Udemy – SQL Server Performance Tuning Part 2 2018-5

SQL Server Performance Tuning Part 2 is a training course on increasing the speed and optimization of SQL servers and databases / Part 2, which was published by Udemy Academy. In this training course, common bugs and functional errors in databases and SQL servers are known and ways to fix them are learned. All database administrators should master the training skills given in this course in order to design stable and fast databases. This training course is the second and last part of a comprehensive two-part series that was published on the website a while ago. There are tools available to optimize databases, among the most important of which, performance monitor, DTA, DMV, extended events, and profilers can be mentioned.

Among the most important topics raised in this course, we can mention indexing optimization, page separation, tempb site, recompilation of repeated and saved projects, etc.

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

• Indexing optimization
• Separation of pages
• Sizing tempb
• Recompile duplicate and stored procedures
• Working with various database optimization tools and software such as performance monitor, DTA, DMV, extended events and profilers
• And …

Course specifications

Publisher: Udemy
Instructors: Raphael Asghar
Language: English
Level: Beginner
Number of Lessons: 41
Duration: 7 hours and 35 minutes

Course topics

SQL Server Performance Tuning Part 2 Prerequisites

SQL performance tuning part 2 requires that you MUST have SQL performance tuning part 1 course and SQL administration part 1,2,3 as well as Learn T-SQL courses. All SQL Server application, Virtual Box application and Windows 2016 operating system will be available as a trail period for 6 months via downloads

Pictures

SQL Server Performance Tuning Part 2 introduction video

Installation guide

After Extract, watch with your favorite Player.

English subtitle

Quality: 720p

Download link

Download Part 1 – 1 GB

Download Part 2 – 1 GB

Download Part 3 – 1 GB

Download Part 4 – 1 GB

Download Part 5 – 866 MB

Size

4.9 GB