Tutorial Title

Oracle Database Administration class lessons 1-12. Click here for lessons 13-27 (free registration required).

Lesson 1. Introduction to the Oracle Data Dictionary

This tutorial provides an Introduction to the Oracle Data Dictionary from the perspective of the DBA. Diagrams, examples and queries against the Oracle Data Dictionary views support the descriptive text.

Lesson 2. Oracle 9i Architecture: Files

An introduction to Oracle Architecture with an in-depth look at the operating system files that make up the database.

Lesson 3. Oracle 9i Architecture: Processes

An overview of Oracle Background Processes.

Lesson 4. Oracle 9i Architecture: Memory

An in-depth lesson on the memory areas used by the Oracle Database such as the SGA and PGA.

Lesson 5. Creating Oracle Administrative Users

A practical and hands-on lesson on creating and using Oracle administrative users.

Lesson 6. Starting and Stopping an Oracle Instance

An in-depth, hands-on lesson on using the Oracle STARTUP and SHUTDOWN commands to start and stopn an Oracle database.

Lesson 7. Oracle Initialization Parameter files

Learning how to start an Oracle database with non-default parameter files, change parameter values and work with 9i SPFILES.

Lesson 8. Creating and Managing Oracle Users

Administrative processes needed to create and manage all users of the Oracle database.

Lesson 9. Oracle Password Management

A hands-on lesson on Oracle password aging, locking and complexity routines.

Lesson 10. Introduction to Oracle Database Auditing

A hands-on tutorial on recording user activity in the Oracle Database.

Lesson 11. Managing Oracle Security

A discussion of Security related tasks for the Oracle DBA.

Lesson 12. Managing Oracle Tablespaces

Creating and managing locally managed tablespaces, including a discussion of Automatic Segment Storage Management (ASSM) and Oracle Managed Files (OMF).

Click here for lessons on Managing Oracle Tables, Indexes, Constraints, Undo, Redo Logs, Control files, RMAN, Logical Backups (Import and Export Utilities), SQL Loader, Oracle Networking, User Managed Backups and Partitioning.

Oracle 9i and 10g New Features Tutorials for Database Administrators

Oracle 10g Backup Recovery RMAN New Features

This lesson, intended for Oracle DBAs, covers 10g features related to RMAN and backup and recovery. It is an excerpt from our Oracle 10g New Features Overview by Example book. It is good preparation for Oracle Certification exam 1Z0-040.

Oracle 10g Flashback Enhancements

This lesson, intended for Oracle DBAs, is an excerpt from our Oracle 10g New Features Overview by Example book. This tutorial is also helpful preparation for Oracle Certification exam 1Z0-040.

Oracle10g: Intro to DataGuard

This lesson, intended for experienced Oracle users, provides a summary of the features found in Oracle 10g Dataguard

Oracle 9i Performance and Tuning Enhancements

This lesson, intended for Oracle DBAs and Oracle Developers, is an excerpt from our Oracle 9i Differences for DBAs book.

Oracle 10g RMAN Enhancements

This lesson, intended for Oracle DBAs, is an excerpt from our Oracle 10g New Features Overview by Example book. It will help you prepare for Oracle Certification exam 1Z0-040.

Introduction to Oracle Recovery Manager (RMAN)

This lesson, intended for Oracle DBAs, is an excerpt from our Backup & Recovery with RMAN book.

Using Server Parameter Files (SPFILE) with an Oracle Database

This lesson, intended for Oracle DBAs, is an excerpt from our Oracle 9i Differences for DBAs book.

Oracle 9i SGA Management

This lesson, intended for Oracle DBAs, is an excerpt from our Oracle 9i Differences for DBAs book. This tutorial covers SGA-related parameters such as DB_CACHE_SIZE and SGA_MAX_SIZE, multiple database block size support (subcaches), how to dynamically change shared memory allocations (including examples of v$sga_dynamic_components) and the cache advisories.

Oracle SQL Tuning for Developers and DBAs, lessons 1-6. Click here for lessons 7-14.

Lesson 1. Introduction to Oracle SQL Tuning

This lesson will provide you with a foundation in Oracle SQL Tuning.

Lesson 2. Oracle SQL Statement Processing

This lesson provides an introduction to what is involved in executing a SQL statement, including the related Oracle architecture.

Lesson 3. Creating & Reading Oracle Execution Plans

This is a hands-on, in-depth lesson on displaying and reading Oracle execution plans, including how to use EXPLAIN PLAN, V$SQL_PLAN and SQL*Plus Autotrace.

Lesson 4. Oracle SQL Trace & 10053 Event

This lesson provides a practical introduction to Oracle SQL Trace, TKPROF and the 10053 Event Trace.

Lesson 5. Getting to Know CBO

This is a discussion in effective use of the Oracle Cost-Based Optimizer (CBO).

Lesson 6. All About B-Tree Indexes in Oracle

This lesson will provide an introduction to Oracle B-Tree indexes.

Introduction to SQL, PL/SQL, Application Express and More (back to top)

Using Oracle SQL*Plus

This introductory Oracle SQL lesson is an excerpt from our Introduction to Oracle: SQL & SQL*Plus book.

Introduction to the Oracle SQL SELECT Statement

This introductory Oracle SQL lesson is an excerpt from our Introduction to Oracle: SQL & SQL*Plus book.

Oracle10g SQL*Plus Enhancements

This lesson, intended for a general audience, is an excerpt from our Oracle10g New Features Overview book.

Introduction to Oracle PL/SQL

This lesson, intended for Oracle Developers and Oracle DBAs, is an excerpt from our PL/SQL Programming book.

SQL DECODE and Oracle9i CASE Statement

This lesson is an excerpt from our Advanced SQL Queries for Oracle9i Databases book.

Oracle10g SQL Enhancements

This lesson, intended for Oracle DBAs and Oracle Developers, is an excerpt from our Oracle 10g New Features Overview book.

Introduction to Oracle Application Express

This lesson, intended for experienced Oracle users, provides a summary of the features found in Oracle Application Express

Click here for Advanced Oracle Tutorials (free registration required).                    (back to top)