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
Here's a deal for you
We found an offer that may be relevant to this course.
Save money when you learn.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
UDEAFNULP2024
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
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
Good to know
Good to know
Know what's good ,
what to watch for , 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
Save SQL Server Administration Part 2 to your list so you can find it easily later:
Save
Save
Reviews summary
Highly praised sql administration course
Learners say this course provided a detailed explanation of SQL server administration concepts with engaging assignments that were helpful in enhancing their understanding and aided in their work.
Engaging assignments that help enhance understanding of SQL concepts
"thank you so much for your tremendous efforts to make such a very informative course"
"it really helped me understand a lot of theses concepts."
Enhanced skills that helped improve job performance
"it really helped me in my job"
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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
Here are nine courses similar to
SQL Server Administration Part 2.
SQL Server Performance Tuning Part 1
OpenCourser.com/course/splh3q/sql
SQL Server Performance Tuning Part 1
SQL Server Administration: (SQL Server Integration Services)
OpenCourser.com/course/bo4rtq/sql
SQL Server Administration: (SQL Server Integration...
SQL Server Administration Part 3
OpenCourser.com/course/ser9ir/sql
SQL Server Administration Part 3
SQL Server Performance Tuning Part 2
OpenCourser.com/course/t69968/sql
SQL Server Performance Tuning Part 2
Getting Started with Your First SQL Server Instance
OpenCourser.com/course/i8cmc1/getting
Getting Started with Your First SQL Server Instance
Creating a Terraform Configuration for Multi-Cloud Use
OpenCourser.com/course/s8hr0j/creating
Creating a Terraform Configuration for Multi-Cloud Use
phpMyAdmin Fundamentals
OpenCourser.com/course/nrrv5g/phpmyadmin
phpMyAdmin Fundamentals
SQL for Data Analysis: Beginner MySQL Business Intelligence
OpenCourser.com/course/dqep64/sql
SQL for Data Analysis: Beginner MySQL Business...
Database Administration and SQL Language Basics
OpenCourser.com/course/0npq86/database
Database Administration and SQL Language Basics
Effort
10 total hours
Via
Udemy
Instructor
Raphael Asghar
Language
English
Good to know
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
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 - 2024 OpenCourser