Here the complex process of DWH/ETL testing is presented in its simplest form, which assumes no previous data warehousing experience/exposure. This will guide you through to the entire process of data warehousing and some of the BI stuff as well. So get trained in Data Warehousing and explore the wide career opportunities in the field.

Topics Covered

Data Warehousing Concepts • What is Data Warehousing and necessity of it • Difference between Data Warehouse and Database • Data Warehousing architecture • OLAP & OLTP • Data Mining and Data marts Data Warehouse Design • Dimensional Modelling • Fact & Dimension tables • Star Schema • Snowflake Schema ETL Testing • What is ETL and importance of ETL Testing? • Concepts of Data Extraction • Concepts of Data Transformation • Concepts of Data Loading • Change Data Capture and SCDs • Testing Scenarios, creation of test cases and scripts ETL Testing Validations • Different validations performed in ETL Testing SQL Queries o Joins o Referential Integrity Checks o SET operators o Aggregation etc. Subject Area Model Basics of Report Testing • Validation of the report data with DB and UI testing Basics Of Informatica & UNIX

Who should attend

Anyone who is keen to learn Data warehousing and pursue a career in the field.

Pre-requisites

The person should have basic SQL knowledge.

What you need to bring

Laptop, which is not mandatory. But having one is added advantage.""

Key Takeaways

At the end of the course, you'll be able to: - Figure out what data warehousing is and how ETL testing is being carried out. - Test DWH with ease - Tackle real life challenges in DWH testing