MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

ETL Testing Training

Course Summary

Intellipaat ETL testing training course lets you master ETL testing. We provide the best online classes to help you learn data warehousing, OLAP, OLTP, deploying SQL for checking data, basis for business intelligence. Work on real life industry projects.


  • +

    Course Syllabus

    ETL Testing Course Content

    ETL Testing Overview
    Introduction to ETL testing, life cycle of ETL Testing, database concepts, ETL in Business Intelligence, understanding the difference between OLTP and OLAP, data warehousing.Hands-on Exercise – Create OLTP and OLAP database
    Database Testing and Data Warehousing Testing
    Introduction to RDBMS, Relational database concepts, distinction between database and data warehousing testing, integrity constraints.Hands-on Exercise – how to test data warehousing testing, integrity constraints
    ETL Testing Scenarios
    The data warehouse workflow, ETL Testing scenarios, ETL Mapping, Data Warehouse Testing, Data Mismatch & Data Loss Testing.Hands-on Exercise – Create a data warehouse workflow, Create ETL Mapping
    Correctness, Completeness, Quality, Data Validation
    Introduction to various testing scenarios, structure validation, constraint validation, data correctness, completeness, quality, data validation, negative testing.Hands-on Exercise – Create tests as per testing scenarios, Validate structure of the software, Do constraint validation, Check data correctness and completeness, Validate data, Perform negative testing
    Data Checks with SQL
    Using SQL for checking data, understanding database structure, working with SQL ScriptsHands-on Exercise – Write SQL Scripts for checking data
    Reports & Cube testing
    Reports and Cube Testing, scope of Business Intelligence Testing.Hands-on Exercise – Identify ETL testing Scope-Generate Reports, Test Cubes
    ETL Testing Project
    Project – Testing CubeData – SalesThis ETL testing project will provide you with hands-on experience in testing of a multidimensional cube of sales data that includes sales for five years for multiple products. Some of the steps you will be performing in the testing of the cube are validating the dimensions and connections, selecting and matching the data, verifying the dimension hierarchies, validating measures in association with dimension attributes, matching with external interface specification file data and so on.


Course Fee:
USD 172

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top