Learn Sql Server Dba Skills From Scratch

  1. Home
  2. Database-administration
  3. Learn Sql Server Dba Skills From Scratch

Tags: Database Administration

A guide to becoming an SQL Server Database Administrator - DBA

Last updated 2022-01-10 | 3.8

- Backup a database
- Recover a database
- Secure a database

What you'll learn

Backup a database
Recover a database
Secure a database
Install SQL Server Instance
Create ETL Package with SSIS
Create dashboard reports with SSRS
Monitor SQL Server Database
Write T-SQL queries
Use SQL Server Tools like SSMS

* Requirements

* You should be able to use a PC at a beginner level
* Basic knowledge of Database Concepts
* Basic SQL knowledge

Description

SQL Server DBA Skills are in  hot demand due to the growth  and reliance on data.SQL Server is a relational database management system from Microsoft that's designed for the enterprise environment.

A DBA ( Database administrator) has to perform several responsibilities to ensure the smooth running 
of the SQL sever database.

Some of the key daily responsibilities of a SQL Server DBA includes:

Backups
Confirm that backups have been made and successfully saved to a secure location
Check the backup failure alerts, correct the errors and rerun the backups
Review the average duration of backup, any significant changes occurred investigates on this.
Most of the time it happens due to networking low bandwidth
Validate the backup files using restore verify only. Jobs  can  be created to take care of the task and to send a notification if it fails to verify any backup.

Performance
Regularly monitor and identify blocking issues. 
Check Performance counters on all production servers and verify that all counters are within the normal range. 
Throughout the day, periodically monitor performance by collecting relevant data
Create indexes to reduce the time it takes to get responses from the  SQL Server  after a T-SQL Script is executed.

Security
Check the  auditing  logs for failed logins and notify the audit team if necessary
Implement relevant permissions to prevent authorized access to SQL Server databases

T-SQL ( Transact -SQL )
Transact-SQL is central to using SQL Server.  All applications that communicate with an instance of SQL Server
 do so by sending Transact-SQL statements to the server, regardless of the user interface of the application. 
T-SQL is Microsoft's proprietary version of the standard SQL(Structural Query  language)

Using T-SQL you can communicate with SQL Servers to perform task like:

Retrieving data from the database
Updating data
Inserting data into databases
Deleting data

Who this course is for:

  • Support Engineers
  • Aspiring DBA'S
  • Aspiring Programmers
  • Aspiring Developers
  • Aspiring Data Warehouse professionals
  • Data Analyst
  • Data Scientist
  • Graduate looking for career in IT

Course content

15 sections • 84 lectures

Getting Started with SQL Server 4 lectures

Introduction Preview 05:47

Please Read Preview 00:19

What is a DBA Preview 01:48

Database Concepts Preview 03:50

SQL Server 2019 Local Environment Setup 11 lectures

What is SQL Server Preview 02:57

SQL Server 2019 Hardware | Software Installation Requirements Preview 04:21

SQL Server Editions Preview 04:45

Download SQL Server 2019 Developer Edition Preview 04:31

SQL Server 2019 Developer Edition Installation Preview 09:43

Installing SQL Server Management Studio Preview 05:48

Connecting to SQL Server with SSMS Preview 07:46

SQL Server Configuration Manager Preview 08:10

Install adventureworks 2016 database Preview 06:28

Install adventureworksDW 2016 database Preview 05:49

Enabling Log shipping Preview 02:16

SQL Server Reporting Services Setup 7 lectures

Installing Reporting Services Preview 04:24

Configure Report Server Preview 12:49

Accessing Report Server Web Portal Locally Preview 03:11

Accessing Report Server Web Portal Remotely Preview 06:54

Configure SSMS for local SSRS administration Preview 03:57

Adding users and groups to SSRS Web Portal Preview 03:24

Installing Report Builder Preview 02:58

Visual Studio 2019 and SSIS Setup 5 lectures

What is Visual Studio Preview 04:32

Minimum Installation Requirements for Visual Studio 2019 Preview 04:27

Installing Visual Studio Preview 08:15

Installing SQL Server Data Tools (SSDT) Preview 04:09

Installing Designers for SSIS,SSAS,SSRS Preview 06:21

SQL Server Integration Services -SSIS 12 lectures

What is SSIS Preview 03:24

Create new SSIS Project with Visual studio 2019 Preview 01:41

Create new Integration Project Preview 05:35

Adding Flat file connection manager Preview 06:26

Remapping Column Data Types Preview 11:12

Adding and Configuring OLE DB Connection Manager Preview 03:39

Add a Data Flow Task to a Package Preview 05:02

Add and configure Flat File Source Preview 04:28

Add and configure Lookup Transformation Preview 11:29

Add and configure Lookup Key for DateKey Transformation Preview 09:28

Add and Configure OLE DB Destination Preview 07:53

Testing SSIS Package Preview 02:02

SQL Server Reporting Services -SSRS 3 lectures

Using SSRS to create Executive Dashboards Preview 01:57

Create a basic report - part 1 Preview 06:57

Create a basic report - part 2 Preview 11:20

Creating a Column Chart with SSRS 4 lectures

Create the data source Preview 06:21

Create the data sets Preview 03:40

Add the column chart Preview 06:46

Add extra data to a column chart Preview 05:22

Creating a Pie Chart with SSRS 3 lectures

Create the data source Preview 06:21

Create the data sets Preview 04:09

Add the Pie Chart Preview 05:41

Using SSRS to add Indicators to Reports 3 lectures

Create the data source Preview 06:21

Create the data sets Preview 07:24

Add the Indicators Preview 11:18

Adding a Gauge with SSRS 3 lectures

Create the data source Preview 06:21

Create the data sets Preview 07:24

Add the Gauge Preview 08:44

Adding Maps to Reports with SSRS 3 lectures

Create the data source Preview 06:21

Create the data sets Preview 03:53

Add the Map Preview 06:09

Database Backup and Recovery 7 lectures

Copy Database Preview 03:02

Performing a Full Database Backup Preview 09:18

Performing a Differential Database Backup Preview 08:42

Performing a Transaction Database Backup Preview 06:55

Recovering a Database Preview 07:13

Lab Exercise 1 Preview 02:30

Lab Exercise 2 Preview 00:34

Monitoring SQL Server Performance 6 lectures

Introduction Preview 00:42

Using Activity Monitor Preview 02:38

Collecting Data Preview 08:34

Using Performance Monitor Preview 06:19

Using Extended Events Preview 07:16

Using Indexes to improve performance Preview 06:03

Database Security 3 lectures

Enforcing Authentication Preview 11:43

Applying Permission level access Preview 09:20

Using Audit to check database integrity Preview 10:13

Transact-SQL -T-SQL 10 lectures

What is T-SQL Preview 10:27

Writing a basic SELECT Statement Preview 09:28

Removing records with T-SQL Preview 05:13

Modifying Data with T-SQL Preview 05:31

Add data to database with T-SQL Preview 11:24

Create a database object with T-SQL Preview 11:10

Alter Database Structure with T-SQL Preview 04:39

Deleting Database Objects with T-SQL Preview 02:49

Stripping a database table of data with T-SQL Preview 03:39

Thank You Preview 00:09