Setup Menus in Admin Panel

ITeLearn.com

ETL Testing Training Online Live Video Tutorials

ETL Testing Training online course can be subscribed for either a year of live tutorials or previously recorded videos. The…

0 STUDENTS ENROLLED
    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



    Pre-Requisites: For a beginner need to have knowledge on Manual Testing ,Software Testing Life Cycle and some knowledge on Mathematical functions
    For Mid-level QA engineers should have knowledge on Database and Data warehouse concepts.

    Pricing :

    – Payment link for ETL Testing (1 Year Videos) : $200
    – Payment link for ETL Testing (LIVE + Videos) : $250

    If you are interested in the Video only option, then you are welcome to join anytime. You will get access to ETL Testing videos that are of high quality.
    1 year of Recorded Video access.

    ETL Testing Course Content

    Chapter 1 : Retrieving Data using the SQL SELECT Statement

    • 1.1 Capabilities of the SELECT statement
    • 1.2 Arithmetic expressions and NULL values in the SELECT statement
    • 1.3 Column aliases
    • 1.4 Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
    • 1.5 Use of the DESCRIBE command

    Chapter 2 : Restricting and Sorting Data

    • 2.1 Limiting the Rows
    • 2.2 Rules of precedence for operators in an expression

    Chapter 3 : Using Single-Row Functions to Customize Output

    • 3.1 Describe the differences between single row and multiple row functions
    • 3.2 Manipulate strings with character function in the SELECT and WHERE clauses
    • 3.3 Manipulate numbers with the ROUND, TRUNC and MOD functions
    • 3.4 Perform arithmetic with date data
    • 3.5 Manipulate dates with the date functions

    Chapter 4 : Using Conversion Functions and Conditional Expressions

    • 4.1 Describe implicit and explicit data type conversion
    • 4.2 Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
    • 4.3 Nest multiple functions
    • 4.4 Apply the NVL, NULLIF, and COALESCE functions to data
    • 4.5 Use conditional IF THEN ELSE logic in a SELECT statement

    Chapter 5 :Reporting Aggregated Data Using the Group Functions

    • 5.1 Group Functions
    • 5.2 Creating Groups of Data
    • 5.3 Restricting Group Results

    Chapter 6 :Displaying Data from Multiple Tables Using Joins

    • 6.1 Introduction to JOINS
    • 6.2 Types of Joins

    Chapter 7 : Using Sub queries to Solve Queries

    • 7.1 Introduction to Sub queries
    • 7.2 Single Row Sub queries
    • 7.3 Multiple Row Sub queries

    Chapter 8 : Using the SET Operators

    • 8.1 Set Operators
    • 8.2 UNION and UNION ALL operator
    • 8.3 INTERSECT operator
    • 8.4 MINUS operator
    • 8.5 Matching the SELECT statements
    • 8.6 Using ORDER BY clause in set operations

    Chapter 9 : Managing Tables using DML statements

    • 9.1 Data Manipulation Language
    • 9.2 Database Transactions

    Chapter 10 : Introduction to Data Definition Language

    • 10.1 Data Definition Language

    Chapter 11 : Introduction to Data Dictionary Views

    • 11.1 Introduction to Data Dictionary
    • 11.2 Describe the Data Dictionary Structure
    • 11.3 Using the Data Dictionary Views
    • 11.4 Querying the Data Dictionary Views

    Chapter 12 : Creating Sequences, Synonyms, Indexes

    • 12.1 Overview of sequences
    • 12.2 Overview of synonyms
    • 12.3 Overview of indexes

    Chapter 13 : Creating Views

    • 13.1 Overview of views

    Chapter 14 : Retrieving Data by Using Sub queries

    • 14.1 Retrieving Data by Using a Subquery as Source
    • 14.2 Working with Multiple-Column subqueries
    • 14.3 Using Scalar sub-queries in SQL
    • 14.4 Correlated Sub-queries
    • 14.5 Working with the WITH clause
    • 14.6 Analytical Functions

    Chapter 15 : DATAWAREHOUSE BASICS

    • 15.1 What is Datawarehouse?
    • 15.2 What is Business Intelligence?
    • 15.3 Online Transaction Processing System (OLTP)
    • 15.4 OLTP Vs Datawarehouse (OLAP)
    • 15.5 Architecture of Datawarehouse
    • 15.6 Data mart
    • 15.7 Top Down (Immon) Vs Bottom Up (Kimball)
    • 15.8 ROLAP, MOLAP and HOLAP

    Chapter 16 : DATA MODELING

    • 16.1 What is data Model?
    • 16.2 E-R Modeling
    • 16.3 Dimensional Modeling
    • 16.4 Dimension table
    • 16.5 Fact Table
    • 16.6 SURROGATE KEY
    • 16.7 SCD Type 1
    • 16.8 SCD Type 2
    • 16.9 SCD Type 3
    • 16.10 Types Measures or Facts or Metrics
    • 16.11 What is Schema?
    • 16.12 STAR Schema
    • 16.13 SNOWFLAKE SCHEMA
    • 16.14 Confirmed Dimension
    • 16.15 Junk Dimension
    • 16.16 Degenerated Dimension
    • 16.17 Types of Fact Tables
    • 16.18 Fact less fact

    Chapter 17 : ETL Testing

    • 17.1 Introduction
    • 17.2 What is ETL Testing?
    • 17.3 Responsibilities of a ETL Tester

    Chapter 18 : ETL Testing Methodologies

    • 18.1 Smoke Testing
    • 18.2 Functional Testing
    • 18.3 System Testing
    • 18.4 Regression Testing
    • 18.5 Performance Testing
    • 18.6 ETL Testing Work Flow Process
    • 18.7 How to Prepare the ETL Test Plan
    • 18.8 How to design the Test cases in ETL Testing.
    • 18.9 How to reporting the Bugs in ETL Testing?
    • 18.10 ETL Testing Responsibilities.
    • 18.11 How to detect the bugs through database queries

    Chapter 19 : ETL Testing with Informatica PowerCenter

    • 19.1 SAMPLE Loading from source to target
    • 19.2 Testing Heterogeneous Sources
    • 19.3 SORTER Transformation
    • 19.4 FILTER Transformation
    • 19.5 ROUTER Transformation
    • 19.6 EXPRESSION Transformation
    • 19.7 JOINER Transformation
    • 19.8 UNION Transformation
    • 19.9 AGGREAGATOR Transformation
    • 19.10 RANK Transformation
    • 19.11 SEQUENCE GENERATOR Transformation
    • 19.12 Flat File
    • 19.13 Look up Transformation
    • 19.14 SCD type 1
    • 19.15 SCD type 2
    • 19.16 SCD type 3
    • 19.17 Update Strategy
    • 19.18 XML Source Qualifier
    • 19.19 Types of load (Full, incremental, Refresh)

    Chapter 20 : ETL Testing with SSIS

    • 20.1 Packages
    • 20.2 Cubes

    Chapter 21 : ETL Testing with DataStage


    TAKE THIS COURSE
    • $200.00 per 12 months
    • week, 3 days

    Subscribe

    Member Testimonials

    Anuradha Velpuri

    I was impressed by the quality, content and very impressed with Mr. Shanker’s knowledge. We learned all the terminology, test View Full →
    2015-06-24T15:36:43+00:00
    I was impressed by the quality, content and very impressed with Mr. Shanker’s knowledge. We learned all the terminology, test View Full →

    Lenora (US)

    Thank you for reaching out to me in reference to training. I am greatly interested because I am so inspired View Full →
    2015-03-05T20:29:06+00:00
    Thank you for reaching out to me in reference to training. I am greatly interested because I am so inspired View Full →

    Prakash Kosana

    My experience so far related to my training is awesome. I really love the way Karthik teaching. He absolutely come View Full →
    2015-07-02T16:28:51+00:00
    My experience so far related to my training is awesome. I really love the way Karthik teaching. He absolutely come View Full →

    Nimmi Srivastava

    It has been a tremendous knowledgeable journey for me while I was going through the Selenium course. No doubt, I’ve View Full →
    2015-06-24T15:31:04+00:00
    It has been a tremendous knowledgeable journey for me while I was going through the Selenium course. No doubt, I’ve View Full →

    Reena Rani

    This is Reena here from MOST IV Batch. Thank you so much for providing the wonderful and awesome training on View Full →
    2015-06-24T15:20:16+00:00
    This is Reena here from MOST IV Batch. Thank you so much for providing the wonderful and awesome training on View Full →
    Main Menu