SQL Server Database Administrator: Learn SQL DBA Skills

Learn how to administer Microsoft SQL Server Database
3.4 (8 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.
61 students enrolled
$19
$135
86% off
Take This Course
  • Lectures 40
  • Length 3.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2016 English

Course Description

Becoming a database administrator (DBA) can be a very rewarding and fulfilling career.

The path is relatively easy compared to other technical careers.

Microsoft SQL Server is among the top 3 relational database management systems in the world
and getting the skills to becoming an SQL Server DBA will serve you well and open many job opportunities .

Microsoft SQL Server Database Administrators (DBA) can earn $700 or more a day depending
on their experience and skills. It is also possible for a new DBA to start earning from $300 - $400 a day with the skills they will gain from this course in combination with their determination.

The advantage of this course is the amazing virtual labs facilities that is available for free from Microsoft. The virtual labs comes with Microsoft Server 2012 and also Microsoft SQL Server 2016 and various instances of SQL Server like SQL Server Analysis Server (SSAS), SQL Server Reporting Service (SSRS),SQL Server Integration service  (SSIS). The virtual labs is ideal because it is free and gives you an environment that mirrors a real world production SQL Server environment. I strongly urge you to take advantage of this opportunity as I do not know how long Microsoft will have these virtual labs available for. All you require to access the virtual labs is a web browser . It does not matter if you are using a mac , Pc or Linux and there is absolutely nothing for you to install. The lab exercise you will perform in this course using the virtual labs are similar to a real world SQL Server production environment.

What you will learn in this course includes:

  • How to use Microsoft TechNet MSDN Virtual Labs
  • T-SQL  quick Guide
  • Importing and Exporting Data
  • How to use Activity monitor
  • How to use Performance monitor
  • How to backup database
  • How to restore database
  • How to monitor database 
  • How to improve performance
  • How to Authenticate users and groups
  • How to set up Permissions
  • How to setup Auditing



I look forward to seeing on the course.

Thank You

What are the requirements?

  • All you need is a modern web browser and access to the internet

What am I going to get from this course?

  • Use T-SQL to create
  • Use T-SQL to read data from a database
  • Use T-SQL to Update data in a database
  • Use T-SQL to delete data from a database
  • Backup database
  • Restore Database
  • Create Indexes
  • Monitor Performance of database
  • Authenticate users or groups
  • Assign Permissions
  • Setup Auditing
  • Use Activity Monitor
  • Use Performance Monitor
  • Import and Export Data

What is the target audience?

  • This course is meant for anyone aspiring to become a database administrator

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: It is all about the Data
Introduction
Preview
02:43
What is a DBA
01:48
Databases
04:16
MSDN Virtual Labs
10:43
Importing and Exporting Data
09:10
Section 2: Database Backup and Restore
Introduction
Preview
01:30
Copy Database Backup Method
Preview
03:02
Full Database Backup
Preview
09:17
Differential Database Backup
08:42
Transaction Log Backup
06:55
Database Recovery
07:13
Lab Exercise 1
02:30
Lab Exercise 2
00:34
Conclusion
01:15
Section 3: SQL Server Configuration
SQL Server Configuration Manager
05:28
Checking Installed Services With PowerShell
03:42
Connecting to Instances of SQL Server
05:59
Identifying Installed Databases
04:52
Identifying Other Server Objects
03:19
Section 4: T-SQL Quick Guide
Introduction
02:51
T-SQL DML SELECT Query
09:27
T-SQL DML DELETE Query
05:13
T-SQL DML UPDATE Query
05:31
T-SQL DML INSERT Query
11:24
T-SQL DDL CREATE Query
11:10
T-SQL DDL ALTER Query
04:39
T-SQL DDL DROP Query
02:49
T-SQL DDL TRUNCATE Query
03:38
Conclusion
03:16
Section 5: SQL Server Performance Monitoring
Introduction
00:42
Using Activity Monitor
02:38
Collecting Data
08:34
Using Performance Monitor
06:19
Extended Events
07:15
Indexes
06:03
Section 6: Security
Introduction
03:10
Authentication
11:43
Permissions
09:20
Auditing
10:12
Conclusion
02:26

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Bluelime Learning Solutions, 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.

Ready to start learning?
Take This Course