Database 11g: Administer a Data Warehouse - NEW
Students learn about Oracle’s Database partitioning architecture and identify the benefits of partitioning. Students also use parallel operations to reduce response time for data-intensive operations. Participants extract, transform, and load data into an Oracle database warehouse. Students also use materialized views to improve the data warehouse performance. Students also learn how query rewrite can improve a query’s performance. Students use the SQL Access Advisor to optimize the entire workload. Finally, students learn how to tune materialized views for fast refresh and query rewrite and how to use the compression and resumable sessions features.
|
10g: Oracle Warehouse Builder New Features
This course introduces students to the new features in Oracle Warehouse Builder
10g Release 2. Students learn how to use Warehouse Builder 10g Release 2 new
features to produce high quality information in the Oracle database.
|
10g: Oracle Warehouse Builder pt 1
Students learn how to implement a data warehousing solution using Oracle
Warehouse Builder. Oracle Warehouse Builder is a single, comprehensive tool for
that provides data quality, data auditing, fully integrated relational and
dimensional modeling, and full life cycle management of data and metadata.
|
10g: Oracle Warehouse Builder pt 2
In this 2-day hands-on course, students engage in in-depth activity with
multidimensional deployment and loading using Oracle Warehouse Builder.
Students also learn aspects of managing their data warehouse.
|
10g: Data Warehouse Fundamentals
In this course, participants study the issues involved in planning, designing,
building, populating, and maintaining a successful data warehouse. Participants
also examine Oracle’s approach to a successful data warehouse implementation by
identifying proven Data Warehouse and Business Intelligence (DW and BI)
technologies and tools provided by Oracle.
|
10g: Implement and Administer a Data Warehouse
This course is your first step towards success as an Oracle professional,
designed to give you a firm foundation in basic database administration. In
this class, you will learn about the architecture and how its components work
and interact with one another and also how to install and maintain an Oracle
database.
|
9i: Data Warehouse Administration
With the help of business intelligence, companies are learning more about their
best customers, their supply chains and product life cycles--to the benefit of
the bottom line. Accurate business intelligence can lead to competitive
advantage, and people who know how to administer such a system play a critical
role in its success.
|
Data Warehouse Database Design
In this course, students are presented with the basic concepts, fundamental
issues, and techniques for the design of a data warehouse or data mart.
Students examine all phases and tasks of the data warehouse design process,
including business modeling, entity relationship diagramming, dimensional
modeling, physical modeling, and warehouse meta data management.
Return to top
|