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.

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.

 B enefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Objectives

• 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

Topics

• 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

Nguồn: Oracle Learning