The increasing complexity and sophistication of cyber threats pose significant challenges to database security, making it critical for professionals to implement comprehensive solutions. In this course, Advanced SQL Server Applications, you’ll gain the ability to secure your SQL Server databases comprehensively and effectively against modern threats. First, you’ll explore the essential concepts behind SQL Server security, understanding common threats and the importance of safeguarding application data. Next, you’ll discover auditing, allowing you to keep track of access and modifications, helping ensure compliance with regulatory standards. Finally, you’ll learn how to implement advanced encryption methods to protect data both at rest and in transit, as well as combating SQL injection attacks. When you’re finished with this course, you’ll have the skills and knowledge of SQL Server security needed to protect your databases from threats, ensuring data integrity and compliance.
Author Name: Rudi Bruchez
Author Description:
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. He worked first as a developer and started as a DBA in 2001, in Switzerland at MSC (Mediterranean Shipping Company). He moved to France in 2005 and is working freelance since 2006. He provides consulting, administration, audits and training. As SQL Server evolves into a more complex solution, he tries to make sure that d… more

Table of Contents

• Course Overview
  1min
• Introduction to Advanced Security Topics
  22mins
• Auditing
  24mins
• Encryption in SQL Server
  41mins
• Fighting SQL Injection Attacks
  16mins
• Tools for Compliance Regulations
  19mins