DATA WARE HOUSING
Course
In Bangalore
Price on request
Description
-
Type
Course
-
Location
Bangalore
Facilities
Location
Start date
Bangalore
(Karnātaka)
See map
Karvin Learning Services 537 1st Floor Robby Arcade, CMH Road, Indiranagar, 560038
Start date
On request
Reviews
Have you taken this course?
Course programme
Data Warehouse Course Contents SQL
Database Concepts
Types of SQL statement
Normalization and denormalization
Sub queries
Joins and set operators
Database Objects
Constraints
Data Warehouse Concepts
Introduction of Data Warehouse
Need arise of DWH
OLTP V/S DWH
OLTP V/s OLAP
Data Warehouse /Data Marts Architecture
Staging/without Staging
Dimensions (Simple and Confirm)
Fact (Simple, fact less, coverage, confirm)
Warehouse Implementation Methods
STAR SCHEMA
SNOW FLAKE SCHEMA
Difference between STAR and SNOW FLAKE Schema.
Other terminologies Cleansing, Purging etc.
PL/SQL
Introduction to PL/SQL
Advantages of PL/SQL
Procedures, Functions, Triggers, Packages
Database Modeling Tool (Erwin)
Introduction of Erwin
Designing Methods
Logical Designing
Physical Designing
Introduction of ER-Modeling
Introduction of Dimension Modeling
Difference between ER-Modeling and Dimension Modeling
Implementation of ER-Model
Implementation of Dimension Model
Forward Engineering and Reverse Engineering
Introduction of various Database Component
Database Concepts
Types of SQL statement
Normalization and denormalization
Sub queries
Joins and set operators
Database Objects
Constraints
Data Warehouse Concepts
Introduction of Data Warehouse
Need arise of DWH
OLTP V/S DWH
OLTP V/s OLAP
Data Warehouse /Data Marts Architecture
Staging/without Staging
Dimensions (Simple and Confirm)
Fact (Simple, fact less, coverage, confirm)
Warehouse Implementation Methods
STAR SCHEMA
SNOW FLAKE SCHEMA
Difference between STAR and SNOW FLAKE Schema.
Other terminologies Cleansing, Purging etc.
PL/SQL
Introduction to PL/SQL
Advantages of PL/SQL
Procedures, Functions, Triggers, Packages
Database Modeling Tool (Erwin)
Introduction of Erwin
Designing Methods
Logical Designing
Physical Designing
Introduction of ER-Modeling
Introduction of Dimension Modeling
Difference between ER-Modeling and Dimension Modeling
Implementation of ER-Model
Implementation of Dimension Model
Forward Engineering and Reverse Engineering
Introduction of various Database Component
DATA WARE HOUSING
Price on request