Raphael Asghar
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
Courses : 11
Specification: SQL Server Administration Part 2
|
22 reviews for SQL Server Administration Part 2
Add a review
| Price | $13.99 |
|---|---|
| Provider | |
| Duration | 10 hours |
| Year | 2018 |
| Level | Beginner |
| Language | English |
| Certificate | Yes |
| Quizzes | No |
$13.99
Latif Ali Khan –
Just finished Part 2. It is fun. The professor is awesome and you won’t get bored listening to him. I will recommend to Professor to spend more time with GUI because TSQL Scripts are hard to memorize. Thank you Professor for giving me hope to become TSQL DBA in the future.
Tcd –
Sometimes videos are getting struck and unplayable.
Richard W. Memmer –
Top notch, as expected!
Moshe Dayan –
Liked the explanation. Really cool.
A raja –
well explained
Olatunji Ismaila –
The course has increased my confidence in my new environment
Daniel Alberto Romo Alonso –
Very useful for practical cases!
Tom Gilmour –
Well delivered, lots of practical demonstrations, the presenter is clear, concise, and demos are thorough. Looking forward to doing part 3.
Sneha G.K –
The course was excellent.It helped me answer so many queries put up by my interviewer.Thank you Rafael for your great explanation of concepts.
Quintus Nortje –
Amazing course. Very detailed and broad knowledge and experience. Your courses have helped me understand a lot more than I already knew about SQL. Thanks!!
Shiva Vadde –
Nice explanation
Thomas Romero Jr –
very well explained course.
Tshepang Mokgobo –
Raphael is a very good teacher. He keeps you glued to your screen so as not to miss any of the demonstrations that he is doing. I am gaining so much more from his course
Amit Agrahari –
I am truly liking all your courses. As I am getting to know so much about SQL Server although I was having 5 years of experience as a SQL DBA but i was unaware about the details of each and every thing taught by you.
Veera Venkata Lakshmi Prasanna Chinni –
good
Adedapo Adeyemi –
Well structured introduction
Sachin –
Good course.
Jenny Niu –
very good instructor and can fellow step by step!
Ramdayal Gupta –
Good!
Dusmanta Parida –
It is very good learning.
R K –
**PLEASE DONT BUY** My Opinion Part1 +part2 …. sofar I feel my time is getting burnt. With the same install videos again , again & again. Sofar getting Frustrated. Sorry to use the words. VM install + 2012 install twice; VM install + 2014 install, VM install + 2016 install, VM install + 2017 install Felt More than 60% of video is redundant sofar*** The course would have been best if Ideally it was Organized, avoided redundant actions and steps.. avoid repeating the words , again & again . & most of the commands discussed are spoon feeding which is aint required. Video on difference 2014 vs 2017 nothing discussed other than saying obvious & 2017 compatible on Linux.. Part1,2 > 16 hrs course ; SQL SERVER ARCHITECTURE { Memory/ Clustered Not explained. Difference to Other Database Engine not Explained. disappointing.. Advert on Part3, & Performance Tuning, Other videos to Buy which should include HA & replication concepts fair enough >Though THESE Advert VIDEOS SHOULD NOT be a part of PAID subscription. (May be a Free Video outside the training Videos. for interest. ) making mistakes and correction on video understandable) but done on multilpe modules.. value of Time? ** no questions on instructor.. he is highlyskilled ** But the rating reflects on TIME Efficiency & Quality of information on the Training Videos in 16 hours.. Virtual Training and Class Room training are 2 Different approach ( in VT we could repeat & slow/fast (speed), no necessary for redundant information) (@instructor, as a feedback ..Gentle & kind Note sir, please consider to review some of the presentation of Maria Billings on Oracle training videos. > Specific to content discussed; Time Efficient and Deep Dive) I generally ignore & avoid writing negative feedback. Though i had made this CONCIOUS EFFORT . All videos/documents are available in YOU TUBE; & google. ONe of the reason we still buy is Value of time factor { avoid time investing on searching best video/document or seeing redundant details) @Instructor, With Due respect. with 4.5+ rating .. Sir, I was very disaapointed. Also Video resolution are also poor 720p on a Big screen.. its very blurry,
Dheeraj Rao –
Very nice Demo.