Home » Training Courses » Microsoft Certified Training » 2779 - Implementing a Microsoft SQL Server 2005 Database Training

2779 - Implementing a Microsoft SQL Server 2005 Database Training

5 days - £1500 + vat

Course code - 2779

This five-day instructor-led course provides students with the knowledge and skills 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.

Course Objectives:

At the end of this Microsoft Implementing a Microsoft SQL Server 2005 Database course participants will be able to:

• 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.
• Implement data integrity in Microsoft SQL Server 2005 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.
• Use Notification Services to generate and send notifications.

Course Content:

• Module 1: Creating Databases and Database Files
• Module 2: Creating Data Types and Tables
• Module 3: Using XML
• Module 4: Creating and Tuning Indexes
• Module 5: Implementing Data Integrity by Using Constraints
• Module 6: Implementing Data Integrity by Using Triggers and XML Schemas
• Module 7: Implementing Views
• Module 8: Implementing Stored Procedures
• Module 9: Implementing Functions
• Module 10: Implementing Managed Code in the Database
• Module 11: Managing Transactions and Locks
• Module 12: Using Service Broker
• Module 13: Using Notification Services (Optional)

Course Pre-requisites:

This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for implementing a database.

Before attending this course, students must have:

• 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.

In addition, it is recommended, but not required, that students have completed:

• Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL
• Course 2780: Maintaining a Microsoft SQL Server 2005 Database

Microsoft Certification Exams:

This course prepares delegates for the 70-431 Microsoft SQL Server 2005 - Implementation and Maintenance exam

When you pass Exam 70-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance, you complete the requirements for the following certification(s):

• Microsoft Certified Technology Specialist: SQL Server 2005

This exam can also be used as credit towards the following certifications:

• Microsoft Certified Systems Administrator (MCSA) - on Windows Server 2003
• Microsoft Certified Systems Engineer (MCSE) - On Windows Server 2003

SQL Server 2005 Database Training Courses Recommended Reading

SQL Server 2005 Database Essentials Step by Step by Solid Quality Learning - buy from amazon

 

Download course outline as pdf.

Share This