Duration : 6 weeks 

PROJECTS : 2 Projects along with remote login facility. Documentation and assistance for resume preparation is provided. Placement assistance is also provided. 

RDBMS 

1. Introduction to RDBMS and first three normalization rules
2. Introduction to SQL
3. DDL, DML, DCL
4. Where Clause
5. Joins
6. Group operations
7. Sub queries
8. Set operations
9. Decode and case
10. SQL*PLUS
11. SQL LOADER

DATA WAREHOUSING CONCEPTS 

1. Entity-Relationships
2. OLTP,
3. OLAP,
4. Data Warehousing
5. Data Mart,
6. Data staging
7. Data Warehousing vs. Data Marts
8. Advantages of Data Warehousing
9. Ad-hoc Access vs. Managed Query
10. Data Modeling Techniques
11. Examples and exercises
12. OLAP Tools & Techniques
13. Data Extraction Techniques
14. Data Extraction Tools
15. Dimensional data model
16. Fact table
17. Lookup table
18. Star Schema and Snowflake Schema
19. Slowly Changing Dimension Type1 Type 2: Type 3:
20. Conceptual Data Model
21. Logical Data Model
22. Physical Data Model
23. Bill Inmon vs. Ralph Kimball:
24. Meta data
25. Business intelligence
26. Aggregates
27. Cubes
28. Dimensions
29. Measures,
30. Slice and dice
31. Hierarchy
32. Drill down

INFORMATICA 

1. Introduction to Data Warehousing (Dimensional modeling,Star/snowflake,Facts,Dimensions,SCDs etc)
2. Understanding the scope of Data warehouse project
3. Data warehouse Architecture and Design
4. Real Time DW Project Architecture
5. Different People involved in a DW team(and their roles like DW Architect, Business Analyst, Developer, Tester, Reports, DBA’s.)
6. Informatica and Data warehousing
7. Informatica Architecture
8. ETL with Informatica
9. Informatica Suite Components
10. Informatica Designer
11. Workflow Monitor
12. Source Analyzer
13. Warehouse Designer
14. Mapping Designer
15. Mapplets Designer
16. Transformations in Informatica
17. Importing sources and Targets
18. Source Qualifier Transformation
19. Filter Transformation
20. Expression Transformation
21. Aggregator Expression
22. Router Transformation
23. Lookup Transformation
24. Rank Transformation
25. Sequence Generator
26. Creating, Configuring and Linking Ports
27. Joiner Transformation
28. Sorter Transformation
29. Using Informatica Manager
30. Creating Repository
31. Managing the Repository
32. ODBC DSN creation
33. Designing the ETL
34. Understanding The After-Design Scenario
35. Specifying the Database Connections
36. Advanced Informatica
37. Repository Security
38. Managing Groups
39. Managing Users
40. Managing Privileges
41. Changing password
42. Folder Permission
43. Backup & Restore
44. Troubleshooting Informatica
45. Understanding Jobs and Scheduler
46. Other topics like parameter files, Partitioning.
47. Various types of testing done in Data warehousing (Unit, Integration, System,UAT)
48. Real time Implementation Incremental loads.etc)
49. Performance and Tuning(Various Bottle necks and so on)
50. Interview Question