Summer-Ready Savings: Find the Training Course You Need at a Price You'll Love

closeClose

Oracle Autonomous Database Workshop

Course Details
Code: D105098GC10
Tuition (USD): $1,628.00 • Classroom (2 days)

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.

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 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
  •  
  • Scale up and scale down resources as required
  •  
  • Terminate an Autonomous Database instance

Skills Gained

  • Provision Autonomous Database instance
  • Use Oracle Machine Learning with Autonomous Database
  • Identify the typical workflow for using Autonomous Database
  • Work with data sets
  • Monitor and manage Autonomous Database Cloud service instances
  • Load data into service instances

Who Can Benefit

  • Cloud Administrator
  • Developer

Course Details

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
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward