Oracle Cloud Data Management Foundations Workshop (2022)

Course details

Do you know how to effectively use current database systems with modern data management strategies and tools? Or that you can use the Oracle Cloud Data Platform as an extension and complement to the other core Oracle databases? In this course, find out how to architect data management platforms to work together, simplify processes, and maximize your overall productivity, as you prepare for the Oracle Cloud Data Management 2022 Foundations Associate (1Z0-1105-22) certification exam.

Learn more about ways to reduce cost and improve your performance, reliability, and security outcomes, with experts from Oracle University. Get a comprehensive introduction to the latest data management tools designed uniquely for the Oracle platform, including Autonomous Database, Exadata Database Service, MySQL and NoSQL, converged database, resiliency, upgrades, and more. By the end of this course, you’ll be ready to leverage Oracle data management and machine learning solutions on the official exam.

Concepts

1. Data Management Introduction

01 - Oracle's data management strategy
02 - Oracle database offerings
03 - Multicloud and hybrid cloud
04 - OCI overview
05 - Demo - OCI console walk-through

2. Autonomous Database (ADB)

06 - Getting started with ADB
07 - Provisioning an ADB
08 - Start and stop ADB
09 - Autoscaling
10 - ADB tools

3. Exadata and Database Cloud Service (DBCS)

11 - Exadata deployment options
12 - Exadata lifecycle management
13 - DBCS offerings

4. MySQL and NoSQL

14 - MySQL data service and HeatWave - Overview
15 - MySQL data service architecture
16 - Manage MySQL data service
17 - Create, manage, and use HeatWave
18 - Oracle NoSQL database cloud service overview

5. Converged Database

19 - How to simplify application development
20 - Developing on ADB - Using JSON
21 - Developing on ADB - Using GraphQL
22 - Developing on ADB - Using Spatial Studio

6. Resiliency

23 - Oracle's maximum security architecture
24 - Oracle's maximum availability architecture

7. Developing on Oracle Database

25 - Managing an Oracle database with REST APIs
26 - Autonomous database built-in tools
27 - Data transforms
28 - Business models
29 - Data insights
30 - Catalog
31 - Low-code development using APEX
32 - CI CD for APEX and Oracle database developers

8. Data Lake, Data Warehouse, and Machine Learning

33 - Data Lakehouse on OCI
34 - Oracle machine learning
35 - Data mesh architecture

9. Upgrades and Migrations

36 - Migration use cases and solutions overview
37 - Database upgrade best practices

10. Prepare for the Data Management Foundation 2022 Associate Certification

38 - Prepare for the data management foundation certification