Online Training on ETL Testing

RK SOFT is the First Exclusive Training Institute on Hyperion Products by Certified Industry Experts.
We are giving Corporate Training & Online Training on IBM and Hyperion Products.

About Instructor: - Our Instructor has about 12 years of experience in IT field and 13 years in Data warehousing and Hyperion products. Instructor is a IBM Cognos TM1 Certified consultant and Hyperion Certified Consultant in Essbase, HFM and Planning.Instructor can be reached by Email all the time. Since the Instructor is working fulltime in IT organizations, they cannot be reached by phone during the weekdays.

ADVANTAGES with RK SOFT:
=> Real Time Instructor Led Live Online Training
=> Customized Courses matching the job requirements of the consultant
=> Convenience of learning anytime/anyplace
=> Feel and decide after attending Free Demo session with real time instructors working with MNCs
=> Regular and Crash Courses at the option of the Client
=> Training with Live Examples
=> Training Material Support PPTs & Pdf Docs
=> Practicals after every major topic
=> Software access for practice
=> Tests and FAQs from interviews point of view with Project Work
=> Round the Clock Support
=> Feedback from training coordinators throughout the course
=> Mock Interviews after the completion of the Course
=> On the Job Support by the Trainer through Email
=> All at reasonable Price

Course Content:

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
NORMALIZATION
ODS
STAGING AREA
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 TYPE1,TYPE2,TYPE3
INITIAL LOAD
INCREMENTAL LOAD
FULL LOAD
CDC- change data capture
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
Reverse Engineering
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?
Testplan Preparation
Testcases Preparation
Preparation of Test data
Process Of ETL Testing
Testing Concepts
Whitebox Testing
Blackbox 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
Practice:
Testing scenarios, creation of test cases and scripts
Test case execution and defect tracking and reporting
Preparation of Test data
Practice ETL Testing with Real Time Scenarios