Data Warehousing school training courses in Columbus, OH (public, in-house or online)

After completing this course, students will be able to:
� Describe data warehouse concepts and architecture considerations.

� Select an appropriate hardware platform for a data warehouse.

� Design and implement a data warehouse.

� Implement Data Flow in an SSIS Package.

� Implement Data Flow in an SSIS Package.

� Debug and Troubleshoot SSIS packages.

� Implement an SSIS solution tha...

Full archival course description>>

This course investigates the architecture, design, and implementation of massive-scale data systems. The course discusses foundational concepts of distributed database theory including design and architecture, security, integrity, query processing and optimization, transaction management, concurrency control, and fault tolerance. It then applies these concepts to both large-scale data warehouse and cloud computing systems. The course blends theory with practice, with each student developing both...

Full archival course description>>

In this course, students learn the basic concepts of a data warehouse and study the issues involved in planning, designing, building, populating, and maintaining a successful data warehouse. Students learn to improve performance or manageability in a data warehouse using various Oracle Database features.

Students also learn the basics about Oracle’s Database partitioning architecture and identify the benefits of partitioning. Students review the benefits of parallel operations to reduce ...

Full archival course description>>

Implement the new partitioning methods

Employ data compression

List the new and updated MV catalog views

Identify the refresh performance enhancements




Review the benefits of using MVs and query rewrite

Use the Query rewrite enhancement to support queries with inline views

Write crosstab queries to pivot (rotate) column values into new columns and to unpivot (rotate) columns into column values

Architecture of SAP NetWeaver 7.0 BI

Overview of the most important objects (Info objects, InfoProviders and so on) in BI and their properties


Components of the data flow and extracting data from SAP source systems or other data sources in the BI




Benefits and use of the BI Content

Introduction to administration of BI data targets

Basics for optimizing query performance (BI accelerator)