| |
University Seminars
The University Seminars are held on Sunday, April 18th and Thursday, April 22nd (The days before and after Live!). These seminars are held in both full-day and half-day formats and are packed with intensive training. There are a variety of seminar topics to choose from and the instructors are leading Oracle professionals bringing you only the best in training. There is an additional fee for attending a University Seminar, but it is well worth the valuable training you will take away.
| Full-day University Seminars (Sunday, April 18, 2004 - 8:30am - 4:30pm) |
Registration rate | $499 USD |
| |
| Half-day University Seminars (Thursday, April 22, 2004 - 8:30am - 12:00pm) |
| Registration rate | $265 USD |
Sunday University Seminars
U1 - Advanced Oracle Database Troubleshooting on UNIX
U2 - Agile Systems Development and Extreme Programming in the Oracle Environment
U3 - Building and Maintaining Applications Using Oracle BI Architecture
U5 - Introduction to Stored PL/SQL
U6 - Oracle 10g New Features for DBAs
U7 - Advanced Backup and Recovery
U8 - Oracle Environment Security
U9 - Oracle Performance Optimization Using Wait Interface
U11 - Oracle9i RAC Configuration and Management
U12 - Java-based Oracle Web Development
Thursday University Seminars
U13 - Advanced DBA Best Practices
U14 - Managing Oracle OLAP
U15 - Key 10g Features Oracle9i DBAs Need to Know
U16 - DBA's Introduction to Java
U1: Advanced Oracle Database Troubleshooting on UNIX
Speaker: Tim Gorman, SageLogix
Focus Area: Database Administration
Expertise: Intermediate
Abstract:
Database administration requires a wide range of supporting skills: database internals, database architecture, security, backup/recovery, network and systems administration. But perhaps no skill is more useful than the ability to use all of these knowledge sources to quickly and accurately diagnose failures and performance -- tuning problems. This seminar details the necessary methods and tools to use in debugging all manners of connectivity errors, failures, Oracle errors and performance issues. Tools described include trace mechanisms, Oracle "events", V$ views and X$ tables and UNIX utilities such as "truss", "strace", or "tusc". The seminar focuses on understanding the Oracle data structures and internals accessed by these tools so that participants understand when (and when not)to use each tool and what information it can provide. The speaker provides practical advice based on actual usage via actual case studies.
U2: Agile Systems Development and Extreme Programming in the Oracle Environment
Speakers: Paul Dorsey, Dulcian, Inc.
Expertise: Intermediate
Abstract:
Agile processes and Extreme Programming (XP) are taking the software development community by storm. This is the latest trend for increasing the quality and reducing the failure rate of software projects. At all major software development conferences, this is the main topic of many of the papers presented. Using these new techniques for Oracle based systems presents some challenges. This University Seminar will provide an overview of these techniques and describe how they can be effectively used to support Oracle-based systems development.
[Return to Top]
U3: Building and Maintaining Applications Using the Oracle Environment
Speakers: Chris Claterbos and Dan Vlamis, Vlamis Software Solutions
Focus Area: Data Warehousing and Business Intelligence
Expertise: Intermediate
Abstract:
This seminar will present the technologies that were introduced with Oracle9i/10g and 9i Internet Developers Suite (9iDS). These include analytical functions in the relational database, OLAP Services, 9i Oracle Warehouse Builder (OWB), Java OLAP API, and BI Beans. Attendees will see how to use Oracle9i, OLAP Services, 9i OWB, JDeveloper 9i and BI Beans to build an OLAP aware warehouse and then develop simple and complex applications to view the warehouse data. A comparison between thick and thin client applications will also be discussed. The attendees will be shown how to start building OLAP warehouses and developing applications using BI Beans and JDeveloper. A sample datamart will be built and an application will be built to access this data during the class. All attendees will have access to the resulting application code.
[Return to Top]
U5: Introduction to Stored PL/SQL
Speaker: John King, King Training Resources
Focus Area: eBusiness and Application Development
Expertise: Beginner
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.
U6: Oracle10g New Features
Speaker: Daniel Liu, First American Real Estate Solutions
Focus Area: Database Administration
Expertise: Intermediate
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. Those topics include: new initialization parameters, Automatic Storage Management (SAM), 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, new SQL enhancements, high availability improvements in Log Miner, Real Application Clusters (RAC), Data Guard, Oracle Streams, and more. The topics covered in this seminar are primary for the database administrators.
[Return to Top]
U7: Advanced Backup and Recovery
Speaker: Tim Quinlan, TLQ Consulting, Inc.
Focus Area: Database Administration
Expertise: Intermediate
Abstract:
This seminar will discuss advanced backup and recovery techniques available in Oracle9i and 10g. This is intended for intermediate to advanced DBAs 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 Recover 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.
U8: Oracle Environment Security
Speaker: Kenny Smith, Inplexus
Focus Area: Database Administration
Expertise: Intermediate
Abstract:
An Oracle system uses one or more Oracle software components. Typically, a database runs database code, user screens and an application server. A company places significant resources into their Oracle systems running properly because the business depends on it. Systems must be available, information must be kept confidential and data knowledge must be trusted. Therefore, securing Oracle systems is more important now than ever. In this seminar, you'll learn features of Oracle security and how to use those features to configure the software to perform as expected yet prevent misuse. Also, you'll learn how to harden the entire Oracle environment - operating systems, application servers, programming code - the works.
[Return to Top]
U9: Oracle Performance Optimization Using Wait Interface
Speaker: Gaja Krishna Vaidyanatha, Veritas Software
Focus Area: Database Administration
Expertise: Beginner
Abstract:
Oracle performance tuning has developed a reputation as part science, part art, and part wizardry. This paper will impart the core principles of performance management by sharing a step-by-step process of iteratively investigating, determining, and implementing tuning solutions using a proven methodology. This time-tested and field-proven method looks at performance management as having a system-wide scope. It steers you away from the old bad habit of simply throwing more memory at Oracle's shared memory areas in response to performance problems. The core idea here is that, bulk of possible performance gains can be achieved quickly and with minimal effort, if you truly know how to identify your system's bottlenecks. This identification process will be done using the the Oracle Wait Interface, which is a set of V$ views and trace methods that reveal the exact source of of the bottlenecks in your Oracle database.
[Return to Top]
U11: Oracle9i RAC Configuration and Management
Speaker: Mike Ault, TUSC
Focus Area: Database Administration
Expertise: Intermediate
Abstract:
In this session the student will be taught the principles of parallel processing as they
apply to Oracle9i Real Application clusters. Following the introductory material, which lays the
foundation for good understanding of cluster technology, the session will show the installation, configuration,
management, tuning and troubleshooting of an Oracle9i RAC database. As a final topic the class will
cover the new advancements in Oracle10g Real Application Clusters. The session will draw on TUSC's
experience in the Oracle9i RAC field as well as recognized expert reference materials and Oracle
supplied documentation as source material.
U12: Java-based Oracle Web Development
Speaker: Brad Brown, TUSC
Focus Area: Application Server and Web Services
Expertise: Beginner
Abstract:
The goal of this presentation is to teach you the key things you need to know
in order to begin your walk into the world of Java-base development. This presentation will:
- explain why Java is a good choice
- compare Java and PL/SQL
- teach you how to use JDeveloper for your Java development
- cover Web Services, Java Server Pages, JAva Stored Procedures and JDBC.
By the end of this seminar you will be well on your way to staying ahead of the curve!
[Return to Top]
U13: Advanced DBA Best Practices
Speaker: Michael Abbey, The Pythian Group
Focus Area: Database Administration
Expertise: Advanced
Abstract:
DBAs' jobs are much simpler when they pay attention to detail and manage their repositories according to an advanced set of practices. Efforts invested in naming conventions for example have huge payoff down the road. I will look at issues related to monitoring 8i/9i/10g databases and mechanisms to put in place that make one's job easier.
U14: Managing Oracle OLAP
Speakers: Chris Claterbos and Mike Banasik, Vlamis Software Solutions
Focus Area: Data Warehousing and Business Intelligence
Expertise: Beginner
Abstract:
In Oracle9i, Oracle has separated the physical storage of data warehouse data from the logical analysis of OLAP applications. Physically, data can be stored in relational tables, or in Analytic Workspaces (multidimensional storage). Analytic Workspaces make possible all sorts of interesting business intelligence applications, such as collaborative budgeting, collaborative forecasting, predictive analysis, and modeling applications. All of this is now available within the Oracle9i database. With this new freedom comes new challenges in managing these tables and analytic workspaces. How are AWs updated? What is the best storage location for your data? When should the OLAP option be used? What are the major new capabilities in Oracle OLAP 10g and how does this affect the design of a data warehouse? We will discuss exactly that these mysterious Analytic Workspaces are. We will also present best practices and strategies pulled from a decade of experience with these analytic workspaces in their former life, as Express databases as well as multiple projects involving analytic workspaces. Attendees will see how Oracle tools such as Oracle Warehouse Builder, Oracle Enterprise Manager, Analytic Workspace Manager, and OLAP Worksheet can be used to manage the Oracle OLAP environment.
[Return to Top]
U15: Key 10g Features Oracle9i DBAs Need to Know
Speaker: George Trujillo, Trubix
Focus Area: Database Administration
Expertise: Intermediate
Abstract:
This high impact seminar will address how new features in Oracle 10g should be influencing how Oracle9i databases are managed. Enterprise management, scalability and growth, backup and recovery, tuning and data management will be covered.
U16: DBA's Introduction to Java
Speaker: John King, King Training Resources
Focus Area: Database Administration
Expertise: Beginner
Abstract:
Java has quickly become a standard tool for developers. Java's promise of write once, run anywhere is extremely attractive, if somewhat elusive so far. Application developers need to understand the basics of Java syntax, Java support for object-oriented programming, and the various types of Java programs to be developed. Oracle8i is designed to work with Java in many ways that will be introduced in an overview of Oracle8i's Java-oriented features. Using a series of examples and live demonstrations this seminar will introduce the basics of Java programming and program creation. Attendees will be prepared to create Java code and know how it fits into the overall scheme of Oracle application development.
[Return to Top]
|
