| |
|
| |
Oracle9i Database - Fundamentals I Training Class
Course ID: 5874
|
|
| |
|
|
| |
|
|
| |
Oracle9i Database - Fundamentals I Training Seminar
Overview:
This course introduces students to the responsibilities of an Oracle?? database administrator (DBA). You will learn the underlying architecture of the Oracle database server and the essential tasks required to manage database installations.
At Course Completion:
This course will help you to prepare for Oracle's exam, Oracle9i Database: Fundamentals I (1Z0-031). - Describe the basic Oracle9i architecture and how objects are stored in the database. - Manage an Oracle instance. - Manage tablespaces and datafiles. - Manage tables and indexes. - Manage undo data. - Maintain the online redo log and the control files. - Manage users, privileges, roles, and resources. - Describe globalization support.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Overview of Oracle9i Architecture
Database Architecture
User Processes
Resources for the DBA
|
|
Lesson 2: Understanding the Oracle Instance
Overview of Database Creation
Creating a Database with the Database Configuration Assistant
Logical and Physical Structures
Database Objects and Their Storage
Managing the Database Instance
Obtaining Instance Information
|
Lesson 3: Managing Tablespaces and Datafiles
Managing Tablespaces
Resizing and Moving Tablespaces
Overview of Oracle Managed Files
|
Lesson 4: Managing Tables and Indexes
Constructing Tables
Table Information and Analysis
Overview of Indexes
Managing Indexes
Implementing Constraints
Maintaining Integrity Constraints
|
Lesson 5: Managing Undo Data
Overview of Rollback Segments
Implementing Automatic Undo Management
|
|
Lesson 6: Managing the Online Redo Log and the Control File
Overview of the Online Redo Log
Plan and Configure the Online Redo Log
Managing and Maintaining the Control File
|
Lesson 7: Managing Users and Security
Managing Users
Managing Privileges and Roles
Managing Passwords and Profiles
|
Lesson 8: Globalization Support
Overview of Globalization Support
NLS Parameters
| |
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
Oracle9i - Introduction
Oracle9i SQL - Introduction
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Oracle9i Database - Fundamentals I Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5874
| Course Duration: 5 Days
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|