Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
The Day to Day Real World SQL Server DBA
Rating: 4.0 out of 5(342 ratings)
1,689 students

The Day to Day Real World SQL Server DBA

Working Through Real World Daily DBA Requests
Created byMike West
Last updated 5/2016
English

What you'll 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.

Course content

3 sections • 16 lectures • 1h 9m total length

  • What are we going to Learn in this Course?1:15

    A short course introduction.

  • Is this Course Right for You?1:58

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

  • Demo: Setting up Login and User for Third Party Application5:05

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

  • Demo: Moving SQL Server Logins Between Instances4:17

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

  • Summary0:25

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

  • Quiz

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

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


Who this course is for:

  • 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.

Report abuse