Size: 753 MB | Duration: 5h 29m | Video: AVC (.mp4) 1280×720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English
SQL Server comes with many features for monitoring, securing, optimizing, and supporting your database infrastructure. Learn how to use these features to administer your SQL Server instances, and prepare for the Microsoft MCSA Administering a SQL Database Infrastructure (70-764) certification exam. Adam Wilbert covers four main skill areas required of SQL Server 2016 administrators: configuring access to data, managing backups, monitoring performance, and implementing the high-availability features of the product. Learn about data encryption, access control, role-level security, and dynamic data masking. Use SQL Server auditing to gain insights into the health and performance of your system, and determine upgrade paths. Discover how to back up SQL Server and perform full or partial restores, and monitor activity. Explore indexing and query execution plan management. Plus, learn to configure availability groups to mitigate hardware failure.
* Configuring backup and connection encryption
* Creating and maintaining users
* Managing permissions and roles
* Configuring SQL Server auditing
* Developing a backup strategy
* Restoring databases
* Identifying and recovering from corruption
* Monitoring database activity and queries
* Managing indexes
* Managing statistics
* Monitoring instances
* Implementing log shipping
* Implementing always on availability groups
Download 百度云
你是VIP 1个月(1 month)赞助会员，
转载请注明：0daytown » Lynda – SQL Server 2016: Administer a Database Infrastructure