The Complete SQL Server DBA Bootcamp: Beginner To Expert
4.1 (52 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,223 students enrolled

The Complete SQL Server DBA Bootcamp: Beginner To Expert

Learn to become an SQL Server DBA (Database Administrator) and become a Junior SQL Server Database Administrator (DBA).
4.1 (52 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,223 students enrolled
Created by Gary Cowan
Last updated 7/2020
English
Current price: $27.99 Original price: $39.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 9 articles
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You will learn how to be a SQL Server Database Administrator (SQL Server DBA)
  • Get employed as a SQL Server Database Administrator (SQL Server DBA)
  • Being a SQL Server Database Administrator (SQL Server DBA) , you will be able to install an configure SQL Server
  • Being a SQL Server Database Administrator (SQL Server DBA), you will be able to troubleshoot problems
  • Being a SQL Server Database Administrator (SQL Server DBA), you will be able to set up security on SQL Server
  • Being a SQL Server Database Administrator (SQL Server DBA), you will know how to backup and restore a database
Requirements
  • Internet Access
Description

Learn to become an SQL Server DBA (Database Administrator) and become a Junior SQL Server Database Administrator (DBA).

This course is for anybody who wants to become a SQL Server DBA but doesn't know what skills or steps to take.

Nearly every company needs a DBA and usually, they need a SQL Server DBA. To become a good DBA, you need technical, communication and problem-solving skills.

In this course, I will cover how to be a DBA and you will learn the same skills no matter which version of SQL Server you use.

This step by step approach will be as follows

  • Learn all the concepts of installing and configuring SQL Server

  • Gain knowledge on how to secure a SQL Server and Database

  • Learn how to backup and restore a database

  • Learn T-SQL skills to be an amazing SQL Server DBA

This your first step to becoming a SQL Server DBA, let's get started!

Who this course is for:
  • Students who want to become a SQL Server Database Administrator (SQL Server DBA)
Course content
Expand all 56 lectures 02:43:34
+ Introduction
2 lectures 02:02

This is an introduction on how you can become a SQL Server DBA. It shows you all the benefits of becoming a junior SQL Server Database Administrator.

Preview 01:18
+ Installing SQL Server like a professional
4 lectures 16:34

Within this lecture, it shows you the different editions of SQL Server so you will understand the choices you have to make when you become a SQL Server DBA.

Preview 01:22

This lecture will show you how to install SQL Server like a DBA. We will go through the following

  • How to install the SQL Server Engine

  • Best things to install when you are installing SQL

  • Any tips and tricks

Preview 09:02
For this assignment, you will have to install another SQL Server on your desktop. This will be a 'Named Instance' and call the Named Instance 'DEV1' For example /DEV1
Install a 'Named Instance' SQL Server
1 question

This lecture will show you how to install SQL Server Management studio like a SQL Server DBA.

Install Management Studio
05:01

You will need to create test data in the lecture to complete the SQL Server DBA course.

Setup and creating test data
01:09
Installation Quiz
3 questions
+ Creating Databases - What DBA's should know!
7 lectures 22:28

This lecture describes what the MDF and LDF files are used for. You will need to know this you want to become a SQL Server DBA

MDF vs LDF Files
00:17

You will learn as a SQL Server DBA how to create a database using SQL Server Management Studio (SSMS)

Creating a database using SQL Server Management Studio (SSMS)
02:33

You will learn as a SQL Server DBA how to create a database using TSQL

Creating databases using TSQL
02:30

You will learn how to create a table using TSQL. You will do this many times when you are a SQL Server DBA

Creating, deleting and altering a table using TSQL
07:40

You will learn how to create a table using SQL Server Management Studio (SSMS). You will do this many times when you are a SQL Server DBA

Creating, altering and deleting a table using SQL Server Managent Studio (SSMS)
04:11

This is a description of filegroups with a SQL Server database. You will have to create filegroups when you become a SQL Server DBA.

Multiple File Groups - What they are
01:21

This lecture shows you how to create multiple file groups within SQL Server. This is a task for a SQL Server DBA.

Multiple File Groups - Practical
03:56
+ T-SQL for Beginners
21 lectures 01:05:30
What is in this section - VERY IMPORTANT
00:11
Switching between Databases - USE Command
01:26

This lecture will outline what kind of T-SQL skills you will need to be a Junior SQL Server DBA

SELECT
04:04

You will learn how to use the Union command as a SQL Server DBA.

UNION
01:28

You will learn how to use the Date command as a SQL Server DBA.

DATE Functions
05:09

You will learn how to use the Case command as a SQL Server DBA.

CASE Statements
03:10
JOINS : INNER, LEFT AND RIGHT JOINS - PART 1
00:10

You will learn how to use the JOIN command as a SQL Server DBA.

JOINS : INNER, LEFT AND RIGHT JOINS - PART 2
11:36

You will learn how to use the more Join commands as a SQL Server DBA.

Which JOIN is better? PART 1
04:20
Which JOIN is better? PART 2
00:41

You will learn how to use the Count command as a SQL Server DBA.

COUNT Statement
03:23

You will learn how to use the SUM command as a SQL Server DBA.

SUM Statement
02:39

You will learn how to use the AVG command as a SQL Server DBA.

AVG (Average) Statement
03:29

You will learn how to use the Group BY command as a SQL Server DBA.

Filter GROUP BY Statement using HAVING Statements
04:27

You will learn how to insert data into a table as a SQL Server DBA.

How to insert data into a table
02:57

As a SQL Server DBA, you will learn how to update a table.

How to update data in a table
02:52

As a SQL Server DBA, you will learn how to delete information from a table.

How to delete information from a table
02:26

This IF/ELSE command is very important and you will learn how to use it while during this course as well as a SQL Server DBA

IF / ELSE
04:53
IF / ELSE Further Reading
00:03

You will use stored procedures nearly every day being a SQL Server DBA and this lecture will teach you how to use it.

Stored Procedures
03:35

View play an important role in using SQL Server and you will need how to create then being a SQL Server DBA

Views
02:29
+ Backup And Restore
4 lectures 05:57

This lecture will go through how to backup and restore a database. I will explain the following

  • What is a full backup

  • What is a differential backup

  • What is a transaction log backups

Very useful information on being a SQL Server DBA

Backing up and restoring a database - Overview
02:28

This lecture will show you how a SQL Server DBA task of backing up and restoring a database needs to be done.

Backing up and restoring a database using SQL Server Management Studio (SSMS)
01:56

Using TSQL, this lecture will show you how to restore and backup and database when you are a SQL Server DBA

Backing up and restoring a database using TSQL
01:29
Further Reading - Backup and Restore
00:04
Create a new database, back up and restore the backup using SQL Server Management Studio GUI, then back up and restore the database using TSQL Practice doing a Differential and Transactional Log backups and see they work.
Backing up and restoring assignment
1 question
+ SQL Server DBA - Performance Tuning
4 lectures 10:39

This lecture gives an explanation of Indexes. You will have to understand this concept when you are a SQL Server DBA.

Creating Indexes - Part 1
02:28

You will learn how to create indexes which is a very important role when you are SQL Server DBA.

Creating Indexes - Part 2
03:39
When not to use an Index
00:19

Fragmentation can happen on indexes and as a SQL Server DBA, you will need to know how to fix it.

Fragmentation - Rebuilding Indexes
04:13
+ Extra Topics
10 lectures 30:39

If you want to know more about using SA rather than a windows account to get into a SQL Server Instance, then this lecture will tell you how to do it. It is very useful information when you are a SQL Server DBA to know how to troubleshoot problems like this.

SA vs Windows Account
03:55

This lecture talks about SQL Server Configuration Manager so you will understand what is it when you become a SQL Server DBA

SQL Server Configuration Manager
03:23

This lecture talks about SQL Server Maximum memory settings. You will have to set this when you become a SQL Server DBA.

SQL Server Maximum Memory Setting
02:17

Putting the file in the correct location is very important and as a SQL Server DBA, you will need how to set this up properly.

Database Default Locations - Part 1
01:08
Database Default Locations - Part 2
00:16

You will need to know how to use the SQL Server Agent when you are a SQL Server DBA.

What is the SQL Server Agent
10:25

Detaching and attaching databases are a very important task you will need to do when you become a SQL Server DBA. This lecture will show you how to do it.

Detaching and Attaching Databases
02:26

Know what the system databases are in SQL Server is knowledge that a SQL Server DBA needs to understand. This lecture will explain it to you.

The System databases
01:47

This lecture is about TempDB file growth. You will need to know how to control this being a SQL Server DBA.

TempDB File growth and location settings
03:03

This command might get used often when you are a SQL Server DBA.

'Killing' processes
01:59
+ Importing data from a text file.
1 lecture 04:32

This lecture will show you how to import a file. You will have to know how to do this when you are SQL Server DBA.

Importing data from a text file
04:32
+ Security For DBA's
2 lectures 03:49

Logins and Roles are a very important concept within SQL Server and you will need to know how to set this up when you are a SQL Server DBA.

Logins and Roles
03:45
Logins and Roles - Part 2
00:04
+ Bonus Lecture
1 lecture 01:21
What to learn next
01:21