Azure SQL Database administration Tips and Hints Exam (DP-300)

Finally, I got my certification Azure Database administrator Associate for Exam (DP-300) after two times failure, during the journey of study I watched many courses, videos, and articles, and this post of today is for spreading what I have from the knowledge and what I learned during the journey, and I do two things during my study published around 70 articles in Azure technologies and prepared one document to contain many pieces of information for Azure SQL Database administration

So, in this post, you will find all of the resources that you can start your study from it and the document I created it

Azure SQL Resources

• Azure SQL for beginners: https://aka.ms/azuresql4beginners or from here https://aka.ms/azuresql4beginnersch9
• Azure SQL Bootcamp:  https://aka.ms/azuresqlbootcamp
• Azure SQL Workshop: https://aka.ms/sqlworkshops
• Azure SQL Workshop Slides: https://aka.ms/azuresqlworkshopslides
• Azure SQL fundamentals:  https://aka.ms/azuresqlfundamentalsm
• Data Exposed: https://channel9.msdn.com/Shows/Data-Exposed/
• My Azure SQL Articles: https://lnkd.in/edn6nyY/#AzureSQL
• DP-300 Test Practices: https://www.examtopics.com/exams/microsoft/dp-300/view/
• Microsoft Learning Path: https://docs.microsoft.com/en-us/learn/certifications/exams/dp-300
• Pluralsight Guide: https://www.pluralsight.com/guides/cloud-certifications:-azure-database-administrator-associate
• DP-300 Exam Preparation: https://www.sqlshack.com/how-to-prepare-for-the-exam-dp-300-administering-relational-databases-on-microsoft-azure/
• DP-300 Study Guide: https://ravikirans.com/dp-300-azure-exam-study-guide/
• Udemy Course: https://www.udemy.com/course/professional-azure-sql-database-administration/

Azure Database Administration Documentation Exam (DB-300) V1

In this document, you will find much information related to the below 30 topics:

1. SQL Server on Azure VM
2. MariaDB, MySQL, and PostgreSQL on Azure
3. Azure SQL Database Architecture
4. Azure SQL Database Connectivity
5. Introduction to Azure SQL
6. Azure SQL Database Types
7. Scaling out Azure SQL Database
8. Azure SQL Database
9. Service Tier and Purchase Model
10. Azure SQL Database Elastic Pool
11. Azure SQL Database Elastic Pool Compute + Storage
12. Azure SQL Database MI Managed Instance
13. Differences between SQL Server On-Premises and Azure SQL Managed instance
14. Azure Managed instance Service Tier
15. Azure SQL Managed instance Security
16. Azure SQL MI References
17. Differences between Azure SQL Database and SQL Server and Non-Supported Features
18. Azure Database Migration
19. Azure SQL backup
20. Azure SQL Restore
21. Azure SQL Security
22. SQL Azure HA High Availability
23. Azure SQL Performance
24. Query performance insight
25. Azure SQL Analytics
26. Azure SQL Performance Recommendation Services
27. Azure SQL Automatic Tuning Services
28. Azure SQL Elastic Database Jobs
29. Azure SQL Database Data Sync
30. Azure DB-300 Exam QA

Check this link to download the Azure Database administrator Document, and for other Azure Technical Documents you can check it from here