NYOUG Virtual Lunchtime Training Series

About The Event

Join the New York Oracle Users Group for a Tuesday through Friday knowledge feast! With two to three sessions a day, we hope to enlighten your week with information that can help you personally, or your team at work. Whether you're working from home or at the office, tune in and get ready for a different deep-dive topic per day!

Registration per day is required! Be sure to register for each training day which includes a session you are interested in watching.

Join us at any time throughout the Training Day(s) you signed up for via your Zoom confirmation.

All sessions are FREE, thanks to our sponsors!

11:00 AM ET

So you want to run your Oracle Database in the Cloud?

Every industry, from financial services to healthcare, can benefit from running their Oracle database in the cloud. The choice is not whether or not to use a cloud database, but instead, which model and type will work best to meet your specific needs.

The good news is Oracle has something for everyone. Whether you’re looking for an easy to manage DBaaS provisioned service, or the power of a fully provisioned Exadata Cloud Service or perhaps the operational efficiency of a fully Autonomous Database is what you’re looking for. Don’t worry Oracle has you covered.

Attend this session to learn about Oracle’s database cloud services portfolio and find the solution that fits your needs.

DATABASE by Sean StaceyDirector Product Management

12:00 PM ET

From DBA to DE: Becoming a Data Engineer

Today’s Oracle DBA has acquired extremely valuable skills that actually make it simpler than ever to transition to the role of Data Engineer (DE). After all, who knows their application systems’ data – the myriad places where it’s stored, its relative quality and timeliness, and value to her IT organization - better than the DBA?

This session will:
• Explain what the DE role often entails in forward-looking IT teams
• Describe what current skills are needed to fulfill the role, and what upskilling is required
• Discuss how best to maintain relevance for your career’s foreseeable future

DATABASE by Jim CzuprynskiTechnology Advocate

13:00 PM ET

Player Piano - The world of Oracle Autonomous Data Warehouse / Autonomous Transaction Processing

Emerging information technology trends for the cloud have the power to transform organizations. In the data management and analytics space, a key cloud service offering has arrived. Oracle Autonomous Data Warehouse (ADW) Cloud & Oracle Autonomous Transaction Processing (ATP) simplifies the provisioning, maintenance, and optimization for data warehouse workloads in the cloud, and promotes low touch for database administrators and load and pull approaches to data analytics. In this session learn about ADW/ATP provisioning and data loading, see a series of performance benchmarks, and discover the process flow of start the service, define tables, load data, and then run queries. You'll also see the world of Player Piano materialize as the DBA's in their ghost shirts ride into the headwinds of the future.

CLOUD by Rich NiemicViscosity

12:00 PM ET

Oracle on Azure, the Why, the How and the What to Know

The session will cover why customers are migrating Oracle workloads onto Azure Cloud, how to correctly assess workloads and identify red flags before they become an issue in your migration strategy. We’ll cover compute and storage options for success and how to avoid the pitfalls of licensing and what modernization really means for many Oracle workloads in Azure.

MICROSOFT AZURE by Kellyn Gorman Microsoft

13:00 PM ET

Oracle database backups, HA, and DR within Azure

This presentation will focus on the choices available for database backups, high availability, and disaster resiliency for Oracle database workloads running in Azure. There are currently more than 5000 Azure customers running Oracle database workloads in Azure IaaS, and that number is growing by leaps and bounds. We discuss how to protect databases using backups and redundancy, and how to maximize database service availability. Many customers formerly used Oracle RAC on-prem, but due to Oracle’s prohibition of RAC in public clouds other than their own (for whatever reason), all have realized the fact that RAC isn’t needed, likely has never been needed, and most likely has even been an obstacle to high availability for Oracle database.

MICROSOFT AZURE by Tim Gorman Microsoft

11:00 AM ET

Manage and Diagnose Cluster Health and Performance with GIMR

The Grid Infrastructure Management Repository, or GIMR, is a powerful tool for monitoring cluster health and performance. GIMR was, unfortunately, poorly received when introduced in Oracle Database 12c and developed a bit of a bad reputation. As a result, many DBAs don't leverage GIMR and its related suite of diagnostics to their full potential. This session looks beyond the myths and mystery of GIMR, and casts new light on its features and functionality.

Topics covered:

GIMR, the MGMT database, and Cluster Health Advisor (CHA) overview
Best practices and recommendations for managing the GIMR environment
Differences and advantages of CHA's "normality model" over threshold-based alerts
Creating and calibrating cluster performance models to address KPIs and temporal variations
Understanding and acting on cluster performance alerts and recommendations
Identifying and addressing common issues

SQL by Sean ScottViscosity

12:00 PM ET

Oracle SQL Plan Management (SPM) your Imperative Performance Tool

Oracle SQL Plan Management (SPM) is often overlooked and underused. This feature started in version 11.1 and has been enhanced with each new release. As of 19c this should be your go to method to help maintain well performing SQL statements. In this session we will cover what SPM is, how to use SPM from end to end, and how to monitor it. Once you start using SPM Baselines you will find them to an invaluable tool in your continuous goal to maintain database performance.

SQL by Gary GordhamerViscosity

13:00 PM ET

Need for Speed? My Top Five Oracle Performance Tuning Tips

Performance tuning can be complex. It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, System Consultant at Quest Software, will detail 5 steps to quickly identify performance issues and resolve them. Attendees at this session will learn how to:

Quickly fine tune a SQL statement
Identify performance inhibitors to help avoid future performance issues
Recognize and understand how new Oracle features can change and/or support different execution plans

SQL by Janis Griffin Quest Technologies

12:00 PM ET

Supercharge data processing with PL/SQL

One of Tom Kyte’s mantras was “You should process data with one SQL statement”. Yet often you have to run many different statements in a transaction. In these cases PL/SQL is the essential glue that holds the process together.

Join this session to learn how to write great PL/SQL and learn about its latest enhancements.

SQL by Chris SaxonOracle Corporation

13:00 PM ET

PL/SQL All the Things in Oracle SQL Developer, SQLcl, & ORDS

The IDE for PL/SQL offers support for debugging, code profiling, and so much more. This session will give a quick overview of all the major development lifecycle tasks for your PL/SQL programs.

We’ll end with a quick demo of all the cool things you can do with PL/SQL programs in your Oracle REST APIs!

SQL by Jeff SmithOracle Corporation