The SQL Server DBA Bootcamp: Beginner To Expert (Part 1)

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

Created byGary Cowan

Last updated 6/2021

English

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

Course content

11 sections • 58 lectures • 2h 43m total length

Introduction1:18
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.
Support0:17

SQL Server Editions1:22
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.
Installing SQL Server Database Engine9:02
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
Install a 'Named Instance' SQL Server
Install Management Studio5:01
This lecture will show you how to install SQL Server Management studio like a SQL Server DBA.
Setup and creating test data1:09
You will need to create test data in the lecture to complete the SQL Server DBA course.
Installation Quiz

MDF vs LDF Files0: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
Creating a database using SQL Server Management Studio (SSMS)2:33
You will learn as a SQL Server DBA how to create a database using SQL Server Management Studio (SSMS)
Creating databases using TSQL2:30
You will learn as a SQL Server DBA how to create a database using TSQL
Creating, deleting and altering a table using TSQL7:40
You will learn how to create a table using TSQL. 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)4:11
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
Multiple File Groups - What they are1:21
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 - Practical3:56
This lecture shows you how to create multiple file groups within SQL Server. This is a task for a SQL Server DBA.

What is in this section - VERY IMPORTANT0:11
Switching between Databases - USE Command1:26
SELECT4:04
This lecture will outline what kind of T-SQL skills you will need to be a Junior SQL Server DBA
UNION1:28
You will learn how to use the Union command as a SQL Server DBA.
DATE Functions5:09
You will learn how to use the Date command as a SQL Server DBA.
CASE Statements3:10
You will learn how to use the Case command as a SQL Server DBA.
JOINS : INNER, LEFT AND RIGHT JOINS - PART 10:10
JOINS : INNER, LEFT AND RIGHT JOINS - PART 211:36
You will learn how to use the JOIN command as a SQL Server DBA.
Which JOIN is better? PART 14:20
You will learn how to use the more Join commands as a SQL Server DBA.
Which JOIN is better? PART 20:41
COUNT Statement3:23
You will learn how to use the Count command as a SQL Server DBA.
SUM Statement2:39
You will learn how to use the SUM command as a SQL Server DBA.
AVG (Average) Statement3:29
You will learn how to use the AVG command as a SQL Server DBA.
Filter GROUP BY Statement using HAVING Statements4:27
You will learn how to use the Group BY command as a SQL Server DBA.
How to insert data into a table2:57
You will learn how to insert data into a table as a SQL Server DBA.
How to update data in a table2:52
As a SQL Server DBA, you will learn how to update a table.
How to delete information from a table2:26
As a SQL Server DBA, you will learn how to delete information from a table.
IF / ELSE4:53
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 Further Reading0:03
Stored Procedures3:35
You will use stored procedures nearly every day being a SQL Server DBA and this lecture will teach you how to use it.
Views2:29
View play an important role in using SQL Server and you will need how to create then being a SQL Server DBA

Backing up and restoring a database - Overview2:28
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 using SQL Server Management Studio (SSMS)1:56
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 TSQL1:29
Using TSQL, this lecture will show you how to restore and backup and database when you are a SQL Server DBA
Further Reading - Backup and Restore0:04
Backing up and restoring assignment

Creating Indexes - Part 12:28
This lecture gives an explanation of Indexes. You will have to understand this concept when you are a SQL Server DBA.
Creating Indexes - Part 23:39
You will learn how to create indexes which is a very important role when you are SQL Server DBA.
When not to use an Index0:19
Fragmentation - Rebuilding Indexes4:13
Fragmentation can happen on indexes and as a SQL Server DBA, you will need to know how to fix it.

SA vs Windows Account3:55
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.
SQL Server Configuration Manager3:23
This lecture talks about SQL Server Configuration Manager so you will understand what is it when you become a SQL Server DBA
SQL Server Maximum Memory Setting2:17
This lecture talks about SQL Server Maximum memory settings. You will have to set this when you become a SQL Server DBA.
Database Default Locations - Part 11:08
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 20:16
What is the SQL Server Agent10:25
You will need to know how to use the SQL Server Agent when you are a SQL Server DBA.
Detaching and Attaching Databases2:26
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.
The System databases1:47
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.
TempDB File growth and location settings3:03
This lecture is about TempDB file growth. You will need to know how to control this being a SQL Server DBA.
'Killing' processes1:59
This command might get used often when you are a SQL Server DBA.

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!

After you have done this course, you will be able to take other courses supplied by CloudWer and these courses can be found in the 'Support' sections of the course material.

We will also be making a 'The SQL Server DBA Bootcamp: Beginner To Expert (Part 2)' course so if there is anything you wish to be included in this course, contact us.

Who this course is for:

Students who want to become a SQL Server Database Administrator (SQL Server DBA)

The SQL Server DBA Bootcamp: Beginner To Expert (Part 1)

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 2min

Installing SQL Server like a professional4 lectures • 17min

Creating Databases - What DBA's should know!7 lectures • 23min

T-SQL for Beginners21 lectures • 1hr 5min

Backup And Restore4 lectures • 6min

SQL Server DBA - Performance Tuning4 lectures • 11min

Extra Topics10 lectures • 31min

Importing data from a text file.1 lecture • 5min

Security For DBA's2 lectures • 4min

SQL Server DBA Interview Questions1 lecture • 1min

Requirements

Description

Who this course is for: