Course Details

Previous Page


SQL Server Database Security


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


Overview/Description
Candidates should be aware of the various security features availabe 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)
1.3

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 firewall
  • demonstrate how to manage users and permissions as they relate to database security
  • configure auditing
  • configure transparent database encryption
  • demonstrate how to implement SQL Database security features
  • Course Number:
    cl_dicp_a06_it_enus