You can develop the basic skills to effectively administer an Oracle Server Database and configure an Oracle Database

Course Description:

Through hands-on experience in administering an Oracle 9i Database you can understand the Oracle Server architecture, expand the size of the database, implement security, and know why and how specific database administration tasks are performed.

You can learn:

• Oracle Server Architecture

• To install Oracle Server Software

• Oracle Enterprise Manager (OEM)

• Oracle Management Server (OMS)

• To Start and Stop an Oracle Database

• To manage Tablespaces and Undo Segments

• To create an Oracle Database, Tables, Constraints and Indexes, and all other Database Objects

• To manage Redo Logs, Tablespaces, Datafiles, Controlfiles, and Security

• To audit the database

Who Needs to Attend:

Data Analysts, Database Administrators, Systems Administrators, Network Managers and Technical Support Personnel

Prerequisites:

Knowledge of SQL

Introduction to Oracle 9i SQL and SQL* Plus course or equivalent experience

Introduction to Oracle 9i PL/SQL course or equivalent experience is highly recommended.

Course Labs:

Lab 1: Creating Tables, Indexes and Constraints

Lab 2: Creating Other Database Schema Objects

Lab 3: Starting And Stopping The Database

Lab 4. Using and Managing SPFILES and Parameters

Lab 5: Blocks and Extents

Lab 6: Undo Segments

Lab 7: Segments

Lab 8. Managing Tablespaces

Lab 9: Multiple Block Size Management

Lab 10: Architecture

Lab 11: Advanced Memory Management

Lab 12: Oracle Database Files

Lab 13: Using Oracle-Managed Files

Lab 14: Users and Security

Lab 15: DBA Tools

Lab 16: Creating an Oracle Database

Lab 17: Oracle Auditing

Course Content:

• Oracle RDBMS Components
• DBA Responsibilities

• Introduction to Datatypes and Tables

• Integrity Constraints

• Temporary tables, partitioned tables (range, hash, list), external tables, IOTs

• Indexes and Skip Scanning

• Online reorganization

• Database workspace management

• DDL Commands used

• Views, Materialized views

• Sequences, Synonyms, Database Links

• Outlines, Dimensions, Hierarchies

• PL/SQL Program Units

• Supplied Packages

• Oracle Data Dictionary

• Storage of Large Objects (BFILEs, BLOBs, CLOBs)

• What Tool to Use?

• Connecting as a Privileged User

• Password file authentication

• Starting and Shutting Down a Database

• Reading the Alert Log / Trace Files

• Quiescing the database

• SPFILE / Parameter management

• Basic Definitions

• Blocks & Extents

• Fragmentation / Deallocation

• Introduction to Segments

• Managing Undo Segments

• Automatic Undo Management

• Managing sort activity, and Data and Index Segments

• Monitoring database segments

• Tablespace Overview

• System Tablespace

• Types of Tablespaces

• Creating additional tablespaces

• Altering tablespaces

• Temporary Tablespaces

• Tablespace Quotas

• Monitoring Tablespaces

• Architecture Overview

• Database and Process structures

• Memory structures – SGA, PGA

• Alternative configurations

• Basic Structures of an Oracle RDBMS

• Data Files, Redo Log Files

• Archived Redo Log Files

• Control Files, Oracle-Managed Files (OMF)

• Managing Database Users

• System and Object Privileges

• Managing Roles, Profiles and Passwords

• Resource Manager

• The Virtual Private Database

• OEM Configuration and Console

• Oracle Management Server Configuration, and Other OEM Console Tools

• Apache Server

• ORADIM

• Universal Installer

• Benefits of OFA

• Planning a database

• Creating a Database

• The CREATE DATABASE Command

• Using the Database Configuration Assistant

• Types of Auditing

• Establishing an audit trail repository

• Auditing options, Audit results

• DBMS_DDL

• DBMS_JOB

• DBMS_PCLXUTIL

• DBMS_RESOURCE_MANAGER

• DBMS_ROWID

• DBMS_SESSION

• DBMS_SHARED_POOL

• DBMS_SPACE

• DBMS_SPACE_ADMIN

• DBMS_TTS

• DBMS_UTILITY

• Character sets supported

• Choosing a character set

• Multi-byte character sets

• National Language Support (NLS)

• Defining time zones

• Daily, Weekly, Monthly, and As Needed Tasks