OUR VISION

To be the premier Information and Communications Technology (ICT) training and consulting services provider in the caribbean.

OUR MISSION

To improve the quality of knowledge and skills base of ICT professionals within the caribbean through the provision of competitive world-class ICT training and consulting services on current and emerging platforms.

MS 2779: Implementing a Microsoft SQL Server 2005 Database

Duration: 5 Days Instructor-Led

This five-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.

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

Prerequisites
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 Outline
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
Module 6: Implementing Views
Module 7: Implementing Stored Procedures and Functions
Module 8: Implementing Managed Code in the Database
Module 9: Using Service Broker

Print this page Print this page