Microsoft SQL Server 2016: Data Access and Permissions


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


Overview/Description
To protect data in a SQL Server Database environment, you need to ensure that only trusted users and applications have access to it. In this course, you will learn about configuring data access and permissions. This includes managing database object permissions, as well as creating and maintaining users and custom roles. In addition, this course covers configuring user options for Azure SQL Database, row-level security, and dynamic data masking. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Target Audience
Database administrators and database professionals

Prerequisites
None

Expected Duration (hours)
2.2

Lesson Objectives

Microsoft SQL Server 2016: Data Access and Permissions

  • start the course
  • describe the types of database users and their purpose
  • create a database user using SQL Server Management Studio
  • create a database user using Transact-SQL
  • describe available server permissions
  • recognize the steps involved in granting a user access to a database and its objects
  • grant access to database objects
  • revoke access to database objects
  • describe database-level roles and their purpose
  • describe server-level roles and their purpose
  • describe the purpose of application roles
  • recognize why you would use and how to create a custom role
  • describe the purpose of row-level security and how to implement it
  • implement row-level security using T-SQL and predicates
  • implement row-level security using T-SQL and predicates
  • describe the purpose of dynamic data masking
  • define dynamic data masking
  • describe the benefits and features of using Azure SQL Database
  • create and configure a new Azure SQL Database
  • connect to and manage an Azure SQL Database using a local instance of SSMS
  • configure data access and permissions in SQL Server 2016

    • Course Number:
    df_sqla_a02_it_enus

    Expertise Level
    Intermediate