Discover the most current techniques and best practices for securing, backing up, and restoring databases.
Overview
Syllabus
Introduction
- Welcome
- Preparing for the MTA Exam 98-364
- Using the exercise files
- Challenges explained
- What you should know
- Understanding security fundamentals
- Securing the database server
- Implementing server-level security in SQL Server Management Studio
- Understanding Windows authentication
- Creating a new Windows user
- Managing password policies
- Understanding fixed server roles
- Assigning server roles
- Challenge: Creating a new user account
- Solution: Creating a new user account
- Granting access to a database
- Understanding fixed database roles
- Assigning fixed database roles
- Understanding object permissions
- Granting object-level permissions in SSMS
- Granting user permissions to objects
- Managing roles
- Understanding ownership chains
- Creating and using a guest account
- Challenge: Assigning object permissions
- Solution: Assigning object permissions
- Using SQL Server recovery models
- Understanding the available backup options
- Creating backups in SSMS
- Restoring a database in SSMS
- Next steps
Taught by
Adam Wilbert