SQL Server Performance Tuning Part 1 (Udemy.com)

Detail building blocks of SQL performance tuning

( 265 Reviews )

Created by: Raphael Asghar

Produced in 2017

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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 88 / 100

Course Description

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

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

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

You should have a good understanding of SQL ServerAdministration. I would highly recommendthe following courses: Learn T-SQL from Scratch, SQL Administration part 1, SQLAdministration 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

Time: 6h

Instructor Details

Raphael Asghar

4.4 Rating
265 Reviews

Worked as a Production SQL Database Administrator for over 12 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA. I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.