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

Course 8734

Duration: 1 day
Language: English
Level: Intermediate

Azure Database for PostgreSQL is a robust Platform as a Service (PaaS) offering from Microsoft, built on the open-source PostgreSQL database. This course equips you to explore PostgreSQL architecture, configure and secure your database, optimize performance, and migrate data effectively to Azure Database for PostgreSQL Flexible Server. Learn essential skills like query tuning, concurrency management, and leveraging PostgreSQL's built-in features to enhance your database management experience.

Configure and Migrate to Azure Database for PostgreSQL Delivery Methods

In-Person
Online
Upskill your whole team by bringing Private Team Training to your facility.

Configure and Migrate to Azure Database for PostgreSQL Training Information

In this course, you will:

Gain practical skills to configure and manage Azure Database for PostgreSQL.
Understand PostgreSQL architecture and advanced features like multi-version concurrency control (MVCC).
Learn to optimize query performance and implement security best practices.
Explore hands-on data migration techniques, including online and offline methods.
Master advanced features like write-ahead logging, stored procedures, and tuning tools for efficient database operations.

Prerequisites

Familiarity with relational databases
Basic understanding of SQL

Configure and Migrate to Azure Database for PostgreSQL Training Outline

Learning Objectives

Explore PostgreSQL Architecture

Overview of Azure Database for PostgreSQL.
Understand architecture and shared memory.
Hands-on: Explore PostgreSQL on Azure.

Client-Server Communication

Connection handling and PostgreSQL client tools.
Exercise: Utilize PostgreSQL client tools.

Query Processing

Components of query processing and the EXPLAIN statement.
Exercise: Analyze queries with EXPLAIN.

Secure Azure Database for PostgreSQL

Encryption, authentication, and role-based permissions.
Exercise: Configure database permissions.

Stored Procedures and Functions

Create reusable stored procedures and functions.
Exercise: Implement stored procedures in PostgreSQL.

Write-Ahead Logging

Understand ACID compliance and logical decoding.
Exercise: List table changes using logical decoding.

Configure and Manage PostgreSQL

System catalogs, metadata, and autovacuum configuration.
Exercise: Optimize database configurations.

Concurrency Management

Multi-version concurrency control (MVCC), isolation levels, and locking.
Exercise: Explore locking mechanisms.

Query Tuning

Query performance metrics and the Query Store.
Exercise: Assess and optimize queries.

Migrate to Azure Database for PostgreSQL

Compare online vs. offline migration methods.
Exercises: Perform online and offline migrations.

Get This Course $895 GOV $620

1-Day Instructor-Led Training
Hands-On Training
Microsoft Official Content
After-Course Instructor-Coaching

#8734

Sep 3 9:00 AM - 4:30 PM EDT

AnyWare
Oct 21 9:00 AM - 4:30 PM EDT

AnyWare
Dec 2 9:00 AM - 4:30 PM EST

AnyWare
Jan 30 9:00 AM - 4:30 PM EST

AnyWare
Mar 12 9:00 AM - 4:30 PM EDT

AnyWare

1-Day Instructor-Led Training
Hands-On Training
Microsoft Official Content
After-Course Instructor-Coaching

#8734

Sep 3 9:00 AM - 4:30 PM EDT

AnyWare
Oct 21 9:00 AM - 4:30 PM EDT

AnyWare
Dec 2 9:00 AM - 4:30 PM EST

AnyWare
Jan 30 9:00 AM - 4:30 PM EST

AnyWare
Mar 12 9:00 AM - 4:30 PM EDT

AnyWare

Bring this or any training to your organization
Full-scale program development
Delivered when, where, and how you want it
Blended learning models
Tailored content
Expert team coaching

#8734

Questions about this course?

Inquiring For

Myself

Team/Group

First Name*

Last Name*

Email*

Phone Number*

Company*

Job Title

I'm interested In

* Required Fields

Customize Your Team Training Experience

Fill out the form below or call 888-843-8733

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Configure and Migrate to Azure Database for PostgreSQL FAQs

No. Applied Skills credentials are not replacing Certifications. We are expanding our credentialing portfolio to better meet the needs of our learners and customers by allowing people to validate very specific skill sets with this new offering.

Certifications are role-based and evaluate a broader range of skills needed to be successful in critical roles that organizations need to be successful in today’s rapidly changing technical environment.

Applied Skills credentials are scenario-based and evaluate a narrower skill set specific to a critical business problem or challenge that organizations are facing.

If you want to demonstrate that you have the range of skills needed to succeed in a given job role, a Certification is the right way to go. If you want to validate your skills on a specific business problem or scenario your organization faces, an Applied Skills credential will make more sense.

Here are some key differentiators between Certifications and Applied Skills:

Breadth of skills validated: Certifications typically validate 4-6 skill sets, while Applied Skills validate one specific skill set.
Focus: Certifications are job role-based, while Applied Skills are product-based.
Purpose: Certifications are intended to validate skills needed for the technical aspects of job roles that leverage Microsoft solutions and technologies. Applied Skills are intended to validate specific scenarios that may be hindering an organization’s digital transformation goals.

Many of the Applied Skills credentials can be used to help you prepare for Certification exams. Because Applied Skills are awarded based on performance within a lab, that experience may set you up for success on a Certification. All role-based Certification exams require experience, so earning an Applied Skills credential is one way to get some of the experience needed to pass the exam. However, not all skills assessed on a Certification exam will have an associated Applied Skills assessment lab, so you should not rely on Applied Skills alone. Visit how to prepare for a Certification exam.

If you want to demonstrate that you have skill sets that were not assessed by the Certification, are Certification “adjacent,” or are needed for a specific project that you would like to do or are working on. An Applied Skill credential would be a great way to show your employer and peers that you have those skills and the skills validated by your Certification.

It depends on your technical expertise and why you want to earn a Microsoft credential.

If you are exploring technology or just beginning your learning journey in technology, starting with a fundamentals certification makes the most sense because it focuses on ensuring you have the foundational knowledge you need to get started in technology.

If you have experience and want to explore how Microsoft technologies and solutions are used to solve critical business problems, an Applied Skills credential is a great way to validate fundamental world skills focused on specific projects or scenarios.

If you have some experience and are pursuing a job that leverages Microsoft solutions, a role-based certification is the logical solution to validate role-based skills. Note that some Applied Skills credentials relate to our certifications and may provide another way to prepare for a certification exam.

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

Configure and Migrate to Azure Database for PostgreSQL Delivery Methods

Configure and Migrate to Azure Database for PostgreSQL Training Information

Configure and Migrate to Azure Database for PostgreSQL Training Outline

Learning Objectives

Configure and Migrate to Azure Database for PostgreSQL FAQs

Are Applied Skills credentials replacing role-based Certifications?

How do I choose between a Certification and an Applied Skill credential?

Will attaining an Applied Skills credential help me pass a Certification exam?

I already have a role-based Certification. Should I pursue an Applied Skills credential?

I’m just getting started on my Microsoft credentialing journey. What should I pursue first: an applied skills credential, a fundamentals Certification, or a role-based Certification?

Related Courses