Oracle Database Administration – Introduction

3 day course

The overall objective of this course is to allow the reader to gain the skills necessary for basic day-to-day administration of an Oracle database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification. In this course, you will perform key administrative tasks in Oracle Database 10g, such as creating and controlling databases, administering users, implementing security features, monitoring performance, and performing backup and recovery.

Overview of Course Topics:
(for a full detailed outline, visit our PDF link above)

• Installing Oracle Database 10g
• Exploring the Oracle Database Architecture
• Creating a Database
• Configuring Oracle Net Services
• Using SQL and PL/SQL
• Managing the Database Instance
• Managing Tablespaces and Datafiles
• Managing Tables and Indexes
• Creating Views and Sequences
• Managing Users and Security
• Monitoring Performance
• Loading and Unloading Data
• Managing Undo Data
• Administering and Performing Backups
• Recovery Options