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