DATAWAREHOUSING ETL TESTING TRAINING ON IN INDIA

1.Module – I (Database/SQL) •Database Overview •DBMS, RDBMS, ORDBMS •Why Database Required •SQL Overview •DDL, DML, DCL, TCL •Data types •SELECT Statement •Restricting and Sorting Data •Aggregating Data using Group Functions •Creating and managing Tables •Manipulating Data •Sub queries •Important Functions •Joins and different types •Views •Index •Synonym •Constraints •Set Operator 2.Module – II (UNIX/LINUX) •Overview of UNIX Operating System •Basic commands and concepts •Command Manuals •Regular Expressions •Input/Output Redirection •Piping •Filter •Details explanation of File Attributes •Job Scheduling •Archive/Compress File •Environment variables •Basic of Editor: vi, sed •Quoting and Escape Mechanism •Types of Variables •Operator •Shell Arithmatic •How to to write, execute and debug Shell Script Program •Function •Working with UNIX Server •Different Statement and Loops in Shell Script 3.Module – III (Datawarehousing Concepts) •What is Datawarehouse ? •Why Datawarehouse require ? •DWH Architecture •DWH Characteristics •Data Mart and types •DM vs DWH •Common Datawarehouse tasks •Data cleansing •Partitioning •Staging area •Metadata •OLTP, OLAP, ROLAP, MOLAP •Surrogate Key •Materialized View •Dimension Modeling •Facts and Dimensions •DWH Schema designing •Advantages of Datawarehouse •Star Schema, Snow-flake Schema, Galaxy Schema •OBIEE/BI Overview •Overview of Reports 4.Module – IV (ETL Concepts) •Types of Source Files •Data Extraction •Different types of Transformations •Data Loading •Slowly Changing Dimension •SCD (Type-1, Type-2 and Type-3) •Introduction of ETL Tool •Overview of ETL Tool Architecture •ETL Tool Environment •Tracing Level 5.Module – V (Informatica Power Center Tool) •How developers work on Power Center •Different components of Power Center and uses •Tasks developed in different components •Mapping, Session, Worklet, Workflow, Mapplet