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 /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.
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 Components
