Course Overview
The 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.
Upon completion of this program, candidates should be able 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.
Who Should Attend?
Database administrators, Application designers and developers, Web server administrators, System administrators, Implementation specialists, Data centre support engineers, Chief Information Officers (CIO) and other information technology (IT) management professionals
Pre-requisite
- Oracle Database 12c: SQL Fundamentals (Levels I & II)
- Oracle Database 12c: Install & Upgrade Workshop
- Oracle Database 12c: Architecture & Internals
Course Outlines
- 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
