INSTRUCTOR-LED ETL Testing TRAINING

29 Mar 10:00 PM - 11:00 PM
WeekDay Course ETL
(Mon-Fri)
6 weeks - 30 hrs
USD 175

ETL Testing Videos with Support

(21 modules , 30 hrs )

ETL Videos - Lifetime Access

30 hrs of Videos USD 100 Enroll

ETL Testing Course Curriculum


New ETL Testing Training batch starting from 29 Mar 10:00 PM - 11:00 PM
ETL Testing Training course videos will help you learn SQL, data-warehousing concepts, Informatica, ETL process, Pentaho, Data Integration techniques, Tableau, Business Intelligence Reports, creating dashboards and end to end ETL process scenarios with the help of real-time data. Course also includes installations of all the softwares and our team will also help you install them on your local machine for practice.

SQL Server Installation and Commands

DATA WAREHOUSE
/ SQL TUTORIAL

Module - 1

Duration 1 hour

Introduction to ETL,ETL tools
  • 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?
Watch Video
Module - 2

Duration 45 mins

Concepts of BI and BA,Similarities and Differences,Database v/s DWH
  • Business Intelligence(BI).
  • Etl as part of BI.
  • Reporting in BI.
  • Business Intelligence vs. Business Analytics.
  • Different Reporting Tools available.
  • Database vs. Data WareHouse
Linkedin Reviews

SQL Concepts

Module - 3

Duration 2 hours 3 minutes

SQL Installation and ETL Commands
  • File v/s Database
  • Sql Server Installation,sql management studio install
  • Northwind Sample Database
  • DDL commands:Create, Alter, Rename and Drop
  • DML commands:Select,Insert, Update, Delete and Merge
  • TCL Begin, Commit, Rollback
Watch Video
Module - 4

Duration 2 hours 8 minutes

SQL Concepts - Part 1
  • Filtering data using Clauses - where,LIKE,IN,NOT IN,IS NULL,IS NOT NULL,TOP AND DISTINCT
  • Constraints: PRIMARY KEY,FOREIGN KEY integrity, CHECK constraint,UNIQUE,NOT NULL,UNIQUE with UNIQUE pair
  • Drop any constraint
  • Use of clauses: WHERE,LIKE,NOT LIKE
  • Operators: AND, OR
  • Use of IN,NOT IN,IS NULL,IS NOT NULL
Module - 5

Duration 2 hours 45 minutes

SQL Concepts - Part 2
  • Use of ROW_NUMBER(),NTILE(),CAST()
  • String functions:LEN, LTRIM, RTRIM
  • LOWER, UPPER
  • REPLICATE, REVERSE, SUBSTRING
  • How to add blank spaces to column values
  • LEFT TRIM, RIGHT TRIM in a single command
Module - 6

Duration 36 minutes

Stored Procedure and Views
  • Stored procedure
  • View code from the back end of stored procedure
  • Parameterized and non Parameterized
  • View code from the back end of stored procedure
  • How to pass values for parameters
  • How to alter stored procedure
Watch Video
Linkedin Reviews

Introduction to Informatica

Module - 7

Duration 1 Hour 2 minutes

Installation of Oracle, Informatica
  • Installation of ETL tool Informatica
  • Use of Oracle in configuring Informatica Client and Server
  • Configuration of Server and Client tools
  • Role of oracle in informatica
  • Download and Installation of SQL Developer
  • Commands in Oracle SQL plus,SQL developer
Module - 8

Duration 42 minutes

Backup, Restoration in Informatica
  • Start the services for Informatica
  • Launch the Powercenter Informatica Server on browzer(Chrome/firefox).
  • What is Repository Service in Informatica Administrator Home page?
  • Creating Repository Service.
  • What is Integration Service in Informatica Administrator Home page?
  • Creating Integration Service.
Module - 9

Duration 1 hour 31 minutes

Different Data Sources in Informatica
  • Introduction to Repository Manager,Powercenter Designer,Workflow Manager,Work Flow monitor
  • Repository Manager : Create the memory Reference
  • WorkFlow Designer : Sources , Targets
  • WorkFlow Manager : Create Session Task
  • Using flat files:txt,csv,xml,Database schema as Source Data
  • Using flat files:txt,csv,xml,Database schema as Target data
Module - 10

Duration 2 hours

Transformations in Informatica
  • Source Qualifier transformation
  • Aggregate Transformation
  • Filter Transformation
  • Expression Transformation
  • Router Transformation
  • Joiner Transformation

INFORMATICA - ETL TOOL

Module - 11

Duration 1 hour 36 minutes

Sequence Generator,Trigger,Procedure for Normalizing Data in Informatica
  • more use of java transformation
  • use of procedures
  • Some more transformations:use data of resort as source
  • meal plan wise bookings:ap,map,cp,ep
  • room category wise bookings
  • room number wise bookings

ETL TESTING

Module - 12

Duration 2 hours 18 min

SCD, Import/Export client objects, Sample Project
  • SCD 1
  • SCD 2 with flag value.
  • SCD 2 with version number.
  • SCD 2 with Effective Date Range.
  • SCD 3
  • Export Informatica Client Objects.
Module - 13

Duration 1 hour 3 minutes

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
Module - 14

Duration 1 hour 10 minutes

Dashboard, Joins, Highlighters and Filters in Tableau
  • Filter Action.
  • Highlighter Action.
  • Joins in Tableau.
  • Data Blending in Tableau.
  • Dual Axis Comparison.
  • Creating a new Worksheet.

BUSINESS INTELLIGENCE REPORTS

Module - 15

Duration 1 hour 35 min

Business Intelligence Reports
  • Pdf as data Source
  • Data Interpretor
  • Merge the Mismatechd fields
  • Create Calculated Field
  • Filter the Record Set
  • Aliasing the Record Set
Watch Video
Module - 16

Duration 40 mins

BI Dashboards
  • 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 Perform
Module - 17

Duration 16 mins

End To End Project
  • Installation of Pentaho Data Integration
  • Post greSQL Installation

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
  • Sort the records for OLE DB in ascending order
  • Sort the records for OLE DB in descending order
  • Aggregate transformation within SSIS
  • Slowly Changing Dimensions in SSIS
  • SCD Type 1 : Changing Attributes
  • SCD Type 2 : Historical Attribute
ETL Testing Training FAQs

Total modules

21

Total Duration (hrs)

30
000