News

Webinars from Spindustry on SharePoint, MS Teams, and Power BI

Spindustry offers a variety of ways to learn more about solutions to benefit your business. Below is a list of upcoming webinars or pre-recorded sessions that we hope you find helpful.

Spindustry Training Offers SharePoint Governance Consulting

Avoid costly, time consuming mistakes with your SharePoint installation.

Live Instructor-Led Training

The Power to Boost Productivity!


CONTACT US
Training partners

Spindustry Training

spindustrytraining.com - (515) 334-9556

Bookmark and Share

SQL Server Database Optimization and Performance Tuning

Course Code: STT-SQLDBO
Length: 1 Day
Tuition: $699.00

Schedule for this Course

There are no dates scheduled for this course.
If you would like to be added to the wait list for this class Click Here

Course Description:

This course provides students with select essential skills need by Microsoft SQL Server developers and administrators.

At the end of this hands-on course, students will be able to optimize queries, tune indexes to increase query performance, and set up monitoring for performance.  Students will also be able to identify options for refactoring cursors.

The techniques taught in this course apply to Microsoft SQL Server 2008, 2008R2, 2012, 2014, 2016

Prerequisites

  • 6 months or more of writing queries using SQL.
  • 6 months or more experience working with Microsoft SQL Server.
  • A basic understanding of indexing.
  • Experience writing cursors is not required but will help.

Course Outline:

The outline for this course includes:

  1. Query Optimization
  2. Index Optimization
  3. Monitoring for performance
  4. Refactoring Cursors
  5. CLR Overview
  6. Memory Optomized Queries

back to top