Essentials of Data Warehouse/ETL Testing (Level 1)
Audience
The course is appropriate for both Novice and Experienced Software Engineers under the following category:
- Test Engineers
- Quality Assurance Specialists
- Project / Test Leads
- Participants are expected to have basic knowledge on software testing.
- Participants are expected to have basic knowledge on software testing.
Objectives
After the completion of the course, the participants would be able to::
- 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
Course duration
20 Hours
Course outline
Introduction to Class
- Participants
- Familiarization with course material
- Familiarization with the protocols and timings
- Expectation setting and clarifications
Understanding Data Base Concepts and Online Transaction Processing(OLTP)-2 Hours
- 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
- Hands on Excises
Understanding Data Warehouse Concepts(OLAP) - 2 Hours
- Need/Business Drivers Data warehouse
- Data Warehouse- Characteristics
- Data Modelling - Fact , Dimensions, Star , Snowflake Schemas
- Design and Building - Fact and Dimensional Modelling - A CASE STUDY
Understanding Extract, Transform and Load(ETL) - 3 Hours
- Introduction to ETL and its Components
- Landing Zone
- Data Profiling
- Data Quality /Reconciliation
- Transformation Rules
- Staging Databases
- Loading to Reporting/Final Data Warehousing
- A CASE STUDY
Introduction to Test Case ,Test Design - Different Type of Testing - 3 Hours
- 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
Case Study and Hands On - 10 Hours
- Test case design based on mapping and business rulesdocument
- Test Execution
- Test Reporting
- Summary and Learing
- ETL TOOLS
- Introduction to ETL TOOLS
- A Sample Case Study for AN ENTERPRISE DATAWARE HOUSE PROCESS
