Description:
Learn how to automate web applications using Selenium, a popular open-source framework for testing. This course will
cover the fundamentals of Selenium automation testing, including setting up the test environment,
writing test scripts, executing tests, and generating comprehensive test reports.
Key Highlights:
- Master Selenium automation testing techniques
- Learn to write efficient and maintainable test scripts
- Execute tests on multiple browsers and platforms
- Generate comprehensive test reports for analysis and tracking
What you will learn:
- Master Selenium Automation
Gain a solid understanding of Selenium and its key concepts
- Efficient Test Scripting
Learn best practices for writing efficient and maintainable test scripts
- Cross-Browser Testing
Execute tests on various popular browsers to ensure compatibility
- Test Reporting and Analysis
Generate comprehensive test reports for tracking and analysis purposes
Introduction to ETL and Datawarehouse Testing [90 Minutes]
Overview of ETL (Extract, Transform, Load) process |
Understanding the importance of datawarehouse testing |
Key concepts and terminology in ETL and datawarehouse testing |
Assignment#1 |
Data Layer in ETL [90 Minutes]
Source |
Source |
Pre Staging |
Staging |
ODS |
Target |
Assignment#2 |
Load Types [90 Minutes]
Historical Load |
Historical Load |
Initial Load |
Delta Load |
Incremental Load |
Full Load |
Truncate & Load |
Assignment#3 |
ETL Architecture [90 Minutes]
Understanding ETL Architecture |
Mapping Documents |
Lookup Rules |
Transformation Rules |
Direct Map/Direct Load/Direct Move |
Assignment#4 |
Test Document Preparation [180 Minutes]
Prepare "Architecture" Document |
Prepare "Mapping" Document |
Prepare "Test Plan" |
Prepare "Test Data" |
Prepare ETL Test Cases |
Assignment#5 |
Designing Test Cases for ETL and Datawarehouse Testing [120 Minutes]
Understanding source data and data mapping |
Identifying test scenarios and data validation |
Creating test cases for ETL process |
Designing test cases for datawarehouse testing |
Assignment#6 |
All Validations in ETL Testing [270 Minutes]
Metadata Testing |
Count Check |
Maping Validation |
Data Completeness Check |
Data Integrity Check |
Direct Move - Columns Check |
Transformation Rule - Validation |
Lookup Rule - Validation |
Calculated Filed Validation |
Null Check |
Duplicate Check |
Process Flow Validation |
Dependency Validation |
Table to Table Validation |
Flat File to Table Validation |
Assignment#7 |
Testing Techniques for ETL and Datawarehouse Testing [90 Minutes]
Data profiling and data quality testing |
Incremental and full load testing |
Dependency and constraint testing |
Performance and scalability testing |
Error handling and exception testing |
Assignment#8 |
ETL and Datawarehouse Test Execution and Reporting [90 Minutes]
Setting up test environments and test data |
Executing test cases for ETL process |
Performing data validation in datawarehouse |
Tracking defects and issue resolution |
Generating test reports and documentation |
Assignment#9 |
Datawarehouse Process - 1 [90 Minutes]
Dimension Tables |
Fact Tables |
Schemas |
Assignment#10 |
Datawarehouse Process - 2 [90 Minutes]
Understanding of SCD |
SCD Types |
SCD Type -2 |
SCD Type -3 |
SCD Type -4 |
SCD Type -5 |
SCD Type -6 |
SCD Type -7 |
Assignment#11 |
Datawarehouse Process - 3 [90 Minutes]
Understanding of FACT |
Addictive FACTs |
Semi-Addictive FACT |
Non-Addictive FACT |
Factless FACT |
Assignment#12 |
Datawarehouse Process - 4 [90 Minutes]
Star Schema |
Snowflake Schema |
Galaxy Schema |
Assignment#13 |
Data Mart, Data Lake, Cubes, Reports [90 Minutes]
Data Mart |
DataLake |
Cubes |
Reports |
Practice on Project [240 Minutes]
End to End ETL Testing Practice |
Datawarehouse Testing Practice |
Working on Case Study [90 Minutes]
Case Study - 1 |
Case Study - 2 |
Case Study - 3 |
Interview Preparation [180 Minutes]
End to End ETL Testing Practice |
Interview Practice with 120 Questions |
After successful purchase, this item would be added to your Library.
You can access the library in the following ways :
- From Computer, you can access your library after successful login
- For other devices, you can access your library using this web app through browser of your device.
Review
me
star
star
star
star
star