Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

SQL Server 2016 Administration SQL Security with Hands-On

via Udemy

Overview

Get advanced skills to be a SQL Server professional and hardening Microsoft SQL Server securing SQL+ SQL Server login

What you'll learn:
  • securing the Microsoft SQL Server

Make sure your network's SQL Servers are secure, using best practices for physical, instance, network, and file system security. In this course we introduces basics like SQL Server securables, principals, logins, users, and roles. Then learn how SQL Server checks permissions and use that information to create accounts and assign logins and roles. Last also will explains common network security risks and steps you can take to secure network protocols.

The following topics are covered:

  1. Understanding security best practices

  2. Managing logins and users

  3. Understanding how SQL Server checks permissions

  4. Creating and assigning logins and roles

  5. Securing SQL on the network

  6. How to Configuring encryption

    1. Encryption overview

    2. Implement cell-level encryption

    3. Configure transparent data encryption

    4. implement always Encryption

    5. implement backup encryption

    6. Configure encryption for connections

Taught by

Zulqarnain Hayat

Reviews

Start your review of SQL Server 2016 Administration SQL Security with Hands-On

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.