Microsoft Certified Technology Specialist: SQL Server 2005 (MCTS) Certification Preparation Program » GES 816 » 480 hours
Get Started
Find an accredited school near you.
Overseas Military enter "APO" or "FPO"Benefits of
Online Career Training
- Learn in-demand job skills
- Start anytime and set your pace
- Affordably Priced
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
