LiveLabs Workshops
Experience Oracle’s best technology, live!
Come to this open house style session where you’ll gain access to a selection of LiveLabs Workshops to solve your complex developer requirements using the Oracle Database. Topics include Autonomous Database, APEX, Machine Learning, Database 19c, and Database 21c. Each workshop environment takes between five and 15 minutes to set-up. Once set up, you’ll be able to complete this workshop outside of the session time, once the conference is over. There are five different LiveLabs session times. Pick whichever timeslot is most convenient for you!
LiveLabs Workshops List
45 minutes // Security/Manageability
Tales from the Dark Side: Hacking the Database
About this workshop:
Sit down for casual conversation with Q&A as customers share their insights & experience on hot topics like Oracle Database 23c, Engineered Service, Enterprise Manager 13.5, and Machine Learning.
This workshop is a hands-on lab dedicated to the features and functionality of Oracle database security against the most common cyberattacks.
Through the example of a Ransomware attack, you will explore how attackers operate and what features you should use to prevent, detect and mitigate their attacks.
For more details on each of the featured capabilities in this lab, please refer to the LiveLabs *DB Security Basics* and *DB Security Advanced*
Based on an OCI architecture deployed in just a few minutes with a simple internet connection, this workshop allows you to test common database security use cases in an entirely pre-configured environment by the Oracle Database Security Product Management team.
Outline
- Mitigate an SQL Injection
- Assess database vulnerabilities
- Detect, prevent and mitigate data exfiltration
- Detect and prevent abuses of privileges
Prerequisites
- LiveLabs DB Security – Basics is recommended
- Familiarity with database is preferred, but not required
- Some understanding of cloud and database terms is helpful
- Familiarity with Oracle Cloud Infrastructure (OCI) is helpful
2 hours // DB Innovations
Install and Upgrade Autonomous Health Framework to the Latest Version
About this workshop:
The labs in this workshop walk you through the steps to install, deinstall, upgrade and patch the Oracle Autonomous Health Framework (AHF).
Outline
- Install and deinstall the Autonomous Health Framework (AHF)
- Upgrade AHF from a Software Stage Location
- Upgrade AHF from REST endpoints (Object Store)
- Upgrade AHF from MOS
- Apply AHF framework and metadata updates
- Query AHF framework and metadata updates
- Rollback AHF framework and metadata updates
- Cleanup AHF metadata backup directories
Prerequisites
- Basic knowledge of Linux and Administration fundamentals.
- Familiarity with Oracle Database basic concepts
2 hours // DB Innovations
Data Studio – Self-service tools for everyone using Oracle Autonomous Database
About this workshop:
This is an overview Data Studio workshop to introduce you to different tools using a sample data analysis task. After this workshop you will have a working knowledge on how to use these tools.
The tools covered are:
– Catalog
– Data Load
– Data Transforms
– Data Analysis
– Data Insight
After completing this workshop, you can look at the individual in-depth workshops for each tool.
Outline
- Lab 1: Provision an Autonomous Database
- Lab 2: Create a User
- Lab 3: Load demo data
- Lab 4: Understand data analysis requirements
- Lab 5: Browse database objects
- Lab 6: Load additional data
- Lab 7: Transform and prepare data
- Lab 8: Analyze data
- Lab 9: Explore data insights
- Lab 10: Wrap up
Prerequisites
- Familiarity with Database is desirable, but not required
- Some understanding of cloud and database terms is helpful
- Familiarity with Oracle Cloud Infrastructure (OCI) is helpful
2 – 8 hours // DB Innovations
Hitchhiker’s Guide for Upgrading to Oracle Database 19c
About this workshop:
Upgrade your Database to 19c NOW! Using Mike Dietrich’s popular workshop.
Outline
- Setup your Upgrade Compute Instance in the Cloud
- Load the database
- Capture and Preserve SQL
- Perform Auto Upgrade tasks
- Run an AWR Diff Report
- Analyze SQL
- Tune and manage SQL Plans
- Perform upgrades using the plugin method
Prerequisites
- Familiarity with Database is required
- Some understanding of cloud and database terms is helpful
2 hours // DB Innovations
Integrate, Analyze and Act on All Data using Autonomous Database
About this workshop:
This workshop uses Oracle Cloud’s modern data platform for analytics to enable MovieStream to better understand their customers, predict churn and provide targeted recommendations and promotions. We’ll start with two key components of MovieSteam’s architecture. MovieStream is storing its data across Oracle Object Storage and Autonomous Database. Data is captured from various sources into a landing zone in object storage. This data is then processed (cleansed, transformed, and optimized) and stored in a gold zone on object storage. Once the data is curated, it is loaded into an Autonomous Database where it is analyzed by many (and varied) members of the user community – from data analysts to data scientists. These users will take advantage of a variety of Autonomous Database capabilities: advanced Oracle SQL to glean customer insights, Oracle Machine Learning to predict churn, and Oracle Spatial and Graph to provide targeted promotions.
Outline
- Introduction to MovieStream
- Get started
- Lab 1: Provision an ADB instance
- Lab 2: Use Data Tools to create a user and load data
- Lab 3: Use SQL to analyze movie sales data
- Lab 4: Working with JSON data
- Lab 5: Use OML to predict customer churn
- Lab 6: Find the closest pizza shops with Oracle Spatial
- Lab 7: Use Graph analytics for product recommendation
Prerequisites
- Familiarity with Database is desirable
- Understanding of cloud and database terms is helpful
- Familiarity with Oracle Cloud Infrastructure (OCI) is helpful
4 hours // Development
Goldengate 19c Microservices
About this workshop:
Oracle GoldenGate offers a high-performance, fault-tolerant, easy-to-use, and flexible real-time data streaming platform for big data environments. It easily extends customers’ real-time data integration architectures to big data systems without impacting the performance of the source systems and enables timely business insight for better decision making.
This workshop focuses on GoldenGate Real-Time Data Capture demonstrating four scenarios that you can use (both on-premise and in the cloud) to capture real-time data changes from your sources.
Outline
- Prerequisites
- Introduction
- Generate SSH Key
- Prepare Setup (Freetier and Paid Accounts only)
- Environment Setup
- Initialize Environment
- Create One-Way Replication
- HA-DR Replication
- Transformations
Prerequisites
- An Oracle Free Tier, Always Free, or Paid Account
- A general understanding of database and data replication concepts using Oracle GoldenGate
45 minutes // Development
Building an App from a Spreadsheet using Oracle APEX
About this workshop:
In this workshop, you create a fully featured, responsive Web app using Oracle APEX on Oracle Cloud. This workshop gets you a well-rounded understanding of low code app development with APEX. You will be amazed at how you went from a spreadsheet to a beautiful, and fully functional Web app to explore NYC High Schools in minutes!
This workshop walks you through uploading the NYC High Schools spreadsheet data into an Oracle database table, and then creating an application based on this new table. You will then play with the Faceted Search, Interactive Report, and improve the attached form. You will learn how to add a map region to the search page in order to visually enhance the page. You will also learn to download and use the application as a Progressive Web App (PWA).
Outline
- Introduction and Overview
- Login to Oracle Cloud
- Create an APEX Workspace
- Create an app from a spreadsheet
- Improve the faceted search
- Improve the report and form
- Link the calendar
Prerequisites
- Familiarity with Database is desirable, but not required
- Some understanding of cloud and database terms is helpful
- Familiarity with Oracle Cloud Infrastructure (OCI) is helpful
2 hours // Development
Machine Learning on Autonomous Database
About this workshop:
Oracle integrates machine learning across the Oracle stack and the enterprise, fully leveraging Oracle Database and Oracle Autonomous Database. In this workshop, create a machine learning model and move the model to ADB. Explore machine learning notebooks and use prediction in applications.
Outline
- Provision ADB
- Create Machine Learning Model
- Migrate the ML model to ADB
- Use Prediction in an application
Prerequisites
- Familiarity with Database is desireable, but not required
- Some understanding of cloud and database terms is helpful
- Familiarity with Oracle Cloud Infrastucture (OCI) is helpful
90 minutes // Development
Build a Starter Online Shopping App using Oracle APEX!
About this workshop:
This workshop walks you through the creation of a Shopping Cart application that allows administrators users to manage the products, customers, and stores.
On the other side, customers can review and add products to the Shopping Cart and eventually proceed to checkout.
Outline
- Installing Sample Tables
- Adding Columns to the Products Table
- Creating Database Objects
- Creating the Application
- Creating the Order Page
- Creating the Shopping Cart Page
- Creating the Add to Cart Page
- Improving Products Page
- Improving the App
Prerequisites
- Familiarity with Oracle Database and Oracle APEX is desirable, but not required
2 hours 30 minutes // Elastic Computing
Get started with Oracle Machine Learning Fundamentals on Oracle Autonomous Database
About this workshop:
Get a quick tour of Oracle Machine Learning technologies on Autonomous Database. Use OML Notebooks to create and evaluate models and score data using SQL, Python and R. Use OML Services REST API to deploy models and score data. Use AutoML UI for a no-code machine learning experience.
Outline
- Introduction
- Get Started
- Use Oracle Machine Learning Notebooks
- Use Oracle Machine Learning for SQL
- Use Oracle Machine Learning for Python
- Use Oracle Machine Learning for R
- Use Oracle Machine Learning AutoML UI
- Use Oracle Machine Learning Services
Prerequisites
- Familiarity with Python, R and SQL languages
- Familiarity with REST APIs preferred but not required
- Familiarity with Database is desirable, but not required
- Familiarity with Machine Learning concepts
2 hours // Elastic Computing
DBA Essentials – Install Oracle Database 21c on OCI Compute
About this workshop:
Explore how to install the Oracle Database software on a Linux system provided with this workshop. Perform installation for desktop class and server class for Container Database. Configure Oracle Database while installing it and set up a single instance container database.
Outline
- Basic concepts of Oracle Database installation
- Oracle Database Setup Wizard (Database installer)
- Oracle Database Configuration Assistant (Oracle DBCA)
- Installation steps for Oracle Database
- Create and configure Oracle Database
Prerequisites
- Familiar with local shell environments (bash, c shell, etc.)
- Comfortable executing commands in a local shell
- Familiarity with Database is desirable, but not required
- Some understanding of database terms is helpful
2 hours 30 minutes // Elastic Computing
Get Started with Oracle Cloud Infrastructure Core Services
About this workshop:
The labs in this workshop cover an introduction to Oracle Cloud Infrastructure (OCI) Core Services, including virtual cloud networks (VCN), compute and storage services. These labs also provide some of the foundational skills and knowledge you’ll need to attempt the [Oracle Cloud Infrastructure Foundations Certification](https://www.oracle.com/cloud/iaas/training/foundations.html) offered by Oracle University.
The Oracle Cloud Infrastructure Foundations Certification provides candidates with foundational knowledge of core cloud computing concepts and an understanding of those services in Oracle Cloud Infrastructure. The certification is intended for candidates with technical and non-technical backgrounds who want to validate their understanding of Oracle Cloud infrastructure.
The labs featured on this page cover various solutions, skill levels, and categories based on Oracle Cloud Infrastructure (OCI).
Outline
- Identity and Access Management
- Setup Virtual Cloud Networks
- Create a Compute Instance
- Block Volume
- Object Storage
Prerequisites
- Familiarity with Oracle Cloud Infrastucture (OCI) is helpful
60 minutes // Elastic Computing
OCI Configuring File System Storage
About this workshop:
Oracle Cloud Infrastructure File Storage Service provides a durable, scalable, distributed, enterprise-grade network file system. You can connect to a File Storage Service file system from any bare metal, virtual machine, or container instance in your Virtual Cloud Network (VCN). You can also access a file system from outside the VCN using Oracle Cloud Infrastructure FastConnect and Internet Protocol security (IPSec) virtual private network (VPN).
Outline
- Generate SSH Keys
- Create VCN
- Create File System Storage
- Create Compute
- Mount storage to Compute
Prerequisites
- Familiarity with Database is desireable, but not required
- Some understanding of cloud and database terms is helpful
- Familiarity with Oracle Cloud Infrastucture (OCI) is helpful
