Managing and Maintaining Database Security in SQL Server 2005
This course is included in our On-demand training solution.
To identify strategies for auditing database security at the server and user levels, and determine the appropriate way to protect against and respond to different types of attack on SQL Server
Professionals pursuing a career as a Database Administrator
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005.
Managing and Maintaining Database Security in SQL Server 2005identify an appropriate strategy for auditing access to SQL Server at the server level, given a scenario.identify considerations for choosing an encryption algorithm, and recognize how to use the Microsoft Baseline Security Analyzer and SQL Server Surface Area Configuration tools to secure SQL Server.determine an appropriate strategy for monitoring and auditing SQL Server access in a given scenario.recognize strategies for auditing user access to SQL Server in a given scenario.recognize how to verify account policies and user accounts in SQL Server 2005, given a scenario.use stored procedures and views to verify account policy and user account information in SQL Server 2005.recognize how to protect SQL Server against SQL injection and DoS attacks.recognize how to protect SQL Server against viruses, worms, and internal attacks.determine how to protect against and respond to attacks on SQL Server, given a scenario.