Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS AWS Certified Developer - Associate
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development ETL

ETL Testing: From Beginner to Expert

ETL Testing: Essential course for all software testing professionals.
Rating: 4.0 out of 54.0 (1,497 ratings)
7,873 students
Created by Sid Inf
Last updated 7/2019
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Understand the concepts of Business Intelligence Data warehousing
  • Get to know what is ETL Testing, QA Lifecycle and RDBMS Concepts
  • Gain an in-depth understanding of Data Warehouse WorkFlow and comparison between Database Testing and Data Warehouse Testing
  • Understand different ETL Testing scenarios like Constraint Testing, Source to Target Testing, Business Rules Testing, Negative Scenarios Testing, Dependency Testing, Error Handling Testing
  • Perform data Checks using SQL and understand the scope of BI Testing

Course content

41 sections • 255 lectures • 18h 55m total length

  • Preview07:20

  • Preview04:50
  • Preview07:15

  • Preview04:21
  • Preview04:25
  • What is Data?
    03:23
  • Why Data Warehouse is implemented?
    04:51
  • What is a Data Warehouse?
    05:43
  • Test your understanding on the Data Warehouse basics
    3 questions

  • What is a Data Mart?
    01:47
  • Fundamental difference between Data Warehouse and Data Mart
    00:36
  • Advantages of a Data Mart
    02:40
  • Characteristics of a Data Mart
    04:00
  • Disadvantages of a Data Mart
    03:13
  • Mistakes and Misconceptions of a Data Mart
    02:15
  • Test your understanding on the Data Mart Concepts
    3 questions

  • Revised: Enterprise Architecture or Centralized Architecture
    04:08
  • Revised: Federated Data Warehouse Architecture
    02:49
  • Multi Tired Architecture
    03:13
  • Components of a Data Warehouse Architecture
    03:57
  • Purpose of a Staging Area in Data Warehouse Architecture - Part 1
    04:43
  • Purpose of a Staging Area in Data Warehouse Architecture - Part 2
    03:35
  • Test your understanding on the Data Warehouse Architecutre
    3 questions

  • What is Data Modeling?
    02:13
  • Why should a Tester know Data Modeling?
    04:03
  • Data Modeling Techniques
    03:53
  • ER Data Model
    03:41
  • Dimensional Model
    04:39
  • Differences between ER Model and Dimensional Model
    05:50

  • Different phases required to build a Dimensional Data Model
    01:01
  • Business Requirements
    02:25
  • CDM - Conceptual Data Model
    02:41
  • LDM - Logical Data Model
    03:07
  • Physical Data Model
    01:24
  • Database
    04:16
  • Test your understanding
    2 questions

  • What is a Dimension Table?
    02:48
  • What is a Fact Table?
    02:05
  • Additive Facts
    01:45
  • Semi Additive Facts
    02:28
  • Non-Additive Facts
    01:30
  • Fact less Facts
    02:29
  • What is a Star Schema?
    05:23
  • What is a Snow Flake Schema?
    03:25
  • Galaxy Schema or Fact Constellation Schema
    02:20
  • Snow Flake Vs Star Schema
    05:27
  • Conformed Dimensions
    06:38
  • Junk Dimensions
    03:06
  • Degenerate Dimensions
    03:35
  • Role Playing Dimensions
    02:26
  • Slowly Changing Dimensions - Intro and Example Creation
    05:30
  • Slowly Changing Dimensions (SCD) Type 1, 2, 3
    12:30
  • Slowly Changing Dimensions - Summary
    03:33
  • Test your understanding on Dimensional Model Objects
    4 questions

  • What is Data Integration?
    06:49
  • What is ETL?
    04:19
  • Data Acquisition
    04:16
  • Data Transformation
    05:42
  • Common Questions and Summary
    02:49
  • Test your understanding on Data Integration and ETL
    3 questions

  • ETL - Explained
    06:41
  • ELT - Explained
    05:57
  • ETL Vs ELT
    02:23

Requirements

  • Basic RDBMS Concepts
  • ETL Fundamentals
  • Data Warehouse Concepts

Description

DW/BI/ETL Testing Training Course is designed for both entry-level and advanced Programmers. The course includes topics related to the foundation of  Data Warehouse with the concepts, Dimensional Modeling and important aspects of Dimensions, Facts and Slowly Changing Dimensions along with the DW/BI/ETL set up,  Database Testing Vs Data Warehouse Testing, Data Warehouse Workflow and Case Study, Data Checks using SQL, Scope of BI testing and as a bonus you will also get the steps to set up the environment with the most popular ETL tool Informatica to perform all the activities on your personal computer to get first hand practical knowledge. 

Who this course is for:

  • BI/ETL Developers
  • Testers who want to get job on ETL Testing, to get more salary and also who want to get job quickly.
  • IT professionals with very basic knowledge on Database concepts
  • Project Managers, Database Professionals, Mainframe Professionals, SQL Developers

Instructor

Sid Inf
Data/ETL Architect
Sid Inf
  • 4.2 Instructor Rating
  • 12,673 Reviews
  • 51,395 Students
  • 17 Courses

Business Intelligence Consultant and Trainer with 14+ years of extensive work experience on various client engagements. Delivered many large data warehousing projects and trained numerous professionals on business intelligence technologies. Extensively worked on all facets of data warehousing including requirement gathering, gap analysis, database design, data integration, data modeling, enterprise reporting, data analytics, data quality, data visualization, OLAP.

Has worked on broad range of business verticals and hold exceptional expertise on  various ETL tools like Informatica Powercenter, SSIS, ODI and IDQ, Data Virtualization, DVO, MDM.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.