Oracle 10g DBA Training Course

Book
Public Course

Get a Closed
Course Quote

Get an Instructor-led
Online Course Quote

Too Expensive?
Submit Your Price

Request Public
Course Date

Node ID: 3083

Duration

28 hours

Requirements

A grounding in relational database concepts; familiarity with the use of graphical user interfaces and either Windows or Linux operating systems.

Some expertise with both SQL and PL/SQL in an Oracle environment is beneficial, although basic concepts of both languages are covered briefly in this class.

Each delegate will require exclusive use of a suitably equipped PC, together with a single CD containing Oracle 10g Release 2 for Windows or Linux as appropriate. Please consult the Oracle TechNet website to review the Installation Notes Hardware Requirements for Windows or Linux - free registration is required to view this website.

Public Course Dates

Venue

There is no public course dates for this training.
This course would cost you around 2900GBP + VAT.
Please submit a public course date request for the exact price.

Overview

Oracle 10g is the first database product from the Oracle Corporation designed for grid computing. As a "self-managing" database, many of the features in this product have been simplified or automated. This class utilises the graphical management tools introduced with Oracle 10g to familiarise delegates with creating and administering physical and logical file structures in this powerful relational database product.

By completing this class, and with some further hands-on practice, delegates will be prepared to undertake the Oracle Database 10g Administrator Certified Associate (OCA) Exam (code 1Z0-042). Please note that candidates who wish to obtain the more advanced Oracle Database 10g Certified Professional (OCP) credential must attend one Oracle authorised instructor-led class or instructor-led online class.

The class consists of a mixture of lecture and hands on lab exercises.

Course Outline

Who Should Attend

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

For experienced DBA's cross training from other RDBMS products or earlier versions of Oracle, this class can be run in a shortened three day format.

Content

Oracle 10g Architecture: Memory, process and disk structure; instances and databases; storage structures; processing for queries, updates and transactions.
Installing Oracle 10g: Making installation decisions, installing Oracle 10g software, using the DBCA to configure a starter database, installing sample schemas, examining installed files, resolving installation problems.
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.
Database Interfaces: Using SQL*Plus and iSQL*Plus; accessing data and structure; using query, manipulation and transaction commands; creating, altering and dropping database information.
Starting and Stopping Oracle: Starting processes - dbconsole, listener, isqlplus, database instance; startup modes; parameter file; alert log; shutdown operations.
Tablespaces and Datafiles: Purpose and use of tablespaces and datafiles; create, manage, drop tablespaces; system tablespaces and user tablespaces; retrieving status information for tablespaces and datafiles.
Schema Objects: Creating and modifying tables; selecting appropriate data types; constraints; viewing table contents; creating and managing indexes and views; creating and using sequences.
Undo Management: Undo/rollback concepts; configure and size undo features; using the Undo Advisor; undo tablespaces; undo for transactions and rollback/recovery.
Data Administration: Moving data using DML; Data Pump for export and import; SQL Loader for importing external data; administering Oracle directories.
PL/SQL for DBA's: PL/SQL Overview; anonymous blocks; procedures, functions, packages; triggers; supplied procedures.
User Administration: Creating and managing user accounts; profiles, roles, privileges and user assignment; user resource management.
Database Security: Security principles; default user accounts; password management features; auditing database actions.
Network Administration: Managing Oracle listener; Net services; connect time failover; using Net Manager to configure resolution methods, database connectivity; configuring and administering shared servers.
Backup and Recovery Concepts: Overview of backup and recovery; failure point identification; configuring checkpoints, redo logs, archiving; configure database for recovery; RMAN overview; flash recovery area.
Database Backups: Cold and hot datafile/tablespace backups; automated backups; incremental backups; image copies; multiplexed archive logs; control file backups; spfile/password file backups.
Database Recoveries: Restore and recovery overview; non-critical datafile recovery; critical file recovery; recovering damaged archive logs; recovering control files.
Lock Management: Overview; detecting locking issues; transactions and locking; configuring optimum lock strategies; resolving potential deadlocks.
Performance Guidelines: Performance issues; SQL optimiser statistics; gathering performance metrics; Enterprise Manager performance features.
Diagnostics and Tuning: Setting automated alerts; collecting baseline metrics; using advisors; Automatic Database Diagnostic Monitor; Automated Workload Repository; responding to server alerts.
Q&A: Where to now?; suggested reading list; further training.