Oracle 10G/11G Database Administration

AUDIENCE: This course is for support staff who need to be able to provide the day-to-day administration of an Oracle 10G based system. The class is based on the Oracle Enterprise Edition - most concepts are also applicable to Standard Edition and Standard Edition One versions of Oracle 10G.
PREREQUISITES: An understanding of using an Oracle based system is required. Delegates will need knowledge of SQL and attending both of our Oracle SQL courses, or their equivalent from other training providers is highly recommended. Some understanding of Internet concepts is advised to fully benefit from this course.
DURATION: 5 days. Hands on.
OBJECTIVES: This course is highly interactive and consists of theory reinforced by extensive hands on practical sessions. On completion of the class, the delegate will understand the responsibilities of a DBA and be able to perform the tasks associated with the role. Delegates will be provided with the skills to describe the architecture of an Oracle system and configure, create and manage efficient Oracle 10g databases. They will also gain the practical experience to administer users, roles and privileges.
COURSE CONTENT:
Overview Of Oracle
Oracle history
Grid architecture
Application architecture - Client/Server v Multi-tier; Memory and Processes
Physical and logical structures - Files, Tablespaces; Segments, Extents and Blocks
The Oracle Instance - Database startup and shutdown
Management tools - Oracle Enterprise Manager, SQL*Plus
Exercise and quiz

Database Creation, Startup and Shutdown
DBA Privileges Levels - DBA, Security Officer, Network Administrator
Initialisation files
Database creation
Database startup, quiescing, shutdown
Alert log
Exercise and quiz

SGA and Background Processes
Introduction
Buffer cache
Redo log buffer
Shared pool
Program global area
Background processes
Transaction processing

Tablespaces and Tables
Design considerations - required tablespaces
Tablespace creation and management
Automated storage management
Table creation and management - constraints, triggers

Internal and External Files
Datafiles, segments and extents
Control files
Redo logs
Checkpoint processing
Archiving REDO logs

Performance and Tuning Overview
Self monitoring architecture
Disk tuning - Temporary storage, undo segments
Memory tuning - Buffer cache, shared pool, redo log buffer; locks
Statistics management
Oracle Advisors

Users, Roles and Profiles
User creation and management
Profiles
System privileges
Object privileges
Roles
Security and Auditing

Backup and Recovery
Cause of data loss
Structures used
Offline backups
Archiving redo logs
Online backups
Complete recovery principles
Incomplete recovery principles
Oracle Flashback overview

Oracle Net Services
Client/Server architecture - Connection and Naming methods (Easy, Local, Directory, External)
Local Networking and Internet-Working
Files - TNSNAMES.ORA / LISTENER.ORA / SQLNET.ORA / CMAN.ORA / OID (LDAP)
Advanced Features - Load Balancing and Failover

Oracle Utilities
Data Pump - Export and Import
SQL*Loader
Log Miner

Advanced Topics Overview
Performance - Table compression, indexing choices
OLAP processing - Materialized views, ETL solutions
Programming options - PL/SQL v Java
Content Management - XML, LOBs, Ultra Search
Globalisation - time zone, language, date and number formats