Explore

The Day to Day Real World SQL Server DBA

1 hour on-demand video

$ 13.99

Save Course

Go to Course

Brief Introduction

Working Through Real World Daily DBA Requests

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!!!

Requirements

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.

Recommended for you

SDET Training: Selenium WebDriver, Java Project & Code Tests

Complete SDET Training course on Selenium WebDriver with Java Framework, API & Automation Testing, Coding Interview etc Why it’s important for you to take this course:...

Save Course

Master Full-Stack Web Development | Node, SQL, React, & More

Build a fullstack project with Node. js, PostgreSQL, SQL, React, Redux and more! Covers APIs, authentication, and beyond! Why should you take this course?...

Save Course

MySQL MariaDB From Scratch - Become an App Developer in 2020

The Ultimate MySQL MariaDB Beginner Course with EXAMPLES and PROJECT that will take you towards becoming an SQL Master The Ultimate MySQL MariaDB Beginner Course...

Save Course