This is an example of a simple banner

Training: Configure and migrate to Azure Database for PostgreSQL (DP-3021)

Ref. DP-3021
Duration:
1
 jour
Exam:
Non certifiant
Level:
Intermédiaire

Configure and migrate to Azure Database for PostgreSQL Training (DP-3021)

You need to create compelling Power BI reports but your dashboards lack visual impact and user engagement? Report design is both an art and a science, requiring knowledge of visualization best practices, interactivity features and performance optimization. Without proper design skills, reports fail to communicate insights effectively and users abandon them.

This official Microsoft DP-3021 Applied Skills training enables you in 1 day to build Power BI reports in Microsoft Fabric. Guided by MCT-certified trainers, you learn to design report layouts, choose appropriate visualizations, implement drill-through and cross-filtering, add bookmarks and buttons for navigation, and optimize report performance. You practice creating interactive, visually compelling reports connected to semantic models in Fabric. This hands-on credential validates your Power BI report design skills. Sessions are available in person in Geneva and Lausanne or via virtual classroom.

Participant Profiles

  • Database administrators
  • Cloud engineers
  • Back-end developers
  • Cloud solutions architects

Objectives

  • Design effective report layouts and page structures
  • Choose appropriate visualizations for different data types
  • Implement drill-through, cross-filtering and interactive features
  • Add bookmarks and buttons for report navigation
  • Optimize report performance and loading times
  • Create visually compelling dashboards connected to semantic models

Prerequisites

  • Master relational databases
  • Have basic SQL knowledge
  • Understand cloud computing principles

Course Content

Module 1: Explore PostgreSQL architecture

  • Describe Azure Database for PostgreSQL
  • Understand PostgreSQL architecture
  • Understand PostgreSQL shared memory

Module 2: Understand client-server communication in PostgreSQL

  • Understand connection handling
  • Understand the PostgreSQL client tools

Module 3: Understand PostgreSQL query processing

  • Identify the query processing components
  • Understand the EXPLAIN statement

Module 4: Secure Azure Database for PostgreSQL

  • Describe Azure Database for PostgreSQL security
  • Describe built-in Azure Database for PostgreSQL server roles
  • Grant permissions in Azure SQL Database for PostgreSQL
  • Understand encryption in Azure Database for PostgreSQL

Module 5: Procedures and functions in PostgreSQL

  • Create a stored procedure in Azure Database for PostgreSQL
  • Call a stored procedure in Azure Database for PostgreSQL
  • Create and use a function in Azure Database for PostgreSQL

Module 6: Understand write-ahead logging

  • Describe write ahead logging
  • Describe replication and logical decoding

Module 7: Configure and manage Azure Database for PostgreSQL

  • Understand the system catalogs and system views
  • Investigate metadata with system catalogs and system views
  • Explain the purpose of vacuum and autovacuum
  • Configure autovacuum server parameters

Module 8: Understand concurrency in PostgreSQL

  • Understand multi-version concurrency control (MVCC) and snapshots
  • Describe isolation levels
  • Understand locking

Module 9: Tune queries in Azure Database for PostgreSQL

  • Understand statistics
  • Assess query performance with the Query Store

Module 10: Migrate to Azure Database for PostgreSQL flexible server

  • Compare online and offline migrations
  • Identify migration tool options
  • Analyze the decision criteria for tool selection and migration model

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 reports: turning data into visual insights

Report design in Power BI is the final mile of the analytics pipeline, where data models become actionable business insights. Effective reports require more than just placing charts on a page; they need thoughtful layout design, appropriate visualization choices, intuitive interactivity and optimized performance. In Microsoft Fabric, Power BI reports connect directly to semantic models and benefit from the unified platform. This DP-3021 credential validates your ability to create impactful reports.

What you practice during this 1-day training

This hands-on training focuses on building Power BI reports in Microsoft Fabric. You design effective page layouts, choose appropriate visualizations for different data types, implement drill-through and cross-filtering interactions, add bookmarks and buttons for navigation, optimize report performance and loading times, and create mobile-responsive designs. All exercises are performed on real Fabric environments with MCT-certified trainer guidance.

Frequently Asked Questions

What are the prerequisites for this DP-3021 training?

You should have basic Power BI experience and understanding of semantic models. Completing DP-3020 beforehand provides an excellent foundation for this report design training.

Is this an Applied Skills credential or a certification?

DP-3021 is a Microsoft Applied Skills credential, validating your practical Power BI report design skills through a scenario-based assessment.

Can I use these skills in Power BI Desktop as well?

Yes, report design skills are fully transferable between Microsoft Fabric and Power BI Desktop. This training uses the Fabric environment but all visualization and interactivity techniques apply to Desktop as well.

Prix de l'inscription
CHF 850.-
Inclus dans ce cours
  • Training provided by a certified trainer
  • 180 days of access to Official Microsoft Labs
  • Official documentation in digital format
  • Official Microsoft achievement badge
Mois actuel

lun20juil09:00lun17:00VirtuelVirtual Etiquettes de sessionDP-3021

lun20juil09:00lun17:00Lausanne, Av. Mon-Repos 24, 1005 Lausanne Etiquettes de sessionDP-3021

lun24Aoû09:00lun17:00VirtuelVirtual Etiquettes de sessionDP-3021

lun24Aoû09:00lun17:00Genève, Route des Jeunes 35, 1227 Genève Etiquettes de sessionDP-3021

lun28Sep09:00lun17:00VirtuelVirtual Etiquettes de sessionDP-3021

lun28Sep09:00lun17:00Lausanne, Av. Mon-Repos 24, 1005 Lausanne Etiquettes de sessionDP-3021

lun02Nov09:00lun17:00VirtuelVirtual Etiquettes de sessionDP-3021

lun02Nov09:00lun17:00Genève, Route des Jeunes 35, 1227 Genève Etiquettes de sessionDP-3021

lun07Déc09:00lun17:00VirtuelVirtual Etiquettes de sessionDP-3021

lun07Déc09:00lun17:00Lausanne, Av. Mon-Repos 24, 1005 Lausanne Etiquettes de sessionDP-3021

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00

Contact-us

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Make a request

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request