Security and Encryption in SQL Server 2012 and 2014

Learn how to secure SQL Server: Access, authentication, permissions, SQL injections, encryption and much more.
Course info
Rating
(135)
Level
Intermediate
Updated
Jun 4, 2014
Duration
5h 26m
Table of contents
Introduction to Security With SQL Server
Server and System Security
Penetration Testing
Authentication and Logins
Roles and Permissions
Fighting SQL Injections
Encryption
Description
Course info
Rating
(135)
Level
Intermediate
Updated
Jun 4, 2014
Duration
5h 26m
Description

Security in SQL Server is often overlooked. Companies tend to concentrate on availability and performance, but a database system often stores virtually all of a company's valuable and confidential data. So what happens if this data is stolen? In this course, we will cover all areas you need to protect to effectively secure SQL Server. It means system and network protection, user authentication, permissions on the objects and data, and data encryption. We will also use some penetration testing frameworks to show you how attacks are performed against SQL Server through various types of exploits, including SQL injection. The course is focused on SQL Server 2012 and 2014, but most of the information applies to all versions from SQL Server 2005 onward.

About the author
About the author

Rudi Bruchez is a freelance consultant and trainer based in Paris, France. He has more than 15 years of experience with SQL Server and started to venture into NoSQL territories. As SGBD evolve into more complex solutions, he tries to make sure that people understand the fundamentals and implement their databases wisely.

More from the author