DP-300 Exam Preparation: Introduction

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

1. DP-300 Exam Preparation Introduction

Learning Path Introduction

2. Implementing Azure SQL Databases

1. Course Introduction

2. Overview

3. High Availability and Disaster Recovery Concepts

4. Hyperscale

5. Combining On-Premises with the Cloud

6. Always On Availability Groups

7. Failover in the Cloud

8. Database Backups

9. Course Summary

3. Azure SQL and SQL Server Database Monitoring

1. Course Introduction

2. Baseline

3. What to Capture

4. Intelligent Performance

5. Intelligent Insights

6. Consuming Insights

7. DEMO- Streaming Intelligent Insights to Azure SQL Analytics

8. SQL Server Management Studio Reports

9. Wait Statistics

10. Common Wait Types

11. Index & Statistics Maintenance

12. Monitor Storage

13. Alerts

14. DEMO- Disk Space Alert

15. DEMO- Database Mail

16. Course Summary

4. Azure SQL and SQL Server Database Task Automation

1. Course Introduction

2. Database Maintenance

3. Data Maintenance and Recurring Data

4. Maintenance Plans

5. DEMO Maintenance Wizard

6. New Maintenance Plan

7. SQL Agent Jobs

8. DEMO Importing Data

9. Automation Across Servers

10. DEMO SQL Multi-Server Administration

11. SQL Server Policy Management

12. DEMO Policy Management

13. Recovery Services Vault

14. DEMO Recovery Services Vault

15. Microsoft Azure Backup Service

16. Azure Automation Service

17. DEMO Azure Automation Service

18. Elastic Jobs

19. DEMO Elastic Jobs

20. Automated Tuning

21. Automated Patching

22. Course Summary

5. Azure Database Performance Tuning

1. Introduction

2. Overview

3. Storage Performance

4. Disk Performance

5. Disk Caching

6. Disk Striping

7. File Performance

8. Instant File Initialization

9. Temporary Disk and TempDB

10. Virtual Machine Size

11. Managing an Instances Resources

12. SQL Server System Accounts

13. Database Configuration

14. Intelligent Query Processing

15. Azure SQL Serverless

16. Summary

6. Azure SQL and SQL Server Query Performance Tuning

1. Course Introduction

2. Overview

3. Query Processing

4. Query Plans

5. Query the Query Store

6. DEMO Hint at an Index

7. Index Types

8. Table Designs

9. Columnstore Index

10. Storage

11. Compression

12. Course Summary

7. Implementing High Availability and Disaster Recovery for Azure SQL Databases

1. Course Introduction

2. Overview

3. High Availability and Disaster Recovery Concepts

4. Hyperscale

5. Combining On-Premises with the Cloud

6. Always On Availability Groups

7. Failover in the Cloud

8. Database Backups

9. Course Summary

8. Implementing Azure SQL Data Security

1. Course Introduction

2. Course Overview

3. Azure SQL Firewall Rules

4. DEMO Vnet to Vnet and Azure Data Gateway

5. Azure SQL Disk Encryption

6. Azure SQL Transparent Data Encryption

7. Azure SQL Column Encryption

8. Azure SQL Advanced Data Security

9. Azure SQL Track Data Changes

10. Summary

9. Azure Database Authentication and Access

1. Course Introduction

2. Overview

3. Why Use Azure Active Directory Authentication

4. Implementing Azure Active Directory Authentication

5. Setting the Active Directory Admin

6. Create an Azure Active Directory User

7. Managed Identity

8. What Weve Learned in the Demos

9. Database Roles

10. The Principle of Least Privilege

11. Permissions on Objects

12. Managing Permissions with the SSMS GUI

13. Course Summary

10. Azure SQL - Designing and Implementing a Migration Plan

1. Azure SQL Designing and Implementing a Migration Plan - Introduction

2. Evaluating Your Current Database Environment

3. Migration Scenarios

4. Data Transfer

5. Azure Migrate

6. Data Migration Service Demo

7. Data Migration Assistant Assessment Demo

8. Data Migration Assistant Migration Demo

9. SQL Server Migration Assistant Demo

10. MySQL Migration Demo

11. Azure SQL Designing and Implementing a Migration Plan - Summary

189,000 تومان

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

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

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

مدرس: Hallam Webber