Home
Home
Help
Help
Contact us
Contact Us

Oracle Database
  11g Release 1 (11.1)

Database Administration

"Essentials" covers everyday database administration tasks, as performed using the Enterprise Manager GUI. "Supporting Documentation" includes in-depth concept, task and reference material.

Real Application Testing User's GuideHTMLPDF

Essentials

2 Day DBA covers general database administration tasks and concepts. Each 2 Day + book covers more specialized tasks and concepts for specific advanced topics. All tasks are presented in the Enterprise Manager GUI. Supporting documentation describes command line-based methods.

2 Day DBAHTMLPDF
2 Day + Performance Tuning GuideHTMLPDF
2 Day + Security GuideHTMLPDF

Supporting Documentation

The documents below provide more extensive reference and advanced task material related to database administration.

Administrator's GuideHTMLPDF
ConceptsHTMLPDF
Performance Tuning GuideHTMLPDF
ReferenceHTMLPDF
Real Application Testing AddendumHTMLPDF

SQL, PL/SQL, and PL/SQL Packages

SQL statements and PL/SQL programs and packages are used extensively in administering Oracle databases.

SQL Language ReferenceHTMLPDF
SQL Language Quick ReferenceHTMLPDF
PL/SQL Language ReferenceHTMLPDF
PL/SQL Packages and Types ReferenceHTMLPDF

Clients for Database Administration

SQL*Plus is a command-line client used for running SQL statements and compiling PL/SQL code. SQL Developer provides all the same capabilities as SQL*Plus, as well as an easy-to-use, powerful drag-and-drop GUI for managing database objects and creating and viewing reports.

SQL Developer User's GuideHTMLPDF
SQL*Plus User's Guide and ReferenceHTMLPDF
SQL*Plus Quick ReferenceHTMLPDF

Security

Detailed information on database features used to secure your data against unauthorized access.

Security GuideHTMLPDF
Advanced Security Administrator's GuideHTMLPDF
Enterprise User Security Administrator's GuideHTMLPDF
Label Security Administrator's GuideHTMLPDF

Network Management

Oracle Net helps you manage connectivity, security, and performance across both Internet and intranet networks.

Net Services Administrator's GuideHTMLPDF
Net Services ReferenceHTMLPDF

Storage

Using Automatic Storage Management for Oracle databases.

Storage Administrator's GuideHTMLPDF

Backup and Recovery

Use Recovery Manager (RMAN) or user-managed backup techniques to back up and recover Oracle databases.

Backup and Recovery User's GuideHTMLPDF
Backup and Recovery ReferenceHTMLPDF

UNIX and Windows Database Administration

Administration concepts and tasks specific to the Oracle Database on a specific operating system.

Administrator's Reference for Linux and UNIXHTMLPDF
Platform Guide for Microsoft WindowsHTMLPDF

Testing

Oracle Real Application Testing enables you to perform real-world testing of Oracle Database.
Real Application Testing User's GuideHTMLPDF

Popular Topics

ASM, control files, databases, datafiles, database links, data dictionary (basic, advanced), DDL, DML, indexes, initialization parameters (basic, advanced), processes, scheduler, tables, tablespaces, views