Data Warehouse Certification Program with Trainings

Data Warehouse Association of India
Online

Price on request
You can also call the Study Centre
01140... More
Students that were interested in this course also looked at...
See all

Important information

  • Certificate
  • Online
  • New delhi
  • 50 hours of study
Description


Suitable for: EVERYONE

Important information
Venues

Where and when

Starts Location
On request
New Delhi
110001, Delhi, India
See map

Course programme

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


Students that were interested in this course also looked at...
See all