SQL Server Performance Tuning Part 1 (Udemy.com)

Detail building blocks of SQL performance tuning

( 50 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 : 84 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a sql course? Or looking for more detail on Raphael Asghar's SQL Server Performance Tuning Part 1? Feel free to chat below.

Join CourseDuck's Online Learning Discord Community

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

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

Instructor Details

Raphael Asghar

4.2 Rating
50 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.

SQL in Motion (2017)

0.0 (0 Reviews)

Provider: Manning Publications
Time: 4h

$59.99

Introduction to SQL (2015)

0.0 (0 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

Reviews

4.2

50 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Harshvardhan Sharma on

Everything is awesome.Content,example and explanation all are very good.After this course i feel very confident about SQL performance tuning .one thing i would like to suggest you that you should provide cheat sheet for this course so that we can revisit it in a less time.

By Nagaraju Mendi on

Topics were explained very well. There is no video explaining FILL FACTOR listed under the course material folder - 30.

By Abishek Timothy on

Very Useful and Learnt many things for SQL Performance.

By Selcuk KILINC on

I think this course time is too short. My advice is prepare new videos for each topics. For example wait stats is very important subject and you should make a new video series only about wait stats.

By Baohua Xu on

From Database and Querying/System/Abstract Data Types/ point of views to learn computer science/programming, the production DBA will know more than general computing. It is a real great course for DBA.

By Connexall Dev Training on

bottlenecks and issues are talked but not the troubleshooting and practical solution

By Ian Sothcott on

I enjoyed this course. Are there any files where I can copy some of the code?

By Darin H Searcy on

Examples were good. Teacher was a bit scattered and could improve presentation style for clarity. For example, he would sometimes use the wrong word by mistake, saying "table" instead of "column" (or similar). Also, the Part 1 course contained a few practical techniques but most of the real solutions are reserved for Part 2. Courses could be combined.

By vilas Awari on

Awesome.. explained all the things in very detail steps..love it

By Janio Azevedo on

Good examples in each situation, well explained, links and attachments should be divided between the lessons, it will be more clear and easy to use the examples

By Farhang Nosratmakuee on

As an overview, it was good but didn't go deep into the details and was fairly short for a performance tuning course but may be part 2 covers it in more detail

By Vijay Kishore Vittapu on