Oracle Autonomous Database Workshop

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Call for In Class or Live Virtual Dates3$3,600 USDPurchase


OAUTDBWKSHP

Oracle Autonomous Database Workshop

You will receive an overview of Oracle Cloud Infrastructure (OCI) building blocks and its service offerings, exploring in detail Identity and Access Management and Virtual Cloud Network services in OCI. This will equip you with the necessary foundation skills in OCI to manage Oracle Autonomous Database Dedicated. As part of this training, you learn to create compartments, users, groups, policies, and network resources to implement access control and configure network isolation in OCI. These are necessary to deploy Autonomous Exadata Infrastructure and Autonomous Container Database.

Duration: 3 Days

Prerequisites

  • General understanding of cloud technology
  • Basic understanding of Oracle Database and related tools
  • Basic understanding of Oracle Multitenant architecture
  • Attended Oracle Autonomous Database Workshop
  • Working knowledge of administering Oracle Database Basic understanding of Oracle Cloud Infrastructure (suggested)

Audience

  • Cloud Administrators
  • Cloud Database Administrators
  • Fleet Administrators

Learning Objectives

  • Set up a private cloud in a public cloud for Oracle Autonomous Database Dedicated
  • Describe what Oracle Cloud Platform has to offer for database deployments in the cloud
  • Identify the building blocks of Oracle Cloud Infrastructure (OCI)
  • Get familiar with OCI terminology such as tenant, region, availability domain, and shapes
  • Identify available migration methods and tools
  • Migrate to Oracle Autonomous Database Dedicated
  • Review use cases
  • Describe Oracle Autonomous Database Dedicated Architecture
  • Implement Identity and Access Management in OCI
  • Enforce role separation and access control using OCI features
  • Create Virtual Cloud Network, subnets, and access rules to configure network isolation
  • Create and manage Autonomous Exadata Infrastructure
  • Create and manage Autonomous Container Database
  • Create Autonomous Database instances on a dedicated deployment
  • Connect to Autonomous Database instances on a dedicated deployment
  • Manage database users
  • Prepare to migrate your data
  • Migrate data using SQL Developer
  • Migrate On-Premises Oracle Database schema by using Data Pump
  • Use Oracle Machine Learning with Autonomous Database
  • Identify the typical workflow for using Autonomous Database
  • Monitor and manage Autonomous Database Cloud service instances
  • Load data into service instances

Topics

  • Oracle Autonomous Database Dedicated Overview
  • Getting Started with Oracle Cloud Infrastructure
  • Identity and Access Management in OCI
  • Virtual Cloud Network
  • Implement Access Controls and Network Isolation
  • Create and Manage Autonomous Exadata Infrastructure
  • Create and Manage Autonomous Container Database
  • Create Autonomous Database Instances on Dedicated Deployment
  • Connecting to Autonomous Database Dedicated
  • Managing Users in Autonomous Database
  • Migration Overview
  • Prepare to Migrate
  • Migrating Using SQL Developer
  • Migrating On-Prem Database Schema by Using Data Pump
  • Network Isolation by Subnet: Use Case
  • Best Practices & Connection Options for Autonomous Database Dedicated
  • Compartments in Autonomous Data Warehouses
  • Secure Connections to the Autonomous Data Warehouse Cloud
  • Database Services Levels
  • Connect to ADWC database to Load a Local File into ADWC
  • Querying External Data with Autonomous Data Warehouse Cloud
  • Using Oracle Machine Learning with Autonomous Data Warehouse Cloud
  • Oracle Machine Learning User Management
  • Running a SQL Statement

Oracle Autonomous Database Workshop

This training teaches you how to provision an Oracle Autonomous Database Cloud Service instance on Oracle Cloud that is suitable for your workload and requirements. This is a great starting point for Developers, Administrators, Architects and anyone who wants to learn about the first Autonomous Database in the market. Learn the key features of this self-driving, self-securing, self-repairing autonomous database service that can instantly scale to meet demands of mission-critical applications. You will see how these services enables you to focus on your core activity and not spend time creating and managing your IT systems. Taking this hands-on training will prepare you for the Oracle Autonomous Database Cloud certification exam.

Duration: 2 Days

Audience

  • Cloud Administrators
  • Cloud Database Administrators
  • Developers
  • Fleet Administrators

Learning Objectives

  • Describe the key features of Oracle Autonomous Database Cloud Service
  • Choose the instance type based on your workload requirement
  • Identify the typical workflow for using Autonomous Database
  • Provision an Oracle Autonomous Database Cloud Service instance in minutes
  • Connect to the cloud service instance using SQL Developer
  • Create a sandbox database for application testing in minutes
  • Use Oracle Machine Learning with Autonomous Database Cloud services
  • Work with data sets
  • Monitor and manage Autonomous Database Cloud service instances
  • Load data into service instances
  • Scale up and scale down resources as required
  • Terminate an Autonomous Database instance

Topics

  • Working with an Oracle Autonomous Data Warehouse Cloud Instance
  • Connecting to Autonomous Data Warehouse Cloud
  • Sample Data Sets in Autonomous Data Warehouse Cloud
  • Data Loading with Autonomous Data Warehouse Cloud
  • Querying External Data
  • Oracle Machine Learning Notebooks
  • Monitoring and Managing Autonomous Data Warehouse Cloud
  • Oracle Autonomous Transaction Processing Overview
  • Working with an Autonomous Transaction Processing Instance
  • Loading and Querying External Data with Autonomous Transaction Processing
  • Creating Dashboards, Reports, and Notebooks with Autonomous Transaction Processing
  • Managing Users in Autonomous Transaction Processing and Oracle Machine Learning
  • Monitoring Performance of Autonomous Transaction Processing
  • Backing Up and Restoring Autonomous Transaction Processing
  • Starting, Stopping, and Scaling Autonomous Transaction Processing
Right Menu IconMENU