Course Content
Understanding Data Base Concepts and Online Transaction Processing(OLTP)
- Introduction OLTP-Databases Modelling Concepts.
- ERD - Entity Relationship Diagrams
- Logical and Physical Schema for Database Design
- Database Constraints - Primary , Foreign Key , Unique Keys,Surrogate Keys
- Advanced SQL Statements
- Views and Materialized Views
- Meta Data and Operational Data
- Hands on Excises
Understanding Data Warehouse Concepts(OLAP)
- Need/Business Drivers Data warehouse
- Data Warehouse - Characteristics
- Data Modelling - Fact , Dimensions, Star , Snowflake Schemas
- Design and Building - Fact and Dimensional Modelling - A CASE STUDY
Understanding Extract, Transform and Load(ETL)
- Introduction to ETL and its Components
- Landing Zone
- Data Profiling
- Data Quality / Reconciliation
- Transformation Rules
- Staging Databases
- Loading to Reporting/Final Data Warehousing
- A CASE STUDY
Introduction to Test Case ,Test Design - Different Type of Testing
- Understanding of Data Transformation, Mapping and Business Rules
- Understanding of Data Centric Testing
- Test Case and Test Design Methodology
- Categorization of Testing based on objectives of testing and reporting
- Database testing and data Warehouse Testing - A comparision
- Testing Approach, planning and Strategy
Case Study and Hands On
- Test case design based on mapping and business rulesdocument
- Test Execution
- Test Reporting
- Summary and Learing
ETL TOOLS
- Introduction to ETL TOOLS
- A Sample Case Study for AN ENTERPRISE DATAWARE HOUSE PROCESS