• Database Administrators
• Database Administrators
• Database Designers
• Database Designers
• Support Engineer
• Support Engineer
• Technical Administrator
• Technical Administrator
• Data Warehouse Administrator
• Data Warehouse Administrator
• Data Warehouse Administrator

• 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

• A working knowledge of SQL and PL/SQL packages is very helpful in the course.
• Basic knowledge of Linux operating system

Exploring Oracle Database Architecture

• Querying the Oracle Data Dictionary
• Oracle Database Tools
• Oracle-Supplied User Accounts
• Oracle Database Server Architecture
• Oracle SQL and PL/SQL
• Connecting to Oracle Databases
• Introducing Oracle Database
• Relation Database Models

ManagingDatabase Instances

• Initialization Parameter Files
• Opening and Closing PDBs
• Starting Up Oracle Databases
• Shutting Down Oracle Databases
• Querying Dynamic Performance Views
• Working with the Automatic Diagnostic Repository (ADR)

CreatingPDBs

• Methods and Tools to Create PDBs
• Dropping PDBs with SQL*Plus
• Unplugging and Pluggin In PDBs with SQL*Plus
• Cloning PDBs with SQL*Plus
• Creating PDBs from Seed with SQL*Plus

Configuringthe Oracle Network Environment

• Configuring Listeners for Static Service Registration
• Dedicated Versus Shared Server Configurations
• How Listeners Work
• Testing Oracle Net Connectivity with tnsping
• Configuring Listeners for Dynamic Service Registration
• Oracle Net Services
• Configuring Local Naming for Connections
• Configuring Communidation Between Databases

AdministeringUser Security

• Authenticating Users
• Assigning Quotas to Users
• Creating Users
• Granting Privileges
• Creating and Granting Roles
• Creating and Assigning Profiles
• Applying the Principal of Least Privilege
• Revoking Privileges and Roles

Creatingand Managing Tablespaces

• Implementing Oracle Managed Files
• Creating Tablespaces in SQL*Plus
• Moving and Renaming Online Data Files in SQL*Plus
• Viewing Tablespace Information in SQL*Plus
• How Table Data is Stored
• Altering and Dropping Tablespaces in SQL*Plus

ManagingStorage Space

• Block Space Management
• Allocating Extents
• Free Space Management Within Segments
• Row Chaining and Migration
• Space-Saving Features
• Types of Segments
• Oracle Database Space Management Features
• Understanding Deferred Segment Creation

ManagingUNDO Data

• Local Undo Mode Versus Shared Undo Mode
• Comparing Undo Data and Redo Data
• Undo Data: Overview
• Configuring Undo Retension
• Categories of Undo
• Storing Undo Information
• Transactions and Undo Data
• Managing Undo

Moving Data

• Oracle Data Pump: Benefits
• Data Pump Export and Import Clients
• SQL*Loader Overview
• Data Pump Utility: Interfaces and Modes
• Loading Methods
• Oracle Data Pump: Overview
• Data Pump Import: Transformations
• Moving Data: General Architecture

Backup andRecovery Concepts

• Categories of Failure
• Understanding Types of Backups
• Understanding Instance Recovery
• Flashback Technology
• DBA Responsibilities
• Oracle Data Protection Solutions
• Comparing Complete and Incomplete Recovery

Monitoringand Tuning Database Performance

• Database Maintenance
• Automatic Database Diagnostic Monitor
• Automatic Workload Repository (AWR)
• Database Server Statistics and Metrics
• Performance Tuning Methodology
• Performance Planning Considerations
• Managing Performance Activities
• Performance Monitoring

SQL Tuning

• Oracle Optimizer
• SQL Access Advisor
• SQL Plan Directives
• SQL Tuning Advisor
• SQL Tuning Process
• Optimizer Statistics
• Adaptive Execution Plans
• SQL Performance Analyzer

OracleDatabase Resource Manager

• Resource Manager Elements
• Limiting CPU Utilization at the Database Level
• Using the Active Session Pool Feature
• Creating a Complex Resource Plan
• Oracle Database Resource Manager: Overview
• Limiting CPU Utilization at the Server Level
• Creating a Simple Resource Plan
• Using Resource Manager to Allocate Resources

EnterpriseManager Cloud Control

• Controlling the Enterprise Manager Cloud Control Framework
• Starting the Enterprise Manager Cloud Control Framework
• Stopping the Enterprise Manager Cloud Control Framework

Introductionto Oracle Database Cloud Service

• DBCS Architecture
• Oracle Cloud: Overview
• Additional Database Configuration Options
• Features and Tooling
• Database Cloud Service Offerings

CreatingDBCS Database Deployments

• Creating a Database Deployment
• Automated Database Provisioning
• Creating an SSH Key Pair
• How SSH Key Pairs are Used
• Storage Used for Database Files

ManagingDBCS Database Deployments

• Managing Network Access to DBCS
• Cloud Tooling
• Accessing Tools and Features from the DBCS Console
• Enabling Access to a Compute Node Port
• Scaling a Database Deployment
• Managing the Compute Node Associated With a Database Deployment

Backing Upand Restoring DBCS Database Deployments

• Backing Up and Recovering Databases on DBCS
• Creating an On-Demand Backup
• Performing Recovery by Using the Console
• Performing Recovery by Using the dbaascli Utility
• Backup Configuration
• Customizing the Backup Configuration
• Backup Destination Choices

PatchingDBCS Database Deployments

• Using the dbaascli Utility to Manage Patches
• Using the DBCS Console to Manage Patches
• Patching DBCS

CreatingMaster Encryption Keys for PDBs

• Creating and Activating an Encryption Key
• Determining Whether You Need to Create and Activate and Encryption Key for a PDB
• CDB and PDB Master Encryption Keys

TablespaceEncryption by Default

• Using TDE
• Defining the Keystore Location
• Transparent Data Encryption (TDE) Overview
• Managing the Software Keystore and Master Encryption Key
• Managing the Keystore in CDBs and PDBs
• Components of TDE
• Tablespace Encryption by Default in DBCS
• Controlling Tablespace Encryption by Default