Oracle Base Database Services Professional Workshop

Course details

Important skills for implementation and management are the main topics of this course. An in-depth knowledge and set of skills are demonstrated by an Oracle Base Database Services Certified Professional. Join expert instructors from Oracle University to find out more about what you need to know to tackle the Oracle Base Database Services 2023 Certified Professional certification exam.

Gather insights on how to configure, monitor, and manage Virtual Machine DB Systems, Exadata Database Service, MySQL Database and HeatWave, NoSQL Database Cloud Service, and Database Management Service. Along the way, get tips and best practices to prepare for the official certification exam.

Concepts

1. Oracle Base Database Service

01 - Oracle Base Database Service overview
02 - Create an Oracle Base Database Service
03 - Manage an Oracle Base Database Service
04 - Database lifecycle management on a virtual machine DB system
05 - Database metrics and management interfaces
06 - Demo - Create a VCN
07 - Demo - Create a VM DB system
08 - Demo - Create a custom database software image
09 - Demo - Changing the shape of a VM DB system
10 - Demo - Scale the storage for a VM DB system
11 - Demo - Patch a virtual machine DB system
12 - Demo - Changing the license type of a VM DB system
13 - Demo - Create PDB in an existing DB system
14 - Demo - Configuring automatic backups for a database on a VM DB system
15 - Demo - Enable Data Guard for a VM DB system

2. Exadata Database Service

16 - Exadata Database Service overview
17 - Exadata - Network, infrastructure, VM cluster overview
18 - Exadata infrastructure and VM cluster management
19 - Database lifecycle management
20 - Management tools
21 - Demo - Creating an Exadata Cloud Infrastructure for your Exadata Database Service on dedicated infrastructure
22 - Demo - Provision Exadata Database Service on Cloud@Customer infrastructure
23 - Demo - Creating a VM cluster network and provisioning a VM cluster on an Exadata Database Service on Cloud@Customer
24 - Demo - Creating an Exadata Cloud VM cluster on your Exadata Database Service on dedicated infrastructure
25 - Demo - Creating a database home on your Exadata Database Service on dedicated infrastructure
26 - Demo - Creating an Oracle Database on your Exadata Database Service on dedicated infrastructure
27 - Demo - Create a custom database software image
28 - Demo - Creating a pluggable database on your Exadata Database Service on dedicated infrastructure
29 - Demo - Managing pluggable databases on your Exadata Database Service on dedicated infrastructure
30 - Demo - Configuring automatic backups for a database on your Exadata Database Service on dedicated infrastructure
31 - Demo - Create a backup destination on Exadata Database Service on Cloud@Customer
32 - Demo - Create an on-demand full backup of a database on your Exadata Database Service on dedicated infrastructure
33 - Demo - Enable Oracle Data Guard on Exadata Database Service on dedicated infrastructure
34 - Demo - Perform a database switchover using Oracle Data Guard
35 - Demo - Perform a database failover and reinstate a database using Oracle Data Guard
36 - Demo - Perform a patch operation on a Database Home on an Exadata Database Service on dedicated infrastructure
37 - Demo - Perform a Grid Infrastructure patch operation on a VM cluster on your Exadata Database Service on Cloud@Customer
38 - Demo - Updating a guest VM operating system on Exadata Database Service on Cloud@Customer
39 - Demo - Scale VM cluster OCPU resources on Exadata Database Service on Cloud@Customer

3. MySQL Database Service and HeatWave Overview

40 - MySQL HeatWave database service overview
41 - Provision and connect to MySQL database service
42 - Create, manage, and use HeatWave
43 - Operate MySQL database service

4. NoSQL Database Service Cloud Overview

44 - Oracle NoSQL Database Cloud Service overview
45 - Security
46 - Instant elasticity at table level
47 - Data models
48 - Throughput
49 - Connect applications to Oracle NoSQL Database Cloud Service

5. Database Management Service Overview

50 - Configure a database management service for external databases
51 - Configure a database management service for Base Database Service
52 - Install and configure management agents for database management
53 - Observability and management for OCI databases

Oracle Base Database Services Professional Workshop

Authors

Oracle University