Sql Server Database Administrator: Learn Sql Dba Skills

Learn how to administer Microsoft SQL Server Database

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
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 worldand 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 dependingon 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 LabsT-SQL  quick GuideImporting and Exporting DataHow to use Activity monitorHow to use Performance monitorHow to backup databaseHow to restore databaseHow to monitor database How to improve performanceHow to Authenticate users and groupsHow to set up PermissionsHow to setup Auditing
I look forward to seeing on the course.
Thank You

Overview

Section 1: It is all about the Data

Lecture 1 Introduction

Lecture 2 What is a DBA

Lecture 3 Databases

Lecture 4 MSDN Virtual Labs

Lecture 5 Importing and Exporting Data

Section 2: Database Backup and Restore

Lecture 6 Introduction

Lecture 7 Copy Database Backup Method

Lecture 8 Full Database Backup

Lecture 9 Differential Database Backup

Lecture 10 Transaction Log Backup

Lecture 11 Database Recovery

Lecture 12 Lab Exercise 1

Lecture 13 Lab Exercise 2

Lecture 14 Conclusion

Section 3: SQL Server Configuration

Lecture 15 SQL Server Configuration Manager

Lecture 16 Checking Installed Services With PowerShell

Lecture 17 Connecting to Instances of SQL Server

Lecture 18 Identifying Installed Databases

Lecture 19 Identifying Other Server Objects

Section 4: T-SQL Quick Guide

Lecture 20 Introduction

Lecture 21 T-SQL DML SELECT Query

Lecture 22 T-SQL DML DELETE Query

Lecture 23 T-SQL DML UPDATE Query

Lecture 24 T-SQL DML INSERT Query

Lecture 25 T-SQL DDL CREATE Query

Lecture 26 T-SQL DDL ALTER Query

Lecture 27 T-SQL DDL DROP Query

Lecture 28 T-SQL DDL TRUNCATE Query

Lecture 29 Conclusion

Section 5: SQL Server Performance Monitoring

Lecture 30 Introduction

Lecture 31 Using Activity Monitor

Lecture 32 Collecting Data

Lecture 33 Using Performance Monitor

Lecture 34 Extended Events

Lecture 35 Indexes

Section 6: Security

Lecture 36 Introduction

Lecture 37 Authentication

Lecture 38 Permissions

Lecture 39 Auditing

Lecture 40 Conclusion

Lecture 41 Thank You

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