Recommended Related Training Courses:
This Oracle Database 11g: Analytic SQL for Data Warehousing training teaches you how to use Analytic SQL to aggregate, analyze & report & model data. Learn to interpret the concept of a hierarchical query, create a tree-structured report & format hierarchical data.
Oracle OLAP 11g, a fully-integrated component of Oracle Database 11g, provides a full featured multidimensional data model and calculation engine that is easily accessible to any SQL based business intelligence application or tool. In this course students learn to design and create a powerful, analytically rich OLAP data model, and create sophisticated analytic reports of OLAP data by using simple SQL queries.
This Oracle Database 11g Performance Tuning training is an advanced curriculum course. It builds on the Introduction to Performance Tuning in the Administration Workshop I and II courses, focusing on the tuning tasks expected of a DBA.
This is an advanced course building on the introduction to Performance Tuning provided in the Administration Workshop I and II courses. Students learn how to use Oracle Database 11g automatic tuning features.
This Implement Oracle Data Warehousing Best Practices training teaches you the best practices for implementing an enterprise data warehouse. Learn how to build a balanced hardware configuration and review the two classic models: third normal form and star schema.