20% Off Lockdown Learning Discount Avail now

INSTRUCTOR-LED ETL Testing TRAINING

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

ETL Testing Videos with Support

(21 modules , 30 hrs )

ETL Videos - Lifetime Access

30 hrs of Videos USD 100 80 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 13 Mins

Introduction to ETL,ETL tools
  • How ETL Tester Works?
  • Pre requisites for ETL Testing.
  • What can be Data Sources?
  • Different ETL Tools available.
  • Data Ware House Solution.
  • What is ETL Process?
Watch Video
Module - 2

Duration 44 Mins

Concepts of BI and BA,Similarities and Differences,Database v/s DWH
  • How Data WareHouse can be used?
  • Database vs. Data WareHouse
  • Different Reporting Tools available.
  • Business Intelligence vs. Business Analytics.
  • Reporting in BI.
  • Etl as part of BI.
Watch Video
Linkedin Reviews

SQL Concepts

Module - 3

Duration 1 Hrs 52 Mins

SQL Installation and ETL Commands
  • DCL commands: Grant, Revoke
  • Installation of Oracle
  • TCL Begin, Commit, Rollback
  • DML commands:Select,Insert, Update, Delete and Merge
  • DDL commands:Create, Alter, Rename and Drop
  • Northwind Sample Database
Watch Video
Module - 4

Duration 2 Hrs 13 Mins

SQL Concepts - Part 1
  • Some more Conditional Cases.
  • 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
  • Distinct with count
Module - 5

Duration 2 Hrs 46 Mins

SQL Concepts - Part 2
  • Auto increment: Identity key
  • How to add blank spaces to column values
  • REPLICATE, REVERSE, SUBSTRING
  • LOWER, UPPER
  • String functions:LEN, LTRIM, RTRIM
  • Use of ROW_NUMBER(),NTILE(),CAST()
Module - 6

Duration 36 Mins

Stored Procedure and Views
  • How to delete a 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
Linkedin Reviews

Introduction to Informatica

Module - 7

Duration 1 Hr 10 Mins

Installation of Oracle, Informatica
  • Configuration of Server and Client tools
  • Use of Oracle in configuring Informatica Client and Server
  • Role of oracle in informatica
  • Save commands in sql developer
  • Commands in Oracle SQL plus,SQL developer
  • Download and Installation of SQL Developer
Watch Video
Module - 8

Duration 43 Mins

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

Duration 1 Hrs 40 Mins

Different Data Sources in Informatica
  • Mapping Database to Database of Same user and Different user
  • Mapping Data from Database to Flat file
  • Create connection for Database Schema to take it as Source Data
  • Using flat files:txt,csv,xml,Database schema as Target data
  • Using flat files:txt,csv,xml,Database schema as Source Data
  • WorkFlow Manager : Create Session Task
Module - 10

Duration 2 Hrs 40 Mins

Transformations in Informatica
  • java transformation
  • Aggregate Transformation
  • Filter Transformation
  • Expression Transformation
  • Joiner Transformation
  • Router Transformation

INFORMATICA - ETL TOOL

Module - 11

Duration 1 Hrs 35 Mins

Sequence Generator,Trigger,Procedure for Normalizing Data in Informatica
  • foodcost only for all plans
  • room rent only for all plans
  • room type wise bookings
  • room number wise bookings
  • room category wise bookings
  • meal plan wise bookings:ap,map,cp,ep

ETL TESTING

Module - 12

Duration 2 Hrs 20 Mins

SCD, Import/Export client objects, Sample Project
  • Delete the tables from recycle bin(Purge)
  • 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 Hrs 2 Mins

Tableau as Reporting Tool
  • Creating Bar Charts
  • Download Tableau Public
  • Creating Bubbles Charts
  • Explore the reports on the Tableau Public account
  • Installing the Tableau
  • Dimension and Measures in Tableau
Module - 14

Duration 1 Hrs 8 Mins

Dashboard, Joins, Highlighters and Filters in Tableau
  • Explore Dashboards on Tableau Public account.
  • Creating a new Worksheet.
  • Difference between blending joining data sets
  • Example based on dual axis Comparison
  • Filter Action.
  • Highlighter Action.

BUSINESS INTELLIGENCE REPORTS

Module - 15

Duration 1 Hrs 35 Mins

Data Management in Tableau
  • Pdf as data Source
  • Data Interpretor
  • Merge the Mismatechd fields
  • Create Calculated Field
  • Filter the Record Set
  • Aliasing the Record Set
Module - 16

Duration 40 Mins

BI Testing in Tableau-Project
  • BI Functional Testing
  • Adhoc Report Testing
  • BI Security Testing
  • BI Stress Testing
  • BI Regression Testing
Module - 17

Duration 32 Mins

Installation of PostgreSql and Pentaho
  • Post greSQL Installation
  • Installation of Pentaho Data Integration

BI REPORTS TESTING

Module - 18

Duration 44 mins

End To End Project
  • BI Functional Testing
  • Adhoc Report Testing
  • BI Security Testing
  • BI Stress Testing
  • BI Regression Testing

ETL WITH SSIS

Module - 19

Duration 30 mins

SSIS Introduction And Installation
  • Download and Install Sql Server Data Tools as Visual Studio
  • Different Versions of SQL Server
  • Data Control Task in SSIS
  • Data Flow Task in SSIS
  • Visual Studio for SSIS
  • How SSIS works for ETL?
Watch Video
Module - 20

Duration 1 hour 6 minutes

SSIS Utilities
  • Drop and Create table for OLE DB
  • Linking between Packages , Control Flows , Data Flow Tasks
  • Using OLE DB as target for XML source file
  • Map the CSV Flat File with Text file
  • Drop and Create table within Excel sheet
  • Map the CSV file to Excel sheet
TRAINING VIDEO - 21

Duration 1 hr 30 min

SSIS Advanced Concepts
  • Fuzzy Lookup Transformation
  • Sort the records for OLE DB in ascending order
  • Aggregate transformation within SSIS
  • Sort the records for OLE DB in descending order
  • Slowly Changing Dimensions in SSIS
  • SCD Type 1 : Changing Attributes
ETL Testing Training FAQs

Total modules

21

Total Duration (hrs)

30
000