Designing Security for Microsoft SQL Server 2005

(WC1)

11/10/10

£

595

(W1)

20/12/10

£

775

(E1)

17/01/11

£

775

(EC3)

19/08/10

£

850

(EC3)

16/09/10

£

850

(EC3)

21/10/10

£

850

Please click above and we will take care of the rest.

Please click above and we will be happy to discuss the benefits of onsite and bespoke courses with you.

If suitable dates or locations are not available, click this link and we will arrange one for you

Course Overview

This two-day instructor-led course enables database administrators who work with enterprise environments to design security for database systems using Microsoft SQL Server 2005.

The course emphasizes that students should think about the whole environment, which includes business needs, regulatory requirements and network systems, and database considerations during design. Students will also learn how to monitor security and respond to threats.

This training may be available onsite; please contact us if you are interested.

Audience

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.

Skills Gained

• Explain the principles of SQL Server security.
• Describe the methodology to design a SQL Server security policy.
• Explain the importance of monitoring SQL Server security.
• Integrating with Enterprise Authentication Systems.
• Developing a Secure Communication Policy.
• Integrate SQL Server security with enterprise-level authentication systems.
• Develop Windows server-level security policies.
• Develop a secure communication policy.
• Define security monitoring standards for SQL Server at the enterprise and server level.
• Design a SQL Server instance-level security policy.
• Design a database-level security policy.
• Design an object-level security policy.
• Define security monitoring standards for instances and databases.
• Analyze business and regulatory requirements.
• Determine the exceptions and their impact on security.
• Design a response policy to handle the denial-of-service attacks.

Examinations

This course will prepare you for the following exams and certification tracks shown. Please note that the exam may not be included in the price shown: please contact us to check.

Microsoft® Certification Tracks  »
    Microsoft® Exams  »
       Exam 70-443: PRO: Designing a Database Server Infrastructure by Using Microsoft® SQL Server 2005

Prerequisites

Before attending this course, students must:

• Have basic knowledge of security protocols and how they work. For example, NTLM or Kerberos. Have basic knowledge of public key infrastructure (PKI) systems. For example, how public and private keys work, strengths and weaknesses, and what they are used for.
• Have working knowledge of Active Directory directory service. For example, security models, policies, group policy objects (GPOs), and organizational units (OUs).
• Be able to design a database to third normal form (3NF) and know the trade offs when backing out of the fully normalized design (denormalization) and designing for performance and business requirements in addition to being familiar with design models, such as Star and Snowflake schemas.
• Have experience creating Microsoft Visio drawings or have equivalent knowledge.
• Be able to use patch management systems. Have knowledge of common attack methods. For example, buffer overflow, replay attacks, etc. Be familiar with SQL Server 2005 features, tools, and technologies.
• 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:
• • Implementing a Microsoft SQL Server 2005 Database [MS2779]
  • Designing Microsoft SQL Server 2005 Infrastructure and Services [MS2786]

Course Outline

• Module 1: Introduction to Designing SQL Server Security
• Module 2: Designing a SQL Server Systems Infrastructure Security Policy
• Module 3: Designing Security Policies for Instances and Databases
• Module 4: Integrating Data Encryption into a Database Security Design
• Module 5: Designing a Security Exceptions Policy
• Module 6: Designing a Response Strategy for Threats and Attacks

Follow On Courses

• Designing A High Availability Database Solution using SQL Server 2005 [MS2788]
• Administering and Automating MS SQL Server 2005 Databases and Servers [MS2789]
• Troubleshooting & Optimizing Database Servers using MS SQL Server 2005 [MS2790]