Designing Security for Microsoft SQL Server 2005 Training Course

To speak to a training advisor please call

0800 40 848 40

training@coursemonster.co.uk

Show all Microsoft Courses

Scheduled Dates (sort by: location | date)

Request availability or book by selecting a date:

Central London

City

London (WC1) 17/03/10 £ 595

London (EC2) 14/06/10 £ 750

London (WC1) 16/06/10 £ 595

Greater London

London (EC3) 18/03/10 £ 700

London (EC3) 22/04/10 £ 700

England

Berkshire

Wokingham (RG41) 26/04/10 £ 750

Wokingham (RG41) 02/08/10 £ 750

Manchester (Greater)

Manchester (M1) 26/04/10 £ 695

Manchester (M1) 24/05/10 £ 695

Manchester (M1) 21/06/10 £ 695

Midlands (West)

Birmingham (B3) 22/03/10 £ 695

Birmingham (B3) 19/04/10 £ 695

Birmingham (B3) 26/04/10 £ 695

Birmingham (B3) 17/05/10 £ 695

Birmingham (B3) 24/05/10 £ 695

Birmingham (B3) 14/06/10 £ 695

Birmingham (B3) 21/06/10 £ 695

Birmingham (B3) 28/06/10 £ 695

Somerset

Bath (BA1) 15/04/10 £ 700

Yorkshire (West)

Leeds (LS2) 12/04/10 £ 695

Leeds (LS2) 10/05/10 £ 695

Leeds (LS2) 07/06/10 £ 695

Scotland

Edinburgh

Edinburgh (EH7) 19/04/10 £ 695

Edinburgh (EH7) 17/05/10 £ 695

Edinburgh (EH7) 14/06/10 £ 695

Edinburgh (EH7) 28/06/10 £ 695

Glasgow

Glasgow (G1) 22/03/10 £ 695

Europe / International

LDNM 12/04/10 £ 695

LDNM 10/05/10 £ 695

LDNM 07/06/10 £ 695

Leeds Regus Wellington Place 24/05/10 £ 750

London 12/04/10 £ 598

London 10/05/10 £ 598

London 14/06/10 £ 598

London 12/07/10 £ 598

Prices exclude VAT.

Why do prices vary? Using CourseMonster, you search the schedules of over 100 training companies in one convenient location. Choose the city, date and price that best suits you.

No suitable dates?

I'd like a different date/location

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

I’d like an onsite/bespoke course

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 course has been classified as IT Technical Training.

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]

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]

How to make a booking for the MS2787 course

CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.