Data Warehousing school training courses in Bellevue, NE (public, in-house or online)

Introduces the concepts associated with the development of a data warehouse. Students apply the "Extract, Clean, Conform, and Deliver" process to organizational data and build the dimension and fact tables required in a data warehouse. Current server tools are used in hands-on exercises.

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