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-serve basis; there is no advance signup 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

Jason Straub, Oracle Corporation and Patrick Wolf, Oracle Corporation

This one double” session (two-plus hours) 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.


Transitioning to Oracle Application Express 5 Universal Theme 

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

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. 





PDB Me, ASAP! Oracle Database 12cR2 Multitenant Workshop

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 Code Gym PL/SQL Workout: Oracle Database 12c


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!




Feelin' Groovy – Scripting with SQLgr Hands on Lab


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.




Building an Oracle Database Web Application with Oracle JET and ORDS


Jeff Smith, 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.

The lab will be for 60 minutes, and participants are encouraged to bring their laptop with our Oracle Developer Day VM already installed.




Advanced SQL Topics: Analytic Functions


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.




Advanced SQL Topics: Row Pattern Matching


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.


Back to top



Data Visualization and Advanced Analytics:




Oracle DV for the Finance Analyst


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.


Storyboarding with Oracle Data Visualization


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.




Essbase Cloud:


Hands-On with Essbase Cloud

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


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:




Hands-On with Enterprise Planning and Budgeting Cloud Service 


Bernard Ash, 123OLAP


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