As providing reporting and analytics capabilities in a Dynamics 365 solution is becoming increasingly important I decided to brush up my knowledge about available technologies and patterns in the data area. I think that taking a certification exam is a good way to get started on such a broad topic and it also allows you to set a clear goal. So end of last year, I finally took the DP-900: Microsoft Azure Data Fundamentals exam.
Whenever you want to attain a Microsoft certification, the first place to start is always the study guide which you can find on the certification home page. Another interesting addition from Microsoft is the ability to take a practice assessment for DP-900 (link is listed on the certification home page - there is also a full list of all practice assessments for Microsoft Certifications. Listed below are some of the links and resources that I used - mainly on topics where I had less hands-on experience - so this is definitely not an exhaustive list.
YouTube videos playlists
Describe core data concepts
Describe capabilities of Azure storage
Describe capabilities and features of Azure Cosmos DB
Describe relational Azure Data services
- Features comparison: Azure SQL Database and Azure SQL Managed Instance
- Azure SQL Database security features
- Aggregate functions (Transact-SQL)
- SQL Tools overview: Azure Data Studio, SQL Server Management Studio (SSMS), SQL Server Data Tools (SSDT) and mssql extension for VS Code and command line tools
- What is Azure Data Studio?
- Clustered and non-clustered indexes described
Describe common elements of large-scale analytics
Describe data visualization in Microsoft Power BI
No comments:
Post a Comment