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

 

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

Prerequisites

  • Demonstrate an understanding of relational databases.
  • Demonstrate an understanding of basic SQL.

Course Content

  • 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

Prices & Delivery methods

Online training
Modality: L

Duration 1 day

Price
  • on request
Dates and Booking
Enquire a date
Classroom training
Modality: C

Duration 1 day

Price
  • on request
Dates and Booking
Enquire a date

Schedule

English

Time zone: Central European Time (CET)   ±1 hour

Online training Time zone: British Summer Time (BST) Course language: English
Online training Time zone: Greenwich Mean Time (GMT) Course language: English

6 hours difference

Online training Time zone: Eastern Standard Time (EST) Course language: English
Online training Time zone: Eastern Standard Time (EST) Course language: English
Online training Time zone: Eastern Daylight Time (EDT) Course language: English
Online training Time zone: Eastern Daylight Time (EDT) Course language: English
Online training Time zone: Eastern Daylight Time (EDT) Course language: English
Online training Time zone: Eastern Daylight Time (EDT) Course language: English

7 hours difference

Online training Time zone: Central Standard Time (CST) Course language: English
Online training Time zone: Central Standard Time (CST) Course language: English
Online training Time zone: Central Daylight Time (CDT) Course language: English
Online training Time zone: Central Daylight Time (CDT) Course language: English
Online training Time zone: Central Daylight Time (CDT) Course language: English
Online training Time zone: Central Daylight Time (CDT) Course language: English
Online training Time zone: Central Daylight Time (CDT) Course language: English
Online training Time zone: Central Daylight Time (CDT) Course language: English
Online training Time zone: Central Standard Time (CST) Course language: English
Online training Time zone: Central Standard Time (CST) Course language: English

9 hours difference

Online training Time zone: Pacific Daylight Time (PDT) Course language: English
Online training Time zone: Pacific Daylight Time (PDT) Course language: English
Online training Time zone: Pacific Daylight Time (PDT) Course language: English
Online training Time zone: Pacific Daylight Time (PDT) Course language: English
Online training Time zone: Pacific Standard Time (PST) Course language: English
Online training Time zone: Pacific Standard Time (PST) Course language: English
Instructor-led Online Training:   This is an Instructor-Led Online course. If you have any questions about our online courses, feel free to contact us via phone or Email anytime.
This is a FLEX course, which is delivered both virtually and in the classroom.

Poland

 Warszawa This is a FLEX course.   Time zone: Central European Time (CET) Enroll:
for online training
for classroom training
Warszawa This is a FLEX course.   Time zone: Central European Summer Time (CEST) Enroll:
for online training
for classroom training
Warszawa This is a FLEX course.   Time zone: Central European Summer Time (CEST) Enroll:
for online training
for classroom training
Warszawa This is a FLEX course.   Time zone: Central European Time (CET) Enroll:
for online training
for classroom training
This is a FLEX course, which is delivered both virtually and in the classroom.