UMSL logo

Computer Education & Training Center

Security

SQL Server Security Class

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

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
E3340 Wed., Nov. 9Virtual/WCBeth Arrowsmith
E3550 Fri., Feb. 24Virtual/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, Advanced SQL Queries, and SQL Query Optimization.

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