MCTS: Microsoft SQL Server 2005: - Implementation & Maintenance (MS2779+MS2780) Training/Course Singapore


	+PC Assembly / Networking / Server / Linux - CompTIA A+ - CompTIA Network+ - CompTIA Server+ - CompTIA Linux+ - CompTIA Security+ - IC3 Computer Fundamentals - IC3 Living Online

	+CISCO - CISCO CCNA - CCNA Security - CCNA Voice - CCNA Wireless - CISCO CCNP - CISCO CCIP

	+Microsoft - MCSA 2003 - MCSE 2003 - Administering Active Directory for Win Server 2003 - MCTS: Exchange Server 2007 - MCTS: SQL Server 2005 - Managing and Maintaining Windows 2003 Server

	+Microsoft Office Specialist - Excel 2003 Core - Excel 2003 Expert - Word 2003 Core - Word 2003 Expert - Powerpoint 2003 - Access 2003 - Outlook 2003 - MS Project 2003 - VBA Access 2003 - VBA Excel 2003

	+Microsoft Certified Application Specialist - Excel 2007 - Word 2007 - Access 2007 - Powerpoint 2007

	+Web Development & Programming - Visual.Net Programming - ASP.NET Web Applications - ASP.NET 2.0 & ADO.Net 2.0 - E-Commerce Design - SQL Scripting - Javascript

	+Website Design - Website Design - Advanced Website Design

	+Project Management Professional - Project Management Professional (PMP)

Home > Course List > MCTS: Microsoft SQL Server 2005 > View Shedule

MCTS: Microsoft SQL Server 2005: - Implementation & Maintenance (MS2779+MS2780)

Course Objective:

This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server™
This course is intended for Microsoft SQL Server Administrators, system engineers, and developers who are responsible for implementing,configuring and administering SQL Server 2005.

Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS: SQL Server 2005) implement and maintain databases using specific instructions and specifications. They have thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and know how to explore the user interface. Technology Specialists typically pursue careers as database administrators, database developers, or business intelligence developers. They may also be developers and systems administrators who do not work with SQL Server daily but who want to show their breadth of technology experience.

Microsoft Skills Assessments for SQL Server 2005 help database administrators, database developers, and business intelligence developers focus their exam preparation training and find learning resources. This program consists of two module;
Course 2779: Implementing a Microsoft SQL Server 2005 Database
Course 2780: Maintaining a Microsoft SQL Server 2005 Database

Prerequisite:

An understanding of basic relational database concepts, including:

Logical and physical database design.

Data integrity concepts.

Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).

How data is stored in tables (rows and columns).

Working knowledge of Transact-SQL and relational database, some experience in database design and MS Windows operating system and its core functionality

Certificate Of Attendance :

Certificate Of Attendance will be awarded to students completing the course achieving minimum 75% attendance..

Training Methodology & Materials:

Practical case study sessions to enhance concept.

Well-designed lab sessions to enhance further understanding of the courseware.

Courseware will be provided.

Training Duration:

Full-Time : 5 weekdays or 5 Sats
Time : 9.00am - 5.00pm

Part-Time : 10 sessions
Time : 6.30pm - 10.00pm (2 or 3 times a week)

Course Outline:

For Course 2779 - Implementing a Microsoft SQL Server 2005 Database:

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

For Course 2780 -Maintaining a Microsoft SQL Server 2005 Database:

Module 1: Installing and Configuring SQL Server 2005
Module 2: Managing Databases and Files
Module 3: Disaster Recovery
Module 4: Managing Security
Module 5: Monitoring SQL Server
Module 6: Transferring Data
Module 7: Automating Administrative Tasks
Module 8: Implementing Replication
Module 9: Maintaining High Availability

Course Fees:

Public : $999 excluding Microsoft Exam
Regn Fees : $50

Download Course Brochure (Contact Customer Service @ 6333 4843)