No other conference offers you more than thirty hands-on training labs to choose from at no additional cost. Hands-on labs are included in your registration fee.
People who register for Early Bird Registration will be able to register for the hands-on labs first.
Application Express APEX 101
This hands-on lab is designed for those that are new to Application Express and want to start from scratch and build an application. The lab starts with manipulating database objects before creating and running an application. The lab then continues by adding additional components and finishes with adding security to your application.
Building Charts, Gantts, and Maps with Oracle Application Express
If a picture tells a thousand words, then it follows that a chart shows a thousand numbers. In this session, learn how to create a variety of different chart types, from the most basic to more advanced charts including Gantt charts and Flash Maps, introduced in APEX 4.0. With APEX 4.0, the declarative capabilities within charts has been greatly expanded to make charts easier to customize and maintain. This lab will enable you to fully utilize the charting capabilities built into Oracle Application Express.
Solving the Online Reporting Conundrum with Oracle Application Express Interactive Reports
Can your end-users see all the information you have stored in your database the way they want to see it? Do they keep coming back asking for different reports or formats of their data and need it yesterday? Chances are you answered yes to both of these questions. So the way to solve these problems is to give your end-users the power to maintain their own view of the data. This hands-on session will teach you how to utilize Oracle Application Express Interactive Reporting to exceed your user's online reporting expectations. What's more, if you can write simple SQL such as 'SELECT * FROM my_favorite_table' you are most of the way to delivering Interactive Reports through Oracle's browser-based RAD tool Oracle Application Express. This lab covers both the basics and more advanced techniques which you can use with Interactive Reports.
Oracle Application Express Dynamic Actions
Oracle Application Express 4.0 introduces Dynamic Actions which provide a declarative means to define client-side processing. Previously this involved hand crafting JavaScript and AJAX, but with APEX 4.0, many Dynamic Actions require zero coding using the built-in wizards. This lab will cover the creation of various types of Dynamic Actions from the very basic to more advanced processes utilizing APEX Plug-Ins. {Plug-Ins will be provided, and participants will not need to develop them in this lab}.
Extending Oracle Application Express with Plug-Ins
Oracle Application Express 4.0 introduces APEX Plug-Ins which provides the ability to add custom item and region types, together with custom Dynamic Actions, into the APEX Repository. Once an APEX Plug-In has been installed, it can be utilized by developers in a very similar fashion to built-in items and regions. This lab will not only cover how to use them once implemented but also the creation of APEX Plug-Ins using PL/SQL. This lab is designed for experienced APEX developers.
Oracle Application Express Websheets
Oracle Application Express 4.0 introduces Websheets. This hands-on lab will help you learn how to create pages, data grids and SQL reports. Utilizing the different page sections and markup syntax you will create a variety of content that you can use to train your business people how to create Websheet applications for themselves.
Oracle EPM
Introduction to OBIEE for Essbase Professionals In this hands-on lab, you will see how Essbase data can be brought into OBIEE, and reported on using Oracle BI Answers and Oracle BI Dashboards. You will bring in one of the sample Essbase databases, and build an OBIEE metadata layer to connect to it, building on the Essbase outline and leveraging Essbase MDX calculations. You will create a simple report to show how Essbase data is exposed, and display it as a dashboard to see how OBIEE reporting concepts compare to Essbase ones.
OBIEE: Creating Your First Dashboard This session is aimed at developers, and will take you through the basics of building a range of reports and including them in a dashboard. It will show how tabular, crosstab, and chart reports are created, and how these are included in dashboards that can be scoped to different groups of users. You will see how reports can be delivered pro-actively using Oracle BI Delivers, giving you the ability to create alerts against any data source supported by OBIEE.
Installing the Essbase Platform: Installer Preparation
With version 11, Oracle introduced Oracle Installer technology to the Oracle EPM product line. In this hands-on lab, you will learn how to prepare for an Essbase installation. You will learn where to get the product files, and what do with the files to prepare for the installation. You will also learn about the relational database requirements for the Oracle EPM system data, and will create the database objects necessary for the install. When you complete this lab, you will have done everything necessary to have Essbase running on your system except the actual installation and configuration.
Installing and Configuring the Essbase Platform In this hands-on lab, you will begin with a machine that has been prepared for the installation, and will complete the tasks necessary to install and configure the Essbase platform. You will learn how to validate the completed installation, and will do basic testing to confirm the successful installation.
Essbase: Building Your First Database In this hands-on lab, you will learn the basics of designing and building an Essbase database. You will create the Essbase database structure, build some dimensions, and load some data. Finally, you will test the new database using Excel. This lab is targeted to attendees who have no direct experience building Essbase databases including EPM application users and Oracle database and APEX professionals.
Introduction to Financial Close Management and Disclosure Management
In this hands-on lab, you will see how Oracle's New Hyperion Financial Close Management Web application can be used to control, monitor, and report on your close cycle from consolidation through external reporting. Using Web-based task management, you will see how financial close tasks are created and assigned; view the reporting options available to all types of users; and complete tasks acting as different types of users. In addition, you will see how Disclosure Management allows you to create financial statements, tag them with appropriate XBRL taxonomies, and generate an Instance Document for submission to the appropriate regulatory bodies.
Building a Simple Model with Essbase Studio
This session covers the fundamental capabilities of building and deploying models with Essbase Studio. After completing the session, participants should understand the complete process in moving from data source to deployment. Participants will work with both relational and text connections, create basic dimensions, create alias sets, create cube models, and deploy Essbase cubes.
Creating Mini-schema and Dimensions with Essbase Studio
This session focuses on the steps required to prepare data sources for Essbase Studio data loads and dimension builds. The session also focuses on more advanced dimension building techniques. This includes:
•Creating joins across relational tables and text files
•Building from recursive tables and files (parent and child builds)
•Creating attribute dimensions and alternate hierarchies
•Filtering data elements
•Creating custom data elements
Advanced Essbase Studio Capabilities
This session covers some of the more advanced capabilities of the Essbase Studio. Participants will work with some of the optional, but important, capabilities. These include:
• Creating alternate data source bindings
• Incremental dimensional updates
• Creating and executing drill through reports
• Performing lineage tracking
Leveraging Essbase Data Types
This session lets users work with various data types inherent in the Essbase server. Participants work with data types introduced over the last two major releases. These include: • Date-time dimensions • Text and date measures and members • Varying attributes
Essbase Version 11.x General New Features
This session provides a hands-on overview of key new features in the 9.3.x and 11.x releases of Essbase. New features covered in previous sessions will be mentioned for context, but will not be covered in a hands-on fashion. This session covers: • Trickle feeding of data into Essbase • Working with backups and transaction replay • Implementing target partitions on ASO • Leveraging Smart View slices • Reviewing overall new functionality
SQL Developer
Data Modeling with Oracle SQL Developer Data Modeler Oracle SQL Developer Data Modeler supports logical, relational, and physical data modeling. In addition, users can import from a variety of sources and do forward and reverse engineering of database structures. In this hands-on session, you will learn how to create a relational data model, work with entity relationship diagrams, and generate DDL. You will also work with and export your designs to the reporting repository.
Unit Testing and PL/SQL Development with Oracle SQL Developer 2.1 Oracle SQL Developer supports the development of SQL and PL/SQL code. In this hands-on session, you will work with PL/SQL in SQL Developer, create and edit PL/SQL, compile and debug the code, work with PL/SQL files on the file system, and learn how to use the new Oracle SQL Developer Unit Testing feature to create and run unit tests.
Version Control and File Management with Oracle SQL Developer 2.1
Oracle SQL Developer supports browsing the file system and integrated version control, by integrating with a number of open source version control systems. In this hands-on session, you will use SQL Developer to browse and review files. Using the integrated Subversion support for source code control, you will place files under version control, check out the files, make changes, and check them back into the versioning repository.
Fusion Middleware
An Introduction to Oracle ADF Development
In this lab, you’ll get to experience Oracle ADF - Oracle's strategic development framework for the Fusion applications. See how you can build a complete Java-based application with rich Web-based user interface that access the database without coding a single line of Java. Learn the basics of using Oracle ADF Business Components and Oracle ADF Faces to create attractive applications with ease.
Database Modeling and Development with Oracle JDeveloper
In this lab, you'll get to know the database development capabilities built into Oracle JDeveloper from high-level modeling to core PL/SQL coding. Learn about database modeling with UML, reverse engineer databases into diagrams, use reports to check your database objects status, and more.
Introduction to Web Services Development and Consumption with Oracle JDeveloper
In this lab, you'll learn how to expose business logic as Web services that can be consumed by other system. You'll also learn how to consume existing Web services and access them both from code as well as building Web user interfaces that access Web services.
Java EE Development with Oracle Enterprise Pack for Eclipse
In this lab, you'll get to know Oracle's offering for the Eclipse platform, and learn how they enable faster development with core Java EE technologies such as JPA, EJB, and JSF. Learn how Oracle Enterprise Pack for Eclipse integrates with Oracle WebLogic to provide a simplified development environment.
Oracle WebCenter - Extending Your Application into the Enterprise 2.0 World
In this lab, you'll learn how Oracle WebCenter can add Enterprise 2.0 capabilities to your application. Start with a simple ADF application, and learn how to add content integration, portlet integration, and end-user runtime customization.
Building Dynamic Web 2.0 User Interfaces the Easy Way
In this lab, you'll learn how to leverage Oracle ADF Faces to create cutting edge Web-based user interfaces that leverage AJAX capabilities without coding low-level JavaScript code. See the easiest way to achieve your desired Web user interface with a set of rich components and a visual and declarative development experience.
