Database Run through

Working with oracle - DDL, DML, DTL statements - Writing Basic SQL SELECT Statements - Eliminating Duplicate Rows - Restricting and Sorting Data - Clause- where, group by order by Constrains- primary, not null, unique, check - Single-Row Functions - Joins: inner join, outer join, self join, natural join - Indexes

Introduction to Data Warehousing:

Data Warehouse Concept - Differences between Transactional and Warehoused Data - Data Warehouse Architecture - Logical & Physical Design - Difference between Data Warehouse & Data Mart - Source Data, Staging Data & Target Data - Operational Data Sources (ODS) - OLA, ROLAP & MOLAP Star Schema, Star FLAKE Schema & Snow Flake Schema - Normalization and De-normalization - Meta Data & Data Mining

Database Design and Modeling:
Entity-Relation Model(E-R Model) for Transactional Database:

Defining Entities and their Relationship - Distribution of Attributes under Entities - Normalization of Entities - Modeling Logical E-R Model using Erwin Tool - Conversion of Logical Model into Physical Model - Application of Business Rules - Constraints, Triggers, Domains, Back-end Programs, etc.

Dimensional Model (Star Schema) for Data Warehouse: Introduction to Data Warehousing:

Data Warehouse Concept - Differences between Transactional and Warehoused Data - Data Warehouse Architecture - Logical & Physical Design - Difference between Data Warehouse & Data Mart - Source Data, Staging Data & Target Data - Operational Data Sources (ODS) - OLA, ROLAP & MOLAP Star Schema, Star FLAKE Schema & Snow Flake Schema - Normalization and De-normalization - Meta Data & Data Mining

DATA STAGE: Introduction to ETL

Introduction to Data Stage and various components of DS - DS Designer - DS Project and Developing job - Table definitions & programming in DS - Different types of jobs, stages – Sequencer - Transformer & Routines and processing in DS - DS director, Running, Monitoring jobs - DS Manager, Managing data elements jobs and sequencer - DS Manager, Importing exporting jobs - DS Administrator & Project creation