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

    Aarvind Chaurasia

    I am a QA professional since last 7 years in video cable industry and I was looking to learn more in automation tools. I found... Read More
    2017-06-30T12:02:09+00:00
    I am a QA professional since last 7 years in video cable industry and I was looking to learn more in automation tools. I found iTeLearn on youtube while I was searching for tutorials and I started finding the materials useful hence I decided to join the premium membership and since last few months I have learnt a lot in various topics namely automation tools. I find materials built on gradient level of complexity which takes a total beginner to an advanced stage in an easy manner. Karthik is an excellent educator and professional. I have found many useful topics at this portal via his video tutorials. He has done an excellent job of teaching. It has definitely added to my skill set as a QA professional. I would recommend iTeLearn to everyone interested in raising their skill set or building one, even if they are beginners. Thanks to Karthik and iTeLearn team for creating this portal. Arvind Kumar Chaurasia PMP, MS Engg Mgt

    abdul mohammed

    "hi karthik sir,, the way of ur teaching style is very soft and clear , i believe the students who want to learn ms excel... Read More
    2017-06-30T12:07:01+00:00
    "hi karthik sir,, the way of ur teaching style is very soft and clear , i believe the students who want to learn ms excel they no need to go to any institution ,they can learn online under a soft and experiance teacher like u sir,, thanks a lot bye"

    Nimmi Srivastava

    It has been a tremendous knowledgeable journey for me while I was going through the Selenium course. No doubt, I've learnt in depth not only... Read More
    2017-06-30T12:04:09+00:00
    It has been a tremendous knowledgeable journey for me while I was going through the Selenium course. No doubt, I've learnt in depth not only about the Selenium basics+advanced topics but also the nitty gritty of it too.

    Anuradha Velpuri

    I was part of the webinar. I was impressed by the quality, content and very impressed with Mr. Shanker's knowledge. We learned all the terminology,... Read More
    2017-06-30T12:42:59+00:00
    I was part of the webinar. I was impressed by the quality, content and very impressed with Mr. Shanker's knowledge. We learned all the terminology, test scripts and bug reporting. Looking forward to work on HP's QC.
    2017-06-30T12:42:45+00:00
  •  

Leave a Reply

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