From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Encrypting data

Encrypting data - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

Encrypting data

“

- [Narrator] Extremely sensitive data, such as passwords, credit card numbers, and other types of personal information, will benefit from an additional layer of security in your database's design. Beyond just limiting user access, the data itself should be encrypted so that should it fall into the wrong hands, it'll remain secure as long as they can't decrypt it, too. Let's take a look at how we can encrypt a column of data by creating a new database, and I'll call mine EncryptDataDB. Then, we're going to create a basic table called employees with a couple of fields here, including a social security number field. Then, we'll insert three employees, Malcom, Rory, and Brianne, and we'll include their phone number and social security number. Finally, we'll select everything from the employee's table to make sure that all the inserts worked correctly. I'm going to highlight all these lines and execute it. In the results window, I see the three employees, their employee ID, the name, phone…

Contents