Microsoft Certified Technology Specialist: SQL Server 2005 (MCTS)

Certificate Program

This nationally recognized Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 course teaches students thorough knowledge of the product, as well as an understanding of how to use the 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. This online certificate program is offered in partnership with major accredited colleges and universities.

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

Who Should Attend

This class is intended for anyone who is interested in becoming a MCTS, and especially those interested in gaining employment as database administrators, database developers, and business intelligence developers.

Program Highlights