December 7 - December 10, 2020

Strategic insight and how-to education for Oracle users of all levels

Quest Experience Week: Database and Technology Day

Thursday, December 10

Database and Technology Day is packed full of digital education designed to provide strategic insights and how-to-education for database users of all levels. Best of all? Registration is free, so please join us!

Have questions or need help? Contact us at [email protected].

Database & Technology Day Sessions

11:00 am – 11:45 am ET

Opening Session

The Future is Data-Driven

In today’s world, the ability to quickly create value from different types of data increasingly provides businesses with a competitive edge. But as companies develop more apps, analytics, and ML to digitize their processes and decision points, they’re faced with a difficult choice: to either optimize for fast application development now or easier value creation from data later. In other words, developer productivity or data productivity. In this session, Maria Colgan will explain how Oracle gives developers the right tools for each job to make them more productive, and IT a unified data tier that makes reuse of data and overall management simpler and easier.

Presented by:
Maria Colgan
Oracle

12:30 pm – 1:15 pm ET

Streamlining Oracle Workloads from on-premises to VMware Hybrid Cloud

It is a formidable task to ensure Business Critical Applications meet business SLA’s within the given RTO/RPO and this requires simplifying , standardizing and automating the deployment and configuration along with providing HA and DR these critical applications to meet the above business objectives . VMware Hybrid Cloud which includes VMware Cloud on AWS and Oracle Cloud VMware Solution (OCVS) provides consistent and interoperable infrastructure and services between VMware-based datacenters and the Public cloud, which minimizes the complexity and associated risks of managing diverse environments.

This session will show the lifecycle of BCA workloads on VMware Cloud on AWS. This includes the methodology of migrating Oracle BCA from a Physical architecture (Big Endian) , Engineered Systems or non-VMware virtual platform to VMware vSphere with all best practices. This session will also show providing HA and DR across multi-AZ using Stretched Clusters for VMware Cloud on AWS for all cloud use cases.

Presented by:
Sudhir Balasubramanian and Don Sullivan

Reverse Engineer Machine Learning To Develop Performance Monitoring Rules

Tired of continuously adjusting your performance monitoring and alerting rules? How about using machine learning to create the rules instead! Sure, we can train a supervised ML model to recognize patterns of poor performance. But what if your IT department is not ready to embrace it?

A novel solution is to train a supervised machine learning model to recognize patterns of poor performance, but then extract the rules in plain English and then manually enter them into your existing monitoring and alerting platform. Is this possible? Yes it is! And, I will demonstrate how you can do this.

To ensure you can easily do everything I do, I will use industry standard Python ML libraries, the industry standard Jupyter notebook, AWR and support ticket data. You can experiment with the demonstration materials “as is” and then use them to push your ML and rule creation knowledge deeper.

Presented by:
Craig Shallahamer
OraPub

Moving to the Oracle Cloud with Zero Downtime Migration

Introducing Oracle Zero Downtime Migration (ZDM), Oracle premier automated tool for moving your database from on-premises to the Oracle Cloud. ZDM is an automated tool that leverages the best of high availability and scalability solutions at Oracle  thus moving your Oracle Database to the Oracle Cloud with no downtime. In this session, we will cover in-depth the full range of features and functionality of Oracle Zero Downtime Migration, how it was designed and built and how it can be leveraged for all your migration needs. We will finish by discussing roadmap for ZDM and all things Oracle Database Cloud Migration.

Presented by:
Ricardo Gonzalez
Oracle

The DBA’s Next Great Job

What’s the next role for the DevOps or DBA as the autonomous database and Oracle enhancements free up time? This session will cover the role (managing more databases with autonomous database) & the integration of AI and Machine Learning. Technology is advancing at an exponential rate. This session will show what this means to your company and your future job. See major advances being driven, but also those that will be driven by the autonomous future Oracle is driving ahead.

Presented by:
Rich Niemic
Viscosity

1:45 pm – 2:30 pm ET

Data for Nothing, Get Your Cloud for Free (I Want My Oracle Cloud)

At Oracle Open World 2019, Oracle announced an Always Free Tier of cloud services. This session will review what’s available with these free cloud services such as Oracle autonomous databases including Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP), compute with up to 2 virtual machines, storage including block, object, and archive storage. We’ll explore how these free services work and what can be done with them, such as creating proof of concept systems. Looking for data? No problem! We’ll explore the vast number of free data sources that are available and can be consumed using Application Programming Interfaces (APIs). Once we combine the two, we can easily pull data into these cloud services while creating fully functioning applications including the use of Oracle Application Express (APEX).

Presented by:
Alfredo Abate
Brake Parts Inc LLC

Using Graph Analytics for New Insights

The interesting thing about a graph is that we can use it with almost every application. We can view most data sets as a graph, and that gives you the ability to see your data through the connections and relationships between data entities. Once you represent your data as a graph, you can apply graph algorithms to get new insights into your data. In this session, I will discuss how you can create a graph from relational tables in Oracle Autonomous Database, apply graph algorithms to this graph, and use the results in your applications. My goal is to demystify graph analytics and help you get started using graphs in your analytics applications.

Presented by:
Melliyal Annamalai
Oracle

Oracle Advanced security features in combination with our in-house best practice to safeguard databases for SaaS Applications

In this era, data privacy and security is a major concern. It is a challenge to be compliant with the standards as far as data security is concerned. Oracle Advanced Security options provide us easy ways to protect our databases and be compliant at the same time. This session will give an overview and use cases of several impactful Oracle Advanced Security features we have been using for our SaaS applications in real life production systems. In addition to that, there are several other in-house best practice we have developed over the years which might be beneficial for others.

Presented by:
Omar Faruq
Therap Services, LLC

Oracle 19c Best New Features and a few 21c Tips

This presentation will look at which 19c new features that should be investigated for use. This presentation will also have a few 21c new features such as AutoML. This presentation will also look at which 18c new features that should be in use (such as Snapshot Carousel, PDB Switchover, In-Memory External Tables, Merge Partition Online, Advances in the Approximate Query, Polymorphic Tables, Standby Nologging, and Password-less Schema Creation – & others). Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer. There will be simple examples, where possible, to show the basic functionality of the new features. Some features are too new to show example, but only explain. We will also look at the autonomous database and Oracle’s focus on the future of security.

Presented by:
Rich Niemic
Viscosity

3:00 pm – 3:45 pm ET

OCI: First Class Experience, Economy Class Price

Learn why customers choose Oracle Cloud Infrastructure (OCI) to run PeopleSoft and JD Edwards even when they have existing investments in other Clouds. It comes down to superior economics, single vendor support, application certification, predefined deployment architectures and security postures, the broadest data management platform, lightning fast performance – with the peace of mind of the broadest service level agreement of ANY cloud.

Presented by:
Vishram Patwardhan, Oracle
Dave Geoffrion, Oracle
Rich Konopka, Oracle

Top 10 Ways To Totally Mess-Up An AWR Analysis

You think you have seen it all… and then you see something new. I have studied literally hundreds of AWR reports and thought through thousands of performance scenarios. While I know how to use an AWR or Statspack report to analyze Oracle performance, I have also learned how to totally mess-up the analysis. There are some obvious ways to totally invalidate your analysis. But there are also some subtle mess-ups that fool you into thinking your time-based analysis is rock solid…yet it’s worthless and probably misleading. Join me for a light-hearted session as we explore what NOT to do.

Presented by:
Craig Shallahamer
OraPub

Machine Learning with Automation, Scalability, and Security

Solving today’s business problems increasingly relies on machine learning techniques to leverage the volumes of data enterprises both amass and have access to. Oracle Machine Learning empowers data scientists, data analysts, DBAs, application developers, and executives to realize machine learning-based solutions faster and more easily. Automation of the model building process, referred to as AutoML, along with the ability to scale to enterprise data volumes while maintaining data security in Oracle Database, all come together to meet enterprise needs. In this session, learn about the in-database machine learning features and services, including those related to Oracle Autonomous Database. This session will include demonstrations and previews of Oracle Machine Learning functionality.

Presented by:
Mark Hornick
Oracle

Managing Unstructured Data: LOBs in the World of JSON (New Features and Getting There / Accelerating the database)

One of the most critical aspects of building effective systems is the successful management of unstructured/semi-structured information. The database is no longer only a place to store dollars and cents for the purposes of accounting. Efficient manipulation of JSON has become one of the most critical elements of contemporary database infrastructure. Even though you can store JSON documents in VARCHAR2 columns, in reality you will quickly outgrow VARCHAR2 size limitations and will have to switch to LOBs for storage. However, few people in the development community really understand the underlying mechanics of Oracle LOB datatypes and consider it yet another DBA issue. This presentation attempts to fill that knowledge gap.

Presented by:
Michael Rosenblum
Dulcian

4:15 pm – 5:00 pm ET

A New Era: Transform the Way You Operate & Manage Your Databases Across Private & Hybrid Clouds

Imagine managing your Oracle environment with a unified database operating model while delivering simplicity, performance, availability, and security across private and public clouds. Gone are the late night outage fire drills and the long hours troubleshooting strange performance issues. Nutanix eliminates database management complexity by up to 90% so that organizations can accelerate time to market by as much as 8X.

Learn how to keep your business running with near-zero downtime and still reduce DBA off-hour workload by as much as 50%. Regardless of where your database resides, find out how Nutanix can save you time and transform you into a business driver.

Presented by:
Varun Verma
Nutanix

Get Involved!

Come learn about SELECT Journal! Are you interested in getting your writing published, getting ACE credit for your work, and sharing your knowledge with other Oracle users? Quest Oracle Community is looking for writers to contribute to the SELECT Journal for our Quest Database & Technology Community audience. We are looking for writers with expertise in a variety of topics, so if you think this could be a good fit for you, join this session!

Presented by:
Tim Boles
Hitachi

Oracle APEX: From Idea to Application at the Speed of Light

The need for immediate applications to manage information has never been greater.  Within the past year, countless organizations around the world had unanticipated requirements thrust upon them.  Those organizations skilled in Low Code development platforms delivered solutions far faster than their traditional coding counterparts.  Learn what their advantage was. This session will be a live demonstration of Oracle Application Express (APEX), the low code development platform from Oracle.  In a matter of minutes, we will go from concept to data model to prototype to refined application.  We’ll also convert a spreadsheet to a multi-user Web application.  Two applications in under 45 minutes.  Fasten your seat belt!

Presented by:
Joel Kallman
Oracle

Thanks to our Database & Technology Day sponsors:

Contact us