Data Warehousing for Professionals

Course Description

This course establishes the Data Warehousing fundamental concepts, design, and technology that are critical of every business environment. It introduces the best practice approaches and basic architecture for designing and developing data warehouse solutions including definitions, characteristics, environments, life cycle process, project planning/strategy, implementation/deliverable issues and Infrastructure required. It also provides in-depth analysis of various products and tools available in marketplace.

Who can Attend?

Project Managers/Leads, System Managers, Architects, System Analyst, Application Developers, QA/Testers, DBAs and Application Supporters.

What you will learn..!


Data Warehouse concepts
What is Data Warehouse?
Where was this Data Warehouse before?
How is Data Warehouse evolved?
Why do you need Data Warehouse?
How do you build Data Warehouse?
Data Warehousing Technology Overview Part I
Definitions and descriptions
Data Warehouse Architecture
Introduction to Databases
Introduction to BI tools
Introduction to ETL tools
Data Warehousing Technology Overview Part II
Data Warehouse Infrastructure
Data Warehouse vs Data Marts
Standalone Data Marts
Enterprise Data Warehouse
Operational Data Store (ODS)
Front end architectures OLAP, ROLAP, MOLAP, HOLAP
Physical Database Design
Data Staging
Basic ETL Techniques
Integrating Data from Multiple Source
Data Quality and cleansing
Overview of Data Warehousing in Industry
Retail
Telecom
Customer Relation ship management
Inventory
Order Management
Human Resources
Manufacturing
Data Warehouse Team Players
Project Team Members Their Roles and Responsibilities
Project Scope and Definition?
Project Life Cycle
Business Requirements & Deliverables
Data Warehousing Applications Overiew
Products and tools in the Market
Databases (Teradata , DB2, Oracle etc)
ETL Tools (Informatica, Data Stage , Ab Initio, Data Integrator etc)

Prerequisite

Database programming with SQL knowledge

Course/Batch Details

Duration: 4 weeks i.e. minimum 40 hours of online hands-on training
Weekday Batch - Mon to Fri (6.30pm to 8.30pm)
Weekend Batch - Sat (9.00 am to 5.00 pm) &
Sun (9.00 am to 1.00 pm)



Location: 1755 The Exchange Ste 395, Atlanta, GA 30339
email: info@AAdatawarehousing .com or Call: 770-690-9543

Start Date: CALL