UTOUG Training Days 2025: Full Schedule

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

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

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

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

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

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

9:15am MDT

A Picture is Worth 1000 Words: Master Handling Images in APEX

Tuesday March 25, 2025 9:15am - 10:00am MDT

Room 105

A picture is worth a thousand words, but how can developers effectively manage images in APEX? With so many images come just as many questions: How do you load them? Where should they be stored? What are the best practices for displaying, downloading, editing, and updating images within APEX?

This session demystifies image handling in APEX by exploring a variety of recommended approaches—both declarative and code-based—for uploading, resizing, storing, and displaying images across different use cases, including APEX forms, various report types, and other components.

Attendees will gain a comprehensive understanding of common methods for incorporating images into APEX applications, along with practical insights and the confidence to seamlessly integrate images into their own projects.

Speakers

Karen Cannell

CTHO, TH Technology

Tuesday March 25, 2025 9:15am - 10:00am MDT
Room 105

Development

10:15am MDT

Expanding Your Javascript Reach Within Interactive Grids

Tuesday March 25, 2025 10:15am - 11:00am MDT

Room 105

To fully harness the potential of working with Interactive Grids in APEX, incorporating key JavaScript objects into your development is essential. This presentation will feature coding examples to enhance Interactive Grid functionality and elevate your JavaScript skills. Examples will range from novice to intermediate levels.

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.

Tuesday March 25, 2025 10:15am - 11:00am MDT
Room 105

Development

UTOUG Training Days 2025

From $50.00