ETL Testing Training Course Details

After globalization, many countries have opened their doors and the entire globe has shrunk into a small village. When trade across the borders has become a common thing, the competition is getting tougher and it is leading to a situation where only the fittest survive.

ETL Testing Training Course Details

At this juncture, coming up with foolproof marketing strategies has become necessary for survival. Anyone requiring the correct data should analyze it properly to design such effective marketing strategies. This data may be stored in different places such as sales, customer care, production departments etc. in different formats. This makes analysis of data quite difficult.

Hence there is a need for data warehousing where the data from different databases will be extracted, transformed to the desired format and loaded on a single platform. Extraction, Transformation, and Loading of data will be done with the help of ETL tools. That is how the demand for experts in ETL has increased considerably in the present day.

ETL Training

The need for ETL experts has increased considerably, many training institutes have come up offering ETL training courses. Out of many tutorials, ETL online tutorials have gained enormous popularity and wide acceptance.

When you join an online ETL training course, you will be provided with ETL videos as study material. Details about various ETL tools will be discussed in detail in these videos. These videos discuss the advantages and disadvantages of each tool, application and also depict the process of warehousing using each tool in detail. Narrations will be supported by relevant infographics to make learning easy and effective.

ETL live project training is a part of any ETL video tutorial and here the trainees will get a chance to work on live projects. This will help them to earn practical knowledge and at the same time, they can learn the technology in depth.

ETL Training Course Content

The syllabi may change a bit depending on the preferences of different trainers, but the core of the course will be one and the same. Most of the professional trainers follow the below given pattern:

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 Subqueries to Solve Queries

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

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 subqueries in SQL
  • 14.4 Correlated Subqueries
  • 14.5 Working with the WITH clause
  • 14.6 Analytical Functions

Chapter 15 : DATA WAREHOUSE BASICS

  • 15.1 What is Data warehouse?
  • 15.2 What is Business Intelligence?
  • 15.3 Online Transaction Processing System (OLTP)
  • 15.4 OLTP Vs Data warehouse (OLAP)
  • 15.5 Architecture of Data warehouse
  • 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 Training 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 AGGREGATOR 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

Be First to Comment

Leave a Reply

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