...

+91 78994 89468 | 78994 89384

ETL Testing Training in BTM, Marathahalli, Bangalore & Best ETL Testing Training Institutes in Bangalore

About ETL Testing Training

Techie Zone is a leader in Providing ETL Testing Training Courses located in BTM Layout, Bangalore based on real-time scenarios and placement oriented topics. Our ETL Testing training course covers basic to advanced levels. Our team consists of highly qualified and certified trainers who are working professionals with hands on real time ETL Testing projects knowledge. This  which will provide you an edge over other training institutes.

We provide certification training programs in ETL Testing Training. We have successfully trained and provided placement for many of our students in major MNC Companies, after successful completion of the course. We provide placement support for our students. Our ETL Testing training center is well equipped with lab facilities and excellent infrastructure for providing you real time training experience.

Techie Zone provides regular training classes(day time classes), weekend training classes, and fast track training classes for ETL Testing Training in our Training Centers located in BTM Layout, Bangalore. Students can Enroll and start attending classes as well as practice sessions in the labs without effecting their regular college or office work. We also provide Online Training Classes for ETL Testing Training Course.

Our team of experts at Techie Zone Training Institute, Bangalore have designed our ETL Testing Training course content and syllabus based on students requirements to achieve everyone's career goal.  Our ETL Testing Training course fee is economical and tailor-made based on training requirement.
 
Contact us today to schedule a free demo and complete course details on ETL Testing Training Course.


ETL Testing Training Course Content

ETL Testing training course content and Syllabus in Bangalore
ETL Testing 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
  • 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



Reviews for ETL Testing Training Course

No Reviews for this Course Yet.. Be the First to Review?

Interview Questions

No Interview Questions Found..

Quick Contact