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.
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:
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
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.
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.
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.
Key Objectives:
Click here to watch a video demonstration of provisioning a new autonomous data warehouse and connect using SQL Developer.
Now you have completed this lab here are some useful links that provide more information about getting started and provisioning a new Autonomous Data Warehouse:
Getting Started with Autonomous Data Warehouse Typical Workflow for Using Autonomous Data Warehouse Starting and Stopping Autonomous Data Warehouse
Objectives:
Click here to watch a video demonstration of running queries against the sample data sets that are part of your Autonomous Data Warehouse.
Now you have completed this lab here are some useful links that provide more information about working with service levels and the free sample data sets.
Sample Star Schema Benchmark (SSB) Queries and Analytic Views Schema diagram for sales history schema (SH), see Figure 3-3. Connecting with Oracle SQL Developer (earlier than Version 18.2)
For a video demonstration of loading data into your Autonomous Data Warehouse, click here.
Now you have completed this lab here are some useful links that provide more information about loading data into your new Autonomous Data Warehouse.
Overview of DBMS_CLOUD package used to load, query, and save data. Importing existing Oracle Database schemas into Autonomous Data Warehouse Using Oracle Data Pump.
Now you have completed this lab here are some useful links that provide more information about how to query external data using your new Autonomous Data Warehouse.
Overview of the CREATE_EXTERNAL_TABLE procedure DBMS_CLOUD Package File URI Formats.
The target audience for this bonus lab is: Cloud DBAs, SQL Developers
Now you have completed this lab here are some useful links that provide more information how to scale your Autonomous Data Warehouse and monitor the performance of your queries.
how to manage concurrency and priorities
how to manage run–away SQL statements
Learn about managing Optimizer Statistics and using hints in your queries
The target audience for this bonus lab is: Data Scientists, Cloud DBAs, SQL Developers
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:
Using the Personal Templates
Using the Shared Templates
Using the Example Templates
The target audience for this bonus lab is: Data Scientists, Cloud DBAs, SQL Developers, Cloud Architects
The target audience for this bonus lab is: Data Warehouse Developers, Cloud DBAs, Cloud Architects
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.
Now you have completed this lab here are some useful links that provide more information about how to visualize data from your Autonomous Data Warehouse.
Getting Started Guide for Oracle Data Visualization Desktop Sharing data visualizations, canvases, or stories
Click here to watch a video demonstration that shows you how to monitor performance of your Autonomous Data Warehouse and perform basic administrative tasks.
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
Recommended Reading • Data Warehousing Made Easy (eBook)
Additional Resources • Additional Resources: https://cloud.oracle.com/en_US/datawarehouse/additional-resources • Oracle Autonomous Data Warehouse Cloud Documentation • Oracle Machine Learning Documentation • Join the Autonomous Data Warehouse forum.