The overall objective of this training is threefold. First, this training instructs one in many of the day-to-day administration tasks required of an Oracle database administrator. Second, it is one of the training that assist in preparation for certification as an Oracle Certified Associated (OCA) database administrator. Finally, it introduces one to many of the administration sub-specialties that one might next pursue. It is increasingly rare for a single database administrator to fulfill all the required responsibilities necessary for management of an enterprise-scale Oracle database installation. Therefore, one may eventually specialize into backup and recovery strategies, database performance tuning, security administration and the like. So this textbook introduces the many powerful capabilities of the Oracle database and references the applicable textbooks within the Sideris Oracle database administration series that one might next consult.

Whenever appropriate this textbook demonstrates how an Oracle database installation integrates with its host environment, most commonly a Linux, Unix or MS Windows operating system platform. Extensive examples, workshop exercises and solutions are provided using the SQL command-line, the Enterprise Manager Database Express and the Enterprise Manager Cloud Control interfaces.

This textbook considers subjects helpful for multiple certifications, including such certifications as an Oracle Database 12c Administrator Certified Associate (OCA) "Exam: 1Z0-062: Oracle Database 12c: Installation And Administration".

Oracle Database: SQL Fundamentals

Oracle Database 12c: Install & Upgrade Workshop

Oracle Database 12c: Architecture & Internals

INTRODUCTION: MANAGING THE DATABASE INSTANCE

INTRODUCTION: DATABASE ARCHITECTURE REVIEW

INTRODUCTION: STARTING & STOPPING DATABASE SERVICES

INTRODUCTION: ORACLE NETWORK ENVIRONMENT

INTRODUCTION: DIAGNOSTICS & ORACLE SUPPORT

STORAGE: TABLESPACE MANAGEMENT

STORAGE: ADVANCED TABLESPACE MANAGEMENT

STORAGE: DATA FILES & TEMP FILES MANAGEMENT

STORAGE: UNDO DATA & UNDO TABLESPACES

SECURITY & SCHEMAS: SECURITY OVERVIEW & DATABASE PRIVILEGES

SECURITY & SCHEMAS: USER SECURITY

SECURITY & SCHEMAS: DATABASE AUDITING

SECURITY & SCHEMAS: SQL LOADER

SECURITY & SCHEMAS: EXPORT & IMPORT

PERFORMANCE & AVAILABILITY: MANAGING PERFORMANCE & SQL TUNING

PERFORMANCE & AVAILABILITY: DATA CONCURRENCY

PERFORMANCE & AVAILABILITY: BACKUP & RECOVERY CONCEPTS