SQL Server Administration Part 2

Learn how to optimize, improve performance, review and analysis statistics, use monitoring tools, and create indexes

4.60 (3295 reviews)

Udemy

platform

English

language

Databases

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.

Loading charts...

Comidoc Review

Our Verdict

SQL Server Administration Part 2 offers a comprehensive exploration of various administration tools and techniques, with an emphasis on performance optimization and monitoring. Despite minor issues such as wording mistakes, redundant content, and occasional audio cuts, the course remains valuable for learners seeking to improve their SQL Server administration skills. The course provides practical examples, real-world scenarios, and suggestions for further learning that contribute to a well-rounded educational experience.

What We Liked

Covers a wide range of SQL Server Administration topics, allowing learners to gain comprehensive knowledge
In-depth discussions on performance optimization and monitoring tools
Provides practical examples and methods for further learning
Real-world scenarios presented which enhance understanding of daily DBA tasks

Potential Drawbacks

Occasional wording mistakes that could be distracting for some learners
Some redundant content, including install videos for different SQL Server versions
Lack of proofreading leading to audio cuts and incomplete processes shown
Course delivery is relatable but could benefit from improved editing and fewer errors