etl testing training | etl testing training in bangalore

www.tekclasses.com +91-8970005497/+91-7411642061 [email protected] / [email protected]

ETL TESTING TRAINING

DURATION 35hrs

AVAILABLE BATCHES WEEKDAYS (6.30AM TO 7.30AM) & WEEKENDS (6.30pm TO 8pm)

MODE OF TRAINING AVAILABLE

ONLINE INSTRUCTOR LED CLASSROOM TRAINING (MARATHAHALLI, BANGALORE)

SELF PACED VIDEOS

No. 249, 3rd Floor, Chirag Towers, Outer Ring Road, Marathahalli,

Bangalore – 560037 Landmark – Next to Kalamandir Showroom

Email Contact Number Website [email protected] +91-7411642061 www.tekclasses.com [email protected] +91-8970005497


If you are looking for ETL Testing Training, then Tek Classes is the right place to get the knowledge. Learn

the most fundamental skills of ETL Testing and kick start your growth!!

Course Overview

ETL testing is a concept which can be applied to different tools and databases in information

management industry. The objective of ETL testing is to assure that the data that has been loaded from

a source to destination after business transformation is accurate. It also involves the verification of data

at various middle stages that are being used between source and destination. ETL Testing Training

Course is designed for beginners to advanced Professionals. The course includes the following topics –

Introduction to ETL Testing, OLTP vs. OLAP, Introduction to RDBMS, Database Testing Vs Data

Warehouse Testing, Data Warehouse Workflow and Case Study, Data Checks using SQL and Scope of BI

testing.

Modes of Training: Tek Classes offer ETL Testing training in classroom, online and self-paced video modes.

ETL Testing Online Training - Tek Classes offer ETL testing online training through various online

technologies like Gotomeeting and Webex. These classes are affordable and are for those who are

working professionals. ETL Online training gives you the freedom of attending the session from the

comfort of your home or office. Take the benefits of ETL Testing online training and upgrade your career

into ETL Testing!

ETL Testing Training in Bangalore - Tek Classes is one of the best ETL Testing training institutes in

Bangalore. Our customized sessions on ETL Testing training in Bangalore, Marathahalli; is the best way

to gain hands-on experience and real time knowledge. Get training from the best and experienced

trainers who are specialists in ETL training in Bangalore.

Learn ETL Testing Online through Videos - Tek Classes also offering ETL Testing tutorials through self-

paced videos. Learn ETL Testing Online through our self paced videos which is focused on the concepts,

webinars, case studies, and much more. Our ETL Testing online course gives you the kind of flexibility to

learn from where ever you want. Take this course and upgrade your knowledge on ETL Testing.


Retrieving Data using the SQL SELECT Statement

• Capabilities of the SELECT statement • Arithmetic expressions and NULL values in the SELECT statement • Column aliases • Use of concatenation operator, literal character strings, alternative quote operator, and the

DISTINCT keyword • Use of the DESCRIBE command

Restricting and Sorting Data

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

Using Single-Row Functions to Customize Output

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

Using Conversion Functions and Conditional Expressions

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

Reporting Aggregated Data Using the Group Functions

• Group Functions • Creating Groups of Data • Restricting Group Results

Displaying Data from Multiple Tables Using Joins

• Introduction to JOINS • Types of Joins

Using Sub queries to Solve Queries

• Introduction to Sub queries • Single Row Sub queries • Multiple Row Sub queries


Using the SET Operators

• Set Operators • UNION and UNION ALL operator • INTERSECT operator • MINUS operator • Matching the SELECT statements • Using ORDER BY clause in set operations

Managing Tables using DML statements

• Data Manipulation Language • Database Transactions

Introduction to Data Definition Language

• Data Definition Language

Introduction to Data Dictionary Views

• Introduction to Data Dictionary • Describe the Data Dictionary Structure • Using the Data Dictionary Views • Querying the Data Dictionary Views

Creating Sequences, Synonyms, Indexes

• Overview of sequences • Overview of synonyms • Overview of indexes

Creating Views

• Overview of views

Retrieving Data by Using Sub queries

• Retrieving Data by Using a Subquery as Source • Working with Multiple-Column subqueries • Using Scalar subqueries in SQL • Correlated Subqueries • Working with the WITH clause • Analytical Functions


DATAWAREHOUSE BASICS

• What is Datawarehouse? • What is Business Intelligence? • Online Transaction Processing System (OLTP) • OLTP Vs Datawarehouse (OLAP) • Architecture of Datawarehouse • Data mart • Top Down (Immon) Vs Bottom Up (Kimball) • ROLAP, MOLAP and HOLAP

DATA MODELING

• What is data Model? • E-R Modeling • Dimensional Modeling • Dimension table • Fact Table • SURROGATE KEY • SCD Type 1 • SCD Type 2 • SCD Type 3 • Types Measures or Facts or Metrics • What is Schema? • STAR Schema • SNOWFLAKE SCHEMA • Confirmed Dimension • Junk Dimension • Degenerated Dimension • Types of Fact Tables • Fact less fact

ETL Testing

Introduction

• What is ETL Testing? • Responsibilities of a ETL Tester

ETL Testing Methodologies

• Smoke Testing • Functional Testing • System Testing • Regression Testing • Performance Testing • ETL Testing Work Flow Process • How to Prepare the ETL Test Plan • How to design the Test cases in ETL Testing.


• How to reporting the Bugs in ETL Testing? • ETL Testing Responsibilities • How to detect the bugs through database queries

ETL Testing with Informatica PowerCenter

• SAMPLE Loading from source to target • Testing Heterogeneous Sources • SORTER Transformation • FILTER Transformation • ROUTER Transformation • EXPRESSION Transformation • JOINER Transformation • UNION Transformation • AGGREAGATOR Transformation • RANK Transformation • SEQUENCE GENERATOR Transformation • Flat File • Look up Transformation • SCD type 1 • SCD Type 2 • SCD Type 3 • Update Strategy • XML Source Qualifier • Types of load (Full, incremental, Refresh)

BI Testing with OBIEE:

• Preparing BI Test cases • Data validation with OBIEE • UI Testing with OBIEE


Who can take this course

Business Intelligence Professionals or ETL Developers, Manual Testers, Professionals aspiring to become

ETL Testing Professionals, Project Managers, Database Professionals, Mainframe Professionals, SQL

Developers

Prerequisite

• Quick understanding of SQL concepts

• Knowledge on Software Testing Life Cycle

Key-Takeaways

• 30 Hours of training with Lab Exercises

• Lab exercises for each module.

• Well-Experienced and Real Time Trainers

• Best in Class Infrastructure

• Real time case studies and project integrated into the Curriculum

• 24*7 Support from our team of administrators

• Course Material and Lab guides for students reference

• Placement assistance for those who are looking out for a career in ETL Testing

Trainer Profile

• 10+ Years of Industry Experience

• 6+ Years of experience in ETL Testing and Development

• Excellent Communication Skills

• Trained more than 800+ students

• A cogent speaker and a lucid communicator

• Good at providing real time examples and practical scenarios while explaining concepts.

• Possess positive attitude and ability to meet customer requirements

etl testing training | etl testing training in bangalore

Technology