DP-3021MSMicrosoftMS-DP-30211.0<ul> <li>Demonstrate an understanding of relational databases.</li><li>Demonstrate an understanding of basic SQL.</li></ul><h4>Explore PostgreSQL architecture</h4><ul> <li>Introduction</li><li>Describe Azure Database for PostgreSQL</li><li>Understand PostgreSQL architecture</li><li>Understand PostgreSQL shared memory</li><li>Exercise &ndash; Explore Azure Database for PostgreSQL</li><li>Module assessment</li><li>Summary</li></ul> <h4>Understand client-server communication in PostgreSQL</h4><ul> <li>Introduction</li><li>Understand connection handling</li><li>Understand the PostgreSQL client tools</li><li>Exercise - Explore PostgreSQL with client tools</li><li>Module assessment</li><li>Summary</li></ul> <h4>Understand PostgreSQL query processing</h4><ul> <li>Introduction</li><li>Identify the query processing components</li><li>Understand the EXPLAIN statement</li><li>Exercise - Execute the EXPLAIN statement</li><li>Module assessment</li><li>Summary</li></ul> <h4>Secure Azure Database for PostgreSQL</h4><ul> <li>Introduction</li><li>Describe Azure Database for PostgreSQL security</li><li>Describe built-in Azure Database for PostgreSQL server roles</li><li>Grant permissions in Azure SQL Database for PostgreSQL</li><li>Understand encryption in Azure Database for PostgreSQL</li><li>Exercise: Configure permissions in Azure Database for PostgreSQL</li><li>Module assessment</li><li>Summary</li></ul> <h4>Procedures and functions in PostgreSQL</h4><ul> <li>Introduction</li><li>Create a stored procedure in Azure Database for PostgreSQL</li><li>Call a stored procedure in Azure Database for PostgreSQL</li><li>Create and use a function in Azure Database for PostgreSQL</li><li>Exercise - Create a stored procedure in Azure Database for PostgreSQL</li><li>Module assessment</li><li>Summary</li></ul> <h4>Understand write-ahead logging</h4><ul> <li>Introduction</li><li>Describe write ahead logging</li><li>Describe replication and logical decoding</li><li>Exercise - List table changes with logical decoding</li><li>Module assessment</li><li>Summary</li></ul> <h4>Configure and manage Azure Database for PostgreSQL</h4><ul> <li>Introduction</li><li>Understand the system catalogs and system views</li><li>Investigate metadata with system catalogs and system views</li><li>Explain the purpose of vacuum and autovacuum</li><li>Configure autovacuum server parameters</li><li>Exercise - Configure system parameters and explore metadata with system catalogs and views</li><li>Module assessment</li><li>Summary</li></ul> <h4>Understand concurrency in PostgreSQL</h4><ul> <li>Introduction</li><li>Understand multi-version concurrency control (MVCC) and snapshots</li><li>Describe isolation levels</li><li>Understand locking</li><li>Exercise - Understand locking</li><li>Module assessment</li><li>Summary</li></ul> <h4>Tune queries in Azure Database for PostgreSQL</h4><ul> <li>Introduction</li><li>Understand statistics</li><li>Assess query performance with the Query Store</li><li>Exercise - Assess query performance using Query Store</li><li>Module assessment</li><li>Summary</li></ul> <h4>Migrate to Azure Database for PostgreSQL flexible server</h4><ul> <li>Introduction</li><li>Compare online and offline migrations</li><li>Identify migration tool options</li><li>Analyze the decision criteria for tool selection and migration model</li><li>Exercise &ndash; Offline PostgreSQL database migration</li><li>Exercise &ndash; Online PostgreSQL database migration</li><li>Module assessment</li><li>Summary</li></ul>- Demonstrate an understanding of relational databases. - Demonstrate an understanding of basic SQL.Explore PostgreSQL architecture - Introduction - Describe Azure Database for PostgreSQL - Understand PostgreSQL architecture - Understand PostgreSQL shared memory - Exercise – Explore Azure Database for PostgreSQL - Module assessment - Summary Understand client-server communication in PostgreSQL - Introduction - Understand connection handling - Understand the PostgreSQL client tools - Exercise - Explore PostgreSQL with client tools - Module assessment - Summary Understand PostgreSQL query processing - Introduction - Identify the query processing components - Understand the EXPLAIN statement - Exercise - Execute the EXPLAIN statement - Module assessment - Summary Secure Azure Database for PostgreSQL - 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 - Module assessment - Summary Procedures and functions in 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 - Module assessment - Summary Understand write-ahead logging - Introduction - Describe write ahead logging - Describe replication and logical decoding - Exercise - List table changes with logical decoding - Module assessment - Summary Configure and manage Azure Database for PostgreSQL - 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 - Module assessment - Summary Understand concurrency in PostgreSQL - Introduction - Understand multi-version concurrency control (MVCC) and snapshots - Describe isolation levels - Understand locking - Exercise - Understand locking - Module assessment - Summary Tune queries in Azure Database for PostgreSQL - Introduction - Understand statistics - Assess query performance with the Query Store - Exercise - Assess query performance using Query Store - Module assessment - Summary Migrate to Azure Database for PostgreSQL flexible server - 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 - Module assessment - Summary1 jour690.00675.00675.00940.00690.00690.00490.00420.00690.00950.00