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.

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

Prerequisites

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

Prices & Delivery methods

Online Training

Duration
1 day

Price
  • Online Training: CAD 675
  • Online Training: US $ 675
Classroom Training

Duration
1 day

Price
  • Canada: CAD 675

Click on town name or "Online Training" to book Schedule

This is an Instructor-Led Classroom course
Instructor-led Online Training:   This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.

United States

Online Training 09:00 Pacific Standard Time (PST) Enroll
Online Training 09:00 Central Daylight Time (CDT) Enroll
Online Training 09:00 Eastern Daylight Time (EDT) Enroll
Online Training 09:00 Central Daylight Time (CDT) Enroll
Online Training 09:00 Pacific Standard Time (PST) Enroll

Canada

Online Training 09:00 Pacific Standard Time (PST) Enroll
Online Training 09:00 Central Daylight Time (CDT) Enroll
Online Training 09:00 Eastern Daylight Time (EDT) Enroll
Online Training 09:00 Central Daylight Time (CDT) Enroll
Online Training 09:00 Pacific Standard Time (PST) Enroll