Designing Security for Microsoft SQL Server 2005COURSE CALENDAR
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.
- 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 is accredited by the most recognised certificating body in the UK and supported by certification and credit card sized ID cards produced by XYZ Training Group - one of the UK's largest dedicated IT and Computing training organisations.
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.
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.