Oracle Autonomous Database Workshop NEW Training Logo

Oracle Autonomous Database Workshop NEW Training

Live Online & Classroom Enterprise Certification Training

Powered By

Oracle Logo

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.

ATP_Authorized Logo

Powered By

Oracle Logo

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Certified Trainer

  • Authorized Courseware

  • Completion Certificate from ATP

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is Autonomous Database Workshop Certification Training about?

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 activity and not spend time creating and managing your IT systems.

What are the objectives of Autonomous Database Workshop Certification Training ?

  • Provision Autonomous Data Warehouse & Autonomous Transaction Processing instances
  • Use Oracle Machine Learning with Autonomous Data Warehouse & Transaction Processing instances
  • Identify the typical workflow for using Autonomous Database Cloud Services
  • Work with data sets
  • Monitor and manage Autonomous Database Cloud service instances
  • Load data into service instances

Who is Autonomous Database Workshop Certification Training for?

  • Cloud Database Administrators
  • Cloud Data Architects
  • Cloud Technical Consultants
  • Cloud Architect
  • Developer
  • Cloud Administrator
  • Cloud Database Developer
  • Cloud Application Developer

What are the prerequisites for Autonomous Database Workshop Certification Training?

Suggested Prerequisite

  • General understanding of cloud technology
  • General understanding of relational database technology
  • Working knowledge of SQL and PL/SQL with Oracle SQL Developer tool
  • Basics of Oracle Database administration and user management
  • Basic knowledge of Machine Learning

Available Training Modes

Live Online Training

16 Hours

Classroom Training

2 Days

Course Outline Expand All

Expand All

  • 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
  • Compartments in Autonomous Data Warehouses
  • Automated Management
  • Create an Oracle Autonomous Data Warehouse Instance
  • 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
  • Run a Query in SQL Developer
  • Work with the Sample Data Sets in Autonomous Data Warehouse Cloud
  • Database Services Levels
  • 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 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 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • Restoring and Recovering on Autonomous Transaction Processing
  • Manual Backups on Autonomous Transaction Processing
  • Backup and Recovery on 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

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

Course Logo

Autonomous Database Workshop Certification Training - Certification & Exam

  • SpringPeople is the Authorized Training Partner of Oracle.
  • The training fees is exclusive of exam cost.
  • For any queries; feel free to reach us at oracle@springpeople.com

Reviews