ETL Testing Online Training

 >>  ETL Testing Online Training

ETL Testing Online Training


 (4.9) | 750 Ratings


Introduction


ETL Testing Online Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

ETL Testing Online Training Modules

Module 1: Data Warehousing Concepts

Topics: Introduction to Dataware House, Need for DWH, DWH Architecture, DM VS DWH, Data Mart and Types, Data Cleansing, Data Scrubbing, Normalization, STG Area, DSS, Dimention Modeling, Aggregates, ODS, SCD Types, Initial, Incremental and Full Load, Change Data Capture

Module 2: Oracle Basics & Concepts

Topics: DBMS, RDBMS, Difference between DBMS and RDBMS, Why Database Required?, Different types of databases and difference, Oracle Architecture, Diff B/W Database & Files, PL/SQL Basics, Basic Admin Activities, Inner Query, Outer Query, Referential Integrity, Performance Tuning, Database Schema, Partitioning,

Module 3: ETL Testing Concepts

Topics: Overview of ETL, ETL ARCHITECTURE, Types of ETL Tools, SDLC vs STLC, Reverse Engineering, Roles and Responsibilities, Detect Defects, Defects Logging and Reporting, Types of Tuning and Testing, Test plans Preparation, Preparation of Test data, Process Of ETL Testing, Test cases Preparation

Module 4: Testing Concepts

Topics: Understanding the Types of Testing, UAT, Smoke Testing vs Sanity Testing

Module 5: Software development life cycle:

Topics: Waterfall Model, Agile Model, V-model & Methodology

Module 6: ETL Tool And Testing

Topics: Importance of ETL Testing, Data Extract, Data Load, Import Source, Import Target, Data Transform, Import and Export, Queries Preparation Based on Transformations, Coping and Rules Rules and Techniques, Analyzing of Mappings, Analyzing of Workflows and Worklets, Mappings, Sessions, Maplets, Functionalities, Transformations

Module 7: Test Process Implementation

Topics: Introduction to Software Testing and Quality, Defect Management, Software Life Cycle Stages and Development Models, ETL Testing Techniques, Software Quality Assurance Standards, User Acceptance Testing, Defect Severities and Priorities, Defect management, defect resolution process, Testing Terminologies, Test measurement Techniques and Metrics Collection, Test Planning Design and Execution

Module 8: Other Advantages

Topics: Real-time Scenarios, Use of UNIX Commands, Deployment Process, Backend Testing Using SQL

Exam & Certification

0

Course Review

(4.9)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

ETL Testing Online Training Modules

Module 1: Data Warehousing Concepts

Topics: Introduction to Dataware House, Need for DWH, DWH Architecture, DM VS DWH, Data Mart and Types, Data Cleansing, Data Scrubbing, Normalization, STG Area, DSS, Dimention Modeling, Aggregates, ODS, SCD Types, Initial, Incremental and Full Load, Change Data Capture

Module 2: Oracle Basics & Concepts

Topics: DBMS, RDBMS, Difference between DBMS and RDBMS, Why Database Required?, Different types of databases and difference, Oracle Architecture, Diff B/W Database & Files, PL/SQL Basics, Basic Admin Activities, Inner Query, Outer Query, Referential Integrity, Performance Tuning, Database Schema, Partitioning,

Module 3: ETL Testing Concepts

Topics: Overview of ETL, ETL ARCHITECTURE, Types of ETL Tools, SDLC vs STLC, Reverse Engineering, Roles and Responsibilities, Detect Defects, Defects Logging and Reporting, Types of Tuning and Testing, Test plans Preparation, Preparation of Test data, Process Of ETL Testing, Test cases Preparation

Module 4: Testing Concepts

Topics: Understanding the Types of Testing, UAT, Smoke Testing vs Sanity Testing

Module 5: Software development life cycle:

Topics: Waterfall Model, Agile Model, V-model & Methodology

Module 6: ETL Tool And Testing

Topics: Importance of ETL Testing, Data Extract, Data Load, Import Source, Import Target, Data Transform, Import and Export, Queries Preparation Based on Transformations, Coping and Rules Rules and Techniques, Analyzing of Mappings, Analyzing of Workflows and Worklets, Mappings, Sessions, Maplets, Functionalities, Transformations

Module 7: Test Process Implementation

Topics: Introduction to Software Testing and Quality, Defect Management, Software Life Cycle Stages and Development Models, ETL Testing Techniques, Software Quality Assurance Standards, User Acceptance Testing, Defect Severities and Priorities, Defect management, defect resolution process, Testing Terminologies, Test measurement Techniques and Metrics Collection, Test Planning Design and Execution

Module 8: Other Advantages

Topics: Real-time Scenarios, Use of UNIX Commands, Deployment Process, Backend Testing Using SQL

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry