Home/Courses/Microsoft Data & Power BI/DP-3021 Configure and migrate to Azure Database for PostgreS…
Microsoft Data & Power BIDP-3021 Configure and migrate to Azure Database for PostgreSQL
Configure and migrate to Azure Database for PostgreSQL in one day: understand its architecture, query processing and concurrency, secure, configure and tune it, and migrate to flexible server.
1 dayIntermediate10 modulesDP-3021
About this course
Configure and migrate to Azure Database for PostgreSQL in one day: understand its architecture, query processing and concurrency, secure, configure and tune it, and migrate to flexible server.
Curriculum
10 modules
- Describe Azure Database for PostgreSQL
- Understand PostgreSQL architecture
- Understand PostgreSQL shared memory
- Module assessment
- Understand connection handling
- Understand the PostgreSQL client tools
- Module assessment
- Identify the query processing components
- Understand the EXPLAIN statement
- Module assessment
- 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
- 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
- Describe write ahead logging
- Describe replication and logical decoding
- Module assessment
- 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
- Understand multi-version concurrency control (MVCC) and snapshots
- Describe isolation levels
- Understand locking
- Module assessment
- Understand statistics
- Assess query performance with the Query Store
- Module assessment
- Compare online and offline migrations
- Identify migration tool options
- Analyze the decision criteria for tool selection and migration model
- Module assessment
Who it's for
Database administrators and developers using PostgreSQL.
Before you start
- Demonstrate an understanding of relational databases.
- Demonstrate an understanding of basic SQL.
Related courses
More in Microsoft Data & Power BI →Intermediate
55128 Writing Reports with Report Builder and SSRS Level 2
Microsoft Data & Power BI
View course →Intermediate
55232 Writing Analytical Queries for Business Intelligence
Microsoft Data & Power BI
View course →Foundation
55315 Introduction to SQL Databases
Microsoft Data & Power BI
View course →Intermediate55353
Administering a SQL Database Infrastructure (55353)
Microsoft Data & Power BI
View course →IntermediateDP-300 Exam Prep/DP-300T00
Administering Microsoft Azure SQL Solutions (DP-300 Exam Prep/DP-300T00)
Microsoft Data & Power BI
View course →Foundation
Data Analysis using Power BI Desktop - Level 1: Report Builder
Microsoft Data & Power BI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.