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 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

 

About Mustafa Emasry

Mustafa Elmasry is a Microsoft database consultant working as a Database administrator for more than +10 Years I have very good knowledge about Database Migration, Consolidation, Performance Tuning, Automation Using T-SQL and so many other tasks I do it with multiple customers here in KSA, I am Microsoft SQL Server Certified Development and administration 2008 and 2016 (2x MCTS, 2x MCTIP, MCSA, MCSE), Microsoft Certified Trainer (MCT), Azure Certified 5X Azure Fundamental, Azure Data Fundamental, Azure Administrator, Azure Database administrator, Azure Data Engineer also I was awarded by Microsoft Azure Heroes 3 times as (Azure Content hero, Azure Community hero and Azure Mentor) for more information about my experiences and my activity for spreading the knowledge please check my webpage https://mostafaelmasry.com/about-me/ You will find on it my certification, Articles, Technical documents in Azure I participated on writing it also you can find below all of my Social account links • LinkedIn Account: https://www.linkedin.com/in/mostafaelmasry/ • Twitter Account: https://twitter.com/Elmasrydba • My Azure Articles: https://lnkd.in/edn6nyY/#AllAzurePosts • Microsoft Azure Hero 3X: https://www.azureheroes.community/user/5363 • Founder of Database Cloud Tech blog: https://mostafaelmasry.com/ • Founder of SQLIdol website: http://www.sqlidol.com/team/mustafa-el-masry/ • My Articles on SQLShack: https://www.sqlshack.com/author/mustafaelmasry/ • Founder of LinkedIn Group: https://www.linkedin.com/groups/8406281/ • My Certifications: https://www.youracclaim.com/users/mustafa-elmasry/badges • Other Certifications: https://skillsoft.digitalbadges.skillsoft.com/profile/mustafaelmasry/wallet • One of the top bloggers on the Middle East in SQL Server: Around 300 SQL Server Article, also I have Arabic posts on Microsoft MSDN  https://msdn.microsoft.com/ar-sa/library/dn974980.aspx  https://msdn.microsoft.com/ar-sa/library/mt131032.aspx  https://msdn.microsoft.com/ar-sa/library/mt147014.aspx  https://msdn.microsoft.com/ar-sa/library/mt131033.aspx  https://msdn.microsoft.com/ar-sa/library/mt131034.aspx

Leave a Reply

Your email address will not be published. Required fields are marked *