Course Overview

SQL Server Database Security

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.