SQL Server Database Security


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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.

Target Audience
Database professionals interested in working with hybrid/cloud solutions, and individuals who are preparing to take the 70-473 exam

Prerequisites
None

Expected Duration (hours)
0.9

Lesson Objectives

SQL Server Database Security

  • 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
  • demonstrate how to implement SQL Database security features

    • Course Number:
    cl_dicp_a06_it_enus

    Expertise Level
    Expert