Seminarinhalt
Programm
- Describe Azure Database for PostgreSQL
- Understand PostgreSQL architecture
- Understand PostgreSQL shared memory
- Understand connection handling
- Understand the PostgreSQL client tools
- Identify the query processing components
- Understand the EXPLAIN statement
- 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
- 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
- Describe write ahead logging
- Describe replication and logical decoding
- 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
- Understand multi-version concurrency control (MVCC) and snapshots
- Describe isolation levels
- Understand locking
- Understand statistics
- Assess query performance with the Query Store
- Compare online and offline migrations
- Identify migration tool options
- Analyze the decision criteria for tool selection and migration model
Zielgruppen
Vorkenntnisse
- Kenntnisse im Umgang mit relationalen Datenbanken
- Kenntnisse der grundlegenden SQL-Konzepte