Microsoft Certified Technology Specialist: SQL Server 2005 (MCTS)
GES 816 -- 480 hours -- Certification Preparation Program
Course Objectives
• Identify the tasks involved in supporting Windows 2003 networks.
• Understand how networking concepts are implemented in Windows 2003
• Configure Microsoft Windows 2003 Professional on stand-alone computers and on client computers that are part of a workgroup or domain.
• Install and configure Windows 2003 Server.
• Install, configure, manage and support a network infrastructure that uses Microsoft Windows 2003 server.
• Gain skills needed to create a networking services infrastructure design that supports the required network applications.
• Learn network solution technologies: including DHCP, IP, OSPF, RIP, and IGMP.
• Gain the knowledge and skills needed to design a security framework for small, medium, and enterprise networks by using Microsoft Windows 2003 technologies.
• Install, configure and monitor SQL Server 2005.
• Create and manage database files.
• Create, backup and restore databases.
• Manage security, transactions and locks.
• Transfer data into and out of SQL Server.
• Replicate data between SQL Server instances.
• 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, and functions.
• Implement managed code in the database.
• Use Service Broker to build a messaging-based solution.
• Use Notification Services to generate and send notifications.
• Be prepared to take Microsoft exams 70-290 - Managing and Maintaining a Microsoft Windows Server 2003 Environment; 70-291 - Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure; 70-270 - Installing, Configuring, and Administering Microsoft Windows® XP Professional; 70-431 - Microsoft SQL Server 2005 - Implementation and Maintenance.
Del.icio.us
Digg
Google
Spurl
Yahoo
Blink
Furl
Stumble