DATA WARE HOUSING

Karvin Learning Services
In Bangalore

Price on request
You can also call the Study Centre
80411... More
Compare this course with other similar courses
See all

Important information

  • Course
  • Bangalore
Description

Important information
Venues

Where and when

Starts Location
On request
Bangalore
Karvin Learning Services 537 1st Floor Robby Arcade, CMH Road, Indiranagar, 560038, Karnataka, India
See map

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

Compare this course with other similar courses
See all