Data Warehousing school training courses in Austin, TX (public, in-house or online)

This course focuses on concepts needed for analyzing, designing and applying effective systems for meeting management’s information needs for tactical short-term, and strategic long-term, planning and decision-making. The course covers various models of business intelligence and decision support systems, based largely on database design in support of data warehousing and data mining concepts. Topics include data modeling for the data warehouse and data mart, and application of OLAP and arti...

Full archival course description>>

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