Designing Security for a Database Server Infrastructure for SQL Server 2005

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

Overview

To identify business security requirements, select the appropriate authentication method, and specify a security design for different levels of the SQL Server environment

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

180 min.

Course Objectives

Designing Security for a Database Server Infrastructure for SQL Server 2005

  • identify security requirements when designing a SQL Server environment for a given business scenario.
  • determine security recommendations when designing a SQL Server environment for a given business scenario.
  • identify the authentication requirements of a given enterprise scenario.
  • determine the appropriate authentication method for a given SQL Server enterprise scenario.
  • identify best practices when designing Windows password policies for the SQL Server environment in a given scenario.
  • identify best practices when designing Windows services and securing the network for the SQL Server environment.
  • identify the considerations involved in designing service-level security for the SQL Server environment in a given scenario.
  • identify the considerations involved in designing database-level security for the SQL Server environment, given a scenario.
  • identify the considerations involved in designing object-level security for the SQL Server environment, given a scenario.
  • determine the appropriate security strategy for SQL Server in a given enterprise scenario.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?