- For the first challenge of this course,…I'd like you to create a new user account…for a new hire at H Plus Active.…The user's name is Angela Hashton.…We'll want her to establish her own password…when she first logs in,…and she needs to have the ability…to create new databases on the server…as well as configure and shut down the server.…I estimate that creating the new user login…will take no more than five minutes.…Good luck!…
Resume Transcript Auto-Scroll
Author
Adam Wilbert
Released
11/3/2015
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.
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.
Topics include:
- Securing the database server
- Understanding Windows authentication vs. SQL Server authentication
- Assigning fixed server roles and fixed database roles
- Granting object-level permissions
- Understanding ownership claims
- Creating backups
- Restoring a database
Skill Level Beginner
1h 14m
Duration
127,408
Views
Show More
Show Less
-
Introduction
-
Welcome1m 4s
-
What you should know1m 41s
-
-
1. Securing the Database Server
-
Securing the database server2m 40s
-
Creating a new Windows user4m 24s
-
2. Enforcing Database Roles
-
Managing password policies5m 45s
-
Assigning server roles3m 22s
-
-
3. Working with Fixed Database Roles
-
4. Assigning Database Object Permissions
-
Managing roles1m 46s
-
5. Creating Database Backups
-
Creating backups in SSMS1m 54s
-
Restoring a database in SSMS2m 12s
-
Conclusion
-
Next steps35s
-
Show MoreShow Less
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Challenge: Creating a new user account