Sponsored by


The Hands-On Training Labs are back – with fresh new content for Kscope17. These labs are BYOL – Bring Your Own Laptop – and are included free of charge with your conference registration. Classes are limited to 48 people and will be filled on a first-come, first-served basis; there is no advance sign-up required.


See below for class descriptions:

Data Visualization and Advanced Analytics
Essbase Cloud 
Financial Consolidation & Close Cloud
Enterprise Planning & Budgeting Cloud





Building a Basic Demo Application using Oracle Application Express
Monday, June 26, 2020 4:45 PM - 5:45 PM 
Jason Straub, Oracle Corporation and David Peake, Oracle Corporation

This one session is designed to take you through building a comprehensive application using Application Express. It is designed for people with no prior knowledge or very little experience developing with Application Express. You will learn how to develop a large number of different application components and walk out with the confidence and understanding of how to start building your own applications using Oracle Application Express.


  • Download and Install Oracle Virtual Box (http://www.oracle.com/technetwork/server-storage/virtualbox/downloads/index.html)
  • Download the latest Database App Development VM (http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html)
    {Note: This file is 7.7 GB so may take significant time based on the network. Trying to download from the JW Marriott will probably not work, so it strongly recommended you download the VM before leaving for the conference}
  • Import the VM into VirtualBox on your machine.
  • Update the VM Settings to maximize the System > Base Memory and Processor(s).
  • Start the VM.



Transitioning to Oracle Application Express 5 Universal Theme
Tuesday, June 27, 2020 2:00 PM - 3:00 PM 
Shakeeb Rahman, Oracle Corporation

Oracle Application Express 5 introduces many new features that enable you to quickly build modern and beautiful HTML5 applications. The new Universal Theme implements current design trends and utilizing the new declarative template options, and puts powerful CSS3 techniques at your fingertips. In this session, you will walk through transitioning your existing application to the new Universal Theme. Using some of the packaged apps included with Oracle Application Express 4.2 as examples, we’ll demonstrate step-by-step how to transition these apps to Oracle Application Express 5.


Creating Mobile Applications using Application Express 5
Wednesday, June 28, 2017 11:15 AM - 12:15 AM
Marc Sewtz, Oracle Corporation

Learn how you can declaratively build a compelling mobile application that uses some of the latest HTML 5 capabilities with Application Express. No hand crafting or in-depth knowledge of JavaScript or AJAX is required. Instead bring your SQL knowledge and discover how quickly you can build Web-based mobile applications using the Oracle Application Express declarative framework. 


Wednesday, June 28, 2020 3:00 PM - 5:15 PM
Anton Nielsen, C2 Consulting, Inc.

Oracle REST Data Service (ORDS), Oracle Application Express (APEX), and Oracle JavaScript Extension Toolkit (JET) have disparate, sometimes overlapping, functionality. This session will review these products and focus on how they compliment the Internet of Things. Hands-on participants will build an IoT device that communicates with an Oracle Database via ORDS. Device data will be displayed via JET components and the device will be controlled by an APEX application. Participants will gain hands-on experience in ORDS, APEX, JET, and IoT hardware.





PDB Me, ASAP! Oracle Database 12cR2 Multitenant Workshop
Monday, June 26, 2020 - 10:30 AM - 12:45 PM
Charles Kim, Viscosity North America

Oracle Database 12cR2 has dramatically revamped the range of Multitenant features, including faster PDB cloning with virtually no downtime, tighter resource control at the PDB level, ILM Automatic Data Optimization (ADO) policies for PDBs using Heat Maps, and even FLASHBACK recovery for individual PDBs. This 2-hour workshop explores the latest features of 12cR2 Multitenant and provides attendees with practical, hands-on experience as well as numerous code examples that they can immediately leverage when deploying, upgrading to, and migrating to CDBs and PDBs.


Oracle Dev Gym PL/SQL Workout: Oracle Database 12c
Monday, June 26, 2020 - 2:00 PM - 4:15 PM
Steven Feuerstein, Oracle Corporation

The best way to learn is to actively engage/exercise with the technology. In this session, attendees will participate in an Oracle Dev Gym workout: a series of multiple-choice quizzes that test your knowledge of PL/SQL features in Oracle Database 12c Releases 1 and 2. Steven will then review each quiz and give out prizes for best performance. It'll be a fun and different way to learn about PL/SQL!


Building an Oracle Database Web Application with Oracle JET and ORDS
Tuesday June 27, 2020 - 8:30 AM - 9:30 AM
Jeff Smith and Ashley Chen, Oracle Corporation

Participants will learn how to develop and deploy a RESTful Service using Oracle SQL Developer, Oracle REST Data Services, and Oracle Database. They will then show how to connect these services as data sources to a few different Oracle JET Visualization components to quickly build rich HTML5 applications using our free and open source JavaScript framework.

Prerequisite: Participants need to bring their laptop with our Oracle Developer Days VM already installed. The VM is available on June 12th for download. Please review the instructions on How To Setup the VM.


Advanced SQL Topics: Analytic Functions
Tuesday, June 27, 2020 - 11:15 AM - 12:15 PM
Kim Berg Hansen, Trivadis Danmark A/S

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 started using 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 yourself 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 profitably can use analytic functions in your work.
Prerequisites for attendees:
- You must bring your laptop - connected to the internet (wi-fi or otherwise)
- You must have an Oracle Single-Sign-On Account, as the lab will be using http://livesql.oracle.com
(You'll probably already have such an account for OTN or MOS or other Oracle site, but if not, then it's free and you can create the account on-site, but you'll have more time for the lab if you have the account ready ahead of time)


Feelin' Groovy – Scripting with SQLgr Hands on Lab
Tuesday, June 27, 2020 3:30 PM - 5:45 PM
David Schleis, Insum Solutions

SQL Developer Data Modeler (SDDM) and SQLcl both provide the ability to enhance their power through scripting. While the default scripting language is JavaScript, fortunately Groovy can also be used. Groovy is an incredibly powerful and versatile scripting language already a part of a number of Oracle tools. Groovy is easier to learn than JavaScript and allows you to do more with less code. 

This presentation is an introduction to the Groovy language and the SQLgr libraries. Focus will be placed on Groovy features specifically in regards to their use in the scripting of SQLcl and SDDM. Knowledge of these features, along with the SQLgr libraries, will allow attendees to begin building their own scripts immediately when then they get back to work.

Before you come, check out this blog post about installing the VM: http://www.thatjeffsmith.com/archive/2014/02/introducing-the-otn-developer-day-database-12c-virtualbox-image/


Hands-On Training: Using the Cloud (or Oracle Virtual Box) to Build a DBA Practice Environment
Wednesday, June 28, 2020 8:30 AM - 10:45 AM
Richard Soule, C2 Consulting, Inc.

For those who really want to learn the how and why of building an Oracle Database system from scratch, this is your session! Bring your own laptop, or use one of our hosted servers and we’ll walk through the complete installation and configuration of an Oracle Linux desktop, Oracle Grid Infrastructure with Oracle Restart and ASM including ACFS, Oracle Database 12c Multitenant, Oracle APEX, SQL/Developer and SQLcl, and more. Best practices from building databases for real world deployments as well as from teaching Oracle Database Certification classes will be included throughout the session.


Advanced SQL Topics: Row Pattern Matching
Wednesday, June 28, 2020 1:45 PM - 2:45 PM
Kim Berg Hansen, Trivadis Danmark A/S

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, so this hands-on-lab lets you try out yourself 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 bring your laptop - connected to the internet (wi-fi or otherwise)
- You must have an Oracle Single-Sign-On Account, as the lab will be using http://livesql.oracle.com
(You'll probably already have such an account for OTN or MOS or other Oracle site, but if not, then it's free and you can create the account on-site, but you'll have more time for the lab if you have the account ready ahead of time)





Back to top



Data Visualization and Advanced Analytics:


Storyboarding with Oracle Data Visualization
Tuesday, June 27, 2020 11:15 AM - 12:45 PM
and 3:45 PM - 5:15 PM
Antony Heljula, Peak Indicators

This hands-on-lab will introduce you to Oracle Data Visualization, demonstrating how quick and easy it is to build a Management Reporting pack (the case study won the Oracle EMEA Data Viz Contest 2016). Attendees will be led through the process of producing a storyboard from scratch while using a range of features including mashups, maps, trend lines, outliers, custom calcs, image overlays, and commentary.


Oracle DV for the Finance Analyst
Wednesday, June 28, 2020 9:45 AM - 11:15 AM
and  3:30 PM - 5:00 PM
Kevin McGinley, Red Pill Analytics and Tim German, Qubix

This hands-on-lab will build upon the session given by Kevin McGinley and Tim German by allowing attendees to perform some of the demonstrations shown in the session given earlier in the week. Attendees will get to use Oracle Data Visualization against Essbase cubes, Excel spreadsheets, and even learn how to create their own mashups of data to be used for their own analytical purposes. They'll also learn how building certain types of visualizations and using features like narrative mode can help deepen their analysis and make the communication of their findings easier. Prior attendance of the session is not required to attend the hands-on-lab.






Essbase Cloud:


Hands-On with Essbase Cloud
Monday, June 26, 2020 10:30 AM - 1:00 PM
and 2:00 PM - 4:30 PM
Rudy Zucca, 123OLAP

Essbase Cloud (part of the Oracle Analytic Cloud Service) is the very latest iteration of Essbase. This longer-format lab will provide a hands-on walk through to see what's changed, what new capabilities the cloud version offers, and how to get started with it. Microsoft Excel with Smart View is a prerequisite for some portions of this lab.




Financial Consolidation & Close Cloud:



Hands-On with Financial Consolidation and Close Cloud
Tuesday, June 27, 2020 11:15 AM - 12:45 PM
and 3:30 PM - 5:05 PM 
Eric Erikson, 123OLAP

Financial Consolidation and Close Cloud Service, aka FCCS (yes, there's one C short) is Oracle's cloud consolidation solution. Join Eric Erikson of 123OLAP for a hands-on product tour.




Enterprise Planning & Budgeting Cloud:


PBCS Beyond The Basics - New Features, Tips, and Advanced Functionality
Monday, June 26, 2020  2:00 PM - 3:30 PM
Stephen Bowden, Peloton Group

Cloud-based applications carry an expectation of being modern, agile, and dynamic.  New features appear on a regular cadence.  This session will explore those new and unique capabilities in Oracle Planning Budgeting Cloud, as well as the latest techniques used by leading organizations to fully realize the value of the cloud.  From dashboarding and navigation flows to cloud single sign-on, batch automation, and more - Peloton cloud experts will show you how to get the most from your Planning Budgeting Cloud investment.

·        Smart View for Office (requires a free Oracle account) http://www.oracle.com/technetwork/middleware/smart-view-for-office/overview/index.html

·        Current version of either Chrome or Firefox browser


Hands-On with Enterprise Planning and Budgeting Cloud Service
Wednesday, June 28, 2020  9:45 AM - 11:15 AM
and 3:00 PM - 4:30 PM
Bernard Ash, 123OLAP

EPBCS extends Oracle's Planning and Budgeting Cloud Service with pre-built frameworks for several different Planning application requirements. Come to this lab to explore EPBCS for yourself.