Description: SQL Server 2016 provides a comprehensive set of tools for monitoring and tuning to ensure optimal performance for an environment. This course covers performance metrics and monitoring, as well as the various logging tools available with SQL Server, such as perfmon and dynamic management objects. In addition, this course covers Extended Events, and the event-handling system used for monitoring SQL Server instances. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.
Target Audience: Database professionals responsible for implementing and maintaining SQL Server 2016
Duration: 02:07
Description: SQL Server Resource Governor is a feature used to manage SQL Server workloads and resource consumption by specifying limits on resources such as CPU, IO, and memory. This course covers the Resource Governor and the cloud database service, Microsoft Azure Cloud SQL Database. In addition, monitoring and troubleshooting database instances is also covered. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.
Target Audience: Database professionals responsible for implementing and maintaining SQL Server 2016.
Duration: 02:12
Description: Optimizing statistics helps ensure the most efficient means of executing statements in SQL Server 2016. This course covers how to create, modify, and troubleshoot statistics and indexes in SQL Server 2016. This course also covers how to analyze and troubleshoot query plans in SQL Server 2016. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.
Target Audience: Database professionals responsible for implementing and maintaining SQL Server 2016
Duration: 01:59
Description: Locking is a feature in SQL Server 2016 that helps ensure the physical integrity of each transaction. This course covers how to implement and troubleshoot locking, as well as how to minimize, handle, and remediate deadlocks. This course also covers memory-optimized tables, which are used to improve the performance of transaction processing, as well as native stored procedures - a feature used to enable efficient execution of the queries. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.
Target Audience: Database professionals responsible for implementing and maintaining SQL Server 2016
Duration: 01:47
Description: SQL Server transactions allow you to group together a number of statements to form a single logical unit of work. This course covers the various types of transactions, and explains how to implement them in SQL Server 2016. This course also covers isolation levels, a SQL Server 2016 feature that helps control the way locking works between transactions. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.
Target Audience: Database professionals responsible for implementing and maintaining SQL Server 2016
Duration: 01:43
Description: Triggers in SQL Server 2016 are sets of statements that execute automatically when a specific event occurs in a database. This course covers the design and implementation of the various types of triggers found in SQL Server 2016. In addition, this course cover functions, including scalar-valued, table-valued, deterministic, and nondeterministic. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.
Target Audience: Database professionals responsible for implementing and maintaining SQL Server 2016
Duration: 01:55
Description: Constraints can be used in SQL Server 2016 to ensure data integrity. This covers how to design and implement constraints for tables and columns. This course also covers stored procedures, a SQL Server feature that allows you to reuse the code over and over, providing advantages such as performance, productivity, and ease of use. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.
Target Audience: Database professionals responsible for implementing and maintaining SQL Server 2016
Duration: 02:29
Description: Columnstore indexes work differently from traditional indexes in SQL Server 2016. This course covers how to implement columnstore indexes in SQL Server 2016, as well as the various columnstore performance considerations that can impact operations. This course also covers nonclustered indexes, in-memory indexes, and XML indexes. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.
Target Audience: Database professionals responsible for implementing and maintaining SQL Server 2016
Duration: 01:33
Description: SQL Server 2016 uses indexes to speed up the performance of queries and improve overall database performance. This course covers how to design and implement the various index types available in SQL Server 2016. In addition, this course covers enhancing usability in SQL Server 2016 by using views. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.
Target Audience: Database professionals responsible for implementing and maintaining SQL Server 2016
Duration: 02:05