Database Administration with SQL Server 2019

Database Administration with SQL Server 2019, available at $54.99, has an average rating of 4.13, with 20 lectures, based on 4 reviews, and has 22 subscribers.

You will learn about Learn the roles of the Database Administrator Learn how to install and configure SQL Server 2019 Learn how to do Backups and Restores to keep in line with Business Continuity Planning Learn how to configure security for SQL Server 2019 This course is ideal for individuals who are Any IT Staff or Student who wants to learn about Database Administration and SQL Server It is particularly useful for Any IT Staff or Student who wants to learn about Database Administration and SQL Server.

Enroll now: Database Administration with SQL Server 2019

Summary

Title: Database Administration with SQL Server 2019

Price: $54.99

Average Rating: 4.13

Number of Lectures: 20

Number of Published Lectures: 20

Number of Curriculum Items: 20

Number of Published Curriculum Objects: 20

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Learn the roles of the Database Administrator

Learn how to install and configure SQL Server 2019

Learn how to do Backups and Restores to keep in line with Business Continuity Planning

Learn how to configure security for SQL Server 2019

Who Should Attend

Any IT Staff or Student who wants to learn about Database Administration and SQL Server

Target Audiences

Any IT Staff or Student who wants to learn about Database Administration and SQL Server

This course teaches two things at the same time: 

1. How to become a Database Administrator

2. How to manage SQL Server 2019

Whether you are seeking to become a Junior Database Administrator or to just learn about managing SQL Server 2019, this course has you covered. Even if you have experience with SQL Server already, you can use this course as a reference. You will learn:

1. How to install and configure SQL Server 2019

2. How to secure SQL Server 2019

3. How to do Backup and Recovery to keep in line with Business Continuity Planning

4. The job and roles of the Database Administrator

The course outline is as follows:

Lesson 1 – Introduction

Lesson 2 – Installing and configuring a SQL Server 2019 environment

Lesson 3 – Creating a database

Lesson 4 – Logins, Users, and Roles

Lesson 5 – SQL

Lesson 6 – Instance Configuration

Lesson 7 – TempDB

Lesson 8 – Parallelism

Lesson 9 – Transaction Log

Lesson 10 – Backups

Lesson 11 – Recovery

Lesson 12 – Automation

Lesson 13 – High Availability

Lesson 14 – Cloud

Lesson 15 – Corruption

Note: No prior knowlege is needed except you need to know what is an IP Address. Everything else will be taught in the course.

The hardware requirements are:

A computer with at least 8GB of RAM. Preferrably, the RAM should be 12 GB or more.  This is required to setup a SQL Server virtualized environment. If you don’t meet the hardware requirements, you can always install SQL Server on your host machine instead of the virtual machine.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Lesson 1 – Course Introduction

Lecture 2: Lesson 2 Part 1 – Software Download

Lecture 3: Lesson 2 Part 2 – VMWare Player

Lecture 4: Lesson 2 Part 3 – Windows Server 2019

Lecture 5: Lesson 2 Part 4 – SQL Server 2019

Lecture 6: Lesson 2 Part 5 – Connecting to SQL Server

Lecture 7: Lesson 3 – Creating a database

Lecture 8: Lesson 4 – Logins, Users, and Roles

Lecture 9: Lesson 5 – SQL

Lecture 10: Lesson 6 – Instance Configuration

Lecture 11: Lesson 7 – TempDB

Lecture 12: Lesson 8 – Parallelism

Lecture 13: Lesson 9 – Transaction Log

Lecture 14: Lesson 10 – Backups

Lecture 15: Lesson 11- Recovery

Lecture 16: Lesson 12 – Automation

Lecture 17: Lesson 13 – High Availability and Disaster Recovery

Lecture 18: Lesson 14 – Cloud

Lecture 19: Lesson 15 – Corruption

Lecture 20: Lesson 16 -DAC

Instructors

Safraz Hosein
Database Administration using Oracle and SQL Server

Rating Distribution

1 stars: 1 votes

2 stars: 0 votes

3 stars: 0 votes

4 stars: 0 votes

5 stars: 3 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!