Contact us

Madeira Data Solutions

Your Data, Our Solutions

Advanced Programming and Query Tuning in SQL Server

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).

 

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. Students should be familiar with basic programming and with the syntax of Transact-SQL.

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

A28A8655

 

Schedule

  • 5 days
  • 40 academic hours
  • Upcoming class opening: 8/9/2016

 

Syllabus
 Download here – Advanced Programming and Query Tuning in SQL Server Course Syllabus

 

Materials

  • Disk-on-key with all the course materials:
    • Presentations
    • Demonstrations
    • Class exercises & solutions
    • Homework
    • Additional resources