Overview/Description
Microsoft SQL Server 2008 provides enhanced security features to ensure that each instance is secure. Using SQL Server 2008 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 store 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, as well as how to use impersonation using the EXECUTE AS clause. 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 or two to three years of experience using a previous version of SQL Server