Home
Maximum Availability Series
Automated Storage Management (ASM)
Data Guard
Dynamic Reconfiguration
Flashback
Grid Control
Online Redefinition
Real Application Clusters (RAC)
Resumable Transactions
DBA Series
11g New features for DBAs
Audit Vault
Disaster Prevention and RMAN
Managing Terabyte Databases
Oracle Security Workshop
Sarbanes-Oxley & HIPAA Compliance
Developer Series
11g New Features for Developers
Advanced Queuing and Streams
Array Processing and Bulk Binding
Exception Handling
Oracle Forms
Procedures, Functions, & Packages
Security and Fine Grained Access Control
SQL and PL/SQL Tuning
SwingBench Installation & Configuration
Triggers
Fusion Middleware Series
Oracle Application Server
Oracle Identity Management
Independent Classes
Interviewing and Hiring Oracle Pros
Oracle for DB2/UDB DBAs & Developers
Oracle for Informix DBAs & Developers
Oracle for SQL Server DBAs & Developers
Oracle for Sybase DBAs & Developers
UNIX, Linux and vi
Evening Workshops
Constraints
Exception Handling
Functions & Pipelined Table Functions
Interviewing
Linux and UNIX Skills
Loops Cursors and Array Processing
Materialized Views
New Objects
Partitioning
Sarbanes-Oxley - HIPAA Compliance
Triggers
Tuning SQL and PL/SQL
Writing PL/SQL Packages
Writing Stored Procedures
|
|
New Objects
In Oracle 11g
|
 |
I've been working with Oracle since
version 6 or 7 ... I know all of the basics.
Except perhaps:
- Virtual Columns
- Invisible Indexes
- Compound Triggers
- Follows Clause
- New PL/SQL syntax for
sequences
- New warnings with
DBMS_WARNING
- Flashback Archives
- bdump and udump are gone
Or the list of objects, to
the left, all installed with 11g and owned by SYS.
|
|
The PSOUG's 11g New Objects
workshop focuses on some of the most useful new objects:
When, where, and how to use them.
Oracle has added many new
types of objects, and many variations on familiar types of
objects. It is no longer sufficient or appropriate to
treat every need to store data as a heap table, every
index as a B*Tree index, every requirement as something
that can, and should, be solved using Neolithic
technology.
This 3 hour, hands-on,
evening workshop is only $100/person.
|
|
|
|
Syllabus
|
| 5:45-6:00pm |
Introductions |
Join us for coffee
before class begins.
To attend a workshop you must register at least
one day in advance. |
| 6:00-6:15pm |
Topic
1 |
Introduction
The introductory session focuses on reviewing the
changes Oracle has made to the panoply of object
types available and the importance of developing a
working knowledge of the wealth of features
available. |
| 6:15-7:15pm |
Topic
2 |
Tables
and Indexes
xxx |
| 7:15-8:00pm |
Topic
3 |
Sequences
and PL/SQL Extensions
xxx |
| 8:00-9:00pm |
Topic
4 |
Flashback
Archive
xxx
|
|
|
Instructors |
Jack Cline is the chairman of the Puget Sound Oracle Users Group and has done Oracle contract work in the Puget Sound area for the past 11 years including engagements at Boeing, Bank of America, King County, the City of Seattle, Puget Sound Energy, and the Seattle-King Country Department of Health. He is a frequent guest lecturer at the University of Washington's Oracle Certification Program.
Dan Morgan is an Oracle Ace Director, a
10g and 11g Beta tester for Oracle, and the instructor of
the Oracle program at the University of Washington since
its inception in 1999. He began his IT career in 1969 with
an IBM 370/145, punch cards, and Fortran IV, and though he
will vigorously deny it, wrote COBOL for a decade before
moving into Oracle about when version 6 hit the market.
In addition to Dan's work at the university he is the
Education Chair of the Puget Sound Oracle Users Group, a
member of UKOUG, and a member of the British-American
Chamber of Commerce in Seattle. He is also a frequent
lecturer at training events and at conferences and has
presented at Oracle OpenWorld on RAC (2005), at Seattle
OracleDay (2004-2007), at numerous government and
corporate training events including Apple Computer,
Argonne National Laboratory, Boeing Commercial Airplane
Group, Dow Jones & Company, Lawrence Livermore
National Laboratory, NASA, T-Mobile, US Navy at Pearl
Harbor, and Weyerhaeuser to name but a few and presented
on Streams and Change Data Capture at UKOUG in 2006.
Dan Morgan is the Morgan behind the "Morgan's
Library" website that contains the many demos he has
created for his University of Washington classes as well
as for his frequent lectures. He is the former publisher
of MacTech Journal, has presented Oracle technical
lectures in the US, Canada, Great Britain, and Japan.
Morgan is also the author of this course.
|
|
