Skip to content
UdemySqlPaid courseBeginner levelCertificate

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

icon
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.

icon
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.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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.

icon
More courses by Raphael Asghar

$11.99

$11.99

$10.99

$69.99

$10.99

$69.99

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

icon
Reviews

4.6

3,615 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

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 ! ! !

Showing all 10 reviews on CourseDuck

Read all 3,615 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100