HOT
blank

SQL Server Database Administrator: Learn SQL DBA Skills

Development

Rating4.1
Enroll Now

SQL Server Database Administrator: Learn SQL DBA Skills, available at $54.99, has an average rating of 4.05, with 41 lectures, based on 113 reviews, and has 511 subscribers.

You will learn about 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 This course is ideal for individuals who are This course is meant for anyone aspiring to become a database administrator It is particularly useful for This course is meant for anyone aspiring to become a database administrator.

Enroll now: SQL Server Database Administrator: Learn SQL DBA Skills

Summary

Title: SQL Server Database Administrator: Learn SQL DBA Skills

Price: $54.99

Average Rating: 4.05

Number of Lectures: 41

Number of Published Lectures: 41

Number of Curriculum Items: 41

Number of Published Curriculum Objects: 41

Original Price: $84.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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

Course Curriculum

Chapter 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

Chapter 2: Database Backup and Restore

Lecture 1: Introduction

Lecture 2: Copy Database Backup Method

Lecture 3: Full Database Backup

Lecture 4: Differential Database Backup

Lecture 5: Transaction Log Backup

Lecture 6: Database Recovery

Lecture 7: Lab Exercise 1

Lecture 8: Lab Exercise 2

Lecture 9: Conclusion

Chapter 3: SQL Server Configuration

Lecture 1: SQL Server Configuration Manager

Lecture 2: Checking Installed Services With PowerShell

Lecture 3: Connecting to Instances of SQL Server

Lecture 4: Identifying Installed Databases

Lecture 5: Identifying Other Server Objects

Chapter 4: T-SQL Quick Guide

Lecture 1: Introduction

Lecture 2: T-SQL DML SELECT Query

Lecture 3: T-SQL DML DELETE Query

Lecture 4: T-SQL DML UPDATE Query

Lecture 5: T-SQL DML INSERT Query

Lecture 6: T-SQL DDL CREATE Query

Lecture 7: T-SQL DDL ALTER Query

Lecture 8: T-SQL DDL DROP Query

Lecture 9: T-SQL DDL TRUNCATE Query

Lecture 10: Conclusion

Chapter 5: SQL Server Performance Monitoring

Lecture 1: Introduction

Lecture 2: Using Activity Monitor

Lecture 3: Collecting Data

Lecture 4: Using Performance Monitor

Lecture 5: Extended Events

Lecture 6: Indexes

Chapter 6: Security

Lecture 1: Introduction

Lecture 2: Authentication

Lecture 3: Permissions

Lecture 4: Auditing

Lecture 5: Conclusion

Lecture 6: Thank You

Instructors

Rating Distribution

  • 1 stars: 11 votes
  • 2 stars: 5 votes
  • 3 stars: 24 votes
  • 4 stars: 32 votes
  • 5 stars: 41 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Ethical AI Courses to Learn in November 2024

Top 10 Game Development Courses to Learn in November 2024

Top 10 Software Testing Courses to Learn in November 2024