Design Implement and Troubleshoot Security

Practice Labs Module
Time
30 minutes
Difficulty
Intermediate

The "Design, Implement and Troubleshoot Security" module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises: 1) Implement Security.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or

Already have an account? Sign In »

Overview

Introduction

The Design, Implement and Troubleshoot Security module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

  1. Implement Security

Exercise 1- Implement Security

In this exercise, you will learn the following in Microsoft SQL Server 2012 R2:

  • Create database roles and permissions
  • Create contained users (users without a login)
  • Use the security statements : Grant, Deny, Revoke, Execute As
  • Use CREATE CERTIFICATE statement to add a certificate to a database
Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.