Analytics | APEX | Database Engineering & Development | Emerging Technologies
EPM | Extending Oracle Cloud Applications
Hands-On Training Sponsored by,
The Hands-On Training Labs are back—with fresh new content for ODTUG Kscope23. These labs are BYOL—Bring Your Own Laptop—and are included free of charge with your conference registration. Classes are limited to 40 people and will be filled on a first-come, first-served basis; there is no advance sign-up required.
Analytics
9:00 - 10:30 a.m. | Valley 3
Hands-On Lab | Self-Service Data Preparation
This Hands-on Lab will illustrate how organizations worldwide use Oracle Analytics to manage their data and uncover value across the entire data lifecycle: creating and joining data from multiple sources, preparing data with ML/NLP recommendation-driven data transformation and enrichment, securely collaborating and sharing data across teams, and leveraging embedded augmented analytics and machine learning capabilities to deliver the fastest time to insight across all of your data. You'll learn how to create a connection to an Oracle ADW database and create, transform, and enrich a dataset for analysis by joining data from multiple database tables, and quickly get started analyzing your data with AI driven insights.
Your instructor will provide you the OAC and Oracle ADW Database Environments, login and connection credentials, and guidance throughout the exercises in the Oracle Analytics Cloud.
Presenter - Luis E. Rivas, Oracle Corporation
10:45 a.m. - 12:15 p.m. | Valley 3
Hands-On Training | Data Insights Made Easy with Oracle Analytics Machine Learning
Attend this hands on lab to learn how Oracle Analytics can make it easy for you to gain insights from your data using out of the box ML based functionality. This lab will cover the following areas:
- 'Auto insights' - automatically generated visualizations, based on ML recommendations to get you started on telling the story of your data
- 'Explain' - uncovers hidden relationships in your data
- 'Auto ML' - makes it easy for you to create your own machine learning models).
Presenter - Mike Durran, Oracle Corporation
APEX
9:00 - 10:30 a.m. | Aurora D
Deep Dive | APEX Lightning Talks
Join us for an inspiring session of APEX Lightning Talks, where we explore the world of extending Oracle APEX by integrating innovative tools and harnessing emerging technology! Learn from industry experts as they share insights, tips, and best practices on how to elevate your APEX applications to new heights through powerful extensions, cutting-edge advancements, and seamless integrations.
Streamlining APEX Application Testing with LCT
Discover a low-code interface to effortlessly create tests for your Oracle APEX Apps.
Kai Donato, MT-AG
Intelligent Interactions
Integrating APEX and ChatGPT for Smarter Applications.
Michelle Skamene, Insum
Unleashing the Power of Template Components in APEX 23.1
Building and Sharing Reusable UI Components. Philip Hartenfeller, MT-AG
Amplifying Productivity with Innovative Plugins
Explore how five cutting-edge plugins can supercharge your Oracle APEX applications and enhance productivity.
Michal Lipinski, Pretius Low Code
Integration of Office documents in your APEX app
Don't let the boundaries of applications limit your productivity. Seamlessly integrate and interact with Office documents within your APEX applications.
Dimitri Gielis, United Codes
Beyond Web Apps: Turn Your APEX App into a PWA
Discover how to transform your Oracle APEX application into a Progressive Web App (PWA), leveraging the power of push notifications for enhanced user engagement.
Vincent Morneau, Oracle Corporation
Moderator: 
Michelle Skamene, Insum
10:45 a.m. - 12:15 p.m. | Summit 7
Hands-On Lab | Building a PWA Application
This hands-on lab will provide a comprehensive overview of building Progressive Web Apps (PWAs) with Oracle APEX. We will cover the fundamentals of PWAs and how they can be used to create highly engaging, feature-rich web apps. We will discuss the advantages of using PWAs, such as improved user experience, faster loading times, and the possibility of deeply integrating with the operating system. We will then explore how to create and deploy PWAs using Oracle APEX. This will include a review of the application development process and a demonstration of how to create a PWA using Oracle APEX. We will also go over the various components of a PWA, such as the creation of an icon, file caching, the installability attributes, an engaging persistent authentication setting, and push notifications. At the end of the lab, you will have the knowledge and tools needed to develop and deploy PWAs with Oracle APEX.
Presenter - Vincent Morneau, Oracle Corporation
Co-presenter - Shakeeb Rahman, Oracle Corporation
10:45 a.m. - 12:15 p.m. | Summit 6
Hands-On Lab | Build a Social Media App using APEX
In this workshop, you are guided step-by-step to create a Social Media app where users can upload images, like other users' posts, and delete the uploaded images. While building this application, the developer learns to create pages, regions, customize the UI and create dynamic actions. Optionally, the developers also learn to get user device location by implementing Map region.
Presenter - Neil Fernandez, Oracle Corporation
Database Engineering & Development
9:00 - 10:30 a.m. | Summit 1
Deep Dive | Tutorial: Intro to Data Modelling
Data modeling is not a forgotten ancient art like cuneiform writing! Even with the influx of non-relational data storage platforms, the need to clearly articulate what you are trying to store to a development team is as important as ever. Even though one JSON or XML document is much simpler to pass around, a group of tables linked together with appropriate foreign keys will tell “the story” significantly better. Obviously, there are cases when semi-structured data forms are preferred, but they are not silver bullets. Relational data models still (and will) play a major role in contemporary information technology.
This tutorial is an aggregation of two decades of experience in building large database-centric solutions from the ground up. In the past 20 years, many data modeling decisions were made – and some of them were better than the others. As a result, there were many lessons learned: what to do, what not to do, and what to do under very specific circumstances, etc. Attend this tutorial to benefit from years of practical experience.
Presenter - 
Michael Rosenblum, Dulcian
Emerging Technologies
9:00 - 10:30 a.m. | Summit 3
Deep Dive | New Channels to Improve Communication between Citizens and Public Services
Building chatbots usually involves more than just building conversation flows. A city hall in Spain has built a complete platform in Oracle Cloud and extended the built-in functionality offered by Oracle Digital Assistant to satisfy their business requirements while offering their citizens an improved support service that has been continuously growing over the last few years.
Attend this session to learn how the city hall successfully planned and executed a complete citizen support service with Oracle Digital Assistant as the main building block and other OCI services to enhance the solution.
Presenter - 
Ruben Rodriguez, CGI, Inc.
10:45 a.m. - 12:15 p.m. | Summit 3
Hands-On Lab | Visually Building Chatbots with Oracle Digital Assistant
In this session you will learn what are the most important parts, or terms to be aware of within Oracle Digital Assistant, how to visually implement skills, how to integrate with any external system using its own node.js container, and how to expose them via different channels. I will demonstrate how to create a weather chatbot integrated with a free weather API and expose it via a web widget.
Presenter - Ruben Rodriguez, CGI, Inc.
EPM
9:00 - 10:30 a.m. | Aurora Ballroom C
Exam Kram | Strategic EPM: Oracle Planning Exam
Are you looking to get certified in Oracle Planning but feeling apprehensive about the test? Join Oracle's Product Managers as they walk through what you should expect and prepare for prior to taking the exam. Attendees may even walk away with an Oracle Certification Exam Voucher!
Presenter - Mark Rinaldi, Oracle Corporation
9:00 - 10:30 a.m. | Summit 8
Hands-On Lab | EPM Lightning Rounds
Join us for EPM Lightning Rounds and share what you've been learning! Whether it's technical or non-technical, we want to hear about the topics that excite you. Each speaker will have 10 minutes to talk about the subject of their choosing. If you have never spoken at Kscope before and want to test it out, Come On!! We want to hear from you! Don't miss out on this great opportunity!
If you are interested in speaking, reach out to Sara Beth Good at SaraBeth@odtug.com and she will put you on the schedule!
10:45 a.m. - 12:15 p.m. | Aurora Ballroom C
Hands-On Lab | Kscope Family Feud
Are you looking for a fun and exciting way to engage with your new Kscope friends? Look no further than joining us for a game of Family Feud! Test your knowledge and compete with your loved ones in an entertaining game-show-style atmosphere. Bring your best answers and get ready to have a blast! Don't miss out on this great opportunity to connect with everyone!!
Extending Oracle Cloud Applications
9:00 - 10:30 a.m. | Summit 4
Hands-On Lab | Building Redwood Application Experiences with the Oracle Applications Platform
Bring your laptop with a Chrome browser, and get hands-on practice building Redwood user experiences! In a comprehensive, realistic step-by-step tutorial, you'll dive into creating an application extension application using Visual Builder and the Oracle Applications Platform. The techniques you will use in this lab can be used for creating extensions to your Oracle Cloud/Fusion applications as well as for your own custom-built applications.
Presenter - Peter Koletzke, Consultant
Co-Presenter - Blaine Carter, Oracle Corporation