We may earn an affiliate commission when you visit our partners.
Raphael Asghar
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/gzkdki/sql
What's inside
Learning objective
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.
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.
Syllabus
At the end of this section, the students will have a clear understanding of how to enhance performance by utilizing indexes, proactively monitor the SQL Servers with SQL Server utilities and much more
Read more
Syllabus
At the end of this section, the students will have a clear understanding of how to enhance performance by utilizing indexes, proactively monitor the SQL Servers with SQL Server utilities and much more
Read more
Traffic lights
Traffic lights
Read about what's good
what should give you pause and
possible dealbreakers
Teaches techniques to improve SQL Server performance, such as creating indexes and using the SQL Profiler
Provides an overview of SQL Server logs, allowing learners to monitor the health of the SQL Server more efficiently
Covers essential topics related to SQL Administration, such as using DTA utility and investigating issues with DMVs
Prepares learners for the next course in the SQL Administration series, which covers high availability solutions
Taught by Raphael Asghar, who has extensive experience in SQL Server Administration
Requires SQL Server 2014 or 2017, which may not be the latest versions available
Save this course
Create your own learning path.
Save this course to your list so you can find it easily later.
Save
Save
Reviews summary
In-depth sql server admin skills
According to students, this course offers a strong continuation of SQL Server administration training, delving into crucial topics like performance tuning, monitoring tools, and troubleshooting. Learners particularly value the instructor's deep knowledge and practical insights, finding the explanations clear and the content highly relevant to real-world scenarios. The course provides helpful demos and hands-on exercises to reinforce understanding. While the coverage is generally well-received, some learners note that the pace can be fast at times and certain advanced topics might benefit from greater depth. The use of older SQL Server versions (like 2014/2017) in some examples is also mentioned as a potential point for updating, though the core concepts remain valuable.
Examples use older SQL Server versions.
"Note that the course uses SQL Server 2014 and 2017 for demos."
"While the concepts are timeless, using slightly older versions might require minor adjustments for those on newer editions."
"I had to adapt some examples because I'm using SQL Server 2019."
"The setup section refers to older versions, which might confuse some learners."
"Would be beneficial if examples were updated to a more recent SQL Server version."
Includes useful demos to illustrate concepts.
"The demos using SQL Profiler and Performance Monitor were very helpful in seeing how the tools work in action."
"Hands-on examples for creating and tuning indexes solidified my understanding."
"The demos on monitoring tools like Activity Monitor were easy to follow and replicate."
"Appreciate the practical walkthroughs provided for key admin tasks."
"Seeing the tools used with actual data made the concepts much clearer."
Course covers essential admin tasks and tools.
"This course dives into the tools and techniques needed for performance monitoring and troubleshooting, which are critical admin skills."
"Topics like index tuning, profiler, activity monitor, and DMVs are exactly what administrators need to know daily."
"The sections on blocking, deadlocks, and extended events are very useful for diagnosing database issues."
"Covers a lot of ground essential for managing SQL Server efficiently."
"Provides practical knowledge applicable immediately in my job role."
Instructor shares deep expertise effectively.
"The instructor clearly knows his stuff and explains complex topics like indexing and monitoring very well."
"I really appreciate the instructor's practical approach; he shares valuable real-world tips."
"Great content explained by an expert in the field."
"I found the instructor's explanations on DMVs and Extended Events particularly insightful and easy to follow."
"His knowledge of SQL Server internals shines through, making the lectures very informative."
Some sections feel rushed or need more detail.
"While comprehensive, some topics felt a bit rushed and could have gone deeper into specifics."
"I found the pace to be quite fast in places, making it hard to keep up without pausing frequently."
"Certain advanced concepts were introduced but perhaps not explored in enough depth for a 'part 2' course."
"Could use more detailed explanations for beginners transitioning from part 1."
"Some lectures move very quickly through dense material."
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in SQL Server Administration Part 2 with these
activities:
Review SQL
Show steps
Refresh your SQL knowledge before the course begins to ensure a stronger foundation.
Browse courses on
SQL
Show steps
-
Review SQL syntax and commands
-
Practice writing simple SQL queries
Review SQL
Show steps
Review the basics of SQL to strengthen your foundation before starting the course.
Browse courses on
SQL
Show steps
-
Install a SQL development environment
-
Create a new database
-
Write basic SELECT queries
-
Write basic INSERT, UPDATE, and DELETE queries
-
Practice using SQL to manipulate data
Participate in SQL study groups
Show steps
Join SQL study groups to collaborate with peers, discuss concepts, and learn from each other.
Show steps
-
Find or create a SQL study group
-
Attend study group meetings regularly
-
Actively participate in discussions
-
Share your knowledge and help others
Nine other activities
Expand to see all activities and additional details
Show all 12 activities
Learn about SQL Server Tools
Show steps
Explore and familiarize yourself with the different tools provided by SQL Server to enhance your SQL administration skills.
Show steps
-
Watch tutorials on SQL Server Profiler, Activity Monitor, and Performance Monitor
-
Try out the tools in your own SQL Server environment
Follow SQL tutorials
Show steps
Follow online tutorials to reinforce your understanding of SQL concepts.
Show steps
-
Search for SQL tutorials on topics you need to strengthen
-
Follow the tutorials step-by-step
-
Practice the concepts covered in the tutorials
SQL Query Practice
Show steps
Continuously practice writing SQL queries to improve your proficiency.
Show steps
-
Solve SQL query problems on online platforms
-
Create your own SQL queries to practice
Solve SQL practice problems
Show steps
Solve SQL practice problems to test your understanding and identify areas for improvement.
Show steps
-
Find SQL practice problems online or in textbooks
-
Attempt to solve the problems on your own
-
Check your solutions against the provided answers
-
Review and learn from your mistakes
Mentor junior SQL learners
Show steps
Mentor junior SQL learners to reinforce your understanding and help others succeed.
Show steps
-
Identify opportunities to mentor junior SQL learners
-
Share your knowledge and experience
-
Provide guidance and support
-
Encourage and motivate learners
Develop a SQL project
Show steps
Create a SQL project to apply your skills and demonstrate your understanding of the concepts covered in the course.
Show steps
-
Identify a project idea that aligns with your interests
-
Design the database schema
-
Write the SQL queries to implement the project
-
Test and refine your project
-
Present your project to peers or instructors
SQL Server Performance Report
Show steps
Create a report that analyzes and optimizes the performance of a SQL Server database.
Show steps
-
Identify performance issues using SQL Server tools
-
Implement optimizations to improve performance
-
Create a report documenting the findings and recommendations
Contribute to SQL open-source projects
Show steps
Contribute to SQL open-source projects to gain practical experience and enhance your skills.
Show steps
-
Find SQL open-source projects on platforms like GitHub
-
Review the project documentation and identify areas where you can contribute
-
Make code changes or improvements
-
Submit your contributions for review
Volunteer at a Database Administration Team
Show steps
Gain practical experience and contribute to real-world SQL administration projects.
Show steps
-
Find volunteer opportunities at local organizations or online platforms
-
Contact the organization and express your interest
-
Attend volunteer events and assist with SQL administration tasks
Review SQL
Show steps
Refresh your SQL knowledge before the course begins to ensure a stronger foundation.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Review SQL syntax and commands
- Practice writing simple SQL queries
Review SQL
Show steps
Review the basics of SQL to strengthen your foundation before starting the course.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Install a SQL development environment
- Create a new database
- Write basic SELECT queries
- Write basic INSERT, UPDATE, and DELETE queries
- Practice using SQL to manipulate data
Participate in SQL study groups
Show steps
Join SQL study groups to collaborate with peers, discuss concepts, and learn from each other.
Show steps
Show steps
Show steps
- Find or create a SQL study group
- Attend study group meetings regularly
- Actively participate in discussions
- Share your knowledge and help others
Nine other activities
Expand to see all activities and additional details
Show all 12 activities
Learn about SQL Server Tools
Show steps
Explore and familiarize yourself with the different tools provided by SQL Server to enhance your SQL administration skills.
Show steps
Show steps
Show steps
- Watch tutorials on SQL Server Profiler, Activity Monitor, and Performance Monitor
- Try out the tools in your own SQL Server environment
Follow SQL tutorials
Show steps
Follow online tutorials to reinforce your understanding of SQL concepts.
Show steps
Show steps
Show steps
- Search for SQL tutorials on topics you need to strengthen
- Follow the tutorials step-by-step
- Practice the concepts covered in the tutorials
SQL Query Practice
Show steps
Continuously practice writing SQL queries to improve your proficiency.
Show steps
Show steps
Show steps
- Solve SQL query problems on online platforms
- Create your own SQL queries to practice
Solve SQL practice problems
Show steps
Solve SQL practice problems to test your understanding and identify areas for improvement.
Show steps
Show steps
Show steps
- Find SQL practice problems online or in textbooks
- Attempt to solve the problems on your own
- Check your solutions against the provided answers
- Review and learn from your mistakes
Mentor junior SQL learners
Show steps
Mentor junior SQL learners to reinforce your understanding and help others succeed.
Show steps
Show steps
Show steps
- Identify opportunities to mentor junior SQL learners
- Share your knowledge and experience
- Provide guidance and support
- Encourage and motivate learners
Develop a SQL project
Show steps
Create a SQL project to apply your skills and demonstrate your understanding of the concepts covered in the course.
Show steps
Show steps
Show steps
- Identify a project idea that aligns with your interests
- Design the database schema
- Write the SQL queries to implement the project
- Test and refine your project
- Present your project to peers or instructors
SQL Server Performance Report
Show steps
Create a report that analyzes and optimizes the performance of a SQL Server database.
Show steps
Show steps
Show steps
- Identify performance issues using SQL Server tools
- Implement optimizations to improve performance
- Create a report documenting the findings and recommendations
Contribute to SQL open-source projects
Show steps
Contribute to SQL open-source projects to gain practical experience and enhance your skills.
Show steps
Show steps
Show steps
- Find SQL open-source projects on platforms like GitHub
- Review the project documentation and identify areas where you can contribute
- Make code changes or improvements
- Submit your contributions for review
Volunteer at a Database Administration Team
Show steps
Gain practical experience and contribute to real-world SQL administration projects.
Show steps
Show steps
Show steps
- Find volunteer opportunities at local organizations or online platforms
- Contact the organization and express your interest
- Attend volunteer events and assist with SQL administration tasks
Career center
Learners who complete SQL Server Administration Part 2 will develop knowledge and skills
that may be useful to these careers:
Database Administrator
Database Administrator
In the role of a Database Administrator, you will be responsible for the efficient function of SQL Server. This course can help you build a foundation for this role with its focus on performance monitoring, troubleshooting, and optimization. The material on indexes is particularly relevant to database administration, as proper indexing is essential for maintaining database efficiency. Overall, this course has a fit score of 100 for Database Administrators.
Data Analyst
Data Analyst
As a Data Analyst, you will often analyze data stored in SQL databases. This course provides a helpful overview of SQL Server internals, including performance monitoring and troubleshooting. The material on SQL Profiler is particularly relevant to data analysts, as it can help you identify inefficient queries that may be impacting performance. This course has a fit score of 90 for Data Analysts.
Business Intelligence Analyst
Business Intelligence Analyst
In the role of a Business Intelligence Analyst, you will use data to make better business decisions. This course provides a valuable overview of SQL Server, including performance monitoring and optimization. The material on indexes is particularly relevant to business intelligence analysts, as proper indexing can greatly improve the performance of data queries. Overall, this course has a fit score of 80 for Business Intelligence Analysts.
Data Scientist
Data Scientist
As a Data Scientist, you will use data to build models and make predictions. This course can help you build a foundation for this role with its focus on SQL Server performance monitoring and optimization. The material on SQL Profiler is particularly relevant to data scientists, as it can help you identify inefficient queries that may be impacting performance. Overall, this course has a fit score of 80 for Data Scientists.
Software Engineer
Software Engineer
In the role of a Software Engineer, you will be responsible for designing, developing, and maintaining software applications. This course can help you build a foundation for this role with its focus on SQL Server performance monitoring and optimization. The material on indexes is particularly relevant to software engineers, as proper indexing can greatly improve the performance of data-driven applications. Overall, this course has a fit score of 70 for Software Engineers.
IT Manager
IT Manager
In the role of an IT Manager, you will be responsible for the planning, implementation, and management of information technology systems. This course can help you build a foundation for this role with its focus on SQL Server performance monitoring and optimization. The material on SQL Profiler is particularly relevant to IT managers, as it can help you identify inefficient queries that may be impacting performance. Overall, this course has a fit score of 70 for IT Managers.
Systems Administrator
Systems Administrator
In the role of a Systems Administrator, you will be responsible for the maintenance and support of computer systems and networks. This course can help you build a foundation for this role with its focus on SQL Server performance monitoring and optimization. The material on SQL Profiler is particularly relevant to systems administrators, as it can help you identify inefficient queries that may be impacting performance. Overall, this course has a fit score of 70 for Systems Administrators.
Database Architect
Database Architect
In the role of a Database Architect, you will be responsible for designing and implementing database systems. This course can help you build a foundation for this role with its focus on SQL Server performance monitoring and optimization. The material on indexes is particularly relevant to database architects, as proper indexing can greatly improve the performance of data-driven applications. Overall, this course has a fit score of 60 for Database Architects.
Data Engineer
Data Engineer
In the role of a Data Engineer, you will be responsible for designing, building, and maintaining data pipelines. This course can help you build a foundation for this role with its focus on SQL Server performance monitoring and optimization. The material on SQL Profiler is particularly relevant to data engineers, as it can help you identify inefficient queries that may be impacting performance. Overall, this course has a fit score of 60 for Data Engineers.
Cloud Engineer
Cloud Engineer
In the role of a Cloud Engineer, you will be responsible for the design, implementation, and management of cloud-based applications and infrastructure. This course can help you build a foundation for this role with its focus on SQL Server performance monitoring and optimization. The material on SQL Profiler is particularly relevant to cloud engineers, as it can help you identify inefficient queries that may be impacting performance. Overall, this course has a fit score of 60 for Cloud Engineers.
Systems Engineer
Systems Engineer
In the role of a Systems Engineer, you will be responsible for the design, implementation, and management of computer systems and networks. This course can help you build a foundation for this role with its focus on SQL Server performance monitoring and optimization. The material on SQL Profiler is particularly relevant to systems engineers, as it can help you identify inefficient queries that may be impacting performance. Overall, this course has a fit score of 60 for Systems Engineers.
Network Engineer
Network Engineer
In the role of a Network Engineer, you will be responsible for the design, implementation, and management of computer networks. This course can help you build a foundation for this role with its focus on SQL Server performance monitoring and optimization. The material on SQL Profiler is particularly relevant to network engineers, as it can help you identify inefficient queries that may be impacting performance. Overall, this course has a fit score of 50 for Network Engineers.
Security Analyst
Security Analyst
In the role of a Security Analyst, you will be responsible for identifying and mitigating security risks. This course can help you build a foundation for this role with its focus on SQL Server performance monitoring and optimization. The material on SQL Profiler is particularly relevant to security analysts, as it can help you identify inefficient queries that may be impacting performance. Overall, this course has a fit score of 50 for Security Analysts.
Software Developer
Software Developer
In the role of a Software Developer, you will be responsible for the design, development, and maintenance of software applications. This course can help you build a foundation for this role with its focus on SQL Server performance monitoring and optimization. The material on SQL Profiler is particularly relevant to software developers, as it can help you identify inefficient queries that may be impacting performance. Overall, this course has a fit score of 50 for Software Developers.
Database Designer
Database Designer
In the role of a Database Designer, you will be responsible for the design and implementation of database systems. This course can help you build a foundation for this role with its focus on SQL Server performance monitoring and optimization. The material on indexes is particularly relevant to database designers, as proper indexing can greatly improve the performance of data-driven applications. Overall, this course has a fit score of 40 for Database Designers.
For more career information including salaries, visit:
OpenCourser.com/course/gzkdki/sql
Reading list
We've selected nine books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
SQL Server Administration Part 2.
Focuses on performance tuning and optimization for SQL Server 2016. It provides practical guidance on how to improve the performance of SQL Server databases.
Provides a comprehensive guide to troubleshooting SQL Server issues. It covers a wide range of topics, from basic troubleshooting techniques to more advanced troubleshooting scenarios.
Save
Provides a practical guide to SQL Server performance tuning. It covers topics such as query optimization, index design, and hardware configuration. The book valuable resource for anyone who wants to learn more about how to improve the performance of their SQL Server databases.
Provides a comprehensive guide to query tuning and optimization for SQL Server 2016. It covers a wide range of topics, from understanding query plans to optimizing queries.
Provides a comprehensive overview of SQL Server 2017 administration. It covers topics such as installation, configuration, maintenance, and troubleshooting. The book valuable resource for anyone who wants to learn more about how to administer SQL Server 2017.
Provides a comprehensive guide to high availability and disaster recovery for SQL Server 2016. It covers a wide range of topics, from failover clustering to data protection.
Provides a comprehensive overview of SQL Server 2016 administration. It covers topics such as installation, configuration, maintenance, and troubleshooting. The book valuable resource for anyone who wants to learn more about how to administer SQL Server 2016.
Provides a comprehensive guide to performance tuning for SQL Server 2017. It covers a wide range of topics, from understanding performance monitoring to tuning techniques.
Provides a comprehensive overview of SQL Server 2014 administration. It covers topics such as installation, configuration, maintenance, and troubleshooting. The book valuable resource for anyone who wants to learn more about how to administer SQL Server 2014.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/gzkdki/sql
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2025 OpenCourser