Pre-Training Days Events

Check out these Pre-Training Days Educational Events Monday, February 11, 2013 

  • University Sessions - Four-hour, in-depth sessions on a specific topic offered from 1:00 p.m. – 5:00 p.m.
  • Mastering Oracle Trace Data - One-day course developed by Oracle ACE Director Cary Millsap from 10:00 a.m. – 4:00 p.m.
  • 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.
  • Developing Mobile Applications Workshop - Four-hour, in-depth workshop offered from 1:00 p.m. – 5:00 p.m.  There is no cost to attend. Registration is limited to 80 participants.
  

Download our Mobile App – Sponsored by Arisant 

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.

University Session Registration

Back to Top

TOAD for Oracle Hands-on Training

Dan Hotka, Training Specialist

There are a limited number of laptops available. If you want to use one of these laptops, please let Wendy Fletcher know.

If you wish to bring your own laptop—this is fine too. Please make sure you have these items before coming to the training session:

1) A working Oracle database on your PC.

2) A working TOAD, with user and connect information working.

3) The EMP/DEPT tables installed (see below).

Here is a link to get the free Oracle Express for laptops: http://www.oracle.com/technology/products/database/xe/index.html

Here is a link to get a trial version of the latest TOAD software: http://toadfororacle.com/index.jspa  – select the trial version, it comes with a 30-day key.

Here are the two tables and data that will be needed for the course.

DROP TABLE EMP;
DROP TABLE DEPT;

CREATE TABLE DEPT (
DEPTNO              NUMBER(2) NOT NULL,
DNAME               VARCHAR2(14),
LOC                 VARCHAR2(13),
CONSTRAINT DEPT_PRIMARY_KEY PRIMARY KEY (DEPTNO));

INSERT INTO DEPT VALUES (10,’ACCOUNTING’,'NEW YORK’); INSERT INTO DEPT
VALUES (20,’RESEARCH’,'DALLAS’); INSERT INTO DEPT VALUES
(30,’SALES’,'CHICAGO’); INSERT INTO DEPT VALUES (40,’OPERATIONS’,'BOSTON’);

CREATE TABLE EMP (
EMPNO               NUMBER(4) NOT NULL,
ENAME               VARCHAR2(10),
JOB                 VARCHAR2(9),
MGR                 NUMBER(4),
HIREDATE            DATE,
SAL                 NUMBER(7,2),
COMM                NUMBER(7,2),
DEPTNO              NUMBER(2) NOT NULL,
CONSTRAINT EMP_FOREIGN_KEY FOREIGN KEY (DEPTNO) REFERENCES DEPT (DEPTNO),
CONSTRAINT EMP_PRIMARY_KEY PRIMARY KEY (EMPNO));

INSERT INTO EMP VALUES
(7839,’KING’,'PRESIDENT’,NULL,’17-NOV-81′,5000,NULL,10);
INSERT INTO EMP VALUES
(7698,’BLAKE’,'MANAGER’,7839,’1-MAY-81′,2850,NULL,30);
INSERT INTO EMP VALUES
(7782,’CLARK’,'MANAGER’,7839,’9-JUN-81′,2450,NULL,10);
INSERT INTO EMP VALUES
(7566,’JONES’,'MANAGER’,7839,’2-APR-81′,2975,NULL,20);
INSERT INTO EMP VALUES
(7654,’MARTIN’,'SALESMAN’,7698,’28-SEP-81′,1250,1400,30);
INSERT INTO EMP VALUES
(7499,’ALLEN’,'SALESMAN’,7698,’20-FEB-81′,1600,300,30);
INSERT INTO EMP VALUES (7844,’TURNER’,'SALESMAN’,7698,’8-SEP-81′,1500,0,30);
INSERT INTO EMP VALUES (7900,’JAMES’,'CLERK’,7698,’3-DEC-81′,950,NULL,30);
INSERT INTO EMP VALUES
(7521,’WARD’,'SALESMAN’,7698,’22-FEB-81′,1250,500,30);
INSERT INTO EMP VALUES (7902,’FORD’,'ANALYST’,7566,’3-DEC-81′,3000,NULL,20);
INSERT INTO EMP VALUES (7369,’SMITH’,'CLERK’,7902,’17-DEC-80′,800,NULL,20);
INSERT INTO EMP VALUES
(7788,’SCOTT’,'ANALYST’,7566,’09-DEC-82′,3000,NULL,20);
INSERT INTO EMP VALUES (7876,’ADAMS’,'CLERK’,7788,’12-JAN-83′,1100,NULL,20);
INSERT INTO EMP VALUES
(7934,’MILLER’,'CLERK’,7782,’23-JAN-82′,1300,NULL,10);

COMMIT;

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.

University Session Registration

Back to Top

Oracle 11New 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).

University Session Registration

Back to Top

Using SQLTXPLAIN (SQLT) to Diagnose SQL Statements Performing Poorly

Carlos Sierra,  Oracle Corporation

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.

University Session Registration

Back to Top

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.

University Session Registration

Back to Top


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 Trace, the zero-click trace file collector for Oracle SQL Developer
  • 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.

Registration

Back to Top


OTN Labs

OTN Lab: Database Application Development

Kris Rice, Jeff Smith and David Peake, Oracle Corporation

*No cost to attend

These sessions are hands-on training labs. You will need to bring your own laptop with the following downloaded and installed prior to the sessions. http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html.

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.

Re-engineering Your Database Using Oracle SQL Developer Data Modeler 3.1

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.

OTN Hands-on Workshop Registration

Back to Top


OTN Lab: Oracle 11gR2 Performance Tips

This session is full.

Maria Colgan, Oracle Corporation

These sessions are hands-on training labs. You will need to bring your own laptop with the following downloaded and installed prior to the sessions. http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html.

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.

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

This set of three tutorials shows you how to work with the tuning utilities in SQL Developer.

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

Back to Top


Developing Mobile Applications Workshop

Lynn Munsinger, Oracle Corporation

*No cost to attend

This workshop is a bring-your-own-laptop event—please come with your laptop configured according to the instructions linked below:

Windows users click here.
Mac/iOS Users click here.

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.

OTN Hands-on Workshop Registration

Back to Top