Course Outline

Oracle Database 12c: Administration Workshop Day
ORCL-1102 | Day | 5 DaysThe Oracle Database 12c: Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance.
Learn To:
- Create and manage an Oracle Database Instance.
- Create and manage Storage Structures.
- Configure the Oracle Network Environment.
- Create and manage users.
- Monitor the database and manage performance.
- Learn basic information on backup and recovery techniques.
- Use the Oracle Support Workbench and My Oracle Support to update your Oracle Database software.
Upcoming Dates:

Who should take this course
This course is designed for the following audiences:
- Database Administrators
- Technical Administrator
- Support Engineer
- Technical Consultant
Course Objectives
After completing this course, students will be able to:
- Back up, restore, and patch DBCS database deployments
- Describe the DBaaS and on-premises Oracle Database architectures
- Manage database instances
- Manage UNDO data
- Move data between databases
- Implement basic backup and recovery procedures
- Monitor and tune database performance
- Tune SQL to improve performance
- Manage resources with Oracle Database Resource Manager
- Create pluggable databases (PDBs)
- Configure the Oracle network environment
- Administer user security and implement auditing
- Create and manage tablespaces
- Manage storage space
- Create and manage Database as a Cloud Service (DBCS) database deployments
- Register databases and manage performance with Enterprise Manager Cloud Control
Course Outline
- Getting Started
- Exploring Oracle Database Architecture
- Managing Database Instances
- Creating PDBs
- Configuring the Oracle Network Environment
- Administering User Security
- Creating and Managing Tablespaces
- Managing Storage Space
- Managing UNDO Data
- Moving Data
- Backup and Recovery Concepts
- Monitoring and Tuning Database Performance
- SQL Tuning
- Oracle Database Resource Manager
- Enterprise Manager Cloud Control
- Introduction to Oracle Database Cloud Service
- Creating DBCS Database Deployments
- Managing DBCS Database Deployments
- Backing Up and Restoring DBCS Database Deployments
- Patching DBCS Database Deployments
- Creating Master Encryption Keys for PDBs
- Tablespace Encryption by Default