Administering Microsoft Azure SQL Solutions (DP-300 Exam Prep/DP-300T00)

أدر قواعد بيانات SQL في Azure. خلال أربعة أيام تنشر حلول SQL بنموذجي IaaS وPaaS، وترحّل أحمال العمل إلى Azure SQL Database وManaged Instance، وتؤمّن البيانات وتحميها، وتراقب الأداء وتضبطه، استعداداً لامتحان DP-300.

4 أياممتوسط20 وحدةDP-300 Exam Prep/DP-300T00Microsoft Certified: Azure Database Administrator Associate

سجّل أو استفسر ←اسأل عبر واتساب

نظرة عامة

المنهاج

المحتوى التقني أدناه معروضٌ باللغة الإنجليزية كما ورد في منهاج الدورة، حفاظاً على دقّة المصطلحات.

20 وحدة

Describe Microsoft Intelligent Data Platform roles
Understand SQL Server in an Azure virtual machine
Design Azure SQL Database for cloud-native applications
Explore Azure SQL Managed Instance
Module assessment

Explain IaaS options to deploy SQL Server in Azure
Understand hybrid scenarios
Explore performance and security
Explain high availability and disaster recovery options
Module assessment

Explain PaaS options for deploying SQL Server in Azure
Explore single SQL database
Deploy SQL database elastic pool
Understand SQL database hyperscale
Examine SQL managed instance
Module assessment

Choose the right Azure SQL Database feature
Use Azure SQL migration extension to migrate to Azure SQL Database
Migrate to Azure SQL Database using BACPAC
Use an online method to migrate to Azure SQL Database
Move data to Azure SQL Database
Module assessment

Evaluate migration scenarios
Use Log Replay Service (LRS) to migrate
Migrate using Managed Instance link
Move data to SQL Managed Instance
Module assessment

Describe authentication and identities
Describe Security Principals
Describe database and object permissions
Identify authentication and authorization failures
Module assessment

Explore Transparent Data Encryption
Configure server and database firewall rules
Explain object encryption and secure enclaves
Enable encrypted connections
Describe SQL injection
Understand Azure Key Vault
Module assessment

Explore data classification
Explore server and database audit
Implement Dynamic Data Masking
Implement Row Level security
Understand Microsoft Defender for SQL
Explore Ledger
Implement Microsoft Purview
Module assessment

Describe performance monitoring tools
Describe critical performance metrics
Establish baseline metrics
Explore extended events
Describe database watcher (preview)
Explore Query Performance Insight
Module assessment

Explain how to optimize Azure storage for SQL Server virtual machines
Describe virtual machine resizing
Optimize database storage
Control SQL Server resources
Module assessment

Explore database maintenance checks
Describe database scoped configuration options
Describe automatic tuning
Describe intelligent query processing
Module assessment

Understand query plans
Explain estimated and actual query plans
Describe dynamic management views and functions
Explore Query Store
Identify problematic query plans
Describe blocking and locking
Module assessment

Describe normalization
Choose appropriate data types
Design indexes
Module assessment

Describe wait statistics
Tune and maintain indexes
Understand query hints
Explore performance scenarios
Module assessment

Describe deployment models in Azure
Automate deployment by using Azure Resource Manager templates and Bicep
Automate deployment by using PowerShell
Automate deployment by using Azure CLI
Module assessment

Create a SQL Server maintenance plan
Describe task status notifications

Explore Elastic jobs
Understand Azure Automation
Build an automation runbook
Automate database workflows by using Logic Apps
Monitor automated tasks
Module assessment

Describe recovery time objective and recovery point objective
Explore high availability and disaster recovery options
Describe Azure high availability and disaster recovery features for Azure Virtual Machines
Describe high availability and disaster recovery for PaaS deployments
Explore high availability and disaster recovery solution for IaaS
Describe hybrid solutions
Module assessment

Describe failover clusters in Windows Server
Configure Always-on availability groups
Describe active geo-replication for Azure SQL Database
Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance
Monitor availability
Module assessment