Five Courses:

1.  Introduction to SQL Server 2005/2008 and Transact SQL
This class is a prerequisite for several other WWU SQL Server classes:

• MS Access to SQL Server 2005/2008
• SQL Server 2005/2008 for Developers
• SQL Server 2005/2008 for Administrators
• SQL Server 2005/2008 Performance Tuning (for Administrator and Developers)

Schedule:
Tuesday, January 5, 12, 19; 6 - 9 p.m. and
Saturday, January 23, 9 - noon and 1 to 4 p.m.

Description:
This course introduces the key concepts in relational database models and their implementation in Microsoft SQL Server. It focuses on developing the basic SQL server skills that are necessary for developers, administrators or people attempting to migrate data from access to SQL server. The following topics will be covered:

• Installing and using Microsoft SQL Server 2005 and 2008
• Foundations of Transact-SQL
• Creating Tables
• Constraints
• Joins and the relational database
• SQL Server Report Server (SSRS)

This course is a non-credit adult education course with a credit option for 1 credit. Individuals who can demonstrate a comprehensive knowledge, understanding and application of these concepts may contact the instructor to arrange to take an exam to waive this course.

Course Registration: $475
Optional 1 Credit: $50

Required Text and Materials:
Professional SQL Server 2005 Programming by Robert Vieira, Wiley Publishing (Wrox), 2007. ISBN: 978-0-7645-8434-3. (Alternatives currently being researched).
SQL Server 2005 Books Online (included with SQL Server, also available over the web).

2.  Moving from MS Access to SQL Server
This class has a prerequisite of Introduction to SQL Server 2005/2008 and Transact SQL or proof of equivalent experience.

This class is the second in a series of SQL Server 2005/2008 courses and is applicable to both developers and administrators. This course is not required, but may be helpful for students continuing on to the following courses:

• SQL Server 2005/2008 for Developers
• SQL Server 2005/2008 for Administrators
• SQL Server 2005/2008 Performance Tuning (for Administrator and Developers)

Schedule:
Tuesday, February 2 and 9, 6 - 9 p.m. and
Saturday February 13, 9 - noon and 1 to 4 p.m.

Description:
This course covers in detail the steps and processes involved in moving data and applications from Microsoft Access over to Microsoft SQL Server. The following topics will be covered:

• Class Overview, Access and SQL Server comparison and differences, Class Project Overview
• Access to SQL Server, Migrating Data, Applications and Users
• SQL Server to Access, SQL Server and Access working together
• SSRS, Presentation of Class Projects, Course Review

This course is a non-credit adult education course with a credit option for 1 credit.

Course Registration: $375
Optional 1 Credit: $50

Required Text and Materials:
Professional SQL Server 2005 Programming by Robert Vieira, Wiley Publishing (Wrox), 2007. ISBN: 978-0-7645-8434-3. (Alternatives currently being researched). SQL Server 2005 Books Online (included with SQL Server, also available over the web).

3.  SQL Server 2005/2008 for Developers
This class has a prerequisite of Introduction to SQL Server 2005/2008 and Transact SQL or proof of equivalent experience.

This class is the second in a series of SQL Server 2005/2008 for Developers classes.

1. Introduction to SQL Server 2005/2008 and Transact SQL
2. SQL Server 2005/2008 for Developers
3. SQL Server 2005/2008 Performance Tuning (for Administrator and Developers)

Note: Completion of the three courses is required to earn the SQL Server Developer certificate.

Schedule:
Tuesdays, February 23, March 2, 15, 23, 30 & April 6, 6-9 p.m.
and Saturdays, March 13 and 27, 9-noon & 1-4 p.m.

Description:

• The following topics will be covered:
• Class Overview, TSQL Review, Class Project Overview
• Parameterized Queries, Functions and Stored Procedures. Error Handling. Data Types
• Transactions, Cursors, Triggers. Advanced DML
• Rolling a database to production
• Going with the flow: Understanding queries, reading query execution plans
• Aggregates, unions, cross joins, self joins. XML in Transact-SQL
• Full-Text Searching. More advanced Transact-SQL
• Data In - Data Out: Integrations Services, Builk Copy, Scripting, Replication overview
• Defensive programming against SQL Injection
• Presentation of Class Projects, Course Review

This course is a non-credit adult education course with a credit option for 3 credits.

Course Registration: $950
Optional 3 Credits: $150

Required Text and Materials:
Professional SQL Server 2005 Programming by Robert Vieira, Wiley Publishing (Wrox), 2007. ISBN: 978-0-7645-8434-3. (Alternatives currently being researched). SQL Server 2005 Books Online (included with SQL Server, also available over the web).

4.  SQL Server 2005/2008 for Administrators
Course details under development

Schedule:
Tuesdays, April 13, 20, 27, May 4, 11, 18; 6 - 9 p.m. and
Saturdays, April 24 and May 1 9-noon & 1-4 p.m.

Course Registration: $950
Optional 3 Credits: $150

5.  SQL Server 2005/2008 Performance Tuning for Administrator and Developers
Course details under development