Microsoft SQL Server 2012 – Developing Databases: Tuning and Optimizing Queries


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
With its blend of visual tools and powerful Transact-SQL language, SQL Server 2012 will continue to enjoy large market share in the relational database management sphere. Database developers that use SQL Server will experience measureable benefits from obtaining Microsoft’s MCSE certification relating to SQL Server 2012. This course is one of a series in the Skillsoft learning path that covers the objectives for the Exam 70-464: Developing Microsoft SQL Server Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.

Target Audience
Database Administrator and developers who create and manage databases within their organization as part of their daily tasks. This can include creating the database objects, ensuring their security, implementing and ensuring data integrity, managing transactions and locks, and ensuring the server instance and database are running efficiently.

Prerequisites
None

Expected Duration (hours)
1.5

Lesson Objectives

Microsoft SQL Server 2012 – Developing Databases: Tuning and Optimizing Queries

  • differentiate between tools for analyzing queries
  • recognize the functions of DMVs
  • determine the most appropriate transaction isolation level to used in a certain situation
  • identify sources where Extended Events correlate data from
  • troubleshoot poorly performing applications in a database
  • Course Number:
    md_dsqd_b07_it_enus

    Expertise Level
    Intermediate