Oracle Autonomous Database Workshop

Topics

• Oracle Cloud Platform for Database in the Cloud
• Oracle Cloud Infrastructure Essentials
• Oracle Autonomous Database Overview
• Provisioning an Oracle Autonomous Database
• Connecting to Autonomous Database
• Data Loading and Querying External Data
• Managing Users
• Using Oracle Machine Learning with Autonomous Database
• Monitoring and Managing Autonomous Database
• Backing Up and Restoring an Autonomous Database
• Starting, Stopping, Scaling, and Terminating an Autonomous Database
• Oracle Cloud Infrastructure Security
• Managing an Autonomous Database Using Command Utilities and APIs
• Migrating Oracle Databases to Autonomous Database: Overview
• Oracle Autonomous Database: Use Cases

• Oracle Autonomous Database Overview
• Oracle Autonomous Database: Optimized by Workload
• Full Database Lifecycle Automation: How It Works
• Oracle Autonomous Data Warehouse Cloud Key Features
• Use Cases For Autonomous Data Warehouse Cloud

Working with an Oracle Autonomous Data Warehouse Cloud Instance

• Create an Oracle Autonomous Data Warehouse Instance
• Compartments in Autonomous Data Warehouses
• Automated Management

Connecting to Autonomous Data Warehouse Cloud

• Connecting to Autonomous Data Warehouse Cloud
• Secure Connections to the Autonomous Data Warehouse Cloud
• Download Client Credentials (Wallets)
• Working with Autonomous Data Warehouse Cloud Service Console

Sample Data Sets in Autonomous Data Warehouse Cloud

• Work with the Sample Data Sets in Autonomous Data Warehouse Cloud
• Database Services Levels
• Run a Query in SQL Developer

Data Loading with Autonomous Data Warehouse Cloud

• Data Loading Options
• Connect to ADWC database to Load a Local File into ADWC
• Data Loading from Cloud Object Storage Using SQL Developer Import Wizard
• Data Loading from Cloud Object Storage Using PL/SQL
• Monitoring and Troubleshooting Loads

Querying External Data

• Querying Data on the Oracle Object Store
• Querying External Data with Autonomous Data Warehouse Cloud
• External Table for Source Data
• Query Data with External Table

Oracle Machine Learning Notebooks

• Using Oracle Machine Learning with Autonomous Data Warehouse Cloud
• Oracle Machine Learning User Management
• Working with Oracle Machine Learning for Data Access, Analysis, and Discovery
• Built-in SQL Worksheet and Notebook
• Running a SQL Statement

Monitoring and Managing Autonomous Data Warehouse Cloud

• Monitoring the Performance of Autonomous Data Warehouse Cloud
• Automated Management, Tuning and Instant Elasticity
• Managing Run-Away SQL Statements on Autonomous Data Warehouse Cloud
• Monitoring SQL Statements
• Managing Optimizer Statistics and Hints on Autonomous Data Warehouse Cloud
• Starting, Stopping, and Scaling Autonomous Data Warehouse Cloud
• Backing Up and Restoring Autonomous Data Warehouse Cloud

Oracle Autonomous Transaction Processing Overview

• Autonomous Transaction Processing Architecture
• Autonomous Transaction Processing: Key Features
• Typical Workflow for Autonomous Transaction Processing
• Using Oracle Machine Learning with Autonomous Transaction Processing
• Securing Autonomous Transaction Processing

Working with an Autonomous Transaction Processing Instance

• Provisioning an Autonomous Transaction Processing Instance
• Compartments in Autonomous Transaction Processing
• Connecting to an Autonomous Transaction Processing Instance
• Securing Connections to Autonomous Transaction Processing
• Predefined Database Service Names
• Connecting Using Oracle Database Tools

Loading and Querying External Data with Autonomous Transaction Processing

• Loading Data with Autonomous Transaction Processing
• Loading Data from Files in the Cloud
• Importing Data Using Oracle Data Pump
• Loading Data from Local Files Using SQL*Loader
• Querying External Data with Autonomous Transaction Processing
• Querying External Data
• Validating External Data

Creating Dashboards, Reports, and Notebooks with Autonomous Transaction Processing

• Creating Dashboards, Reports, and Notebooks
• Accessing the Oracle Machine Learning User Management Page
• Working with OML for Data Access, Analysis, and Discovery
• Working with Analytics and Visualization
• Oracle Analytics Cloud with Autonomous Transaction Processing

Managing Users in Autonomous Transaction Processing and Oracle Machine Learning

• Creating and Removing Users in Autonomous Transaction Processing
• Creating and Removing Users with Autonomous Transaction Processing
• Managing the Administrator Account in Autonomous Transaction Processing
• Creating User Accounts in Oracle Machine Learning

Monitoring Performance of Autonomous Transaction Processing

• Monitoring the Performance of Autonomous Transaction Processing
• Monitoring Activity and Utilization
• Monitoring SQL Statements
• Managing Concurrency and Priorities
• Managing Run-Away SQL Statements
• Managing Optimizer Statistics and Hints

Backing Up and Restoring Autonomous Transaction Processing

• Backup and Recovery on Autonomous Transaction Processing
• Restoring and Recovering on Autonomous Transaction Processing
• Manual Backups on Autonomous Transaction Processing

Starting, Stopping, and Scaling Autonomous Transaction Processing

• Starting and Stopping Autonomous Transaction Processing
• Terminating Autonomous Transaction Processing
• Scale Up Autonomous Transaction Processing resources
• Scaling Up and Down Resources
• Adding/Removing CPU or Storage Resources