Comprehensive SQL Server Administration Part 1

Focused View

11:47:47

0 View

1 - Introduction to Microsoft SQL Server

1 -Section 01 - Introduction to SQL Server.pdf

1 -What is SQL Server.mp4

01:22

2 -The Evolution (Versions) of SQL Server.mp4

08:30

3 -The Editions of SQL Server.mp4

06:56

4 -The SQL Server Configuration Manager.mp4

10:02

5 -The SQL Server Management Studio.mp4

02:01

6 -Demo SQL Server Configuration Manager.mp4

14:22

7 -Demo SQL Server Management Studio Part 1.mp4

08:05

8 -Demo SQL Server Management Studio Part 2.mp4

14:53

9 -SQL Server Databases.mp4

05:35

10 -Database Types.mp4

01:50

11 -System Databases (Deep Dive).mp4

03:36

12 -Database Server Environments.mp4

06:23

13 -Demo Database Types Part 1.mp4

07:05

14 -Demo Database Types Part 2.mp4

12:13

15 -Demo Database Types Part 3.mp4

09:59

2 - Authentications, Role-Based Access Control and Permissions

1 -Logins and Users.mp4

10:35

1 -Section 02 - Authentications, Role-Based Access Control and Permissions.pdf

2 -Server Roles.mp4

06:24

3 -Database Roles.mp4

08:42

4 -Permissions.mp4

05:41

5 -Demo Windows Login.mp4

10:29

6 -Demo Database Roles.mp4

09:37

7 -Demo Login Failed Error Troubleshooting.mp4

13:33

8 -Demo Roles and Permissions.mp4

11:38

9 -Demo Windows Active Directory Group.mp4

11:46

10 -Demo SQL Login.mp4

06:30

3 - Disaster Recovery

1 -Section 03 - Disaster Recovery Strategies and Database Maintenance.pdf

1 -What is a Disaster.mp4

01:43

2 -Disaster Recovery Terminologies.mp4

03:48

3 -Database Recovery Models.mp4

07:36

4 -Database Backup Part 1.mp4

14:12

5 -Database Backup Part 2.mp4

09:48

6 -Database Restore.mp4

05:46

7 -Demo Disaster Recovery Strategies Part 1.mp4

05:01

8 -Demo Disaster Recovery Strategies Part 2.mp4

09:14

9 -Demo Database Backup Part 1.mp4

07:57

10 -Demo Database Backup Part 2.mp4

10:39

11 -Demo Database Restore Part 1.mp4

11:11

12 -Demo Database Restore Part 2.mp4

13:33

13 -Demo Database Restore Part 3.mp4

08:26

14 -Disaster Recovery Exercises.mp4

01:21

4 - Database Maintenance

1 -Database Maintenance Tasks.mp4

11:40

2 -Demo Database Maintenance Tasks Using GUI Part 1.mp4

09:31

3 -Demo Database Maintenance Tasks Using GUI Part 2.mp4

09:55

4 -Demo Database Maintenance Tasks Using GUI Part 3.mp4

10:10

5 -Demo Database Maintenance Tasks Using Ola Hallengren Part 1.mp4

10:44

6 -Demo Database Maintenance Tasks Using Ola Hallengren Part 2.mp4

10:09

7 -Knowledge Check Exercises.mp4

00:29

5 - Log Shipping

1 -Introduction to High Availability.mp4

06:05

2 -Introduction to Log Shipping.mp4

11:22

3 -Log Shipping Pros and Cons.mp4

09:42

4 -Demo Log Shipping Configuration Part 1.mp4

07:22

5 -Demo Log Shipping Configuration Part 2.mp4

11:33

6 -Demo Log Shipping Configuration Part 3.mp4

11:33

7 -Demo Failover in Log Shipping Part 1.mp4

09:12

6 - Mirroring

1 -Introduction to Database Mirroring.mp4

10:56

2 -Synchronous vs Asynchronous Commit Modes.mp4

10:51

3 -Database Mirroring Pros and Cons.mp4

06:03

4 -Demo Database Mirroring Configuration Part 1.mp4

11:30

5 -Demo Database Mirroring Configuration Part 2.mp4

12:45

6 -Demo Database Mirroring Configuration Part 3.mp4

09:06

7 - AlwaysOn Availability Group

1 -Introduction to AlwaysOn Availability Group.mp4

09:42

2 -AlwaysOn Availability Group Pros and Cons Part 1.mp4

11:29

3 -AlwaysOn Availability Group Pros and Cons Part 2.mp4

05:37

4 -AlwaysOn Availability Group Configuration Steps Part 1.mp4

08:09

5 -AlwaysOn Availability Group Configuration Steps Part 2.mp4

05:08

6 -Demo AlwaysOn Availability Group Configuration Part 1.mp4

07:48

7 -Demo AlwaysOn Availability Group Configuration Part 2.mp4

11:49

8 -Demo AlwaysOn Availability Group Configuration Part 3.mp4

11:33

9 -Demo AlwaysOn Availability Group Configuration Part 4.mp4

13:06

10 -Demo AlwaysOn Availability Group Cluster Permission.mp4

10:36

11 -Demo AlwaysOn Availability Group Quorum Configuration.mp4

07:26

8 - Replication

1 -Introduction to Replication.mp4

04:33

2 -Replication Topology.mp4

02:17

3 -Replication Backward Compatibility.mp4

08:21

4 -Replication Types.mp4

09:31

5 -Replication Agents.mp4

05:26

6 -Transactional vs Snapshot Replication.mp4

05:36

7 -Replication Pros and Cons.mp4

06:10

8 -Demo Transactional Replication Configuration Part 1.mp4

06:32

9 -Demo Transactional Replication Configuration Part 2.mp4

09:57

10 -Demo Transactional Replication Configuration Part 3.mp4

09:50

11 -Demo Transactional Replication Configuration Part 4.mp4

12:51

12 -Demo Transactional Replication Configuration Part 5.mp4

07:31

13 -Demo Snapshot Replication Configuration.mp4

08:09

Description

Introduction to SQL Server, Authentications, RBAC, Database Maintenance, Disaster Recovery, and High Availability

What You'll Learn?

Microsoft SQL Server, Versions, Editions, Database Types, Configuration Manager and Management Studio
Authentication Types, Role-Based Access Control (Server and Database Roles) and the Principle of Least Privilege
Industry Standard Disaster Recovery Strategies Using RPO, RTO and SLA
Database Maintenance Tasks (Database Backup, Index Maintenance, Statistics Update and Database Integrity Check)
High Availability Solutions such as Log Shipping, Mirroring, AlwaysOn Availability Group and Replication

Who is this for?

Individuals with Technical Hands-On Abilities (Prospective Microsoft SQL Server Database Administrators)

Beginner/Junior Microsoft SQL Server Database Administrators

Mid-Level/ Intermediate Microsoft SQL Server Database Administrators

What You Need to Know?

No Prior Information Technology (I.T) Experience Is Required

Windows Personal Computer (Laptop or Desktop)

Reliable Internet Connection

Great Passion to Learn

Existing Virtual Lab Environment for Technical Hands-on Practices

More details

Description
Dive into the world of SQL Server with our comprehensive course designed for existing and prospective Microsoft SQL Server Database Administrators. Whether you're a beginner, junior, or intermediate-level Database Administrator, this course equips you with essential skills and knowledge to excel in the field. You'll gain a solid foundation in SQL Server architecture and functionality, and learn critical topics such as authentications, database maintenance, disaster recovery, and high availability (Log Shipping, Mirroring, AlwaysOn Availability Group, and Replication).
This course is rich in technical hands-on demonstrations to enhance your comprehension of the material, and it includes numerous practice exercises to reinforce your learning. You'll also find a wealth of typical interview questions to help you prepare for job interviews and knowledge checks. Designed to help you break into the IT field or switch roles within the industry, this course ensures you are well-prepared for your career.
This engaging course is perfect for those with a passion for technical hands-on activities and aims to provide a solid foundation in SQL Server administration.
Prerequisite to this course is a virtual lab, with setup videos available in my first course (Comprehensive SQL Server Administration Lab Setup). Trainees with an existing lab can skip the first course and proceed with this course.
Who this course is for:
Individuals with Technical Hands-On Abilities (Prospective Microsoft SQL Server Database Administrators)
Beginner/Junior Microsoft SQL Server Database Administrators
Mid-Level/ Intermediate Microsoft SQL Server Database Administrators

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft SQL

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.