Comprehensive SQL Server Administration Part 1

سرفصل های دوره

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

1 - Introduction to Microsoft SQL Server

1 -Section 01 - Introduction to SQL Server.pdf

1 -What is SQL Server

2 -The Evolution (Versions) of SQL Server

3 -The Editions of SQL Server

4 -The SQL Server Configuration Manager

5 -The SQL Server Management Studio

6 -Demo SQL Server Configuration Manager

7 -Demo SQL Server Management Studio Part 1

8 -Demo SQL Server Management Studio Part 2

9 -SQL Server Databases

10 -Database Types

11 -System Databases (Deep Dive)

12 -Database Server Environments

13 -Demo Database Types Part 1

14 -Demo Database Types Part 2

15 -Demo Database Types Part 3

2 - Authentications, Role-Based Access Control and Permissions

1 -Logins and Users

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

2 -Server Roles

3 -Database Roles

4 -Permissions

5 -Demo Windows Login

6 -Demo Database Roles

7 -Demo Login Failed Error Troubleshooting

8 -Demo Roles and Permissions

9 -Demo Windows Active Directory Group

10 -Demo SQL Login

3 - Disaster Recovery

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

1 -What is a Disaster

2 -Disaster Recovery Terminologies

3 -Database Recovery Models

4 -Database Backup Part 1

5 -Database Backup Part 2

6 -Database Restore

7 -Demo Disaster Recovery Strategies Part 1

8 -Demo Disaster Recovery Strategies Part 2

9 -Demo Database Backup Part 1

10 -Demo Database Backup Part 2

11 -Demo Database Restore Part 1

12 -Demo Database Restore Part 2

13 -Demo Database Restore Part 3

14 -Disaster Recovery Exercises

4 - Database Maintenance

1 -Database Maintenance Tasks

2 -Demo Database Maintenance Tasks Using GUI Part 1

3 -Demo Database Maintenance Tasks Using GUI Part 2

4 -Demo Database Maintenance Tasks Using GUI Part 3

5 -Demo Database Maintenance Tasks Using Ola Hallengren Part 1

6 -Demo Database Maintenance Tasks Using Ola Hallengren Part 2

7 -Knowledge Check Exercises

5 - Log Shipping

1 -Introduction to High Availability

2 -Introduction to Log Shipping

3 -Log Shipping Pros and Cons

4 -Demo Log Shipping Configuration Part 1

5 -Demo Log Shipping Configuration Part 2

6 -Demo Log Shipping Configuration Part 3

7 -Demo Failover in Log Shipping Part 1

6 - Mirroring

1 -Introduction to Database Mirroring

2 -Synchronous vs Asynchronous Commit Modes

3 -Database Mirroring Pros and Cons

4 -Demo Database Mirroring Configuration Part 1

5 -Demo Database Mirroring Configuration Part 2

6 -Demo Database Mirroring Configuration Part 3

7 - AlwaysOn Availability Group

1 -Introduction to AlwaysOn Availability Group

2 -AlwaysOn Availability Group Pros and Cons Part 1

3 -AlwaysOn Availability Group Pros and Cons Part 2

4 -AlwaysOn Availability Group Configuration Steps Part 1

5 -AlwaysOn Availability Group Configuration Steps Part 2

6 -Demo AlwaysOn Availability Group Configuration Part 1

7 -Demo AlwaysOn Availability Group Configuration Part 2

8 -Demo AlwaysOn Availability Group Configuration Part 3

9 -Demo AlwaysOn Availability Group Configuration Part 4

10 -Demo AlwaysOn Availability Group Cluster Permission

11 -Demo AlwaysOn Availability Group Quorum Configuration

8 - Replication

1 -Introduction to Replication

2 -Replication Topology

3 -Replication Backward Compatibility

4 -Replication Types

5 -Replication Agents

6 -Transactional vs Snapshot Replication

7 -Replication Pros and Cons

8 -Demo Transactional Replication Configuration Part 1

9 -Demo Transactional Replication Configuration Part 2

10 -Demo Transactional Replication Configuration Part 3

11 -Demo Transactional Replication Configuration Part 4

12 -Demo Transactional Replication Configuration Part 5

13 -Demo Snapshot Replication Configuration

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy