->
Lynda - SQL Server 2016: Administer a Database Infrastructure
Categories: Tutorials
Lynda - SQL Server 2016: Administer a Database Infrastructure - 594443
Lynda - SQL Server 2016: Administer a Database Infrastructure
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.


Table of Contents

  • Introduction
  • 1. Configure Encryption
  • 2. Configure Data Access and Permissions
  • 3. Configure Auditing
  • 4. Develop a Backup Strategy
  • 5. Restore Databases
  • 6. Manage Database Integrity
  • 7. Monitor Database Activity
  • 8. Monitor Queries
  • 9. Manage Indexes
  • 10. Manage Statistics
  • 11. Monitor SQL Server Instances
  • 12. Implement Log Shipping
  • 13. Implement Always On Availability Groups
  • Conclusion

    • Lynda - SQL Server 2016: Administer a Database Infrastructure


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.


    Categories Sitemap



    rss