Learn Database Administration with SQL Server 2019. No prior experience needed.
This course teaches two things at the same time:
What you’ll 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.
Course Content
- Introduction –> 19 lectures • 6hr 43min.
Requirements
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.