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

Homepage

https://www.udemy.com/course/become-a-sql-server-dba-some-dba-can-earn-700-a-day/