The Hands-On Training Labs and Deep Dives are back—with fresh new content for the ODTUG Kscope21 Virtual Event. These labs and deep dives are included free of charge with your conference registration. Pre-registration is required as these classes have participant limits. Unfortunately, there are no waiting lists. Don’t miss out—make sure to add them to your registration today!

See below for the class descriptions:

Analytics

Application Express

Database

Emerging Technologies

Enterprise Planning

EPM Foundations & Reporting

Essbase

Financial Close

Modern App Development

Profitability


Analytics:

OAC: Self-Service Data Visualization Hands-On Lab (max. 30 participants)
Tuesday, June 22, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Analytics HOL Room
Monday, June 28, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Analytics HOL Room
Brendan Doyle and Mike Durran, Oracle Corporation

Join us for an Oracle Analytics Hands-On Lab (HOL)! This Analytics HOL will provide you with the necessary fundamentals to get started with Oracle Analytics Cloud (OAC) and you'll gain a deeper understanding of how to get the most out of your data!

You will learn to self-serve with your data by creating multiple data visualizations and mashing up different data sets. You'll build custom calculations in which you will be able to display the results in captivating map visualizations. Additionally, you'll start to become a data storyteller with the creative control of using freeform canvases, custom backgrounds, one-click statistical analyses, and natural language generation to accelerate your analysis and reporting needs much further!
All you'll need in order to participate in this Hands-On Lab is a stable internet connection, a modern web browser, and an eagerness to learn! Your instructor will provide you the OAC environment, login credentials, and guidance throughout the exercises in this Oracle Analytics Cloud lab!

OAC with ADW: Self-Service Data Prep and Data Flow HOL (max. 30 participants)
Wednesday, June 23, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Analytics HOL Room
Tuesday, June 29, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Analytics HOL Room
Brendan Doyle and Mike Durran, Oracle Corporation

Are you looking to supercharge analysis and streamline your data management with Oracle Analytics Cloud (OAC) connected to Autonomous Data Warehouse (ADW)?

This Hands-On Lab will illustrate how organizations worldwide rely on Oracle to manage their data and uncover value across the entire data lifecycle: creating and blending data, self-service data visualization and analysis, securely collaborating and sharing analysis 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 Autonomous Data Warehouse, build a Data Flow to curate a data set for analysis, and securely save it back to ADW for later use!

All you'll need in order to participate in this Hands-On Lab is a stable internet connection, a modern web browser, and an eagerness to learn! Your instructor will provide you the OAC and ADW environment, login and connection credentials, and guidance throughout the exercises in the Oracle Analytics Cloud and Autonomous Data Warehouse lab!


Application Express:

Oracle APEX Spreadsheet Hands-On Lab (max. 50 participants)
Wednesday, June 23, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | APEX HOL Room
Oracle presenter TBA

What you will learn:
- Build your first app through uploading a spreadsheet.
- Improve the search and report pages.
- Link pages.

While all of this sounds daunting, you will be amazed at how quickly you go from a spreadsheet to a fully featured, responsive web app.

Proof-of-Concept Hands-On Lab (max. 50 participants)
Monday, June 28, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | APEX HOL Room
Oracle presenter TBA

What you will learn:
- Define new tables and views.
- Create an application on the new data structures.
- Refine the application.

Who knew creating new database tables could be so easy? And then just as easily, build a great app on top of those tables.

Remote Data Source Hands-On Lab (max. 50 participants)
Wednesday, June 30, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | APEX HOL Room
Oracle presenter TBA

What you will learn:

- Define and populate a table from a REST endpoint.
- Create an application on the new data.
- Refine the application.

Learn how to manipulate data using simple SQL and charts to gain new insights.


Database:

Analytic Functions HOL (max. 30 participants)
Thursday, June 24, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Database HOL Room
 O-Ace-Director-Icon-rgb.png Kim Berg Hansen, Trivadis

When analytic functions appeared in the database in version 8, they were the best thing to happen to SQL since the keyword SELECT was invented. Analytic functions are indispensable in a lot of use cases for creating highly efficient queries, often enabling you to avoid slow procedural code. Once you have used analytic functions more than a couple of times, you'll develop the mindset for recognizing opportunities for utilizing them often in your daily work, making your applications highly efficient.

This Hands-On Lab will let you try out a series of examples demonstrating the powerful aspects of analytic function syntax and various use cases, giving you practical experience that'll help you know when you can profitably use analytic functions in your work.

Pre-requisites for attendees:

You must have an Oracle Single-Sign-On Account, as the lab will be using http://livesql.oracle.com
(You probably already have such an account for OTN, MOS, or another Oracle site, but if not, then it's free and you can create the account at the time of the conference. However, you'll have more time for the lab if you have the account ready ahead of time).

Pattern Matching HOL (max. 30 participants)
Friday, June 25, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Database HOL Room
 O-Ace-Director-Icon-rgb.png
Kim Berg Hansen, Trivadis

Often you need to work with how data interacts across rows, not just within a single row. Analytic functions can help a lot with this, but since version 12.1, row pattern matching has been an alternative that enables querying for patterns in the data in more complex ways than analytics can do—and at the same time in a simpler fashion as the syntax is very declarative. Once you are familiar with the syntax, you can use MATCH_RECOGNIZE for quite varied use cases, like searching patterns in stock ticker data, grouping sequences, bin fitting problems, and a lot more.

The syntax can be daunting at first glance, though with a lot of options. This Hands-On Lab lets you try out different ways of using the MATCH_RECOGNIZE clause, showing the syntax with various use cases, letting you come to grips with how the various parts of the syntax work and interact with each other.

Prerequisites for attendees:

You must have an Oracle Single Sign-On Account, as the lab will be using http://livesql.oracle.com
(You probably already have such an account for OTN, MOS, or another Oracle site, but if not, then it's free and you can create the account at the time of the conference. However, you'll have more time for the lab if you have the account ready ahead of time).

Using Graph Studio for New Insights (max. 30 participants)
Thursday, July 1, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Database HOL Room
Jayant Sharma and Albert Godfrind, Oracle Corporation

Explore the new Graph Studio feature of Oracle Autonomous Database and its power to find new insights in your data. Graph analytics enables you to find important entities, hidden relationships, anomalous patterns, tightly connected clusters, and more. In this lab, you will load and model data as a graph, use graph algorithms, query for graph patterns in your data, and visualize results in an integrated notebook. With Graph Studio you will get started with graphs in minutes.

Note: All you'll need in order to participate in this Hands-On Lab is a stable internet connection, a modern web browser, and an eagerness to learn! Your instructor will provide you the Oracle Autonomous Database environment (using LiveLabs platform on the cloud), along with login credentials, and guidance throughout the exercises in this Graph lab.


Emerging Technologies:

Building Microservices with Oracle Converged Database (max. 100 participants)
Friday, June 25, 2021 | 11:00 a.m. – 1:40 p.m. | Emerging Technologies Room
Thursday, July 1, 2021 |11:00 a.m. – 1:40 p.m. | Emerging Technologies Room
Sanjay Goil, Paul Parkinson, and Richard Exley, Oracle Corporation

Building upon Oracle's LiveLabs, this HOL will cover the following:

-Set up OCI, OKE, and ATP.

-Build and deploy microservices.

-Set up database connection secrets, tables, and AQ messaging.

-Data-centric microservices walkthrough with Helidon MP.

-Polygot microservices.

-Scaling the application.

-Create an APEX app to make sense of the data.


Enterprise Planning:

Groovy Scripting for Enterprise Planning Cloud (max. 25 participants)
Tuesday, June 22, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Ent Plan HOL Room
Wednesday, June 23, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Ent Plan HOL Room
Monday, June 28, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Ent Plan HOL Room
Chris McManus, Keyteach

Explore how Groovy rules, a multi-faceted language for the Java platform, can be written in Calculation Manager as an alternative to traditional business rules. Discover how Groovy can be used with Enterprise Planning Cloud to generate calc scripts dynamically at runtime, based on the context in which they are executed. Attendees will also explore the use of pure Groovy rules for performing data validation.


EPM Foundations:

Explore the REST APIs for Oracle EPM Cloud (max. 25 participants)
Thursday, June 24, 2021 |11:00 a.m.  – 1:40 p.m. | EPM Found/Reporting HOL Room
Wednesday, June 30, 2021 | 2:20 – 5:00 p.m. | EPM Found/Reporting HOL Room
Chris McManus, Keyteach


Discover how REST API functions allow clients to issue requests to and receive responses from a server using the HTTP protocol. Find out how to extend and automate the Oracle EPM Cloud using the available REST APIs, allowing the monitoring of applications and the execution of processes through simple URL-based requests.

Introducing Restricted Use DRM for Hyperion 11.2 (max. 25 participants)

Thursday, June 24, 2021 | 2:20 – 5:00 p.m. | EPM Found/Reporting HOL Room
Wednesday, June 30, 2021 | 11:00 a.m. – 1:40 p.m. | EPM Found/Reporting HOL Room
Simon Beesley, Keyteach


Not just a replacement for EPMA, “Restricted Use” DRM is available for all to use for FREE within a Hyperion EPM environment. Find out how organizations can synchronize master data between Oracle EPM on-premises applications—ideal for multi-product/multi-application or where a number of administrators maintain EPM metadata. Find out what is required for installation and discover more about the features, capabilities, and benefits of adopting this software.

An Introductory Overview of Narrative Reporting (max. 25 participants)
Friday, June 25, 2021 | 11:00 a.m. – 1:40 p.m. | EPM Found/Reporting HOL Room
Tuesday, June 29, 2021 | 2:20 – 5:00 p.m. | EPM Found/Reporting HOL Room
Caroline Robinson, Keyteach


Get an overview of how to define, author, review, and publish management and regulatory reports using a secure, auditable workflow. Discover the key configuration tasks and learn how to combine data and textual narrative content. Discover how reports can be grouped to produce executive briefing books and explore the use of report bursting to distribute report content securely.

Managing Enterprise Data with EDM (max. 25 participants)
Friday, June 25, 2021 | 2:20 – 5:00 p.m. | EPM Found/Reporting HOL Room

Tuesday, June 29, 2021 | 11:00 a.m. – 1:40 p.m. | EPM Found/Reporting HOL Room
Simon Beesley, Keyteach

Get an overview of the capabilities and understand the architecture of Oracle's Enterprise Data Management Cloud (EDMCS) and find out how to share and map enterprise data across applications. Discover the advantages of unified control of diverse data silos, crucial to the effective administration and synchronization of master data across the enterprise.


Essbase:

Get “Hands On” with Essbase 21c (max. 25 participants)
Friday, June 25, 2021 |11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Essbase HOL Room
Thursday, July 1, 2021 |11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Essbase HOL Room
Chris McManus, Keyteach

Get “hands on” with the latest Essbase platform, review the differences in features and functionality between Essbase 11g on premises and Essbase 21c. Discover the modern browser-based UI for management and administration, explore the new Cube Designer plugin for Smart View, and learn about new platform features such as connections/data sources, new security roles, dynamic filters, and more.


Financial Close:

Getting Started with Account Reconciliation Cloud (max. 25 participants)
Tuesday, June 22, 2021 | 11:00 a.m. – 1:40 p.m. | Financial Close HOL Room
Wednesday, June 23, 2021 | 2:20 – 5:00 p.m. | Financial Close HOL Room
Monday, June 28, 2021 | 11:00 a.m. – 1:40 p.m. | Financial Close HOL Room
Graeme Gibson, Keyteach

Discover how Account Reconciliation Cloud (AR) can streamline close processes and deliver insight about the real-time status of account reconciliations and transaction matching. Find out how reconciliation compliance is used to manage reconciliation processes and explore the automation of high-volume/labor-intensive transaction matching.

 

Understanding Calculations in Financial Consolidation and Close Cloud (max. 25 participants)
Tuesday, June 22, 2021 | 2:20 – 5:00 p.m. | Financial Close HOL Room
Wednesday, June 23, 2021 | 11:00 a.m. – 1:40 p.m. | Financial Close HOL Room
Monday, June 28, 2021 | 2:20 – 5:00 p.m. | Financial Close HOL Room
Simon Beesley, Keyteach

This session introduces techniques for manipulating calculations and writing custom business logic for Financial Consolidation and Close Cloud (FCC). Explore the concepts required for writing calculations in the new multi-dimensional environment for financial consolidation and gain insight into the relationship between built-in calculations and those over which there is full control.


Modern App Development:

Building Apps for Mobile Devices: The Easy Way (max. 30 participants)
Wednesday, June 23, 2021 | 11:00 a.m. – 1:40 p.m. | MAD HOL Room
Susan Duncan, Oracle Corporation

In this Hands-On Lab, build a mobile application and deploy it to your mobile device with Visual Builder. We’ll start from scratch, creating data objects and a mobile optimized UI experience that will allow us to interact with data. Then we’ll learn how to deploy the application as both a Progressive Web App (PWA) as well as a packaged app for android and iOS which you can publish to app stores. No prior experience needed.

 

Visual Builder Deep Dive: The End-to-End Development Experience (max. 30 participants)
Wednesday, June 23, 2021 | 2:20 – 5:00 p.m. | MAD HOL Room
Shay Shmeltzer, Oracle Corporation

In this demo-focused deep dive session, we’ll first introduce you to Visual Builder’s architecture, building blocks, and the development experience.

We’ll then expand to cover advanced features of the Visual Builder Studio environment, focusing on how they help teams manage development processes and software delivery. We’ll cover tracking issues, managing agile development sprints, versioning, branching and merging code, and automating continuous delivery of your app.

Get “Hands On” and Build Your First Digital Assistant (max. 30 participants)
Tuesday, June 29, 2021 | 11:00 a.m. – 1:00 p.m. | MAD HOL Room
Grant Ronald, Oracle Corporation

In this instructor-led session you are going to turbo charge your practical knowledge of conversational digital assistants by getting “hands on”. The session starts with an insight into the main building blocks of building chatbots, and then an end-to-end demo of how to build an AI-driven chatbot that understands natural language. You’ll then get access to an instance to build your own chatbot with step-by-step guidance and support from the Oracle Digital Assistant development team.

The Real-World Lessons of Building a Product Digital Assistant: From Conception, Going Live, and Learning to Be Smarter (max. 30 participants)
Tuesday, June 29, 2021 | 2:20 – 3:50 p.m. | MAD HOL Room
Grant Ronald, Oracle Corporation

There is a universe of difference between the emp/dept/“hello world” of conference demos and building production quality 24x7 software used by thousands of people. In this session we’ll introduce Artie, which is not only a production chatbot but is also a framework for other production digital assistants being developed inside Oracle.

We will discuss the conception of the idea of Artie, how the project was defined, architected, designed, and how the software was developed. We’ll also look at and demonstrate how we measured the success of Artie and how we improved language understand and user experience over time.

You’ll also get access to Artie to test and then ask any questions.


Profitability:

Discover the Capabilities of Profitability and Cost Management (max. 25 participants)
Thursday, June 24, 2021 |11:00 a.m. – 1:40 p.m. | Profitability HOL Room
Friday, June 25, 2021 | 2:20 – 5:00 p.m. |  Profitability HOL Room
Monday, June 28, 2021 | 11:00 a.m. – 1:40 p.m. | Profitability HOL Room 
Wednesday, June 30, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Profitability HOL Room
Simon Beesley, Keyteach

Discover the capabilities and the concepts required to design and create Oracle Profitability and Cost Management (PCM) applications. In this introductory hands-on session, attendees will get an overview of how to identify and exploit profitability through the development of advanced modelling and complex what-if scenarios and reporting.