"Essentials" covers everyday database administration tasks, as performed using the Enterprise Manager GUI. "Supporting Documentation" includes in-depth concept, task and reference material.
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 DBA||HTML|
|2 Day + Performance Tuning Guide||HTML|
|2 Day + Security Guide||HTML|
The documents below provide more extensive reference and advanced task material related to database administration.
|Performance Tuning Guide||HTML|
SQL, PL/SQL, and PL/SQL Packages
SQL statements and PL/SQL programs and packages are used extensively in administering Oracle databases.
|SQL Language Reference||HTML|
|SQL Language Quick Reference||HTML|
|PL/SQL Language Reference||HTML|
|PL/SQL Packages and Types Reference||HTML|
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 Guide||HTML|
|SQL*Plus User's Guide and Reference||HTML|
|SQL*Plus Quick Reference||HTML|
Detailed information on database features used to secure your data against unauthorized access.
|Advanced Security Administrator's Guide||HTML|
|Enterprise User Security Administrator's Guide||HTML|
|Label Security Administrator's Guide||HTML|
Oracle Net helps you manage connectivity, security, and performance across both Internet and intranet networks.
|Net Services Administrator's Guide||HTML|
|Net Services Reference||HTML|
Using Automatic Storage Management for Oracle databases.
|Storage Administrator's Guide||HTML|
Backup and Recovery
Use Recovery Manager (RMAN) or user-managed backup techniques to back up and recover Oracle databases.
|Backup and Recovery User's Guide||HTML|
|Backup and Recovery Reference||HTML|
Maximize availability of Oracle databases using Data Guard and other technologies.
|High Availability Overview||HTML|
|Data Guard Concepts and Administration||HTML|
|Data Guard Broker||HTML|
UNIX Platform Database Administration
Administration concepts and tasks specific to the Oracle Database on UNIX platforms.
|Administrator's Reference for Linux and UNIX||HTML|