April Learning Carnival is here, Use code FEST10 for an extra 10% off

Encryption in SQL Server

person icon Mike West


Encryption in SQL Server

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

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Mike West

category icon Development,Databases,SQL Server

Lectures -23

Duration -1 hours



30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course 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


What will you learn in this course:

  • 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


What are the prerequisites for this course?

  • You should have a familiarity with SQL Server
Encryption in SQL Server


Check out the detailed breakdown of what’s inside the course

7 Lectures
  • play icon Course Introduction 01:06 01:06
  • play icon Is this Course Right for You? 01:52 01:52
  • play icon What is Encryption? 01:46 01:46
  • play icon Types of Encrypted Data 01:52 01:52
  • play icon Data Encryption Options in SQL Server 03:34 03:34
  • play icon Install SQL Server 2019 and SSMS 05:08 05:08
  • play icon Add and Upgrade the AdvertureWorks Database 06:05 06:05
Encryption Case Studies
15 Lectures

Instructor Details

Mike West

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.

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us