Home » Training Courses » Programming & Networking Training » Oracle Database Administration Training

Oracle Database Administration Training

5 days - please call for a quote

Oracle Database Administration is a skill that has been growing in demand over recent years, despite the downturn in the global economy. This Oracle Database Administration training course builds on the SQL*Plus and PL/SQL skills from the perspective of a technician responsible for creating and administering physical and logical file structures in this powerful relational database product.

Oracle Database Administration Course Objectives

This Oracle Database Administration training course is intended for technical staff who are becoming responsible for creating and administering Oracle databases.
Development staff may also benefit from attending this Oracle Database Administration training course, to gain an overview of the work of a Database Administrator to aid in developing effective systems that will be based on Oracle.

Oracle Database Administration Course Content

Database Administration:

Memory, process and disk structure
instances and databases
storage structures
backup and recovery
SQL and database tuning
network resource management

Oracle Architecture:

Disk structures
parameter files
control files
data files
redo log files
password files
segments, extents and blocks
memory areas
shared pool
buffer cache
redo log buffer
processes
database writer
log writer
system monitor
process monitor
archiver
processing overview

Creating a Database:

Configuring the operating system
privileged account authentication
creating a parameter file
creating a database
creation commands
post creation actions
data dictionary management

Starting and Stopping Oracle:

Instance processing overview
startup command
startup stages
command options
shutdown commands and options
checking instance status
using the alert logs
trace files

Tablespaces, Datafiles and Rollback Segments:

Structure review
tablespace types
system tablespace
non-system tablespaces
inside a tablespace
locally managed and dictionary managed tablespaces
datafiles
tablespace and datafile management
segments, extents and blocks
rollback segment operations
creating and managing rollback segments

Tables and Indexes:

Creating tables
data types
creation and management commands
inside a table
table management (alter, drop, move)
partitioned tables
indexes
creating indexes and setting storage criteria
index management

Database Integrity:

Creating, altering and dropping constraints
enabling and disabling constraints
constraints and indexes
more on index types
index-organised tables
bitmap indexes
reverse key indexes

User and Resource Management:

User accounts overview
resource profiles
system and password limits
profile management
authentication choices - password, operating system, database
users and tablespaces
privileges and roles
creating and managing user account
tablespace quotas; data dictionary information

Privileges:

User and system privileges
assigning privileges to users
using roles
stored code privileges
invoker and definers rights

Oracle Best Practices:

User and system privileges
assigning privileges to users
using roles
stored code privileges

Oracle Database Administration Training Course Prerequisites

A grounding in relational database concepts; familiarity with the use of graphical user interfaces.
Some expertise with both SQL and PL/SQL in an Oracle environment is expected.

Oracle Database Administration Course Recommended Reading:-

Effective Oracle by Design (Osborne Oracle Press Series)

For full course content and pre-requisites download the Oracle Database Administration Training Course PDF