SQL Server Administration Part 2 (Udemy.com)
Learn how to optimize, improve performance, review and analysis statistics, use monitoring tools, and create indexes
Created by: Raphael Asghar
Last updated August 2018
What you will learn
- At the end of SQL Administration Part 2, the student will be able to create indexes for to gain performance, use the SQL Profiler to find and trouble shoot expensive queries, use the activity monitor for analysis, deploy the performance monitor to find specific about SQL Server internals, use DTA utility, create and investigate issues with DMVs and extended events, look at SQL logs, monitor the health of the SQL Server more efficiently and much more.
Course Description
SQL Administration Part 2 will benefit the student by providing the necessary guide lines for enhancing SQL Server performance by utilizing indexes, reviewing DMVs for analysis, and setting up performance counters for gathering resource metrics; and also I will explain a handful of utilities to gather information about SQL Server internals, such as SQL Profiler, Database Tuning Advisor (DTA), Extended Events, SQL performance monitor, Activity monitor, and teach about partitions, creating contained database for recovery, reviewing SQL server logs and by installing SQL Server 2014 as the newer SQL version.The student will not only add to the knowledge gained bur SQL Administration Part 1, but get prepared for the next course SQL Administration Part 3 – the high availability solutions.
Instructor Details
- 4.6 Rating
3,615 Reviews
Raphael Asghar
Worked as a Production SQL Database Administrator and developer for over 15 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.
More courses by Raphael Asghar
Learn T-SQL From Scratch For SQL Server Administrator (2020)
4.6 (2,904 Reviews)
Provider: Udemy
Time: 8.7h
$10.99
SQL Server Reporting Services Part 1 (SSRS) (2017)
4.6 (2,497 Reviews)
Provider: Udemy
Time: 6.1h
$69.99
More SQL courses
SQL - The Complete Developer's Guide (MySQL, PostgreSQL) (2025)
4.8 (2,153 Reviews)
Provider: Udemy
Time: 19.7h
$94.99
SQL Server High Availability and Disaster Recovery (HA/DR) (2026)
4.8 (1,810 Reviews)
Provider: Udemy
Time: 88.3h
$16.99
70-461 Session 3: Querying Microsoft SQL Server (T-SQL code) (2025)
4.8 (1,094 Reviews)
Provider: Udemy
Time: 3.6h
$12.99
Modern Event-Driven Spring Boot: Kafka & Spring Cloud Stream (2026)
4.8 (494 Reviews)
Provider: Udemy
Time: 13.4h
$10.99
Oracle Database 12c Backup and Recovery using RMAN (2024)
4.8 (428 Reviews)
Provider: Udemy
Time: 20.1h
$34.99
Reviews
By Erick G on 3/11/2026
Very practical and useful way of teaching the topics related to this area, I definitely recommend it to anyone interested on learn this new role. I have learned so much that has helped me to improve in my job activities. Thanks to the Instructor Raphael Asgar, for sharing this knowledge
By Wessels Theron on 2/17/2026
Arguably the best SQL Administration course series i ever did. Very well presented with good audio and slides, and packed with technical theory and easy to follow practical exercises to really just accentuate what is being taught. Learned a ton on this course of which i can now apply to my daily job. Highly recommend !
By Piyush Agarwal on 9/26/2021
This course will seriously help me as a Sql Server database professional with DBA activities. It has given us a platform to know various stuff and from here on we can further explore our self and enhance and take learning to the next level. However, I felt that certain videos could have been edited well.
By Casmir Azih on 8/11/2019
I feel very much improved taking courses from Mr. Asghar. Starting with the free course, I began TSQL from scratch, SQL Server Administration part 1 and having now completed part 2. Mr. Asghar is an amazing instructor and I can't wait to begin part 3. Thank you.
By James Dinser on 4/16/2019
The material itself is great, but there are points for example where when you start the next video and he has a table and database called People3 that he created that wasn't done in previous video or at the beginning of the current video. I find myself back tracking to see if I missed something earlier but cannot find it. So I had to created the database using his script I see on the screen and then just guessing the column details.
By Phat Hoang on 9/3/2018
More real-life examples on extended events similarly to examples on Sql Profiler since the Sql Profiler is deprecated would be very helpful. Besides that I learned a lot from this course.
By Abhay kumar on 5/15/2018
Clear & focus experience Instructor ,having indept knowledge ..Clearly explain the basic and advance ,plus exampled to have L2 knowledge ..Really like the course and love to enroll to NEXT part 3.
By Era Aryal on 5/1/2018
This class is very productive and knowledgeable.We will get a chance to learn new things in as an SQLDBA.I am not an IT background but I learned lots of things from this class.Looking forward to learn the remaining classes of this course.
By Sultan Ahmed on 3/11/2017
Best Production DBA-SQL Server Training Course Ever. Takes his time but explains very well and provides downloadable course material for lectures which makes the process of watching his tutorial, understanding the lecture, and testing them out easy and perfect for learning quickly.
By Phenon Wilkes on 3/15/2016
I am a visual person. Seeing how things work enables me to understand it more clearly. Even though I know what a clustered index is, the demonstration on the clustered video ensures that I have that lasting vision of it and the example of the phone books not increasing in pages was excellent. This course is going to allow me to absorb this information much more clearly ! Thank you, Raph for understanding what it means to TEACH ! ! !
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 92 / 100












