Overview  |   Courses  |   Instructors  |   How to Apply

Course Descriptions

Currently accepting applications Apply now >> Next program starts: Autumn 2008 Program location: Online + Classroom (Downtown Seattle) Combined (see details >>) Sign up to receive e-mail updates >> Contact a program representative >>   Program at a glance >>

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 Quarter

SQL Server Essentials: Concepts and Tools

Schedule: (5 classroom sessions and 5 online sessions) Wednesdays, 6-9 p.m., Oct. 1-Dec. 10, 2008 (no class November 26); $669; 3 CEUs. Instructor: Mary Sweeney

The first course will introduce SQL Server. Topics included will involve relational database concepts, SQL programming, SQL Server tools, as well as introduce topics that will be presented in more detail in subsequent courses.

Topics:

• An overview of business intelligence and requirements gathering
• Review of structured query language (SQL), including data definition language (DDL), data manipulation language (DML), data control language (DCL)
• Transaction processing vs. decision support
• Record locking
• Scripting concepts
• Indexing
• Optimization basics
• Permissions
• Architecture basics (storage, notification, caching)
• Base Table Integrity & constraints
• Query Analyzer & Enterprise Manager (2000) vs. Management Studio (2005)

Prerequisites: database design and relational database theory; basic SQL; some exposure to a database software product; familiarity with general programming concepts.

How to sign up for individual enrollment in this course

Winter Quarter

Database Development

Schedule: (5 classroom sessions and 5 online sessions) Wednesdays, 6-9 p.m., Jan. 7-Mar. 11, 2009; $669; 3 CEUs. Instructor: Sylvia Vargas

Focuses on actual development of a more sophisticated database application. The distinction between application (UI) and database development is examined, along with programming concepts, views, security issues and reporting.

Topics:

• Triggers
• ANSI and T-SQL
• User-defined functions
• User-defined types
• Views
• Security
• 3 layers of application development
• Interoperability with .NET common language runtime
• Report creation

Prerequisites: database design and relational database theory; basic SQL; some exposure to SQL Server and the concepts discussed in the first course; familiarity with general programming concepts.

How to sign up for individual enrollment in this course

Spring Quarter

SQL Server Administration

Schedule: (5 classroom sessions and 5 online sessions) Wednesdays, 6-9 p.m., Apr. 1-June 3, 2009; $669; 3 CEUs. Instructor: Steve Harrell

Covers administration topics of interest to developers and DBA's, plus project work.

Topics:

• Backup and restore
• Security
• User accounts
• Performance tuning and optimization
• Alert automation
• Hardware influence on performance
• Report distribution
• High availability and disaster recovery
• Defining ETL and dataflow
• Analysis services and data warehousing
• Additional resources and e-learning
• Reporting services

Prerequisites: design and relational database theory; basic SQL; some exposure to SQL Server and the concepts discussed in the first course; familiarity with general programming concepts.

How to sign up for individual enrollment in this course