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

SQL Basics

• Relational Model
• Normalization
• DDL Commands
• DML Commands
• Joins
• Functions
• Cursor
• Procedures

Data Warehousing Basics

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

BI Basics

• Evolution and Need
• Data Mining
• Data Reconciliation
• ETL Process
• ETL Transformations
• ETL Testing Types

BI Test Design

• Test Design
• BI Test Scenarios
• BI Reports Testing Scenarios
• BI Testing Challenges
• BI Testing Requirements Gathering
• BI Testing High Level Design
• BI Testing Low level Design

BI Test Execution

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

BI Functional Testing

• What is BI Functional Testing
• BI Testing for Data Accuracy
• BI Testing for Metadata
• BI Testing for Data Transformations
• BI Testing for Data Quality
• BI Testing for Data Completeness

Adhoc Report Testing

• What is Adhoc Report Testing
• Subject Area Design Check
• Mapping Check
• Joins Check

BI Security Testing

• What is BI Security Testing
• Report Access Security
• Data Security (or Position based Security)
• Single Sign-on Security
• Integrated Security

BI Regression Testing

• What is BI Regression Testing
• Reference Data Testing
• Incremental BI Testing

BI Stress Testing

• What is BI Stress Testing
• BI Testing for Scalability

Apply for Certification

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