Skip to content
Write a review
UdemySQLPaid courseIntermediate levelCertificate

The Day to Day Real World SQL Server DBA (Udemy.com)

Working Through Real World Daily DBA Requests

4.0
342 reviews

Created by: Mike West

Last updated May 2016

icon
What you will 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.

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.0 out of 5higher than 6% of them
  • Reviews342#245 of 389 by number of reviews
  • Length1.2 hoursshorter than 95% of them
  • Last updatedMay 2016earlier than 93% of them

icon
Course Description

COURSE REVIEWS:

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

This course is Amazing. It's concise, valuable and prolific. I highly recommended for DBA's. - Amir

Great. -Njabulo

A solid overview. Covers the basics in a clear and concise manner. - Stephen Ward

We need more videos like this regarding the DBA SQL. - Mohammad

It was an amazing course. - Kabeer

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!!!
Read More Intermediate Intermediate Level product length iconTime: 1.2h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Mike West

I'm the founder of LogikBot. I've worked at Microsoft and Uber. I helped design courses for Microsoft's Data Science Certifications. If you're interested in machine learning, I can help.

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. 

Over the last five years I've transitioned to the exciting world of applied machine learning.  I'm excited to show you what I've learned and help you move into one of the single most important fields in this space.

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  

Read More

icon
More courses by Mike West

$14.99

Free

$13.99

$69.99

$54.99

$54.99

All courses by Mike West

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

All SQL courses

icon
Reviews

4.0

342 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Anonymized User on 5/1/2023

I will come back for sure, it is so sincere to share the resources you use in this course to your audiences / students

By José Manuel Arias Millán on 5/20/2022

It is focused on demos and lack some explanation but it does cover a wide variety of scenarios. Overall it does offer a good DBA point of view.

By Kanan Rustamov on 2/3/2022

The explanation wasn't satisfaying

By Jerry Wong on 4/9/2021

The course is too short and it doesn't go detail enough. For example in video 10, we know there is an issue with HR_PROD but who is responsible for the latency problem? Nevertheless, I did learn few tips from the course. Thank you.

By Nasratullah Rahman on 2/4/2021

I liked it since he was getting to the point and not wasting any time on stuff which does not benefit us much.

By Ryan Sheeran on 11/6/2020

Decent refresher on some tasks I don't personally do very often, as a number of these processes are set up in our systems, but they are still good to keep sharp in the event we create a new server/upgrade/etc.

By Bill Kelly on 9/28/2020

Good examples were used in the demos but the steps were a little vague or assumed you knew what was being clicked on (because we could see the video). I thought more explanation could have been provided.

By Amarnath on 11/24/2018

what i really looking for more real time project scenarios like how many servers exist ...how much memory allocation for your project...how many employees dba can work with and what tools are used,how you resolve tickets how you going to escalate your issues if you cant find ,useful scripts which you used (you need to tell us which is missing in this video),what issuses you faced in replication and always on and how you troubleshoot them...these are much useful for me as iam beginner to this dba world please do a video and let put that as a free (requesting you as fan :-) )

By Mosammat on 7/28/2017

The course was good but I was there was little bit more explanation on recovering a db after subsystem failure

By Mike Laugharne on 3/27/2017

Good, but skips over steps I would have liked an explanation to. Some of it feels like more of a quick how-to guide than a learning experience.

Showing all 10 reviews on CourseDuck

Read all 342 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 80 / 100

The Day to Day Real World SQL Server DBA
Visit course on Udemy Write a review
  • Video Duration: icon 1.2h
  • Price: $54.99
  • Provider: icon Udemy
  • Updated: icon May 2016
  • Level: Intermediate Intermediate
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com