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.
|