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

The IOUG Cloud Computing (and Virtualization) Special Interest Group (SIG) is dedicated to communication and information interchange around the subject matter of Cloud Computing. The SIG provides a vendor-neutral perspective to the private and public database cloud and delivery mechanisms for Database-As-A-Service (DBaaS), Infrastructure-As-A-Serice (IaaS) and select Platform-As-A-Service (PaaS) technologies. Join us at this Cloud SIG session at Quest Forum Digital Event   Community Education Weeks for a panel discussion on the latest cloud technology topics such as Oracle Gen 2 Cloud, Database-as-a-Service, and Oracle Autonomous Databases Cloud service, etc. The panel will also discuss how the cloud may impact you and how your applications & databases along with your skills and career can adapt to the cloud age.

Quest Forum Digital Event 2020

Setting up Cloud Environments using the Web UI is only the second-best option. The method of choice is Scripting. While HashiCorps Terraform has become the lingua franca for defining large setups, it appears to be a bit unwieldy for small changes. Oracle provides the OCI Command Line Interface (CLI) as OpenSource on GitHub, which is ideal for those small changes.

This talk introduces to Scripting with the OCI CLI. It walks through the process of setting it up. A quick orientation is followed by a deep dive in the command line and JSON Parameters. Tips and Tricks as well as common caveats an how to avoid them lead to the conclusion. The presentation contains a live demo. All Demos are available for download.

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

According to research, organizations in the top tier of data literacy had a greater enterprise value of 3 to 5 percent. What is data literacy? It's the ability to read, work with, analyze and argue the data. Learn how to grow yourself and your organization by increasing data literacy. We'll talk about four different data personalities and an action plan for each personality to increase their data potential.

Quest Forum Digital Event 2020

AWS continuously rolls out new tools and capabilities around analytics at a pace that can be hard to keep up with, much less take advantage of.  In this session, we will provide an overview of the AWS suite of analytics tools, discuss current concepts such as data lakes, unstructured data, ML and AI, and review some ways that customers can begin experimenting on their own to see what areas would be beneficial to their business.

Quest Forum Digital Event 2020

Application Express (APEX) continues to grow in popularity for application development, both for new business use cases as well as migration from older development technologies (e.g. PowerBuilder). But many developers and DBAs alike aren’t necessarily aware that APEX is now available within Oracle Autonomous Transaction Processing, a powerful self-contained set of Cloud-based database services.

This session demonstrates a real-life business scenario – the creation of a financial services/retirement planning application – that combines best practices for APEX development efforts with ATP’s simplicity to provide a stable deployment for hybrid OLTP and reporting workloads.

Quest Forum Digital Event 2020

Have you moved beyond just sending alerts and monitoring performance in OEM?  If not, learn the top 5 things that you should be doing to take your game to the next level.  Topics will include high availability, standby management, configuration management, and more!