Implementing a Microsoft SQL Server 2005 Database

Course Objective

	In-House Training for as few as 3 Attendees >> Or Call Toll Free 1-866-313-5768

SQL Server 2005 is a landmark release of Microsoft’s powerful relational database management system for the Windows platform. It will change the way you architect your data systems and develop your data driven applications

This Three-day instructor-led course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.

What you will learn

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

Who should attend

• IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database.

Prerequisites

• Basic knowledge of the Microsoft Windows operating system and its core functionality
• Working knowledge of Transact-SQL
• Working knowledge of relational databases
• Some experience with database design

Onsite Training  Class Schedule  Registration