• 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 NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Systems Development