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.


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. RivasOracle 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:

  1. 'Auto insights' - automatically generated visualizations, based on ML recommendations to get you started on telling the story of your data
  2. 'Explain' - uncovers hidden relationships in your data
  3. 'Auto ML' - makes it easy for you to create your own machine learning models).

Presenter - Mike Durran, Oracle Corporation


9:00 - 10:30 a.m. | Aurora D

Deep Dive | APEX Lightning Talks

The APEX Lightning Talks are back! After a week of inspiring content, finish the week with this fun and informative session. Some of the best, well-known speakers and luminaries in the APEX community will give you insights into Oracle APEX. Speakers and topics to be announced.

Presenter: aceicon_0000_Oracle_ACE-Program_Spade_Associate_rgb.png 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 | Building an Online Shopping Cart App in 60 mins!

Learn how to quickly and easily build a shopping cart app with Oracle APEX. Using this app, administrators can manage products, customers, and stores. On the user side, customers can review and add products to the cart and eventually proceed to checkout.

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 -  aceicon_0001_Oracle_ACE-Program_Spade_Pro_rgb.png 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 - aceicon_0002_Layer-1.png 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 - aceicon_0002_Layer-1.png Ruben Rodriguez, CGI, Inc.


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 - Al MarcianteOracle 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 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 | Hands-on with Redwood: Build Applications Using the Oracle Application Platform

Bring your laptop and get hands-on building Redwood user experiences! In a series of comprehensive, realistic step-by-step tutorials, you'll dive into creating applications using Visual Builder and the Oracle Applications Platform. We'll also share tips and tricks so that you are well-equipped to get started with your own development projects.

Presenter - aceicon_0002_Layer-1.png Peter Koletzke, Consultant

Co-Presenter - Blaine Carter, Oracle Corporation