SQL Server Administration Part 2
4.8 (115 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,372 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server Administration Part 2 to your Wishlist.

Add to Wishlist

SQL Server Administration Part 2

Learn how to optimize, improve performance, review and analysis statistics, use monitoring tools, and create indexes
4.8 (115 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,372 students enrolled
Created by Raphael Asghar
Last updated 3/2017
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 9.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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.
View Curriculum
Requirements
  • All the student needs is a laptop or a desktop. All material where appropriate will be downloaded via internet. Plus, you will need as a pre-requisite SQL Administration Part 1. All scripts and documentation will be provided by me to the student via zip file.
Description

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.

Who is the target audience?
  • Student who are interested in managing SQL Server, Developers, IT Admins, System Admins and anyone who is responsible for the databases.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 43 Lectures Collapse All 43 Lectures 09:18:17
+
SQL Administration Part 2: SQL Performance methods and SQL Server utilities
43 Lectures 09:18:17


Install SQL Suite
11:20

Clustered Index
16:59

Create non cluster index
12:07

Composite Index
18:06

Use or not use indexes
11:20

Deciding factors in creating indexes
20:09

using sql profler for indexes
19:41

Reorganize and Rebuild Indexes
15:47

Into To SQL Profiler
17:57

SQL Profiler longest running query
13:37

Audit logins
12:11

SQL Profile with Index Tuning
10:40

SQL Profiler Best Practice
05:24

SQL Server Side Trace
16:31

Database Engine Tuning Advisor
12:10

Statistics
11:44

Activity Monitor
14:01

SQL Performance Monitor
16:24

SQL Performance hardware issues
12:49

SQL Performance Monitoring Hardware CPU
16:47

SQL Performance Monitoring Hardware memory
10:10

SQL Performance Monitoring Hardware disks
08:46

23 SQL Perfmon scehdule
08:51

DMV
13:53

Block and Locks
13:15

BLOCKING
10:45

Deadlock
04:45

Extended Events
18:20

Extended Events via TSQL
11:59

Database Snapshots
15:12

Import Export Data
10:01

BCP
12:59

Partition
19:51

Partition part 2
19:51

Partition 3
12:46

Contained datababase Part 1
11:47

Contained datababase Part 2
10:12

Policy Based Management
18:46

Linked Servers
08:20

SQL server and agent logs
05:24

SQL ADMINISTRATION PART 3
05:32
About the Instructor
Raphael Asghar
4.6 Average rating
1,254 Reviews
15,841 Students
10 Courses
Production SQL Database Administrator

Worked as a Production SQL Database Administrator for over 10 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Created five courses for those students who want a simple path to becoming a SQL DBA.I love SQL Administration and all that is involved in managing and creating a stable SQL architecture enviroement. I want to pass that experience and information to my students.