Data Warehouse / ETL Testing

ETL Testing

Ratings 4.36 / 5.00
Data Warehouse / ETL Testing

What You Will Learn!

  • 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

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 Should Attend!

  • 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.

TAKE THIS COURSE

Tags

  • ETL

Subscribers

159

Lectures

247

TAKE THIS COURSE



Related Courses