SQL Server Administration Part 2

SQL Server Administration Part 2, available at $74.99, has an average rating of 4.56, with 49 lectures, based on 3079 reviews, and has 16978 subscribers.

You will learn about 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. This course is ideal for individuals who are Student who are interested in managing SQL Server, Developers, IT Admins, System Admins and anyone who is responsible for the databases. It is particularly useful for Student who are interested in managing SQL Server, Developers, IT Admins, System Admins and anyone who is responsible for the databases. .

Enroll now: SQL Server Administration Part 2

Summary

Title: SQL Server Administration Part 2

Price: $74.99

Average Rating: 4.56

Number of Lectures: 49

Number of Published Lectures: 49

Number of Curriculum Items: 49

Number of Published Curriculum Objects: 49

Original Price: $19.99

Quality Status: approved

Status: Live

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.

Who Should Attend

Student who are interested in managing SQL Server, Developers, IT Admins, System Admins and anyone who is responsible for the databases.

Target Audiences

Student who are interested in managing SQL Server, Developers, IT Admins, System Admins and anyone who is responsible for the databases.

SQL Administration Part 2 will benefit the student by providing the necessary guide lines for enhancing SQL Server performance by utilizing indexes, reviewing DMVs for analysis, and setting up performance counters for gathering resource metrics; and also I will explain a handful of utilities to gather information about SQL Server internals, such as SQL Profiler, Database Tuning Advisor (DTA), Extended Events, SQL performance monitor, Activity monitor, and teach about partitions, creating contained database for recovery, reviewing SQL server logs and by installing SQL Server 2014 as the newer SQL version.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.

Course Curriculum

Chapter 1: SQL Administration Part 2: SQL Performance methods and SQL Server utilities

Lecture 1: Introduction

Lecture 2: Install SQL Server 214

Lecture 3: Install SQL Suite

Lecture 4: POST ADDENDUM

Lecture 5: APPS NEEDED

Lecture 6: CREATE VM

Lecture 7: INSTALL SQL SERVER 2017

Lecture 8: ADVENTUREWORKS 2017 DB

Lecture 9: COMPARISON SQL SERVER 2014 VS 2017

Lecture 10: Clustered Index

Lecture 11: Create non cluster index

Lecture 12: Composite Index

Lecture 13: Use or not use indexes

Lecture 14: Deciding factors in creating indexes

Lecture 15: using sql profler for indexes

Lecture 16: Reorganize and Rebuild Indexes

Lecture 17: Into To SQL Profiler

Lecture 18: SQL Profiler longest running query

Lecture 19: Audit logins

Lecture 20: SQL Profile with Index Tuning

Lecture 21: SQL Profiler Best Practice

Lecture 22: SQL Server Side Trace

Lecture 23: Database Engine Tuning Advisor

Lecture 24: Statistics

Lecture 25: Activity Monitor

Lecture 26: SQL Performance Monitor

Lecture 27: SQL Performance hardware issues

Lecture 28: SQL Performance Monitoring Hardware CPU

Lecture 29: SQL Performance Monitoring Hardware memory

Lecture 30: SQL Performance Monitoring Hardware disks

Lecture 31: 23 SQL Perfmon scehdule

Lecture 32: DMV

Lecture 33: Block and Locks

Lecture 34: BLOCKING

Lecture 35: Deadlock

Lecture 36: Extended Events

Lecture 37: Extended Events via TSQL

Lecture 38: Database Snapshots

Lecture 39: Import Export Data

Lecture 40: BCP

Lecture 41: Partition

Lecture 42: Partition part 2

Lecture 43: Partition 3

Lecture 44: Contained datababase Part 1

Lecture 45: Contained datababase Part 2

Lecture 46: Policy Based Management

Lecture 47: Linked Servers

Lecture 48: SQL server and agent logs

Lecture 49: SQL ADMINISTRATION PART 3

Instructors

Raphael Asghar
Production SQL Database Administrator

Rating Distribution

1 stars: 21 votes
2 stars: 33 votes
3 stars: 239 votes
4 stars: 1125 votes
5 stars: 1661 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu