Call Us: +91-9000011489

Register for Free Demo

Database Testing Concepts:

  •  What is Database Testing
  •  Database Testing Architecture
  •  Stages involved in Database Testing
  •  Fundamentals of Database Testing
  •  Components of the database

SQL

  • Introduction to SQL
  •  DDL Statements
  •  DML Statements
  •  DCL Statements
  •  SQL Operators, Triggers, Cursors, Sequences & Indexes
  •  Sub Queries and Joins
  •  Union, Intersect and Minus
  •  Views, Stored Procedures & Functions
  •  100 SQL Queries Hands on

Data Warehousing Concepts:

  • What is Data and the Types of Data?
  •  Introduction of Data Warehouse
  •  Data Warehouse Architecture
  •  Data Extraction
  •  Data Transformation and Types of Transformations
  •  Data Loading
  •  Characteristics of Data Warehouse
  •  What is OLTP
  •  What is OLAP
  •  Difference between OLTP & OLAP
  •  What is Meta Data?
  •  Differences between DB Testing & DWH Testing
  •  DWH Challenges

Data Marts:

  •  What is Data Mart and How it is different from a data warehouse
  •  Types of Data Marts
  •  Reasons for building a Data Mart
  •  Advantages & Disadvantages of a Data Mart
  •  Data warehouse vs. Data mart

Dimensional Modeling:

  •  What is Dimensional Modeling and why it is important?
  •  Dimensional Model architecture
  •  Attribute
  •  Hierarchy
  •  What is Fact table and its purpose?
  •  What is Dimension table and its purpose?
  •  Granularity or Grain of Fact Table
  •  Primary key
  •  Surrogate Key
  •  Look Up Table
  •  ER Modeling Vs. Dimensional Modeling
  •  Normalization

 

SCD (Slowly Changing Dimension:

  • What is SCD (Slowly Changing Dimension?
  •  SCD Type 1
  •  Advantages & Disadvantages of SCD1
  •  SCD Type 2
  •  Advantages & Disadvantages of SCD2
  •  SCD Type 3
  •  Advantages & Disadvantages of SCD3

Schema Models:

  • Types of Schema Models
  •  Star Schema Model
  •  Advantages & Disadvantages of Star Schema Model
  •  Snow Flake Schema Model
  •  Advantages & Disadvantages of Snow Flake Schema Model
  •  Constellation or Mixed or Galaxy Schema model.

DW Design Methodologies:

  • Inmon’s Design Methodology
  •  Advantages & Disadvantages
  •  Kimball’s Design Methodology
  •  Advantages & Disadvantages

Data Modeling:

  •  What is Data Modeling?
  •  Types of Data Models
  •  Conceptual Data Model
  •  Logical data Model
  •  Physical Data Model
  •  Types of Facts

Life Cycle of the Data Warehouse Project:

  •  Life Cycle of Data Warehouse Project in the real world
  •  DWH/ETL Process

Data Warehouse Testing Phases:

  •  Data Warehouse Testing Phases and phase wise Testing Activities

ETL Testing Concepts:

  • What is ETL Testing?
  •  Role of ETL in a Data Warehouse
  •  Popular ETL tools
  •  ETL Testing Goals
  •  Full Load & Delta Load

Types of testing techniques in ETL:

  • Count Checks
  •  Minus Query
  •  Look up Query
  •  Default Checks
  •  Null Checks
  •  Audit Table checks

ETL Tester Roles & Responsibilities:

  • White box testing
  •  Black box testing
  •  ETL Test Strategy Document Preparation
  •  ETL Test Plan Document Preparation
  •  Test data Preparation
  •  How to design the Test cases in ETL Testing.
  •  How to report the Bugs in ETL Testing?

ETL Tool: Informatica

  •  Introduction to Informatica
  •  Informatica Product Line
  •  Architecture of Informatica
  •  Informatica PowerCenter Client Tools
  •  What is Transformation and different types of Tranformations
  •  Aggregator Transformation
  •  Custom Transformation
  •  Expression Transformation
  •  External Procedure Transformation
  •  Filter Transformation
  •  HTTP Transformation
  •  Input Transformation
  •  Java Transformation
  •  Joiner Transformation
  •  Lookup Transformation
  •  Output Transformation
  •  Rank Transformation
  •  Reusable Transformation
  •  Router Transformation
  •  Sequence Generator Transformation
  •  Sorter Transformation
  •  Source Qualifier Transformation
  •  SQL Transformation
  •  Stored Procedure Transformation
  •  Union Transformation
  •  Update Strategy Transformation
  •  XML Generator Transformation
  •  XML Parser Transformation
  •  XML Source Qualifier Transformation
  •  External Transformation

ADD on’s :

    •  Real-time Scenario’s using Dim & Fact Tables( ETL Testing using Informatica tool)
    •  Introduction to OBIEE BI Tool
    •  UNIX Commands
    •  Resume Preparation
    •  Real time Interview Questions