Training Days 2009 University Sessions

Hands-on Oracle Application Express
From Zero to 60 in a Day!

Bradley Brown, TUSC - A Rolta Company
Application Development

PLEASE NOTE: This is a hands-on session. You'll need to bring your own laptop that has a wireless card that can connect to Brad's network.

In this session, you'll learn to use APEX from concept to delivery to support. We'll start with an existing "database" (i.e. an Excel spreadsheet) and build a real world application from the ground up. We'll also look at how APEX was used to solve specific business problems such as performing online property validations, keeping track of insured pilots, bug tracking, Agile development tracking, getting people to RSVP to monthly events without having to call them, and others. This session will discuss and demonstrate the functional requirements, how these applications were extended over time, the net results, and cost savings.

APEX is a declarative Web-based application development and deployment environment. It's a powerful and easy way to quickly develop a database-centric Web application. You can install APEX on your own machines or run it in a hosted environment on Oracle's apex.oracle.com site. All development (construction of pages) is done through the browser interface. You can use the SQL Workshop and the Data Workshop to run SQL and add data to your environment. This easy-to-use tool will impress you in no time at all! PL/SQL developers and DBAs love Application Express! This presentation gives the participants a good introduction and great hands on experience with the APEX development environment, as well as a good idea of the power that it contains to create quick, powerful Web application in a very short time.

Brad will bring a server that has APEX installed along with a wireless network router that everyone will connect to for the class. You'll need to bring your own laptop that has a wireless card that can connect to his network. You can share with someone else in the class if you would like, but the best experience is for you to do the typing. SQL and PL/SQL knowledge will be beneficial, but not absolutely necessary. This class is going to be limited in size, so sign up quickly!

Advanced RMAN Backup and Recovery

Robert Freeman, Church of Jesus Christ of Latter-day Saints
Database Administration

So, you have RMAN up and running. You are backing up your database, and you are pretty sure you know how to recover it. Maybe. Beyond that, what else exists out in the RMAN world that can help you? In this presentation Robert Freeman, author of Oracle Database 10g RMAN Backup and Recovery will touch on a number of advanced RMAN topics. Topics include point-in-time recoveries, performance tuning, and database duplication. Several new Oracle Database 11g features will also be highlighted. Come join us for this exciting exploration of advanced RMAN backup and recovery topics!

Maximum Availability Architecture 101

Stephan Haisley, Oracle Corporation
Database Administration

Oracle Maximum Availability Architecture (MAA) is Oracle Corporation's HA best practices blueprint based on Oracle high availability technologies such as Real Application Cluster, ASM, Data Guard, Exadata, Flashback technologies, etc. The goal of MAA is to design the best high availability architecture with the greatest return on investment and quality of service

Downtime is something every mission critical business wants to avoid or minimize, whether it is due to planned or unplanned outages. Oracle offers a number of features and proven operational and configuration practices to minimize downtime.

This session aims to demystify the HA features offered by Oracle and outline a clear set of best practices to avoid and minimize downtime for all outages. I will provide real world examples of how MAA best practices have prevented prolonged downtime when faulty HBAs corrupted the primary database, how a leading telecom reduced downtime exposure from two hours to its minutes for outages resulting in site failover, and how legal and insurance firms reduced downtime to minutes using Data Guard switchover for upgrades and major system changes. I will also describe how to configure for zero downtime for most unplanned and some planned outages.

Oracle SQL Developer: Hands-On Experience

Sue Harper and Kris Rice, Oracle Corporation
Application Development

PLEASE NOTE: This is a hands on session. Users are required to bring their own laptops with a database 9.2.01 or above installed. XE database is fine too. This can be downloaded and installed from OTN. We will not do database setup on the day.

SQL Developer provides database developers with a powerful tool for database development tasks. Users can browse, create, edit, and delete Oracle database objects; create, edit, and debug SQL and PL/SQL code; manipulate and export data; run reports and place files under version control. Using a combination of presentation and hands on, this session walks users through various aspects of the tool. We'll start with an overview and look at the general features of the product, with a focus on new features. This is followed by a drill down into features such as PL/SQL editing and debugging, building User Extensions, using Version Control, and interacting with Application Express. We'll close with an overview of SQL Developer Data Modeling and an opportunity to try out the product. In each of the sections, attendees will have a choice of hands on sessions to work with. Throughout, we will be using the latest release of SQL Developer, pointing out the latest new features introduced.

Understanding Explain Plans

Dan Hotka, Training Specialist
Application Development

Understanding how Oracle arrives at the Explain Plan is a definite prerequisite to doing any further SQL statement tuning. Attend this presentation to understand exactly how Oracle arrives at execution plans and gain a better understanding of how Oracle works.

A Guide to Fusion Web Development with JDeveloper 11g

Peter Koletezke and Duncan Mills
Quovera and Oracle Corporation
Application Development

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 Oracle 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-authors of the Oracle Press book Oracle JDeveloper 10g for Forms and PL/SQL Developers, 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.

Quality "Shmality"-Why You Need Data Quality
and How to Conduct a Data Quality Program

William Wimsatt
Wells Landers Group
Business Intelligence/Data Warehousing

PLEASE NOTE: This is a hands-on session. Users are required to bring their own laptops. We will be sending an email to participants with directions for loading the required software prior to the session.

Understand data quality, how to conduct data profiling, and discuss options for starting a data quality or governance program in your organization.

Data stored in a data warehouse or data mart must be trusted to have true actionability. When you bring data into your data warehouse, you need to first understand the structure and the meaning of your data, and then assess the quality and the extent to which you may need to cleanse and transform it. Once you know what actions you need to take, you then need to make the required corrections to the data, and put in place a means to detect and correct any more errors that might occur in future loads.

Many organizations build a data warehouse to provide an integrated, reliable, and consistent version of the truth. Data is typically sourced from various systems and has to be extracted, cleansed, and integrated before being made available for users to query.

The quality of the data loaded data warehouses and data marts is highly variable; however, the process of profiling your source data has been a time-consuming, manual process via custom programs or the purchase of an expensive third-party tool.

This presentation will present data quality, and formation of a data quality program through hands-on demonstrations and exercises with Oracle Warehouse Builder Data Profiler and an open source data profiler.


Exadata

Tom Kyte, Oracle Corporation

Join Tom Kyte and learn how Oracle Exadata and Oracle Database 11g provide a comprehensive platform for addressing today's data warehousing and business intelligence requirements.

IT Budget Bailouts

Jim Thomas, vice president sales and marketing
Arisant

Jenny McGurk, application development manager
Douglas County School District

IT budgets are being reduced, but expectations are not. Create your own bailout by choosing solutions that meet the demands of your business while also creating significant IT savings. This presentation will highlight real solutions that save real money.

Tackle Maintenance
Performance and Change with Confidence

Jeff Smith, Solutions Architect, Quest Software

As a database administrator, you have to be more versatile than ever. You are likely under a great deal of pressure to implement application and database changes, and quickly resolve problems, all while preventing data loss or corruption. Furthermore, meeting service levels for performance and availability may add to the complexity of your job.