Training: Develop data-driven applications with Azure SQL Database (DP-3020)

Ref. DP-3020

Download PDF

Duration:

jour

Exam:

Non certifiant

Level:

Intermédiaire

Funding:

Eligible

Home > Trainings > IT Pro > Develop data-driven applications with Azure SQL Database (DP-3020)

Develop data-driven applications with Azure SQL Database Training (DP-3020)

You need to build semantic models for Power BI reporting but struggle with data modeling best practices and DAX optimization? Semantic models are the foundation of every Power BI report, and poorly designed models lead to slow reports, incorrect calculations and frustrated users. Without proper modeling skills, analytics investments fail to deliver their full value.

This official Microsoft DP-3020 Applied Skills training enables you in 1 day to build Power BI semantic models in Microsoft Fabric. Guided by MCT-certified trainers, you learn to design star schemas, create relationships, write DAX measures and calculated columns, implement row-level security, and optimize model performance. You practice building production-ready semantic models connected to Fabric data sources. This hands-on credential validates your data modeling skills for Power BI analytics. Sessions are available in person in Geneva and Lausanne or via virtual classroom.

Participant Profiles

<ul>
<li>Solution architects</li>
<li>Application developers</li>
<li>Database administrators</li>
<li>DevOps engineers</li>
<li>IT project managers</li>
</ul>

Objectives

Design star schemas for Power BI semantic models
Create and manage table relationships
Write DAX measures and calculated columns
Implement row-level security for data access control
Optimize semantic model performance
Connect models to Fabric data sources

Prerequisites

Experience with relational databases
Knowledge of security concepts: identities and permissions
Using the Azure Portal to create resources

Course Content

Module 1 : Get started with Azure SQL Database for modern application development

Explain deployment options
Explore Hyperscale capabilities
Understand the serverless compute tier
Enable application resilience with Azure SQL Database
Understand AI capabilities for Azure SQL Database

Module 2 : Develop for Azure SQL Database

Create and configure an Azure SQL Database
Use SQL Database Projects
Build and deploy database projects in GitHub Actions and Azure DevOps
Secure and monitor Continuous Integration and Continuous Deployment (CI/CD)

Module 3 : Develop a data API for Azure SQL Database

Explore Data API Builder for Azure SQL Database
Develop a data API using Azure Static Web Apps
Develop a data API using Azure Web App for Containers

Module 4 : Explore data manipulation options in Azure SQL Database

Use RESTful endpoints to import data to Azure SQL Database
Manipulate data in Azure SQL Database with Azure Functions
Understand the data movement tools available

Module 5 : Explore security practices for Azure SQL Database

Explore authentication methods
Configure managed identity
Understand firewall rules
Explore advanced data security

Documentation

Access to Microsoft Learn, Microsoft’s online learning platform, offering interactive resources and educational content to deepen your knowledge and develop your technical skills.

Lab / Exercises

This course provides you with exclusive access to the official Microsoft lab, enabling you to practice your skills in a professional environment.

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

Power BI semantic models: the foundation of effective analytics

Semantic models are the core of every Power BI report, defining how data is structured, related and calculated. A well-designed semantic model ensures fast reports, accurate calculations and a consistent user experience. In Microsoft Fabric, semantic models benefit from direct connectivity to lakehouses and warehouses through OneLake. This DP-3020 credential validates your ability to build production-ready models, an essential skill for analytics professionals in Switzerland.

What you practice during this 1-day training

This hands-on training focuses on building semantic models in Microsoft Fabric. You design star schemas with fact and dimension tables, create relationships and manage cardinality, write DAX measures and calculated columns, implement row-level security for data access control, optimize model performance through best practices, and connect to Fabric data sources. All exercises are performed on real Fabric environments with MCT-certified trainer guidance.

Frequently Asked Questions

What are the prerequisites for this DP-3020 training?

You should have basic Power BI experience and understanding of data modeling concepts. Familiarity with DAX fundamentals is helpful but the training covers essential DAX patterns.

Is this an Applied Skills credential or a certification?

DP-3020 is a Microsoft Applied Skills credential, validating your practical semantic model building skills through a scenario-based assessment.

Do I need Microsoft Fabric to use semantic models?

Semantic models can be built in both Power BI Desktop and Microsoft Fabric. This training focuses on the Fabric environment where models benefit from tighter integration with lakehouses and warehouses, but the skills are transferable to Power BI Desktop as well.