COURSE OBJECTIVE
- This course consists of the Oracle Database 12c: Administration Workshop Ed 1 and the Oracle Database 12c: Install and Upgrade Workshop Ed 1 course. In this course, you will be introduced to Oracle Database Cloud Service.
- This course will teach you about the Oracle Database architecture and you will discover how to effectively manage an Oracle Database instance. You will also be provided key information on how to install and administer Oracle Database 12c
WHO CAN BENEFIT
- Technical Administrator
- Database Administrators
- Database Designers
- Support Engineer
GAINING SKILLS
After completing this course, students will be able to:
- Manage Oracle Database Storage structures
- Gain an understand of the Oracle Database Cloud Service
- Install Oracle Database 12c software
- Upgrade database to Oracle Database 12c
- Create an Oracle Database
- Create a container database
- Monitor the Database
- Manage Database Performance
- Implement Database Auditing
- Configure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and Tasks
- Schedule Jobs to Run Inside or Outside of the Database
- Configure Oracle Net Services
- Configure your Database For Backup and Recovery Operations
- Describe Oracle Database Architecture
- Manage the Oracle Database Instance
COURSE CERTIFICATION
OCA
PREREQUISITE
Before attending this course, students must have:
- Data processing
- Familiarity with data processing concepts and techniques
COURSE CONTENT
- Introduction
- Exploring the Oracle Database Architecture
- Oracle Software Installation Basics
- Installing Oracle Database Software
- Creating an Oracle Database by Using DBCA
- Oracle Database Management Tools
- Managing the Database Instance
- Configuring the Oracle Network Environment
- Administering User Security
- Managing Database Storage Structures
- Managing Space
- Managing Undo Data
- Managing Data Concurrency
- Implementing Oracle Database Auditing
- Backup and Recovery Concepts
- Backup and Recovery Configuration
- Performing Database Backups
- Performing Database Recovery
- Moving Data
- Performing Database Maintenance
- Managing Performance
- Oracle Database Cloud Service: Overview
ABOUT INSTRUCTOR
