Udemy – SQL Server Performance Tuning Part 1 2020-3

SQL Server Performance Tuning Part 1 is a training course on optimizing the performance and speed of the SQL server, published by Udemy Academy. This training course cannot be specific to a profession and category, and different people such as database administrators, developers, IT specialists, sysadmins and network managers can equally benefit from the valuable topics of this course. . . Optimizing SQL servers and databases has a lot for us and can save us a lot of time and money. To participate in this training course, you must have some mastery of SQL Server management.

Among the most important topics discussed in this course are indexes and indices, waiting statistics, filling factor, preventing fragmentation and data disintegration, manual allocation of space to logs and data. various, tempdb file configuration, etc. are among the most important topics raised in this training course.

What you will learn in SQL Server Performance Tuning Part 1:

• Indexes
• wait stats
• fill factor
• Avoiding fragmentation and disintegration of data
• Manual allocation of space to various logs and data
• config file tempdb
• Common database performance problems and errors and their solutions
• data caching
• virtualization
• And …

Course specifications

Publisher: Udemy
Instructors: Raphael Asghar
Language: English
Level: Beginner
Number of Lessons: 37
Duration: 5 hours and 57 minutes

Course topics

SQL Server Performance Tuning Part 1 Prerequisites

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.

Pictures

SQL Server Performance Tuning Part 1 introduction video

Installation guide

After Extract, watch with your favorite Player.

English subtitle

Quality: 720p

Download link

Download – 717 MB

Size

717 MB