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.

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

For more information, email

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
E0712 Mon., Oct. 5 & Tues., Oct. 6Virtual/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
E0713 Mon., Oct. 19 & Tues., Oct. 20Virtual/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
E0714 Mon., Nov. 2 & Tues., Nov. 3Virtual/WCBeth Arrowsmith

If you would like to register for a course, call (314) 984-9000 or register online.

Check out our Relational Database Design Class Using SQL Server to learn effective design principles that allow you to maximize the speed and efficiency of your database.

You may also be interested in other SQL Server classes including SQL Server Reporting Services, SQL Server Integration Services, SQL Server Administration, and SQL Server Relational Database Design.