Microsoft Azure SQL Database Administration

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

Azure SQL Database Administration

1. Introduction

2. Getting Started with Azure SQL

1. What is Azure zone & regions

2. Azure SQL deployment options

3. Purchasing models, service tiers, and hardware choices

4. Getting Started with Azure Free Tier

5. Management interfaces Azure Portal

3. Deploy and configure servers, instances, and databases for Azure SQL

1. Introduction

2. Deploying Azure SQL Databases

3. Exploring SQL Server Management Studio

4. Exploring Azure Data Studio

5. Deploying SQL Server Managed Instance

6. Deploy SQL Server on Azure VM

4. Configure database authentication and authorization

1. Introduction

2. Authentication with Azure Active Directory

3.1 create user from aad.zip

3. Configure and Create AAD Users

4. Securables and Database Roles

5. Managing Security with Firewall Rules

6.1 granting permissions.zip

6. Granting Permissions on Securables

5. Implement compliance controls for sensitive data

1. Introduction

2.1 data classification.zip

2. Data classification and Discovery

3.1 auditing test.zip

3. Auditing Azure SQL Databases

4. Implement Row Level security

5. Microsoft Defender for Cloud

6. Protect data in-transit and at rest and in-transit

1. Explore Transparent Data Encryption

2. Object encryption and secure enclaves

3. Dynamic Data Masking

4. Enable encrypted connections

7. Deploy highly available solutions by using Azure SQL

1. Backup and restore strategies

2. Disaster Recovery

3. Restore to Point-in-Time and deleted databases

4. High Availability by service tier

8. Migrating to Azure

1. Migration using Application Data Tier

2.1 Migration With SQL Package.txt

2.2 SQL Package Documentation.html

2. Migration using SQL Package

3.1 Download Microsoft Integration Service.html

3. Migration using Azure Data Studio

4. Migration using Data Migration Assistant

9. Performance & Monitoring with Azure SQL

1. Monitoring Using Azure Portal

2. Intelligent Performance

3. Database Console Commands for SQL Server

4. Monitoring with Dynamic Management Views (DMVs)

5. Introduction to Azure SQL Query Store

6.1 index tutorial.zip

6. Performance Tuning with Indexes

7.1 monitering blocking.zip

7.2 monitering uncomminted transactions.zip

7.3 simulating blocking script 1.zip

7.4 simulating blocking script 2.zip

7. Monitoring and Resolving Blocking

10. Automation & Maintenance

1. Introduction

2. Azure Automation Account

3. Automating Task With Runbooks

4. Unsupported Features in Azure SQL.html

11. Conclusion

1. Last Words

139,000 تومان

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

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

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

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