EssentialsDatabase Administration
"Essentials" covers everyday database administration tasks, as performed using the Enterprise Manager GUI. "Supporting Documentation" includes in-depth concept, task and reference material.
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 DBA | HTML | |
| 2 Day + Security Guide | HTML | |
| 2 Day + Performance Tuning Guide | HTML |
Supporting Documentation
Supporting documentation treats advanced topics related to database administration. In general, the 2 Day + books refer you to these topics when needed.
| Concepts | HTML | |
| Administrator's Guide | HTML | |
| Reference | HTML | |
| SQL Language Reference | HTML | |
| Performance Tuning Guide | HTML | |
| Error Messages | HTML |
SQL and PL/SQL
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 | |
| SQL Developer User's Guide | HTML | |
| Advanced Application Developer's Guide | HTML |
Clients for Database Administration
Oracle SQL Developer is a powerful easy-to-use GUI with browse, create, edit, and drag-and-drop capabilities for managing database objects, and creating and viewing reports. SQL*Plus is a command-line client used for running SQL statements and compiling PL/SQL code. SQL Developer has all the capabilities of SQL*Plus in a GUI-based interface.
| SQL Developer User's Guide | HTML | |
| SQL*Plus Release Notes | HTML | |
| SQL*Plus User's Guide and Reference | HTML | |
| SQL*Plus Quick Reference | HTML |
Security
Detailed information on database features used to secure your data against unauthorized access.
| Security Guide | HTML | |
| Advanced Security Administrator's Guide | HTML | |
| Enterprise User Security Administrator's Guide | HTML | |
| Label Security Administrator's Guide | HTML | |
| Database Vault Administrator's Guide | HTML |
Network Management
Oracle Net helps you manage connectivity, security, and performance across both Internet and intranet networks.
| Net Services Reference | HTML | |
| Net Services Administrator's Guide | HTML |
Storage
Using Automatic Storage Management for Oracle databases.
| Automatic Storage Management 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 | |
| Advanced Replication Management API Reference | HTML |
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 UNIX-Based Operating Systems | HTML | |
| Platform Guide for Microsoft Windows | HTML |
Testing
Oracle Real Application Testing enables you to perform real-world testing of Oracle Database.| Real Application Testing User's Guide | HTML |
