Oracle Autonomous Database Administration Workshop

Course details

Oracle has introduced a new era of data management with the Oracle Autonomous Database. In this exam prep course for the Oracle Autonomous Database Cloud Specialist (1Z0-931-23) certification, learn what you need to know about deployment offerings, tools, and ways to migrate to this platform. Go over how to manage, secure, and develop on this platform. Build your knowledge and understanding of this important tool. This course empowers you to troubleshoot, think creatively, and push your skills to their limits, while being able to simplify database deployments and environments and reduce management workloads.

Concepts

1. Getting Started with Autonomous Database

01 - Welcome - Getting started with Autonomous Database
02 - Getting started with Autonomous Database
03 - Autonomous Database offerings type
04 - Autonomous Database license type

2. Oracle Cloud Free Tier Account

05 - Demo - Oracle Cloud Free Tier sign-up
06 - Demo - OCI console walk-through
07 - Demo - Setting up your tenancy
08 - Demo - MFA and budget setup

3. Fundamentals of Oracle Database

09 - Database architecture
10 - Database instance and memory structures
11 - Multitenant architecture
12 - Physical and logical structures and database objects
13 - Backup and recovery concepts
14 - Flashback
15 - Security

4. Autonomous Database on Shared Infrastructure

16 - Welcome - Autonomous Database on shared infrastructure
17 - Provisioning
18 - Start and stop ADB
19 - Scaling
20 - Auto scaling
21 - Move ADB to another compartment
22 - Create an ADB clone
23 - Managing Users
24 - Create alarms and events
25 - Manage ADB backup and restores
26 - Autonomous Data Guard
27 - Demo - Provisioning
28 - Demo - Start and stop ADB
29 - Demo - Scaling
30 - Demo - Move ADB to another compartment
31 - Demo - Create an ADB clone
32 - Demo - Backup and recovery
33 - Demo - Create events and alarms

5. Autonomous Database on Dedicated Infrastructure

34 - Welcome - Autonomous Database on dedicated infrastructure
35 - Dedicated infrastructure overview
36 - Describe workflows and functionality
37 - Provision dedicated resources - Exadata, container database, and VM cluster
38 - Monitoring dedicated infrastructure
39 - Creating OCI policies for Autonomous Dedicated
40 - Manage maintenance scheduling (patching)
41 - Managing encryption keys

6. Managing and Monitoring Autonomous Database

42 - Welcome - Managing and monitoring Autonomous Database
43 - Using REST APIs to manage ADB
44 - Manage ADB using OCI CLI
45 - Patching and upgrades
46 - Setting up ACLs and private end points
47 - Monitor Autonomous Database performance
48 - Set up service notifications
49 - Monitor auto scaling
50 - Monitor auto indexing
51 - Using Data Safe
52 - Compartment quotas
53 - ADB connectivity
54 - Managing the Database Wallet
55 - Database service names, wallet types, and connectivity options
56 - Connect to ADB using SQL developer and database actions
57 - Use Marketplace developer image to connect to Autonomous Database
58 - Configure disaster recovery (Autonomous Data Guard)
59 - Demo - Connect to ADB
60 - Demo - Monitor auto scaling
61 - Demo - Configure disaster recovery (Autonomous Data Guard)

7. Autonomous Database Tools

62 - Welcome - Autonomous Database tools
63 - Database actions
64 - APEX
65 - Oracle Machine Learning
66 - Data analysis
67 - Data transforms
68 - Business model
69 - Data insights and catalog
70 - Demo - SQL developer
71 - Demo - APEX
72 - Demo - Oracle Machine Learning

8. Developing on Autonomous Database

73 - Welcome - Developing on Autonomous Database
74 - Use Oracle Autonomous JSON database terms and concepts
75 - Using Autonomous JSON database
76 - Use Oracle Text
77 - Spatial on Oracle Autonomous Database
78 - Using Spatial Studio
79 - Using Graph in Oracle Autonomous Database overview
80 - Create and query graph
81 - Graph studio
82 - Integrating object storage data with Autonomous Database
83 - Demo - Use Oracle Autonomous JSON database

9. Migration

84 - Welcome - Migration
85 - Migration options and considerations
86 - Migrating to Autonomous Database