Designing Security for Microsoft SQL Server 2005

Face-to-face Instructor Led Courses, IT and Computing, Databases

What Is Designing Security for Microsoft SQL Server 2005 Training?

The course emphasises that delegates 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. By the end of the course delegates will be able to : 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.

Who Should Attend

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.

Course Agenda

- 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.


Available onsite or nationwide at any of over 50 centres, see below our open course availability. Alternatively, call 0844 335 8882.


The Designing Security for Microsoft SQL Server 2005 course will be accredited to the latest in recognised certificating award. All successful delegates will also receive an Xyz certificate of attendance. Enrolled subscribers of the National Training Card will also have any certificate, qualification and/or ID card (where applicable) automatically added to their member account.

More Information

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 Designing Microsoft SQL Server 2005 Infrastructure and Services.

Course Availability

Available on client premises as an in-house course or at one of training venues, provided minimum delegate numbers are achieved. Whatever your requirement, simply complete the enquiry form below and we'll send you our quotation by return.

Make A Designing Security for Microsoft SQL Server 2005 General Enquiry Here

Complete the form below and we'll send you some training options and / or a quote by return. Please only use this form if you are interested in Designing Security for Microsoft SQL Server 2005 courses. For all other enquiries, please use the general contact page, refine your search above or call us on 0844 335 8882.

Designing Security for Microsoft SQL Server 2005 Training Enquiry

Open / Public Course Dates
Open Courses Unavailable
eLearning Options
eLearning Currently Unavailable
Designing Security for Microsoft SQL Server 2005
Part of our Databases range of training courses

Course Information

  • Course Duration 1 day
  • Max Class Size 12

  • All prices exclude VAT. Discounts available for larger groups & for corporate clients.
Our Designing Security for Microsoft SQL Server 2005 Training Courses

Rated 4.4 / 5
*based on 104 client reviews.