Sql Dba For Beginners

Learn the Lucrative skills of a DBA

Last updated 2022-01-10 | 4.3

- Backup and Restore Databases
- Write basic T-SQL Queries
- Identify Server Objects

What you'll learn

Backup and Restore Databases
Write basic T-SQL Queries
Identify Server Objects
Setup Performance Monitoring
Automate Tasks
Identify instances of SQL Server

* Requirements

* Browser and internet access

Description

Databases are everywhere and the demand for database administrator has increased.

The role of a database administrator includes backing up database for safety and having the skills to restore the database if required.

This SQL DBA beginners course will teach you the basic functions that DBA's has to perform.In this course you will not have to install any software as we will be using a ready made virtual lab environment provided my Microsoft.

The virtual labs is ideal because it is free and gives you an environment that mirrors a real world production SQL Server environment. I strongly urge you to take advantage of this opportunity as I do not know how long Microsoft will have these virtual labs available for. All you require to access the virtual labs is a web browser . It does not matter if you are using a mac , Pc or Linux and there is absolutely nothing for you to install. The lab exercise you will perform in this course using the virtual labs are similar to a real world SQL Server production environment.

What you will learn in this course includes:

  • How to use  Virtual Labs
  • T-SQL  quick Guide
  • Importing and Exporting Data
  • How to use Activity monitor
  • How to use Performance monitor
  • How to backup database
  • How to restore database
  • How to monitor database
  • How to improve performance
  • How to authenticate users and groups
  • How to set up Permissions
  • How to setup Auditing

I look forward to seeing you on the course.

Thank You

Who this course is for:

  • Anyone with basic Database and T-SQL Knowledge
  • Not suitable for advanced database users

Course content

6 sections • 49 lectures

Introduction Preview 02:43

Using Virtual Labs Preview 10:43

SQL Server Instances Preview 05:59

Installed Databases Preview 04:52

Server Objects Preview 03:19

PLEASE READ Preview 00:06

What is SQL Server Preview 02:57

SQL Server Hardware and Software Requirements Preview 04:21

SQL Server Editions Preview 04:45

SQL Server Download Preview 04:31

SQL Server Installation Preview 09:43

Installing SSMS Preview 05:48

Connecting to SQL Server with SSMS Preview 07:46

SQL Server Configuration Manager Preview 08:10

Installing Sample AdventureWorks Database Preview 06:28

Enabling Log Shipping Preview 02:16

Introduction Preview 01:30

Importing and Exporting Data Preview 09:10

Database Copy Preview 03:02

Full Database Backup Preview 09:17

Differential Database Backup Preview 08:42

Transaction Log Backup Preview 06:55

How to Recover Database Preview 07:13

Lab Practice 1 Preview 02:30

Lab Practice 2 Preview 00:34

Summary Preview 01:15

Introduction Preview 00:42

Activity Monitor Preview 02:38

Gathering Data Preview 08:34

Performance Monitor Preview 06:19

Extended Events Preview 07:15

Using Indexes to Improve Performance Preview 06:03

Automating Task Preview 01:18

What is T-SQL Preview 02:51

Writing a T-SQL SELECT Query Preview 09:27

Using T-SQL UPDATE Query Preview 05:31

T-SQL DELETE Query Preview 05:13

T-SQL INSERT Query Preview 11:24

T-SQL CREATE Query Preview 11:10

T-SQL ALTER Query Preview 04:39

T-SQL DROP Query Preview 02:49

T-SQL TRUNCATE Query Preview 03:38

Summary Preview 03:16

Introduction Preview 03:10

Authentication Preview 11:43

Controlling Access with Permissions Preview 09:20

Enabling Auditing Preview 10:13

Conclusion Preview 02:26

Thank You Preview 00:08