Speaker Registration Training Days 2021

 

Thank you for submitting your abstracts and congratulations on being accepted to speak at UTOUG's Training Days.

When you register for the conference remember to specify how you would like to be compensated for each of your accepted presentations:

          - $150 stipend for each presentation

          - Donate to pay for student attendees' registration

Mark your calendar for UTOUG Training Days, March 17 - 18, 2021!

If you have any questions or need help, please contact trainingdays@utoug.org
UTOUG Training Days 2021 Tracks
APEX

APEX is one of our biggest communities at UTOUG. This group wants to learn about new features and how to do things better in Oracle Application Express. They also want to learn about those features that they probably are not using but should be.

BI & Data Warehousing

Our Business Intelligence and Data Warehousing track focuses on creating insights from data. On the Data Warehouse end, we discuss a wide range of topics from data warehouse implementation and maintenance to ETL processing tools and procedures. Our members also present on Business Intelligence, these sessions discuss reporting tools as well as ways to display the data to tell stories or show trends.

DBA

Currently our DBAs are concerned about performance, security, and cloud. Some of our members are still on 11g databases and they want to hear lessons learned in the upgrade to 19c. Others are considering what it will take to move to the cloud or how to manage an autonomous database. No matter what version or where their database is hosted, we are all concerned about the security of our systems. 

Development

The Development track focuses mostly on SQL and PL/SQL but we are not limited to that. Attendees of this track are interested in learning about new or better ways to do things. Visual Builder Studio, JET, JSON, ADF, Open Source, Docker, DevOps, etc. are all topics we are curious about.

Emerging Technology

Presentations in this track examine new and exciting tools and technologies like Artificial Intelligence, Machine Learning, and chatbots. Come see how business are implementing and benefiting from emerging technologies.

Getting Started

UTOUG is continuing to focus on incorporating content for students and junior level professionals who are still learning the tools we use. This track will offer beginner level content to help introduce the audience to the database or any of the other tracks.

Professional Development

The professional development track will discuss non-technical ways to help you improve your career opportunities or to be more efficient in your 
current job.

DB Viscosity Training PART 3: ORACLE DATABASE PERFORMANCE TUNING

Join ODTUG and Viscosity for a hands-on virtual class that introduces upgrading to Oracle 19c. In this class, students will get hands-on experience with on how to tune your Oracle database 19c. 

We have a limited number of user IDs available for the hands-on lab, so be sure to register quickly as a "Hands-On Participant" or for the HOL Waiting List. Registration is unlimited for those interested in only watching/listening.

Oracle database upgrades often lead to performance related issues. This is due to the number of underlying technical changes in software, introduction of new features, and general enhancement of the products. With many 19c upgrades going on, it’s good to know how to use the many technical features in Oracle for dealing with or even eliminating performance issue. 

In this lab we will go through some of the basic skills that every DBA should have around performance tuning from enhance explain plans and gathering statistics to using SQL Plan Management. We will also cover the differences between SQL Baselines and SQL profiles. This session should be good if you are an experienced DBA just brushing up on your skills, or new to using Oracle database performance tuning tools.


Outline: 

1. 19c upgrade / Lab setup 

     A. MOS Reading 

     B. Profiles vs Baselines 

     C. Optimizer Decision Tree

2. SQL Explain Plan + Lab 

     A. Normal 

     B. Plan statics 

     C. Monitor 

     D. Finding your statements

3. Database Statistics + Lab 

     A. Automated jobs 

     B. Checking object staleness 

4. SQL Plan Management (SPM) / Baselines + Lab 

     A. Create a baseline 

     B. Evolving Baseline 

     C. Viewing Baseline Plan / Usage 

5. SQL Profile + Lab 

     A. Generated by SQL tuning advisor 

     B. Transport to another DB 

6. SQL Patch + Lab 

     A. Grabbing a SQL ID 

     B. Adding a patch (hint)

ODTUG EPM Community Webinar: Inter-pod Revolutions: Connected Enterprise Solution in Oracle EPM Cloud

Presented by:Vatsal Gaonkar,Alithya

*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 pop up on your screen immediately after the webinar.

Prerequisites: None Program Level: Beginner to Intermediate Instructional Delivery Method: Group Internet Based Price & cancellation policy: Free. No need to cancel - if you do not attend you will be automatically cancelled.

At the time of this abstract submission, inter-application data transfer solutions are not possible using inter-pod data maps. The session will discuss a library of solutions implemented at clients for transferring between applications in separate pods. Each configuration has its own merits and use case. The four main categories that will be discussed are - 

   1.Trickle Feed - uses a combination of inter-pod REST API connection, data management load rule, groovy scripting and scheduled EPM Automate job on a jump server to pick-up the files from source and push to target. 

   2.Focused On-save Push - pushes an intersection from source to target using inter-pod REST API connection, data management load rule and groovy scripting. 

   3.Scheduled Push- uses a combination of windows or linux job, inter-pod REST API connection, groovy 
scripting, data management load rule and EPM Automate commands to extract and push data en masse from source 
to target. 

   4.Json Extract and Load - uses a combination of groovy scripting and inter-pod REST API connection to 
extract and push an intersection on-save. 

The audience will walk-away with learnings and understanding of inter-pod configurations, mainly for EPM Cloud planning applications. Snippets of code will form the "gold dust" takeaway from the session.

DB Viscosity Training PART 2: UPGRADING TO ORACLE DATABASE 19C

Join ODTUG and Viscosity for a hands-on virtual class that introduces upgrading to Oracle 19c. In this two hour class, students will get hands-on experience with on how to upgrade databases to Oracle Database 19c. A virtual 
presentation will be followed by the hands-on practicum on performing an actual database upgrade. Attendees will have access to a virtual machine with Oracle database versions 11.2.0.4 and 12.1.0.2 pre-installed with the latest PSU. Attendee can perform database upgrades from Oracle versions 11.2.0.4 or 12.1.0.2 to Oracle Database 19c (19.7 or higher). Only 30 user logins are available for hands-on, so be sure to register quickly as a "Hands-On Participant" if you want to secure a login for yourself. Registration is unlimited for those only interested in watching/listening.
The hands-on-lab will consist of the following: 
• Installing Oracle Database 19c software 
• Patching the database software to the latest Release Update (RU) 
• Performing pre-upgrade tasks prior to the database upgrade 
• Upgrading an Oracle 11.2.0.4 or 12.1.0.2 database to Oracle Database 19c with the latest RU • Performing post-upgrade tasks after the database upgrade

RMOUG: REACH FOR THE SUMMIT

Virtual Training Days

February 8 - 11, 2021
RMOUG Virtual Training Days

RMOUG’s Training Days is the premier grass-roots user training event in the U.S., offering a variety of 
technical and functional educational sessions over three days from world-renowned experts. It's known 
throughout the country for relevant content and networking opportunities, all of which will continue at this 
years' virtual event. 

For almost 30 years, Training Days has been hosted by RMOUG, an active, independent, nonprofit organization 
striving to provide its members with instruction, guidance, and networking events throughout the year, 
including a multi-page quarterly newsletter full of topical content and tips.

Note: Due to the limited space, you may only sign-up for a total of 2 workshops/deep-dive sessions. All other 
sessions are not limited and you do not need to pre-register for.

REGISTER
PRICE
TOTAL
RMOUG Member Conference Rate
If registering 5 or more people please contact leslie@epsconferences.com
US$100 US$100
New/Renewing Membership Fee and Conference Rate
If registering 5 or more people please contact leslie@epsconferences.com
US$175 US$175

Also Attending

  • Sandra Grotewohl
  • Sean Stacey
  • Craig Shallahmer
  • Bobby Curtis
  • Sean Scott
  • Elaine Thomas-Magnuson
  • Rocky
  • Adao Oliveira Junior
  • Roel Hartman
  • Kellyn Pot’Vin-Gorman
  • Marcelle Kaye
  • Tim Giltinan

What the Heck is the Oracle Optimizer Doing? Part 2 – Plan Costing

O que diabos o Oracle Optimizer está fazendo? Parte 2 - Plano de custos

Session Abstract:

When Oracle optimizes your SQL, it works out what it thinks is the best way to execute your statement to retrieve your data as quickly as possible, minimising unnecessary resource usage.

This presentation will look at what Oracle is doing. We will use the 10053 trace functionality to show how Oracle uses statistics to cost your SQL access paths, showing what cost really means and how it works, and the impact of messing with system statistics on your database.

Note: This webinar session not planned for recording, please attend the live session only.
Imagem
Neil Chandler
Database Guy, Chandler Systems

Neil has been working in IT since 1988, and with Oracle software since 1991.

He is an independent consultant who specialises in Performance Tuning, RAC, DataGuard, Goldengate, Upgrades, Data Migration, with some PL/SQL and Apex Development for good measure.

He likes to drink strong smooth Italian coffee, good beer and better whisky, depending upon the time of day.

Neil is an Oracle ACE Director, and a board member of the UKOUG

Exadata Storage Server Internals

Exadata Storage Server Internals

 

Session Abstract:
Storage is one of the most critical tiers in any database technology, The Exadata Storage Server runs the Exadata Storage Server Software and it provides several features like Smart Scan, Smart Flash Cache, Smart Flash Logging, IO Resource Manager, Storage Indexes and Hybrid Columnar Compression. Managing them becomes very important, take a deep dive into Exadata Storage Server Internals to know more on it.
Karan Dodwal (OCM) ♠
Karan Dodwal
Oracle Exadata Consultant, Fidelity International

Karan Dodwal is an Oracle ACE and Oracle Certified Master (OCM) with specialization in Oracle Cloud, Oracle Exadata and Performance Tuning, he works with Fidelity International as a Exadata DMA. He is an OTN Author where he frequently publishes articles on OTN, OTN Portuguese, OTN Spanish. He is a speaker and technical evangelist for All India Oracle Users Group where he presents sessions on Oracle Technology in various events like Sangam and OGYatra. In his free time he helps Oracle Users in Oracle Community through different forums. He has set up several Oracle High Availability Environments on all platforms for mission-critical Oracle Databases.

Getting started with automation in Oracle Cloud Infrastructure

This session will help get you started in Oracle Cloud Infrastructure automation. Maybe you're just starting out in cloud infrastructure management or you just need an overview of the related technology I'll discuss the aims of automation and consider how to get the most value out of automation.  Using working code example in common tools including the OCI API, OCI CLI, Python and Terraform I aim to provide the audience with a platform for further learning of essential skills the world of OCI operational management.

This session was orginally included in the UKOUG Conference 2020 agenda but did not run as planned.
Register
This event is free for members of the UKOUG. If you are a guest that registered for the UKOUG Conference 2020, please contact us with your booking details to book for this session for free.
27-JAN-2021
MEMBER RATE
This event is already included with your membership
Included in your membership

Register

GUEST ATTENDEE
You can attend this event at the non-member rate but membership may be a more cost effective option, find out more here.
£25

Register

STUDENT
Students can attend for free
FREE

Register
Speaker

Graham Smith

Graham Smith, Cedar Consulting

Graham Smith leads the PeopleSoft Technology Practice at Cedar Consulting (Version 1). He is an experienced software engineer and cloud infrastructure analyst and is an Oracle Cloud Infrastructure Certified Architect.  He’s also an Oracle ACE Director and is a regular presenter at Oracle OpenWorld and User Group events around the world and enjoys the friendly and helpful community of Oracle users.

Oracle 19c Hands-On Experience: New Features



Join ODTUG and Viscosity for a hands-on virtual class that introduces new features and enhancements in the Oracle 19c Database.

In this two hour class, students will get hands-on experience with Automatic Indexing, Performance Tuning and SQL Quarantine. Participants will also discover ways the Oracle 19c improves database security and protects data.

Only 30 user logins are available for hands-on, so be sure to register quickly as a "Hands-On Participant" if you want to secure a login for yourself. Registration is unlimited for those only interested in watching/listening. 

Outline:

Automatic Indexing 
SQL Performance Tuning Enhancements 
  Automatic SQL Plan Management 
  Real-Time Statistics and High-Frequency Statistics Collection 
  SQL Repair Advisor 
SQL Quarantine 
Security Enhancements 
  Schema-only accounts 
  Passwords removed from Oracle-supplied accounts 
  Privilege Analysis

Preparation: Students will need to have internet access, a web browser and a PDF reader if they are participating as a hands-on student.

Five (5) Oracle Machine Learning Notebooks You Should Know!

Oracle Machine Learning Notebooks provide a collaborative user interface for data scientists and business and data analysts who perform machine learning in Oracle Autonomous Database--both Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP). Oracle Machine Learning Notebooks enables data scientists, citizen data scientists, and data analysts to work together to explore their data visually and develop analytical methodologies. The Notebooks interface provides access to Oracle's high performance, parallel and scalable in-database implementations of machine learning algorithms via SQL and PL/SQL, with support for Python and R coming soon. Easy to understand and easy to repurpose, OML notebooks enable novice, intermediate and expert Oracle data professionals to leverage OML’s 30+ algorithms for classification, regression, anomaly detection, attribute importance, clustering, associations, text mining and other machine learning problems. This HOL session steps users through five (5) “must see” OML notebooks that serve as the core of many data science projects: classification, attribute importance, time-series forecasting, text mining and anomaly detection. Come learn how to get started using Oracle Machine Learning to tackle a wide variety of data-driven problems.

This session was orginally included in the UKOUG Conference 2020 however, due to a technical issue it did not run as planned.
Register
This event is free for members of the UKOUG. If you are a guest that registered for the UKOUG Conference 2020, please contact us with your booking details to book for this session for free.
20-JAN-2021
MEMBER RATE
This event is already included with your membership
Included in your membership

Register


GUEST ATTENDEE
You can attend this event at the non-member rate but membership may be a more cost effective option, find out more here.
£25

Register
STUDENT
Students can attend for free
FREE

Register
Speaker

avatar for Charlie Berger

Charlie Berger, Oracle

Charlie Berger is the Senior Director of Product Management, Machine Learning, AI and Cognitive Analytics for Oracle Server Technology. Since 1999, he has been responsible for Oracle Machine Learning—starting when Oracle acquired Thinking Machines Corporation where he was VP of Product Management & Marketing. He works closely with Development, Customers and Applications that embed OML’s algorithms. He is the co-founder of BIWA Inc. that runs the Analytics and Data Oracle User Community (AnDOUC) TechCasts and events. Previously, he worked in product management and engineering in several startups in expert systems, statistical and exploratory data analysis, robotics and machine vision. Prior to that, he graduated from Honeywell Computer’s 3-year Manufacturing Management Program. He holds an MS in Manufacturing Engineering and an MBA, both from Boston University, and a BS in Operations Research/Industrial Engineering from the University of Massachusetts at Amherst.