title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Configure and migrate to Azure Database for PostgreSQL
Duration
1
Course
MOC-DP-3021
Available Formats
Classroom Training, Online Training
Course Description
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.Objectives
After completing this learning path, students will be able to:
- Understand connection handling.
- Understand the PostgreSQL client tools.
- Identify the query processing components.
- Understand EXPLAIN.
- Describe the security features of Azure Database for PostgreSQL.
- Create database users and grant permissions.
- Understand encryption in Azure Database for 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.
- Describe write-ahead logging.
- Describe replication and logical decoding.
- 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.
- 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.
- Describe statistics in Azure Database for PostgreSQL.
- Assess query performance with the Query Store.
- Understand the different online and offline migration options.
- Identify the different migration tools available.
- Select the appropriate migration tool for your specific scenario.
Prerequisites
- Demonstrate an understanding of relational databases.
- Demonstrate an understanding of basic SQL.
Topics
Explore PostgreSQL architecture
- Introduction
- Describe Azure Database for PostgreSQL
- Understand PostgreSQL architecture
- Understand PostgreSQL shared memory
- Exercise – Explore Azure Database for PostgreSQL
- Knowledge check
- Introduction
- Understand connection handling
- Understand the PostgreSQL client tools
- Exercise - Explore PostgreSQL with client tools
- Knowledge check
- Introduction
- Identify the query processing components
- Understand the EXPLAIN statement
- Exercise - Execute the EXPLAIN statement
- Introduction
- 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
- Exercise: Configure permissions in Azure Database for PostgreSQL
- Introduction
- 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
- Exercise - Create a stored procedure in Azure Database for PostgreSQL
- Introduction
- Describe write ahead logging
- Describe replication and logical decoding
- Exercise - List table changes with logical decoding
- Knowledge check
- Introduction
- 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
- Exercise - Configure system parameters and explore metadata with system catalogs and views
- Introduction
- Understand multi-version concurrency control (MVCC) and snapshots
- Describe isolation levels
- Understand locking
- Exercise - Understand locking
- Knowledge check
- Introduction
- Understand statistics
- Assess query performance with the Query Store
- Exercise - Assess query performance using Query Store
- Knowledge check
- Introduction
- Compare online and offline migrations
- Identify migration tool options
- Analyze the decision criteria for tool selection and migration model
- Exercise – Offline PostgreSQL database migration
- Exercise – Online PostgreSQL database migration
- Knowledge check
Related Courses
-
Microsoft Azure Security Technologies
MOC-AZ-500T00- Duration: 4 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,380.00 USD
-
Microsoft Azure Fundamentals (1 Day)
MOC-AZ-900T00- Duration: 1 Day
- Delivery Format: Classroom Training, Online Training
- Price: 595.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.