SQL Server 2008

Campaign Dates

Dec. 10, 2008 – December 31, 2009 (while supplies last)

SQL Server 2008 Software Availability

SQL Server software is available for the following courses:

• 2778 - Writing Queries Using   Microsoft® SQL   Server™ 2008   Transact-SQL
• 6158 - Updating Your SQL 2005   Skills to SQL Server     2008
• 6231 - Maintaining a   Microsoft® SQL   Server™ 2008   Database
• 6232 - Implementing a   Microsoft® SQL   Server™ 2008    Database
• 6234 - Implementing and   Maintaining Microsoft®   SQL Server™ 2008 Analysis Services
• 6235 - Implementing and   Maintaining Microsoft®   SQL Server™ 2008   Integration Services
• 6236 - Implementing and   Maintaining Microsoft®   SQL Server™ 2008   Reporting Services
• 6317 - Upgrading Your SQL   Server 2000 Skills to   SQL Server 2008

About the Free Software

• SQL Server 2008 Standard Edition – Full software
• 1 CAL (Client Access) license
• 32 bit, 64 bit and IA64 versions included
• Software will be English only at this point 
• Shipped in a "White sleeve" version worldwide (similar to our Windows Server 2008 Free Software offer)

About this Course

These instructor-led courses provide students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The courses focus on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.

Audience Profile

These courses are intended for IT Professionals who administer and maintain SQL Server databases.

At Course Completion

After completing these courses, students will be able to:

• Create databases and database files.
• Create data types and tables.
• Use XML-related features in Microsoft SQL Server 2008.
• Plan, create, and optimize indexes.
• Implement data integrity in Microsoft SQL Server 2008 databases by using constraints.
• Implement data integrity in Microsoft SQL Server 2008 by using triggers.
• Implement views.
• Implement stored procedures.
• Implement functions.
• Implement managed code in the database.
• Manage transactions and locks.
• Use Service Broker to build a messaging-based solution.