COURSE OBJECTIVE:
Students will learn to, • Explore PostgreSQL architecture • Understand client-server communication in PostgreSQL • Understand PostgreSQL query processing • Secure Azure Database for PostgreSQL • Procedures and functions in PostgreSQL • Understand write-ahead logging • Configure and manage Azure Database for PostgreSQL • Understand concurrency in PostgreSQL • Tune queries in Azure Database for PostgreSQL • Migrate to Azure Database for PostgreSQL flexible server
TARGET AUDIENCE:
Not available. Please contact.
COURSE PREREQUISITES:
• Demonstrate an understanding of relational databases. • Demonstrate an understanding of basic SQL.
COURSE CONTENT:
Explore PostgreSQL architecture • Describe the architecture of PostgreSQL. • Describe the options for creating an Azure Database for PostgreSQL server. • Understand PostgreSQL shared memory.Understand client-server communication in PostgreSQL • Understand connection handling. • Understand the PostgreSQL client tools.Understand PostgreSQL query processing • Identify the query processing components. • Understand EXPLAIN.Secure Azure Database for PostgreSQL • Describe the security features of Azure Database for PostgreSQL. • Create database users and grant permissions. • Understand encryption in Azure Database for PostgreSQL.Procedures and functions in 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.Understand write-ahead logging • Describe write-ahead logging. • Describe replication and logical decoding.Configure and manage Azure Database for PostgreSQL • 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.Understand concurrency in PostgreSQL • 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.Tune queries in Azure Database for PostgreSQL • Describe statistics in Azure Database for PostgreSQL. • Assess query performance with the Query Store.Migrate to Azure Database for PostgreSQL flexible server • Understand the different online and offline migration options. • Identify the different migration tools available. • Select the appropriate migration tool for your specific scenario.
FOLLOW ON COURSES:
Not available. Please contact.