How to Become a World Class SQL Server Performance Tuner
Use These Scripts in Production Right Now
Affiliate disclosure: if you enroll through links on this page, the course provider may pay us a commission. This comes at no extra cost to you and does not influence how we describe courses.
What You'll Learn in This Course
Master key concepts and practical skills through structured learning modules. By completing this curriculum, you'll gain valuable expertise applicable to real-world scenarios.
Learning Outcome 1
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.
Learning Outcome 2
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.
Learning Outcome 3
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%.
Learning Outcome 4
Secondly, your goal will be to reduce system stress on either the IO subsystem, memory or cpu by 20%.
Skills You'll Develop
This comprehensive How to Become a World Class SQL Server Performance Tuner curriculum is designed to take you from foundational concepts to advanced implementation. Each module builds upon the previous, ensuring a structured learning path that maximizes knowledge retention and practical application.
Course Requirements & Target Audience
Understand what you need to succeed in this course and determine if it's the right fit for your learning goals
Prerequisites & Requirements
What you need before starting this How to Become a World Class SQL Server Performance Tuner course:
- 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.
Who This Course Is For
This course is perfect for:
- Motivated learners at any level
- Self-paced students
- Anyone interested in the subject
This course might not be suitable if:
- • You're looking for a quick tutorial rather than comprehensive learning
- • You prefer learning without structured curriculum
- • You need highly specialized or niche content
Course Information & Details
Everything you need to know about this online course, from duration to certification
Course Instructor
Mike West
Expert instructor with industry experience
Course Language
English
All materials in English
Start Your Learning Journey Today
This online course offers comprehensive training with expert instruction, practical exercises, and a certificate of completion. Join thousands of students advancing their careers through quality online education.
Course Enrollment
Budget-Friendly Course
Typically around $19.99
Pricing may vary. Check the course provider for current promotions and exact pricing.
What's Included
- 1.5 hours on-demand video
- 3 downloadable resources
- 12 articles
- Access on mobile and TV
- Full lifetime access
- 13 mins on-demand audio
Affiliate disclosure: if you enroll through links on this page, the course provider may pay us a commission. This comes at no extra cost to you and does not influence how we describe courses.
- ✓Instant access after enrollment
- ✓Learn at your own pace
- ✓Direct enrollment with Udemy
Where this course fits
Certifications in this area
Concepts behind this area
VLAN (Virtual LAN)
A VLAN divides one physical switched network into several logical segments, each with its own broadcast domain, by tagging frames with a VLAN identifier so that ports and devices in different VLANs cannot reach each other without a router.
NAT (Network Address Translation)
Network address translation rewrites the addresses and ports in packets as they cross a network boundary, most commonly so that many devices with private addresses can share one public address to reach the internet.
DHCP (Dynamic Host Configuration Protocol)
DHCP is the protocol by which a device joining a network asks for and receives an address, a subnet mask, a default gateway and DNS servers from a server, for a limited lease period, so that nobody has to configure addresses by hand.
Uptime & SLA
Uptime is the proportion of time a service answers requests, quoted in nines, and a service level agreement is the contract clause setting out how that proportion is counted and what the provider owes when it falls short.
Kubernetes
Kubernetes is an open-source system that runs containers across a cluster of machines, keeping the number and placement of running copies matched to a declared desired state, and restarting, rescheduling and scaling them without a person intervening.
Shared Hosting
Shared hosting puts your website on a machine that is simultaneously running hundreds of other people's, pooling its processor, memory and disk between all of you, which is both why it costs so little and why your speed partly depends on strangers.
The field, explained: Hosting & Cloud
Wider context: the fields we cover, the glossary and certification exams, all written by us rather than pulled from a provider feed.
