logo

Mastering PostgreSQL 12 (DB3171)

Thanks to its reliability, robustness, and high performance, PostgreSQL has become the most advanced open source database on the market. This third edition of Mastering PostgreSQL helps you build dynamic database solutions for enterprise applications using the latest release of PostgreSQL, which enables database analysts to design both physical and technical aspects of system architecture with ease. Starting with an introduction to the newly released features in PostgreSQL 12, this course will help you build efficient and fault-tolerant PostgreSQL applications. You’ll thoroughly examine the advanced features of PostgreSQL, including logical replication, database clusters, performance tuning, monitoring, and user management. You’ll also work with the PostgreSQL optimizer, configure PostgreSQL for high speed, and understand how to move from Oracle to PostgreSQL. As you progress through the chapters, you’ll cover transactions, locking, indexes, and how to optimize queries for improved performance. Additionally, you’ll learn how to manage network security and explore backups and replications while understanding useful PostgreSQL extensions to help you in optimizing the performance of large databases. By the end of this PostgreSQL course, you’ll be able to get the most out of your database by implementing advanced administrative tasks effortlessly.

Pohađajte naše MySQL obuke u Beogradu, putem virtuelne učionice (online, uživo) ili u vašim prostorijama (on-site).

Specijalni popusti se odobravaju prilikom prijave više učesnika koji istovremeno pohađaju obuku iz vaše kompanije, državni i neprofitni sektor, itd.   Kontaktirajte nas da biste saznali više.

Termini obuke

Trajanje obuke: 
4 dana / 28 sati

Privatni trening

On-site / Online
Minimalan broj polaznika: 3
4 dana / 28 sati
Cena na zahtev
srpski ili engleski
Plan obuke: 

Module 1: PostgreSQL 12 Overview

  • What's new in PostgreSQL 12?
  • Summary

Module 2: Understanding Transactions and Locking

  • Working with PostgreSQL transactions
  • Understanding basic locking
  • Making use of FOR SHARE and FOR UPDATE
  • Understanding transaction isolation levels
  • Observing deadlocks and similar issues
  • Utilizing advisory locks
  • Optimizing storage and managing cleanup
  • Summary

Module 3: Making Use of Indexes

  • Understanding simple queries and the cost model
  • Improving speed using clustered tables
  • Understanding additional B-tree features
  • Introducing operator classes
  • Understanding PostgreSQL index types
  • Achieving better answers with fuzzy searching
  • Understanding full-text search
  • Summary

Module 4: Handling Advanced SQL

  • Introducing grouping sets
  • Making use of ordered sets
  • Understanding hypothetical aggregates
  • Utilizing windowing functions and analytics
  • Writing your own aggregates
  • Summary

Module 5: Log Files and System Statistics

  • Gathering runtime statistics
  • Creating log files
  • Summary

Module 6: Optimizing Queries for Good Performance

  • Learning what the optimizer does
  • Understanding execution plans
  • Understanding and fixing joins
  • Enabling and disabling optimizer settings
  • Partitioning data
  • Adjusting parameters for good query performance
  • Making use of parallel queries
  • Introducing JIT compilation
  • Summary

Module 7: Writing Stored Procedures

  • Understanding stored procedure languages
  • Understanding various stored procedure languages
  • Improving functions
  • Using functions for various purposes
  • Summary

Module 8: Managing PostgreSQL Security

  • Managing network security
  • Digging into RLS
  • Inspecting permissions
  • Reassigning objects and dropping users
  • Summary

Module 9: Handling Backup and Recovery

  • Performing simple dumps
  • Handling various formats
  • Replaying backups
  • Handling global data
  • Summary

Module 10: Making Sense of Backups and Replication

  • Understanding the transaction log
  • Transaction log archiving and recovery
  • Setting up asynchronous replication
  • Upgrading to synchronous replication
  • Making use of replication slots
  • Making use of CREATE PUBLICATION and CREATE SUBSCRIPTION
  • Summary

Module 11: Deciding on Useful Extensions

  • Understanding how extensions work
  • Making use of contrib modules
  • Other useful extensions
  • Summary

Module 12: Troubleshooting PostgreSQL

  • Approaching an unknown database
  • Inspecting pg_stat_activity
  • Checking for slow queries
  • Inspecting the log
  • Checking for missing indexes
  • Checking for memory and I/O
  • Understanding noteworthy error scenarios
  • Summary

Module 13: Migrating to PostgreSQL

  • Migrating SQL statements to PostgreSQL
  • Moving from Oracle to PostgreSQL
  • Summary
Benefiti: 
  • Video snimak predavanja u periodu od 180 dana posle kraja obuke

  • Pristup laboratorijama u toku trajanja kursa
  • Materijal u elektronskom obliku

  • Sertifikat o pohađanju kursa

Kontaktirajte nas za više informacija o ceni:

Eccentrix
Office: +381 11 71 38 192
Mobile: +381 65 31 38 195
E-mail: Jelena.Mijanovic@eccentrix.rs

Milutina Milankovića 9đ,
11070 Novi Beograd
www.eccentrix.rs

Eccentrix
Office: +381 11 71 38 192
Mobile: +381 65 31 38 197
E-mail: Boris.Gigovic@eccentrix.rs

Milutina Milankovića 9đ,
11070 Novi Beograd
www.eccentrix.rs