SQL Server Database Administrator: Learn SQL DBA Skills

Rating 4.15 out of 5 (105 ratings in Udemy)

What you'll 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

Description

Becoming a database administrator (DBA) can be a very …

Rating 4.15 out of 5 (105 ratings in Udemy)

What you'll 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

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

Duration 3 Hours 58 Minutes

Paid

Self paced

Beginner Level

English (US)

475

Rating 4.15 out of 5 (105 ratings in Udemy)

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.