Data Warehouse Certification Program with Trainings

A) BEGINNER’S MODULE (Level-I) RDBMS CONCEPTS:-

• What is RDBMS

• Codd’s Rules

• Functional dependency

• Partial dependency

• Transitive dependency

• Normalization o Ist Normal Form o IInd Normal Form o IIIrd Normal (BCNF)

• Primary key, Foreign Key, Candidate Key

• Entity, Attributes, Relationship

• ER Modeling

• Cardinality

• Management of Locks

INTRODUCTION TO DATABASE

• Data Types

• DML (Data Manipulation Language)

• Select

• Insert

• Delete

• Update

• DDL (Data Definition Language)

• Alter

• Create

• Drop

• Truncate

• DCL (Data Control Language)

• Grant

• Revoke

• TCL (Transaction Control language)

• Commit

• Rollback

• Save points

• Constraints

• Primary Key

• Foreign key

• Check

• not null

• Unique

• %type, %row type

• Conditional Structure

• If

• Then

• Else Loop

• End loop

• For loop

• While loop

• Cursor (Éxplicit, Implicit) and cursor variable

• Error handling with exception

• Brief Introduction of Function, Procedure, Package, Trigger

• Brief idea of view, index, sequence B)

EXPERT MODULE INTRODUCTION TO DATA WAREHOUSING

• Data warehousing concepts

• Need of data warehousing

• Elements of data warehousing

• Data warehousing architecture

• Data Mart Vs DW

• Meta Data

• Explanation of Cube, Dimension, hierarchy, level, facts and measures

• Fact table and dimension table

• Difference between OLTP and OLAP

• Surrogate key

• Different types of Dimension , facts and measures

• OLAP/ROLAP/MOLAP

• Types of Schema

• Star schema

• Snowflake schema

• Star flake schema

• Introduction of Business Intelligence

• Introduction to Data mining

DESIGN TOOL

• Data modeling

• Modeling concepts

• Understanding data modeling concepts

• Enterprise Data modeling

• Relationship types

• Relationship cardinality

• Dimensional Modeling

• Defining entity types

• Primary Key , foreign key

• Report generation

• Creating logical Model

• Creating physical model ETL TOOL: Designer

• Working with sources

• Working with targets

• Working with Flat files

• Mappings

• Transformation

• Normalization and Denormalization

• OLAP & Hybrids

• OLAP Analysis List of Transformation

• Aggregation

• Lookup

• Virtual field

• Scheduling

• Indexing

OLAP DATABASE SETUP & DESIGN FOR TECHNICAL ANALYSTS (Level-II)

• How to connect with database(ODBC or server)

• Denorm-this (How to denormalize)

• Import-This (How to import into Chimera database)

• Analyze-this (front end)

• Data groups

• Templates

• Fields

• Queries

ANALYTICS USING FRONT-END FOR BUSINESS ANALYSTS (Level-III)

• Bandings ( Key Performance Indicators/ KP Matrices)

• Numeric

• Parametric

• Date

• Discrete

• Objects

• Cross tabulations

• Field statistics

• Venn diagram’s

• Multidimensional Cross tabulations

• Session properties

• Import session items

• Export session items

• Report generation CRM (Customer Relationship Management)

• Alerts

• Performance Measures

• Score fields

• Score bandings

• Time dimensions