UTOUG Training Days 2025: Full Schedule

arrow_back View All Dates

9:15am MDT

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

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

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

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 →

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

Development

9:15am MDT

Application Performance Tuning Forum

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

Room 209

Have you ever wished you could bring together four or five experts from different disciplines in one room to hear their top tips for application performance tuning and ask them questions? Since application performance depends on the collaboration of roles like DBA, developer, designer, and architect, you'd want to hear from representatives of each. You’d also want insights into techniques applicable to various technologies, as well as those specific to one technology.

You’ve found the right session to fulfill that wish. This session combines a series of lightning talks from well-known experts with a Q&A, where you can ask questions or share a tip you’ve found useful. Check out the panelists' biographies to get a sense of their expertise.

See you there!

Speakers

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 →

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

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

10:15am MDT

How to Get Rid of Materialized Views Using Hashing in ELT/ETL

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

Room 209

Materialized views are a robust Oracle Database feature, but they have some drawbacks. When we refresh the data and an incremental refresh (force refresh) doesn’t work, we need to fully reload the materialized view. While it’s refreshing, the data is inaccessible to business users. If it fails, we must rerun it, leaving the data inaccessible. Sometimes, the process simply takes longer than expected.

What if we need to refresh the data several times a day? What if the materialized view sources data from OLTP tables, and we can’t create additional load on the OLTP system?

Two main aspects must be considered: the source of the materialized view and the data refresh method.
We assume a staging area exists where all necessary tables are replicated, providing near real-time data.
We plan to demonstrate how a materialized view can be refactored into a combination of a view, table, and procedure (or mapping). By using a hash function, we can update data incrementally instead of performing a full load. This approach makes the process faster and ensures business users have continuous access to the data. It also enables more frequent refreshes, even approaching real-time updates.

Additionally, if this materialized view serves as a source for third-party systems, it can include attributes for further change data capture (CDC).

This approach reduces data outage time, protects against incidents, and enables close-to-real-time data for end users.

Speakers

Konstantin Zhernevskiy

Senior DWH Architect, Data Intensity

Konstantin is a senior DWH architect at Data Intensity with over 20 years of experience in the Oracle technology stack. For the past 10 years, he has focused on delivering data marts, data warehouses, and analytical reporting applications. His expertise includes AI, machine learning... Read More →

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

Development, Infrastructure (including database)

11:15am MDT

Oracle Generative AI & Vector Database with Retrieval Augmented Generation (RAG)

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

Room 209

Learn how to leverage AI and machine learning (ML) by understanding their potential in your applications and products. This session will cover algorithms and their uses with Oracle’s Vector Database and Vector Search, along with Large Language Models (LLMs) like Cohere, Llama, and ChatGPT. We’ll explore how these models can help drive success through Oracle’s products and teach you how to integrate AI/ML into your company’s tech plan for innovation or security. This session is accessible for non-experts.

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 →

Tuesday March 25, 2025 11:15am - 12:00pm MDT
Room 209

Development, Data (not database)

1:30pm MDT

SQL Puzzles

Tuesday March 25, 2025 1:30pm - 2:15pm MDT

Room 209

Join me on a journey to explore the SQL challenges I’ve faced over the years. We’ll walk through real-world technical problems and write SQL together to solve them. Takeaways will include:
- A deeper understanding of core SQL concepts
- Improved query optimization skills
- Creative problem-solving (training your brain to approach data problems from different angles)

Speakers

Brandon Mason

Manager of Database Administration, America First Credit Union

Like many DBAs, Brandon graduated in human resource management and started his career in an HR office. While that work didn’t enhance his technical skills, it helped him develop the ability to work effectively with the people who manage systems. Brandon has been an Oracle DBA for... Read More →

Tuesday March 25, 2025 1:30pm - 2:15pm MDT
Room 209

Development, Intrastructure (including database)

UTOUG Training Days 2025

From $50.00