IOUG Attendees - Access the session proceedings

Connect with IOUG
Expand your network by
connecting to IOUG on these
social media sites:

University Seminars

Don't miss out on these in-depth seminars held the first and last day of COLLABORATE 09 – IOUG Forum. Packed with intensive training on one topic, University Seminars are offered in both full- and half-day formats. Choose from a variety of seminar topics taught by seasoned Oracle users. (There is an additional registration fee to attend a University Seminar that can be found on the registration form.)

Sunday, May 3, 2009

U1: Data Modeling Made Easy
Judi Doolittle, Sandia National Laboratories 
This one-day University Seminar covers the use of Entity Relationship Modeling in detail, through many real life examples, practical business problems and solutions. With material that is used in the usual 4-day Oracle University course this one-day session will get to the heart of the matter and make data modeling fun and easy. Learn to normalize until it hurts and de-normalize until you can use it in the real world. This will be a hands on pencil and paper modeling class where you will learn how to make practical models that your company can implement.
Prerequisite: Basic understanding of databases and SQL.

U4: Understanding Cost Based Optimization
Jonathan Lewis, JL Computer Consultancy
This day-long presentation consists of four session lasting about 90 minutes each. In it we aim to examine the basic mechanisms of the Cost Based Optimizer so that we can get a better understanding of why it can choose unexpected execution paths. The key areas we examine are: why the optimizer chooses to use, or ignore and index; the mechanisms, arithmetic, and debugging of joins; and how to help the optimizer with statistics and (where absolutely necessary) hints.
Prerequisite: Attendees should have some familiarity with reading simple SQL and execution plans, and feel comfortable with simple mental arithmetic.

U6: Oracle Database 11g OCP - One Day Exam Cram
Robert Freeman, LDS Church 
In this jam packed, fast and furious session, we will cram your brain and your notepads full of information that will prepare you for the Oracle 11g OCP exam. The author of the Sybex book: OCP: Oracle Database 11g Administrator Certified Professional Study Guide will lead you through an intense one-day session that will provide hints, tips and insight into what you need to pass the Oracle Database 11g OCP Exam.
Prerequisite: Attendee should be a knowledgeable DBA with the Oracle database product line.

U7: TOAD Tips and Tricks
Bert Scalzo, Quest Software 
TOAD users, come and see how to maximize both developer and DBA productivity using powerful shortcuts, overlooked features and advanced capabilities. This session will have you saying “wow – I didn’t know TOAD could do that (and so easily)!” You’ll learn easy yet extraordinary ways to make both new and veteran TOAD users more productive, and thus increase the value of TOAD usage within your company. Our goal will be to show you how to get the most out of your TOAD experience. And this session is being brought to you by people who know TOAD best - the product manager and product architect. There might even be time for some product future roadmap discussion and upcoming feature previews!
Prerequisite: This is not a product sales or marketing event. Attendees should already own TOAD and simply be looking for ways to make better or more productive use.

U9: Ask Tom Kyte Live!
Tom Kyte, Oracle
Read and write consistency - Oracle's multiversioning model is by far it's most striking core RDBMS feature. We'll explore this often misunderstood database feature, both from a "read" perspective as well as some nuances you probably are not aware of in a multi-user environment. This session is probably an eye-opening experience, even for people that have been using Oracle for many many years.
All about Flashing back - This session covers all of the flashback areas: flashback query, flashback table, flashback row history, flashback drop, flashback data archive, and flashback database. Tom explains how each feature is physically implemented; for example, what settings like undo_retention and guaranteed undo retention mean and what they do. This session is very in depth (on the "how") so database administrators can be prepared to allow these features to be used in their database environments.
Reorganizing objects - when and how - A hotly debated topic is "Do I need to reorganize/rebuild indexes and tables." We will discuss the times when a reorganization or rebuild is relevant, how to measure what you've done (to verify that the work performed did something useful!), and the best techniques for performing a reorganization of data.
All about encryption - From the dbms_obfuscation_toolkit, to dbms_crypto to transparent data encryption at the column level to tablespace encrypt and data pump encryption, we'll cover them all. We'll investigate which technique should be used and under what circumstances they should be used. We'll see how the keys are managed by the Oracle Database - or not in the case of the DBMS_ packages. We'll discuss "why" you encrypt and when encryption just does not apply.
Prerequisite: None.

U11: Zen and the Art of Database Tuning
Michael Ault, Texas Memory Systems 
In this day long seminar Mike Ault presents techniques for tuning Oracle from the database internals, to SQL to the physical aspects of the database environment, the entire Zen of Oracle. With frequent demonstrations and opportunities for questions this seminar delivers on Oracle tuning knowledge transfer.
Prerequisite: The attendee should be generally familiar with Oracle database structure and SQL syntax.

U17: RMAN A to Z
Michael Abbey, Ntirety 
Please note this seminar is half-day, taking place from 9:00 a.m. – 12:30 p.m., and is available at the half-day rate. No refunds for pricing difference will be provided for registration packages.
This 1/2-day university seminar is designed to fast-track the attendee into using rman. Often, when confronted with a move to a new solution, such as rman when in the backup arena, the task list starts with a handful of easily manageable items. Once the work commences, that "small list" blossoms into a larger and larger list as new sub-tasks are uncovered and the project evolves.
For example, initially one decides whether the database will be backed up open or shut. Once the time arrives to make that decision, it becomes obvious that an online backup is the best way to proceed. Suppose though your database is not running in archivelog mode! Now the process has to deviate to plan for the work required to place the instance in that mode … these types of distractions are covered in this seminar.
Prerequisite: None.

{back to top}

Thursday, May 7, 2009

U16: Oracle 11g/10g Developers: What You Need to Know
John King, King Training Resources  
New features of the Oracle database geared to developers will be discussed and demonstrated. Attendees will be introduced to the new and improved features of Oracle 11g/10g that directly impact application development. Special emphasis is placed on features that can reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: New SQL functions, Regular Expression improvements, virtual columns, new XMLType options, XML indexing improvements, SQL pivot statements, JDBC improvements, PL/SQL syntax enhancements, PL/SQL compiler, trigger improvements, PL/SQL Result Cache, case/accent-insensitive query, regular expressions, expanded LOBs, new data types (BINARY_FLOAT, BINARY_DOUBLE, etc.), new Statistical functions, Model clause, and the recycle bin. Attendees will be better equipped to create new applications or modify existing applications to take full advantage of Oracle 11g/10g.
Prerequisite: Attendees should be familiar with some earlier version of Oracle.

U18: IOUG RAC Attack!
Whether you’re new to or familiar with Real Application Clusters (RAC), you do not want to miss the IOUG RAC Attack! hands-on lab. The hands-on lab will cover: cluster installation prerequisites on Linux, installing Oracle clusterware, installing Oracle RDBMS, creating RAC database, failure testing and backup/recovery testing.
Also, you'll have a chance to interact with some RAC experts from IOUG, Oracle and the RAC SIG, as they'll be available to help you as you navigate the hands-on exercises. These volunteers are sharing their knowledge to help you be successful with your learning experience. This opportunity doesn't come along often, so don't miss a chance to pick the brains of our experts!

{back to top}