2015
Lynda
Adam Wilbert
1:14
English
Ongoing, regular administration is critical to the security and performance of databases such as Oracle and SQL Server. It's also a key topic of the Microsoft Technology Associate (MTA) Exam. Whether you're studying to pass the test or simply to keep your admin skills up to date, this course will cover the most current techniques and best practices for administering a database. Adam Wilbert covers the core concepts, including securing the server with user authentication and roles, assigning object-level permissions, and performing a backup and restore. Along the way, he'll provide tips for working with SQL Server Management Studio and some challenges to help you practice what you've learned.
Note: This course will also prepare certification candidates for the "Administer a database" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals.
Introduction
Welcome
Preparing for the MTA Exam 98-364
Using the exercise files
Challenges explained
What you should know
1. Securing the Database Server
Understanding security fundamentals
Securing the database server
Implementing server-level security in SQL Server Management Studio
Understanding Windows authentication
Creating a new Windows user
2. Enforcing Database Roles
Managing password policies
Understanding fixed server roles
Assigning server roles
Challenge: Creating a new user account
Solution: Creating a new user account
3. Working with Fixed Database Roles
Granting access to a database
Understanding fixed database roles
Assigning fixed database roles
4. Assigning Database Object Permissions
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
5. Creating Database Backups
Using SQL Server recovery models
Understanding the available backup options
Creating backups in SSMS
Restoring a database in SSMS
Conclusion
Next steps
Download File Size:173.33 MB