SQL Server Administration Part 2 from Udemy

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.

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

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

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

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"

Career center

Learners who complete SQL Server Administration Part 2 will develop knowledge and skills that may be useful to these careers:

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.

See salaries and explore the career path for Database Administrator

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.

See salaries and explore the career path for Data Analyst

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.

See salaries and explore the career path for Data Scientist

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.

See salaries and explore the career path for Business Intelligence Analyst

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.

See salaries and explore the career path for IT Manager

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.

See salaries and explore the career path for Software Engineer

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.

See salaries and explore the career path for Systems Administrator

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.

See salaries and explore the career path for Data 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.

See salaries and explore the career path for Systems Engineer

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.

See salaries and explore the career path for Database Architect

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.

See salaries and explore the career path for Cloud Engineer

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.

See salaries and explore the career path for Security Analyst

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.

See salaries and explore the career path for Network Engineer

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.

See salaries and explore the career path for Software Developer

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.

See salaries and explore the career path for Database Designer