Designing Security for Microsoft SQL Server 2005 (2787)

OBJETIVOS
This course enables database administrators who work with enterprise environments to design security for database systems using Microsoft SQL ServerT 2005. The course emphasizes that students should think about the whole environment, which includes business needs, regulatory requirements, network systems, and database considerations during design. Students will also learn how to monitor security and respond to threats.

PARTICIPANTES
This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment .

EQUIPOS Y DURACIÓN
Se dispone de un ordenador por alumno. El curso tiene una duración de 10 horas (consultar los horarios disponibles en el calendario de New Horizons). El nº de plazas es limitado.

 

[Temario]

Introduction to Designing SQL Server Security
Principles of Database Security
Methodology for Designing a SQL Server Security Policy
Monitoring SQL Server Security

Designing a SQL Server Systems Infrastructure Security Policy
Integrating with Enterprise Authentication Systems
Developing Windows Server-Level Security Policies
Developing a Secure Communication Policy
Defining SQL Server Security Monitoring Standards

Designing Security Policies for Instances and Databases
Designing an Instance-Level Security Policy
Designing a Database-Level Security Policy
Designing an Object-Level Security Policy
Defining Security Monitoring Standards for Instances and Databases

Integrating Data Encryption into a Database Security Design
Securing Data by Using Encryption and Certificates
Designing Data Encryption Policies
Determining a Key Storage Method

Designing a Security Exceptions Policy
Analyzing Business and Regulatory Requirements
Determining the Exceptions and their Impact

Designing a Response Strategy for Threats and Attacks
Designing a Response Policy for Virus and Worm Attacks
Designing a Response Policy for Denial-of-Service Attacks
Designing a Response Policy for Internal and SQL Injection Attacks