Oracle Database 10g Administration:Basic

Installing Oracle Database 10g
Install Oracle Database 10g

Exploring the Oracle Database 10g Architecture
Understand Database Architecture
Identify Database Object Types
Recognize the Oracle Instance
Understand the User Connection Process
Identify Resources for the DBA

Creating a Database
Create, Configure, and Delete a Database Using the DBCA
Use Client and Administration Tools

Configuring Oracle Net Services
Examine Oracle Net Services
Perform Basic Oracle Net Server-Side Configuration
Perform Basic Oracle Net Client-Side Configuration
Configure Oracle Shared Server
Configure Connect-Time Failover

Using SQL and PL/SQL
Write Simple SQL SELECT Statements
Filter and Sort Data
Work with SQL Functions
Work with Multiple Tables
Modify Data
Control Database Transactions
Explore PL/SQL

Managing the Database Instance
Obtain Instance Information
Manage the Database Instance
Organize Database Objects
Describe Database Objects and Their Storage

Managing Tablespaces and Datafiles
Manage Tablespaces
Find Tablespace and Datafile Information
Resize and Drop Tablespaces
Configure Oracle Managed Files Managing Tables and Indexes
Create Tables
Gather and Analyze Table Information
Create Indexes
Implement Integrity Constraints
Maintain Integrity Constraints

Creating Views and Sequences
Create Views
Create Sequences

Managing Users and Security
Manage Users
Manage Privileges and Roles
Manage Passwords and Resource Limits
Audit Database Usage
Monitoring Performance
Manage Locks
Gather and Use Tuning and Troubleshooting Information

Loading and Unloading Data
Manage Data Using the Data Pump
Move Tablespaces
Load Data Using SQL*Loader
Create and Access External Tables

Managing Undo Data
Configure Undo Segments and Tablespaces
Understand Automatic Undo Retention

Administering and Performing Backups
Create Redo Log Groups and Members
Plan and Configure the Online Redo Log Group
Manage and Maintain Control Files
Back Up the Database
Examine Recovery Manager Concepts

Administering and Performing Recovery Operations
Manage Recovery
Employ User-Managed and RMAN Recovery
Tune Database Recovery

After completing this course, students will know how to:

Install Oracle Database 10g.
Describe the basics of the Oracle Database 10g architecture.
Create a database.
Configure Oracle Net services.
Use SQL and PL/SQL.
Manage the database instance.
Manage tablespaces and datafiles.
Manage tables and indexes.
Create views and sequences.
Manage users and security.
Monitor database performance.
Use utilities to load data into and unload data from a database.
Manage undo data.
Describe the purpose of redo log files, redo log groups, and control files. You will also perform backups.
Perform restore and recovery operations.

Prerequisites

This course is intended for Oracle Database 10g Administrators, Sales
Consultants, Support Engineers, Oracle Software Developers, and Technical
Consultants. Students should have some knowledge of Oracle database utilities,
architecture, and terminology. Students will also have knowledge of SQL *Plus,
iSQL *Plus, and PL/SQL