Best Data Warehousing training institute Bangalore| Datawarehousing training Bangalore


Data Warehousing Training in Bangalore by DTecH

Data warehousing training institute Bangalore

This instructor-led course provides the basic skills and knowledge towards Datawarehousing concepts. All basic concepts related to Datawarehousing is covered in this course.

Click here to download the Syllabus 

Duration: 2 days

Pre-requisites:

Thorough working knowledge of SQL required.

Who should attend?

Developers who wish to go into Datawarehousing Field.
Beginners who have taken a course on SQL and wish to move into Datawarehousing. 

Topics Covered:

1.What is and OLTP?
2.What is Data Warehouse?
3.OLTP Vs Data Warehouse?
4.Why do you need Data Warehouse?
5.How do you build Data Warehouse?
6.Data Warehousing Technology
7.Definitions and descriptions
8.Data Warehouse Architecture
9.Introduction to BI tools
10.Introduction to ETL tools
11.Data Warehouse – Infrastructure
12.Top Down Vs Bottom Up Approach
13.Data Warehouse Vs Data Marts
14. Standalone Data Marts
15.Enterprise Data Warehouse
16.Operational Data Store (ODS)
17.Front end architectures—OLAP, ROLAP, MOLAP, HOLAP
18.What is Data Modeling?
19.Relational Data Modeling Vs Dimensional Data Modeling?
20.Physical Vs Logical Modeling?
21.Reverse Engineering Vs Forward Engineering?
22.Physical Database Design
23.Star Schema Vs Snow Flake Schema
24.Facts & Dimensions
25.Type 1, Type 2 and Type 3 Slowly Changing Dimension updates
26.Surrogate key Concept.
27.Data Staging
28.Basic ETL Techniques

Best Datawarehousing and Business Intelligence training Bangalore