This course is designed to provide you with a firm foundation in administration of an Oracle database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner.

Course objectives

• Describe Oracle Database architecture
• Describe Oracle Database Cloud Service (DBCS) architecture and features
• Create and manage DBCS database deployments
• Configure the database to support your applications
• Manage database security and implement auditing
• Implement basic backup and recovery procedures
• Move data between databases and files
• Employ basic monitoring procedures and manage performance

Target audience

• Database Administrator
• Data Warehouse Administrator
• Database Designer
• Support Engineer
• Technical Administrator

Prerequisites

A working knowledge of SQL is very helpful in the course. Suggested courses that will help you gain this knowledge:

Outline

• Introduction
• Oracle Database Architecture
• Introduction to Oracle Database Cloud Service
• Creating DBCS Database Deployments
• Accessing an Oracle Database
• Managing DBCS Database Deployments
• Managing Database Instances
• Understanding Oracle Net Services
• Administering User Security
• Creating PDBs
• Creating Master Encryption Keys for PDBs
• Creating and Managing Tablespaces
• Managing Storage Space
• Managing Undo Data
• Moving Data
• Backup and Recovery Concepts and Configuration
• Creating Database Backups
• Performing Database Recovery
• Monitoring and Tuning Database Performance
• SQL Tuning
• Miscellaneous