Designing Security for a Database Server Infrastructure for SQL Server 2005 Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Overview/Description
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 (hours)
3.0
Lesson 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.
Course Number: 236752_eng