Database Courses:
Designing Security for Microsoft SQL Server 2005 Training Course


Classroom Courses ~ Closed Courses ~ Onsite Courses ~ Training Passport ~ MCSE Courses ~ CBT Courses
Home Page ~ Contact ~ Training Centre ~ Course Schedule ~ Late Availability ~ Consultancy
   
    PTR Associates Ltd - Classroom Based Courses, Wokingham, Berkshire, uk
21a Peach Street, Wokingham, Berkshire, UK
Tel: 0118 979 4000       Fax: 0118 979 4035
Email:
training@ptr.co.uk      Web: www.ptr.co.uk

Designing Security for Microsoft SQL Server 2005 Course


Course Description
This two-day instructor-led course enables database administrators who work with enterprise environments to design security for database systems using Microsoft SQL ServerT 2005. The course emphasizes that students should think about the whole environment, which includes business needs, regulatory requirements, network systems, and database considerations during design. Students will also learn how to monitor security and respond to threats.

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 pre-requisites:
Before attending this course, students must:

  • Have basic knowledge of security protocols and how they work. For example, Windows NT LAN Manager (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 network architectures and technologies. For example, how a firewall works, how IPSec works in a networking context, and common vulnerability points.
  • 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 tradeoffs 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 strong monitoring and troubleshooting skills.
  • Have experience creating Microsoft Office Visio drawings or have equivalent knowledge.
  • Have strong knowledge of the operating system and platform. That is, how the operating system integrates with the database, what the platform or operating system can do, interaction between the operating system and the database.
  • Have basic knowledge of application architecture. That is, different methods of implementing security in an application, how applications can be designed in three layers, what applications can do, the interaction between applications and the database, and interactions between the database and the platform or operating system.
  • Have knowledge about network security tools. For example, sniffer and port scanning. Must understand how they should be used.
  • Be able to use patch management systems.
  • Have knowledge of common attack methods. For example, buffer overflow, and replay attacks.
  • Be familiar with SQL Server 2005 features, tools, and technologies.
  • Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential or equivalent experience.
scheduled dates / price

Topics covered on the 2 day Designing Security for Microsoft SQL Server 2005 course


Introduction to Designing SQL Server Security

  • Principles of Database Security
  • Methodology for Designing a SQL Server Security Policy
  • Monitoring SQL Server Security

Designing a SQL Server Systems Infrastructure Security Policy

  • Integrating with Enterprise Authentication Systems
  • Developing Windows Server-Level Security Policies
  • Developing a Secure Communication Policy
  • Defining SQL Server Security Monitoring Standards

Designing Security Policies for Instances and Databases

  • Designing an Instance-Level Security Policy
  • Designing a Database-Level Security Policy
  • Designing an Object-Level Security Policy
  • Defining Security Monitoring Standards for Instances and Databases

Integrating Data Encryption into a Database Security Design

  • Securing Data by Using Encryption and Certificates
  • Designing Data Encryption Policies
  • Determining a Key Storage Method

Designing a Security Exceptions Policy

  • Analyzing Business and Regulatory Requirements
  • Determining the Exceptions and their Impact

Designing a Response Strategy for Threats and Attacks

  • Designing a Response Policy for Virus and Worm Attacks
  • Designing a Response Policy for Denial-of-Service Attacks
  • Designing a Response Policy for Internal and SQL Injection Attacks
This is an instructor led training course taught in a classroom based environment.

Course Classification:  Technical Training Course


Course Fee = £690
   (excl.VAT)


Scheduled course dates
May 2008 June 2008 July 2008 August 2008 September 2008
----



If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite SQL Server 2005 Training and bespoke SQL Server 2005 courses


If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.







PTR Associates Limited

21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk
SQL Server 2005 Course Index & Training Schedule
More SQL Server 2005 Courses

Implementing and Maintaining SQL Server 2005 Course

Implementing & Maintaining Microsoft SQL Server 2005 Integration Services Course

Designing Security for Microsoft SQL Server 2005 Course

Designing High Availability Database Solutions Using Microsoft SQL Server 2005 Course

SQL Server 2005 Analysis Services Course

SQL Server 2005 Reporting Services Course

C Programming Courses
Cisco Courses
Citrix Courses
CIW Courses
CompTia Courses
Database Courses
Exchange Server Courses
Fortran Courses
Internet Courses
Java Courses
JSP Courses
Linux Courses
MCSD Courses
MCSE Courses
Microsoft Courses
Microsoft .NET Courses
Microsoft Access Courses
Microsoft Excel Courses
Microsoft Outlook Courses
Microsoft Powerpoint & Visio Courses
Microsoft Project Courses
Microsoft Server Products Courses
Microsoft Word Courses
Networking Courses
Oracle Courses
Perl Courses
Programming Courses
Security Courses
SQL Courses
SQL Server 2000 Courses
SQL Server 2005 Courses
Unix Courses
VBA Courses
Visual Basic Courses
Windows 2000 Courses
Windows Server 2003 Courses
Windows Vista Courses
Windows XP Courses
XML Courses