Course: Administering SQL Server I

Course Description
The course teaches students to install, configure, and troubleshoot a SQL Server. Classes teach students to develop a security strategy, capacity plan, and a data availability solution. Students also learn to develop a migration plan and to manage security, data, replication, and remote data availability. Automating administrative tasks and optimizing a database are also included. Prepares student for exams such as the Microsoft Certified Professional (MCP) exam, which is one exam in the Microsoft Certified Systems Administrator (MCSA), Microsoft Certified Database Administrator (MCDBA) and Microsoft Certified Systems Engineer (MCSE) certifications.

Certificate
 Completion of this course certifies proficient SQL server installation and managing skills based on a score of 80% or higher on competency exams. A Certificate of Technical Competency is available upon request.

This course fulfills requirements for the following Programs:

  • IT - Networking
  • Network Engineer (MCSE)

Competencies (skills you will learn)

  • Understand SQL Server architecture.
  • Install and configure SQL Server login security, database permissions, and manage files and databases.
  • Automate administrative tasks using SQL Server Agent.
  • Import, export, transform, and replicate data.
  • Monitor and maintain SQL Server performance.

Course Structure
 This is a competency-based course offered in open-entry/open-exit format.

Course Length
 The estimated length of this course is 120 hours.
 Actual course length will depend upon your schedule and your ability to master the subject material.

Specific Course Admission Requirements
 There are no specific requirements to take this course. However, courses in the Information Technology Programs are to be taken in order. The course list can be found on the information sheet for each program or by contacting Student Services.

Textbooks & Materials

70-228: MCSE Guide to MS SQL Server 2000 Administration - optional
ISBN:9781418835262
Price:$98.25

Go to the Bookstore for a list all textbooks available

Course Location and Schedule
Rose Park Campus: 8 a.m. to 8 p.m. Monday - Thursday, 8 a.m. to 12 p.m. Friday

Tuition and Fees
 Tuition is based on the number of enrolled classroom hours. High school students are exempt from tuition, but are responsible for course and program fees and the cost of textbooks. Please see the SLTATC Monthly Tuition and Fee Schedule or contact Student Services for current tuition and fee information.

This course does not have an individual course fee, but please see the information sheet for your desired program for estimated total program tuition and fee costs.