Home
Community
Events
Evening Workshops
Training
Resources
Library
How Can I?
Code
Samples
Presentations
Links
Book Reviews
Downloads
User Groups
General
Contact Us
About Us
Legal Notices | Terms of Use
Privacy Statement |
|
Evening Education Workshops |
New releases of Oracle's software isn't like that of some other
companies 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 |
Interviewing
There is a lot more to being competitive in the current
job market than have a four year degree or being able to
white-board a full-outer join. This three hour workshop is
a safe environment in which to learn the best techniques
and to enhance your soft skills.
Sarbanes-Oxley
Compliance and Fine Grained Auditing
There are a lot of reasons why our industry is changing
and why we must keep acquiring new skills. One of the new
ones is changes in the legal landscape. This workshop will
cover the basics of Sarbanes-Oxley, HIPAA, and FACTA. Then
we will cover Fine Grained Auditing and other technologies
built into the 9i and 10g databases that will allow you to
make sure your projects comply.
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.
|
|
