Welcome to ONLC Training Centers

DP-3021: Configure and Migrate to Azure Database for PostgreSQL Course

Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $595

Savings options:

 Learning Credits
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Need a class for a group?

We can deliver this class for your group. Follow the link to request more information.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Train from your home or office

If you have high-speed internet and a computer you can likely take this class from your home or office.


DP-3021: Configure and Migrate to Azure Database for PostgreSQL Course

 

Overview

Dive into the world of PostgreSQL in Azure with our comprehensive 8-hour course. You'll gain essential knowledge of PostgreSQL architecture and learn practical steps for configuring and managing PostgreSQL databases in the Azure environment. From exploring security features to mastering query tuning and migration strategies, this course covers it all.

Through a combination of expert instruction and hands-on labs, you'll develop the skills to manage, configure, and migrate databases effectively. Whether you're looking to enhance your database administration skills or prepare for real-world migration scenarios, this course equips you with the tools and knowledge to excel in PostgreSQL management on Azure.

Who Should Attend

This course is designed for database administrators who want to expand their skills into Azure PostgreSQL management. If you're looking to transition your PostgreSQL databases to Azure or enhance your ability to manage and optimize Azure Database for PostgreSQL, this course is perfect for you.

Prerequisites

Demonstrate an understanding of relational databases and basic SQL. No prior experience with Azure or PostgreSQL is required, but familiarity with database concepts will be beneficial.

Course Outline

Explore PostgreSQL architecture

  • Architecture of PostgreSQL
  • Options for creating an Azure Database for PostgreSQL server
  • PostgreSQL shared memory

Understand client-server communication in PostgreSQL

  • Connection handling
  • PostgreSQL client tools

Understand PostgreSQL query processing

  • Query processing components
  • EXPLAIN statement

Secure Azure Database for PostgreSQL

  • Security features of Azure Database for PostgreSQL
  • Create database users and grant permissions
  • Encryption in Azure Database for PostgreSQL

Procedures and functions in PostgreSQL

  • Create and call stored procedures
  • Create and use functions

Understand write-ahead logging

  • Write-ahead logging concepts
  • Replication and logical decoding

Configure and manage Azure Database for PostgreSQL

  • System catalogs and system views
  • Metadata investigation
  • Vacuum process and configuration

Understand concurrency in PostgreSQL

  • Multi-Version Content Control and snapshots
  • Isolation levels
  • Locking in Azure Database for PostgreSQL

Tune queries in Azure Database for PostgreSQL

  • Statistics in Azure Database for PostgreSQL
  • Query performance assessment with Query Store

Migrate to Azure Database for PostgreSQL flexible server

  • Online and offline migration options
  • Migration tools overview
  • Selecting appropriate migration tools
  • Offline and online PostgreSQL database migration

 

View outline in Word

ADP3C1

Attend hands-on, instructor-led DP-3021: Configure and Migrate to Azure Database for PostgreSQL training classes at ONLC's nationwide locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

GENERAL INFO

Class Format
Class Policies
Student Reviews


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com