Courses Offered

Date Warehousing

- Course Detail

Review concepts relational databases

Normalization, 1st. 2nd. And 3rd.
normal form Star schema design and Snowflake schema design
Data Aggregation concepts

Database and ETL

Oracle sql*loader
PL/SQL
Extract, Transform, Load procedures
Table partitioning concepts
Data warehouse performance tuning

UNIX Overview and Shell scripts

Basic UNIX commands
Korn Shell
Automating ETL scripts

Data Warehouse Project

Real life Equity portfolio data warehouse
Designing Portfolio data warehouse
Feeds from external vendors
Creating Load procedures
Automating load procedures Aggregate table creation

Find This Course at your location