SQL Server 2008 R2: Security Management


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

Overview/Description
Microsoft SQL Server 2008 R2 provides enhanced security features to ensure that each instance is secure. Using SQL Server 2008 R2 security features, administrators can guarantee that access to a SQL Server instance is granted only to specified users, using either Windows Authentication or Mixed Mode Authentication by creating logins and then mapping the logins to the databases within the instance. Administrators also have the ability to encrypt a SQL Server instance using transparent data encryption (TDE) and to encrypt the data within a database using encryption certificates and asymmetric and symmetric keys. Impersonation is another SQL Server security feature, which is used to make sure that the person who accesses the database has the appropriate permissions to complete the task, for example, running a specific stored procedure to access underlying objects. This course demonstrates how to create SQL Server logins, database users, and how to grant permissions, including server and database roles. It also addresses how to use encryption to protect a database and database data, how to use impersonation using the EXECUTE AS clause, and how to configure auditing to monitor access to SQL Server. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.

Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who don't work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.

Prerequisites
One to two years of experience using SQL Server 2008, SQL Server 2008 R2 or two to three years of experience using a previous version of SQL Server

Expected Duration (hours)
2.0

Lesson Objectives

SQL Server 2008 R2: Security Management

  • recognize how security works in the SQL Server 2008 R2 Database Engine
  • recognize how to create a login for SQL Server 2008 R2
  • recognize how to create a schema for SQL Server 2008 R2
  • recognize how to use T-SQL to create a user for SQL Server 2008 R2
  • recognize how to implement encryption in SQL Server 2008 R2
  • recognize how to use impersonation in a given scenario
  • recognize how to create a DDL trigger to audit access
  • recognize how to create a logon trigger to audit access
  • recognize how to create an event notification to audit access
  • create logins, users, and schemas to allow access to SQL Server 2008 R2
  • use impersonation to change the execute context for a session
  • create a DDL trigger for auditing access in SQL Server 2008 R2

    • Course Number:
    md_mcir_a03_it_enus