Managing Security in Microsoft SQL Server 2008 (10155)


This two-hour course provides you with the skills and knowledgerequired to manage security in SQL Server 2008. In this course,you will explore the SQL Server 2008 security model. You willalso learn how to create SQL logins and database users and use existingor new roles to facilitate security at a user level or role level.

Topics covered in this course include:

  • Overview of the SQL Server 2008 Security Model
  • Securing SQL Server 2008
  • Securing SQL Server Databases
  • Using Data Encryption to Protect Data
  • Auditing in SQL Server 2008

Student prerequisites:

To benefit from this course, the learner must be familiar with usingMicrosoft Windows. They must have knowledge of basic relationaldatabase concepts and querying data by using Transact-SQL. They must befamiliar with the role of a database administrator.



  • Describe the SQL Server 2008 security model.
  • Secure SQL Server 2008.
  • Secure SQL Server 2008 databases.
  • Use data encryption to protect data.
  • Audit security in SQL Server 2008.


User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-MSMS-S208
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend