Is there a topic you would like covered but do not see here? We are happy to take webinar suggestions. Email us at kgately@odtug.com.

Did you miss a webinar? As a full ODTUG member, you can view all of our past webinars at any time. Just log in and you will see the link for the recorded list under the Resources tab. Not a member? Join now for $99!

NASBA_CPERegistry_logo_color_transparent.png  ODTUG is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry  of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.NASBARegistry.org.

How to qualify for CPE Credits:

  • Register for the webinar, indicate that you are a Full (paid) ODTUG member, and check the box on your registration form to indicate you'll be earning credits.
  • Attend the session and fill out an evaluation form; make sure to include your name. The evaluation form will be sent to you once the webinar is completed.
  • You must respond to all poll questions that will show up on the screen at random during the presentation.
  • After the webinar, you will receive a certificate via email for the session you attended.
  • Submit the certificate to your State Board of Accountancy.

Webinars are free to all. No cancellation is required. If you do not attend, your registration will automatically be cancelled.

Webinars that are eligible for CPE credit will be noted as such in their description.
Our webinar calendar is constantly evolving! Check back frequently, as more webinars will be added to the schedule.

Suggest a Topic   Past ODTUG Webinar

communities_0006_Layer-6.pngEmerging correct.jpg Tuesday, April 7, 2020 11:00 AM - 12:00 PM EDT  
  Automated Anomalous Performance Detection Using Machine Learning in IT

  ACE Director.jpg Craig Shallahamer, OraPub

Oracle performance issues typically fall into two categories. Either "I've seen this before and it's bad!" or "I've never seen this before. We better check it out!" The good news is that a trained analyst with many years of experience can quickly do an AWR or ASH analysis.

The bad news is that this manual approach DOES NOT SCALE! Even an expert can't comfortably monitor hundreds or thousands of databases. And, our rule-based systems are relatively simplistic because they can't capture the complexity and diversity of activity in production Oracle systems.
One solution for this unscalable monitoring and analysis problem is to use machine learning. So, in this webinar I'm going to introduce you to the world of applied machine learning from an Oracle professional (DBA/developer/manager) perspective. This includes understanding what ML is, why use it, and why now. 
But the best part is that I will demonstrate how to create an automated anomalous performance detection system! I'll be using industry standard Python with its ML libraries and Jupyter Notebooks. You will be able to download and do everything I do in this webinar!
If you have ever wondered how ML can be applied in an IT environment, you don't want to miss this webinar.

communities_0006_Layer-6.png Thursday, April 9, 2020 12:00 PM - 1:00 PM EDT  
  Best 18c New Features: A Painless Transition

  ACE Director.jpg Rich Niemiec, Viscosity North America

This webinar will focus on some of the best 18c new features that should be investigated for use for tuning, applications, and administration. Some of you may only be on 12c (or just moving there). Some of you may be on 12cR2 or 18c already but haven’t had the time to investigate or implement some of the great features. This session is for you!

The features we’ll cover for 18c are not only central for effective database administration tasks; they’re also the key to helping application developers write better code to leverage built-in efficiencies that 18c provides. In this session, we’ll offer simple examples, such as how to leverage the new PDB Snapshot Carousel, to show the basic functionality of the new features.

Register Here

communities_0001_Layer-1.png Tuesday, April 14, 2020 12:00 PM - 1:00 PM EDT  
  APEX is Traveling the World Spatially Through Google!
 Brandon Webb, Datavail

Have you ever wondered how to locate and put dots on a map in an application? Thanks to Oracle APEX and Google Maps, you can do it! Learn how to build your own geospatial application utilizing Oracle APEX and Google. In the presentation we’ll cover the history of spatial, spatial analytics, and the geographic information system. From there a live demo will cover how to:

  • Make calls to the Google API
  • Pass in a parameter to get latitude and longitude
  • Set up procedure in a database to call Google API
  • Store and retrieve geolocation data from Oracle JSON
  • Analyze heat maps and more!

Register Here

communities_0003_Layer-3.png CPE Web Icon.pngTuesday, April 21, 2020 12:00 PM - 1:00 PM EDT  
 Change Complex Requirements to Simple Solutions: Customization of FCCS Consolidation Rules
 Megha Chopra and Mohit Jain, Genpact

*This webinar is eligible for one (1) CPE credit for Computer Software & Apps. To receive the credit attendees must be a Full (paid) ODTUG member, attend the entire webinar and answer all poll questions that will pop up on-screen during the webinar, and fill out the evaluation form (with your name) that will be sent out immediately after the webinar.

FCCS provides powerful inbuilt configurable consolidation. Every organization has to customize their consolidation rules as dictated by their company's internal structure. Consolidation methods and configurable consolidation rules are the two important pillars for setting up custom consolidation for the organization.

We are presenting a session on FCCS's powerful configurable consolidation. Learning objectives for this session include:

1.      The seven system-defined consolidation methods and how to use them effectively
2.      What are the consolidation methods' configurable parameters – (ownership %, consolidation %, control and minority (non-controlling) interest %)
3.      How to create custom consolidation methods
4.      Ownership management: how to define the consolidation settings to each entity hierarchy on a scenario, year, and period
5.      Data forms and dimensions setup for ownership module
6.      How to use nine seeded consolidation rules
7.      How to use standard elimination consolidation rules
8.      Advanced configurable consolidation rules
9.      How to effectively use consolidation rulesets and rules

Prerequisites: None
Program Level: Beginner to Intermediate
Instructional Delivery Method: Group Internet Based

Register Here

communities_0001_Layer-1.png Thursday, April 23, 2020 12:00 PM - 1:00 PM EDT  
  At Your Service: Web Services & APEX
  ACE Director.jpg Scott Spendolini,  Viscosity North America

As organizations turn to the cloud and SaaS solutions more and more, their data becomes stored in multiple locations. While the cloud brings many benefits to an organization, it’s also creating new challenges, such as how to report across platforms in a single place.

To address this, APEX introduced a new feature called Web Source Modules. Web Source Modules make it trivial for APEX developers to consume and integrate any RESTful web service hosted by anyone. Once integrated, APEX forms, reports, charts, and even calendars can point to the corresponding web service displayed on any APEX page.

This session will provide an overview of Web Source Modules, what they are capable of, and how they work with other APEX components. It will then walk through how to create them and tie them to APEX components for reporting as well as CRUD operations—all without writing a single line of code!

Register Here

communities_0006_Layer-6.png Thursday, May 7, 2020 12:00 PM - 1:00 PM EDT 
 You’re At 18, Going to 19: Standing Pat on Oracle Database 19c in 2020 and Beyond
 ACE Director.jpg Jim Czuprynski, Viscosity North America

You’re an overwhelmed Oracle DBA, and your organization’s Oracle databases are still moored to Oracle release—or even worse,—but you can see the writing on the wall: It’s time to upgrade, and soon. Or perhaps you’ve just completed a rather painful upgrade process to 12cR2 or 18c, and after getting your database back to merely performant again, you can’t even think about the next release without a lump in your throat or butterflies in your stomach.

This webinar is the third in a series focused on getting your Oracle environment ready to take advantage of the appropriate database release; it will focus on some excellent reasons to overcome those trepidations: the immense benefits that Oracle Database 19provides, including new multitenant licensing, numerous performance improvements, simpler-than-ever automatic upgrades, and the first steps towards the truly converged database.

This session is designed to help Oracle DBAs, regardless of their level of expertise, to migrate quickly, efficiently, and nearly painlessly to Oracle 19c so they can take immediate advantage of its latest features.

Register Here