etl testing online training in hyderabad

Introduction to etl/dwh testing training course:

LEADARCHER offers real-time and placement focused ETL testing training in Hyderabad. Our data warehousing ETL testing course includes fundamental to advanced level and our ETL testing course is intended to get the placement in good MNC companies in Hyderabad as rapidly as once you complete the ETL testing certification training course. Our ETL testing instructors are data warehousing ETL testing certified experts working professionals with real time multiple ETL Testing projects knowledge. We have intended our ETL testing course content and syllabus based on students constraint to achieve everyone's career goal.

Our data warehousing ETL testing training centers are capable of lab facilities and outstanding infrastructure. We also offer data warehousing ETL testing certification training conduit for our students in Hyderabad. Our data warehousing ETL testing course charge is worth for money and custom-made course fee based on the all student's training requirements. ETL testing training in Hyderabad is conducted on day time classes, evening batch classes, weekend training classes, and fast track training classes.

Course Content for etl/dwh testing training:

LEADARCHER includes all the concepts in actual time with live situations Oracle Basics & Concepts, DWH Concepts, ETL Testing Concepts, Testing Concepts, ETL Tool and Testing and practice in real time.

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
  • 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
  • SDLC vs STLC
  • Reverse Engineering
  • QC(Quality Center and BugZilla)
  • Roles and Responsibilities
  • Minus,Duplicate,Count,Intersection
  • 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 and FAQ’s