Microsoft Certified Technology Specialist: SQL Server 2005 (MCTS) GES 816 » 480 hours

Upon successful completion of this program, you’ll be able to:

• Configure Microsoft Windows 2003 Professional on stand-alone computers and on client computers that are part of a workgroup or domain
• Install, configure, manage, and support a network infrastructure that uses Microsoft Windows 2003 server
• 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 and databases
• Manage security, transactions, and locks
• Transfer data into and out of SQL Server and replicate data between instances
• Use XML-related features in Microsoft SQL Server 2005Use Service Broker and Notification Services

You’ll also be prepared to take these 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