www.TheComputerTrainers.com

---

Microsoft SQL Server 2005 Administration

 

Audience:  This five-day instructor-led course provides students with product knowledge and skills needed to implement and maintain 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 and maintaining a database.  This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing and maintaining 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

Syllabus:  This course will incorporate both real-life labs, and instructor-led lectures.  The course will run for five days, from 8:30 am to 4:30 pm. After completing this course the student should 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, triggers, and XML schemas.

·         Implement views.

·         Implement stored procedures and functions.

·         Implement managed code in the database.

·         Install and configure SQL Server 2005

·         Manage database files.

·         Manage security.

·         Perform administrative tasks.

·         Back up databases.

·         Restore databases.

·         Monitor SQL Server.

·         Troubleshoot SQL Server

·         Transfer data.

Instructor: Microsoft Certified Trainer

Dates: July 14^th – July 18^th, 2008; 8:30am – 4:30pm.

Cost: This course is priced at $2499.00 per person which includes the training material.

Contact: Val Dow at 343-2112, or e-mail val@thecomputertrainers.com

 

 

Note:  Course is subject to change according to available course material.