ETL Testing Training
ETL Stands for Extract Transform and Load. ETL tools will integrate various kind of data format into the desired data. ETL tools will support different type of vendors with different software. In addition, ETL tools will do the transformation of data within systems involving complex business rules. Various ETL tools are available in market like Informatica, Microsoft SSIS, Clover, Oracle Warehouse Builder, etc.,
ETL will perform the following operations
- Extraction of data from various sources
- Transformation of data involves following activities
- Cleansing the existing data
- Standardizing the data
- Reformatting the data
- Aggregation of data
- Applying complex business rules with existing data
- Transformed data will be loaded into the desired data format
ETL Training Placement
- Students will get 100% placement assistance from Hope Tutors until they get placed
Best Online ETL Testing Training
Hope Tutors is well equipped with the latest infrastructure and experienced trainers to provide Online ETL Training.
Contact us today to know more about our ETL Testing Training and schedule a free demo class.
Related Testing Courses
Course Curriculum
ETL Testing - Concepts | |||
Test plan & Testing strategy in data warehousing | 00:00:00 | ||
Report testing and Data warehousing testing | 00:00:00 | ||
Testing plan | 00:00:00 | ||
Test cases possibilities in Data warehousing | 00:00:00 | ||
HP ALM and HP QC – Defect raising and re-testing | 00:00:00 | ||
Basic DATABASE Concept and SQL | |||
Basic history of database concept: DBMS, RDBMS, ORDBMS | 00:00:00 | ||
SQL Language overview : DQL, DML, DDL, DCL, TCL | 00:00:00 | ||
Data Manipulation Language DML and Transaction Control Language TCL | |||
DML : INSERT, UPDATE, DELETE, MERGE | 00:00:00 | ||
TCL : COMMIT, ROLLBACK, SAVEPOINT | 00:00:00 | ||
Data Definition Language - DDL | |||
DDL : CREATE, ALTER, RENAME, DROP, TRUNCATE | 00:00:00 | ||
DEFAULT OPTION. | 00:00:00 | ||
Restricting and Sorting Data | |||
WHERE Clause – Character Strings and Dates, number | 00:00:00 | ||
General Comparison Conditions = > >= < <= <> | 00:00:00 | ||
Other Comparison BETWEEN , IN , LIKE , NULL | 00:00:00 | ||
Logical Conditions AND OR NOT | 00:00:00 | ||
ORDER BY Clause, Sorting by Column Alias , Column Position, Multiple Columns | 00:00:00 | ||
Constraints | |||
NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK | 00:00:00 | ||
Column Level Constraint, Table Level Constraint – Naming constraints and usage | 00:00:00 | ||
Adding a Constraint, Dropping a Constraint, | 00:00:00 | ||
Disabling Constraints, Enabling Constraints | 00:00:00 | ||
Validating Constraints | 00:00:00 | ||
Single-Row Functions | |||
Character Functions: UPPER, LOWER, INITCAP, LENGTH, SUBSTR, INSTR, LPAD, RPAD, CONCAT, LTRIM, RTRIM, TRIM, REPLACE, TRANSLATE, REVERSE | 00:00:00 | ||
Number Functions: ROUND, TRUNC, MOD, POWER, CEIL , FLOOR, ABS | 00:00:00 | ||
Dates Functions: SYSDATE, MONTHS_BETWEEN, NEXT_DAY, LAST_DAY, ADD_MONTHS, ROUND, TRUNC, Arithmetic on Date | 00:00:00 | ||
Conversion Functions: Implicit Data-Type Conversion & Explicit Data-Type Conversion, TO_CHAR ,TO_NUMBER ,TO_DATE | 00:00:00 | ||
General Functions: NVL , NVL2 , NULLIF, COALESCE | 00:00:00 | ||
CASE Expression, DECODE | 00:00:00 | ||
Nested function with real-time usage | 00:00:00 | ||
JOINS | |||
EQUI JOIN / SIMPLE JOIN / NORMAL JOIN | 00:00:00 | ||
ANSI JOIN, LEFT OUTER, RIGHT OUTER, FULL OUTER | 00:00:00 | ||
INNER JOIN, JOIN … USING clause, JOIN … ON clause, | 00:00:00 | ||
CROSS JOIN, NON-EQUI JOIN, SELF JOIN | 00:00:00 | ||
ORACLE STANDARD OUTER JOINS. | 00:00:00 | ||
Multi table Joins, Complex Joins – How to simplified complex joins. | 00:00:00 | ||
Multi-row Functions | |||
Group Functions Rules, SUM, MIN, MAX, COUNT, AVG | 00:00:00 | ||
Creating Groups of Data: GROUP BY Clause | 00:00:00 | ||
Filtering Group Results: The HAVING Clause | 00:00:00 | ||
Sub-queries | |||
Single-Row Subqueries- Rules, Operators : = > >= < <= <> | 00:00:00 | ||
Null Values in a Subquery | 00:00:00 | ||
Multi-Row Subqueries- Rules, Operators : IN, ANY , ALL | 00:00:00 | ||
Views | |||
Simple Views and Complex Views – Create, Drop | 00:00:00 | ||
Rules for Performing DML Operations on a View | 00:00:00 | ||
Inline Views | 00:00:00 | ||
Materialized View – Create, Refresh, Drop – Usage | 00:00:00 | ||
Other Database Objects | |||
Sequence- NEXTVAL and CURRVAL | 00:00:00 | ||
Index | |||
Index – When to Create an Index, When Not to Create an Index. | 00:00:00 | ||
Synonyms | |||
Synonyms | 00:00:00 | ||
SET Operators | |||
UNION | 00:00:00 | ||
UNION ALL | 00:00:00 | ||
INTERSECT | 00:00:00 | ||
MINUS | 00:00:00 | ||
Advanced Date-time Functions | |||
TIME ZONES | 00:00:00 | ||
SYSDATE, SYSTIMESTAMP | 00:00:00 | ||
CURRENT_DATE , CURRENT_TIMESTAMP | 00:00:00 | ||
SESSIONTIMEZONE | 00:00:00 | ||
TO_YMINTERVAL | 00:00:00 | ||
TO_TIMESTAMP , numtodsinterval, cast, compose, decompose | 00:00:00 | ||
Analytic Functions | |||
WM_CONCAT, LAG, LEAD, RANK, DENSE_RANK | 00:00:00 | ||
Query_by partition_clause with sum, min, max, avg, count | 00:00:00 | ||
order_by_clause with sum, min, max, avg, count | 00:00:00 | ||
Data warehouse Concepts | |||
Business Intelligence | 00:00:00 | ||
Data Warehousing Concepts (What/Why/How) | 00:00:00 | ||
Data Modeling (Schemas, FACTS and DIMENSIONS) | 00:00:00 | ||
Data Mart | 00:00:00 | ||
Metadata | 00:00:00 | ||
OLAP VS OLTP | 00:00:00 | ||
Dimension | 00:00:00 | ||
Fact | 00:00:00 | ||
Types of Dimension tables | 00:00:00 | ||
Types of Fact tables | 00:00:00 | ||
Star Schema | 00:00:00 | ||
Snowflake Schema | 00:00:00 | ||
Slowly Changing Dimensions | 00:00:00 | ||
Top down and Bottom up approach | 00:00:00 | ||
E T L Informatica Power Center 9.X.X | |||
Why do we need ETL tool and Why Informatica? | 00:00:00 | ||
Introduction to Informatica | |||
Introduction | 00:00:00 | ||
Getting started | 00:00:00 | ||
Informatica Suite Components | 00:00:00 | ||
Informatica Architecture | 00:00:00 | ||
Informatica Server | 00:00:00 | ||
Informatica Power Center Client Components | |||
Repository Manager | 00:00:00 | ||
Designer | 00:00:00 | ||
Workflow Manager | 00:00:00 | ||
Workflow Monitor | 00:00:00 | ||
Informatica Building Blocks | |||
Source & Targets | 00:00:00 | ||
Transformations | 00:00:00 | ||
Mappings | 00:00:00 | ||
Mapplets | 00:00:00 | ||
Sessions | 00:00:00 | ||
Workflows | 00:00:00 | ||
Sources | |||
Working with Relational Source | 00:00:00 | ||
Working with Flat file Source | 00:00:00 | ||
Working with heterogeneous sources | 00:00:00 | ||
Targets | |||
Working with Relational Targets | 00:00:00 | ||
Working with Flat file Targets | 00:00:00 | ||
Direct and Indirect file loading | 00:00:00 | ||
Different Transformations | |||
Active and Passive Transformations | 00:00:00 | ||
Connected and un-connected transformations | 00:00:00 | ||
Source Qualifier Transformation | 00:00:00 | ||
Filter Transformation | 00:00:00 | ||
Expression Transformation | 00:00:00 | ||
Sorter Transformation | 00:00:00 | ||
Aggregator Transformation | 00:00:00 | ||
Router Transformation | 00:00:00 | ||
Rank Transformation | 00:00:00 | ||
Sequence Generator Transformation | 00:00:00 | ||
Joiner Transformation | 00:00:00 | ||
Lookup Transformation | 00:00:00 | ||
Connected Lookup | 00:00:00 | ||
Un Connected Lookup | 00:00:00 | ||
Update Strategy Transformation | 00:00:00 | ||
Union Transformation | 00:00:00 | ||
Normalizer Transformation | 00:00:00 | ||
Transaction Control Transformation | 00:00:00 |
Features
FAQ
Course Reviews
2154 STUDENTS ENROLLED
Best training
I Got a real – time knowledge in ETL. My training is full of practical sessions. Thanks Hope Tutors
Best Institute for ETL testing
I completed my ETL Course in Hopetutors . My training is very useful .I got placed in MNC.
Best Institute
I learned ETL training in Hope Tutors. The experience was really useful and good. thanks
My Training Experience in Hope Tutors
The way my trainer explained the concepts is very simple and understandable. End of my training i done a real time project its useful to develop my carrier. Thanks for the useful training.Good experience .
Best training institute for professionals
I am already working in Testing field for my project change i Learn ETL advance concepts in Hope Tutors. Both the trainer and training is real – time one. Useful and one of the best institute for professionals
ETL training
I am new to this testing , but for my project i learn this concepts in Hope Tutors.The training is full of practical with real – time examples. My trainer really a stuffed guy. Thanks
good experience
I am a automation tester for my onsite project i learn ETl , Really nice experience. Fast track classes but trainer support me a lot during training.thanks Hope
Useful Training
Hope Tutors give me a good and quality training for ETL. Really useful and lot of new concepts i learned thanks
Best Training institute
One of the best institute for ETL .Trainer really support me and help me to complete my project. good experience
Best Trainer and Training institute
I search lot of institute for my training finally i got a best trainer and training institute . Hope Tutors really give me a good and practical oriented training.
Best trainer For my training in Hope tutors
Thanks for my trainer kumar for the best training he gived. the training was very useful and informative one. He explained a lot of new concepts .