|
Designing Security for Microsoft SQL Server 2005 - (Microsoft Training Course: 2787) - 2 days
|
|
|
Target Audience
|
Pre-requisites
|
|
Purpose
|
Print 2 Page Flyer
|
|
Exams
|
Price Options
|
| |
|
COURSE OUTLINE
|
| |
|
Introduction to Designing SQL Server Security
|
Designing a SQL Server Systems Infrastructure Security Policy
|
|
Designing Security Policies for Instances and Databases
|
Integrating Data Encryption into a Database Security Design
|
|
Designing a Security Exceptions Policy
|
Designing a Response Strategy for Threats and Attacks
|
|
|
Target Audience:
This course enables database administrators who work with enterprise environments to design security for database systems using Microsoft SQL Server 2005.
Pre-requisites:
Before attending this course, students must have the following pre-requisites:- Be familiar with SQL Server 2005 features, tools, and technologies.
- Knowledge of the operating system and platform.
- A working knowledge of Active Directory directory service.
- Have experience creating Microsoft Visio drawings.
- Knowledge of common attack methods.
- Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential - or equivalent experience.
- In addition, it is recommended, but not required, that students have completed: Course 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL; Course 2779, Implementing a Microsoft SQL Server 2005 Database; Course 2780, Maintaining a Microsoft SQL Server 2005 Database.
Purpose:
After completing this course, students will be able to explain the principles and methodology of designing SQL Server security; understand guidelines for implementing server-level security using authentication methods; explain how to design SQL Server instance-level, database-level, and object-level security policies; understand the guidelines and considerations for security data using encryption and certificates; respond to virus and worm attacks, denial-of-service attacks, and injection attacks.False
|
