Microsoft Certified Technology Specialist (MCTS): SQL Server 2005

Select Industry/Course: Select Course CompTIA Security+ Microsoft Certified Desktop Support Technician (MCDST) Microsoft Certified Systems Administrator (MCSA) Microsoft Certified Systems Engineer (MCSE) Microsoft Certified Technology Specialist: Windows Vista, Configuration Microsoft Certified Technology Specialist: Microsoft Exchange Server 2007, Configuration Sun Certified Java Associate (SCJA) Sun Certified Java Professional (SCJP) J2EE Framework Sun Certified Web Component Development (SCWCD) Cisco Certified Entry Networking Technician: Interconnecting Cisco Networking Devices Part 1 (ICND1) Cisco Certified Network Associate: Interconnecting Cisco Networking Devices Part 2 (ICND2) CompTIA A+ CompTIA Network+ Cisco Certified Network Professional: Building Scalable Cisco Internetworks (BSCI) Microsoft Certified IT Professional: Database Developer Cisco Certified Network Professional: Building Cisco Multilayer Switched Networks (BCMSN) Microsoft Exchange Server 2007, Configuration Microsoft Certified IT Professional (MCITP): Database Developer Microsoft Certified IT Professional (MCITP): Enterprise Administrator Microsoft Certified IT Professional (MCITP): Server Administrator Microsoft Certified IT Professional (MCITP): Enterprise Support Technician Microsoft Certified IT Professional (MCITP): Database Administrator Microsoft Cetified Technology Specialist (MCTS): Microsoft SQL Server 2008, Database Development Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation & Maintenance Microsoft Certified Technology Specialist (MCTS): .NET Framework 3.5 ASP .NET Applications Microsoft Certified Technology Software (MCTS): .NET Framwork 3.5 ADO.NET Applications

Course Schedule & Online Registration

If you are an individual, please click here.

Target Audience

IT Professionals who wish to increase their proficiency level on SQL Server 2005 product features and technologies to prepare themselves for the implementation of databases.

Course Overview

At the end of the course, trainees will learn how to implement and maintain databases. Trainees will also be equipped with thorough knowledge of the product through the use of SQL tools and Transact-SQL language.

Course Duration

70 hours / 10 days exclude examination hours

Assessment

Required exams for MCTS:SQL 2005 (1 exam required)	Classroom Training
Exam 70-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance	Course 2779: Implementing a Microsoft SQL Server 2005 Database (five days) and Course 2780: Maintaining a Microsoft SQL Server 2005 Database (five days)

Course Outline

Implementing a Microsoft SQL Server 2005 Database

• Course Code: 2779
• Exam Code: 70-431
  • 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 and triggers.
  • Implement views, stored procedures, functions and 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

Pre-requisites

MCAD/MCSD/ MCSA/MCSE/2780

Course Location

NTUC LearningHub Pte Ltd
International Plaza (near Tanjong Pagar MRT)
10, Anson Road #06-18
Singapore 079903

Certification

Microsoft Certified Technology Specialist (MCTS): SQL Server 2005

Enquiry

Type of enquiry Corporate Individual

Company Name

Name *

Contact No *

Email *

Preferred Contact Email Telephone Call Morning Noon Evening

Questions & Comments

Enter characters displayed

* Mandatory fields

Our Partners