Oracle 8 DBA

Oracle 8 Database Administration (Oracle 8 DBA)

The Oracle Certified Professional (OCP) Program give you a distinct advantage. An OCP Certification demonstrates that you have a solid understanding of a job role and the Oracle products used in that role. Being an Oracle Certified Professional can help raise your visibility and increase your access to the industry's most challenging opportunities. An Oracle Certification is also a valuable, industry-recognized credential that signifies a proven level of knowledge and ability.

This track is primarily for Database Administrators who have ideally completed training in their job role and have at least six months of experience. You must pass all 5 of the exams listed below to earn OCP status. Once you've passed all 5 exams, you will receive your OCP certificate.

Course outline

Introduction to Oracle: SQL and PL/SQL 15 Hours
Enterprise DBA Part 1A: Architecture and Administration 18 Hours
Enterprise DBA Part 1B: Backup and Recovery Workshop 12 Hours
Enterprise DBA Part 2: Performance Tuning Workshop 12 Hours
Enterprise DBA Part 3: Network Administration 15 Hours
1. Introduction to Oracle: SQL and PL/SQL

Writing a Basic SQL Statement
Restricting and Sorting Data
Single Row Functions
Displaying Data from Multiple Tables
Aggregating Data using Group Functions
Writing Subqueries
Multi-Column Subqueries
Producing Readable Output with SQL*Plus
Manipulating Data
Creating and Managing Tables
Including Constraints
Creating Views
Other Database Objects
Controlling User Access
SQL Workshop
Declaring Variables
Writing Executable Statements
Interacting with the Oracle Server
Writing Control Structures

2. Enterprise DBA Part 1A: Architecture and Administration

Oracle Architectural Components
Getting Started with the Oracle Server
Managing an Oracle Instance
Creating a Database
Data Dictionary Views and Standard Packages
Maintaining the Control File
Maintaining Redo Log Files
Managing Tablespaces and Data Files
Storage Structure and Relationships
Managing Rollback Segments
Managing Tables
Managing Indexes
Maintaining Data Integrity
Loading Data
Reorganizing Data
Managing Password Security and Resources
Managing Users
Managing Privileges
Managing Roles
Using National Language Support

3. Enterprise DBA Part 1B: Backup and Recovery Workshop

Backup and Recovery Considerations
Oracle Recovery Structures and Processes
Oracle Backup and Recovery Configuration
Physical Backup Without RMAN
Complete Recovery of an Oracle Database
Incomplete Recovery of an Oracle Database with Archiving
Oracle Export/Import Utilities
Additional Recovery Issues
Oracle Utilities for Troubleshooting
Oracle Recovery Manager Architecture
Oracle Recovery Catalog Maintenance
Physical Backups Using RMAN
Restore and Recover Using RMAN
Oracle Standby Database

4. Enterprise DBA Part 2: Performance Tuning Workshop

Oracle Performance Tuning Methodology
Oracle Alert and Trace Files
Utilities and Dynamic Performance Views
Tuning the Shared Pool
Tuning the Buffer Cache
Tuning the Redo Log Buffer
Database Configuration and I/O Issues
Using Oracle Blocks Efficiently
Optimizing Sort Operations
Rollback Segment Tuning
Monitoring and Detecting Lock Contention
SQL Issues and Tuning Considerations for Different Applications
Managing Mixed Workload
Tuning with Oracle Expert
Multithreaded Server Tuning Issues (Optional)
Use a tuning methodology to diagnose and resolve performance tuning issues
5. Enterprise DBA Part 3: Network Administration

Identifying networking business trends and problems
Presenting Oracle's networking solutions
Basic Net8 Architecture
Basic Net8 Server-Side Configuration
Basic Net8 Client-Side Configuration
Centralized Naming Concepts
Usage and Configuration of Oracle Names
Usage and Configuration of Multi-Threaded Server
Usage and Configuration of Connection Manager
Troubleshooting the Network Environment
Security In the Network Environment