SQL Server TrackCourse 5 of 7

Microsoft SQL Server Security and Protection

Covering a broad spectrum of topics from foundational security concepts to advanced encryption techniques, this course offers in-depth knowledge of securing SQL Server environments against modern threats — including SQL injection, denial-of-service, and data breaches. Participants will explore server and network security best practices, user authentication and authorisation mechanisms, data protection strategies, and auditing techniques to ensure compliance and robust monitoring.

13 hours · 9 sessionsCAD $325Beginner to AdvancedHands-On Learning
Enrol in This Course

What you'll learn

  • Understand and apply multiple layers of SQL Server security including service accounts, encryption algorithms, and database encryption mechanisms
  • Configure server and network security settings such as SSL encryption, firewall rules, and service management
  • Manage user authentication and authorisation including Windows and SQL Server authentication
  • Implement advanced data protection techniques including column-level permissions, roles, schemas, and views
  • Configure SQL Server auditing for compliance and robust monitoring

Prerequisites

SQL Server Database Administration recommended.

Part of the SQL Server Track

Master Microsoft's enterprise database platform.

7 courses · approx. 20–28 weeksBeginner to Advanced
View full track

Course Modules

9 modules · instructor-led, hands-on delivery

01Introduction to SQL Server Security
02Server and Network Security
03User Authentication and Authorisation
04Protecting the Data
05Code and Data Encryption
06Attacks and Injections
07Securing SQL Agent Service
08Securing Service Broker
09SQL Server Auditing

Other courses in this track

01
Microsoft SQL Server Querying Data16 hours · 11 sessionsCAD $275
02
Microsoft SQL Server Database Development34 hours · 22 sessionsCAD $519
03
Microsoft SQL Server Database Administration28 hours · 19 sessionsCAD $427
04
05

Microsoft SQL Server Security and Protection(current)

13 hours · 9 sessionsCAD $325

Ready to Enrol?

CAD $325 · Get in touch and we'll get you started in Microsoft SQL Server Security and Protection.

Send an Enquiry