
	Home About Us Services Site Map White Papers Web Briefings Careers Contact Us

	Training/Mentoring

	Oracle Applications
	Enterprise Performance Management
	Business Intelligence
	Custom Development
	Identity Management (Security)
	Managed Services
	Database Services
	Training/Mentoring
		The Service
		The Value
		Contact Us / Registration
		Oracle Certification Prep
		Course Schedule
		Directions, Travel & Accommodations
		Register Online
	Oracle Licensing
	Project Management
	Rolta Solutions

Oracle Database 10g Administration

Click here to contact us

Course Overview

This course introduces students to basic Oracle database administration. In this class, students learn to install and maintain an Oracle database. The course begins with a conceptual understanding of the Oracle database architecture and the software installation process.

Students learn how to create an operational database and properly configure its physical and logical components. These topics are followed by detailed instruction on the best practices for performance monitoring, database security, user management and backup/recovery operations.

These topics are reinforced with structured hands-on lab exercises.

Course Goals

To develop the skills necessary to perform basic database administration tasks for an Oracle database.
To provide instruction on installing Oracle software, configuring the instance, managing database structures, perform backup and recovery, and troubleshoot performance issues.
To complete challenging hands-on exercises in an interactive, instructor-led environment.

Prerequisites

A working knowledge of SQL is suggested.

Who Should Attend?

Database Administrators
Support Engineers
Sales Consultants
Technical Consultants
Database Designers
Project Managers

Course Materials

Database Administration Course Notes
Database Administration Reference Book

Duration

Five (5) days

Course Outline

Introduction
- Grid Technology
- Oracle Database Architecture
- Instance Management
- Database Structures
- Tablespaces and Data Files
- Segments, Extents, and Blocks
Software Installation
- Software Installation
- Database Administrator Tasks
- Oracle Database Tools
- System Requirements
- Optimal Flexible Architecture (OFA)
- Oracle Universal Installer (OUI)
- Installation Options
Database Creation
- Database Planning
- Database Configuration Assistant (DBCA)
- Password Management
- Database Templates
Database Management
- Management Framework
- Oracle Enterprise Manager
- Using SQL*Plus
- Parameter Files
- Startup and Shutdown
- The Alert Log
- Dynamic Performance Views
Data Storage
- Storage Structures
- Database Blocks
- Tablespaces and Data Files
- Oracle Managed Files (OMF)
- Collecting Storage Information
- Increasing Database Size
- Automatic Storage Management
User Security
- User Accounts
- User Authentication
- Privileges
- Roles
- Profiles and Users
- Password Security
Schema Objects
- What Is a Schema?
- Tables
- Constraints
- Indexes
- Views
- Sequences
- Temporary Tables
- Data Dictionary
Data Concurrency
- DML Commands
- Transaction Commands
- PL/SQL
- Functions
- Procedures
- Packages
- Triggers
- Locks
- Data Concurrency
- DML Locks
- Enqueue Mechanism
- Lock Conflicts
- Deadlocks
Undo Data
- Data Manipulation
- Transactions and Undo Data
- Undo Data vs Redo Data
- Undo Retention
- Undo Tablespace
- Undo Advisor
Database Security
- Industry Requirements
- Database Auditing
- Value-Based Auditing
- Fine-Grained Auditing
- DBA Auditing
- Security Updates
Database Connections
- Oracle Net Services
- Oracle Net Listener
- User Sessions
- Networking Tools
- Listener Control Utility
- Database Registration
- Naming Methods
- Advanced Options
Proactive Maintenance
- Optimizer Statistics
- Statistic Levels
- Automatic Workload Repository (AWR)
- Automatic Database Diagnostic Monitor (ADDM)
- Advisory Framework
- Server-Generated Alerts
- Automated Maintenance Tasks
Performance Management
- Performance Monitoring
- SQL Tuning Advisor
- SQL Access Advisor
- Automatic Shared Memory Management (ASMM)
- Dynamic Performance Statistics
- Dynamic Performance Views
Backup and Recovery
- Types of Failures
- Checkpoint (CKPT)
- LogWriter (LGWR)
- Archiver (ARCn)
- Instance Recovery
- Media Failure
- Control Files
- Redo Log Files
- Archive Log Files
- ARCHIVELOG Mode
Backup Solutions
- Oracle Secure Backup
- User-Managed Backup
- Recovery Manager (RMAN)
Recovery Solutions
- Opening a Database
- Loss of a Control File
- Loss of a Redo Log File
- Loss of a Data File
Performing Flashback
- Flashback Technology
- Flashback Database
- Flashback Table
- Flashback Drop
- Flashback Query
- Flashback Versions Query
- Flashback Transaction Query
Moving Data
- General Architecture
- Directory Objects
- SQL*Loader
- Data Pump
- External Tables

Disclaimer