Overview  |   Courses  |   Instructors  |   Advisory Board  |   How to Apply

Course Descriptions

The 2008-2009 program is underway and is no longer accepting applications Single courses may be available Next program starts: Autumn 2009 Details will be posted in Spring Program location: Online + Classroom (Downtown Seattle) Combined (see details >>) Sign up to receive e-mail updates >> Contact a program representative >>

Interested in taking a single class? Some courses (designated by a below) may be open on a space-available basis to professionals who are not seeking the certificate. See Single-Course Enrollment for details.

Autumn Course

Database Essentials with Oracle

Schedule: (5 classroom sessions, 5 online sessions) Wednesdays, 6:00-9:00 p.m., Oct. 8-Dec. 17, 2008; $669 (no meeting on Nov. 23); 3 CEUs..
Instructor: Robert Perry

Participants learn the basics of Oracle's database concepts and architecture, installation and configuration in UNIX and Windows environments, best practices, SQL tuning, and using Oracle to manipulate data. Topics:

• Basic logical and physical database constructs
• Basic Oracle installation and configuration
• Working with SQL*Plus
• Data dictionary basics
• Creating and managing tablespaces
• Creating and managing heap, IOT, and partitioned tables
• B*Tree, bitmap, compressed, descending, reverse, and no-segment indexes
• Creating and utilizing constraints (primary keys, foreign keys, unique constraints, check constraints)
• Creating and utilizing sequences to generate surrogate keys
• Creating and utilizing views and materialized views
• Creating and utilizing aliases and synonyms
• Using SQL to Insert, Update, Delete, and Select
• Working with multi-table joins
• Working with the SQL WHERE, GROUP BY, HAVING and ORDER BY clauses
• SQL statement tuning with AUTOTRACE, DBMS_XPLAN, EXPLAIN PLAN, and TKPROF
• Working with single-row and aggregating group functions
• Working with subqueries
• Working with built-in string, numeric, and date functions

Winter Course

PL/SQL Programming with Oracle

Schedule: (5 classroom sessions, 5 online sessions) Wednesdays, 6:00-9:00 p.m., Jan. 14-Mar. 18, 2009; $669.
Instructor: Dan Morgan

Participants extend their skills from the first quarter and learn to build their own functions, procedures, packages, operators, and triggers to write their own database back-end programs. Topics:

• Understanding database blocks
• Writing and passing parameters with stored procedures and functions
• Writing package headers and bodies and package initialization
• Writing table, instead-of, DDL event, and System event triggers
• Creating and using static and dynamic cursors (ref cursors)
• Array processing and bulk binding
• Working with Dynamic SQL: Both Native and DBMS_SQL
• Working with loops and logical control structures
• Exception handing in PL/SQL objects
• Working with pragmas including autonomous transaction, serially_reusable, and exception_init
• Work with Oracle's build-tin packages including Advanced Rewrite, DBMS_WARNING, and UTL_FILE
• Tuning and Debugging functions, packages, procedures, and triggers

How to sign up for individual enrollment in this course

Spring Course

Built-in Packages and Database Management

Schedule: (5 classroom sessions, 5 online sessions) Wednesdays, 6:00-9:00 p.m., Apr. 8-June 10, 2009; $669.
Instructors: Dan Morgan and Jeremiah Wilton

Participants learn advanced Oracle technologies essential for a future in high-end database development and DBA opportunities. This course provides hands-on experience building database front-ends with tools and advanced techniques involving the latest database features. Topics:

• Advanced Queuing
• Change Data Capture and Streams Replication
• Data Guard Replication for disaster recovery
• Fine Grained Access Control (Virtual Private Database)
• Fine Grained Auditing
• Real Application Clusters
• Recovery Management (RMAN)

How to sign up for individual enrollment in this course