Loaded data from flat data files into SQL Server
database tables using bcp, bulk insert, and table import; Created ETL packages using SQL Server SSIS Designer to extract data from flat file and excel files
Created database tables with various data types, constrains (primary key, foreign key, unique, check, default, etc.) and indexes (clustered index and non-clustered index) in Oracle database.
Extracted data from SQL
Server database tables into flat data files and Excel sheets using table export and BCP for easy data migration
Created SAS views from
Oracle database tables using SAS / Access and writing SAS programs using Base SAS and SAS / Macros to create reports.
* Proficient in SQL Server and T - SQL (DDL and DML) in constructing Tables, Normalization techniques
on database Tables and sub-queries including commands, Join, Views, Stored Procedures and Triggers.
Created UNIX shell scripts and external tables to upload data into
database tables for processing.
Core Coding and unit testing using the old Oracle database and running batch jobs for loading
database tables from Flat Files using SQL * Loader.
This guide includes some pretty geeky details as is geared toward experienced eLearning programmers who aren't intimidated
by database tables and light PHP coding.
We have faced some technical challenges (
wrt database tables & connectivity) during 6th to 9th of this month.
Designed and developed SSIS packages (Incremental and Bulk) for Extracting, Transforming and Loading Monster's Site data and Siebel CRM data which includes sources
like database tables, spreadsheets and files from FTP.
Loaded data from flat data files into SQL Server 2008
database tables using bcp, bulk insert, and table export / import, SSIS package
Performed analysis of Mapping Documents and «Schema Compare»
with Database tables, logged the defects and worked with the Database Modeling Team to resolve them.
«You might want to write a library that has inside of it as private state
the database table that records usernames and passwords,» Chlipala says.
My approach uses a combination of Javascript, PHP and Articulate Storyline and requires that you have the tools and knowledge to create
a database table or you have access to someone who can create the database for you.
Extracted data from SQL Server
database tables and Oracle database tables into flat data files and Excel sheet.
Loaded data from flat data files into SQL Server 2008
database tables using bulk insert, and table import wizard methods.
Analyzed application performance and optimized
the database tables, indexes, and stored procedures.
Create indexes on
the database tables and generate trace event to improve the query performance and optimize data access
In scope of grey box testing verified application data stored within
a database table using SQL queries
Used the Microsoft SQL Server 2000 client tools to create
database tables.