Oracle 9i DBA I

Professional Training Solutions Ltd

Price: TBA

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 4 Days
Call: +971 4 5490356

Course details

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.

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.

Introduction and Duties of the DBA:

Oracle RDBMS Components
DBA Responsibilities

Tables, Constraints and Indexes:

Introduction to Datatypes and Tables
Integrity Constraints
Temporary tables, partitioned tables (range, hash, list), external tables, IOTs
Indexes and Skip Scanning
Online reorganisation
Database workspace management

Other Database Schema Objects:

DDL Commands used
Views, Materialised views
Sequences, Synonyms, Database Links
Outlines, Dimensions, Hierarchies
PL/SQL Program Units
Supplied Packages
Oracle Data Dictionary
Storage of Large Objects (BFILEs, BLOBs, CLOBs)

Starting and Stopping the Database:

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

How Space is Physically Consumed - Blocks and Extents:

Basic Definitions
Blocks & Extents
Fragmentation / Deallocation
How Space is Logically Consumed - Segments:
Introduction to Segments
Managing Undo Segments
Automatic Undo Management
Managing sort activity, and Data and Index Segments
Monitoring database segments

Managing Tablespaces - Default behavior of CREATE TABLESPACE command:

Tablespace Overview
System Tablespace
Types of Tablespaces
Creating additional tablespaces
Altering tablespaces
Temporary Tablespaces
Tablespace Quotas
Monitoring Tablespaces

Basic Oracle Architecture:

Architecture Overview
Database and Process structures
Memory structures - SGA, PGA
Alternative configurations

Oracle Database Files:

Basic Structures of an Oracle RDBMS
Data Files, Redo Log Files
Archived Redo Log Files
Control Files, Oracle-Managed Files (OMF)

Users and Security:

Managing Database Users
System and Object Privilages
Managing Roles, Profiles and Passwords
Resource Manager
The Virtual Private Database

Oracle DBA Tools:

OEM Configuration and Console
Oracle Management Server Configuration, and Other OEM Console Tools
Apache Server
ORADIM
Universal Installer

Creating an Oracle Database:

Benefits of OFA
Planning a database
Creating a Database
The CREATE DATABASE Command
Using the Database Configuration Assistant

Oracle Auditing:

Types of Auditing
Establishing an audit trail repository
Auditing options, Audit results

PL/SQL Packages for the DBA:

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

Globalization Support:

Character sets supported
Choosing a character set
Multi-byte character sets
National Language Support (NLS)
Defining time zones

Updated on 08 November, 2015

Course Location

Show map Location Westland Square Pearse St Dublin 2 Ireland

About Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.

they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.

their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:

restructuring for competitiveness

productivity improvements through updating work processes to match new technology

managing outstheircing

strategic financial planning and engineering

their methodology is to:

Work closely with clients to understand and help them prioritise their needs

Design and deliver the best mix of training activities and consultancy to establish the competencies required

Provide ongoing coaching to sustain the improved practices and processes

they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.

their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.

See all Professional Training Solutions Ltd courses

View more Virtual classroom training for Oracle online courses See all Oracle Courses

See all current Oracle jobs in UAE