The ‘SQL Server Administration Part 2’ course on udemy will guide you in enhancing the performance of the SQL server by teaching various SQL techniques. Utilizing indexes, reviewing DMVs for analysis, and setting up performance counters for gathering resource metrics are the main topics covered in this SQL course.
The course gives you the complete knowledge of ‘SQL Administration part 2’ and acts as an add-on course to the ‘SQL Administration part 1’. The course is usually available for INR 2,699 on Udemy but you can click on the link and get the ‘SQL Server Administration Part 2’ for INR 499.
Who all can opt for this course?
- Students interested in administering SQL Server.
- Programmers, system administrators, IT managers, and anybody else in charge of the databases.
Course Highlights
| Key Highlights | Details |
|---|---|
| Registration Link | Apply Now! |
| Price | INR 499 ( |
| Duration | 10 Hours |
| Rating | 4.6/5 |
| Student Enrollment | 14,978 students |
| Instructor | Raphael Asghar |
| Topics Covered | SQL Performance Monitor, DMV, BCP, Database Management, and SQL Profile with Index Tuning |
| Course Level | Intermediate |
| Total Student Reviews | 2,554 |
Learning Outcomes
- Be able to use the activity monitor for analysis.
- Deploy the performance monitor to find specific information about SQL Server internals.
- Use the DTA utility.
- Create and investigate problems with DMVs and extended events.
- Monitor the health of the SQL Server more effectively.
Course Content
| S.No. | Module (Duration) | Topics |
|---|---|---|
| 1. | SQL Administration Part 2: SQL Performance methods and SQL Server utilities (10 hours 12 minutes) | Introduction |
| Install SQL Server 214 | ||
| Install SQL Suite | ||
| POST ADDENDUM | ||
| APPS NEEDED | ||
| CREATE VM | ||
| INSTALL SQL SERVER 2017 | ||
| ADVENTUREWORKS 2017 DB | ||
| COMPARISON SQL SERVER 2014 VS 2017 | ||
| Clustered Index | ||
| Create non cluster index | ||
| Composite Index | ||
| Use or not use indexes | ||
| Deciding factors in creating indexes | ||
| using sql profler for indexes | ||
| Reorganize and Rebuild Indexes | ||
| Into To SQL Profiler | ||
| SQL Profiler longest running query | ||
| Audit logins | ||
| SQL Profile with Index Tuning | ||
| SQL Profiler Best Practice | ||
| SQL Server Side Trace | ||
| Database Engine Tuning Advisor | ||
| Statistics | ||
| Activity Monitor | ||
| SQL Performance Monitor | ||
| SQL Performance hardware issues | ||
| SQL Performance Monitoring Hardware CPU | ||
| SQL Performance Monitoring Hardware memory | ||
| SQL Performance Monitoring Hardware disks | ||
| 23 SQL Perfmon scehdule | ||
| DMV | ||
| Block and Locks | ||
| BLOCKING | ||
| Deadlock | ||
| Extended Events | ||
| Extended Events via TSQL | ||
| Database Snapshots | ||
| Import Export Data | ||
| BCP | ||
| Partition | ||
| Partition part 2 | ||
| Partition 3 | ||
| Contained datababase Part 1 | ||
| Contained datababase Part 2 | ||
| Policy Based Management | ||
| Linked Servers | ||
| SQL server and agent logs | ||
| SQL ADMINISTRATION PART 3 |
Resources Required
- Any desktop or laptop computer will do for a student.
- Students will require SQL Management Part 1 as a prerequisite.
- Instructor will send the student a zip file with all scripts and supporting materials.
Featured Review
Francis Opoku (5/5) : If this course did not make sql database administration fun and easy, then I’m sorry you have to chose another field. i will say it again, this is the best sql dba course you can have.
Pros
- Nivin M Sasi (5/5) : Our application is running with SQL DB, after taking this course I could apply the best practices in administering the database which helped me a lot to improve my system performance.
- Sri Tekal (5/5) : this course is one of the best course and it covers all aspects of sql server administration.
- Kimberly Emerson (5/5) : This was the best resource in helping me pass the 70-462 exam.
- Alhaji Conteh (5/5) : Taking classes with Raphael Asghar is the best investment I have ever made.
Cons
- Mj Saurondon (1/5) : Please try to watch at least 30% of courses before reviewing.
- DBA Cloud (2/5) : Also Video resolution are also poor 720p on a Big screen..
- Surendhar B (1/5) : Not in Detail and Titles are not relevant to the Video.
- Mj Saurondon (1/5) : Also note, there are a few students that review the course without even completing 5% of the course.
About the Author
The instructor of this course is Raphael Asghar who is a Production SQL Database Administrator. With 4.5 Instructor Rating and 26,633 Reviews on Udemy, Instructor offers 25 Courses and has taught 133,378 Students so far.
- Instructor has worked for more than 15 years for several businesses, including Neutrogena, BakeMark, Solutions2Go, and NextGen, as a Production SQL Database Administrator and developer.
- Instructor assist those students who require more than just the fundamentals of SQL.
- Instructor creates practical courses for students seeking a direct route to becoming SQL DBAs.
- Instructor adores maintaining and constructing a reliable SQL architecture environment, which is what SQL administration is all about.
Comparison Table
| Parameters | SQL Server Administration Part 2 | SQL Server Administration Part 3 | SQL Server Administration Part1 |
|---|---|---|---|
| Offers | INR 499 ( | INR 499 ( | INR 499 ( |
| Duration | 10 hours | 8.5 hours | 10 hours |
| Rating | 4.6/5 | 4.7/5 | 4.5/5 |
| Student Enrollments | 14,612 | 11,732 | 20,595 |
| Instructors | Raphael Asghar | Raphael Asghar | Raphael Asghar |
| Register Here | Apply Now! | Apply Now! | Apply Now! |
Leave feedback about this