Oracle Autonomous Database Professional Workshop (January 2025)

Course details

This course teaches Oracle Cloud infrastructure terminology and is also a resource for those preparing for the Oracle Autonomous Database Cloud Specialist (1Z0-931-24) exam. Through lesson slides, corresponding videos and demonstrations, and hands-on labs, 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 - Module introduction
02 - Architectural components and key features
03 - Describe the different Autonomous Database offerings
04 - Describe the different Autonomous Database license types
05 - Understanding the OCI infrastructure

2. Autonomous Database Serverless

06 - Module introduction
07 - Create Autonomous Database serverless instances - Auto scaling
08 - Create Autonomous Database serverless instances - Provision ADB
09 - Create Autonomous Database serverless instances - Start and stop ADB
10 - Manage users
11 - Understand database consolidation with elastic resource pools
12 - Use cloning
13 - Move Autonomous Database
14 - Monitor Autonomous Database instances - Events and alarms
15 - Manage Autonomous Database backups and restores
16 - Describe Data Guard
17 - Describe ADB Dedicated and ADB Cloud@Customer - Dedicated infrastructure
18 - Describe ADB Dedicated and ADB Cloud@Customer - Workflows and functionality
19 - Provisioning dedicated resources
20 - Creating OCI policies for Autonomous Dedicated
21 - Monitor dedicated infrastructure
22 - Manage maintenance scheduling - Patching

3. Managing and Monitoring Autonomous Database

23 - Module introduction
24 - Manage Autonomous Database instances - Using REST APIs to manage ADB
25 - Manage Autonomous Database instances - Using OCI CLI to manage ADB
26 - Manage Autonomous Database instances - Patching, upgrades, and services
27 - Use an access control list (ACL) and private endpoints
28 - Manage encryption keys
29 - Monitor ADB performance
30 - Set up service notifications
31 - Use services in ADB - Auto indexing
32 - Use services in ADB - Data safe
33 - Use services in ADB - Compartment quotas
34 - Use ADB connectivity - Autonomous Database connectivity
35 - Use ADB connectivity - Connecting to ADB with SQL Developer and DB Actions
36 - Use ADB connectivity - Connect to ADB
37 - Use ADB connectivity - Encryption, credentials, and wallet
38 - Configure disaster recovery - Data Guard

4. Autonomous Database Tools

39 - Module introduction
40 - Describe Autonomous Database tools
41 - Use Autonomous Database with Oracle APEX
42 - Use Autonomous Database with Oracle SQL Developer Web - Database actions
43 - Use Autonomous Database with Oracle Machine Learning
44 - Create a business model
45 - Apply data insights
46 - Explain data analysis

5. Developing on Autonomous Database

47 - Module introduction
48 - Developing new and extending existing applications with natural language queries using generative AI
49 - Use Autonomous JSON Database
50 - Use Oracle Text
51 - Incorporate location-based analysis - Autonomous Spatial
52 - Use Autonomous Graph - Using Graph
53 - Use Autonomous Graph - Create a graph, query, analysis, and visualization
54 - Use Autonomous Graph - Using Graph Studio
55 - Explore data lake analytics with Autonomous Database
56 - Use data sharing in Autonomous Database

6. Migrate to Autonomous

57 - Module introduction
58 - Describe the options and considerations for migrating to Autonomous Database
59 - Migrate to Autonomous Database using Data Pump

7. Prepare for Oracle Autonomous Database Cloud Professional Certification

60 - Prepare for the Autonomous Database Cloud 2024 Professional certification - Part 1
61 - Prepare for the Autonomous Database Cloud 2024 Professional certification - Part 2
62 - Prepare for the Autonomous Database Cloud 2024 Professional certification - Part 3