Oracle Autonomous Database (2022)

Course details

Are you looking for the next generation of cloud computing architecture to scale for your organization? The latest core infrastructure from Oracle can help your apps run even faster, more securely, using fewer resources than ever before. In this course, a unique offering from Oracle University, early-career learners get a comprehensive introduction to the basic concepts of the Oracle Autonomous Database in preparation for the Autonomous Database Specialist certification exam.

Explore the terminology and build your awareness of the main tenets of autonomous databases, including key constructs in database creation, shared and dedicated infrastructure, database management, monitoring, tools, development, migration, and more. Prepare yourself to apply this knowledge as a test taker with practical study tips and Oracle Certified technical instruction. Along the way, you can test out your new analytic skills in the corresponding videos, hands-on labs, demos, and practice challenges.

Concepts

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

1. Autonomous Database on Shared Infrastructure

05 - Welcome - Autonomous Database on shared infrastructure
06 - Start and stop ADB
07 - Provisioning
08 - Scaling
09 - Auto scaling
10 - Move ADB to another compartment
11 - Create an ADB clone
12 - Managing users
13 - Create alarms and events
14 - Manage ADB backup and restores
15 - Autonomous data guard
16 - Demo - Provisioning
17 - Demo - Start and stop ADB
18 - Demo - Scaling
19 - Demo - Move ADB to another compartment
20 - Demo - Create a ADB clone
21 - Demo - Backup and recovery
22 - Demo - Create events and alarms

2. Autonomous Database on Dedicated Infrastructure

23 - Welcome - Autonomous Database on dedicated infrastructure
24 - Dedicated infrastructure overview
25 - Describe workflows and functionality
26 - Provision dedicated resources - Exadata, container database, and VM cluster
27 - Monitoring dedicated infrastructure
28 - Creating OCI policies for autonomous dedicated
29 - Manage maintenance scheduling (patching)
30 - Managing encryption keys

3. Managing and Monitoring Autonomous Database

31 - Welcome - Managing and monitoring Autonomous Database
32 - Monitor Autonomous Database performance
33 - Setting up ACLs and private end points
34 - Setup service notifications
35 - Monitor auto scaling
36 - Monitor auto indexing
37 - Compartment quotas
38 - Using data safe
39 - Using REST APIs manage ADB
40 - Manage ADB using OCI CLI
41 - Patching and upgrades
42 - Connecting to Autonomous Database - Part 1
43 - Connecting to Autonomous Database - Part 2
44 - Connect to ADB using SQL developer
45 - ADB connectivity
46 - Use marketplace developer image to connect to Autonomous Database
47 - Configure disaster recovery (Autonomous Data Guard)
48 - Demo - Connect to ADB
49 - Demo - Monitor auto scaling
50 - Demo - Configure disaster recovery (Autonomous Data Guard)

4. Autonomous Database Tools

51 - Welcome - Autonomous Database tools
52 - Database actions
53 - APEX
54 - Oracle machine learning
55 - Data analysis
56 - Data transforms
57 - Business model
58 - Data insights and catalog
59 - Demo - SQL developer
60 - Demo - APEX
61 - Demo - Oracle machine learning

5. Developing on Autonomous Database

62 - Welcome - Developing on Autonomous Database
63 - Use Oracle autonomous JSON database terms and concepts
64 - Using autonomous JSON database
65 - Use Oracle text
66 - Spatial data on Oracle Autonomous Database
67 - Using Spatial Studio
68 - Using graphs in Oracle autonomous database overview
69 - Create and query graphs
70 - Graph Studio
71 - Integrating object storage data with Autonomous Database
72 - Demo - Use Oracle autonomous JSON database

6. Migration

73 - Welcome - Migration
74 - Migration options and considerations
75 - Migrating to autonomous database