IIRF Online > Development > Database Design & Development > SQL Server > SQL Server Performance Tuning Part 1
SQL Server Performance Tuning Part 1 by Udemy
Detail building blocks of SQL performance tuning
Course Highlights
- 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...
Skills you will learn!
Curriculum
37 Topics
DOWNLOAD APPLICATIONS
SQL Performance Tuning Part 1
CREATE A VIRTUAL MACHINE
CONFIGURING WINDOWS SERVER
INSTALLING SQL SERVER 2016 PART 1
INSTALLING SQL SERVER 2016 PART 2
INSTALLING SSMS
RESTORING DATABASE
WHAT IS SQL PERFORMANCE TUNING
HARDWARE
DETAIL KNOWLEDGE OF PARTS
AUTOGROWTH SETTING AND QUIZ 1
INDEXES
WHAT IS INDEXING
CREATE A CLUSTERED INDEX WITH PK
NON CLUSTERED INDEX
B TREE
B TREE NON CLUSTER INDEX
ANATOMY OF SQL PAGE
CAUSING A PAGE SPLIT
TYPES OF INDEXES
WHAT IS THE QUERY OPTIMIZER
OPERATORS
TABLE SCAN
NON CLUSTERED INDEX PART 1 AND QUIZ 2
NON CLUSTERED INDEX PART 2
ORDER OF COLUMN IN NON CLUSTERED INDEX
FILTER NON CLUSTERED INDEX
SORT OPERATOR
JOIN OPERATORS
STATISTICS
What is Locking?
What is blocking?
DEADLOCKS
WAIT STATISTICS
RECOMPILATIONS
TEMPDB AND QUIZ 3
SQL Server Performance Tuning Part 1
Related SQL Server Courses
Thank You!
Your review has been submitted successfully.