From the course: Designing Database Solutions for SQL Server 2016
Join today to access over 25,300 courses taught by industry experts.
Encrypting data - SQL Server Tutorial
From the course: Designing Database Solutions for SQL Server 2016
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.