Optimizing and Securing an Oracle8 Data Warehouse

Training Provided by Teach Me IT Optimizing and Securing an Oracle8 Data Warehouse is the third course of the Oracle8 Data Warehousing curriculum. This course acquaints users to the various methods that can be employed to secure and optimize an Oracle8 data warehouse. The course explains the concepts of tuning the data warehouse, creating backups, recovering and archiving data. The course extensively covers aspects related to securing the data warehouse and managing users, resources, roles, privileges, and the concept of RAID. After completing this course, the user will be able to:

Describe the process of tuning loads and scrubs
Describe memory tuning
Describe the optimization process of executing queries
Describe the EXPLAIN PLAN statement and the TKPROF utility
Tune for sorts of the data warehouse
Describe the features of Oracle8 that help tune data warehouse tablespaces
Describe the initialization parameter file
Manage roles and privileges
Describe and implement security policies
Perform backup and recovery
Describe RAID levels

Optimizing and Securing an Oracle8 Data Warehouse

Other Courses in the Curriculum  Planning an Oracle8 Data Warehouse  Implementing an Oracle8 Data Warehouse Course Name Optimizing and Securing an Oracle8 Data Warehouse Audience Database administrators who design and implement data warehousing solutions with the help of business analysts and the management.  Course Requirements You need Microsoft Internet Explorer 5.0 or above OR Netscape Navigator/Communicator 4.78 or above. Plug-in Requirements  ØMacromedia Shockwave plug-in for Windows for IE/NN  ØMacromedia Flash plug-in for Windows for IE/NN Note: Macromedia Flash plug-in comes built in with IE 5.5 and above and NN 6.x. To download the plug-ins, click on the relevant icon below.   Pre-requisites Before taking this course, the user should be familiar with relational database concepts and should have experience in designing database management systems. The user should also be familiar with basic data warehousing concepts and terminology, and know the basic ANSI SQL statements. Some knowledge of Oracle8 is beneficial.  Course Duration 3.3  hours Course Objectives Optimizing and Securing an Oracle8 Data Warehouse is the third course of the Oracle8 Data Warehousing curriculum. This course acquaints users to the various methods that can be employed to secure and optimize an Oracle8 data warehouse. The course explains the concepts of tuning the data warehouse, creating backups, and recovering and archiving data. The course extensively covers aspects related to securing the data warehouse and managing users, resources, roles, privileges, and the concept of RAID. After completing this course, the user will be able to: Describe the process of tuning loads and scrubs Describe memory tuning Describe the optimization process of executing queries Describe the EXPLAIN PLAN statement and the TKPROF utility Tune for sorts of the data warehouse Describe the features of Oracle8 that help tune data warehouse tablespaces Describe the initialization parameter file Manage roles and privileges Describe and implement security policies Perform backup and recovery Describe RAID levels   Course Outline Tuning the Data Warehouse Tuning Loads, Scrubs, and Memory Tuning Queries Other Tuning Features Quiz Securing the Warehouse Managing Roles and Privileges Data Warehouse Security Policies Backup, Recovery, and RAID Quiz

About The Training Provider: Teach Me IT

More Oracle8 Data Warehousing Training from Teach Me IT

• Implementing an Oracle8 Data Warehouse
• Planning an Oracle8 Data Warehouse