SQL Server DBA Essentials for beginners
4.1 (7 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
540 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server DBA Essentials for beginners to your Wishlist.

Add to Wishlist

SQL Server DBA Essentials for beginners

Learn the essential skills a SQL Server Database Administrator requires to keep the database running smoothly
4.1 (7 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
540 students enrolled
Last updated 11/2016
English
Current price: $10 Original price: $165 Discount: 94% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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:

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-SQLscript is executed.


Security
Check the  auditing  logs for failed logins and notify the audit team if necessary
Implement 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 database
Updating information
Inserting data into databases
Deleting data
Dropping a Table or database


Who is the target audience?
  • Aspiring DBA
  • Aspiring Data Analyst
  • Aspiring SQL developers
  • Data warehouse professionals
Compare to Other SQL Server Courses
Curriculum For This Course
29 Lectures
03:02:11
+
Introduction and Connecting to virtual lab
5 Lectures 25:10



Database Concept
03:50

MSDN Virtual Labs
10:44
+
Database backup and restore strategy
7 Lectures 38:14
Copy Database
03:02

Full Backup
09:18

Differential Backup
08:42

Transaction Backup
06:55

Recovering a database
07:13

Lab Exercise 1
02:30

Lab exercise 2
00:34
+
Implementing security and protecting the databases
3 Lectures 31:16
Enforcing Authentication
11:43

Permission level access
09:20

Auditing to check database integrity
10:13
+
Monitoring SQL Server Performance
5 Lectures 30:49
Using Activity Monitor
02:38

Data collection
08:34

Activating Performance monitor
06:19

Extended Events
07:15

Using Indexes to improve performance
06:03
+
T-SQL
9 Lectures 56:42
What is T-SQL
02:51

SELECT Statement
09:27

DELETE Statement
05:13

UPDATE Statement
05:31

INSERT Statement
11:24

CREATE Statement
11:10

ALTER Statement
04:39

DROP Statement
02:49

TRUNCATE Statement
03:38
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,761 Reviews
38,768 Students
92 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.