Security for MS SQL Server 2005

Global Knowledge UK
Coventry, Dublin, London, Wakefield, Wokingham, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

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 and network systems, and database considerations during design. Students will also learn how to monitor security and respond to threats.

Objectives
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

Pre-Requisites
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 network architectures and technologies. For example, how a firewall works, how IPSec works in networking context, common vulnerability points, etc.
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 strong monitoring and troubleshooting skills.
Have experience creating Microsoft 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, replay attacks, etc.
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:

M2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.
M2779, Implementing a Microsoft SQL Server 2005 Database.
M2780, Maintaining a Microsoft SQL Server 2005 Database.

...''

Phone:+44 (0) 118 977 7766

School Address:

Global Knowledge UK
Mulberry Business Park,
Fishponds Rd, Wokingham, RG41 2GY

Jobs & Resumes: Coventry, Dublin, London, Wakefield, Wokingham
Houses & Roommates: Coventry, Dublin, London, Wakefield, Wokingham

MS Windows Server 2003 Active Directory & Network Infrastructure
Microsoft Windows XP Professional
ASP.NET Web Application Using Visual Studio .NET
Programming the Microsoft .NET Framework with C#
Visual Basic.Net
ADO.NET
XML Web Services Using Microsoft ASP.Net
MS Internet Information Services (IIS) 6.0
Microsoft Identity Integration Server (MIIS) 2003
Microsoft SQL Server 2005
Network Security
Internet Security and Acceleration (ISA) Server 2004
Networking for Call Pilot
VOIP Technologies
Call Pilot Rls. 4.0 Administration and Applications
Meridian 1 Large Switch Installation & Maintenance
Nortel Communication Server 1000 Telephony Manager Release 3.0
Communication Server 1000E Installation, Maintenance & Configuration
Nortel WLAN 2300 Installation, Administration & Maintenance

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.