SQL Server Performance Tuning Part 1
4.4 (1,013 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,176 students enrolled

SQL Server Performance Tuning Part 1

Detail building blocks of SQL performance tuning
Bestseller
4.4 (1,013 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,174 students enrolled
Created by Raphael Asghar
Last updated 3/2020
English
English [Auto]
Current price: $12.99 Original price: $19.99 Discount: 35% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6 hours on-demand video
  • 7 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • At the end of this course, the student will have extensive knowledge in the following areas: Types of indexes that can affect performance, ability to read and understand the execution plans, determine the causes of wait stats, views deeply into statistics, comprehend the cause of the fill factor and page splits, view various execution modes and much much more
Course content
Expand 37 lectures 05:57:28
+ SQL Server Performance Tuning Part 1 of 2
37 lectures 05:57:28
CREATE A VIRTUAL MACHINE
17:11
CONFIGURING WINDOWS SERVER
08:02
INSTALLING SQL SERVER 2016 PART 1
09:45
INSTALLING SQL SERVER 2016 PART 2
10:15
INSTALLING SSMS
02:05
RESTORING DATABASE
06:34
WHAT IS SQL PERFORMANCE TUNING
10:38
HARDWARE
09:30
DETAIL KNOWLEDGE OF PARTS
05:24
AUTOGROWTH SETTING AND QUIZ 1
09:32
INDEXES
04:39
WHAT IS INDEXING
15:46
CREATE A CLUSTERED INDEX WITH PK
04:47
NON CLUSTERED INDEX
09:58
B TREE
05:27
B TREE NON CLUSTER INDEX
04:11
ANATOMY OF SQL PAGE
05:21
CAUSING A PAGE SPLIT
18:18
TYPES OF INDEXES
03:50
WHAT IS THE QUERY OPTIMIZER
11:05
OPERATORS
07:16
TABLE SCAN
17:17
NON CLUSTERED INDEX PART 1 AND QUIZ 2
12:00
NON CLUSTERED INDEX PART 2
11:56
ORDER OF COLUMN IN NON CLUSTERED INDEX
03:14
FILTER NON CLUSTERED INDEX
09:11
SORT OPERATOR
04:07
JOIN OPERATORS
12:21
STATISTICS
19:05
What is Locking?
11:26
What is blocking?
09:57
DEADLOCKS
08:27
WAIT STATISTICS
14:37
RECOMPILATIONS
07:08
TEMPDB AND QUIZ 3
15:34
Requirements
  • You should have a good understanding of SQL Server Administration. I would highly recommend the following courses: Learn T-SQL from Scratch, SQL Administration part 1, SQL Administration part 2, SQL Administration part 3
Description

This course is designed for any student that is interested in learning about how to fine tune their SQL Server and databases.  Also, developers, SQL DBAs, IT staff and Network Administration

At the end of this course, the student will have extensive knowledge in the following areas:

Indexes, wait stats, fill factor, fragmentation, data and log file allocation, tempdb configuration, common performance issues, blocking, locking, database tuning advisor, execution plan, caching, virtualization and much more

You should have a good understanding of SQL Server Administration.  I would highly recommend the following courses: Learn T-SQL from Scratch, SQL Administration part 1, SQL Administration part 2, SQL Administration part 3

Who this course is for:
  • This course is designed for any student that is interested in learning about how to fine tune their SQL Server and databases. Also, developers, SQL DBAs, IT staff and Network Administration