Udemy

Platform

English

Language

Databases

Category

SQL Server 2016 Administration SQL Security with Hands-On

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

4.40 (65 reviews)

Students

3.5 hours

Content

Jan 2019

Last Update
Regular Price

SKILLSHARE
SkillShare
Unlimited access to 30 000 Premium SkillShare courses
30-DAY FREE TRIAL

What you will learn

securing the Microsoft SQL Server


Description

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


Screenshots

SQL Server 2016 Administration SQL Security with Hands-On
SQL Server 2016 Administration SQL Security with Hands-On
SQL Server 2016 Administration SQL Security with Hands-On
SQL Server 2016 Administration SQL Security with Hands-On

Content

Introduction

Introduction

Security Best Practices for SQL Server

Physical security

SQL instance security

Network security considerations

File system security

SQL Server Security Basics

SQL Server securables

SQL Server principals

Manage logins and users

Understanding and using roles

Understanding and Using SQL Server Permissions

SQL Server permissions

Understanding how SQL Server checks permissions

Permissions applied to securables

Creating and Assigning Logins and Roles

Understanding SQL Server authentication modes

Creating logins

Creating roles

Assigning logins and roles for security

Securing SQL on the Network

Understanding network security risks

SQL Server Configuration Manager

Securing network protocols

Configuring encryption MSSQL 2016

What is Encryption?

Implement cell-level encryption

How to Configure transparent data encryption

implement always Encryption

implement backup encryption

Configure encryption for connections


Reviews

P
Philcee30 September 2020

The course was exactly what I expected. It was explained in detail, and the instructor was clear in his explanation. Thanks to Udemy

C
Coconut28 December 2019

Information is informative, but the instructor talks slow, and almost seems like a singing of upper and lower notes for starting and ending of thoughts. I do appreciate that the instructor points out where to go inside of SQL Server to perform various tasks. Added scripts for encryption is great.

C
Cyrille2 July 2019

It has been a good and exciting experience, i am actually learning a lot on Sql server Database and security in particular.

S
Srivinas15 September 2018

Enjoyed with Experienced instructor, in depth explanation, very easy to understand and relate to real hands-on demo, simply an amazing course, fantastic course Hayat.Thanks


Coupons

DateDiscountStatus
10/25/201990% OFFExpired
4/2/2021100% OFFExpired
5/19/2021100% OFFExpired
5/27/202190% OFFExpired
6/10/202190% OFFExpired
7/20/202190% OFFValid

1831346

Udemy ID

7/31/2018

Course created date

10/25/2019

Course Indexed date
Bot
Course Submitted by