SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. In this course, you’ll learn about the administrative features that are available in SQL Server. This course also examines other SQL Server 2005 essential application, support, and maintenance topics – features you can use for high-availability, stability, reliability, and scalability of databases. Other topics covered include understanding and implementing security, analyzing performance, automating administrative tasks, and disaster recovery.

SQL Training Audience:

Database administrators interested in gaining a more thorough knowledge of SQL Server 2005’s features.

SQL Training Prerequisites

A working knowledge of SQL Server 2000 or 2005, basic relational database concepts, XML, Transact-SQL, and networking and security concepts.


SQL Training Course duration

3 days

SQL Training Course outline

Understanding and Implementing Security

• Security Overview
• The Threats
• SQL Server 2005 Security Design Philosophy
• The Two Stages of Security
• Authentication
• Configuring SQL Server Security Settings
• Windows Integrated Authentication
• SQL Server Authentication
• Authorization
• Principals
• Securable Objects
• Permissions
• Permission Types
• Permission Statements
• Granting Permissions
• Roles, Permissions, and Schemas
• Execution Context
• Metadata Security
• Data Encryption
• Encryption Keys
• Encrypting Data
• Security Epilog