ETL testing course for Intermediate trainees by Satori Technologies and Solutions Private Limited

Data warehousing ETL Testing
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 Admin 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
DWH Concepts
What Is Dwh ?Why We Require That ?
Dwh Architecture
Data Mart And Types
Dm Vs Dwh
Data Cleanzing
Data Scrubing
Data Masking
Normalization
ODS
STG Area
DSS
ETL Testing Course Contents
Diff B/W OLTP Vs ODS, OLAP Vs DSS
Dimention Modeling
Dimensions
Facts
Aggregates
DWH Schema Designing
Star Schema, Snowflake Schema, Galaxy Schema, FCS
Slowly Changing Dimensions
Scd Type,Type,Type
Initial Load
Incremental Load
Full Load
CDC- Change Data Capture
FAQs
ETL Testing Concepts
Introduction Of ETL-Extract, Transform, Load
ETL Tools And Diff Types Of ETL Tools
ETL Architecture
ETL Testing And Why We Require
Different ETL Tools Architectures
SDLC And Methods/Models
STLC And Methods/Models
SDLC Vs STLC
Reverse Engineering
Qc(Quality Center And Bugzilla)
Roles And Responsibilities
Minus, Duplicate, Count, Intersection, Etc
Detect Defects
Defects Logging And Reporting
How To Prepare Queries Very Quickly With The Help Of Mapping
Performance Tuning And Performance Testing, Report Testing, UI Testing
Quality And Different Standards That Tester Should Follow, Why?
Test plan Preparation
Test cases Preparation
Preparation Of Test Data
Process Of Etl Testing
Testing Concepts
White box Testing
Black box Testing
Gray Box Testing
Regression Testing
Smoke Testing Vs Sanity Testing
User Testing
Unit Testing
Intigration Testing
Module Testing
System Testing
UAT
ETL Tool And Testing
Data Extract
Data Transform
Data Load
Import Source
Import Target
Mappings, Maplets
Workflows, Worklets
Transformations, Functionalities, Rules And Techniques
Import And Export
Coping And Rules
Queries Preparation Based On Transformations
Importance Of Etl Testing
Creating Of Mappings, Sessions, Workflows
Running Of Mappings, Sessions, Workflows
Analyzing Of Mappings, Sessions, Workflows
Tasks And Types