Setup Menus in Admin Panel

ITeLearn.com

ETL Testing Course Content

ETL Testing Course Content

Chapter 1 : Retrieving Data using the SQL SELECT Statement

  • 1.1 Capabilities of the SELECT statement
  • 1.2 Arithmetic expressions and NULL values in the SELECT statement
  • 1.3 Column aliases
  • 1.4 Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
  • 1.5 Use of the DESCRIBE command

Chapter 2 : Restricting and Sorting Data

  • 2.1 Limiting the Rows
  • 2.2 Rules of precedence for operators in an expression

Chapter 3 : Using Single-Row Functions to Customize Output

  • 3.1 Describe the differences between single row and multiple row functions
  • 3.2 Manipulate strings with character function in the SELECT and WHERE clauses
  • 3.3 Manipulate numbers with the ROUND, TRUNC and MOD functions
  • 3.4 Perform arithmetic with date data
  • 3.5 Manipulate dates with the date functions

Chapter 4 : Using Conversion Functions and Conditional Expressions

  • 4.1 Describe implicit and explicit data type conversion
  • 4.2 Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • 4.3 Nest multiple functions
  • 4.4 Apply the NVL, NULLIF, and COALESCE functions to data
  • 4.5 Use conditional IF THEN ELSE logic in a SELECT statement

Chapter 5 :Reporting Aggregated Data Using the Group Functions

  • 5.1 Group Functions
  • 5.2 Creating Groups of Data
  • 5.3 Restricting Group Results

Chapter 6 :Displaying Data from Multiple Tables Using Joins

  • 6.1 Introduction to JOINS
  • 6.2 Types of Joins

Chapter 7 : Using Sub queries to Solve Queries

  • 7.1 Introduction to Sub queries
  • 7.2 Single Row Sub queries
  • 7.3 Multiple Row Sub queries

Chapter 8 : Using the SET Operators

  • 8.1 Set Operators
  • 8.2 UNION and UNION ALL operator
  • 8.3 INTERSECT operator
  • 8.4 MINUS operator
  • 8.5 Matching the SELECT statements
  • 8.6 Using ORDER BY clause in set operations

Chapter 9 : Managing Tables using DML statements

  • 9.1 Data Manipulation Language
  • 9.2 Database Transactions

Chapter 10 : Introduction to Data Definition Language

  • 10.1 Data Definition Language

Chapter 11 : Introduction to Data Dictionary Views

  • 11.1 Introduction to Data Dictionary
  • 11.2 Describe the Data Dictionary Structure
  • 11.3 Using the Data Dictionary Views
  • 11.4 Querying the Data Dictionary Views

Chapter 12 : Creating Sequences, Synonyms, Indexes

  • 12.1 Overview of sequences
  • 12.2 Overview of synonyms
  • 12.3 Overview of indexes

Chapter 13 : Creating Views

  • 13.1 Overview of views

Chapter 14 : Retrieving Data by Using Sub queries

  • 14.1 Retrieving Data by Using a Subquery as Source
  • 14.2 Working with Multiple-Column subqueries
  • 14.3 Using Scalar sub-queries in SQL
  • 14.4 Correlated Sub-queries
  • 14.5 Working with the WITH clause
  • 14.6 Analytical Functions

Chapter 15 : DATAWAREHOUSE BASICS

  • 15.1 What is Datawarehouse?
  • 15.2 What is Business Intelligence?
  • 15.3 Online Transaction Processing System (OLTP)
  • 15.4 OLTP Vs Datawarehouse (OLAP)
  • 15.5 Architecture of Datawarehouse
  • 15.6 Data mart
  • 15.7 Top Down (Immon) Vs Bottom Up (Kimball)
  • 15.8 ROLAP, MOLAP and HOLAP

Chapter 16 : DATA MODELING

  • 16.1 What is data Model?
  • 16.2 E-R Modeling
  • 16.3 Dimensional Modeling
  • 16.4 Dimension table
  • 16.5 Fact Table
  • 16.6 SURROGATE KEY
  • 16.7 SCD Type 1
  • 16.8 SCD Type 2
  • 16.9 SCD Type 3
  • 16.10 Types Measures or Facts or Metrics
  • 16.11 What is Schema?
  • 16.12 STAR Schema
  • 16.13 SNOWFLAKE SCHEMA
  • 16.14 Confirmed Dimension
  • 16.15 Junk Dimension
  • 16.16 Degenerated Dimension
  • 16.17 Types of Fact Tables
  • 16.18 Fact less fact

Chapter 17 : ETL Testing

  • 17.1 Introduction
  • 17.2 What is ETL Testing?
  • 17.3 Responsibilities of a ETL Tester

Chapter 18 : ETL Testing Methodologies

  • 18.1 Smoke Testing
  • 18.2 Functional Testing
  • 18.3 System Testing
  • 18.4 Regression Testing
  • 18.5 Performance Testing
  • 18.6 ETL Testing Work Flow Process
  • 18.7 How to Prepare the ETL Test Plan
  • 18.8 How to design the Test cases in ETL Testing.
  • 18.9 How to reporting the Bugs in ETL Testing?
  • 18.10 ETL Testing Responsibilities.
  • 18.11 How to detect the bugs through database queries

Chapter 19 : ETL Testing with Informatica PowerCenter

  • 19.1 SAMPLE Loading from source to target
  • 19.2 Testing Heterogeneous Sources
  • 19.3 SORTER Transformation
  • 19.4 FILTER Transformation
  • 19.5 ROUTER Transformation
  • 19.6 EXPRESSION Transformation
  • 19.7 JOINER Transformation
  • 19.8 UNION Transformation
  • 19.9 AGGREAGATOR Transformation
  • 19.10 RANK Transformation
  • 19.11 SEQUENCE GENERATOR Transformation
  • 19.12 Flat File
  • 19.13 Look up Transformation
  • 19.14 SCD type 1
  • 19.15 SCD type 2
  • 19.16 SCD type 3
  • 19.17 Update Strategy
  • 19.18 XML Source Qualifier
  • 19.19 Types of load (Full, incremental, Refresh)

Chapter 20 : ETL Testing with SSIS

  • 20.1 Packages
  • 20.2 Cubes

Chapter 21 : ETL Testing with DataStage

December 28, 2016
Main Menu