How to Become a World Class SQL Server Performance Tuner

Online Course

Udemy

Go to Udemy

Start Learning

What is the course about?
Prerequisites & Facts
Cost, Certificate & Degree
Reviews & Experiences

What is the course about?

How to Become a World Class SQL Server Performance Tuner

The course How to Become a World Class SQL Server Performance Tuner is an online class provided by Udemy. It may be possible to receive a verified certification or use the course to prepare for a degree.

Use These Scripts in Production Right Now

Course description

How to Become a World Class SQL Server Performance Tuner

By the end of this course you will have a systematic process approach and all the necessary tools needed to begin your journey as a SQL Server performance tuner.
In this course we will define our performance tuning objectives before we dive head first into tuning. What is our end goal? What steps are we going to take to arrive at this goal? Our end goal needs to be realistic and measureable.
Let’s define them right now. Your goal be the end of the course will be speed up data retrieval on the worst performing queries by at least 30%.
Secondly, your goal will be to reduce system stress on either the IO subsystem, memory or cpu by 20%.

You will need to have SQL Server 2012 or 2014 installed. It can be an express version.
I’ll be providing all the scripts and schema for the course. There is no other cost other than the price of the course. Everything else is included or free.
If you don’t have a performance tuning script library then we will start one. If you do, then we will add to it.
If you’re not familiar with SQL Server fundamentals then this course may not be for you. I do appreciate and understand your enthusiasm and promise this course will be here when you’re ready.

1.5 hours on-demand video
13 mins on-demand audio
12 articles
3 downloadable resources
Full lifetime access
Access on mobile and TV
Mike West

Start Learning

Prerequisites & Facts

How to Become a World Class SQL Server Performance Tuner

Course Topic

IT & Software, Operating Systems, SQL Server

University, College, Institution

Udemy

Course Skill Level

see course summary

Course Language

English

Place of class

Online, self-paced (see curriculum for more information)

Degree

Certificate

Start Learning

Degree & Cost

How to Become a World Class SQL Server Performance Tuner

To obtain a verified certificate from Udemy you have to finish this course or the latest version of it, if there is a new edition. The class may be free of charge, but there could be some cost to receive a verified certificate or to access the learning materials. The specifics of the course may have been changed, please consult the provider to get the latest quotes and news.

Udemy

How to Become a World Class SQL Server Performance Tuner

provided by Udemy

Start Learning