etl testing online training

 

Go trainings offers the best Etl Testing online Training with the IT industry specialists as our trainers are experienced certified tutors will share their experience, tips and tricks in the Etl Testing Online Training from india and we are also providing similar courses;like Hadoop Online Training.

 

 

ETL Testing Course Content

 

                                                                                                                        

Overview Of ETL Testing Online training course

 

Oracle Basics & Concepts

  • DBMS
  • RDBMS
  • DBMS vs RDBMS
  • Why Database Required
  • Different types of databases and difference
  • ASCII vs UNICODE
  • PL/SQL Basics
  • Oracle Architecture
  • Diff B/W Database & Files
  • OLTP
  • OLAP, ROLAP, MOLAP
  • METADATA
  • DDL,DML,DCL
  • BASIC ACTIVITIES
  • DATATYPES
  • TABLES
  • SQL ,SUB QUERIES,CORELATED SUB QUERY
  • INNER QUERY,OUTER QUERY
  • FUNCTIONS AND TYPES AND IMPORTANCE
  • JOINS AND DIFFERENT TYPES
  • VIEWS n MATERIALIZED VIEWS
  • INDEX
  • CONSTRAINTS
  • REFERENTIAL INTEGRITY
  • PARTITIONING
  • PERFORMANCE TUNING
  • DIFFERENT TYPES OF TECHNIQES
  • DATABASE SCHEMA

 

Data WareHousing Concepts:

  • What is Data Ware House?
  • Difference between OLTP and DataWare Housing
  • Data Acquisition
  • Data Extraction
  • Data Transformation
  • Data Loading
  • Data Marts
  • Dependent Data Mart
  • Independent Data Mart
  • Data Base Design
  • Star Schema
  • Snow Flake Schema
  • Fact constellation Schema

 

SCD(slowly changing dimension)

  • Type-1 SCD
  • Type-2 SCD
  • Type-3 SCD
  • Basic Concepts in SQL
  • Overview of ETL Tool Architecture
  • White Box and Black BOX Testing Functionality on Different Transformation Rules
  • Data Ware House Life Cycle
  • Different Types of Testing Techniques in ETL
  • Minus Queing
  • Count Queing

 

ETL Testing Concepts

  • Introduction
  • What is use of testing
  • What is quality & standards
  • Responsibilities of a ETL Tester

    A.)Software development life cycle

  •     Waterfall model
  •     V-model
  •     Agile model & methodology
  •     Prototype model
  •     Spiral model

    B.)Testing methodologies

  •     White box testing
  •     Black box testing
  •     Grey box testing

 

ETL Testing Work Flow Process

 

How to Prepare the ETL Test Plan

 

How to design the Test cases in ETL Testing.

 

How to reporting the Bugs in ETL Testing ?

 

ETL Testing Responsibilities in DataStage, Informatica, Abinitio etc;

 

How to detect the bugs through database queries

 

ETL Performing Testing & Performing Tuning

Contact For More Details On Etl Testing Training +91 9063320459    Etl Testing Online Training