ETL Testing Online Course Training In Bangalore
ETL testing Online course Training In Bangalore
Course Content:

DATA WAREHOUSING CONCEPTS:

DBMS and RDBMS
What is Data Warehousing and necessity of it?
Data warehousing architecture

OLAP,ROLAP, MOLAP

Data mining
Meta data
Tables, views
Constraints
Fact and Dimensional Tables
Partitioning of tables
Concepts of Referential Integrity
Concepts of Modelling
Database Schema
Concepts of normalization
Concepts of Slowly Changing Dimensions
Concepts of Data Mart
Full and Incremental extraction Process
Change Data capture

SQL CONCEPTS:

DDL, DML commands
All the basic functions (Character Functions, Conversion Functions, Advanced functions, Mathematical Functions and Date Functions)
Joins
Practice SQLs for some sample test scenarios

ETL TESTING:

What is ETL and importance of ETL testing?
Creating, running and analysing sessions/workflows in Informatica
Preparation of Test strategy, Test plan and estimations
Testing scenarios, creation of test cases and scripts
Test case execution and defect tracking and reporting

REPORT TESTING:

Validation of the report data with DB and UI testing
Preparation of Test data

LEVELS OF TESTING

Unit testing
Integration testing
Module testing
System testing
UAT
PRACTICE SESSIONS ON ETL TESTING
 Write review
Ad posted 60 days ago SEE LATEST ANNOUNCEMENTS
Write review
Leave your comments on this ad
Offensive messages and spam will be removed
You're not sending an SMS, type the entire word without spelling errors