|
Get Started
The Autumn 2009 program is no longer accepting applications
Next program starts: Autumn 2010
Details will be posted in Spring
Single courses may be available
|
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: (3 classroom sessions and 3 online sessions) Saturdays, 10:00 a.m.-4 p.m. with 1 hour lunch break, Oct. 10, 24; Nov. 7, 21; Dec. 5, 12, 2009; $719; 3 CEUs. Instructor: Buck Woody
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) Tuesdays, 6:00-9:00 p.m., Jan. 5-Mar. 9, 2010; $719; 3 CEUs. Instructor: TBD
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) Tuesdays, 6:00-9:00 p.m., March 30-June 1, 2010; $719; 3 CEUs. Instructor: Mark Pohto
This course will cover administration SQL Server 2008 servers in an enterprise environment. You will learn how to install, configure, secure, and monitor SQL servers. In addition, you will learn how to create a backup strategy and understand high availability options.
Topics:
- Installation and configuration
- SQL Server Internals
- Security
- Disaster recovery
- Performance tuning
- High availability
- Architectures
- Virtualization
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
