Data Warehouse / ETL Testing
Data Warehouse / ETL Testing, available at $54.99, has an average rating of 4.55, with 247 lectures, based on 30 reviews, and has 226 subscribers.
You will learn about 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 This course is ideal for individuals who are Beginners who want to learn the complete concepts of ETL from very Beginning or Database developers and database administrators. or Students who wish to learn a new skill to develop their career. or Professionals who wish to learn a new skill to develop their career. It is particularly useful for Beginners who want to learn the complete concepts of ETL from very Beginning or Database developers and database administrators. or Students who wish to learn a new skill to develop their career. or Professionals who wish to learn a new skill to develop their career.
Enroll now: Data Warehouse / ETL Testing
Summary
Title: Data Warehouse / ETL Testing
Price: $54.99
Average Rating: 4.55
Number of Lectures: 247
Number of Published Lectures: 247
Number of Curriculum Items: 247
Number of Published Curriculum Objects: 247
Original Price: ₹2,699
Quality Status: approved
Status: Live
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
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.
Target Audiences
- 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.
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
Course Curriculum
Chapter 1: Introduction
Lecture 1: Introduction
Lecture 2: History of Computer
Lecture 3: Components of Computer
Lecture 4: Functionalities of Computer
Lecture 5: Software Components
Chapter 2: Operating System
Lecture 1: What is Operating System
Lecture 2: Types of Operating System
Chapter 3: Linux and its Conmmand
Lecture 1: Directory Commands
Lecture 2: File Commands
Lecture 3: Listing Files
Lecture 4: Copy and Move Commands
Lecture 5: More Command
Lecture 6: Cat Command
Lecture 7: Regular Expression with GREP
Lecture 8: GREP Hands-On
Lecture 9: Diff Command Theory and Hands-On
Lecture 10: Cmp Command Theory and Hands-On
Lecture 11: Pipes Line Command Theory and Hands-On
Lecture 12: Man Command Theory and Hands-On
Lecture 13: Process Monitoring Command Theory
Lecture 14: Process Monitoring Hands-On
Lecture 15: File Permission Part 1
Lecture 16: File Permission Part 2
Lecture 17: Networking Command Theory and Hands-On
Lecture 18: Admin Command Theory and Hands-On
Lecture 19: Compression Command Theory and Hands-On
Chapter 4: RDBMS
Lecture 1: Data vs Information
Lecture 2: Why do we need Data?
Lecture 3: Different ways of storing the Data
Lecture 4: Systems to store Data
Lecture 5: History of RDBMS
Lecture 6: What is RDBMS?
Lecture 7: What is Database?
Lecture 8: Database Components
Lecture 9: Database Components Hands-On
Lecture 10: Datatypes Theory
Lecture 11: Datatypes Hands-On
Lecture 12: Database Objects Introduction
Lecture 13: Database Object – Index
Lecture 14: Database Object – Sequence
Lecture 15: Database Object – View
Lecture 16: Database Object – View Hands-On
Lecture 17: Database Design
Lecture 18: ER Diagram Part 1
Lecture 19: ER Diagram Part 2
Lecture 20: ER Diagram Part 3
Lecture 21: Keys Introduction
Lecture 22: Super Key
Lecture 23: Candidate Key
Lecture 24: Primary Key
Lecture 25: Unique Key – Surrogate Key – Alternate Key – Composite Key
Lecture 26: Foreign Key
Lecture 27: Data Integrity Introduction
Lecture 28: Domain Integrity Check Constraint Theory
Lecture 29: Check Constraint Hands-On
Lecture 30: Default Constraint
Lecture 31: Not Null Constraint
Lecture 32: Unique Constraint
Lecture 33: Entity Integrity Constraint
Lecture 34: Entity Integrity Constraint Hands-On
Lecture 35: Referential Integrity
Lecture 36: Referential Integrity Hands-On
Lecture 37: Normalization Introduction
Lecture 38: Need for Normalization with Example
Lecture 39: Dependencies
Lecture 40: First Normal Form
Lecture 41: Second Normal Form
Lecture 42: Third Normal Form
Lecture 43: BCNF Normal Form
Lecture 44: What is Transactions?
Lecture 45: Transactions – ACID Properties
Lecture 46: What is Atomicity?
Lecture 47: What is Consistency?
Lecture 48: What is Isolation?
Lecture 49: What is Durability?
Chapter 5: Structured Query Language
Lecture 1: Introduction to SQL
Lecture 2: Types of SQL Commands
Lecture 3: DDL Commands – Create & Alter
Lecture 4: DDL Commands – Rename
Lecture 5: DDL Commands – Drop & Truncate
Lecture 6: DDL Commands – Comment
Lecture 7: DML Commands
Lecture 8: DML Commands Hands-On
Lecture 9: Ways of Inserting Data
Lecture 10: Ways of Inserting Data – Hands-On
Lecture 11: DCL Commands
Lecture 12: DCL Commands – Hands-On
Lecture 13: TCL Commands
Lecture 14: TCL Commands – Hands-On
Lecture 15: DQL Commands
Lecture 16: DQL Commands Hands-On
Lecture 17: SQL Statements
Lecture 18: Alias Theory and Hands-On
Lecture 19: Distinct Theory and Hands-On
Lecture 20: What are Operators?
Instructors
-
Blismos Academy
Practitioners of Big Data Engineering
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 0 votes
- 3 stars: 2 votes
- 4 stars: 17 votes
- 5 stars: 11 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024