UMSL logo

Computer Education & Training Center

SQL Server Administration

SQL Server Administration Classes

Virtual Classes: Our SQL Administration classes are now available online with an instructor present for the entire course. You will see the instructor's screen throughout the class and you can share your screen if you need individual help from the instructor. You will have time to practice, ask questions, and receive hands-on training. During class, you will be able to access our SQL Server in order to learn SQL.

In-person classes are also available at our West County facility with limited enrollments to promote social distancing. When you register, choose your class section based on how you want to attend the class: virtual or in-person.

  • Select "Live Online" if you want to attend virtually from your workplace or home.
  • Choose "West County In-Person" if you want to attend a class at our West County location.

For more information, email info@cetc.umsl.edu.

Introduction to SQL Server System Administration

(Prerequisite: Intermediate Applications of SQL or equivalent experience.) Learn the basics of installing, configuring, and administering Microsoft SQL Server. Get an overview of SQL Server and how the current version differs from previous versions and differences among editions. Install and configure Microsoft SQL Server Enterprise Edition, and investigate how to troubleshoot your installation, along with how to install and troubleshoot the client tools used to connect to SQL Server. Learn about some of the common tools and utilities, such as the SQL Server Management Studio, that come with the program and can assist you in managing your database. Discuss SQL Server security from the standpoint of creating and working with user logon accounts and setting database security through database permissions. [Course Outline]
Fee: $399

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
E1464 Thurs., Feb. 25 & Fri., Feb. 26Virtual/WCBeth Arrowsmith

Intermediate SQL Server System Administration

(Prerequisite: Introduction to SQL Server System Administration or equivalent experience.) This course emphasizes maintenance, optimization, and performance tuning of a SQL Server database. Investigate how to plan the space requirements for a database and control its size. Learn to optimize queries and defragment, import, export, back up, and restore databases. Additional topics include index tuning, multi-user considerations, an introduction to SQL Server Integration Services (SSIS), and disaster recovery considerations. [Course Outline]
Fee: $399

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
E1465 Thurs., Mar. 11 & Fri., Mar. 12Virtual/WCBeth Arrowsmith

Advanced SQL Server System Administration

(Prerequisite: Intermediate SQL Server System Administration or equivalent experience.) Explore advanced techniques using SQL Server to store and retrieve data from other SQL Server and other heterogeneous data sources. Probe deeper into the administration of SQL Server with a discussion of the Microsoft Distributed Transaction Coordinator and distributed transactions. Investigate various methods of storing and retrieving data from multiple locations, including linked servers, data replication, and log shipping. Learn how to configure snapshot, transactional, and merge replication and the advantages and disadvantages of each. [Course Outline]
Fee: $399

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
E1466 Mon., Mar. 29 & Tues., Mar. 30Virtual/WCBeth Arrowsmith