SQL Server Dba Essentials For Beginners

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

Homepage

https://www.udemy.com/course/sql-server-dba-essentials-for-beginners/

SQL Server Dba Essentials For Beginners Fast Download
SQL Server Dba Essentials For Beginners Full Download