2013
Lynda
Gerry O'Brien
1:36
English
Make sure your network's SQL Servers are secure, using best practices for physical, instance, network, and file system security. Gerry O'Brien introduces basics like SQL Server securables, principals, logins, users, and roles. Then learn how SQL Server checks permissions and use that information to create accounts and assign logins and roles. Last, Gerry explains common network security risks and steps you can take to secure network protocols.
Introduction
Welcome
What you should know before watching this course
1. Security Best Practices for SQL Server
Physical security
SQL instance security
Network security considerations
File system security
2. SQL Server Security Basics
SQL Server securables
SQL Server principals
Manage logins and users
Understanding and using roles
3. Understanding and Using SQL Server Permissions
SQL Server permissions
Understanding how SQL Server checks permissions
Permissions applied to securables
4. Creating and Assigning Logins and Roles
Understanding SQL Server authentication modes
Creating logins
Creating roles
Assigning logins and roles for security
5. Securing SQL on the Network
Understanding network security risks
SQL Server Configuration Manager
Securing network protocols
Conclusion
Next steps
Download File Size:248.16 MB