Home
Community
Events
Training
Evening Workshops
Resources
Library
How Can I?
Code Samples
Presentations
Links
Book Reviews
Downloads
User Groups
General
Contact
About
Services
Legal Notice & Terms of Use
Privacy Statement |
| Evening Education Workshops |
New releases of Oracle's software isn't like that of some othercompanies where they just repackage
essentially the same feature set with a new GUI. Each new release provides us with a substantial set of new capabilities and changes what
constitutes "best practice."
Whether your skill set is beginner or expert there is almost no one who has ever heard their employer say "Oracle just put out a new release
... why don't you take the next six months to study it in your lab." and as Tom Kyte often says "no one of us knows as much as all
of us."
To support our members and our community we have designed a series of hands-on 10gR2 workshops to make it easy for everyone to improve and expand
their skills. And each workshop designed to be easily accessible for beginners and yet contain hard hitting content of value for experts.
Review the following syllabus and consider how these workshops would benefit you and your team. |
|
All Evening workshops are only $100 per person
|
|
SQL |
10g
and 11g New Objects
An Oracle database consists of a lot more things than
tables and indexes. In the last two major releases we have
seen the importance of new object types including
contexts, directories, external tables, global temporary
and index organized tables, object view, and much more.
Constraints
Perhaps you have been building tables with constraints for years; perhaps not.
But would you know when to build this?
ALTER TABLE person
ADD CONSTRAINT fk_person_state_zip
FOREIGN KEY (per_state, per_zip)
REFERENCES state_zip (state, zip_code)
INITIALLY DEFERRED DEFERRABLE;
|
And this is just one example
of among many that will be covered.
ISO and ANSI Joins
Those of us who have worked with the Oracle RDBMS are very
familiar with the ISO join syntax where an inner join uses
= in the WHERE clause, and a simple (+) changes it into an
outer join. This syntax has been valuable ... but it has
known deficiencies addressed by the ANSI syntax added with
9i. Join us and learn how to use the new capabilities
including FULL JOINS and NATURAL JOINS. Do you understand
what these two examples do? How about some of your
co-workers?
SELECT
p.last_name, t.title_name
FROM person p FULL OUTER JOIN
title t
ON p.title_1 = t.title_abbrev;
SELECT COUNT(*)
FROM cartesian c, product p
WHERE c.join_column !=
p.join_column; |
Materialized Views
Understanding materialized views and query rewrite are critical developer skills: Especially when working with Decision Support and Data Warehouses.
|
SQL Tuning with Autotrace, Explain Plan, and DBMS_XPLAN
Tuning DML should not be an exercise in random events of which one of them, hopefully, will result in an improvement.
In 9i and 10g Oracle has added many new tuning features for developers and DBAs. If you don't recognize this statement ... this workshop is for you.
|
|
SELECT * FROM TABLE(dbms_xplan.display
('PLAN_TABLE','abc','ALL')); |
|
| PL/SQL |
Cursor Loops
and Array Processing
Cursor loops and single row fetches became obsolete in Oracle 9i. If you are still using them you are writing
inefficient code. Join this workshop to learn how to give up cursor loops for good. We will cover array processing,
bulk binding, FORALL statements, exception handling, and working with a sparse matrix.
Exception
Handling
Exception handling is a critical skill and goes far beyond
the ability to write WHEN OTHERS THEN. Exception handling,
properly implemented, will tell you not just what broke
but where, when, why, and how the code was called.
Triggers
This workshop is designed for those with a basic understanding of tables, constraints, and indexes that
would like to learn how to write table triggers for referential integrity, data modification, and auditing. We
will cover STATEMENT and ROW LEVEL triggers, BEFORE and AFTER triggers, the :NEW and :OLD environment variables,
the OF clause, and the CASCADING and MUTATING trigger errors.
We also cover DDL and SYSTEM event triggers.
Writing and Debugging Packages
The optimum way to implement your functions and procedures
into the Oracle database is with built-in packages. This
workshop covers the importance of packages and the
value-added including overloading, serial reusability, the
initialization section, defining global variables,
constants, and data types, and more.
Writing and Debugging PL/SQL Functions
If you haven't been writing your own functions, including PIPELINED TABLE FUNCTIONS this workshop is for you. We
will cover parameter passing and notation, parameter defaults, definer rights, and how to test and debug the
functions you've written.
Writing and Debugging Stored Procedures
If you haven't been writing your own procedures this workshop is for you. We will cover parameter passing and
notation, parameter defaults, definer rights, NOCOPY and how to test and debug the procedures you've written. |
| General |
UNIX and Linux Basics
Have you reached that point in your career where you've
hit our industry's glass ceiling? The one that stops those
whose experience doesn't include UNIX and Linux? If you
want to get over your fear and learn to love vi and grep
this workshop is for you. No prior experience in a
terminal window is required.
We will do a hands-on Linux installation, navigate the
file system, create users and alter permissions, create
and drop directories and files, move and copy files, alter
kernel parameters in preparation for a database
installation, learn to use some basic tools such as and
even write a few basic shell scripts. |
| Custom Workshops |
| Didn't see what you wanted? Please contact Dan Morgan and let him know of your interest.
Moving from DB2, Informix, SQL Server, or Sybase to Oracle? We have retraining classes too.
|
|