UTOUG Training Days 2025: Full Schedule

arrow_back View All Dates

9:30am MDT

APEX Collections: What's in Your Collection?

Monday March 24, 2025 9:30am - 10:15am MDT

In this presentation, we will cover this powerful APEX component and how it can be implemented in many areas of your applications. APEX Collections can store large amounts of data within session state, including CLOBs and BLOBs. They are a necessity when working with Interactive Grids and reducing application to database server connections.

Speakers

Marty Booth

Senior DBA, Sports Medicine Research and Testing Laboratory

Marty enjoys working with data and designing database structures. An Oracle APEX enthusiast, he also has a passion for forecasting and monitoring weather conditions and playing the piano.

Monday March 24, 2025 9:30am - 10:15am MDT
Room 105

Development

9:30am MDT

What You Missed at CloudWorld 2024 & Leveraging AI

Monday March 24, 2025 9:30am - 10:15am MDT

Room 209

A keynote by Larry Ellison highlighted why four clouds are key to Multi-Cloud Databases, while Safra Catz emphasized Oracle's commitment to customers. Andy Mendelsohn unveiled new 23ai features and AI-enhanced SQL, Juan Loaza introduced the Oracle Vector Database and the new Oracle GenDev environment for AI development, and Steve Miranda discussed over 100 AI features in Oracle Applications. My session will integrate key insights from these discussions, focusing on practical AI applications.

Speakers

Rich Niemiec

Chief Innovation Officer, Viscosity North America

Rich Niemiec is the current chief innovation officer of Viscosity North America. A world-renowned IT and data expert, he co-founded and served as CEO of TUSC, a Chicago-based systems integrator of business solutions founded in 1988. Rich is inducted into both the Chicago and E&Y National... Read More →

Monday March 24, 2025 9:30am - 10:15am MDT
Room 209

Development, Data (not database)

10:30am MDT

Security Forum for DBAs and Developer

Monday March 24, 2025 10:30am - 11:15am MDT

Room 105

Speakers

Karen Cannell

CTHO, TH Technology

Karen Cannell is the CTHO of TH Technology, a U.S.-based consulting firm specializing in Oracle technology solutions, particularly APEX. With more than 30 years of IT experience, she has served the government, engineering, healthcare, and fisheries industries. Karen is an Oracle ACE... Read More →

Monday March 24, 2025 10:30am - 11:15am MDT
Room 105

Development, Development

10:30am MDT

The Ultimate Beginner's Guide to Database Changes Using Oracle SQLcl & Liquibase

Monday March 24, 2025 10:30am - 11:15am MDT

Room 209

Almost all developers and DBAs are familiar with Oracle's SQL Developer and SQL Command Line (SQLcl) tools—but did you know SQLcl includes an Oracle-customized version of Liquibase?
What is Liquibase, and why should you use it for schema changes? How should it fit into a developer's or DBA's daily work? Is it only required as part of a CI/CD pipeline? And how do you get started with this Oracle-specific version of Liquibase?
This session serves as the ultimate beginner's guide to managing database schema changes with SQLcl and Liquibase. It features conceptual explanations in simple, easy-to-understand terms, along with live demos.

Speakers

Simon Pane

Principal Consultant, Pythian

Simon is an Oracle ACE Pro and Oracle Certified Professional with extensive experience presenting at major Oracle and PostgreSQL conferences, including Oracle CloudWorld. He has won multiple speaking and writing awards, including the UKOUG Best New Overseas Speaker in 2016. A former... Read More →

Monday March 24, 2025 10:30am - 11:15am MDT
Room 209

Development, Infrastructure (including database)

11:30am MDT

Oracle Developer Tuning Tips

Monday March 24, 2025 11:30am - 12:15pm MDT

Room 105

Whether you're new to SQL tuning or celebrating your 10th year, this session offers valuable insights for all skill levels. We’ll begin with a quick introduction to SQL and the Oracle Optimizer, followed by specific examples and tips on various SQL tuning options and methods. The goal is to provide practical takeaways without delving too deeply into any one area. Example code and demonstrations will be included.

Learning objectives include:
- What is SQL tuning?
- Which tools should I use?
- Why Explain Plan may be misleading
- The importance of statistics and histograms
- How to use Tuning Advisor and AWR Top N SQL
- Why SQL Profiles fail
- How to create a SQL Baseline from the cursor cache
- How to create a SQL Patch
- Optimizer tuning techniques
- Why isn’t my index being used? (Index clustering)

Speakers

Gary Gordhamer

Managing Principal Consultant, Viscosity North America

Gary Gordhamer has spent much of his career focusing on enterprise application landscapes and business process digitization. His technical experience spans more than 30 years with Oracle E-Business Suite, middleware, databases, and related technologies. His professional background... Read More →

Monday March 24, 2025 11:30am - 12:15pm MDT
Room 105

Development, Infrastructure (including database)

1:15pm MDT

Developing Your First AI Chatbot with GenAI

Monday March 24, 2025 1:15pm - 2:00pm MDT

Room 209

With the rapid growth of generative AI tools over the past two years, creating an AI chatbot has become easier than ever. This presentation explores how AI chatbots differ from rule-based and intent-based models, highlighting their benefits, effectiveness, and emerging risks. It also includes a live, step-by-step demo on developing an AI chatbot and comparing backend services such as OpenAI, Azure OpenAI, and OCI Generative AI.

Speakers

Ahmed Aboulnaga

Director, REI Systems

Ahmed Aboulnaga specializes in technical management, architecture, and consulting, with a focus on Oracle, Java, and cloud technologies. Over the course of his 20-year career, he has delivered enterprise solutions for commercial, government, and global clients. An Oracle ACE and published... Read More →

Monday March 24, 2025 1:15pm - 2:00pm MDT
Room 209

Development, Beyond Oracle

1:15pm MDT

Getting Started with Oracle Visual Builder - Part 1

Monday March 24, 2025 1:15pm - 2:00pm MDT

Room 105

Discover how to develop with the platform powering the next generation of Oracle Redwood Fusion Cloud Apps. Oracle Visual Builder is a visual development platform designed to simplify the creation of responsive applications using a JavaScript/HTML/REST tech stack.

This demo-focused session will explain the architecture and components of an application and guide you through the basic building blocks needed to create your own applications.

Speakers

Blaine Carter

Product Manager, Oracle

Blaine Carter is a product manager for Visual Builder and Visual Builder Studio. He enjoys discovering how things work and sharing that knowledge with others.

Monday March 24, 2025 1:15pm - 2:00pm MDT
Room 105

Development

2:15pm MDT

Building a Card Viewer App with Oracle APEX and API Integration

Monday March 24, 2025 2:15pm - 3:00pm MDT

Room 220

In this presentation, we will explore how to leverage Oracle APEX to build a powerful, user-friendly application that dynamically pulls and displays images using external API data. Oracle APEX’s low-code environment streamlines application development, while API integration provides access to a vast library of data and images. Learn how to set up an API connection, manage and display dynamic images, and build intuitive filters for sorting and viewing cards. By the end of the session, you’ll be equipped with the knowledge to create interactive, data-driven applications that access and display external data, enriching the user experience and expanding the capabilities of Oracle APEX.

Speakers

Alan Quigley

Senior Software Architect, Viscosity North America

Alan Quigley is a senior software architect with Viscosity North America and has been an Oracle PLSQL and APEX developer for over 14 years.

Monday March 24, 2025 2:15pm - 3:00pm MDT
Room 220

Development

2:15pm MDT

Getting Started with Oracle Visual Builder - Part 2

Monday March 24, 2025 2:15pm - 3:00pm MDT

Room 105

Speakers

Blaine Carter

Product Manager, Oracle

Blaine Carter is a product manager for Visual Builder and Visual Builder Studio. He enjoys discovering how things work and sharing that knowledge with others.

Monday March 24, 2025 2:15pm - 3:00pm MDT
Room 105

Development

2:15pm MDT

PLSQL Hidden Features for Devs & DBAs

Monday March 24, 2025 2:15pm - 3:00pm MDT

Room 209

"Every problem is a database problem until the DBA proves otherwise."
Learn how to use PL/SQL's lesser-known or rarely used features to understand, debug, trace, log, document, and speed up your code. Discover how DBAs can guide and assist developers in mastering these techniques.

Speakers

Matheus Boesing

Database Consultant, Aggrandize

A frequent speaker in the Oracle community across Latin America and Europe, Matheus is a computer scientist from PUCRS with 15 years of experience as an Oracle DBA. He is an Oracle Instructor and serves as a professor for the databases in cloud postgraduate program in Brazil. Matheus... Read More →

Monday March 24, 2025 2:15pm - 3:00pm MDT
Room 209

Development, Infrastructure (including database)

3:15pm MDT

A Fishy Business, Secured: A Real Implementation of RAS in APEX

Monday March 24, 2025 3:15pm - 4:00pm MDT

Room 209

"How much time and resources could you save by implementing security rules just once?

Learn about the challenges faced and lessons learned from a real-world implementation of Real Application Security (RAS) in APEX at a large, multi-government fisheries agency. While RAS often gets a bad rap for being too complex or tricky, it effectively addressed the costly problem of enforcing complex security rules across multiple schemas, roles, applications, and connection methods.

In this session, we’ll share our experience with a complex instance involving hundreds of end users, each governed by intricate rules and access rights. You’ll learn how to:
- Deploy RAS security policies to restrict access to sensitive data
- Differentiate users connecting indirectly via APEX or directly via SQLcl or SQL Developer
- Properly enable RAS in APEX

Join us to explore whether RAS is the right solution to secure your business."

Speakers

Karen Cannell

CTHO, TH Technology

Monday March 24, 2025 3:15pm - 4:00pm MDT
Room 209

Development, Infrastructure (including database)

3:15pm MDT

Tapping Oracle AI Services Using A Visual Builder Front End

Monday March 24, 2025 3:15pm - 4:00pm MDT

Room 105

If you’ve thought that calling Oracle AI services from a custom application is difficult and complicated, come to this session to learn the real story. It turns out that the APIs offered by Oracle AI services make it easy to tap into their rich features. This session will showcase an example of a Visual Builder front end built to access the Oracle OCI AI Document Service and extract data from an image file. The steps demonstrated can be adapted to any front-end tool and used to leverage other Oracle AI services.

Speakers

Blaine Carter

Product Manager, Oracle

Blaine Carter is a product manager for Visual Builder and Visual Builder Studio. He enjoys discovering how things work and sharing that knowledge with others.

Peter Koletzke

Technical Director and Principal Instructor, Independent

Peter Koletzke is an Oracle ACE Director with over 39 years of experience in the IT industry. He has presented at more than 410 Oracle technology conferences worldwide and received over a dozen user group awards from ODTUG, NYOUG, UTOUG, and ECO/SEOUC. Koletzke is an Oracle Certified... Read More →

Monday March 24, 2025 3:15pm - 4:00pm MDT
Room 105

Development

UTOUG Training Days 2025

From $50.00