Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Complete ETL Testing Course
Before we start
What is Data Testing/ETL Testing and the Challenges in ETL testing? (4:50)
What will be the future of ETL tools/testing as big data is getting popular? (7:15)
The Basics - Data warehouse Concepts course
Is DWH still relevant in the age of Big Data? (4:25)
What is Data? (3:23)
Why Data Warehouse is Implemented? (4:51)
What is a Data Warehouse? (5:48)
Quiz: Test your understanding on the Data Warehouse Concepts
Data Mart
What is a Data Mart? (1:47)
Fundamental Difference between DWH and DM (0:36)
Mistakes and MisConceptions of a Data Mart (2:15)
Quiz: Test your understanding on Data Marts
Data Warehouse Architectures
Enterprise Architecture or Centralized Architecture (4:08)
Federated Data Warehouse Architecture (2:49)
Muitli Tired DWH Architectures (3:13)
Components of Data Warehouse Architecture (3:57)
Purpose of a Staging Area in Data Warehouse Architecture - Part 1 (4:43)
Purpose of a Staging Area in Data Warehouse Architecture - Part 2 (3:35)
Quiz: Test your understanding on the Data Warehouse Architectures
Dimensional Modeling
What is Data Modeling? (2:13)
Why should a tester know Data Modeling (4:03)
What are Data Modelling Techniques? (3:53)
What is an ER Data Model? (3:41)
What is Dimensional Modeling? (4:39)
What is the differences between ER and Dimensional Modeling? (6:02)
How to build a Dimensional Model?
What are the different phases required to build a Dimensional Data Model? (1:01)
How to gather Business Requirements for a Data Model? (2:25)
What is CDM - Conceptual Data Model? (2:41)
What is LDM - Logical Data Model? (3:07)
What is PDM - Physical Data Model? (1:24)
How the Database is playing the role in Dimensional Model? (4:16)
Various Objects in Dimensional Model
What is a Dimension table? (2:48)
What is a Fact table? (2:05)
What are Additive facts? (1:45)
What are Semi Additive facts? (2:28)
What are Non Additive facts? (1:30)
What are Fact Less facts? (2:29)
What are Surrogate Keys? (4:01)
What is a Star Schema? (5:23)
What is a SnowFlake Schema? (3:25)
What is a Galaxy Schema or Fact Constellation Schema? (2:20)
What is the difference between Star and SnowFlake? (5:27)
What are conformed dimensions? (6:38)
What are junk dimensions? (3:06)
What are degenerate dimensions? (3:35)
What are slowly changing dimensions? (25:44)
What are slowly changing dimensions type 1,2 and 3? (12:30)
Slowly Changing Dimensions - Summary (3:33)
Quiz: Test your understanding on Dimensional Model Objects
Data Integration and ETL
What is Data Integration? (6:49)
What is ETL? (4:19)
What is Data Acquisition? (4:16)
What is Data Transformation? (5:42)
What are some of the common questions on Data Integration and ETL? (2:49)
ETL Vs ELT
What is ETL? (6:41)
What is ELT? (5:57)
What is the difference between ETL Vs ELT? (2:23)
Typical Roles in a Data Warehouse Project
What is the role of a Project Sponsor in a DW/BI/ETL project? (3:24)
What is the role of a Project Manager in a DW/BI/ETL project? (1:46)
What is the role of a Functional Analyst or Business Analyst in DW/BI/ETL projects? (2:53)
Who is an SME - Subject Matter Expert? (4:17)
What does an Architect do in a DW/BI/ETL project? (3:07)
What is the role of a DWH Tech Admin? (1:20)
What does the Data Modeler's do? (8:59)
What is the importance of the ETL Developers? (1:56)
What is the role of BI OLAP Developers? (1:29)
What is the role of ETL Testers or the QA analysts? (1:58)
What is the role of the DB, UNIX and Network administrators in a DW/BI/ETL project? (0:56)
What is the difference between Data Architect, Data Warehouse Architect, BI Architect and Solution Architect? (9:57)
Final Note about the Roles (2:16)
Quiz: Test your understanding on different roles in the DW/BI/ETL projects
DW/BI/ETL Implementation Approach
What are the different implementation approaches in DW/BI/ETL projects? (1:51)
How does the Knowledge Capture Sessions help? (3:34)
How are requirements gathered? (7:21)
What is the Architecture phase? (4:48)
How should the databases be considered in the implementation approach? (1:35)
What is done in the ETL phase? (2:43)
How is the data accessed by various stakeholders? (2:10)
Data Access Types - Selection (1:37)
Data Access Types - Drilling Down (0:58)
Data Access Types - Exception Reporting (0:36)
Data Access Types - Calculations (1:26)
Data Access Types - Graphics and Visualization (0:58)
Data Access Types -Data Entry Options (2:04)
Data Access Types - Customization (1:00)
Data Access Types - WebBased Reporting (0:56)
Data Access Types - BroadCasting (1:05)
What happens in the deployment phase? (1:42)
How the iterative approach is beneficial? (3:25)
Quiz: Test your understanding on the DW/BI/ETL iterative approach
DW/BI/ETL Test Stratergy and Data Centric Approach
Introduction and Knowledge Capture Sessions (1:09)
Test Stratergy and Plan (2:48)
Define Test Framework (2:25)
Assessing different Source and Target Data (4:12)
Test ETL - The Data Centric Method (3:12)
SIT - ​System Integration Testing (5:34)
Regression Testing (3:57)
Performance Testing (4:33)
Acceptance Testing (3:45)
Different Categories Of Projects where DW/BI/ETL Testing is required
Introduction to different categories of DW/BI/ETL (4:01)
New DataWarehouse SetUp (2:26)
Migration Testing (1:52)
Change Requests - For Existing Projects (1:28)
OLAP/Dashboard/Report Testing (0:54)
Roles and Responsibilities of an ETL Testing Professional
Knowledge of the project or the application (3:50)
Analysis of the specifications provided by the clients (2:45)
Approve requirements and design specifications (1:18)
Create and Maintain the test stratergy document (1:13)
Design the Test Cases as per the Test plan (1:16)
Estimate the efforts required to design the test cases and excute the project (1:23)
Tracability of requirements to test cases (1:10)
Define Exit and Entrace criteria (0:53)
Creating Test Plan, Test Scenario, Test Cases & Test Scripts (1:50)
Test Data Creation (4:31)
Creating and Maintaining Reusable Scripts and Execute Test Scripts (1:20)
Execute backend data-driven test cases (1:47)
Client Co-ordination and Incorporate UAT Test cases and Identify Bugs (1:44)
Other Roles and Responsibilities (3:41)
Database Testing
What are the variances between GUI and DB Testing? (7:36)
Different Types of Database Testing - Structural Testing (16:46)
Different Types of Database Testing - Functional Testing (10:50)
Different Types of Database Testing - Functional Testing - Part 2 (7:17)
Different Types of Database Testing - Non Functional Testing (5:05)
Different Types of Database Testing - Summary (1:14)
Defect Management
What are bug reports? (1:41)
What should be done after finding the bug/defect? (2:49)
What to write in the bug summary? (1:25)
What is the importance of using appropriate language/phrases in the bug summary? (3:01)
What are the steps to reproduce the defects? (2:11)
Do we need to include the test data in the defect or bug summary? (0:39)
Do we need to include screenshots in the defect/bug summary? (1:33)
What is severity and priority? (0:58)
What is the importance of logs in defect/bug report? (0:28)
Additional Information (3:08)
Possible Reasons for Defects & Bugs
What are the common causes for defects or bugs? (0:59)
Insufficient/Incorrect Requirements (3:30)
Assumptions and Misunderstanding (1:58)
Wrong decisions during the design (2:12)
Good programmers with wrong goals (2:11)
Various complexities (5:04)
Time Constraints (4:19)
Frequently Changing Business Requirements (2:13)
Issues/Defect Management Process
Discrepancy Reporting (6:51)
Communicating the Discrepancy (2:35)
Escalation (1:33)
Generating Metrics (1:46)
Issue Severity Table
Critical Issue Severity (2:44)
High severity issues (1:26)
Medium severity issues (0:43)
Low severity issues (1:00)
How should the databases be considered in the implementation approach?
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock