Skip to main content
DP-3021: Configure and migrate to Azure Database for PostgreSQL
0%
Previous
Course data
Introduction
Audio Book: DP 3021 Introduction
Lesson 1: Configure and migrate to Azure Database for PostgreSQL
Lesson 1: Configure and migrate to Azure Database for PostgreSQL
Audio Lesson 1: Configure and migrate to Azure Database for PostgreSQL
Podcast Lesson 1: Configure and migrate to Azure Database for PostgreSQL
1.1.1 Introduction
1.1.2 Describe Azure Database for PostgreSQL
1.1.3 Understand PostgreSQL architecture
1.1.4 Understand PostgreSQL shared memory
1.1.5 Summary
Activity - Accordion
Activity - Quiz
1.2.1 Introduction
1.2.2 Understand connection handling
1.2.3 Understand the PostgreSQL client tools
1.2.4 Summary
Activity - Short Answer
Activity - Quiz
1.3.1 Introduction
1.3.2 Identify the query processing components
1.3.3 Understand the EXPLAIN statement
1.3.4 Summary
Activity - True/False
Activity - Quiz
1.4.1 Introduction
1.4.2 Describe Azure Database for PostgreSQL security
1.4.3 Describe built-in Azure Database for PostgreSQL server roles
1.4.4 Grant permissions in Azure SQL Database for PostgreSQL
1.4.5 Understand encryption in Azure Database for PostgreSQL
1.4.6 Summary
Activity - Multiple Response
Activity - Quiz
1.5.1 Introduction
1.5.2 Create a stored procedure in Azure Database for PostgreSQL
1.5.3 Call a stored procedure in Azure Database for PostgreSQL
1.5.4 Create and use a function in Azure Database for PostgreSQL
1.5.5 Summary
Activity - Drag and Drop
Activity - Quiz
1.6.1. Introduction
1.6.2 Describe write ahead logging
1.6.3 Describe replication and logical decoding
1.6.4 Summary
Activity - Sequence
Activity - Quiz
1.7.1 Introduction
1.7.2 Understand the system catalogs and system views
1.7.3 Investigate metadata with system catalogs and system views
1.7.4 Explain the purpose of vacuum and autovacuum
1.7.5 Configure autovacuum server parameters
1.7.6 Summary
Activity - Multiple Response
Activity - Quiz
1.8.1 Introduction
1.8.2 Understand multi-version concurrency control (MVCC) and snapshots
1.8.3 Describe isolation levels
1.8.4 Understand locking
1.8.5 Summary
Activity - Popup
Activity - Quiz
1.9.1 Introduction
1.9.2 Understand statistics
1.9.3 Assess query performance with the Query Store
1.9.4 Summary
Activity - Short Answer
Activity - Quiz
1.10.1 Introduction
1.10.2 Compare online and offline migrations
1.10.3 dentify migration tool options
1.10.4 Analyze the decision criteria for tool selection and migration model
1.10.5 Summary
Activity - True/False
Activity - Quiz
Resources
DP 3021: Blueprint
DP 3021: Detailed Curriculum
Next
Side panel
Categories
All categories
AICERTs- Extended E-Learnin...
AICERTs- Extended E-Learnin...
NetCom+
AI CERTs Free Courses
NetCom+ Bengali
Netcom+ Free Courses
Home
Contact Us
Watch Demo
Search
Search
Search
Search
Close
Toggle search input
Log in
Email
Email
Password
Password
Forgot your password?
Log in
Categories
Collapse
Expand
All categories
AICERTs- Extended E-Learnin...
AICERTs- Extended E-Learnin...
NetCom+
AI CERTs Free Courses
NetCom+ Bengali
Netcom+ Free Courses
Home
Contact Us
Watch Demo
Open course index
Course info
DP-3021: Configure and migrate to Azure Database for PostgreSQL
Grade
Certificate
Certificate Download
Certificate Sharing
