Configure and migrate to Azure Database for PostgreSQL (DP-3021) [M-DP3021]

Tijdsduur
Locatie
Op locatie, Online
Startdatum en plaats

Configure and migrate to Azure Database for PostgreSQL (DP-3021) [M-DP3021]

Global Knowledge Belgium BV
Logo van Global Knowledge Belgium BV
Opleiderscore: starstarstar_halfstar_borderstar_border 4,5 Global Knowledge Belgium BV heeft een gemiddelde beoordeling van 4,5 (uit 2 ervaringen)

Tip: meer info over het programma, prijs, en inschrijven? Download de brochure!

Startdata en plaatsen
computer Online: VIRTUAL TRAINING CENTER
6 feb. 2026
computer Online: VIRTUAL TRAINING CENTER
6 mar. 2026
computer Online: VIRTUAL TRAINING CENTER
2 apr. 2026
place1-Mechelen (Battelsesteenweg 455-B)
28 apr. 2026
computer Online: VIRTUAL TRAINING CENTRE
28 apr. 2026
computer Online: VIRTUAL TRAINING CENTER
13 mei. 2026
computer Online: VIRTUAL TRAINING CENTER
5 jun. 2026
computer Online: VIRTUAL TRAINING CENTER
3 jul. 2026
place1-Mechelen (Battelsesteenweg 455-B)
7 aug. 2026
computer Online: VIRTUAL TRAINING CENTER
7 aug. 2026
computer Online: VIRTUAL TRAINING CENTRE
7 aug. 2026
computer Online: VIRTUAL TRAINING CENTER
4 sep. 2026
computer Online: VIRTUAL TRAINING CENTER
2 okt. 2026
computer Online: VIRTUAL TRAINING CENTER
6 nov. 2026
computer Online: VIRTUAL TRAINING CENTER
3 dec. 2026
place1-Mechelen (Battelsesteenweg 455-B)
22 dec. 2026
computer Online: VIRTUAL TRAINING CENTRE
22 dec. 2026
Beschrijving

Vrijwel iedere training die op een onze locaties worden getoond zijn ook te volgen vanaf huis via Virtual Classroom training. Dit kunt u bij uw inschrijving erbij vermelden dat u hiervoor kiest.

OVERVIEW

Azure Database for PostgreSQL is a Platform as a Service database service in the Microsoft cloud. It bases itself on the PostgreSQL open-source relational database and includes built-in high availability, automatic backup and restore, as well as comprehensive security features. The pay-as-you-go pricing model provides predictable performance and near-instant scaling. In this learning path, you learn the main features of PostgreSQL and how they work in Azure Database for PostgreSQL. You learn about the different Azure Database for PostgreSQL implementation options, and how to configure a server for your needs.

OBJECTIVES

Students will learn to,

  • Explore PostgreSQL architecture
  • Unders…

Lees de volledige beschrijving

Veelgestelde vragen

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Nog niet gevonden wat je zocht? Bekijk deze onderwerpen: Data Migratie, PostgreSQL, Microsoft Azure, PL/SQL en Provisioning SQL.

Vrijwel iedere training die op een onze locaties worden getoond zijn ook te volgen vanaf huis via Virtual Classroom training. Dit kunt u bij uw inschrijving erbij vermelden dat u hiervoor kiest.

OVERVIEW

Azure Database for PostgreSQL is a Platform as a Service database service in the Microsoft cloud. It bases itself on the PostgreSQL open-source relational database and includes built-in high availability, automatic backup and restore, as well as comprehensive security features. The pay-as-you-go pricing model provides predictable performance and near-instant scaling. In this learning path, you learn the main features of PostgreSQL and how they work in Azure Database for PostgreSQL. You learn about the different Azure Database for PostgreSQL implementation options, and how to configure a server for your needs.

OBJECTIVES

Students will learn to,

  • Explore PostgreSQL architecture
  • Understand client-server communication in PostgreSQL
  • Understand PostgreSQL query processing
  • Secure Azure Database for PostgreSQL
  • Procedures and functions in PostgreSQL
  • Understand write-ahead logging
  • Configure and manage Azure Database for PostgreSQL
  • Understand concurrency in PostgreSQL
  • Tune queries in Azure Database for PostgreSQL
  • Migrate to Azure Database for PostgreSQL flexible server

CONTENT

Explore PostgreSQL architecture

  • Describe the architecture of PostgreSQL.
  • Describe the options for creating an Azure Database for PostgreSQL server.
  • Understand PostgreSQL shared memory.

Understand client-server communication in PostgreSQL

  • Understand connection handling.
  • Understand the PostgreSQL client tools.

Understand PostgreSQL query processing

  • Identify the query processing components.
  • Understand EXPLAIN.

Secure Azure Database for PostgreSQL

  • Describe the security features of Azure Database for PostgreSQL.
  • Create database users and grant permissions.
  • Understand encryption in Azure Database for PostgreSQL.

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

Understand write-ahead logging

  • Describe write-ahead logging.
  • Describe replication and logical decoding.

Configure and manage Azure Database for PostgreSQL

  • Describe system catalogs and system views in Azure Database for PostgreSQL.
  • Investigate metadata in Azure Database for PostgreSQL.
  • Explain the purpose of the vacuum process.
  • Configure vacuum server parameters.

Understand concurrency in PostgreSQL

  • Describe Multi-Version Content Control and snapshots in Azure Database for PostgreSQL.
  • Describe isolation levels in Azure Database for PostgreSQL.
  • Describe locking in Azure Database for PostgreSQL.

Tune queries in Azure Database for PostgreSQL

  • Describe statistics in Azure Database for PostgreSQL.
  • Assess query performance with the Query Store.

Migrate to Azure Database for PostgreSQL flexible server

  • Understand the different online and offline migration options.
  • Identify the different migration tools available.
  • Select the appropriate migration tool for your specific scenario.
Blijf op de hoogte van nieuwe ervaringen
Er zijn nog geen ervaringen.
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Download gratis en vrijblijvend de informatiebrochure

(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)

Heb je nog vragen?

(optioneel)
We slaan je gegevens op om je via e-mail en evt. telefoon verder te helpen.
Meer info vind je in ons privacybeleid.