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

Privacy Policy