This course demonstrates the principles and methodology of designing and monitoring SQL Server security. Participants will learn the benefits of establishing and maintaining a security policy.
This course covers the guidelines for implementing server-level security using authentication methods, creating password policies, and for determining service account permissions. Participants will learn how to design SQL Server instance and database-level security policies. Also covered in this course are the guidelines and considerations for securing data using encryption and certificates, and for responding to virus, worm, denial-of-service and injection attacks. Participants are required to have a network-enabled Windows laptop with administrative rights to both the operating system and anti-virus software.