Training Content
Placement Whatsapp
ONLINE ADVANCE ETL TESTING TRAINING IN SINGAPORE

ETL Testing Online Training Provided by webdesignerssingapore with Our Professionals has 5+ years of IT experience in ETL Testing arena and was involved in global Implementation. We blend our ETL Testing course with the right kind of real-time exposure that gives the much needed advantage for their careers. Through our own industry network, students will get advantage of complete 100% ETL Testing training. We will provide technical support for your Interviews.

websitedesigningsingapore is a freelance online advance etl testing training in singapore, advance etl testing training in singapore, advance etl testing training institute in singapore, advance etl testing training course in singapore, advance etl testing training with live project in singapore, best advance etl testing training institute in singapore, online etl testing training in singapore.

Please contact on my mobile/Whatsapp 91-9347045052 for any web designing , ui designing, logo design, banner design and website upgrade work. Email me at info@websitedesigningsingapore.com to Know course and support. Add my Skype id (purnendu_ranjan) to discuss further.

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

 

 
Why Training With Us
GET IN TOUCH
Trending training
main Training
Students Placement
Placement
Placement Assistent
Live Project Training
Placement in MNC
100% Job Assistance

Our Training

  • magento
  • PHP
  • wordpress
  • phpMysql
  • drupal
  • magento
  • PHP
  • wordpress
  • phpMysql
  • drupal
  • magento
  • PHP
  • wordpress
  • phpMysql
  • drupal
  • magento
  • PHP
  • wordpress
  • phpMysql
  • drupal