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

    Madhumita Shyam

    During this two weeks I went through the fast track QTP videos and found it extremely helpful . I liked the way emphasis is given... Read More
    2017-06-30T11:37:02+00:00
    During this two weeks I went through the fast track QTP videos and found it extremely helpful . I liked the way emphasis is given on scripting and not on recording .That's what I was actually looking for . I am hoping these training videos will clear my doubts that I was experiencing all this while in QTP . I am sure going forward it will help me with all clarifications that I have . I am a manual tester with 8 plus years experience and have recently got the opportunity to work with QTP basics at my work place . I want to learn the advanced QTP and did not find the right training that was actually looking for until now . I think these training videos are the right ones for me . I also look forward for the next live QTP session

    thejbmcd

    "You bring the information across in a very well, non-rushed and simply explained way... I look forward to viewing your other tutorials - Thank you... Read More
    2017-06-30T12:05:57+00:00
    "You bring the information across in a very well, non-rushed and simply explained way... I look forward to viewing your other tutorials - Thank you mate! "

    Sujata A

    Very Excellent session, good voice,thanks Karthik for the excellent training. Your explanation about "why, how" is really marvellous. I am a beginner and able to... Read More
    2017-06-30T12:40:18+00:00
    Very Excellent session, good voice,thanks Karthik for the excellent training. Your explanation about "why, how" is really marvellous. I am a beginner and able to understand so clearly and its valuable too. Thanks alot.

    Lakshmi Manohari Sorapalli

    The videos I have gone through till now were really good with detailed information and I also liked the way Karthik explains the subject.
    2017-06-30T11:48:02+00:00
    The videos I have gone through till now were really good with detailed information and I also liked the way Karthik explains the subject.

    Archana

    Thank you Karthik and team itelearn, It is great platform to learn about IT courses. I am impressed by the trainers and the way they... Read More
    2017-08-07T06:10:04+00:00
    Thank you Karthik and team itelearn, It is great platform to learn about IT courses. I am impressed by the trainers and the way they teach, very easy to grasp for Beginners like me. Appreciate the efforts you put towards this trainings. Can't wait for my next class.
  •  

Leave a Reply

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