Logo
  • phone_icon
  • US Contact Number: +1(917)-745-8787

  •  India Contact Number: (+91) 8968585110
  • Get Social with us!

ETL Testing Course Details

Total Duration: 30+ HRS

Total Modules: 20

Datawarehouse / SQL Tutorial

Duration 42 mins

Module - 1

right_icon2Introduction to ETL/DATAWAREHOUSING

    • Topics
    • How to Handle Data in Bulk ?
    • Data Ware House Solution.
    • What is ETL Process?
    • Different ETL Tools available.
    • What can be Data Sources?
    • Pre requisites for ETL Testing.
    • How ETL Tester Works?

Duration 32 mins

Module - 2

right_icon2Details on BI and Reporting

  • Topics
  • Business Intelligence(BI).
  • Etl as part of BI.
  • Reporting in BI.
  • Business Intelligence vs. Business Analytics.
  • Different Reporting Tools available.
  • Database vs. Data WareHouse
  • How DW can be used?

Duration 2 hrs 45 mins

Module - 3

right_icon2SQL - Basics

  • Topics
  • file vs database.
  • SQL server installation.
  • Northwind sample database.
  • DDL - Create,Alter,Rename and Drop.
  • DML - Select,Insert,Update and delete.
  • DML - Select,Insert,Update and delete.
  • TCL - Begin,Commit and Rollback.
  • Constraints - Primary,Unique,Not NUll,Check,Default and Foreign.
  • Clauses - where,like,in,IS NULL,IS NOT NULL,top and distinct.
  • Aggregate Functions - Max,min,avg,sum and count.
  • CONCAT String Function.
  • Order by(ACS / DESC ),Conditional Case.
  • Clauses->group by,having.
  • Arithmetic Operations.
  • Difference between delete,drop,truncate with example.

Duration 1 hr 30 minutes

Module - 4

right_icon2SQL Functions

  • Topics
  • String Functions : Upper, Lower, Len, LTRIM, RTRIM, REVERSE, REPLICATE and SUBSTRING.
  • Arithmetic Functions : Floor,Ceiling,Sqrt,exp,log and absolute.
  • Row Number,NTILE,CAST,CASE.
  • Ranking Functions : Rank and Dense Rank with Partition BY and Over clause, Rank and Dense Rank with out Partition BY and Over clause.
  • SET operations : UNION,UNION ALL,INTERSECT and EXCEPT.

Duration 1 hr 30 minutes

Module - 5

right_icon2SQL Joins

  • Topics
  • SQL Joins : Inner join,Left Join,Right Join,Self Join and Full OUTER Joins.
  • Column Aliasing and Table Aliasing.
  • Difference between joins and UNION.
  • Sub Queries : Dependent and Independent, With Comparison Operators =,<,>,<=, With IN and NOT IN, With Exists and Not Exists, All System Stored Procedures.
  • Stored Procedures : Create,Execute,View,Alter,Delete and Encrypt.
  • SQL View->Create a View,How it can be used.

Datawarehousing/ETL concepts

Duration 1 hr

Module - 6

right_icon2Data Ware House Concepts Part - 1

    • Topics
    • Normalization in Database,
    • Types of Normalization : 1NF,2NF,3NF.
    • Dimensional Modeling in DWH.
    • Schema in DWH.
    • Data Marks and its types.

Duration 43 mins

Module - 7

right_icon2Data Ware House Concepts Part - 2

  • Topics
  • Types of Dimensional Tables : SCD0,SCD 1, SCD 2,SCD 3 and SCD 4.
  • De generative Dimensions.
  • Junk Dimensions.
  • Date/ Time Dimensions.

Duration 32 mins

Module - 8

right_icon2Data Ware House Concepts Part - 3

  • Topics
  • Additive Facts.
  • Semi- Additive Facts.
  • Non Additive Facts.
  • Fact less Facts.
  • Transactional Fact Tables.
  • Periodic Fact Tables.
  • Accumulated Fact Tables.
  • Approaches in DWH: Top Down Approach and Bottom Up Approach

Installation Oracle / Informatica

Duration 2 hrs

Module - 9

right_icon2DataWarehousing ETL Concepts -4

  • Topics
  • Use of Oracle as Database.
  • ETL Tool Informatica.
  • Installation of oracle with SQL Plus and SQL developer utility.
  • Commands in oracle SQL plus and SQL developer.
  • Similarities and Differences.
  • Create a new users in SQL plus.
  • Create a new user in SQL developer.
  • Create tables in user and insert records.
  • Delete the records and drop the user with cascade
  • Saving the SQL developer commands
  • Download Powercenter Informatica.
  • Unzip the all 4 files.
  • Collect the dependent files.
  • Unzip the server and client files.
  • Install Informatica Server.
  • Creating domain with oracle.
  • Start the services for Informatica Server.
  • Launch the Powercenter Informatica Server on browzer(Chrome/firefox).
  • Installing Informatica Client.
  • Powercenter Informatica Client Components.

Duration 1 hr

Module - 10

right_icon2Linking Informatica Server and Informatica Client

  • Topics
  • What is Repository Service in Informatica Adminutesitrator Home page?
  • What is Integration Service in Informatica Adminutesitrator Home page?
  • Creating Repository Service.
  • Creating Integration Service.
  • Creating Domain In Powercenter Repository manager.
  • Linking Client with server.
  • Work with Powercenter Designer.
  • Work with WorkFlow Manager.
  • Work with WorkFlow Monitor.
  • Copy from Existing Repository Service.
  • BackUp of the existing Repository Service.
  • Use the backup file to restore the content.

Informatica - ETL Tool

Duration 1 hr 30 mins

Module - 11

right_icon2Different Types Of Data Sources and work with all types

  • Topics
  • Using Flat File (.txt / .csv) , XML File , Database Source table.
  • Repository Manager : Create the memory Reference.
  • WorkFlow Designer : Sources , Targets ,
  • Different types of Sources and Targets.
  • How to link with Flat File as Data Source?
  • Mapping for Flat File to Flat File.
  • Mapping for XML File to Flat File.
  • Mapping for Database table to Flat File.
  • Creating the Connection for the database user.
  • Mapping for Database table to Database Table.
  • WorkFlow Manager : Create Session Task
  • Create Workflow.
  • Run the Workflow.
  • WorkFlow Monitor : Monitor the Workflow.

ETL Testing

Duration 2 hrs 30 mins

Module - 12

right_icon2Transformations

  • Topics
  • All Transformations Definition
  • Source Qualifier
  • Aggregate Transformation
  • Filter Transformation
  • Expression Transformation
  • Router Transformation
  • Joiner Transformation
  • Sequence Generator Transformation
  • Lookup : Connected and Unconnected

Duration 1 hr 45 mins

Module - 13

right_icon2SCD's

  • Topics
  • SCD 1
  • SCD 2 with flag value.
  • SCD 2 with version number.
  • SCD 2 with Effective Date Range.
  • SCD 3
  • Test Cases
  • Test Scenarios
  • Tester's Check List

Duration 1 hr

Module - 14

right_icon2Project Overview

  • Topics
  • Export Informatica Client Objects.
  • Import all Informatica Client Objects
  • Client Objects : Sources, Targets, Mappings, WorkFlows.
  • Working with sample Project.
  • Delete the tables from recycle bin(Purge)

Business Intelligence Reports Testing

Duration 42 min

Module - 15

right_icon2BI Reports

  • Topics
  • Tableau as Reporting Tool
  • Download Tableau Public
  • Installing the Tableau
  • Using Excel file as Data Source in tool
  • Working with single sheet in Tableau
  • Dimension and Measures in Tableau
  • Hierarchy in Data
  • Creating own Hierarchy
  • Creating Maps
  • Creating Bar Charts
  • Creating Bubbles Charts
  • Creating Work Sheets as Reports
  • Explore the reports on the Tableau Public accountOLAP system

Duration 70 min

Module - 16

right_icon2Business Intelligence Reports Testing

  • Topics
  • BI Functional Testing
  • Report Design Check
  • Prompts Check
  • Report Data Accuracy Check
  • Drill Down Report
  • Report Perfromance
  • Browser Checks
  • Report Regression Testing
  • BI Stress Testing
  • Simulating Concurrent Load
  • BI Caching
  • BI Security Testing
  • AdHoc report Testing
  • Subject Area Design Check

Project

Duration 2 hr 20 min

Module - 17

right_icon2End to End Project

  • Topics
  • Project Overview
  • Designing the Mapping
  • Using the differnet tranformation
  • Test Case Design
  • Data Cleaning
  • Project Dimension and Facts

Sorry, we aren't online at the moment. Leave a message and we'll get back to you.