Advanced Programming and Query Tuning in SQL Server

Rating:
1 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 5
Loading...
Please Log in or register to rate

Advanced Programming and Query Tuning in SQL Server

DB-209

The Advanced Programming and Query Tuning in SQL Server course takes programming and query tuning in SQL Server from the basic level to the advanced, providing students with tools and techniques that will allow them to write code for a broad range of requirements while optimizing performance, and on the other hand, optimize performance of existing SQL Server queries and processes. Throughout the course, the students will analyze different case studies while comparing several approaches for each one and choosing the best solutions.

The course is based on SQL Server 2014, but it is relevant also for previous versions of SQL Server (2005/2008/2008R2/2012/2016).

Audience

Target Audience:
The course is intended for SQL Server DBA’s and developers who are responsible for either writing Transact-SQL queries or tuning already written Transact-SQL queries.

Prerequisites:
Students should be familiar with basic programming and with the syntax of Transact-SQL.

Course Objectives
  • Understand the various data structures and data types within SQL Server
  • Be able to design and utilize indexes and statistics efficiently
  • Learn best practices for using programming objects in SQL Server
  • Understand how the query processor works
  • Learn to write efficient Transact-SQL code using advanced techniques
  • Understand how to read and analyze execution plans
  • Acquire techniques for efficient query tuning
© Copyright - Skilit - Site by Dweb