Managing and Maintaining Database Security in SQL Server 2005

This course is included in our On-demand training solution.

Overview

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

Target Audience

Professionals pursuing a career as a Database Administrator

Prerequisites

Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005.

Expected Duration

150 min.

Course Objectives

Managing and Maintaining Database Security in SQL Server 2005

  • identify 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?