• Online, Self-Paced
Course Description

Candidates should be aware of the various security features available to best secure a SQL Server database. A layered security approach, firewall rules, and role-based security are a few topics covered in this course.

Learning Objectives

Secure SQL Server Databases

  • start the course
  • describe the layered approach to security
  • configure firewall rules
  • demonstrate how to configure firewalls using portals
  • use PowerShell to configure a firewall
  • use Transact SQL to configure a firewall
  • use REST API to configure a firewall
  • demonstrate how to manage users and permissions as they relate to database security
  • configure transparent database encryption

Practice: SQL Database Security

  • demonstrate how to implement SQL Database security features

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.