Sqlserverdbatraining Course

SQL Server Editions Preview 01: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 Engine Preview 09: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

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 Management Studio Preview 05:01

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

Setup and creating test data Preview 01:09

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

Installation Quiz

MDF vs LDF Files Preview 00: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) Preview 02:33

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

Creating databases using TSQL Preview 02:30

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

Creating, deleting and altering a table using TSQL Preview 07: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) Preview 04: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 are Preview 01: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 - Practical Preview 03: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 IMPORTANT Preview 00:11

Switching between Databases - USE Command Preview 01:26

SELECT Preview 04:04

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

UNION Preview 01:28

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

DATE Functions Preview 05:09

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

CASE Statements Preview 03:10

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

JOINS : INNER, LEFT AND RIGHT JOINS - PART 1 Preview 00:10

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

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

Which JOIN is better? PART 1 Preview 04:20

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

Which JOIN is better? PART 2 Preview 00:41

COUNT Statement Preview 03:23

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

SUM Statement Preview 02:39

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

AVG (Average) Statement Preview 03:29

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

Filter GROUP BY Statement using HAVING Statements Preview 04:27

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

How to insert data into a table Preview 02:57

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

How to update data in a table Preview 02:52

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

How to delete information from a table Preview 02:26

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

IF / ELSE Preview 04: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 Reading Preview 00:03

Stored Procedures Preview 03:35

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

Views Preview 02: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 - Overview Preview 02: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) Preview 01: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 TSQL Preview 01: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 Restore Preview 00:04

Backing up and restoring assignment

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.

Creating Indexes - Part 1 Preview 02: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 2 Preview 03: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 Index Preview 00:19

Fragmentation - Rebuilding Indexes Preview 04:13

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

SA vs Windows Account Preview 03: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 Manager Preview 03: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 Setting Preview 02: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 1 Preview 01: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 2 Preview 00:16

What is the SQL Server Agent Preview 10:25

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

Detaching and Attaching Databases Preview 02: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 databases Preview 01: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 settings Preview 03:03

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

'Killing' processes Preview 01:59

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

Importing data from a text file Preview 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.

Logins and Roles Preview 03:45

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 - Part 2 Preview 00:04

SQL Server DBA Interview Questions Preview 00:07

What to do next Preview 00:17

Leave a review and win FREE access to courses Preview 00:44