Quest Forum Digital Event 2020

Use the latest technology on robotics, machine learning & Oracle chatbots to create the future with AI.  We will explore how to leverage and integrate robotics & machine learning into your companies tech plan.  We'll show the state of robotics and how you can test and use this technology to create the future.

Quest Forum Digital Event 2020

In this session, Blaine Carter will demonstrate how to REST enable your database using Oracle Rest Data Services (ORDS). He will demonstrate how to use SQL Developer to create and deploy REST services in ORDS. First, Blaine will "Auto Rest" enable a table and a PL/SQL package. Then, he will secure the API and create an OAuth2 client that can be used to access the service. Next, he will walk through the steps of creating a custom REST API using the REST Data Services wizard. This API will be used to POST image files into a BLOB column in the database and the GET handler will serve the image directly in a web page. You will leave this session with an understanding of how to quickly create REST services on your own database.

Quest Forum Digital Event 2020

Complex performance situations are not always quickly diagnosable using an AWR time-based analysis or an ASH sample-based analysis. And certainly, the diagnosis will not be completed the second new data becomes available or before a support ticket has been received!

A solution is to use a supervised learning classification machine learning model. We can train the model to recognize and "understand" a virtually unlimited number of Oracle performance and business-related data.

Once trained, we will present the model with just-available data asking, for example, if a support ticket will likely be submitted. Or perhaps, if the performance will likely be green, yellow, or red.

Join me as I build a "Poor Performance" indicator using 100% free industry-standard tools, such as Python and the "Always Free" Oracle Autonomous Database with Oracle ML SQL Notebooks. All presentation slides, scripts, and a recording of the demonstration are available!

Quest Forum Digital Event 2020

ChatOps is an automation model connecting users and tools to processes through messaging applications. It leverages the simplicity and familiarity of chat to empower users to interact directly with applications and databases, retrieving information, and performing work in real-time. Done right, ChatOps is a safe, agile way to minimize or eliminate tedious, repetitive operational tasks and reduce workloads. Virtually anything can be automated or called via ChatOps through simple commands—from self-service password resets, to initiating reporting cycles, to running ad hoc refreshes of development environments—all without granting end users access to a database or application.

This session covers:
-Connecting Oracle databases in the Cloud or on-premises to chat services via REST
-Considerations for building database APIs to handle ChatOps interactions
-Methods for securing communications between the database and application
-Practical examples of ChatOps integrations

Quest Forum Digital Event 2020

Oracle is revolutionizing how data is managed with the introduction of the world’s first self-driving database. Oracle Enterprise Manager offers a unified, cost-effective, and easy way to automate the migration of your on-premises database workloads to the next generation of industry-leading database, Oracle Autonomous Database, eliminating human labor and error. For Database Cloud Services, Enterprise Manager helps DBA’s consolidate Databases or Infrastructure on OCI Cloud and also assess success of migration. Reap benefits from seamlessly transferred configurations, periodic synchronization of data with production, and “time travel” capabilities such as rewind/refresh. Join this session to learn more.

Quest Forum Digital Event 2020

Encrypting data at rest is a foundational strategy for any information security program. The security of your data depends not just on how complete the encryption is within database environment but also on how much security and control you have over the encryption keys. In this session, join Oracle Database security product managers to learn about innovations in Oracle Transparent Data Encryption including online migration from clear text to encrypted data. Hear about the latest innovations in key management including the new multimaster high-availability architecture for Oracle Key Vault. The session also features real-world customer deployment cases.

Quest Forum Digital Event 2020

MySQL 8 introduced a new tool for DBAs. In this training session, we will explore the tool availability, installation, and usage. This tool is called MySQLShell and contains many features and  APIs that are very effective to manage the servers. MySQL/Oracle DBA can use this tool to explore the database using their Python/Javascript or Xconnector skills. This tool helps to download JSON documents to MySQL instance. We will go into details about many features that are very useful in daily DBA's tasks.

Quest Forum Digital Event 2020

The majority of modern IT solutions consist of multiple systems communicating using APIs. The “common language” is usually JSON. Unfortunately, the Oracle RDBMS did not have native JSON support until version 12c. Previously, developers had to use either third-party tools (the most popular was PL/JSON) or write their own code to support JSON processing. When it comes to database upgrades, the question arises: Should we utilize new features or not? This question is especially relevant when you need to edit 10,000+ lines of code and core system functionality.  The authors decided to accept a challenge and migrate from PL/JSON to Oracle native JSON and share their story with conference attendees.

Quest Forum Digital Event 2020

Most did not expect a new version after 11.2, but then the surprise - Oracle 18c XE was released - for FREE.  In this session, we will dive into what is Oracle Database Express Edition - the latest updates, including diving into the excellent features it brings to the table.  Areas that will be covered include installation, usage, new features, and how you can quickly get started with Oracle XE and Docker - a perfect match.

Quest Forum Digital Event 2020

We have used Pure Flash storage and Oracle Multitenant to fully utilize our servers with minimal license costs. We have over 300 database instances. 150 unique databases and only utilize 26 licenses.