10 Things Every Production SQL Server Should Have (Udemy.com)

The Bare Essentials Every SQL Server Production Server Should Have.

Created by: Mike West

Produced in 2016

icon
What you will learn

  • Configure SQL Server correctly for production environments
  • Set up an alerting system so you are notified when jobs fail and when alerts are fired
  • Become more confident when an outage occurs.

icon
Quality Score

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

Overall Score : 92 / 100

icon
Course Description

Some recent reviews!!!
"I can't thank Mike enough for providing such useful information without cost; the content in this course is invaluable." Ken
"Thank you for the 10" David V
"Great Course." David SThis course focuses on 10 things that every SQL Server in production should have.We will start with the single MOST important facet to every SQL Server DBAs job. Backups. We will cover the different kinds of backups and discuss how often we should be taking them. We will demo restores so WE understand the mechanics of how SQL Server backups up a database.We will talk about the importance of the FULL backup and what having it means to recovery.WE will cover consistency checks and talk about how often they should be run and why they should be run.WE will cover statistics and index REBUILDS and how and why we should use them.Lastly, WE will cover how to set up database MAIL so we can be alerted when OUR jobs fail.Many organizations don't have production DBAs so this course can assist them with setting up the very basic necessities for a production SQL Server.This is an entry level course and can be taken by developers, network administrators and database administrators. The course is even well suited for those who manage DBAs.The course is a real world approach to setting up your SQL Server in a production environment.The course if FREE so sign up now.Who this course is for:
  • There are no prerequisites for this course. If you have a basic knowledge of SQL Server then this course is for you.
  • This course will cover the bare minimum we need for our SQL Servers in a production environment.
  • Using the collegiate scale as a guide this course will be a 101 level course.

icon
Instructor Details

placeholder

Machine Learning Enthusiast
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
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 w

icon
More courses by Mike West

How To Begin Your Career As a SQL Server DBA

$11.99

The Complete Python Course for Machine Learning Engineers

$11.99

How You Can Master the Fundamentals of Transact-SQL

$11.99

How to Become A Data Scientist Using Azure Machine Learning

$11.99

How I Solve of All SQL Server Outages

$11.99

An Introduction to Machine Learning for Data Engineers

$11.99

icon
Reviews

4.6

49 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

Great!!!!

Step by step learning is a great start.

Very good basic sql server main points. A quick refresher to main sql server topics

This short course is excellent and will give you a good understanding of the basics in SQL server administration.

i have an idea about IT terms now and also got an idea about date back which is very importance in every organization

the course is more educative, lean a lot on system set up and software.

Well detailed and straight to the point.

Es muy buen curso

Good course and it's free!

Very informative with examples. Excellent way of explanation

I think the idea of teaching about back up first is very intresting. Trying to understand the methodology. volume a little low difficult to hear the lecture.

Great practical course - thx Mike!