- 1 Understanding Relational Data with Azure
- 2 Creating Reports with Power BI
- 3 Optimize Model Performance with Power BI
- 4 Designing Business Solutions with Microsoft Power Platform
- 5 Configuring Model-driven Applications with Power Apps (PL-400)
- 6 Explore Data by Using Azure Synapse Analytics (DP-500)
- 7 Optimize Enterprise-scale Data Models (DP-500)
- 8 Query Data by Using Azure Synapse Analytics
Are you a seasoned data professional heading towards a cloud environment? Do you have profound SQL knowledge, but you’re not sure how it can be applied in Azure Data Services? Or do you simply want to acquire the skills necessary to successfully pass the DP-900 exam? In this course, Understanding Relational Data with Azure, you’ll gain the ability to identify key concepts and features in the Azure relational ecosystem. First, you’ll explore the main characteristics of OLTP and OLAP systems. Next, you’ll discover the difference between various Azure delivery models, such as PaaS, IaaS, and SaaS. You’ll also understand key characteristics of various relational Data Services within Azure, namely Azure SQL Database, Azure DB for MySQL, and Azure DB for PostgreSQL. Finally, you’ll learn how to connect and query relational data from Azure SQL Database, Azure DB for MySQL, and Azure DB for PostgreSQL. When you’re finished with this course, you’ll have the foundational understanding of relational data in Azure that will enable you to make a smooth transition from on-prem to a cloud environment, and get you ready for the DP-900 exam.
Building a data-driven story is one of the core requirements for effective business decision-making. This course will teach you how to design and configure comprehensive reporting solutions with Microsoft Power BI.
Creating a Power BI report may look like an easy task, but there is a huge difference between the report that works and the report that works efficiently! This course will teach you how to optimize model performance and build efficient solutions.
Microsoft Power Platform offers a whole range of low-code solutions to common business challenges. This course will teach you how to design efficient solutions using different components of Microsoft Power Platform ecosystem and get you ready for PL-100 (Microsoft Power Platform App Maker) exam!
Model-driven apps enable you to create robust and scalable data-driven business solutions. This course will teach you how to design, configure and deploy efficient model-driven apps with Microsoft Power Apps.
Providing insight from the data should be a quick and straightforward process. This course will teach you how to explore and visualize the data in Azure Synapse Analytics directly.
You’ve built an enterprise data solution and now struggling with performance. In this course, Optimize Enterprise-scale Data Models – DP-500, you’ll learn to design optimal data models to support large enterprises. First, you’ll explore various areas for performance improvement. Next, you’ll discover how to leverage different external tools to fine-tune your data model. Finally, you’ll learn how to apply some advanced concepts, such as incremental refresh and denormalization. When you’re finished with this course, you’ll have a foundational understanding of performance optimization in Power BI that will enable you to design optimal enterprise-scale data models and get you ready for the DP-500 exam.
Providing insight from data should be a fast and efficient process. In this course, Query Data by Using Azure Synapse Analytics – DP-500, you’ll learn to perform exploratory data analysis in Azure Synapse Analytics. First, you’ll discover the key components of the Azure Synapse Analytics platform. Next, you’ll understand how to leverage various file types to explore the data from serverless SQL pools, and how to query the relational data stored in dedicated SQL pool. Finally, you’ll learn how to use a machine learning PREDICT function to take your queries to another level. When you’re finished with this course, you’ll have the foundational understanding of the data exploration process in Azure Synapse Analytics that will enable you to explore and query the data in Azure Synapse Analytics and get you ready for the DP-500 exam.