Name: Oracle Database 11g: Administration Workshop I
Course Code: OR50102
Duration: 5
Scheduled Dates for OR50102
In this course, students study the issues involved in planning, designing, building, populating, and maintaining a successful data warehouse. Students learn the reasons why data warehousing is a compelling decision support solution in today's business climate. They examine the Oracle approach to a successful data warehouse implementation using a proven methodology. During the course, students examine Oracle warehouse technology, and identify the technology available from Oracle Partners for designing, implementing, and running a data warehouse.
Target Audience
This course is ideal for Database Administrators, Data Warehouse Designers, and Data Warehouse Administrators.
Key Topics
- Introduction
- Meeting a Business Need
- Unsuitability of Online Transaction Processing (OLTP) Systems for Complex Analysis
- Management Information Systems and Decision Support Systems (DSS)
- Data Extract Processing
- Business Drivers for Data Warehouses
- Typical Uses of a Data Warehouse
- Defining Data Warehouse Concepts and Terminology
- Data Warehouse Definition
- Data Warehouse Properties
- Data Warehousing Terminology
- Components of a Data Warehouse
- Oracle Warehouse Vision, Products, and Services
- Driving Implementation Through a Methodology
- Warehouse Development Approaches
- The Need for an Iterative and Incremental Methodology
- Oracle Data Warehouse Method
- Data Warehouse Fundamental Elements
- Oracle Warehouse Technology Initiative (WTI)
- Planning for a Successful Warehouse
- Managing Financial Issues
- Obtaining Business Commitment
- Managing a Warehouse Project
- Analyzing User Query Needs
- Types of Users
- Gathering User Requirements
- Managing User Data Access
- Online Analytical Processing (OLAP) Models
- Query Access Architectures
- Modeling the Data Warehouse
- Data Warehouse Database Design Phases
- Phase One: Defining the Business Model
- Phase Two: Creating Dimensional Model
- Data Modeling Tools
- Choosing a Computing Architecture
- Choosing a Computing Architecture
- Architectural Requirements
- The Hardware Architecture
- Database Server Requirements
- Parallelism
- Planning Warehouse Storage
- The Data Server Architecture
- Protecting the Database
- Building the Warehouse
- Extracting, Transforming, and Transporting Data
- Extracting Data
- Examining Data Sources
- Extraction Techniques
- Extraction Tools
- Transforming Data
- Importance of Quality Data
- Transformation
- Transforming Data: Problems and Solutions
- Transformation Techniques
- Transformation Tools
- Transportation: Loading Warehouse Data
- Transporting Data into the Warehouse
- Building the Transportation Process
- Transporting the Data
- Postprocessing of Loaded Data
- Transportation: Refreshing Warehouse Data
- Capturing Changed Data
- Limitations of Methods for Applying Changes
- Purging and Archiving Data
- Final Tasks
- Selecting ETT Tools
- Leaving a Metadata Trail
- Defining Warehouse Metadata
- Developing a Metadata Strategy
- Examining Types of Metadata
- Metadata Management Tools
- Common Warehouse Metadata
- Supporting End-User Access
- Business Intelligence
- Multidimensional Query Techniques
- Categories of Business Intelligence Tools
- Data Mining in a Warehouse Environment
- Oracle Data Mining Partners
- Web-Enabling the Warehouse
- Accessing the Warehouse Over the Web
- Common Web Data Warehouse Architecture
- Issues in Deploying a Data Warehouse on the Web
- Evaluating Web-Based Tools
- Managing the Data Warehouse
- Managing the Transition to Production
- Managing Growth
- Managing Backup and Recovery
- Identifying Data Warehouse Performance Issues
Objectives
- Upon completion of this course, participants will be able to:
- Demonstrate familiarity with the various technologies required to implement a data warehouse
- Define the decision support purpose and end goal of a data warehouse
- Describe methods and tools for accessing and analyzing warehouse data
- Explain the implementation and organizational issues surrounding a data warehouse project
Required Skills/Experience
- Business-level understanding of Oracle technology
Suggested Next Course(s)
- Oracle Database 11g: Administration Workshop II
Note
Suggested Prerequisites:
Oracle Database 11g: Introduction to SQL
Fee: $3,000.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC
