Hands-on Training  

The Hands-on Training Labs are back—with fresh new content for Kscope13. See below for class descriptions. Space is limited and is filled on a first-come, first-served basis. There is no additional fee to attend the labs, but you must be registered for Kscope13; so the sooner you register, the better chance you have of securing a seat at the lab(s) you want to attend. You may register for up to three labs. Don’t delay—the labs fill up quickly each year.

If a lab that you want to attend is full, you will be able to wait outside the classroom onsite for last minute openings.

Already registered?
Here are some helpful instructions on how to sign up for hands-on training sessions. Registrations for hands on training are first-come, first-served and space is limited.

All classes require that you bring your own computer.


Application Express Hands-on Training

Tablet + APEX
Chris Ostrowski, Avout
Session 10: Tuesday, 3:30 – 4:30 PM
End-users are increasingly demanding mobile access to corporate applications. New languages, development tools, skill sets, and determining platforms to support can make the entry into mobile application development difficult for organizations. A new technology makes decisions about mobile development much easier: JQuery Mobile. Oracle APEX integrates easily with JQuery Mobile. This combination can be used to create mobile applications that are supported on a wide range of mobile devices relatively simple. This presentation will walk attendees through the steps of building a mobile application using Oracle Application Express. Attendees are encouraged to bring an iPad (or other mobile device) to actively participate and see the final results of their work.

Oracle Application Express Hands-on Labs
David Peake, Oracle Corporation
Session 11: Wednesday, 8:30 – 9:30 AM
Session 12: Wednesday, 9:45 – 10:45 AM

Rather than forcing you to choose just one lab session to attend, the Oracle Application Express Development Team is conducting an al la carte hands-on-lab session in which you get to choose the labs you're interested in. You have over two hours of sessions from which to choose a wide variety of different labs on Application Express.

Back to Top

.NET Hands-on Training

Hands-on Training: Building .NET Applications with Oracle

Alex Keh, Oracle Corporation
Session 3: Monday, 11:30 AM – 12:30 PM
In this session, try the latest features of Oracle Data Provider for .NET (ODP.NET) and Oracle Database’s tight integration with Visual Studio. Step-by-step labs include several topics:

- LINQ, Entity Framework, WCF Data Services, and Open Data Protocol (OData)
- Fully managed ODP.NET
- The integrated PL/SQL debugger in Visual Studio
- ASP.NET web application development
- Using Oracle Performance Analyzer and Oracle Developer Tools for Visual Studio’s SQL Tuning Advisor feature in Visual Studio
- ODP.NET best practices for performance
- Using ODP.NET with Oracle TimesTen In-Memory Database
- Many others

Pick whichever topic interests you—work at your own pace. Lessons cover all experience levels, for attendees new to .NET and Oracle, as well as experienced users.

Back to Top

The Database and Developer's Toolkit Hands-on Training

How to Prevent Suboptimal Execution Plans
Maria Colgan, Oracle Corporation
Session 14: Wednesday, 1:45 – 2:45 PM
This session shows the process of analyzing and resolving the most common SQL execution performance problems including, poor cardinality estimations, bind peeking issues, selecting the wrong access method, and more. You will learn how to identify and quickly resolve these issues and develop a toolkit of queries and techniques to determine the root cause of any plan regression.

SQL Tuning using SQL Developer
Jeff Smith, Oracle Corporation
Session 6: Tuesday, 8:30 – 9:30 AM
SQL Developer is used by millions of people and this lab will teach how to use some often missed features which help tune SQL statements. This includes using the SQL Tuning advisor, how to use various optimizer access path, and other features.

Labs include:

- Tune Your SQL with the SQL Tuning Advisor
- Learn about Optimizer Access Paths Using Oracle SQL Developer
- Working with Tuning Utilities in Oracle SQL Developer


Developing REST for On-premise or in the Cloud
Rick Greenwald, Oracle Corporation
Session 13: Wednesday, 11:15 AM – 12:15 PM
This hands-on lab will teach the new Oracle APEX Listener and Oracle Apex 4.2 RESTful services. REST can be accessed from any client, any language making database applications more accessible than ever. The new RESTful services make this easier than ever compared to many other options.

Labs Include:
- Learn how to write REST services with the Apex Listener

Back to Top

ADF and Fusion Dev. Hands-on Training

Building Your First On-device Mobile Application with Oracle ADF Mobile
Joe Huang, Oracle Corporation
Session 1a: Monday, 8:30 – 10:15 AM
Learn how to develop iOS and Android applications with Oracle ADF Mobile. No prior ADF experience required. Learn how Oracle ADF Mobile simplifies cross device mobile development with declarative development approach. See how to present data and interact with device features such as camera and SMS in this hands-on lab.

Web-based Dashboards and Data Visualization Made Simple
Shay Shmeltzer,Oracle Corporation
Session 8: Tuesday, 11:15 AM – 12:15 PM
Need to display data in meaningful ways? Looking to impress management with beautiful data visualizations? Come and learn how the Oracle ADF Data Visualization components can help you achieve an impressive web dashboard quickly. Create interactive charts, maps, gauges, and more.

Complete Oracle ADF Application in 60 Minutes
Lynn Munsinger,Oracle Corporation
Session 4a: Monday, 1:45 – 3:30 PM
Never tried Oracle ADF development before? Still think ADF is hard to develop with? Come and experience the Oracle ADF development on your own machine. See how far you can get building rich web-based applications with the latest version of Oracle ADF and without the need for low level coding. In the process you'll get familiar with the various layers and technologies used in Oracle ADF.

Back to Top

Business Intelligence Hands-on Training

Oracle BI Analysis and Dashboards 11g– Basic
Nancy Hamilton, KPI Partners
HOT1: Monday, 8:30 – 11:15 AM
In this hands-on lab, participants will be introduced to the OBIEE 11g interface and learn how to create, view, and modify basic analyses. Delegates will learn how to filter their results and how to add custom views such as charts and pivot tables to their report layout. Participants will build an interactive dashboard with prompts to filter dashboard data in this session. Attendees will also discover how to work with hierarchical columns, a new feature in 11g. No prior knowledge of OBIEE is required.

Oracle BI Analysis and Dashboards 11g– Advanced
Nancy Hamilton, KPI Partners
HOT2: Monday, 1:45 – 4:15 PM
This hands-on session is intended for delegates with some prior knowledge of OBIEE. Participants will discover how to work with the Map Viewer feature of 11g and learn advanced filtering and prompting techniques, including filters based on a previous analysis, prompt defaults and constraints, different types of user input and slider prompts. New query features available in OBIEE 11g will be covered, such as selection steps and custom groups. We will also learn how to create an analysis from multiple subject areas and how to combine analyses using set operations.

Back to Top

Essbase Hands-on Training

Working with the New Workflow
Rudy Zucca, 123OLAP
HOT3: Tuesday, 10:45 AM – 12:15 PM
Build out Workflow from scratch

- Setting up Workflow. Hierarchies and assigning to planning units
- Workflow from end user perspective
- Setting up Workflow across multiple dimensions
- Validation rules and workflow
- Administration tips for Workflow Build out Workflow from scratch
- Setting up Workflow. Hierarchies and assigning to planning units
- Workflow from end user perspective
- Setting up Workflow across multiple dimensions
- Validation rules and Workflow
- Administration tips for Workflow

Essbase Studio for Beginners
Michael Nader,Bluestone
HOT4: Tuesday, 2:00 – 4:30 PM
Join us for some Essbase Studio fun as we walk you through the basics and some intermediate concepts of the latest version of the Essbase Studio.  Learn why Studio is the best way to create your Essbase applications and why its time to put EIS to bed. During the lab you will deploy an Essbase cube built from a relational source, learn how to update its properties and define drill-through reports to relational tables.

Planning Form Design Tips and Tricks
Rudy Zucca, 123OLAP
HOT5: Wednesday, 8:30 – 11:15 AM
Level – Intermediate. Create forms exploring various Tips and Tricks

- Substitution variables for making forms dynamic adjust months/years represented
- Rolling forecasts
- Dynamic variables
- Business rules to spread inputs based on user selected options – 445, even, historically based
- Using validation rules and formulas
- Composite forms

Intro to Calc Manager for HFM
Eric Erikson, 123OLAP
HOT6: Wednesday, 1:45 – 4:15 PM

In this hands-on session, you will learn how to use Calculation Manager with HFM. You will also learn how to navigate the software and build common HFM rules, including how to use variables, objects, and rulesets. Once built rules will be deployed to HFM and backed up. Lastly, converting from Classic script to Calculation Manager will be covered.


MDX Beyond Basics: Putting MDX to Work
Ron Moore, MTG
HOT7: Thursday, 8:30 AM – 12:00 PM
So you’ve learned the basics of MDX and you are ready to take the next step. What are the next challenges as you begin to put MDX to use in real projects?

In this hands-on lab we will cover practical application of intermediate to advanced functions, calculation order and optimization using real world examples of some of the most frequently used calculations such as:

- Intermediate to advanced ratio analysis
- Rolling calculations
- User defined members and sets
- Complex period-to-period comparisons
- Balance forward calculations
- Analytical functions

We will make use of member formulas and queries. We will also make use of Smart View’s Smart Query feature to illustrate how MDX can be used in end user reporting applications. We will also address some tricky calculation order issues and demonstrate optimization techniques.

Back to Top

Find us on Facebook
Follow Us