Contact us

Data Warehouse/ETL Testing

Language: English

Instructors: Blismos Academy

$34

 

Course Curriculum
Welcome to the Course
Introduction
Computer Basics
What is Computer?
What is Computer? Study Material
History of Computer
History of Computer Study Material
Components of Computer
Components of Computer Study Material
Functionalities of Computer
Functionalities of Computer Study Material
Software Components
Software Components Study Material
Computer Basics Assessment
Operating System
What is Operating System?
Operating System Study Material
Types of OS
Types of OS Study Material
Operating System Assessment
Installation Videos
Oracle_VirtualMachine_Installation
How to install Ubuntu operating system on Virtual box
MySQL Installation in Ubuntu
Linux
Directory commands : PWD, Mkdir, Cd, Rmdir
Directory commands : PWD, Mkdir, Cd, Rmdir Study Material
File Commands : Head, Tail, Sort, Touch, Find, Gedit, Locate
File Commands Head, Tail, Sort, Touch, Find, Gedit, Locate Study Material
Listing Files: LS Theory and Hands-On
Listing Files Ls Study Material
Assessment 1
Copy and Move Commands Theory and Hands-On
Copy and Move Commands Study Material
More Command Theory and Hands-On
More Command Study Material
Cat command Theory and Hands-On
Cat command Study Material
Assessment 2
Regular Expressions with GREP
GREP Hands-on
Regular Expressions with GREP Study Material
Comparison Commands
Diff Theory and Hands-On
Diff Study Material
Cmp Theory and Hands-On
Cmp Study Material
Assessment 3
Linux Commands with Pipes Theory and Hands-On
Linux Commands with Pipes Study Material
Linux Commands - Man Theory and Hands-On
Linux Commands - Man Study Material
Linux - Process Monitoring Theory
Linux Process Monitoring Hands-on
Linux - Process Monitoring Study Material
Assessment 4
Linux File Permissions Part1
Linux File Permissions Part2
Linux File Permissions Part1 Study Material
Linux File Permissions Part2 Study Material
Networking Command Theory and Hands-On
Networking Command Study Material
Admin Commands Theory and Hands-On
Admin Commands Study Material
Linux - Compression Theory and Hands-On
Linux - Compression Study Material
Assessment 5
RDBMS
Data vs information
Data vs Information Study Material
Why do we need Data?
Why do we need Data Study Material
Different ways of storing the Data
Different ways of storing the Data Study Material
Systems to Store Data
Systems to Store Data Study Material
RDBMS
History of RDBMS
History of RDBMS Study Material
What is RDBMS?
What is RDBMS Study Material
What is Database?
What is Database Study Material
RDBMS Assessment
Database Components
Database Components - Hands on (Create database & Table)
Database Components Study Material
Database Components Assessment
Datatypes Theory
Dataypes - Hands On
Datatypes Study Material
Datatypes Assessment
Database objects Introduction
Database objects Introduction Study Material
Index Concepts Theory and Hands on
Index Concepts Study Material
Database Object Sequence
Database Object Sequence Study Material
Database objects Views Theory
Database Objects Views-Hands on
Database Object Views Study Material
Database Objects Assessment
Database Design
Database Design Study Material
ER Diagram Part1
ER Diagram Part1 Study Material
ER Diagram with component part2
ER Diagram with Component Part2 Study Material
ER Diagram Parrt3
ER Diagram Part3 Study Material
Database Design Assessment
Keys
Keys Introduction
Keys Introduction Study Material
SuperKey
Super key Study Material
Candidatekey
Candidate Keys Study Material
PrimaryKey
Primary Key Study Material
Unique-Surrogate-Alternate-CompositeKeys
Unique-Surrogate-Alternate-Composite Keys Study Material
ForeignKey
Foreign Key Study Material
Keys Assessment
Constraints
Data Integrity Introductions
Data Integrity Introductions Study Material
Domain Integrity Check Constraints Theory
Check Constraint Hands-on
Domain Integrity Check Constraints Study Material
Default Constraint
Default Constraint Study Material
Not Null Constraint
Not Null Constraint Study Material
Unique Constraint
Unique Constraint Study Material
Entity Integrity Constraint
Entity Integrity Constraint Hands-on
Entity Integrity Constraint Study Material
Referential Integrity
Referential Integrity Hands-on
Referential Integrity Study Material
Constraints Assessment
Normalization
Introduction - Normalization
Introduction - Normalization Study Material
Need for Normalization with example
Need for Normalization with example Study Material
Dependencies
Dependencies Study Material
Normalization - First Normal Form
Second Normal Form
Third Normal Form
BCNF Normal Form
Normalization - First Normal Form to BCNF Normal Form Study Material
Normalization Assessment
Transactions and ACID Properties
Transactions
Transactions Study Material
Transactions - ACID Properties
Transactions - ACID Properties Study Material
Atomicity
Atomicity Study Material
Consistency
Consistency Study Material
Isolation
Isolation Study Material
Durability
Durability Study Material
Transaction Assessment
SQL
Introduction to SQL
Introduction to SQL Study Material
Types of SQL Commands
Types of SQL Commands Study Material
SQL Introduction Assessment
DDL Commands
Create and Alter Theory and Hands-on
Create and Alter Study Material
Rename Theory and Hands-on
Rename Study Material
Drop and Truncate Theory and Hands-on
Drop and Truncate Study Material
Comment Theory and Hands-on
Comment Study Material
DDL Assessment
DML Commands
DML Commands Theory
DML Commands Hands-on
DML Commands Study Material
DML Assessment
Ways of Inserting Data into Tables Theory
Way of Inserting Data into Tables Hands-on
DCL Commands
DCL Commands Theory
DCL Commands Hands-on
DCL Commands Study Material
DCL Assessment
TCL Commands
TCL Commands Theory
TCL Commands Hands-On
TCL Commands Study Material
TCL Assessment
DQL Commands
DQL Commands Theory
DQL Commands Hands-On
DQL Assessment
DQL Commands Study Material
SQL Statements
SQL Statements Study Material
SQL Statement Assessment
Alias Theory and Hands-on
Alias Study Material
Alias Assessment
Distinct Theory and Hands-on
Distinct Study Material
Distinct Assessment
Operators and its Types
What are Operators?
What are Operators Study Material
Arithmetic Operators Theory
Arithmetic Operators Hands-on
Arithmetic Operators Study Material
Arithmetic Operators Assessment
Comparison Operators
Comparison Operators Study Material
Comparison Operator Assessment
Logical Operators-And & Between
Logical Operators-And & Between Study Material
Logical Operators-In & Not In
Logical Operators-In & Not In Study Material
Logical Operators-Like & OR
Logical Operators-Like & OR Study Material
Logical Operators - Exists & Not Exists
Logical Operators - Exists & Not Exists Study Material
Logical Operators Assessment
Aggregate Functions Theory
Aggregate Functions Hands-On
Aggregate Functions Study Material
Aggregate Assessment
SQL Clauses and Types
SQL Clauses
SQL Clauses Study Material
Where Clause Theory
Where Clause Hands-On
Where Clause Study Material
Where Clause Assessment
Order By Clause Introduction
Order By Clause Introduction Study Material
Order By Clause -Ascending Order Theory and Hands-On
Order by - Ascending Order Study Material
Order By Clause -Descending Order Theory and Hands-On
Order By Clause -Descending Order Study Material
Order By Clause - Ascending & Descending Order Theory and Hands-On
Order By Clause - Ascending & Descending Order Study Material
Order By Clause - Ascending with Null Values Theory and Hands-On
Order By Clause - Ascending with Null Values Study Material
Order By Clause - Descending with Null Values Theory and Hands-On
Order By Clause-Descending with Null Values Study Material
Order By Assessment
Group By Clause Theory
Group By Clause Hands-On Part 1
Group By Clause Hands-On Part 2
Group By Clause Study Material
Group By Assessment
Having Clause Theory
Having Clause Hands-On
Having Clause Assessment
What is Null Value?
What is Null Value? Study Material
Inserting the Null Values Theory
Inserting the Null Values Hands-on
Inserting the Null Values Study Material
Null vs Empty Space Theory
Null vs Empty Space Hands-on
Null vs Empty Space Study Material
How to find Null Values Theory
How to find Null Values Hands-on
How to find Null Values Study Material
Null Values in Arithmetic Expressions -Theory
Null Values in Arithmetic Expressions Hands-on
Null Values in Arithmetic Expressions Study Material
Null Assessment
Sub Query
SubQuery Theory
SubQuery Hands-on
Sub Query Study Material
SubQuery Types Theory Part1
SubQuery Types Hands-On Part1
SubQuery Types Theory Part2
SubQuery Types Hands-On Part2
SubQuery Types Study Material
Sub Queries Assessment
Joins
What are Joins?
What are Joins? Study Material
How Joins Work?
How Joins Work? Study Material
Inner Joins Theory
Inner Joins Hands-On
Inner Joins Study Material
Outer Joins Theory
Outer Joins Hands-on
Outer Joins Study Material
Self Join Theory
Self Joins Hands-on
Self Joins Study Material
Cross Joins Theory
Cross Joins Hands-On
Cross Joins Study Material
Joins Assessment
Set Operators
Set Operator Introduction
Set Operators Introduction Study Material
Union Set Operator Theory
Union Set Operator Hands-On
Union Set Operators Study Material
Union All Set Operators Theory
Union All Set Operators Hands-On
Union All Set Operators Study Material
Intersect Operators Theory and Hands-on
Intersect Operators Study Material
Minus Operator Theory
Minus Operator Hands-On
Minus Operators Study Material
Set Operators Assessment
String Functions
Introduction to String Functions
Introduction to String Functions Study Material
Strings Case Manipulation Theory and Hands-On
Strings Case Manipulation Study Material
Adding and Removing Spaces Part 1
Adding and Removing Spaces Part2
Adding and Removing Spaces Part3
Adding and Removing Spaces Hands-On
Substring Theory Part 1
Substring Theory Part 2
Substring Hands-On
Substring Study Material
Substring Index Theory
Substring Index Hands-On
Substring Index Study Material
Instring & Locate Theory
Instring & Locate Hands-on
Instring & Locate Study Material
Strings Functions Assessment
Data Warehouse
Transactional Processing VS Analytical Processing
What is Data Warehouse?
What is Data Warehouse? Study Material
History of Data Warehouse
History of Datawarehouse Study Material
Data Warehouse Introduction Assessment
OLAP & OLTP
OLTP & OLAP Study Material
OLTP & OLAP Assessment
Introduction to ETL
Introduction to ETL Study Material
Extraction in ETL
Extraction in ETL Study Material
Transformation Introduction
Transformation Introduction Study Material
Types of Transformation
Types of Transformation Study Material
Load Data
Load Data Study Material
DataWarehouse Architecture Introduction
DataWarehouse Architecture Introduction Study Material
Data Warehouse Architectures based on Layers
Data Warehouse Architecture based on Tiers
Data Warehouse Architecture based on Layers and Tiers Study Material
ETL Assessment
What is Data Mart ?
Storing Data in Data Warehouse
Dimension Tables and Fact Tables
Dimension and Fact table with Example
Dimension and Fact Assessment
Introduction to Data Warehouse Schema
Star Schema
Snowflake Schema
Fact Constellation Schema
Slowly Changing Dimension Introduction
SCD Type 0 and SCD Type 1
SCD Type 2
SCD Type 3
SCD Type 4
SCD Type 6
SCD Assessment
ETL Tools
Scheduling Tools
Reporting Tools
Tools Assessment
Testing
What is Quality?
Characteristics of Good Software
What is Software Testing?
Role of Software Testing
Testing Intro Assessment
Introduction to SDLC
SDLC Assessment
Software Development Life Cycle Phases
Software Testing Life Cycle
STLC Phases
Categories of the Requirements
Non Functional Testing
Functional Testing
Test Case
Test Case Assessment
Introduction to Test case Design Techniques
High Level Test Case Design Technique
Low Level Technique Part1
Low level Techniques Part2
Software Testing Phases
Unit Testing
Functional Testing
Integration Testing
System Testing
User Acceptance Testing
Regression Testing
What is Defect
Defect Life Cycle
Defect Parameters
Jira
Introduction to Jira
Key Concepts of Jira
Features of Jira
Different Templates in Jira
How to Register Jira trial account?
Jira Work flow
How to create projects in diff templates?
How to configure Zephyr suad ?
How to write Testcases in Jira ?
How to import & export testcases in Jira ?
How to create a bug ?
ETL Testing
What is Data Warehouse?
What is ETL?
What is ETL Testing?
Business Requirements in Datawarehouse ETL Mapping
ETL Testing with example
DataWarehouse Testing Life Cycle
Major Testing Phases
Metadata Check
19. Meta Data Validation Hands-On
Data Mismatch Check
Data Completeness Validation with Record Count
Record Count Check Hands-On
Data Completeness Validation with Column Data Profiling
Column data Profiling Validation Hands-On
Data Duplication Check
Duplicate Validation Hands-On
Data Accuracy
Data Accuracy Check Hands-On
Data Consistency
Data Consistency Hands-On
Data Transformation Validation
Data Transformation Validation - Example
Data transformation validation Hands-On
ETL Testing Data Validation Scenarios
Data Validation Approach for Scenario1
Data Validation Approach for Scenario 2
Data Validation Approach for Scenario 3
Data Validation Approach for Scenario 4 and 5
ETL Testing Project - MySQL
Introduction to Project
Pre Requisites Project
Hands-On Preparation
Branch Table Testing Approach
Branch Table MetaData Check Hands-On
Branch Table Count Null Duplicate Check
Branch Table Transformation Validation Hands-On
Branch Table Validating columns without Transformation Hands-On
Customer Table Meta Data count duplicate Hands-On
Customer table Transformation validation Hands-On
Customer Table Transformation Hands-On
Accounts Table Meta Data Check Hands-On
Accounts Table Count Null Duplicate Check Hands-On
Accounts Table Transformation Validation Hands-On
Accounts Table Transformation Validation Left pad Hands-On
Payments Table Validation Hands-On
Payments table count null duplicate check Hands-On
Payments Table Transformation validation Hands-On
ETL Testing Project - SQL Server
Introduction to Project
Pre Requisites Project
What is SQL Server ?
Branch Table Preparation Source and Target
Branch Table with User Interface
Loading all the Tables - Preparation
Branch Table Testing Approach
Branch Table - Meta Data Check
Branch Table Count Null Duplicate Hands - On
Branch Table Transformation Validation Hands - On
Branch Tables Columns with Asis Mapping - Hands - On
Customer Table Metadata Check Hands-On
Customer table Hands-On Count Null and Duplicate Check
Customer Table Hands-on Transformation1
Customer Table Hands-On Transformation2
Transformation Validation for Customer table Trans3
Customer Table Validation for columns without transformation
Accounts Table Meta Data Check
Count Null Duplicate Check Hands-on
Accounts Table Transformation1
Accounts Table Transformation2
Accounts Table Transformation3
Accounts Validation for the Non transformed columns
Payments Table Transformation Table1
Payments table validation for non transformed columns

How to Use

After successful purchase, this item would be added to your courses.You can access your courses in the following ways :

  • From the computer, you can access your courses after successful login
  • For other devices, you can access your library using this web app through browser of your device.

Reviews

Launch your GraphyLaunch your Graphy
100K+ creators trust Graphy to teach online
Blismos Academy 2024 Privacy policy Terms of use Contact us Refund policy