ETL Testing Training online course can be subscribed for either a year of live tutorials or previously recorded videos. The registration allows access to more than 25 hours of videos, forums and discussion platforms associated with ETL.

ETL is the process of extracting data from its original source transforming it and loading it onto a data warehouse. The curriculum deals with the understanding of retrieving data from SQL. Methods and measures for sorting and retrieving data. The understanding of single row and multiple row functions. Listing and functions of data type conversion, explicit and implicit.

Trainer : Mahesh

Karthik Kosireddi (Personal Profile) : Software professional with experience in many reputed companies both as techie and admin. A trainer, enjoying the reputation of creating hundreds of software testing experts around the world.

ETL Testing Course Content

Below is the list of topics that have been covered extensively in the video pages listed above.

  • Chapter 1 : Retrieving Data using the SQL SELECT Statement
  • Capabilities of the SELECT statement
    Arithmetic expressions and NULL values in the SELECT statement
    Column aliases
    Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
    Use of the DESCRIBE command

  • Chapter 2 : Restricting and Sorting Data
  • Limiting the Rows
    Rules of precedence for operators in an expression

  • Chapter 3 : Using Single-Row Functions to Customize Output
  • Describe the differences between single row and multiple row functions
    Manipulate strings with character function in the SELECT and WHERE clauses
    Manipulate numbers with the ROUND, TRUNC and MOD functions
    Perform arithmetic with date data
    Manipulate dates with the date functions

  • Chapter 4 : Using Conversion Functions and Conditional Expressions
  • Describe implicit and explicit data type conversion
    Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
    Nest multiple functions
    Apply the NVL, NULLIF, and COALESCE functions to data
    Use conditional IF THEN ELSE logic in a SELECT statement

  • Chapter 5 :Reporting Aggregated Data Using the Group Functions
  • Group Functions
    Creating Groups of Data
    Restricting Group Results

  • Chapter 6 :Displaying Data from Multiple Tables Using Joins
  • Introduction to JOINS
    Types of Joins

  • Chapter 7 : Using Sub queries to Solve Queries
  • Introduction to Sub queries
    Single Row Sub queries
    Multiple Row Sub queries

  • Chapter 8 : Using the SET Operators
  • Set Operators
    UNION and UNION ALL operator
    INTERSECT operator
    MINUS operator
    Matching the SELECT statements
    Using ORDER BY clause in set operations

  • Chapter 9 : Managing Tables using DML statements
  • Data Manipulation Language
    Database Transactions

  • Chapter 10 : Introduction to Data Definition Language
  • Data Definition Language

  • Chapter 11 : Introduction to Data Dictionary Views
  • Introduction to Data Dictionary
    Describe the Data Dictionary Structure
    Using the Data Dictionary Views
    Querying the Data Dictionary Views

  • Chapter 12 : Creating Sequences, Synonyms, Indexes
  • Overview of sequences
    Overview of synonyms
    Overview of indexes

  • Chapter 13 : Creating Views
  • Overview of views

  • Chapter 14 : Retrieving Data by Using Sub queries
  • Retrieving Data by Using a Subquery as Source
    Working with Multiple-Column subqueries
    Using Scalar sub-queries in SQL
    Correlated Sub-queries
    Working with the WITH clause
    Analytical Functions

  • Chapter 15 : DATAWAREHOUSE BASICS
  • What is Datawarehouse?
    What is Business Intelligence?
    Online Transaction Processing System (OLTP)
    OLTP Vs Datawarehouse (OLAP)
    Architecture of Datawarehouse
    Data mart
    Top Down (Immon) Vs Bottom Up (Kimball)
    ROLAP, MOLAP and HOLAP

  • Chapter 16 : DATA MODELING
  • What is data Model?
    E-R Modeling
    Dimensional Modeling
    Dimension table
    Fact Table
    SURROGATE KEY
    SCD Type 1
    SCD Type 2
    SCD Type 3
    Types Measures or Facts or Metrics
    What is Schema?
    STAR Schema
    SNOWFLAKE SCHEMA
    Confirmed Dimension
    Junk Dimension
    Degenerated Dimension
    Types of Fact Tables
    Fact less fact

  • Chapter 17 : ETL Testing
  • Introduction
    What is ETL Testing?
    Responsibilities of a ETL Tester

  • Chapter 18 : ETL Testing Methodologies
  • Smoke Testing
    Functional Testing
    System Testing
    Regression Testing
    Performance Testing
    ETL Testing Work Flow Process
    How to Prepare the ETL Test Plan
    How to design the Test cases in ETL Testing.
    How to reporting the Bugs in ETL Testing?
    ETL Testing Responsibilities.
    How to detect the bugs through database queries

  • Chapter 19 : ETL Testing with Informatica PowerCenter
  • SAMPLE Loading from source to target
    Testing Heterogeneous Sources
    SORTER Transformation
    FILTER Transformation
    ROUTER Transformation
    EXPRESSION Transformation
    JOINER Transformation
    UNION Transformation
    AGGREAGATOR Transformation
    RANK Transformation
    SEQUENCE GENERATOR Transformation
    Flat File
    Look up Transformation
    SCD type 1
    SCD type 2
    SCD type 3
    Update Strategy
    XML Source Qualifier
    Types of load (Full, incremental, Refresh)

  • Chapter 20 : ETL Testing with SSIS
  • Packages
    Cubes

  • Chapter 21 : ETL Testing with DataStage

No videos cannot be downloaded. Videos can only be be streamed online using your secure Member login.

We only provide online trainings as my participants are spread across the world. I do not have any classroom trainings.

Please visit our webpage – https://www.itelearn.com/pricing-option for pricing details

Go to https://www.itelearn.com/wp-login.php There is a member login on the home page. Please login with your credentials.

  • Member Testimonials

    Sangeetha S

    This is Fantastic Video...It is much appreciated and will be very helpful if you could please email the PDF format to sangeethasami@gmail.com
    2017-06-30T12:26:03+00:00
    This is Fantastic Video...It is much appreciated and will be very helpful if you could please email the PDF format to sangeethasami@gmail.com

    Pramod Yadav

    Amazing work man :). Was truly inspired by your presentation and way of explanation. Thanks for sharing. Any possibilities to get personal training from you... Read More
    2017-06-30T12:13:17+00:00
    Amazing work man :). Was truly inspired by your presentation and way of explanation. Thanks for sharing. Any possibilities to get personal training from you on QTP?

    Roopa Patil

    This is Roopa Patil here. I had purchased QTP and Selenium videos from you in the month of Aug and Sep 2012. I had 7... Read More
    2017-06-27T11:52:39+00:00
    This is Roopa Patil here. I had purchased QTP and Selenium videos from you in the month of Aug and Sep 2012. I had 7 years of gap after my engineering, still with your video's I got job in GE health care as SDET. I would like to thank you for this and I am very grateful to you.

    Tejshree Surapaneni

    It was really a very good exposure. I got a lot of hands on on the subject...In future I would refer itelearn to my friends... Read More
    2017-08-07T06:43:24+00:00
    It was really a very good exposure. I got a lot of hands on on the subject...In future I would refer itelearn to my friends and family who would love to be World best tester.

    Nizam Ahmed

    It was my great pleasure to view some video lecture which I got from you. It is really nice. I like your way of teaching.....ime... Read More
    2017-06-30T11:58:45+00:00
    It was my great pleasure to view some video lecture which I got from you. It is really nice. I like your way of teaching.....ime to time looking at your video references I am getting benefited. Thanks and looking forward to see more video lectures from you in the near future
  •  

Leave a Reply

Your email address will not be published. Required fields are marked *