Oracle Cloud Data Management Foundations Workshop (2022)
5h 45mIntermediate2022-11-16
Authors
Oracle University
Building Cloud Proficiency on Oracle Cloud Infrastructure
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.
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.
Skills covered
Oracle Cloud InfrastructureOracle DatabaseData Resource ManagementCloud AdministrationOracleDatabase ManagementCloud ComputingOne-Off
Concepts
Data Management Introduction
- Oracle's data management strategy
- Oracle database offerings
- Multicloud and hybrid cloud
- OCI overview
- Demo - OCI console walk-through
Autonomous Database (ADB)
- Getting started with ADB
- Provisioning an ADB
- Start and stop ADB
- Autoscaling
- ADB tools
Exadata and Database Cloud Service (DBCS)
- Exadata deployment options
- Exadata lifecycle management
- DBCS offerings
MySQL and NoSQL
- MySQL data service and HeatWave - Overview
- MySQL data service architecture
- Manage MySQL data service
- Create, manage, and use HeatWave
- Oracle NoSQL database cloud service overview
Converged Database
- How to simplify application development
- Developing on ADB - Using JSON
- Developing on ADB - Using GraphQL
- Developing on ADB - Using Spatial Studio
Resiliency
- Oracle's maximum security architecture
- Oracle's maximum availability architecture
Developing on Oracle Database
- Managing an Oracle database with REST APIs
- Autonomous database built-in tools
- Data transforms
- Business models
- Data insights
- Catalog
- Low-code development using APEX
- CI CD for APEX and Oracle database developers
Data Lake, Data Warehouse, and Machine Learning
- Data Lakehouse on OCI
- Oracle machine learning
- Data mesh architecture
Upgrades and Migrations
- Migration use cases and solutions overview
- Database upgrade best practices
Prepare for the Data Management Foundation 2022 Associate Certification
- Prepare for the data management foundation certification