Encryption in SQL Server 2019
What you’ll learn
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 EncryptionTransparent Level EncryptionDynamic Data MaskingEncryption 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.
Overview
Section 1: Introduction
Lecture 1 Course Introduction
Lecture 2 Is this Course Right for You?
Lecture 3 Course Structure
Lecture 4 What is Encryption?
Lecture 5 Types of Encrypted Data
Lecture 6 Data Encryption Options in SQL Server
Lecture 7 Install SQL Server 2019 and SSMS
Lecture 8 Add and Upgrade the AdvertureWorks Database
Section 2: Encryption Case Studies
Lecture 9 Case Study: Column Level Encryption: Part 1
Lecture 10 Case Study: Column Level Encryption: Part 2
Lecture 11 Case Study: Column Level Encryption: Part 3
Lecture 12 Case Study: Transparent Data Encryption: Part 1
Lecture 13 Case Study: Transparent Data Encryption: Part 2
Lecture 14 Case Study: Transparent Data Encryption: Part 3
Lecture 15 Backup Certificate and Keys
Lecture 16 Case Study: Always Encrypted: Part 1
Lecture 17 Case Study: Always Encrypted: Part 2
Lecture 18 Case Study: Always Encrypted: Part 3
Lecture 19 Case Study: Always Encrypted: Part 4
Lecture 20 Case Study: Dynamic Data Masking: Part 1
Lecture 21 Case Study: Dynamic Data Masking: Part 2
Lecture 22 Case Study: Dynamic Data Masking: Part 3
Lecture 23 Case Study: Dynamic Data Masking: Part 4
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 Information:
Udemy | English | 1h 10m | 1.64 GB
Created by: Mike West
You Can See More Courses in the Developer >> Greetings from CourseDown.com