Is there a topic you would like covered but do not see here? We are happy to take webinar suggestions. Email us at firstname.lastname@example.org.
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!
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.
Automated Anomalous Performance Detection Using Machine Learning in IT
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.
Best 18c New Features: A Painless Transition
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.
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!
Tuesday, April 21, 2020 12:00 PM - 1:00 PM EDT
Change Complex Requirem
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
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
Program Level: Beginner to Intermediate
Instructional Delivery Method: Group Internet Based
Thursday, April 23, 2020 12:00 PM - 1:00 PM EDT
At Your Service: Web Services & APEX
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!
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
Jim Czuprynski, Viscosity North America
You’re an overwhelmed Oracle DBA, and your organization’s Oracle databases are still moored to Oracle release 18.104.22.168—or even worse, 22.214.171.124—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 19c provides, 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.