SQL Server Performance Tuning Part 1

5,176 students enrolled

SQL Server Performance Tuning Part 1

Detail building blocks of SQL performance tuning

Bestseller

5,174 students enrolled

Created by Raphael Asghar

Last updated 3/2020

English

English [Auto]

Preview this course

SQL Server Performance Tuning Part 1

$12.99 $19.99 35% off

2 days left at this price!

30-Day Money-Back Guarantee

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

+ – SQL Server Performance Tuning Part 1 of 2

37 lectures 05:57:28

DOWNLOAD APPLICATIONS

Preview 08:32

SQL Performance Tuning Part 1

Preview 13:02

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

Featured review

Andrew McLaughlin ( 57 courses, 20 reviews )

a year ago

Great course. Long time student of Raphael, always happy with his content. Overall, this course is a hands-on, example driven overview of a lot of important concepts. Several topics are introduced. I already feel more comfortable with execution plans and have a deeper understanding of how indexes work. I'm looking forward to taking Part 2 of this series.