Oracle Autonomous Database Workshop

Course Fees: $1278.00 excl. GST
Printed Manual: $40.00 excl. GST
Course Duration: 1 days
Course Manual

Wellington

22 Apr - 22 Apr

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 those self-driving, self-securing, self-repairing autonomous database services that can instantly scale to meet demands of mission-critical applications. You will learn about the Autonomous Data Warehouse service that is tuned and optimized for data warehouse workloads and Autonomous Transaction Processing service tuned and optimized for transaction processing or mixed workloads.

You will see how these services enables you to focus on your core development activity and not spend time creating and managing you data source.

Learn To:

  • Describe the key features of Oracle Autonomous Database Cloud Service
  • Choose the instance type based on your workload requirement
  • Provision an Oracle Autonomous Data Warehouse Cloud Service instance in minutes
  • Provision an Oracle Autonomous Transaction Processing 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
  • Scale up and scale down resources as required
  • Terminate the database instance in minutes
  • Cloud Database Administrators
  • Cloud Data Architects
  • Cloud Technical Consultants
  • Cloud Architect
  • Developer
  • Cloud Administrator
  • Cloud Database Developer
  • Cloud Application Developer
  • Use Oracle Machine Learning with Autonomous Data Warehouse & Transaction Processing instances
  • Provision Autonomous Data Warehouse & Autonomous Transaction Processing instances
  • Identify the typical workflow for using Autonomous Database Cloud Services
  • Work with sample data sets
  • Load data into service instances
  • Monitor and Manage cloud service instances

Oracle Autonomous Data Warehouse Cloud Overview

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

Working with an Oracle Autonomous Data Warehouse Cloud Instance

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

Connecting to Autonomous Data Warehouse Cloud

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

Sample Data Sets in Autonomous Data Warehouse Cloud

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

Data Loading with Autonomous Data Warehouse Cloud

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

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

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

Monitoring and Managing Autonomous Data Warehouse Cloud

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

Oracle Autonomous Transaction Processing Overview

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

Working with an Autonomous Transaction Processing Instance

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

Loading and Querying External Data with Autonomous Transaction Processing

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

Creating Dashboards, Reports, and Notebooks with Autonomous Transaction Processing

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

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
  • Creating User Accounts in Oracle Machine Learning
  • Managing the Administrator Account in Autonomous Transaction Processing

Monitoring Performance of Autonomous Transaction Processing

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

Backing Up and Restoring Autonomous Transaction Processing

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

Starting, Stopping, and Scaling Autonomous Transaction Processing

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