The Day to Day Real World SQL Server DBA
4.4 (21 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.
213 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Day to Day Real World SQL Server DBA to your Wishlist.

Add to Wishlist

The Day to Day Real World SQL Server DBA

Working Through Real World Daily DBA Requests
4.4 (21 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.
213 students enrolled
Created by Mike West
Last updated 5/2016
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 2 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • By the end of this course you'll have a better understanding of what SQL Server DBAs do every day.
  • You'll be able to discuss the basics of setting up replication, fixing blocking issues and determining the load on the disks.
  • You will have a strong understanding of the daily routines a SQL Server DBA completes.
View Curriculum
Requirements
  • Because we need the SQL Server Agent SQL Server Express can't be used.
  • Evaluation copy of SQL Server 2012 installed.
  • You'll need two separate instances. They can be on the same computer.
Description

Reviews from other courses: 

Great content and teaching. Gave me a clear understanding of DBAs do. I cant wait for that to be my title one day soon. - Abigail 

The way of presentation was awesome and easily understandable.  - Srikkanth

Great++++ - Keylin

Course Summary

All videos filmed in 1080 and audio is crystal clear.

What do SQL Server DBAs do all day

The answer really is… it depends on the day. 

Most DBAs start their day with some kind of caffeine.. usually coffee… then start checking job failures and other alerts. 

Did any jobs fail last night? If so… was it a critical job? Can we kick it off right now during core hours? Why did it fail? Backup failures will need to be kicked off immediately. 

We simply can’t have production databases without backups. The good thing about backups is there highly optimized and can often be run during core hours. 

The DBA will have to troubleshoot the failures and answer the questions above. 

You’ll set up dev, test and other non-production environments. You’ll create users, import and export data and plan high availability and disaster recovery options. 

In this course I’m going to cover some fundamental tasks the SQL Server DBA may be asked to perform on a day in day out basis

Thanks for your interest in “The Day to Day Real World SQL Server DBA.” 

The first 10 minutes are free on every Udemy course. Please take a moment to watch all ten minutes to ensure this course is right for you. 

See you in the course!!!


Who is the target audience?
  • This course is for anyone wanting to learn what SQL Server DBAs do throughout the day. There are no prerequisites, however, it will be beneficial if you have a solid understanding of what SQL Server is.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
16 Lectures
01:09:53
+
Course Introduction
5 Lectures 13:01

Let's find out if this course is right for you.

Preview 01:58

Let's create an application login for a third party app. 

Preview 05:05

This time tested script allows us to move SQL Server logins between boxes. 

Preview 04:17

Let's wrap up the two demos we covered in this section.

Summary
00:26

Quiz
5 questions
+
Daily Tasks and Requests
10 Lectures 56:32

DBAs spend a lot of time fixing job failures. Let's take a look at a common one. 

Demo: Fixing Job Failures
03:40

Let's start setting up replication. 

Demo: Setting Up Transactional Replication - Part 1
05:19

Let's finish setting up transactional replication. 

Demo: Setting Up Transactional Replication - Part 2
07:07

DBAs often move databases between server for developers or QA testers. Let's learn how that's accomplished. 

Demo: A Prod to Dev Daily Restore Job Using Scripts
10:15

Let's walk through how DBAs determine IO subsystem failure. 

How to Determine Subsystem Latencies
06:32

You'll be asked to move data often. Let's take a look at a simple approach. 

Exporting One or Two Tables
05:58

Let's setup LS for disaster recovery. 

Setting Up Log Shipping - Part 1
04:48

Let's finished setting up LS. 

Setting Up Log Shipping - Part 2
06:38

One of the most common causes of system outages is blocking. Let's see how we find blocking. 

Demo: Troubleshooting and Fixing Blocking
03:29

SANs fail. Let's see what a disk failure looks like and how to recovery it. 

Recovering a Database After Subsystem Failure
02:46

Quiz
25 questions
+
Conclusion
1 Lecture 00:20
Final Thoughts. Thank you.
00:20
About the Instructor
Mike West
4.2 Average rating
2,606 Reviews
43,060 Students
40 Courses
SQL Server and Machine Learning Evangelist

I've been a production SQL Server DBA most of my career.

I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.

Experience, education and passion

I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.

Certifications

Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).

Personal

Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.