ETL Testing MODULES

PLANS AND PRICING

Total modules

21

Total Duration (hrs)

30

DATA WAREHOUSE
/ SQL TUTORIAL

Module - 1

Duration 42 mins

Introduction To ETL and Datawarehousing

  • 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.
Watch Video

Module - 2

Duration 32 mins

Details On BI And Reporting

  • Business Intelligence(BI).
  • Etl as part of BI.
  • Reporting in BI.
  • Business Intelligence vs. Business Analytics.
  • Different Reporting Tools available.
  • Database vs. Data WareHouse

Module - 3

Duration 2 hrs 45 mins

SQL- Basics

  • File vs database.
  • SQL server installation.
  • Northwind sample database.
  • DDL - Create,Alter,Rename and Drop.
  • DML - Select,Insert,Update and delete.
  • DCL : Grant,Revoke.
Watch Video

Module - 4

Duration 1 hr 30 minutes

SQL Functions

  • 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.

Module - 5

Duration 1 hr 30 minutes

SQL Joins

  • 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.

DATA WAREHOUSING
/ ETL CONCEPTS

Module - 6

Duration 1 hr

Data Warehouse Concepts
Part - 1

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

Module - 7

Duration 43 mins

Data Warehouse Concepts
Part - 2

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

Module - 8

Duration 32 mins

Data Warehouse Concepts
Part - 3

  • Additive Facts.
  • Semi- Additive Facts.
  • Non Additive Facts.
  • Fact less Facts.
  • Transactional Fact Tables.
  • Periodic Fact Tables.

INSTALLATION ORACLE / INFORMATICA

Module - 9

Duration 2 hrs

Data warehousing ETL Concepts
Part -4

  • 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.

Module - 10

Duration 1 hr

Linking Informatica Server And Informatica Client

  • What is Repository Service in Informatica Administrator Home page?
  • What is Integration Service in Informatica Administrator Home page?
  • Creating Repository Service.
  • Creating Integration Service.
  • Creating Domain In Powercenter Repository manager.
  • Linking Client with server.

INFORMATICA - ETL TOOL

Module - 11

Duration 1 hr 30 mins

Working with Different Data Sources

  • 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.

ETL TESTING

Module - 12

Duration 2 hrs 30 mins

Transformations

  • All Transformations Definition
  • Source Qualifier
  • Aggregate Transformation
  • Filter Transformation
  • Expression Transformation
  • Router Transformation

Module - 13

Duration 1 hr 45 mins

SCD's

  • SCD 1
  • SCD 2 with flag value.
  • SCD 2 with version number.
  • SCD 2 with Effective Date Range.
  • SCD 3
  • Test Cases

Module - 14

Duration 1 hr

Project Overview

  • 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

Module - 15

Duration 42 min

Business Intelligence Reports

  • 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
Watch Video

Module - 16

Duration 45 mins

BI Dashboards

  • Filter Action.
  • Highlighter Action.
  • Joins in Tableau.
  • Data Blending in Tableau.
  • Dual Axis Comparison.
  • Creating a new Worksheet.

Module - 17

Duration 1 hr 30 mins

End To End Project

  • Pdf as data Source
  • Data Interpretor
  • Merge the Mismatechd fields
  • Create Calculated Field
  • Filter the Record Set
  • Aliasing the Record Set

BI REPORTS TESTING

Module - 18

Duration 45 mins

End To End Project

  • BI Functional Testing: Dashboard Design Check, Prompts Check, Report Data Accuracy Check, Drill Down Reports Check, Browser Check.
  • Adhoc Report Testing: Subject Area Design Check , JOIN Checks, Mapping Checks.
  • BI Security Testing :Report Access Security , Data Security , Single Sign On Security , Integrated Security.
  • BI Stress Testing : Simulating User Behavior , Simulating Concurrent User Load , BI Cache , Measurement.
  • BI Regression Testing : Regression Testing of Report Data , Regression Testing of Report Format , Regression Testing of Prompts , Regression Testing of Security , Regression Testing of Report Performa

ETL WITH SSIS

Module - 19

Duration 30 mins

SSIS Introduction And Installation

  • Why SSIS after Informatica?
  • How SSIS works for ETL?
  • Visual Studio for SSIS
  • Data Flow Task in SSIS
  • Data Control Task in SSIS
  • Different Versions of SQL Server
Watch Video

Module - 20

Duration 1 hour 6 minutes

SSIS Utilities

  • How SSIS works?
  • Linking between Packages , Control Flows , Data Flow Tasks
  • Map the CSV Flat File with Text file
  • Map the CSV file to Excel sheet
  • Drop and Create table within Excel sheet
  • Using Execute SQL Command

TRAINING VIDEO - 21

Duration 1 hr 30 min

SSIS Advanced Concepts

  • Local Variables
  • Global Variables
  • Static and Non-Static Variables
  • Static and Non-Static Functions
  • Creating Objects in C#
  • Meaning of static







Linkedin Reviews