University Sessions

University Sessions are four-hour, in-depth sessions on a specific topic offered on Tuesday, February 16 from 1:00 p.m. - 5:00 p.m. for an extra fee of $125 for people not attending Training Days, and $112.50 for people attending the conference. Below are descriptions of the sessions offered:
Robert Freeman, LDS Church Database Administration
Installing Oracle Database 11g RAC on VMWare
Room 103/105

DBAs with Oracle RAC experience are becoming more and more in demand as Oracle RAC installs increase. So, if you are a DBA, but your employer does not currently use Oracle RAC, how do you learn about Oracle RAC, install the various components involved in an Oracle RAC cluster, and manage an Oracle RAC database? This presentation will show you how to install an Oracle RAC cluster on a laptop using VMWare, Linux, and Oracle RAC.

Back To The Top
Ashley Chen, Sue Harper, and Kris Rice, Oracle Corporation
Database Administration
Hands-On Lab: Working with SQL Developer and SQL Developer Data Modeler
Room 108/110

This is a “Bring Your Own Laptop” hands-on session, which offers a selection of tutorials for you to choose from, whether you are new to SQL Developer, want to learn about the latest features, or want to work with SQL Developer Data Modeler.

The tutorials available are:
Oracle SQL Developer

  • Getting Started
  • Advanced Oracle SQL Developer Features
  • Developing and Debugging PL/SQL
  • Using Source Code Control
  • Creating User Defined Extensions
  • Creating PL/SQL Unit Tests

Oracle SQL Developer Data Modeler

  • Adding a Table to an Existing Database
  • Modifying a Logical Model Using Inheritance and Object Types
  • Generating a Multi-Dimensional Model
  • Reviewing Your Oracle SQL Developer Data Modeler Design
The Getting Started and Advanced tutorials cover a broad spectrum of features in the tool, while the PL/SQL section covers creating, editing, and debugging PL/SQL. You can learn how to take advantage of SQL Developer's extensibility by adding features to the core product, with a tutorial that walks through adding context menus, navigator displays and editors, and using XML. Alternatively, you can learn to how to create a Subversion repository and place your file-based project under control using source code control. The selection of SQL Developer Data Modeler tutorials show you how to work with logical, relational, and multi-dimensional models. You also learn to work with the reporting repository by exporting your designs to the repository and running a set of predefined reports.

Back To The Top
Dan Hotka, Training Specialist Applications
Understanding Explain Plans
Room 102

The course starts out with a complete overview of the Oracle architecture so students can get an understanding of how their SQL and applications can take advantage of the computing environment. This course includes a discussion on the differences of the various Explain Plan steps such as Merge-Join and Nested-Loop, and when it is best to use each. Dan goes into considerable detail, with SQL examples, on how the optimizers (both rule and cost) make their decisions. Students will see a variety of SQL statements, reviewing Explain Plans and making changes to make these SQL statements perform better.

Back To The Top
Peter Koletzke, Quovera and
Duncan Mills, Oracle Corporation		 Applications
A Guide to Fusion Web Development with JDeveloper 11g
Room 107/109

These days, development shops have been mandated to develop new applications using Java Platform, Enterprise Edition (Java EE) Web technologies. This proves to be a challenge for traditional application developers because the main Java EE languages and the style of development are very different. Oracle Corporation is developing the next wave of Oracle Applications (E-Business Suite, now Oracle Fusion Applications) using JDeveloper 11g and Application Development Framework (ADF) technologies such as ADF Business Components and ADF Faces Rich Client. JDeveloper 11g helps Web developers from every discipline transition more easily than ever to Java EE Web development. Its declarative and visual development environment rivals that of traditional tools, yet it creates standard Java EE code that can be deployed on any Java EE server such as Oracle Application Server and WebLogic Server. This training session, presented by the co-author(s) of the Oracle Press book Oracle JDeveloper 11g Handbook, explains how to use JDeveloper and ADF with the technologies Oracle is using for Fusion applications. It provides an introduction to, and best practices for, the use of JDeveloper’s visual and declarative tools. It demonstrates how you can use JDeveloper’s visual and declarative environment to create the Model layer, using ADF Business Components, which allow you to easily query, insert, update, and delete data; as well as the View and Controller layers, using ADF Faces Rich Client and JSF, which supplies the AJAX-enabled, Web 2.0 user interface, and the ability to interact with user events such as button clicks.

Back To The Top
Daniel Liu, Oracle Corporation Database Administration
Oracle Database 11gR2 New Features
Room 111/113

Doing more with less is the mantra for today's organization. Oracle Database 11g is helping organizations deliver a higher quality of service to their customers, while reducing the cost of computing through consolidation, reduced storage, and the elimination of idle redundancy. Daniel will introduce the new features in Oracle Database 11g Release 2 and Release 1. Those topics include: Real Application Testing, RAC One, Active Data Guard, ASM Enhancements, Advanced Compression, SQL Query Result Cache, In-Memory Database Cache, Total Recall, Automatic Diagnostic Repository, Invisible Index, New Partitioning Methods, Audit Vault, Data Masking, Exadata, Hybrid Columnar Compression, and SQL Developer Data modeler. The seminar will also discuss upgrade and deployment strategy. The topics covered in this seminar are primary for database administrators.

Back To The Top
Scott Spendolini, Sumner Technologies Applications
Troubleshooting Oracle APEX
Room 104/106

Oracle Application Express is made up of several technologies: PL/SQL, HTML, CSS, JavaScript, and Ajax. When something goes wrong, it's often more difficult to figure out what went wrong than it is to fix it. This presentation takes a brief look at each technology that makes up Oracle Application Express and discusses and demonstrates how to effectively track down and solve the problem. As an added bonus, every tool outlined in this presentation is available for free.

Back To The Top