SQL Server Database Administrator: Learn SQL DBA Skills
3.9 (13 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.
77 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server Database Administrator: Learn SQL DBA Skills to your Wishlist.

Add to Wishlist

SQL Server Database Administrator: Learn SQL DBA Skills

Learn how to administer Microsoft SQL Server Database
3.9 (13 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.
77 students enrolled
Last updated 4/2016
English
Current price: $10 Original price: $95 Discount: 89% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
Requirements
  • All you need is a modern web browser and access to the internet
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

Who is the target audience?
  • This course is meant for anyone aspiring to become a database administrator
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 40 Lectures Collapse All 40 Lectures 03:41:18
+
It is all about the Data
5 Lectures 28:40

What is a DBA
01:48

Databases
04:16

MSDN Virtual Labs
10:43

Importing and Exporting Data
09:10
+
Database Backup and Restore
9 Lectures 40:58



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
+
SQL Server Configuration
5 Lectures 23:20
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
+
T-SQL Quick Guide
10 Lectures 59:58
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
+
SQL Server Performance Monitoring
6 Lectures 31:31
Introduction
00:42

Using Activity Monitor
02:38

Collecting Data
08:34

Using Performance Monitor
06:19

Extended Events
07:15

Indexes
06:03
+
Security
5 Lectures 36:51
Introduction
03:10

Authentication
11:43

Permissions
09:20

Auditing
10:12

Conclusion
02:26
About the Instructor
Bluelime Learning Solutions
4.2 Average rating
958 Reviews
24,021 Students
61 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.