Basic of SQL
What is Data warehouse?
Need of Data warehouse?
Introduction to OLTP, ETL and OLAP Systems
Data warehouse Architecture
Data Marts
ODS ( Operational Data Store )
Dimensional modeling
Star schema, snowflake schema
What are Fact and Dimensional tables?
and fact constellations schema
Normalization and De-Normalization
Several real time business Scenarios
Types of SCD’s
Types of ETL Testing
Data Completeness, Data Transformations, Data Quality, Performance and Scalability, Integration testing
Different types of SDLC
Waterfall Model, V-Shaped Model, Iterative Model Incremental Spiral Model, Big Bang Model, Agile Model
Agile Model
Extreme Programming, Kanban, Lean Development, Scrum, Crystal, FDD.