Sql Server Dba Essentials For Beginners

Learn the essential skills a SQL Server Database Administrator requires to keep the database running smoothly

What you'll learn
Setup security on SQL Server
Monitor performance of SQL Server
Backup database
Restore database
Update data
Insert data
Delete data
Truncate data
Drop table
Requirements
Access to SQL Server - We will use a virtual Lab
Basic Database concepts knowledge
Basic T-SQL Knowledge
Description
SQL Server is a relational database management system (RDBMS)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:
BackupsConfirm that backups have been made and successfully saved to a secure locationCheck the backup failure alerts, correct the errors and rerun the backupsReview the average duration of backup, any significant changes occurred investigates on this.Most of the time it happens due to networking low bandwidthValidate 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.
PerformanceRegularly 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 dataCreate indexes to reduce the time it takes to get responses from the  SQL Server  after a T-SQLscript is executed.
SecurityCheck the  auditing  logs for failed logins and notify the audit team if necessaryImplement relevant permissions to prevent authorised 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 databaseUpdating informationInserting data into databasesDeleting dataDropping a Table or database


Overview

Section 1: Introduction and Connecting to virtual lab

Lecture 1 Introduction

Lecture 2 What is SQL Server

Lecture 3 What is a DBA

Lecture 4 Database Concept

Lecture 5 MSDN Virtual Labs

Section 2: Database backup and restore strategy

Lecture 6 Copy Database

Lecture 7 Full Backup

Lecture 8 Differential Backup

Lecture 9 Transaction Backup

Lecture 10 Recovering a database

Lecture 11 Lab Exercise 1

Lecture 12 Lab exercise 2

Section 3: Implementing security and protecting the databases

Lecture 13 Enforcing Authentication

Lecture 14 Permission level access

Lecture 15 Auditing to check database integrity

Section 4: Monitoring SQL Server Performance

Lecture 16 Using Activity Monitor

Lecture 17 Data collection

Lecture 18 Activating Performance monitor

Lecture 19 Extended Events

Lecture 20 Using Indexes to improve performance

Section 5: T-SQL

Lecture 21 What is T-SQL

Lecture 22 SELECT Statement

Lecture 23 DELETE Statement

Lecture 24 UPDATE Statement

Lecture 25 INSERT Statement

Lecture 26 CREATE Statement

Lecture 27 ALTER Statement

Lecture 28 DROP Statement

Lecture 29 TRUNCATE Statement

Lecture 30 Thank You

Aspiring DBA,Aspiring Data Analyst,Aspiring SQL developers,Data warehouse professionals