Nearly every software application uses some form of database as its means of storing data – and the database of choice is often Microsoft SQL Server. Efficient use of SQL Server requires careful thought and an understanding of its capabilities. This course is designed to give application developers a thorough grounding in best practices for SQL Server database development.

This certificate program is designed for up and coming database professionals. Each course in the certificate provides practical concepts and tools for the SQL Server Specialist. The project-driven / real world content enables course participants to work on smaller applications as well as a longer database project that may span the full course sequence. Course fees include the SQL Server 2005 Training Kit with books and CDs, one state-of-the-art lab station per person, and access to SQL Server for class projects and assignments. By the end of the second course, class participants should be prepared to take both the Microsoft Certification Exams 70-441 and 70-442.

Course Descriptions [click here for course descriptions]
Fall 2008: SQL Server Development Essentials 101
Winter 2009: SQL Server Advanced Development

By the end of this program, SQL Server Development Specialists will:

• Understand data modeling and how to implement a data model in SQL Server
• Utilize the primary features of Transact-SQL to insert, update, extract and delete data from a SQL Server database
• Implement stored procedures, functions, and views
• Enforce data integrity through indexes, constraints, triggers
• Store and manipulate XML data in a SQL Server database
• Utilize tools for transferring and transforming data (SSIS)
• Be prepared to take the Microsoft Certification Exams 70-441 and 70-442

The SQL Server Development Specialist Program is designed for:

• Businesses, nonprofit organizations, government agencies or educational institutions seeking expertise in developing a database application
• IT professionals considering SQL Server Database Developer certification
• Developers wishing to increase their understanding of database principles and specifically the tools in SQL Server that streamline application development
• DB administrators looking to support the programming of data stores for web- or desktop-based applications