Skip to Main Content

Breadcrumb for learning path

Main Parent

Learning Path Details Parent

bubbles_banner

Information

learning_path_info

Getting Started Workshop for Autonomous Data Warehouse

This workshop provides a detailed step-by-step, hands-on experience with Oracle’s Autonomous Data Warehouse. With Oracle Autonomous Data Warehouse we make it quick and easy for you to create a secure, fully managed data warehouse service in the Oracle Cloud which allows you to start loading and analyzing your data immediately.

Enroll the User-Public

Learning_path_filler

Learning_path_icons

beginner Beginner
duration 90 Min
modules 14 Modules

Learning Path Contents

Module Sections Topics and more

  • Before You Begin This Workshop
      duration 0 Min
    Please read the following section as it will help you get ready to run this workshop.
     
    Hide
    Introduction to Autonomous Data Warehouse
    • What is an Autonomous Data Warehouse?

      Oracle Autonomous Data Warehouse is built around the market leading Oracle database and comes with fully automated data warehouse specific features that deliver outstanding query performance.  This environment is delivered as a fully managed cloud service running on optimized high-end Oracle hardware systems.  You don’t need to spend time thinking about how you should store your data, when or how to back it up or how to tune your queries.  

      We take care of everything for you.

    • Click here to watch our short video that explains key features in Oracle's Autonomous Data Warehouse.

       

       

    • Autonomous Data Warehouse allows you to select the exact combination of storage and CPUs to fit your project and your budget. You will experience the process of selecting CPUs and deciding the exact storage size during this workshop.

      We keep all of your data safe and secure.  It’s always backed up and always encrypted in Oracle’s cloud.  Using our client tools you load all kinds of different types of data from worksheets on your computer, webstore log files to data files stored in Oracle’s cloud-based object store and load that data into your Autonomous Data Warehouse cloud.

      Oracle’s Autonomous Data Warehouse is the perfect quick-start service for fast data loading and sophisticated data reporting and analysis.  Oracle manages everything for you so you can focus on your data.

      Read on to begin your Getting Started journey with Oracle Autonomous Data Warehouse.

    How to Get Your Free Cloud Trial Account
    • If you already have an Oracle Cloud account then you can skip this section. If you don't have an Oracle Cloud account then you can quickly and easily sign up for a free trial account that provides:

      • $300 of free credits good for up to 3500 hours of Oracle Cloud usage
      • Credits can be used on all eligible Cloud Platform and Infrastructure services for the next 30 days
      • Your credit card will only be used for verification purposes and will not be charged unless you 'Upgrade to Paid' in My Services

      Click on the image below to go to the trial sign-up page which will allow you to request your free cloud account:

      Once your trial account is created, you will receive a Welcome to Oracle Cloud email that contains your cloud account password along with links to useful collateral. To sign into the Oracle Cloud, copy and paste this URL into a browser window: https://cloud.oracle.com/tryit

    Logging in to Oracle Cloud, Selecting a Data Center for your Workshop
    • When you login into the Cloud Console for Autonomous Data Warehouse you will have the option of choosing the REGION for your new data warehouse instance.

      To ensure you get the very best experience possible during this workshop we recommend that when creating instances of Autonomous Data Warehouse in North America Data Region, please choose our data center in Phoenix. When creating instances of Autonomous Data Warehouse in EMEA and APAC, please choose our data center in Frankfurt.

      For example the image below shows how you would select the us-phoenix-1 REGION.

      If you do not see the US-Phoenix-1 region (or any other region), choose the menu item "Manage Regions". Subscribe to the region you want (e.g. US-Phoenix-1). It will become available for selection after you refresh your browser.

    Lab Pre-requisites – Required Software
    • This workshop needs two desktop tools to be installed on your computer to do the exercises in this lab.

      1. SQL Developer 
      To download and install SQL Developer please follow this link, http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html and select the operating system for your computer. This page also has instructions on how to install SQL Developer on Windows, Mac OSX and Linux.

      If you already have SQL Developer installed on your computer then please check the version. The minimum version that is required to connect to an Oracle Autonomous Data Warehouse Cloud is SQL Developer 17.4.

      2. Data Visualization Desktop 
      To download and install Data Visualization Desktop please follow this link, https://www.oracle.com/technetwork/middleware/oracle-data-visualization/downloads/oracle-data-visualization-desktop-2938957.html and select the operating system for your computer. This page also has instructions on how to install DVD on Windows and Mac OSX.

      If you already have Data Visualization Desktop installed on your computer then please check the version. The minimum version that is required to connect to an Oracle Autonomous Data Warehouse Cloud is 12c 12.2.5.0.0.


       

    Getting Help During This Workshop
    • Cloud Customer Connect Forum for Autonomous Data Warehouse


      If you have a question during this workshop then use the Autonomous Data Warehouse Forum to post questions, connect with experts, and share your thoughts and ideas about Oracle Autonomous Data Warehouse.

      Are you are completely new to the Cloud Customer Connect forums? Visit our forum  Getting Started page to learn how to best leverage community resources.

  • Lab 1 - Getting Started and Provisioning a New Autonomous Data Warehouse
      duration 15 Min
    This lab walks you through the steps of logging into Oracle Cloud, accessing the Oracle Autonomous Data Warehouse console and provisioning your first Autonomous Data Warehouse. The last part of this lab will explore how to connect to your new data warehouse using Oracle SQL Developer.
     
    Hide
    • Key Objectives:

      • Sign-in to the Oracle Cloud
      • Provision a new autonomous data warehouse
      • Download the client credentials wallet file
      • Connect from Oracle SQL Developer to your new autonomous data warehouse
    • Click here to watch a video demonstration of provisioning a new autonomous data warehouse and connect using SQL Developer.

    Useful Links
  • Lab 2 - Working with Data Warehouse Services and the Free Sample Data Sets
      duration 15 Min
    In this lab you will explore the free sample data sets that are included witin your new autonomous data warehouse. As part of this lab you will experiment with the selecting different levels of database services that come with your Autonomous Data Warehouse.
     
    Hide
    • Objectives:

      • Learn about the different service levels that are part of autonomous data warehouse (HIGH, MEDIUM, LOW)
      • Learn about the free Star Schema Benchmark (SSB) and Sales History (SH) sample data sets
      • See how the different levels of database service affect performance and concurrency
    • Click here to watch a video demonstration of running queries against the sample data sets that are part of your Autonomous Data Warehouse.

    Useful Links
  • Lab 3 - Loading Data into Your New Autonomous Data Warehouse
      duration 10 Min
    In this lab, you will be uploading files to Oracle Object Storage, creating new sample tables, loading data into those sample tables from files on the OCI Object Storage, and troubleshooting errors relating to your data load jobs.
     
    Hide
    • Key Objectives:

      • Learn how to upload files to Oracle Object Storage
      • Learn how to load data from an object store
      • Learn how to use the SQL Developer Data Import Wizard to load your data
      • Learn how to troubleshoot your data loads
    Useful Links
  • Lab 4 - Querying External Data
      duration 0 Min
    In this lab, you will be querying files directly on Oracle Object Storage without loading them to your autonomous data warehouse.
     
    Hide
    • Key Objectives:

      • Learn how to define external tables against Object Store data sets
      • Learn how to query external tables
      • Learn how to create data warehouse user 
    Useful Links
  • Lab 5 - Creating Rich Data Visualizations
      duration 15 Min
    This lab will walk you through the process of connecting your Autonomous Data Warehouse to Data Visualization Desktop and then use DVD and build sophisticated data visualizations to help your business teams get deeper insights about their data.
     
    Hide
    • Key Objectives:

      • Set Up Local Environment
      • Create New Data Visualization Desktop Connection
      • Prepare Data Set and Create Visualization

      Note that you will need to have installed the Oracle Data Visualization Desktop application to do this lab. There are instructions at the start of this lab that contain links to the software download page for  Data Visualization Desktop.

    Useful Links
  • Additional Bonus Labs for Data Warehouse Developers, Cloud DBAs and Data Scientists
      duration 0 Min
    These additional labs are aimed at Cloud architects, Data Warehouse Developers, Cloud DBAs and Data Scientists and cover the following topics.
     
    Hide
    More Information
    • The bonus labs cover the following topics that will help you expand your knowledge by introducing some more advanced topics for Autonomous Data Warehouse" 

      1) Managing and monitoring Autonomous Data Warehouse using the Cloud Console
      2) Using Oracle Machine Learning SQL Notebooks
      3) Introduction to machine learning with DBMS_PREDICTIVE_ANALYTICS
      4) Using data integration tools with Autonomous Data Warehouse

       

    Getting Help During These Bonus Labs
    • Cloud Customer Connect Forum for Autonomous Data Warehouse

      Don't forget....if you have a question during this bonus labs then use the Autonomous Data Warehouse Forum on CloudCustomerConnect to post questions, connect with experts, and share your thoughts and ideas about Oracle Autonomous Data Warehouse.

      Of course, if you are completely new to the Cloud Customer Connect forums then refer to the Getting Started page to learn how to best leverage community resources.

  • BONUS Lab 6 - Managing and Monitoring Autonomous Data Warehouse using the Cloud Service Console
      duration 10 Min
    For this lab you will watch a video demo that shows the capabilities available via the Cloud Console and Autonomous Data Warehouse Service Console.
     
    Hide
    Target Audience
    • The target audience for this bonus lab is: Cloud DBAs, SQL Developers 

       

    Objectives
    • Key Objectives:

      • Learn how to start/stop your Autonomous Data Warehouse instance
      • Learn how to recover your Autonomous Data Warehouse database - if needed
      • Learn how to use the service console to monitor the performance of your Autonomous Data Warehouse
    • Click here to watch a video demonstration that shows you how to monitor performance of your Autonomous Data Warehouse and perform basic administrative tasks.

    Useful Links
    • Now you have completed this lab here are some useful links that provide more information about the Autonomous Data Warehouse Service Console. 

      - Using the Overview and Activity tabs to get real-time and historical information about the utilization of the service

      - More information about the graphs on the  Console Overview page. 

      - More information about the graphs on the Console Activity page

  • BONUS Lab 7 - Scaling and Query Performance in Autonomous Data Warehouse
      duration 5 Min
    In this lab you will scale up your Oracle Autonomous Data Warehouse instance by adding more CPUs with on interruption to your service. You will watch a recorded demo that shows the performance and concurrency impacts of scaling your service online.
     
    Hide
    Target Audience
    • The target audience for this bonus lab is: Cloud DBAs, SQL Developers 

       

    • Key Objectives:

      • Learn how to scale up and scale down the number of CPUs and amount of storage used by your Autonomous Data Warehouse
      • Understand how scaling affects both concurrency and performance with your Autonomous Data Warehouse
    Useful Links
  • BONUS Lab 8 - Oracle Machine Learning SQL Notebooks
      duration 10 Min
    During this lab you will be using the new Oracle Machine Learning SQL notebook application that is part of your Autonomous Data Warehouse. This browser-based application provides a web interface to run SQL queries and scripts, which can be grouped together within a notebook. Notebooks can be used to build single reports, collections of reports, and dashboards. Oracle Machine Learning provides a simple way to share workbooks with other OML users.
     
    Hide
    Target Audience
    • The target audience for this bonus lab is: Data Scientists, Cloud DBAs, SQL Developers

       

    • Key Objectives:

      • Learn how to create new Oracle Machine Learning notebook user accounts
      • Learn how to run a SQL statement within a SQL Notebook
      • Learn how to share notebooks
      • Learn how to create and run SQL scripts
         
    Useful Links
    • Now you have completed this lab here are some useful links that provide more information about Oracle Machine Learning SQL Notebook
       

      Detailed documentation on how to get started with Oracle Machine Learning for creating SQL and data mining notebooks where you can perform data analytics, data discovery and data visualizations is available here.

      You can store your notebooks as templates, share notebooks, and provide sample templates to other users:

  • BONUS Lab 9 - Simple Introduction to Machine Learning Algorithms (DBMS_PREDICTIVE_ANALYTICS)
      duration 10 Min
    During this lab you will be using the Oracle Machine Learning SQL notebook application to explore how you can use the in-database DBMS_PREDICTIVE_ANALYTICS functionality. DBMS_PREDICTIVE_ANALYTICS provides a set of easy-to-use procedures that simplify the machine learning process.
     
    Hide
    Target Audience
    • The target audience for this bonus lab is: Data Scientists, Cloud DBAs, SQL Developers, Cloud Architects

    Objectives
    • Key Objectives:

      • Learn how to import notebooks into Oracle Machine Learning
      • Learn how to use the in-database DBMS_PREDICTIVE_ANALYTICS analytics
      • Learn how to use Oracle Machine Learning Examples gallery to explore use cases for other machine learning algorithms
         
  • BONUS Lab 10 - Using Data Integration Tools with Autonomous Data Warehouse
      duration 60 Min
    In this lab, you will configure and use Oracle Data Integration Platform Cloud (DIPC) with Autonomous Data Warehouse. This lab follow a typical enterprise data warehouse reference implementation with ETL/ELT batch processing, real time data replication, and data quality review. You will load data from a flat file and a database table using Oracle Data Integrator (ODI) to your Autonomous Data Warehouse. You will replicate data from a database table to Autonomous Data Warehouse using Oracle Golden Gate (OGG). You will review data quality in your Autonomous Data Warehouse using Oracle Enterprise Data Quality (EDQ).
     
    Hide
    Target Audience
    • The target audience for this bonus lab is: Data Warehouse Developers, Cloud DBAs, Cloud Architects

    • Key Objectives:

      • Learn how to load data using Oracle Data Integrator (ODI)
      • Learn how to replicate data to your Autonomous Data Warehouse with Oracle GoldenGate (OGG)
      • Learn how to review data quality by using Oracle Enterprise Data Quality (EDQ)
  • All Done
      duration 0 Min
    Congratulations you have completed the Getting Started Workshop for Autonomous Data Warehouse!
     
    Hide
  • Learn More About Autonomous Data Warehouse
      duration 0 Min
    This section provides links to additional recommended reading materials and other useful resources.
     
    Hide