Autonomous Database Learning Lounge

October 23, 2023 | 15 minute read
Marcos Arancibia
Senior Principal Product Manager, Autonomous Database
Text Size 100%:

Learn all about Oracle Autonomous Database by joining our bi-weekly Live Webinars at Autonomous Database Learning Lounge https://bit.ly/adb-learning-lounge. We will keep this post updated with each new session below as the recording and slides become available - so make sure to bookmark and watch this page!

For all things Autonomous Database, make sure to go to Get Started with Autonomous Database: https://www.oracle.com/autonomous-database/get-started/

The ADB Learning Lounge sessions are hosted by Marcos Arancibia Product Manager in the Oracle Autonomous Database team.

The listing below shows the Autonomous Database Learning Lounge sessions, their recordings, links to the Slides and other important links on each subject.

 

Important: Starting in 2024, all recordings and links will be available only at the AskTOM site

 

December 2023: Securing Your Autonomous Database: Unleashing the Power of Oracle Data Safe

Oracle Data Safe can be used quickly and conveniently to ensure the security posture of your Autonomous Database. Data Safe is included for Autonomous Databases and provides a security control center to assess configuration risk, identify highly privileged database users, manage and store audit records, report on database activity, discover sensitive data, and remove sensitive data from non-production copies of the database.

See an overview and Live Demo of many Data Safe features, learn how it helps Oracle customers protect their data, and find out how you can begin using Data Safe today.

Speaker: Assets from the session:
- Link to the slides in PDF format
- Main site for Oracle Data Safe
- Documentation: Get Started with Data Safe
- Documentation: What's New in Data Safe
- Documentation: Data Safe Administration Guide
- Documentation: Data Safe User Guide
- Documentation: Data Safe API
- LiveLab: Oracle Data Safe Fundamentals
- Customer video story: SOHO Media Solutions Addresses GDPR Compliance with Oracle Data Safe
- Customer story: OPI PIB enjoys cost-effective data security with Oracle

divider

December 2023: APEX on ADB - best practices for the world's most popular enterprise low-code application platform

Oracle APEX (APEX) is a low-code development platform that enables you to build scalable, secure enterprise applications with world-class features that can be deployed anywhere. Each Autonomous Database instance includes a dedicated instance of Oracle APEX. Oracle APEX provides you with an easy-to-use browser-based environment to load data, manage database objects, develop REST interfaces, and build applications which look and run great on both desktop and mobile devices.

You can use Oracle APEX to develop a wide variety of solutions: import spreadsheets and develop a single source of truth in minutes, create compelling data visualizations against your existing data, deploy productivity applications to elegantly solve a business need, or build your next mission-critical data management application.

Oracle APEX on Autonomous Database provides a preconfigured, fully managed and secured environment to both build and deploy world-class data-centric applications. There are no limits on the number of developers or end users for your Oracle APEX applications; Autonomous Database can instantly scale compute and storage online as needed, based upon your workload. Additionally, Oracle APEX applications developed on-premise can be easily deployed to Oracle APEX on Autonomous Database, or vice-versa.

The session included the following topics:
  • APEX overview, benefits, architecture, and customer successes
  • ADW / ATP with APEX compared to specialized APEX Service
  • What's new for ADB + APEX lately, and what's coming next
  • All about the twice-per-year APEX upgrade process on ADB
  • ADB + APEX configuration options such as Vanity URLs and Customer Managed ORDS
  • Tips, best practices, and known restrictions for ADB + APEX

Speakers: Assets from the session:
- Link to the slides in PDF format
- Main site for APEX and the APEX Service
- APEX on Autonomous Database updates
- Pique Solutions Time and Motion Study benchmark: ReactJS vs. Low-Code APEX
- Blog: Enhanced Oracle APEX Upgrade Process in Oracle Cloud
- Blog: Introducing Vanity URLs for APEX and ORDS on Oracle Autonomous Database
- Documentation: APEX on ADB - Use Web Services with Oracle APEX
- Office Hours: Oracle APEX Office Hours monthly

divider

December 2023: Accelerating App Dev with ACID Transactions, Native JSON Support and MongoDB API in ADB

If you follow industry trends and marketing, you might know about the "next big thing" called Document Databases, which hold schemaless collections of JavaScript Object Notation (JSON) documents that are popular with developers. Without standards for document store interfaces, the MongoDB API is one of the more popular interfaces supported by multiple systems. Oracle Autonomous Database offers a MongoDB-compatible NoSQL document store API, besides its unmatched relational capabilities.

Learn how to use MongoDB programs and applications to connect to the Oracle Autonomous Database as a pure document store, using the Oracle Database API for MongoDB. Get the best of the SQL and NoSQL worlds - build low-latency, high-throughput applications without losing the ability to analyze your JSON data with SQL. With Oracle Autonomous Database, fragmented, separated document stores are no longer needed.

Speakers: Assets from the session:
- Link to the slides in PDF format
- Main site Autonomous JSON Database
- LiveLabs: Developing with JSON and SODA
- LiveLabs: Using the Database API for MongoDB
- Live SQL: SQL/JSON Features
- Documentation: Overview of the Oracle Database API for MongoDB
- Documentation: Configure the Oracle Database API for MongoDB
- Paper from VLDB 2020: Native JSON Datatype Support: Maturing SQL and NoSQL convergence in Oracle Database
- Wikibon Benchmark: Oracle Binary JSON Format - 2X Faster than MongoDB and AWS DocumentDB
- Technical Case Study: DPA overcomes project complexity, improves performance with Autonomous Database
- Blog: Case Study on InfStones and Autonomous JSON Database managing their multi-terabyte system
- Blog: Oracle Database API for MongoDB

divider

November 2023: Securing your critical data: Oracle Autonomous Database & Database Vault

Oracle Database Vault enhances the security of your critical data, and it can separate privileged users from sensitive data, protect database credentials from being misused or abused, and limit DDL operations to a change control window. It is available with Autonomous Database and simple to enable


Speaker: Assets from the session:
- Link to the slides in PDF format
- LiveLab: Securing a legacy application using Oracle Database Vault on Oracle Autonomous Database
- Office Hours: AskTom - Database Security Office Hours
- Office Hours recording: Database Vault Use Cases - Part 1
- Office Hours recording: Database Vault Advanced Use Cases - Part 2
- Office Hours recording: Database Vault Basics Part 1- Enforcing a Trusted Path to Data
- LiveLab: Oracle Database Vault
- LiveLab: Prevent unauthorized data access in Autonomous DB with DV

divider

November 2023: Oracle Estate Explorer and Elastic Resource Pools for database consolidation in ADB

The introduction of Elastic Resource Pools has made Autonomous Database Serverless the ideal target for database consolidation, but identifying the best candidates to migrate to Autonomous Database might not always be straightforward when you have hundreds or even thousands of Oracle databases. Oracle Estate Explorer is a lightweight tool that can analyze thousands of databases in just a few hours and enables you to identify those databases that will offer the greatest return on investment in the shortest time if you move them to Autonomous Database.

Speakers: Assets from the session:
- Link to the slides in PDF format
- Migrate Oracle Databases to OCI: migration programs
- Oracle Estate Explorer overview slides
- Oracle Estate Explorer installation guide
- Blog: How to Achieve up to 87% Compute Cost Savings with Elastic Resource Pools on Autonomous Database
- Documentation: Using Elastic Resource Pools on Oracle Autonomous Database Serverless

divider

October 2023: New features for Autonomous Database announced at Oracle CloudWorld'23

In this session ADB Product Managers introduced the new features of Autonomous Database announced at Oracle CloudWorld'23 (held in Las Vegas, on September 18-21, 2023), and showed a Live Demo of the new SQL Generation capability using GenAI

It included the following topics:
  • New SELECT AI feature - SQL generation capability using GenAI - Live Demo
  • New Oracle Autonomous Database Free Container Image
  • New Elastic Resource Pools for Autonomous Database
  • Resources available to learn more about Autonomous Database at Oracle CloudWorld'23

Speakers: Assets from the session:
- Link to the slides in PDF format
- LiveLab: Chat with Your Data in Autonomous Database Using Generative AI
- Blog: Autonomous Database speaks "human"
- Presentations: All Autonomous Database presentations at Oracle CloudWorld'23
- LiveLab: All hands-on workshops offered at Oracle CloudWorld'23
- Blog: How to Achieve up to 87% Compute Cost Savings with Elastic Resource Pools on Autonomous Database
- Documentation: Use and Manage Elastic Resource Pools on Autonomous Database
- Oracle Container Registry: Autonomous Database Free Container Image

divider

September 2023: New Data Sharing with Autonomous Database

Data Sharing is a new feature of Autonomous Database that allows for secure and efficient sharing of data across different departments, applications, and even organizations. With the use of the Delta Sharing protocol, users can easily grant access to subsets of their data while maintaining full control over who has access and what they can do with it. This capability not only enhances collaboration and decision-making but also enables organizations to generate new revenue streams by monetizing their data assets.

In particular, this session covered a Business understanding of Data Sharing, the technical aspects of the delta sharing protocol, and an End-to-End demo of Data Sharing in use with Autonomous Database.
Speaker:
Alexey Filanovskiy, Senior Principal Product Manager
Assets from the session:
- Link to the slides in PDF format
- Hands-on workshop: Implement Data Sharing with Data Studio UI
- Hands-on workshop: Implement Data Sharing with PL/SQL code
- Quick Start Guide for Oracle Data Sharing
- Blog: Unlimited data-driven collaboration with Data Sharing in Autonomous Database

divider

September 2023: Hidden Gems in Database Tools for Autonomous Database

This session explains the abilities of Database Tools, and how they are available from Day 1 in Autonomous Database

It includes the following topics:
  • REST APIs
    • REST APIs for your Data & Business Logic
    • Real World usage of REST APIs by customers
    • AutoREST
    • REST Enabled SQL
    • SODA for REST and MongoAPI for Oracle
  • Did you know?
    • Built-in Swagger Tooling
    • Data Pump from your Browser
    • Batch Load CSV to your Tables via REST
    • Search & Browse your database
    • Scheduler Interface

Speaker:
Jeff Smith, Distinguished Product Manager

Assets from the session:
- Link to the slides in PDF format
- LiveLab: Build and Secure REST APIS
- LiveLab: Build a Python App with REST
- YouTube video: Oracle REST Data Services in '5' Minutes
- That Jeff Smith Blogs
- Oracle REST APIs on Twitter

divider

August 2023: Multicloud integration points with Autonomous Database

This session explains the different Multicloud integration points available for the Autonomous Database with MS Azure, AWS and GCP.

In particular, the topics in this session covered:
  • Autonomous Database on Oracle Database Service for Azure (ODSA)
  • Accessing Cloud Resources
    • Principal Authentication for OCI, Azure, AWS, and GCP
    • Loading Data from Object Stores
    • Creating and Querying External Tables
    • Customer-managed Key and Secret Management
  • Security
    • Encryption at Rest
    • Secret Management for Credential Objects
  • Accessing Other Databases
    • Oracle-Managed Heterogeneous Connectivity

Speakers:
Can Tuzla, Principal Product Manager
Assets from the session:
- Link to the slides in PDF format
- Oracle Database Service for Azure (ODSA) documentation: https://bit.ly/ODSAdoc
- Autonomous Database Home Page: https://bit.ly/adb-home
- Autonomous Database Blog: https://bit.ly/adb-blog-home
- Autonomous Database Documentation: https://bit.ly/adb-doc

divider

August 2023: Maps in Apps: Database-driven development with Oracle Spatial in Autonomous Database

Location is an essential component of modern business applications in both operational and analytics scenarios, and is a key to understanding the relationships between business entities such as trade areas, demographics, and traffic patterns. Whether represented as maps, reports, or notifications, the results of location-based analysis, such as "which properties are within a flood hazard zone", are often the only means of relating diverse sources of data.

The Spatial features of Oracle Autonomous Database provide robust geospatial data management and analysis. These features are accessed programmatically with SQL, or using the no-code Oracle Spatial Studio web tool. As a feature of Oracle's converged database, these geospatial capabilities co-exist with a wide range of features supporting database-driven application development.

This session explains how to include maps and location-based analysis in your applications with Oracle Spatial combined with Oracle Application Express (APEX) for low-code application development and Oracle REST Data Services (ORDS) for creating spatial services.

Speaker:
David Lapp, Senior Principal Product Manager

Assets from the session:
- Link to the slides in PDF format
- Oracle Spatial Geocoding SQL API for Autonomous Database
- Geocoding SDO_GCDR package documentation
- LiveLabs code sprint (search for "geocode"): https://developer.oracle.com/livelabs
- Sample APEX Maps Application: https://apex.oracle.com/go/apps/sample-maps
- Spatial Blogs: https://blogs.oracle.com/database/category/db-spatial
- Spatial 19c Documentation: https://docs.oracle.com/en/database/oracle/oracle-database/19/spatl
- YouTube channel: https://www.youtube.com/@oraclespatialandoraclegraph
- Spatial Blogs: https://blogs.oracle.com/database/category/db-spatial
- Spatial LiveLabs Hands-on Labs (search for "spatial"): https://developer.oracle.com/livelabs
- Spatial portal: https://www.oracle.com/database/spatial/

divider

July 2023: Graphs Made Easy: Find New Insights in Your Data with Graph in Autonomous Database

Modeling your data as a graph can help you find connections in data. With graphs you can uncover money laundering in financial transactions, traverse linked components in manufacturing data, search for connected parts in a supply chain inventory, find impacted nodes in a telecommunication network failure, and more.

Graph Studio in Oracle Autonomous Database makes it easy for developers to get started with graph queries and graph analytics. You can create, query, analyze, and visualize graphs using automated graph modeling tools, a SQL-like graph query language, and pre-built graph algorithms, all using data in tables in your autonomous database.

Speakers:
Melliyal Annamalai, Distinguished Product Manager
Assets from the session:
- Link to the slides in PDF format
- Main Oracle site for Oracle Graph: https://oracle.com/database/graph
- Oracle Free Hands-on Labs: https://bit.ly/GraphLiveLabs
- Youtube channel for Graph: https://bit.ly/Spatial-Graph-YouTube
- Oracle Blog site for Graph: https://bit.ly/OracleGraphBlog
- Medium blog site for Graph: https://medium.com/tag/oracle-graph/latest

divider

June 2023: Embedding AI/ML in applications using OML in Autonomous Database

Oracle Machine Learning greatly simplifies the way to embed AI\/ML in your applications, and is included with every Autonomous Database.

Learn about the concepts surrounding in-database machine learning from SQL, Python, R and REST APIs, along with OML components exclusive to Autonomous Database. Understand the benefits of using machine learning in ADB, common use cases, and the upcoming features.

See live demos of the different UI options available for using OML with Autonomous Database with OML Notebooks and the no-code OML AutoML UI, as well as how to use Conda environments for third-party Python and R packages with Autonomous Database. Learn also about how to use ML models deployed to OML Services using the REST API for real-time scoring, and UDFs in Python and R through REST and SQL APIs.

Finally check the new Model Monitoring capabilities for detecting the need to replace an ML model in production.

Speakers:
Mark Hornick, Senior Director of Product Management;
Sherry LaMonica, Consulting Member of Technical Staff;
Marcos Arancibia

Assets from the session:
- Link to the slides in PDF format
- Main Oracle site for Oracle Machine Learning: https://oracle.com/machine-learning
- Oracle Free Hands-on Labs: https://bit.ly/omllivelabs
- Oracle Machine Learning Office Hours: https://bit.ly/omlofficehours
- Blog site for Oracle Machine Learning: https://bit.ly/omlblogs
- Github site for OML sample code: https://bit.ly/omlgithub

divider

June 2023: Delivering successful Data Lakes with Autonomous Data Warehouse

Data Lakes are the new reality for many companies who want to maximize business output from their data capital. Unfortunately, it is estimated that 85% of data lake projects fail.

What can you do to be part of a success story? This session will describe the challenges and how to overcome them. We’ll highlight the best practices for building data lakes that simplify data integration, offer open access and deliver sophisticated analytics.

You will see how to get value from all your data - even when that data is distributed across multiple clouds.

Speaker:
Alexey Filanovskiy, Senior Principal Product Manager
Assets from the session:
- Link to the slides in PDF format
- Data Lake - OCI Reference Architecture : https://docs.oracle.com/en/solutions/data-platform-lakehouse/index.html
- Oracle Free Hands-on Labs: https://bit.ly/build-data-lake-with-adw-workshop
- Youtube channel for Data Lakes: https://bit.ly/adb-datalake-playlist
- Oracle Blog site for Data Warehousing: https://blogs.oracle.com/datawarehousing/
- Medium blog site for building Data Lakes with ADB

divider

May 2023: Integrate, Load and Analyze all your data with Autonomous Database Data Studio

The new Autonomous Database Data Studio is new built-in application that unites the Data Tools of the Autonomous Database into a single, integrated user interface. It incorporates all the following tools and capabilities:
  • Loading data, with the Data Load tool
  • Finding and understanding data, with the Catalog
  • Transforming data, with Data Transforms
  • Analyzing data and preparing Analytic Views, with Data Analysis
  • Providing immediate insights from your data, with Data Insights
In addition, spreadsheet add-ins are available for both Microsoft Excel and Google Sheets, to facilitate easy self-service data analysis, and collaboration with other teams.

Speakers:
Patrick Wheeler, Vice President of Product Management;
Jayant Mahto, Senior Principal Product Manager;
Bud Endress, Senior Principal Product Manager;
Ashish Jain, Senior Principal Product Manager

Assets from the session:
- Link to the slides in PDF format

divider

May 2023: Autonomous Database changes the way you build smart applications. Learn how easy it is!

Analytics are critical to successful applications; they need to be embedded in every part of your solution.

How do you simplify your path to success? We’ll step thru a use case to show you how.

Learn how to unleash your creativity using this immersive, easy-to-use, self-service platform! We also show you how to access information and collateral about Autonomous Database.

Speakers:
Martin Gubar, Director of Product Management
Keith Laker, Senior Principal Product Manager



Assets from the session:
- Link to the slides in PDF format

Marcos Arancibia

Senior Principal Product Manager, Autonomous Database

Marcos Arancibia is a Senior Principal Product Manager for Oracle Autonomous Database, with focus on outbound activities. He is charted with developing a comprehensive platform for enabling all customers and use cases to migrate to Autonomous Database, and attract new developers and customers to bring their Applications and workloads to the Oracle Autonomous Database. Before joining Oracle in 2010 he spent 13 years at SAS Institute Inc., from Country Manager in LAD to Regional Data Mining lead in the US. He holds a bachelor's degree with additional courses in the master's degree, both in Statistics from UNICAMP in Brazil. He has Certifications from Stanford on AI and Machine Learning, and from the University of Washington on Computational Neuroscience.


Previous Post

October edition of newsletter for Autonomous Database Serverless

Keith Laker | 5 min read

Next Post


How to quickly enable a set of smart alarms to monitor your Autonomous Databases

Keith Laker | 4 min read
Everything you need to know about data warehousing with the world's leading cloud solution provider