DATA WARE HOUSING

Data Warehouse Course Contents SQL
Database Concepts
Types of SQL statement
Normalization and denormalization
Sub queries
Joins and set operators
Database Objects
Constraints

Data Warehouse Concepts
Introduction of Data Warehouse
Need arise of DWH
OLTP V/S DWH
OLTP V/s OLAP

Data Warehouse /Data Marts Architecture
Staging/without Staging
Dimensions (Simple and Confirm)
Fact (Simple, fact less, coverage, confirm)
Warehouse Implementation Methods
STAR SCHEMA
SNOW FLAKE SCHEMA
Difference between STAR and SNOW FLAKE Schema.
Other terminologies Cleansing, Purging etc.

PL/SQL
Introduction to PL/SQL
Advantages of PL/SQL
Procedures, Functions, Triggers, Packages

Database Modeling Tool (Erwin)
Introduction of Erwin
Designing Methods
Logical Designing
Physical Designing
Introduction of ER-Modeling
Introduction of Dimension Modeling
Difference between ER-Modeling and Dimension Modeling
Implementation of ER-Model
Implementation of Dimension Model
Forward Engineering and Reverse Engineering
Introduction of various Database Component