University Seminars

The University Seminars are held on Sunday, April 23, 2006 and Thursday, April 27, 2006. These seminars are held in both full-day and half-day formats and are packed with intensive training. Directly before and after the symposium, attend a variety of seminar topics presented by leading Oracle professionals.

For a small additional fee, learn the hottest solutions, tips and techniques. Space is limited and reservations are made on a first come first serve basis.

Need to add a University Seminar to your registration? Not registered with IOUG but interested in attending one of our Seminars? Click here!

Full-day University Seminars (Sunday, April 23, 2006 - 9:00 a.m. - 5:00 p.m.)

•  $440 USD through March 31, 2006
•  $520 USD after March 31, 2006

Half-day University Seminars (Thursday, April 27, 2006 - 8:30 a.m. - 12:00 p.m.)

• $225 USD through March 31, 2006
• $275 USD after March 31, 2006

Sunday University Seminars

U1: Secure your Oracle Database Infrastructure in Phases
U2: 10g Advanced Backup and Recovery in 2006
U3: Oracle Predictive Modeling
U4: All About Rollback and Undo Segments, Automatic Undo Management and Flashback Query
U5: Oracle Database 10g: Data Guard, Streams, and RAC
U6: Preparing the Beginning DBA for COLLABORATE 06
U7: Essential Performance Forecasting
U8: Scaling to Infinity: Partitioning Data Warehouses on Oracle
U9: Introduction to Stored PL/SQL (Procedures, Functions, Packages, and Triggers)
U10: Data Modeling Made Easy
U11: Advanced RAC & Management via EM Grid Control

Thursday University Seminars

U17: Introduction to Java - PL/SQL Developers Take Heart!
U18: Learn How to Build Your Own RAC System
U19: Oracle 10g New Features for DBA
U20: Oracle 10g/9i for Developers: What You Need to Know

U1: Secure your Oracle Database Infrastructure in Phases

Speaker: Arup Nanda
Expertise: All
Focus Area: DBA
Abstract: Most DBAs are so absorbed in the day to day administration of the database that they tend to overlook some of the most imprtant elements - security being one. With today's environment with myriads of laws and regulations, security is not just a nice-to-have anymore, it's a requirement. So, how do you plan for a secure database infrastructure without being overwhelmed? This calls for a phased approach. This session will show that tasks can be broken into four phases - done in a day, in a week, in a month and finally six months.

U2: 10g Advanced Backup and Recovery in 2006

Speaker: Tim Quinlan
Expertise: Intermediate
Focus Area: DBA
Abstract: This course will discuss advanced backup and recovery techniques available in Oracle 10g (including R1 and R2). This is intended for intermediate to advanced DBA's and assumes that attendees understand basic user-managed backup and recovery features. Therefore basic features will only be discussed briefly to allow more time for the more advanced topics. Main topics covered include advanced backup and recovery tips and techniques, standby databases and data guard as well as recovery manager. Other topics relating to Oracle availability will also be touched upon in this fast moving seminar. Emphasis will be placed on Oracle 10g features.

U3: Oracle Predictive Modeling

Speaker: Donald K. Burleson
Expertise: Advanced
Focus Area: DBA
Abstract: Those who cannot remember the past are condemned to repeat it, and this is especially true for those who use Oracle Discoverer and Oracle data mining for analyzing historical data and identifying significant correlations. Oracle professionals are now applying the techniques of predictive modeling to Oracle performance data and using the gold mine of information in STATSPACK and AWR to develop Oracle tuning models. This paper will examine the types of data stored inside STATSPACK and AWR and examine techniques for trend identification and predictive modeling. Using these techniques Oracle professionals remove the guesswork from change to the Oracle instance and provide a framework for gathering evidence to justify database changes.

U4: All About Rollback and Undo Segments, Automatic Undo Management and Flashback Query

Speaker: Kirtikumar Deshpande, Verizon
Expertise: Beginner
Focus Area: DBA - Administration
Abstract: The Automatic Undo Management and Flashback Query are two most talked about new features of Oracle9i Database. In this session, we will discuss in detail, what are Undo Segments, how and why Oracle uses them. You will learn what Oracle does behind the scenes to mange them automatically. We will discuss the tasks that are still DBAs responsibility. We will also discuss the reasons for ORA-1555 (Snapshot too old) error and learn how Automatic Undo Management works to minimize its occurrence. The Flashback Query feature allows you to access data as it existed at a point in time in the past. You will learn how actually it works and it applications. These two features are enhanced in Oracle Database 10g to offer automatic undo retention time tuning, undo retention time guarantee, undo tablespace sizing, flashback version query, flashback transaction query, and flashback table. You will learn how those work and where those can be helpful.

U5: Oracle Database 10g: Data Guard, Streams, and RAC

Speaker: Daniel Liu, First American Real Estate Solutions
Expertise: Intermediate
Focus Area: DBA
Abstract: This one-day technical session is designed for Oracle professionals to gain in-depth knowledge of Oracle Database 10g’s top three High-Availability solutions – Data Guard, Streams, and RAC. It offers an introduction to the basic concepts and architectures of the three products. It discusses the requirements and steps to setup each high availability solutions. It provides the performance analysis and implementation tips of the three products. The session will help users to choose and implement the right technologies to solve their business problems.

U6: Preparing the begining DBA for Collaborate06

Speaker: Robert Freeman, Burleson Oracle Consulting & Training
Expertise: Beginner
Focus Area: DBA - Administration
Abstract: This full day session will be designed to provide the begining DBA training on administration of the Oracle Database. In addition, each individual topic area will be assocaited with suggested Collaborate06 sessions that will provide additional detail on the topic at hand. Oracle DBA topics covered in this session include Oracle database architecture overview, Creation and administration of Oracle Databases, and Backup and Recovery of Oracle databases.

U7: Essential Performance Forecasting (Full University Seminar)

Speaker: Craig Shallahamer, Orapub, Inc.
Expertise: Beginner
Focus Area: Architecture & Infrastructure - Other
Abstract: When a bunch of new users are going be added to a system, it’s the DBA who is quickly asked, “That’s not going to be a problem, is it?” And when performance begins to degrade, it’s the DBA who hears about it…and was supposed to prevent it. So at a basic level, identifying future performance problems and developing mitigating strategies is an essential DBA skill. This seminar will prepare you do just this. Through this five part full day university seminar, you will learn forecasting lingo, basic forecasting math, relevant statistics, charactering an Oracle workload, and how to forecasting using advanced queuing theory and linear regression.

U8: Scaling to Infinity: Partitioning Data Warehouses on Oracle

Speaker: Tim Gorman, Sage Logix
Expertise: All
Focus Area: Data Warehousing & Business Intelligence
Abstract: Partitioning is crucial to data warehouses based on Oracle, but how do you use this complex functionality effectively? What other major features of Oracle does partitioning enable, and how and why? This presentation is the result of long practical experience in logical and physical database design for data warehouses, driven by the combination of business requirements and systems requirements. It will provide straight answers and solid guidelines to best utilize Oracle DW features to ensure success. Data warehouses that utilize partitioning effectively often succeed, while data warehouses that are not designed to use partitioning effectively often dies painfully.

U9: Introduction to Stored PL/SQL (Procedures, Functions, Packages, and Triggers)

Speaker: John King, King Training Resources
Expertise: Beginner
Focus Area: Developer - Programming (e.g. Java/J2EE, JSP, Beans, XML, SQL, PL/SQL, Perl, CGI, OCI)
Abstract: Many people have a passing familiarity with PL/SQL, but, now necessarily the methods with which stored PL/SQL is created and used. Using many live code examples and demonstrations attendees are introduced to the ins-and-outs of stored PL/SQL. This seminar introduces the basic concepts of Procedures, Functions, Packages, and Triggers along with helpful hints on their implementation. An introduction to Java Stored Procedures and a comparison with PL/SQL will also be covered. Attendees will be able to read PL/SQL code and understand what stored Procedures, Functions, Packages, and Triggers are doing, and how they may be used effectively.

U10: Data Modeling Made Easy

Speaker: Judi Hotsinpiller, Sandia National Laboratory
Expertise: All
Focus Area: Developer - Design/Configuration (Extranet, Intranet, Modelling)
Abstract: 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.

U11: Advanced RAC & Management via EM Grid Control

Speakers: Erik Peterson, Oracle; Anil Khilani, Oracle
Expertise: Intermediate
Focus Area:  Architecture & Infrastructure – Hardware Configuration (e.g. RAC, ASM, OS)
Abstract: Know RAC well? This class will take a single shared cluster already running RAC and turn it into a full scale database grid supporting different workloads each with their own priority and resource needs. Session will focus on Database Services and their ability to provide isolation and visibility, learn about alternatives in load balancing including the new Runtime Connection Load Balancing, and how to manage, monitor and control each of these in Enterprise Manager. Coverage will also include using Enterprise Manager for general database administration, Performance Monitoring, and ADDM.

U17: Introduction to Java - PL/SQL Developers Take Heart!

Speaker: Peter Koletzke, Quovera
Expertise: Beginner
Focus Area: Developer - Programming (e.g. Java/J2EE, JSP, Beans, XML, SQL, PL/SQL, Perl, CGI, OCI)
Abstract: Oracle's current focus on implementing database and development features based on the Java language may have you thinking that you need to learn Java. However, if you are familiar with PL/SQL, your first view of Java may be a bit discouraging because its object-oriented core makes it look different. Also, you may be wonder about Java's strengths and weaknesses and where it fits in the industry. -- This university session explains to PL/SQL developers who have had little or no exposure to Java, the basic concepts of and terms used in Java. The session provides an overview of the language and reviews the concepts of object orientation upon which Java is based. It also discusses the fundamental Java code structures -- classes and methods -- as well as control statements; exception handling; datatypes; and variables. Finally, the session provides a view of where Java is used in J2EE web development.

U18: Learn How to Build Your Own RAC System

Speaker: George Trujillo, Trubix
Expertise: Beginner
Focus Area: DBA
Abstract:Abstract
This half day workshop will teach attendees how to build their own RAC system. At the end of this in-depth workshop, attendees will walk away with the knowledge of how to build and configure an Oracle10g RAC system from scratch. This workshop will demystify all the core RAC components such as Cluster Ready Services (CRS) and Oracle10g Automatic Storage Management (ASM). A RAC system will be assembled, cabled, installed and configured during the workshop to make sure attendees understand all the RAC components. This workshop is ideal for DBAs who will be working with RAC environments in the future. While attendees watch a RAC system being built from scratch, RAC best practices and key configuration issues will be presented. At the end of this workshop attendees will walk away with the knowledge of how to build a RAC system on their own at home and understand best practices for configuring a RAC system.

U19: Oracle 10g New Features for DBA

Speaker: Daniel Liu, First American Real Estate Solutions
Expertise: All
Focus Area: DBA - Administration
Abstract: Oracle Database 10g, next-generation database, is the industry's first designed for grid computing. Grid computing reduces the cost of IT by clustering servers together to act as a single large computer, dynamically shifting server resources between applications on demand. Daniel Liu, the co-author of Oracle 10g New Features for the DBA by Rampant TechPress, will introduce the new features in Oracle Database 10g Release 1&2. Those topics include: new initialization parameters, Automatic Storage Management (ASM), Cross Platform Transportable tablespaces, new SYSAUX tablespace, high-speed Data Pump utility, extended Flashback functions, RMAN enhancements, Column-level Virtual Private Database (VPD), database tuning and performance improvement, high availability improvements in Real Application Clusters (RAC), Data Guard, Oracle Streams, and more. The topics covered in this seminar are primary for the database administrators.

U20: Oracle 10g/9i for Developers: What You Need to Know

Speaker: John King, King Training Resources
Expertise: Intermediate
Focus Area: Developer
Abstract: The features of Oracle10g R1 and R2 extend the capabilities of the database in many ways. Attendees will be introduced to the new and improved features of Oracle10g that directly impact application development and some of the more important Oracle9i features they might have missed. Special emphasis is placed on features that can reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: New SQL statements, case/accent-insensitive query, regular expressions, expanded LOB storage, distributed LOB, new data types (BINARY_FLOAT, BINARY_DOUBLE, SDO_GEORASTER), new Statistical functions, Model clause, recycle bin, ISO Join options, CASE statement, Outer join improvements, XML support, External tables, MERGE, Object improvements, Rules manager, Expression Filters, and expanded Java capabilities.