SQL Server Performance Tuning Part 1

SQL Server Performance Tuning Part 1, available at $59.99, has an average rating of 4.53, with 37 lectures, based on 4752 reviews, and has 20320 subscribers.

You will learn about 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 This course is ideal for individuals who are 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 It is particularly useful 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.

Enroll now: SQL Server Performance Tuning Part 1

Summary

Title: SQL Server Performance Tuning Part 1

Price: $59.99

Average Rating: 4.53

Number of Lectures: 37

Number of Published Lectures: 37

Number of Curriculum Items: 37

Number of Published Curriculum Objects: 37

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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

Course Curriculum

Chapter 1: SQL Server Performance Tuning Part 1 of 2

Lecture 1: DOWNLOAD APPLICATIONS

Lecture 2: SQL Performance Tuning Part 1

Lecture 3: CREATE A VIRTUAL MACHINE

Lecture 4: CONFIGURING WINDOWS SERVER

Lecture 5: INSTALLING SQL SERVER 2016 PART 1

Lecture 6: INSTALLING SQL SERVER 2016 PART 2

Lecture 7: INSTALLING SSMS

Lecture 8: RESTORING DATABASE

Lecture 9: WHAT IS SQL PERFORMANCE TUNING

Lecture 10: HARDWARE

Lecture 11: DETAIL KNOWLEDGE OF PARTS

Lecture 12: AUTOGROWTH SETTING AND QUIZ 1

Lecture 13: INDEXES

Lecture 14: WHAT IS INDEXING

Lecture 15: CREATE A CLUSTERED INDEX WITH PK

Lecture 16: NON CLUSTERED INDEX

Lecture 17: B TREE

Lecture 18: B TREE NON CLUSTER INDEX

Lecture 19: ANATOMY OF SQL PAGE

Lecture 20: CAUSING A PAGE SPLIT

Lecture 21: TYPES OF INDEXES

Lecture 22: WHAT IS THE QUERY OPTIMIZER

Lecture 23: OPERATORS

Lecture 24: TABLE SCAN

Lecture 25: NON CLUSTERED INDEX PART 1 AND QUIZ 2

Lecture 26: NON CLUSTERED INDEX PART 2

Lecture 27: ORDER OF COLUMN IN NON CLUSTERED INDEX

Lecture 28: FILTER NON CLUSTERED INDEX

Lecture 29: SORT OPERATOR

Lecture 30: JOIN OPERATORS

Lecture 31: STATISTICS

Lecture 32: What is Locking?

Lecture 33: What is blocking?

Lecture 34: DEADLOCKS

Lecture 35: WAIT STATISTICS

Lecture 36: RECOMPILATIONS

Lecture 37: TEMPDB AND QUIZ 3

Instructors

Raphael Asghar
Production SQL Database Administrator

Rating Distribution

1 stars: 40 votes
2 stars: 72 votes
3 stars: 571 votes
4 stars: 1848 votes
5 stars: 2221 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu