This 18 hours instructor-led course is designed to walk-through into real-world examples in-class exercises the core technologies, concepts, architecture, and various features of data warehouses and models. You gain hands-on experience in building a Data Warehouse through a formal process from the conceptual, logical, and physical phases of data warehousing using leading market tools.
At the end of this course, you should be able to:
Describe methods and tools for accessing and analyzing warehouse data
Describe the benefits of data warehousing
Explain the implementation and organizational issues surrounding a data warehouse project
Describe the various technologies required to implement a data warehouse
WHO SHOULD ATTEND?
Data Warehouse Administrators
Data Warehouse properties and characteristics
Gathering business and user requirements
Data warehouse database design phases
Defining the business model
Data Warehousing Architecture
Using time and summarize data in the data warehouse
Examining data sources
Extraction techniques review
Transforming data: issues and action items
Resolving quality data issues
Building the loading process
Transforming XML Schemas
Enrollment is limited to 20 attendees.
The program course contents are delivered either only evening time or at the weekends or in combination of both.