PostgreSQL Performance Tuning Training Course

This instructor-led, live training in Indonesia (online or onsite) is aimed at database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL.

By the end of this training, participants will be able to:

• Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
• Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
• Perform post-migration steps to test, optimize, update, and maintain a migrated database.

This course handles the administration and performance tuning of PostgreSQL databases. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.

This course covers the administration and performance tuning of PostgreSQL databases. 

Target audience includes system administrators and database architects. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.

Pelatihan ini dirancang untuk Database Administrator dan Arsitek yang ingin belajar PostgreSQL dari dasar.

Anda akan mempelajari PostgreSQL arsitektur, instalasi, perancangan serta cara melakukan backup dan pemulihan database di PostgreSQL.

This training is designed for Database Administrators and Architects who want to learn the tools and techniques for implementing Backups, High Availability and Database Security in PostgreSQL.
You will also learn how to find slow queries, monitor database performance and tune PostgreSQL for Performance.

This training is designed for Database Administrators and Architects who want to learn Streaming Replication in PostgreSQL and how pgpool-II can be used to achieve automatic failovers and setup a highly available PostgreSQL Database Cluster.

In this instructor-led, live training in Indonesia (onsite or remote), participants will learn the general and advanced aspects of PostgreSQL, including administration, performance turning, advanced development, and replication as they step through a series of hands-on, live-lab exercises involving setup, configuration, testing, deployment and troubleshooting.

By the end of this training, participants will be able to:

• Use advanced administration techniques to configure and manage a PostgreSQL server.
• Optimize the database and queries for maximum performance.
• Replicate and scale a PostgreSQL server.

This course provides programmatic interaction with PostgreSQL databases. Learn techniques, syntaxes and structures needed to develop quality applications using PostgreSQL backend. This training also covers SQL Tuning covering best practices for writing efficient SQL.

Target audience includes developers who want to use or extend PostgreSQL, as well as database architects.

This instructor-led, live training in Indonesia (online or onsite) is aimed at sysadmins and developers who wish to use PostgreSQL 13 to set up, build, and manage databases for high-performance applications.

By the end of this training, participants will be able to:

• Install and configure PostgreSQL 13.
• Understand the features, architecture, and fundamentals of operating, managing, and maintaining databases with PostgreSQL 13.
• Learn how to configure Postgres database tables and schemas.
• Learn how to perform data manipulations and queries.
• Explore the different programming interfaces (client and server) to fully utilize and extend functionalities in PostgreSQL 13.

Pelatihan langsung yang dipimpin instruktur di Indonesia (online atau di lokasi) ditujukan untuk pengembang dan administrator tingkat menengah yang ingin memanfaatkan fitur dan peningkatan terbaru di PostgreSQL 16.

Pada akhir pelatihan ini, peserta akan mampu:

• Memahami arsitektur dan komponen PostgreSQL 16.
• Memanfaatkan fitur lanjutan SQL dan ekstensi PostgreSQL.
• Menerapkan praktik terbaik keamanan dan kontrol akses.
• Melakukan tugas administrasi basis data, termasuk pencadangan, pemulihan, dan pemantauan.
• Optimalkan kinerja database melalui strategi penyetelan dan pengindeksan.
• Manfaatkan alat bawaan PostgreSQL untuk ketersediaan dan replikasi tinggi.
• Integrasikan PostgreSQL dengan kerangka pengembangan aplikasi modern.

This instructor-led, live training in Indonesia (online or onsite) is aimed at database admins and sysadmins who wish to use PostgreSQL to manage large-scale data while optimizing the database systems for high availability and performance.

By the end of this training, participants will be able to:

• Install and configure PostgreSQL.
• Understand the features and architecture of PostgreSQL.
• Learn how to perform database operations with SQL.
• Perform database backup and recovery to prevent data loss.
• Configure the server for high availability.
• Learn the tools and techniques for high performance tuning.
• Explore the external tools for monitoring and observability.

Pelatihan langsung yang dipimpin instruktur di Indonesia (daring atau tatap muka) ini ditujukan untuk profesional tingkat pemula yang ingin belajar menggunakan PostgreSQL untuk membuat database, menulis kueri SQL, memanipulasi data, dan mengelola tabel dengan perintah SQL dan PGAdmin. Kursus ini juga memberikan pengenalan dasar tentang ekstensi Timescale untuk data time-series.

Setelah selesai pelatihan ini, peserta akan dapat:

• Mengerti prinsip basis data relasional dan arsitektur PostgreSQL.
• Instal, konfigurasikan, dan menjelajahi PostgreSQL serta PGAdmin.
• Menulis dan menjalankan kueri SQL untuk pemilihan data, penyaringan, pengelompokan, dan penggabungan.
• Memanipulasi data dengan pernyataan SQL dan mengelola objek database.
• Membuat dan mengelola view serta mengeksplorasi ekstensi PostgreSQL seperti Timescale.

Pelatihan langsung yang dipimpin instruktur di Indonesia (online atau di lokasi) ditujukan untuk pengembang dan administrator yang ingin menggunakan PostgreSQL dengan Python untuk membangun aplikasi yang aman, andal, dan stabil dalam skala besar.

Pada akhir pelatihan ini, peserta akan mampu:

• Instal, konfigurasikan, dan sambungkan PostgreSQL dengan Python.
• Dapatkan penyegaran tentang Python dasar-dasar pemrograman.
• Pahami manfaat menggunakan PostgreSQL dengan Python.
• Pelajari cara melakukan operasi dasar SQL dengan Python.
• Pelajari cara menggunakan fitur lanjutan PostgreSQL dengan Python.
• Menerapkan teknik keselamatan, keamanan, pemantauan, dan pengoptimalan data.