Video description
Microsoft's SQL Server platform is one of the top three relational database products in the world's enterprise marketplace, which means that those with SQL Server skills are in high demand everywhere. This course is designed for those who want to become a SQL Server administrator.
The course prepares you to take Microsoft exam 70-764, the first of two tests you must pass in order to earn the Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Administration certification. Passing the 70-764 exam indicates to the world that you have what it takes to administer the SQL database infrastructure.
- Learn about the topics that will be covered on Microsoft exam 70-764
- Get closer to earning the MCSA SQL 2016 Database Administration certification
- Understand the structure and implementation of SQL Server security
- Discover how encryption is utilized and implemented in SQL Server 2016
- Learn how to manage indexes on the SQL Server platform
- See how data backups and restorations happen on the SQL Server 2016 platform
- Survey the tools used to monitor and tune SQL Server performance
Table of contents
- Introduction
- SQL Server Basics
- Getting And Installing SQL Server 2016
- SQL Server Security
- SQL Server Roles
- Encryption
- Index Management
- Backup And Restore
-
Monitoring SQL Server
- Performance And Monitoring Part - 1
- Performance And Monitoring Part - 2
- Session Identification Overview
- Identifying Blocking Sessions Part - 1
- Identifying Blocking Sessions Part - 2
- Understanding UCPs
- Data Collector Basics
- Data Collector Configuration
- Query Store Basics
- Understanding Extended Events
- Creating An Extended Event Part - 1
- Creating An Extended Event Part - 2
- Editing An Extended Event
- Conclusion
Product information
- Title: Administering a SQL Database Infrastructure - Exam 70-764 Certification Training
- Author(s):
- Release date: June 2017
- Publisher(s): Infinite Skills
- ISBN: 9781491989166
You might also like
book
Exam Ref 70-764 Administering a SQL Database Infrastructure
Prepare for Microsoft Exam 70-764—and help demonstrate your real-world mastery of skills for database administration. This …
video
Querying Data with Transact-SQL - Exam 70-761 Certification Training
Microsoft's SQL Server database platform is dominant in the enterprise database marketplace, making those with MS …
book
Windows Server 2016 Administration Fundamentals
Manage and administer your environment with ease About This Book Get your hands on learning the …
video
Windows Server 70-740: Installation, Storage, and Compute with Windows Server 2016
16+ Hours of Video Instruction More than 16 hours of video instruction, quizzes, and exercises to …