Home
Hosts
NWOUG
OAUG
PSNWRUG
PSOUG
Sponsors
Platinum
Gold
Silver
General
Contact
Legal Notices | Terms of Use
Privacy Statement
|
Three days of
classes taught by internationally recognized
subject-matter experts including Oak Table members
and Oracle Aces.
Click on the title for the class
syllabus.
Click on the presenter's name for a copy
of their bio.
|
|
|
| SQL for Smarties -
Joe Celko (1 day class) - $250
|
|
|
SQL
For Smarties
Joe, a member of the ANSI SQL committee from
1992 to 2007 is one of the world's leading
experts on the SQL language and how to
maximize its effectiveness.
Joe last
visited us in 2007 and we have had numerous
requests to have him return and share his
wealth of knowledge with our region's
developers. |
|
|
|
| Writing Optimal
PL/SQL For Web Applications - Paul
Dorsey (2 day class) - $500
|
|
|
|
|
| Advanced Oracle
Internals - Richard Foote (2 one day
class) - $375 each
|
|
|
An in-depth Oracle Internals presentation on Indexes.
Covered will be on all things Oracle indexes (B*Trees, Bitmaps, Context, Linguistic, IOT, Clustered
Indexes, etc), on all options (Reverse, Compressed, Partitioned,
Function-Based, Invisible, etc) in lots of detail covering lots of
internals, tricks, traps and practical examples that one just won't find
in general Oracle books and courses. I'll also importantly cover how the
CBO treats, costs and uses these indexes when determining optimal
execution plans. |
|
|
|
| Storage Techniques, Effective Indexing, and Reorganizing Objects -
Tom Kyte (1 day class) - $250
|
|
|
This
is a very special treat for our members and
guests and we are thrilled to be able to
present it to you. Tom is going to spend an
entire day covering, in depth, three separate
topics. Below are the three titles. Those
registering for this class will attend all
three for one low price.
Storage
Techniques:
How data is stored on disk by Oracle directly
affects the speed at which we can retrieve
that data (and modify it, and create it and so
on). This session will look at the physical
structures available to us, discuss when to
use each (and when not to!). Techniques such
as clustering, index organized storage,
partitioning, and compression will be
investigated.
Effective
Indexing:
Indexing is a large and somewhat ignored
topic. We all know that "indexes are
good," but what kind of index is
appropriate, and under what circumstances? How
does the type of index affect us? What are the
considerations you want to be thinking of when
coming up with your indexing scheme? This
session will explore these topics as well as
explore the physical structures underlying
each discussed index type.
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.
|
|
|
|
| Optimizing Oracle -
Jonathan Lewis (2 day class) - $1000
|
|
|
Curriculum
will be posted soon |
|
|
|
| Optimizing Oracle
Stats Pack - Jonathan Lewis (1
day class) - $500
|
|
|
Curriculum
will be posted soon |
|
|
|
|
Programming the Oracle database using Java, JDBC and Web
Services -
Kuassi Mensah
(2 day class) - $500
|
|
|
Audience: Java developers, Database developers, DBAs, Data architects, SOA and Web Services assemblers.
Level: Intermediate and Advanced
Duration: 2 days (Courses and Hands-on Labs)
Class Outline:
----------------------
Oracle JDBC - Crash Course
- Overview of JDBC Specifications: from JDBC 1.22 to JDBC 4.0
- JDBC URL, DataSource and Connection: Connection Caching, Connection Wrapping, Proxy Authentication
- Statement, PreparedStatement, CallableStatement, Statement Caching, DML batching
- Manipulating SQL Data types using JDBC: LOB, OPAQUE, XMLTYPE, Object Type, Ref type, VARRAY, NESTED TABLE, SQLData, ORAData, etc.
- Result Set: Scrollable, Updatable, Prefethcing, Changes and Visibility
- RowSet (JSR-114): What for?, JdbcRowSet, CachedRowSet, WebRowSet, FilteredRowSet, JoinRowSet
- RAC Support: Fast Connection Failover, TAF, Runtime Connection Load Balancing
- JDBC Best Practices
Java in the Database - Crash Course
- Stored Procedures as Database Programming Model: Why, What for, PL/SQL or Java?
- OracleJVM Life Cycle: Install/Uninstall,
- OracleJVM Internals: Memory management, Threading, Security,
- Performance: Java Execution in the database, NCOMP
- Developing and Running Java in the Database: loadjava, Call Spec, Type Mapping, Invoking Java in the database
- Pragmatic Applications: RMI Callout, HTTP Callout, CORBA/EJB Callout, SAP Callout, Web Services Callout, JDBC Callout
- Database Scripting: JACL, JYTHON, SCHEME, GROOVY
Database Web Services and SOA – Crash Course
- Web Services and SOA for DBA, Data Architects, and Others
- Database as Web Services Provider: PL/SQL Web Service, JDeveloper Wizard, Web Services Assembler, Data Types, SOA Quality of Services
- Database as Web Services Consumer: WSDL, JPublisher, Web Services Callout Utility
- Wrap Up – Q & A
|
|
|
|
Programming the Oracle database with PHP -
Kuassi Mensah
(1/2 day class) and
Programming the Oracle database with Ruby on Rails -
Kuassi Mensah
(1/2 day class) -$250
|
|
|
Attendees will learn: how to install Ruby on Rails with Oracle; using
Ruby to make a connection to Oracle database; making queries with Ruby;
bind variables; define datatypes; creating and managing transactions;
using PL/SQL with Ruby; using LOB to store and retrieve images; using
XML; using ActiveRecord; creating applications using the Rails framework;
handling OR relationships between tables. |
|
|
|
| Oracle
cross-training for DB2, Informix, SQL Server,& Sybase Professionals -
Dan Morgan (2
day class) - $500
|
|
|
Oracle
cross-training for DB2, Informix, SQL Server, and
Sybase Professionals
Morgan has been cross-training DB2, Informix, SQL
Server and Sybase developers and DBAs, in
Oracle, for years as part of the Oracle program
at the University of Washington and through the
PSOUG's many outreach activities. This intensive class
will focus on building on non-Oracle skill sets to
gain an understanding, and working knowledge, of
Oracle 10g and 11g.
|
|
|
|
| Fusion Middleware -
Chris
Ostrowski (2 day class) - $500
|
|
|
|
|
| Identity Management
- Chris
Ostrowski (1 day class) - $250
|
|
|
|
|
| Maximum
Availability Boot Camp (RAC, Data Guard, and ASM) -
Caleb Small (3 day class) - $1500
|
|
|
|
|
| E-Business Suite -
John Stouffer (3 day class) -$750
|
|
|
|
|
| Oracle Support
Services (1
day) - David
Warhoe (1 day class) - No Charge
|
|
|
|
|
| Breaking Oracle (1
day) - Jeremiah Wilton
(1 day class) - $250
|
|
|
You
can't fix it if you can't practice. But how do
you practice for something that you can't
produce, and reproduce, in a test environment?
Jeremiah's
unique experience as the founding member of
Amazon.com's DBA team, and his devotion to
research, make him uniquely qualified to teach
you how to break the Oracle database, triage
the problem, and fix it. This is a unique
opportunity to learn skills not taught
anywhere else. |
|
|
