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…

0 STUDENTS ENROLLED

    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

    TAKE THIS COURSE
    • $200.00 per 12 months
    • week, 3 days

    Subscribe

    Member Testimonials

    Reena Rani

    This is Reena here from MOST IV Batch. Thank you so much for providing the wonderful and awesome training on View Full →
    2015-06-24T15:20:16+00:00
    This is Reena here from MOST IV Batch. Thank you so much for providing the wonderful and awesome training on View Full →

    Nimmi Srivastava

    It has been a tremendous knowledgeable journey for me while I was going through the Selenium course. No doubt, I’ve View Full →
    2015-06-24T15:31:04+00:00
    It has been a tremendous knowledgeable journey for me while I was going through the Selenium course. No doubt, I’ve View Full →

    Lenora (US)

    Thank you for reaching out to me in reference to training. I am greatly interested because I am so inspired View Full →
    2015-03-05T20:29:06+00:00
    Thank you for reaching out to me in reference to training. I am greatly interested because I am so inspired View Full →

    Prakash Kosana

    My experience so far related to my training is awesome. I really love the way Karthik teaching. He absolutely come View Full →
    2015-07-02T16:28:51+00:00
    My experience so far related to my training is awesome. I really love the way Karthik teaching. He absolutely come View Full →

    Anuradha Velpuri

    I was impressed by the quality, content and very impressed with Mr. Shanker’s knowledge. We learned all the terminology, test View Full →
    2015-06-24T15:36:43+00:00
    I was impressed by the quality, content and very impressed with Mr. Shanker’s knowledge. We learned all the terminology, test View Full →
    Main Menu