Data Warehouse Certification Program with Trainings
Certificate
Online
Description
-
Type
Certificate
-
Methodology
Online
-
Location
New delhi
-
Class hours
50h
Suitable for: EVERYONE
Facilities
Location
Start date
Start date
Reviews
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
Data Warehouse Certification Program with Trainings