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

Quality "Shmality"-Why You Need Data Quality and How to Conduct a Data Quality Program
William Wimsatt, Wells Landers Group
Business Intelligence/Data Warehousing
Room 104/106

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.

Register Now!http://www.technicalconferencesolutions.com/RMOUG_registration.html

University Session: Understanding Explain Plans

Understanding Explain Plans
Dan Hotka, Training Specialist
Application Development
Room 107/109

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.

University Session: A Guide to Fusion Web Development with JDeveloper 11g

A Guide to Fusion Web Development with JDeveloper 11g
Peter Koletezke and Duncan Mills, Quovera and Oracle Corporation
Application Development
Room 111/113

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

Register Now!

University Session: Oracle SQL Developer: Hands-On Experience

Oracle SQL Developer: Hands-On Experience
Sue Harper and Kris Rice, Oracle Corporation
Application Development
Room 108/110/112

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.

Register Now!

University Session: Maximum Availability Architecture 101

Maximum Availability Architecture 101
Stephan Haisley, Oracle Corporation
Database Administration
Room 103/105

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.

Register Now!

University Session: Advanced RMAN Backup and Recovery

Advanced RMAN Backup and Recovery
Robert Freeman, Church of Jesus Christ of Latter-day Saints
Database Administration
Room 102

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.

Register Now!

University Session - Hands-On Oracle Application Express—From Zero to 60 in a Day!

Hands-On Oracle Application Express—From Zero to 60 in a Day!
Bradley Brown, TUSC—A Rolta Company Details
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!

Register Now!

Training Day University Sessions - on Tuesday

Come a day early to receive in depth training on specific topics at Training Days 2009 University Sessions. These are four-hour sessions offered on Tuesday, February 10 from 1:00 p.m. - 5:00 p.m. The fee is $125.00 and if you are registered for the conference you will receive a 10% discount. PDF Document

• The RMOUG University Sessions include:
  Hands-On Oracle Application Express—From Zero to 60 in a Day!
  Bradley Brown, TUSC—A Rolta Company
  Application Development Details
  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.
  
• Advanced RMAN Backup and Recovery
  Robert Freeman, Church of Jesus Christ of Latter-day Saints
  Database Administration Details
  
• Maximum Availability Architecture 101
  Stephan Haisley, Oracle Corporation
  Database Administration Details
  Room 103/105
  
• Oracle SQL Developer: Hands-On Experience
  Sue Harper and Kris Rice, Oracle Corporation
  Application Development Details
  Room 108/110/112
  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.
  
• Understanding Explain Plans
  Dan Hotka, Training Specialist
  Application Development Details
  Room 107/109
  
• A Guide to Fusion Web Development with JDeveloper 11g
  Peter Koletezke and Duncan Mills, Quovera and Oracle Corporation
  Application Development Details
  Room 111/113
  
• Quality "Shmality"-Why You Need Data Quality and How to Conduct a Data Quality Program
  William Wimsatt, Wells Landers Group
  Business Intelligence/Data Warehousing Details
  Room 104/106
  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.

Register now!