UMSL logo

Computer Education & Training Center

SQL Server Administration

SQL Server Administration Classes

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
E8157 Wed., Oct. 25 & Thurs., Oct. 26West CountyFrank Richey

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
E8158 Thurs., Nov. 9 & Fri., Nov. 10West CountyFrank Richey

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
E8159 Thurs., Nov. 30 & Fri., Dec. 1West CountyFrank Richey

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.