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 – http://www.itelearn.com/pricing-option for pricing details

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

  • Member Testimonials

    Vijayalakshmi Shetty

    "Thanks Karthik, I watched few more vedios of you. I really appreciate your effort and patience to bring up the high quality with great content... Read More
    2017-06-30T12:10:12+00:00
    "Thanks Karthik, I watched few more vedios of you. I really appreciate your effort and patience to bring up the high quality with great content vedios, which keeps the viewrs really dynamic and confident on what they learn."

    madhavi emani

    I feel this experience was incredible and gave me lot of knowledge.I had a block in my mind that i can never code, but i... Read More
    2017-08-07T06:39:20+00:00
    I feel this experience was incredible and gave me lot of knowledge.I had a block in my mind that i can never code, but i got over with it with this project.I had a phobia that only people with high logical mind can be programmers.I do not think like that anymore.It was very good to see that project was divided in to teams and tasks.The way Karthik explained us how to write an optimized code was so easy to understand.Internet gives 100's of results and we need to search for the right one.He even taught how to use those results.I liked the status meetings and presentations.Your continuous support and technical feedback encouraged us more.I happy that i took training under highly knowledgeable people like you and Karthik. At this stage, i feel i can confidently try to create code snippets using java and junit on eclipse. I will recommend ITelearn to all my friends who are looking for training, and write good positive reviews on the internet.

    Divya Mudireddy

    I got a full time offer at Availity and today was my first day there .First of all I have to thank You all for... Read More
    2017-08-07T07:00:24+00:00
    I got a full time offer at Availity and today was my first day there .First of all I have to thank You all for all the classes and the projects which gave me immense confidence because of which I am here.Also I would like to thank you all for the extra effort for providing reference for my work with Atomic77. Thank you Karthik,Manoj & Saqib for always insisting on practice.During my interview,the moment I started talking in detail about developing keyword driven framework which I worked on at SLP project, I guess the interview panel were almost sure their search has ended. I would definitely suggest ITelearn to my friends who are looking to learn things in the right way.Being a part of your learning experience not only teaches us confidence but most importantly teaches us to learn and debug anything the right way...I will always be Thankful to ITelearn team and will continue attending few of your ongoing courses. Thanks again and I wish ITelearn to spread more confidence and happiness to all its attendees..Will keep in touch.

    Glory Cristina

    Great Presentation skills
    2017-06-30T12:34:02+00:00
    Great Presentation skills

    Julie Davis

    "Hi Karthik Sir, The way you teach is amazing. Things look very easy whenever I see your Tutorial. I can just say God Bless You... Read More
    2017-06-30T12:07:25+00:00
    "Hi Karthik Sir, The way you teach is amazing. Things look very easy whenever I see your Tutorial. I can just say God Bless You a lot. Thanks "
  •  

Leave a Reply

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