OTN Labs – OTN Labs are four-hour sessions on a specific topic offered from 1:00 – 5:00 p.m. on Monday, February 11. There is no cost to attend either of these workshops. Registration is limited to 80 participants per room.

After you scan the QR Code, install the free Guidebook App. Once installed select Download Guides and type RMOUG.

University Sessions:

Attending Training Days: $112.50
Not Attending Training Days: $125

Big Data Architecture Workshop

Jean-Pierre Dijcks, Oracle Corporation

The goal of this big data is as an architecture topic as well as a lot of buzz. The goal of this session is to share Oracle’s Information Management Reference Architecture for big data. This session will whiteboard an end-to-end architecture discussing the components of a big data solution and how data actually flows between all the components all based on experience with customer implementations and typical scenarios we see day-to-day. At the end of this session you will understand Oracle’s big data reference architecture and have the tools to implement this architecture at your company in a step-by-step manner.

Please make sure you can work with these tables from the TOAD tool on your PC BEFORE you show up for this training session. There simply isn’t time to fix any problems. The course is four hours and we have four hours of material to cover.

Toad for Oracle Introduction Training Course – This hands-on course is aimed at the Oracle professional who wishes to increase their individual or their group’s productivity by utilizing Toad. This half-day course will cover Toad for Oracle installation, general schema browser functions, editors, utilities, and additional features.

Oracle 11g New Features for Developers & DBAs

John King, King Training Resources

In this session attendees are introduced to the new and improved features of Oracle 11g (both Oracle 11g R1 and Oracle 11g R2) that directly impact application development. Special emphasis is placed on features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: new SQL functions, virtual columns, result caching, partitioning improvements, tablespace improvements, XML improvements, pivot statements, JDBC improvements, PL/SQL enhancements such as compound triggers, and Edition Based Redefinition (EBR).

Using SQLTXPLAIN (SQLT) to Diagnose SQL Statements Performing Poorly

Laptops are optional. Using the internet connectivity provided by RMOUG, participants will be able to replicate the demos during the class but having a laptop is not a requirement.

Registration opens at 11:00 a.m. in the Mile High Ballroom pre-function area. The sessions begin at 1:00 p.m.

Carlos Sierra developed the first version of this SQLTXPLAIN (SQLT) tool to help himself during the diagnostics of SQL statements performing poorly. On its first version its name was coe_xplain.sql and it was a simple script. After valuable feedback from several customers, coe_xplain.sql became SQLTXPLAIN (SQLT) and was adopted by a few EBS groups within Oracle. After some exposure to the Server Technologies team, SQLT became application independent and RAC aware. Today, on its third version, SQLT is widely used by many groups within Oracle, especially by the query tuning group within Support. It has become a preferred tool when the task in hand involves the root cause analysis for a SQL that performs poorly.

Delivered by the author of this tool, this in-depth session explains and demonstrates how this SQLT tool helps to diagnose SQL statements performing poorly. It assumes nothing. The session covers SQLT from fundamental concepts, then installation, followed by main methods, SQLT reports navigation, and some special methods. Participants interested in hands-on experience will have the opportunity to practice most of the demos using their own databases either on their laptop or connected to their remote hosts if they can access them from the conference room. The session includes presentations, demos, and significant time for open questions.

APEX for DBAs

Scott Spendolini, Enkitec

APEX for DBAs is designed for the DBA and systems administrator who are responsible for installing and maintaining an installation of APEX. This session starts out by focusing on installing APEX and configuring the Oracle HTTP server to work with it. Once installed, the remainder of the session focuses on how to manage an instance of APEX and configure its settings, such as provisioning mode, e-mail, and password policies. Time is also spent describing the APEX architecture and troubleshooting performance issues.

Master Class:

Mastering Oracle Trace Data

Cary Millsap, Method R Corporation

Rate: $700

Oracle trace data is an extraordinarily rich information source for database application developers, administrators, and anyone who cares about the speed of an Oracle Database application. Oracle trace files include information that yields value throughout your software life cycle, whether you’ve bought prebuilt applications or built them yourself. This course, designed and taught by Cary Millsap, is your fast track to becoming a master of this commonly underutilized data source.

Topics Covered in the One-Day Course

Fundamentals of software performance

Collecting Oracle trace data

Understanding the Oracle trace data stream

Limitations of standard Oracle tools

Using MR Trace and MR Tools

Detecting performance anti-patterns

The $700 fee includes:

Admission to the one-day course

A PDF copy of Mastering Oracle Trace Data, by Cary Millsap (students enrolling early receive a printed and bound copy)

A limited license for MR Tools, the premiere software for trace file mining, management, and manipulation

A Method R “I can help you trace it” T-shirt

Each limited software license included with the one-day course is a single per-user ID license, with no software maintenance contract. A per-user ID license entitles one specific person to run a software tool using a single login user ID on a single machine (either real or virtual). MR Tools runs on Linux, Mac OS X, Solaris SPARC, and Microsoft Windows.

Learn how to use SQL Developer Data Modeler to import your database schema, make changes, and generate the modified DDL.

Testing and Debugging Procedures Using SQL Developer 3.1
Learn how to run a script to update your database, review database objects in your database, create and debug a PL/SQL procedure, and create and run a unit test in SQL Developer.

Building an Application Using Oracle Application Express: Part 1
Learn how to use Application Express to load data into your database, create an application with a variety of page types (including an interactive report, calendar, and data load wizard).

Enhancing Your Oracle Application Express Application: Part 2
Learn how to enhance your Application Express application by switching to a different theme, creating a chart, dynamic actions, plug-ins, and tabular form with a validation.

This is a hands-on training lab. You will need to bring your own laptop.

The number of electrical plugs is limited so please make sure your computer is fully charged when you arrive.

Registration opens at 11:00 a.m. in the Mile High Ballroom pre-function area. The sessions begin at 1:00 p.m.

How to Prevent Suboptimal Execution Plans

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.

The number of electrical plugs is limited so please make sure your computer is fully charged when you arrive.

Registration opens at 11:00 a.m. in the Mile High Ballroom pre-function area. The session begins at 1:00 p.m.

Grab your laptop and mobile device (tablet or smartphone) and join us Monday at RMOUG for a workshop you won’t want to miss! Learn how to create on-device mobile applications that run on both iOS and Android.

The workshop will explain the unique challenges and common use cases of mobile applications and then dive into possible mobile architectures. The workshop will walk you through developing mobile applications that install and run on the device and are able to leverage device-specific features—all with the new Oracle ADF Mobile solution. No previous knowledge of Oracle ADF is needed!

This workshop is a bring-your-own-laptop event—you show up with your laptop configured according to the instructions linked below, and the workshop will provide you with expert knowledge on building a mobile application, laying out compelling mobile user interfaces, constructing task flows that facilitate navigation, accessing data sources and remote services, and interacting with device features such as SMS and the camera. Finally, you’ll deploy the application to an emulator and see first-hand how you can use ADF Mobile to develop applications declaratively and deploy to multiple devices, without writing device-specific code!

Participants will use JDeveloper to create an ADF Mobile Application, and deploy and test the application on an Apple or Android mobile device simulator.

Register now and then make sure you configure your machine according to these instructions, BEFORE you arrive at the workshop:
Windows users click here.
Mac/iOS Users click here.