Software Testing Basics

• Scope
• Functional vs. Non-Functional testing
• Defects and failures
• Finding faults early
• Compatibility
• Input combinations and preconditions
• Static vs. dynamic testing
• Software verification and validation
• The software testing team
• Software quality assurance (SQA)
• Testing Methods - The box approach

Data Warehousing Basics

• Introduction to Data Warehousing
• Data Warehousing Characteristics
• OLAP and OLTP
• Data Warehousing Architecture
• Data Models
• Data Schemas (Star and Snow Flake )

SQL Basics

• Relational Model
• Normalization
• DDL Commands
• DML commands
• Joins
• Functions
• Cursors
• Procedures

ETL Testing Basics

• ETL Process
• ETL Transformations
• ETL Testing Types

ETL Test Design

• ETL Testing Challenges
• ETL Testing Requirements Gathering
• ETL Testing High Level Design
• ETL Testing Low level Design

ETL Test Execution

• Unit Testing
• Integration Testing
• ETL Test Development
• ETL Testing Defects
• Defects Reporting

ETL Testing Tools

• Talend Open Studio
• Informatica Powercenter
• Pentaho Kettle
• Cloud based Tools

Apply for Certification

https://www.vskills.in/certification/testing/etl-testing-certification