Encryption in SQL Server
A Step-by-Step Guide to Implementing Various Encryption Options in SQL Server 2019
Development,Databases,SQL Server
Lectures -23
Duration -1 hours
30-days Money-Back Guarantee
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
Goals
- 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
Prerequisites
- You should have a familiarity with SQL Server
![Encryption in SQL Server Encryption in SQL Server](https://d3mxt5v3yxgcsr.cloudfront.net/courses/3798/course_3798_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
7 Lectures
-
Course Introduction 01:06 01:06
-
Is this Course Right for You? 01:52 01:52
-
What is Encryption? 01:46 01:46
-
Types of Encrypted Data 01:52 01:52
-
Data Encryption Options in SQL Server 03:34 03:34
-
Install SQL Server 2019 and SSMS 05:08 05:08
-
Add and Upgrade the AdvertureWorks Database 06:05 06:05
Encryption Case Studies
15 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Mike West](https://www.tutorialspoint.com/assets/profiles/265722/profile/200_176203-1603432665.jpg)
Mike West
I'm the founder of LogikBot. I've worked at Microsoft and Uber. I helped design courses for Microsoft's Data Science Certifications. If you're interested in machine learning, I can help.
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.
Experience, education and passion
I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.
Certifications
Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).
Personal
Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual 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 Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)