Learn SQL Server DBA Skills from Scratch (Udemy.com)

A guide to becoming an SQL Server Database Administrator - DBA

( 38 Reviews )

Created by: Bluelime Learning Solutions

Produced in 2018

What you will 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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 82 / 100

Course 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 dataWho 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

Time: 7.5h

Instructor Details

Bluelime Learning Solutions

4.1 Rating
38 Reviews

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.

SQL in Motion (2017)

0.0 (0 Reviews)

Provider: Manning Publications
Time: 4h

$59.99

Introduction to SQL (2015)

4.7 (6 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

Reviews

4.1

38 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Gael Vodungbo

Oui

By Ladi Ipaye

SO FAR I AM ENJOYING THE COURSE

By Diviya

Awesomw

By Oreffpm78 .

It is very easy, but a like to be subtitulado

By Mohit Rathor

It is really helpful.

Thanks to all your team.

By Clarence Mbai

Fantastic delivery and well structured course

By Dahinden Stefan

Sehr gut und verstÃ¤ndlich erklÃ¤hrt. Es werden alle wichtige Themen behandelt.

By Edgar Morales

very concrete explanations

By Mehmood khan

not finished the course yet

By Assaf Dekel

I think I'm two hours into the course, and yet to learn a single thing of substance.

By Govindharajan V R A

Good understanding

By Andi Loveday

Although the instructor seems experienced, the programs used in the course are no longer available so it is outdated. The instructor seemed to make each session longer than I felt necessary, quite often I would be bored waiting for him to explain what I needed more than what I didn't need and would speed it up to be able to get what I needed. I am now looking at finding another, more up to date, course to do and am abandoning this one. Quite disappointed.