Data Warehouse and ETL Testing Course
Testing
Lectures -306
Duration -29 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Data Warehouse / ETL Testing is a testing method in which the data inside a data warehouse is tested for integrity, reliability, accuracy and consistency in order to comply with the company’s data framework. The main purpose of testing is to ensure that the integrated data inside the data warehouse is reliable enough for a company to make decisions on.
The Data Warehouse/ETL testing course videos contain Data warehouse Testing, ETL Testing Scenarios, Data checks and many more complex topics explained in a detailed manner which will be helpful to compete with other Organizations. Usually ETL Testing verifies whether the ETL process is working properly.
ETL Testing is a crucial part of ETL because ETL is typically performed on mission critical data.
23+ hours of on demand videos
Clarifications through community
Right blend of concepts and hands-on
In this course, you will:
The difference between Data and Information
Why do we need Data?
Learn the ins and outs of SQL syntax
What is RDBMS and its History?
Database Objects and Database Design
Learning about the Keys and Constraints
Explaining the Normalization and its types
Understanding the Transactions and its types
How to write SQL queries to Manipulate data
How to write SQL queries to insert, update and delete data into database
Analyze data using Aggregate Functions
Testing
Life Cycle of STLC
Types of Testing
What is ETL?
Data Checks
What is Validation?
Validation Checks
Types of Checks
Who this course is for:
- Beginners who want to learn the complete concepts of ETL from very Beginning
- Database developers and database administrators.
- Students who wish to learn a new skill to develop their career.
- Professionals who wish to learn a new skill to develop their career.
Goals
What will you learn in this course:
Master the Command Line and Dozens of Commands
Become an Independent User of the Linux Operating System
Creating, renaming, moving, and deleting files and directories
Understand the basic and Intermediate concepts of databases and MySQL
Learn how to create database tables using SQL commands
Learn SQL operators to write complex SQL queries
Learn about different SQL functions and constraints including NULL values
Foundational Data warehousing concepts
Learning all the concepts and terminologies related to the Data warehouse , such as the OLTP, OLAP, Dimensions, Facts, Star Schema, Snowflake Schema
Data Warehouse Architecture, Data Mart, Data Warehouse Schema and SCDs
You would also learn the basics of Data Modelling Data design
Gain an in-depth understanding of Data Warehouse WorkFlow and comparison between Database Testing and Data Warehouse Testing
Get to know what is ETL Testing and RDBMS Concepts
Understand different ETL Testing scenarios like Constraint Testing, Source to Target Testing, Metadata check,Data Mismatch Check,Data Completeness Validation
Prerequisites
What are the prerequisites for this course?
Passion and curiosity to learn something new technology
No technical knowledge required
A computer with internet connection
Curriculum
Check out the detailed breakdown of what’s inside the course
Welcome to the Course
1 Lectures
- Welcome 02:15 02:15
Computer Basics
5 Lectures
Operating Systems
2 Lectures
Installation
3 Lectures
Linux
68 Lectures
SQL
89 Lectures
Data Warehouse
29 Lectures
Testing
27 Lectures
Jira
11 Lectures
ETL Testing
28 Lectures
ETL Testing Project-MySQL
18 Lectures
ETL Testing Project-SQL Server
25 Lectures
Instructor Details
Blismos Academy
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now