Classes Data & Analytics
DP-3021 Microsoft Technical Partner Delivered
DP-3021 Configure and migrate to Azure Database for PostgreSQL
- 1 days
- 1 upcoming date
- 1 guaranteed to run
- May qualify for CEU/PDU credit
Upcoming dates
All times shown in the class's own timezone. 1 of 1 are guaranteed to run, meaning they go ahead regardless of enrollment.
| Dates | Starts | Where | Status | Seat | Book |
|---|---|---|---|---|---|
| Tue, Dec 15 | 9:00 AM to 5:00 PM EST | Live virtual | GUARANTEED | $695 |
About this class
We have 1 scheduled date of DP-3021 Configure and migrate to Azure Database for PostgreSQL, starting Tue, Dec 15. It is guaranteed to run regardless of enrollment. Seats are $695 each over 1 day, courseware included. Book online with a card, or send a purchase order and we will invoice on net 30 terms.
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 outline
1 - Explore PostgreSQL architecture
- Describe Azure Database for PostgreSQL
- Understand PostgreSQL architecture
- Understand PostgreSQL shared memory
- Module assessment
2 - Understand client-server communication in PostgreSQL
- Understand connection handling
- Understand the PostgreSQL client tools
- Module assessment
3 - Understand PostgreSQL query processing
- Identify the query processing components
- Understand the EXPLAIN statement
- Module assessment
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 assessment
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 assessment
6 - Understand write-ahead logging
- Describe write ahead logging
- Describe replication and logical decoding
- Module assessment
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 assessment
8 - Understand concurrency in PostgreSQL
- Understand multi-version concurrency control (MVCC) and snapshots
- Describe isolation levels
- Understand locking
- Module assessment
9 - Tune queries in Azure Database for PostgreSQL
- Understand statistics
- Assess query performance with the Query Store
- Module assessment
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
- Module assessment
Before you attend
- Demonstrate an understanding of relational databases.
- Demonstrate an understanding of basic SQL.
How reserving works. Your card is authorized, not charged. We confirm the seat with the training center, usually within one business day, and take payment only once it is held. If the class turns out to be full we release the authorization and you are not charged.
Request a quote
Tell us how many people and roughly when. We'll come back with dates, seat price, and a total by the end of the next business day.