call +91-9347045052  /   09032803895
php new batch started
php training courses
seo Training Institute
php Training Institute
request for quote
request for quote for website
Joomla Training Hyderabad
Wordpress Training Hyderabad
Online Joomla Training
Online Wordpress Training
Online Web Designing Training
Online Drupal Training institute

Questions? Comments? Contact us.

Address Inquiries

Sai Datta apartment, 4th Floor
Dilsukhnagar , Near Vasan Eye Care Hospital
Beside Tirumala Music Center,Dilsukhngar, HYD

Call me at: +91-9347045052  /   09032803895 | 08500679873

Course Inquiries

New Batch Timing

PHP and CMS website Help??

professional Freelance web designer company hyderabad
 

etl testing Training

etl testing TRAINING ONLINE AND CLASSROOM

This is a very important aspect of software testing phase and students will be enlightened about the need of Data Warehousing. Furthermore, students will be introduced to the concepts of ETL, OLAP and OLTP systems along with a holistic description of the Data Warehouse architecture. Operational Data Store (ODS) also happens to be a very important part of this course and Data Marts are also introduced. Dimension Modelling holds a very strong relevance in the field of software testing. Few more concepts which are covered under this ETL Testing program are Snowflake Schema, Star Schema, Dimension table, fact table, De-Normalization and Normalization.

etl testing Course Modules

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 ?
  • ARCHITECTURE
  • DATA MART and TYPES
  • DM vs DWH
  • DATA CLEANZING
  • SCRUBING
  • DATA MASKING
  • NORMALIZATION
  • ODS
  • STG AREA
  • DSS

ETL Testing Course Contents

  • Diff B/w OLTP vs ODS,OLAP vs DSS
  • DIMENTION MODELING
  • DIMENSIONS
  • INITIAL LOAD
  • INCREMENTAL LOAD
  • FACTS
  • AGGREGATES
  • DWH SCHEMA designing
  • FULL LOAD
  • CDC- change data capture
  • STAR SCHEMA,SNOWFLAKE SCHEMA,GALAXY SCHEMA,FCS
  • SLOWLY CHANGING DIMENSIONS
  • SCD TYPE1,TYPE2,TYPE3
  • FAQ’S

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?
  • Testplan Preparation
  • Testcases Preparation
  • Preparation of Test data
  • Process Of ETL Testing

 

Testing Concepts

  • Whitebox Testing
  • Testing
  • Gray Box Testing
  • Testing
  • Smoke Testing vs Sanity Testing
  • User Testing
  • 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

 


Call on 9347045052 for complete details about the course
courseCourse Enquiry
Web Designing course Fee Enquiry
Name
Email
Phone
Course
Batch Timing?
Training Type?
Country ?
Message