Course Title: Microsoft Certified Technology Specialist: SQL Server 2005 (MCTS)

School: At a college near you (click "Enroll Now" to see location). [Learn More]
Hours required: 480  
Price: $3,095  
Length course offered: N/A   
Instructor: Chris Lobban [Bio]

Description:

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 certification preparation program is offered in partnership with major colleges, universities, and other accredited education providers.

Goals:

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

Grading System:

Confirmation of Completion awarded with passing score.

School Description:

Offered in connection with a college or university near you, our self-paced, online career courses are designed to launch you into your dream job.

Begin your course anytime. Textbooks are included, and you will have access to student support via phone, email, and chat 24 hours a day.

Click "Enroll Now" to find the partner school for the career course you want to take.

Instructor Bio: Chris Lobban

Chris Lobban brings his industry experience with an extensive assortment of hardware and software solutions. Before starting at Academy of Learning he had worked both in a Help Desk environment and as a Quality Assurance Analyst, where he had to deal with a wide array of different hardware requirements, operating systems, and computer programs every day. This broad experience base, added to his formal training as a Computer Networking and Technical Support Specialist from Seneca College, gives him the training and experience needed to provide support to his students.

Chris has also certified his experience by earning the CompTIA A+ IT Technician, Network+, Server+ and Security+ credentials, as well as the Microsoft MCSE (Windows Server 2003), MCSA (Windows Server 2003) and MCDST (Windows XP) credentials.