Name: DP-3021 Configure and migrate to Azure Database for PostgreSQL
Availability: InStock
Rating: 4.6 (5878 reviews)

Duration:

8.00 hours

6.5 CPD hours

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.

Description:

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

, 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

What You'll Learn:

Course ObjectivesExplore PostgreSQL architectureUnderstand client-server communication in PostgreSQLUnderstand PostgreSQL query processingSecure Azure Database for PostgreSQLProcedures and functions in PostgreSQLUnderstand write-ahead loggingConfigure and manage Azure Database for PostgreSQLUnderstand concurrency in PostgreSQLTune queries in Azure Database for PostgreSQLMigrate to Azure Database for PostgreSQL flexible server, Course ObjectivesExplore PostgreSQL architectureUnderstand client-server communication in PostgreSQLUnderstand PostgreSQL query processingSecure Azure Database for PostgreSQLProcedures and functions in PostgreSQLUnderstand write-ahead loggingConfigure and manage Azure Database for PostgreSQLUnderstand concurrency in PostgreSQLTune queries in Azure Database for PostgreSQLMigrate to Azure Database for PostgreSQL flexible server, Course ObjectivesExplore PostgreSQL architectureUnderstand client-server communication in PostgreSQLUnderstand PostgreSQL query processingSecure Azure Database for PostgreSQLProcedures and functions in PostgreSQLUnderstand write-ahead loggingConfigure and manage Azure Database for PostgreSQLUnderstand concurrency in PostgreSQLTune queries in Azure Database for PostgreSQLMigrate to Azure Database for PostgreSQL flexible server, Course ObjectivesExplore PostgreSQL architectureUnderstand client-server communication in PostgreSQLUnderstand PostgreSQL query processingSecure Azure Database for PostgreSQLProcedures and functions in PostgreSQLUnderstand write-ahead loggingConfigure and manage Azure Database for PostgreSQLUnderstand concurrency in PostgreSQLTune queries in Azure Database for PostgreSQLMigrate to Azure Database for PostgreSQL flexible server, Course ObjectivesExplore PostgreSQL architectureUnderstand client-server communication in PostgreSQLUnderstand PostgreSQL query processingSecure Azure Database for PostgreSQLProcedures and functions in PostgreSQLUnderstand write-ahead loggingConfigure and manage Azure Database for PostgreSQLUnderstand concurrency in PostgreSQLTune queries in Azure Database for PostgreSQLMigrate to Azure Database for PostgreSQL flexible server, Course ObjectivesExplore PostgreSQL architectureUnderstand client-server communication in PostgreSQLUnderstand PostgreSQL query processingSecure Azure Database for PostgreSQLProcedures and functions in PostgreSQLUnderstand write-ahead loggingConfigure and manage Azure Database for PostgreSQLUnderstand concurrency in PostgreSQLTune queries in Azure Database for PostgreSQLMigrate to Azure Database for PostgreSQL flexible server, Course ObjectivesExplore PostgreSQL architectureUnderstand client-server communication in PostgreSQLUnderstand PostgreSQL query processingSecure Azure Database for PostgreSQLProcedures and functions in PostgreSQLUnderstand write-ahead loggingConfigure and manage Azure Database for PostgreSQLUnderstand concurrency in PostgreSQLTune queries in Azure Database for PostgreSQLMigrate to Azure Database for PostgreSQL flexible server, Course ObjectivesExplore PostgreSQL architectureUnderstand client-server communication in PostgreSQLUnderstand PostgreSQL query processingSecure Azure Database for PostgreSQLProcedures and functions in PostgreSQLUnderstand write-ahead loggingConfigure and manage Azure Database for PostgreSQLUnderstand concurrency in PostgreSQLTune queries in Azure Database for PostgreSQLMigrate to Azure Database for PostgreSQL flexible server, Course ObjectivesExplore PostgreSQL architectureUnderstand client-server communication in PostgreSQLUnderstand PostgreSQL query processingSecure Azure Database for PostgreSQLProcedures and functions in PostgreSQLUnderstand write-ahead loggingConfigure and manage Azure Database for PostgreSQLUnderstand concurrency in PostgreSQLTune queries in Azure Database for PostgreSQLMigrate to Azure Database for PostgreSQL flexible server, Course ObjectivesExplore PostgreSQL architectureUnderstand client-server communication in PostgreSQLUnderstand PostgreSQL query processingSecure Azure Database for PostgreSQLProcedures and functions in PostgreSQLUnderstand write-ahead loggingConfigure and manage Azure Database for PostgreSQLUnderstand concurrency in PostgreSQLTune queries in Azure Database for PostgreSQLMigrate to Azure Database for PostgreSQL flexible server

Available Delivery Options for DP-3021 Configure and migrate to Azure Database for PostgreSQL

Live Instructor Led Classroom Online (Live Online)
Traditional Instructor Led Classroom training (TILT/ILT)
Delivery at your offices in United Kingdom
Private dedicated course for your staff

What certification does DP-3021 Configure and migrate to Azure Database for PostgreSQL prepare you for?

The DP-3021 Configure and migrate to Azure Database for PostgreSQL course helps prepare you for the Microsoft Applied Skills: Configure and migrate to Azure Database for PostgreSQL certification path.

Which exam does DP-3021 Configure and migrate to Azure Database for PostgreSQL prepare you for?

The DP-3021 Configure and migrate to Azure Database for PostgreSQL prepares you for the 'DP-3021' official exam. You can take this exam at any exam center across United Kingdom including London, Manchester, Birmingham, Edinburgh or live online wherever you are.

How many CPD hours does DP-3021 Configure and migrate to Azure Database for PostgreSQL provide?

The 1 day DP-3021 Configure and migrate to Azure Database for PostgreSQL course gives you up to 6.5 CPD hours/structured learning hours.

Do you provide training for DP-3021 Configure and migrate to Azure Database for PostgreSQL?

Yes, we provide corporate training, dedicated training and closed classes for DP-3021 Configure and migrate to Azure Database for PostgreSQL. This can take place anywhere in United Kingdom including London, Manchester, Birmingham, Edinburgh or live online.

What is the duration of DP-3021 Configure and migrate to Azure Database for PostgreSQL?

The DP-3021 Configure and migrate to Azure Database for PostgreSQL training takes place over 1 day(s), with each day lasting approximately 8.00 hours including breaks.

What other terms do people search for?

Popular related searches include: DP-3021: Configure and migrate to Azure Database for PostgreSQL, Microsoft, vILT, DP-3021

Why are Nexus Human the best provider for DP-3021 Configure and migrate to Azure Database for PostgreSQL?

Nexus Human are recognised as one of the best training companies. Our trainers have won awards including Small Firms Best Trainer, national training partner of the year for Ireland, and global top 30 instructor awards in 2012, 2019 and 2021.

Is there a discount code for DP-3021 Configure and migrate to Azure Database for PostgreSQL?

Yes, the discount code PENPAL5 is currently available for DP-3021 Configure and migrate to Azure Database for PostgreSQL training. Only one discount code can be used per booking.

DP-3021 Configure and migrate to Azure Database for PostgreSQL