Lynda - Database Fundamentals: Administration
Lynda - Database Fundamentals: Administration
Size: 182MB | Duration: 1h 14m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Beginner | Language: English
Size: 182MB | Duration: 1h 14m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Beginner | Language: 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.
* 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
* 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
Lynda - Database Fundamentals: Administration
No mirrors below please.