Tutorialspoint
Subscription Includes
 01:09:36 of High Quality Videos
 22  Lectures
 Full Lifetime Access
 Certificate on Completion
$ 130   9.99

Encryption in SQL Server 2019

Created by Mike West, Last Updated 23-Oct-2020, Language:English

Encryption in SQL Server 2019

A Step-by-Step Guide to Implementing Various Encryption Options in SQL Server 2019

Created by Mike West, Last Updated 23-Oct-2020, Language:English

What Will I Get ?

  • You'll learn how to define encryption technologies specific to relational databases
  • You'll learn the various encryption approaches in SQL Server
  • You'll learn how to implement many of these encryption technologies in SQL Server
  • You'll be able to take what you've learned and apply it to production servers

Requirements

  • You should have a familiarity with SQL Server

Description

Welcome to Encryption in SQL Server 2019.

In this course you'll learn about the sundry approaches Microsoft uses to encrypt data.  Microsoft SQL Server supports 5 different kinds of encryption for protecting data.  While you'll learn about all of them the course will focus on the most recent and most often used approaches to encrypting your data.

In this course you implement two types of data encryption in SQL Server 2019 and one type that's not encryption but is a solid option for securing data.

They are:

  • Column Level Encryption

  • Transparent Level Encryption

  • Dynamic Data Masking

Encryption is the process of obfuscating data by the use of a key or password. This can make the data useless without the corresponding decryption key or password. Encryption does not solve access control problems. However, it enhances security by limiting data loss even if access controls are bypassed. You can use encryption in SQL Server for connections, data, and stored procedures.

Data protection is critical for ensuring that your organization is compliant with regulatory compliance standards like the GDPR and for meeting the expectations of your clients and business partners. Not only can data breaches result in large fines, but the reputational damage can be just as great.

One you've completed this course, you'll have a solid understanding of data encryption techniques in SQL Server.

Thanks for your interest in Encryption in SQL Server 2019.

Let's get started.

Who this course is for:

  • If you're a SQL Server DBA at any level... this course is for you
  • If you're a Transact-SQL developer... this course is for you
  • If you have a basic understanding of SQL Server... this course is for you

Course Content

  • Introduction

    7 Lectures 00:21:23

    • Course Introduction

      Preview
      00:01:06

    • Is this Course Right for You?

      Preview
      00:01:52

    • What is Encryption?

      Preview
      00:01:46

    • Types of Encrypted Data

      00:01:52

    • Data Encryption Options in SQL Server

      00:03:34

    • Install SQL Server 2019 and SSMS

      00:05:08

    • Add and Upgrade the AdvertureWorks Database

      00:06:05

  • Encryption Case Studies

    15 Lectures 00:48:13

    • Case Study: Column Level Encryption: Part 1

      Preview
      00:03:42

    • Case Study: Column Level Encryption: Part 2

      00:05:02

    • Case Study: Column Level Encryption: Part 3

      00:02:12

    • Case Study: Transparent Data Encryption: Part 1

      00:03:38

    • Case Study: Transparent Data Encryption: Part 2

      00:04:29

    • Case Study: Transparent Data Encryption: Part 3

      00:03:43

    • Backup Certificate and Keys

      00:01:28

    • Case Study: Always Encrypted: Part 1

      00:01:49

    • Case Study: Always Encrypted: Part 2

      00:02:04

    • Case Study: Always Encrypted: Part 3

      00:05:04

    • Case Study: Always Encrypted: Part 4

      00:02:25

    • Case Study: Dynamic Data Masking: Part 1

      00:02:44

    • Case Study: Dynamic Data Masking: Part 2

      00:04:01

    • Case Study: Dynamic Data Masking: Part 3

      00:02:07

    • Case Study: Dynamic Data Masking: Part 4

      00:03:45

Mike West

About me I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman. Over the last five years I've transitioned to the exciting world of applied machine learning. I'm excited to show you what I've learned and help you move into one of the single most important fields in this space.

More Courses from Mike West