Database Administration with SQL Server 2019

Focused View

Safraz Hosein

6:43:16

156 View

1.1 Lesson 1 - Course Introduction.pptx

1. Lesson 1 - Course Introduction.mp4

17:50

2.1 Lesson 2 Part 1 - Lesson Notes.pdf

2.2 Lesson 2 Part 1 - Software Download.pptx

2. Lesson 2 Part 1 - Software Download.mp4

06:31

3.1 Lesson 2 Part 2 - VMWare Player.pptx

3. Lesson 2 Part 2 - VMWare Player.mp4

03:36

4.1 Lesson 2 Part 3 - Windows Server 2019.pptx

4. Lesson 2 Part 3 - Windows Server 2019.mp4

09:37

5.1 Lesson 2 Part 4 - SQL Server 2019.pptx

5. Lesson 2 Part 4 - SQL Server 2019.mp4

18:36

6.1 Lesson 2 Part 5 - Connecting to SQL Server.pptx

6.2 Lesson 2 Part 5 - Lesson Notes.pdf

6. Lesson 2 Part 5 - Connecting to SQL Server.mp4

20:54

7.1 Lesson 3 - Creating a database.pptx

7. Lesson 3 - Creating a database.mp4

12:34

8.1 Lesson 4 - Lesson Notes.pdf

8.2 Lesson 4 - Logins Users Roles.pptx

8. Lesson 4 - Logins, Users, and Roles.mp4

17:57

9.1 Lesson 5 - Lesson Notes.pdf

9.2 Lesson 5 - SQL.pptx

9. Lesson 5 - SQL.mp4

50:05

10.1 Lesson 6 - Instance Configuration.pptx

10.2 Lesson 6 - Lesson Notes.pdf

10. Lesson 6 - Instance Configuration.mp4

18:02

11.1 Lesson 7 - Lesson Notes.pdf

11.2 Lesson 7 - TempDB.pptx

11. Lesson 7 - TempDB.mp4

16:07

12.1 Lesson 8 - Lesson Notes.pdf

12.2 Lesson 8 - Parallelism.pptx

12. Lesson 8 - Parallelism.mp4

12:33

13.1 Lesson 9 - Transaction Log Files.pptx

13. Lesson 9 - Transaction Log.mp4

06:35

14.1 Lesson 10 - Backups.pptx

14.2 Lesson 10 - Lesson Notes.pdf

14. Lesson 10 - Backups.mp4

51:06

15.1 Lesson 11 - Lesson Notes.pdf

15.2 Lesson 11- Recovery.pptx

15. Lesson 11- Recovery.mp4

39:54

16.1 Lesson 12 - Automation.pptx

16. Lesson 12 - Automation.mp4

25:12

17.1 Lesson 13 - High Availability and Disaster Recovery.pptx

17.2 Lesson 13 - Lesson Notes.pdf

17. Lesson 13 - High Availability and Disaster Recovery.mp4

31:01

18.1 Lesson 14 - Cloud.pptx

18.2 Lesson 14 - Lesson Notes.pdf

18. Lesson 14 - Cloud.mp4

12:13

19.1 Lesson 15 - Corruption.pptx

19.2 Lesson 15 - Lesson Notes.pdf

19. Lesson 15 - Corruption.mp4

32:53

Description

Learn Database Administration with SQL Server 2019. No prior experience needed.

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

Who is this for?

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

What You Need to Know?

Know what is an IP Address. Every thing else will be taught

More details

Description
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.

Who this course is for:
Any IT Staff or Student who wants to learn about Database Administration and SQL Server

User Reviews

Rating

average 0

Total votes0

Focused display

I am a Software Developer/Database Administrator using primarily Oracle and SQL Server. My current area of interest is Production Database Administration. Any questions you have, please feel free to contact me at:[email protected] Future learning will include performance tuning on both Oracle and SQL Server. Apart from my career, I enjoy football and calisthenics.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.