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 30 mins

Module - 1

right_icon2Introduction to Datawarehousing/SQL

  • Topics
  • What is Dataware house?
  • Why Dataware house and why not database?
  • What is ETL?
  • What is Business Intelligence?
  • Testers role in ETL?
  • Testers role in Business Intelligence
  • Prerequisites for ETL Testing

Duration 37 mins

Module - 2

right_icon2Data Models

  • Topics
  • Understanding Database Scehma
  • Basics of Data Modelling
  • Sample Model of Customer Ordering at Startbucks
  • Sample Data Model for shopping at Amazon
  • Many to Many Relationship
  • One to Many Relationship
  • Recursive Relationships
  • Parent Child Relationships

Duration 2 hrs 10 min

Module - 3

right_icon2SQL - Basics

  • Topics
  • What is a database?
  • Files Vs databases
  • Different types of databases
  • What is SQL?
  • Basics of Select Statements
  • Literals
  • Mathematical Operations
  • Primary key
  • Foreign Key
  • Unique Key
  • Creating a new table
  • Updating data in a table
  • Delete data from a table
  • Alter Comand
  • Truncate
  • Drop
  • Commit
  • Rollback
  • Views
  • Column aliasing
  • Generated Columns
  • Where Clause
  • Logical Operators
  • Special Operator
  • Not + Special Operators
  • Order by Clause

Duration 2 hrs

Module - 4

right_icon2SQL - (Functions)

  • Topics
  • Arithmatic Functions
  • String Functions
  • Date & Time Functions
  • Ranking functions
  • Rank
  • Dense Rank
  • ROW_NUMBER
  • NTILE
  • PARTITION
  • ISNULL
  • Null Functions
  • ISNULL with AVG
  • COALESCE
  • NOCOUNT
  • CAST
  • Case Expressions
  • SELECT statement with a simple CASE expression
  • Using CASE in an ORDER BY
  • Using CASE in an UPDATE
  • Using CASE in a HAVING
  • Aggregate functions
  • UNION ALL
  • UNION
  • Except
  • Intersect
  • Group by Clause
  • Having Clause
  • Difference between where and having clause
  • Set Operators

Duration 1 hrs

Module - 5

right_icon2SQL Joins and Queries

  • Topics
  • Non Ansi joins
  • -- Table Aliasing
  • -- Self Joins
  • -- Inner join
  • -- Right outer join
  • -- left outer join
  • FULL OUTER JOIN
  • Sub query at WHERE Clause
  • Sub query at HAVING Clause
  • Subqueries with IN and NOT IN
  • Sub query at FROM clause (INLINE View)
  • Comparison Operators Modified by ANY, SOME, or ALL
  • Subqueries with EXISTS
  • Sub query as an EXPRESSION (SCALAR Query)
  • Subqueries with NOT EXISTS
  • Subqueries Used in Place of an Expression
  • Correlated Subqueries
  • Correlated Subqueries with Aliases
  • Correlated Subqueries with Comparison Operators
  • Correlated Subqueries in a HAVING Clause

Datawarehousing/ETL concepts

Duration 45 min

Module - 6

right_icon2DataWarehousing ETLConcepts -1

  • Topics
  • Normalization
  • Denormalization
  • Architecture of Dataware houses
  • Staging Area
  • Dimensional Modelling
  • Dimension table
  • Fact table
  • Star Schema
  • Snow flake Star Schema

Duration 36 min

Module - 7

right_icon2DataWarehousing ETL Concepts -2

  • Topics
  • Types of dimension tables
  • Foreign Key
  • Slowly changing dimension tables
  • SCD1
  • SCD2
  • SCD3
  • Conformed Dimension table
  • Degenerate Dimension tables
  • Junk Dimension tables
  • Date and Time Diemnsion tables

Duration 39 min

Module - 8

right_icon2DataWarehousing ETL Concepts -3

  • Topics
  • Types of Fact tables
  • - Additive Facts
  • - Semi additive Facts
  • - Non Additive Facts
  • - Factless Fact table
  • Enterprise ware house schema
  • Data marts
  • Top to bottom approach
  • Bottom to top approach
  • ODS (Operational Data Store)
  • Decision Supporting System

Duration 30 min

Module - 9

right_icon2DataWarehousing ETL Concepts -4

  • Topics
  • Data Cleansing
  • Data scrubbing
  • Data Masking
  • Initial Loading
  • Incremental loading
  • Full loading

Oracle and Informatica Installation

Duration 70 min

Module - 10

right_icon2Installating Oracle and Informatica

  • Topics
  • Detailed steps for Oracle installation
  • Informatica Installation

Informatica - ETL Tool

Duration 1 hr 40 min

Module - 11

right_icon2Informatica - An ETL Tool

  • Topics
  • What is Informatica?
  • Informatica Client Components
  • Repository
  • Designer
  • Workflow manager
  • Workflow Monitor
  • Session
  • Mapping
  • Mapping document
  • FLAT FILE to FLAT FILE
  • FLAT FILE TO ORACLE
  • ORACLE TO ORACLE
  • XML TO ORACLE

Duration 34 min

Module - 12

right_icon2Informatica - transformations

  • Topics
  • Source Qualifier
  • Expression Transformation
  • Router Transformation
  • Filter Transformation
  • AggregatorTransformation
  • Update Strategy
  • Lookup Transformation
  • Sequence Generator
  • Joiner
  • Normalizer
  • Active and passive transformation

ETL Testing

Duration 1 hr 40 min

Module - 13

right_icon2ETL Testing -1

  • Topics
  • Ex:1-Source table to target table
  • Test cases for Ex -1
  • Ex: 2 -Source File to Target table
  • Test cases for Ex -2

Duration 1 hr 20 min

Module - 14

right_icon2ETL Testing -2

  • Topics
  • Multiple sources to single target table
  • Implementing Test cases for above scenario
  • Single Source to multiple target tables
  • Implementing Test cases for above scenario

Duration 1 hr 5 min

Module - 15

right_icon2ETL Testing -3

  • Topics
  • SCD1
  • Test cases for SCD1
  • SCD2
  • Test cases for SCD2
  • SCD3
  • Test Cases for SCD3

Duration 1 hr

Module - 16

right_icon2ETL Testing -4

  • Topics
  • Testing the fact table
  • Test cases

Duration 1 hrs

Module - 17

right_icon2ETL Testing -5

  • Topics
  • Project Objective
  • Mapping document
  • Templates
  • Test case preparation
  • Testing the project
  • Data Warehouse testing
  • ETL testing Process
  • ETL Scenario and Test Case
  • BI and Report Testing
  • ETl Testing Architecture

Business Intelligence Reports Testing

Duration 42 min

Module - 18

right_icon2Business Intelligence Reports

  • Topics
  • OLAP system
  • ROLAP
  • MOLAP
  • HOLAP
  • DOLAP
  • Data Slicing
  • Data Dicing
  • What is a dashboard

Duration 70 min

Module - 19

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 - 20

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.