15% Learning Discount Avail now

ETL Testing Videos with Support

(21 modules , 30 hrs )

ETL Videos - 25 Days Access

30 hrs of Videos USD 75 63.75 Enroll

ETL Videos - Lifetime Access

30 hrs of Videos USD 135 114.75 Enroll

ETL Testing Course Curriculum


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.

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
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
Linkedin Reviews
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

Introduction to Informatica

Module - 7

Duration 1 hour 14 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 43 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 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

  • 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