To speak to a training advisor please call

0800 40 848 40

training@coursemonster.com

All Courses / Microsoft Courses / Microsoft SQL Server 2005: Designing Security for Microsoft SQL Server 2005

Share: Follow us:

Bookmark with:

Print Page:

Microsoft SQL Server 2005: Designing Security for Microsoft SQL Server 2005

Online Training

Time stretched?

If you would prefer something more flexible, we can now offer Online Training related to this topic.

Click to see a list of courses »

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.

CourseMonster specialises in offering Microsoft training to corporations and individuals alike, we are happy to help with any of your Microsoft training requirements.

Related Courses

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.

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]