Up Skills Yourself, SpireTec Offers Flat 25% Discount OnĀ AllĀ Courses

logo
set your data here
  • Home
    • /
  • DP-3021: Configure and migrate to Azure Database for PostgreSQL

The DP-3021: Configure and Migrate to Azure Database for PostgreSQL course offers a comprehensive guide to leveraging Azure's robust database solutions. Many people face challenges when migrating databases, such as understanding PostgreSQL architecture and managing secure, efficient migrations to Azure's flexible server. This course will provide practical solutions to these common difficulties.

Instructor

DP-3021: Configure and migrate to Azure Database for PostgreSQL Training

Curriculum

Ratings

( 4.2 Ratings )

Live Online Classes starting on 01 January, 1970

DP-3021: Configure and migrate to Azure Database for PostgreSQL

The DP-3021: Configure and Migrate to Azure Database for PostgreSQL course provides essential training in PostgreSQL architecture and the practical steps for configuring and managing PostgreSQL databases in Azure. Participants will explore security features, query tuning, and migration strategies using online and offline tools. Hands-on labs ensure learners gain practical experience in managing, configuring, and migrating databases. This Azure DP-3021 training prepares professionals to tackle real-world database migration and management scenarios effectively. 

 

Target Audience

  • Database Administrator

 

Prerequisites
Required:

  • Demonstrate an understanding of relational databases.

  • Demonstrate an understanding of basic SQL.

 

Course Objectives

  • 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

 

Course Outline

1) Explore PostgreSQL architecture

  • Describe the architecture of PostgreSQL

  • Describe the options for creating an Azure Database for PostgreSQL server

  • Understand PostgreSQL shared memory

  • Lab: Explore Azure Database for PostgreSQL

2) Understand clientserver communication in PostgreSQL

  • Understand connection handling

  • Understand the PostgreSQL client tools

  • Lab: Explore PostgreSQL with client tools

3) Understand PostgreSQL query processing

  • Identify the query processing components

  • Understand EXPLAIN

  • Lab: Execute the EXPLAIN statement

4) Secure Azure Database for PostgreSQL

  • Describe the security features of Azure Database for PostgreSQL

  • Create database users and grant permissions

  • Understand encryption in Azure Database for PostgreSQL

  • Lab: Configure permissions in Azure Database for PostgreSQL

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 PostrgreSQL

  • Lab: Create a stored procedure in Azure Database for PostgreSQL

6) Understand writeahead logging

  • Describe write-ahead logging

  • Describe replication and logical decoding

  • Lab: List table changes with logical decoding

7) Configure and manage Azure Database for PostgreSQL

  • Describe system catalogs and system views in Azure Database for PostgreSQL

  • Investigate metadata in Azure Database for PostgreSQL

  • Explain the purpose of the vacuum process

  • Configure vacuum server parameters

  • Lab: Configure system parameters and explore metadata with system catalogs and views

8) Understand concurrency in PostgreSQL

  • Describe Multi-Version Content Control and snapshots in Azure Database for PostgreSQL

  • Describe isolation levels in Azure Database for PostgreSQL

  • Describe locking in Azure Database for PostgreSQL

  • Lab: Understand locking

9) Tune queries in Azure Database for PostgreSQL

  • Describe statistics in Azure Database for PostgreSQL

  • Assess query performance with the Query Store

  • Lab: Assess query performance using Query Store

10) Migrate to Azure Database for PostgreSQL flexible server

  • Understand the different online and offline migration options

  • Identify the different migration tools available

  • Select the appropriate migration tool for your specific scenario

  • Lab: Offline PostgreSQL database migration

  • Lab: Online PostgreSQL database migration

(4.2 Ratings)

Download Course Contents

Still unsure?
We're just a click away

Course Outline PDF

SpireTec Unique Features

course-img
1-On-1 Training

Benefit from our 1-On-1 Training for personalized, focused, and effective learning experiences.

course-img
Customized Training

Experience our Customized Training service tailored to meet your specific learning needs and goals

course-img
4 - Hours / Weekend Session

Join our Class featuring 4 - Hours / Weekend Session for in-depth learning and expert training.

course-img
Free Demo Class

Join our Free Demo Class to experience top-notch training and expert guidance first hand!

Purchase This Course

Request More Information

CERTIFICATE

Get Ahead With SpireTec Solutions
Training Certificate

Earn your Certificate

Our course is exhaustive and this certificate is proof that you have taken a big leap in mastering the domain.

Differentiate yourself with Masters Certificate

Our course is exhaustive and this certificate is proof that you have taken a big leap in mastering the domain.

Share your achievement

Our course is exhaustive and this certificate is proof that you have taken a big leap in mastering the domain.

Need Customized Curriculum?

Our course is exhaustive and this certificate is proof that you have taken a big leap in mastering the domain.

Talk To Adviser
course-certificate
Download Course Contents
Live Chat
contact us

CONTACT US

Call us for any query
contact-us
Call +91 - 85273 17055

Available 24x7 for your queries

Top Certifications