UMSL logo

Computer Education & Training Center

Security

SQL Server Security Class

Master the art of writing advanced SQL queries by attending a hands-on class at UMSL's Computer Education & Training Center.

Virtual Classes: Our SQL Optimization 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 Optimization.

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.

SQL Security

(Prerequisite: Advanced SQL or equivalent experience.) Understand how data is your most valuable asset and the importance of keeping the data secure. Learn how to manage your SQL Servers database permissions. Discover how to create roles and assign roles to users, making it easier if a user leaves the company or changes positions. Use and create schemas to provide natural data groupings so securing an application or group of applications becomes easier. Discover stored procedures to control and limit what roles can do. Learn about securables, the items that can be secured in a SQL Server, and manage permissions using grant, revoke and deny to protect the data.  [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3064 Mon., July 25Virtual/WCBeth Arrowsmith

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

Classes are also available in SQL Programming using Transact-SQL to extend the functionality of your database.

You may also be interested in other SQL Server classes including SQL Server Reporting Services, SQL Server Integration Services, and Advanced SQL Queries.

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