Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

ETL Testing Essentials

( Duration: 2 Days )

This ETL Testing Essentials training course provides skills to learn, experiment and implement the concepts involved in ETL/Data Warehouse Testing. You will be presented with ample examples, exercises and case studies to understand and apply the concepts taught.

By attending ETL Testing Essentials workshop, delegates will:

  • Review the fundamental concepts of data warehousing and its place in an information management environment
  • Learn about the role of the testing process as part of software development and as part of data warehouse development
  • Learn about test strategies, test plans and test cases - what they are and how to develop them, specifically for data warehouses and decision support systems
  • Create effective test cases and scenarios based on business and user requirements for the data warehouse
  • Plan and coordinate usability testing for data warehousing
  • Conduct reviews and inspections for validation and verification
  • Participate in the change management process and document relevant changes to decision support requirements

  • Basic knowledge on software testing

ETL Testing Essentials class is appropriate for both Novice and Experienced Software Engineers under the following category:

  • Test Engineers
  • Quality Assurance Specialists
  • Project / Test Leads

COURSE AGENDA

1

Understanding Data Base Concepts and Online Transaction Processing(OLTP)

  • Introduction OLTP-Databases Modelling Concepts
  • ERD - Entity Relationship Diagrams
  • Logical and Physical Schema for Database Design
  • Database Constraints - Primary , Foreign Key , Unique Keys, Surrogate Keys
  • Advanced SQL Statements
  • Views and Materialized Views
  • Meta Data and Operational Data
2

Understanding Data Warehouse Concepts(OLAP)

  • Need/Business Drivers Data warehouse
  • Data Warehouse - Characteristics
  • Data Modelling - Fact , Dimensions, Star , Snowflake Schemas
3

Understanding Extract, Transform and Load(ETL)

  • Introduction to ETL and its Components
  • Landing Zone
  • Data Profiling
  • Data Quality / Reconciliation
  • Transformation Rules
  • Staging Databases
  • Loading to Reporting/Final Data Warehousing
4

Introduction to Test Case ,Test Design - Different Type of Testing

  • Understanding of Data Transformation, Mapping and Business Rules
  • Understanding of Data Centric Testing
  • Test Case and Test Design Methodology
  • Categorization of Testing based on objectives of testing and reporting
  • Database testing and data Warehouse Testing - A comparision
  • Testing Approach, planning and Strategy
5

ETL TOOLS

  • Introduction to ETL TOOLS

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X