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

    KHURRUM KAISER

    Hi Karthik, Kindly please let me know, when is your next session starts, i want to take mobile testing course with you..Thank you..Please provide me... Read More
    2017-06-30T12:30:26+00:00
    Hi Karthik, Kindly please let me know, when is your next session starts, i want to take mobile testing course with you..Thank you..Please provide me your email address, so i can provide you my contact information or you can email me at rohankaiser@gmail.com..Thanks.­.

    pannaty surender kumar

    It instilled me confidence to learn computer education though I do not possess basics in computer
    2017-06-30T12:09:48+00:00
    It instilled me confidence to learn computer education though I do not possess basics in computer

    sumangali nelakanti

    The recorded Selenium videos are really good. I work at American Airlines and my team manager excepts me to do current project using selenium. After... Read More
    2017-06-30T11:59:55+00:00
    The recorded Selenium videos are really good. I work at American Airlines and my team manager excepts me to do current project using selenium. After hearing and practicing your WebDriver videos I was able to do few test cases and demo it to my team. My manager was very impressed and appreciated me a lot. More Over, not only Selenium videos, the Core java videos are very helpful to understand the WebDriver. Thank you very much for sending me the videos and I am still listening and learning more things day by day.

    Monica Bharadwaj

    Hope you remember me was a part of this session great video karthik learned a lot from your videos-Continue the good work
    2017-06-30T12:26:31+00:00
    Hope you remember me was a part of this session great video karthik learned a lot from your videos-Continue the good work

    Padmaja Uppati

    I am glad to say that I cracked the CFTL exam a week ago.Thank you very much
    2017-06-30T11:46:44+00:00
    I am glad to say that I cracked the CFTL exam a week ago.Thank you very much
  •  

Leave a Reply

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