Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Pengantar PostgreSQL 16
- Ikhtisar PostgreSQL
- Fitur baru di PostgreSQL 16
- Instalasi dan pengaturan
- PostgreSQL arsitektur dan komponen
Memulai dengan PostgreSQL
- PostgreSQL pengaturan cluster basis data
- Membuat dan mengelola database
- Operasi dasar SQL.
- Menyiapkan dan menjelajahi PostgreSQL 16
Teknik Lanjutan SQL.
- Teknik kueri tingkat lanjut
- Ekspresi tabel umum (CTE)
- Fungsi jendela
- Tipe data JSON dan JSONB
- Menulis pertanyaan SQL tingkat lanjut
Tipe Data dan Ekstensi
- Tipe data khusus
- Pencarian teks lengkap
- PostingGIS untuk data geospasial
- Pemrograman PL/halSQL.
- Menggunakan tipe data dan ekstensi tingkat lanjut
Pengindeksan dan Optimasi Kueri
- Jenis dan penggunaan indeks
- Perencanaan dan pelaksanaan kueri
- Menganalisis dan mengoptimalkan kueri
- Pengindeksan dan pengoptimalan kueri
Penyetelan Kinerja
- Parameter penyetelan kinerja
- Manajemen memori dan sumber daya
- Memantau dan menganalisis kinerja
- Penyetelan dan pemantauan kinerja
Cadangan dan pemulihan
- Strategi cadangan
- Pemulihan tepat waktu
- Cadangan logis dan fisik
- Melakukan pencadangan dan pemulihan
Keamanan dan Access Kontrol
- Otentikasi dan otorisasi
- Manajemen peran dan izin
- Enkripsi dan pengaturan SSL/TLS
- Menerapkan praktik terbaik keamanan
Ketersediaan dan Replikasi Tinggi
- Konsep dan tipe replikasi
- Menyiapkan replikasi streaming
- Mengonfigurasi ketersediaan tinggi dengan Patroni
- Menerapkan replikasi dan ketersediaan tinggi
Mengintegrasikan PostgreSQL dengan Aplikasi
- Menghubungkan PostgreSQL dengan berbagai bahasa pemrograman
- Menggunakan PostgreSQL dalam kerangka aplikasi modern
- ORM dan PostgreSQL
- Mengintegrasikan PostgreSQL dengan aplikasi
Ringkasan dan Langkah Selanjutnya
Requirements
- Pengetahuan dasar tentang SQL
- Familiar dengan konsep database
Hadirin
- Database administrator
- Database pengembang
- Administrator sistem
21 Hours
Testimonials (5)
Andres consistently ensures that he addresses all attendee questions and strives to ensure everyone comprehends his teachings. I admire his expertise and proficiency in the subject matter
Ryan - Questronix Corporation
Course - PostgreSQL for Administrators - 3 Days
Ahmed has been very cooperative and knowledgeable about the subject and throughout been a good and productive training session covering some basic and important topics on Postgres.
Imran Sadiq Bhat
Course - PostgreSQL Essentials
It was clearly tailored to be very appropriate to our purpose which made it extra helpful. I really liked the zoom format as it helped me focus with the material right in front of you all the time and the trainer able to add illustrations and markings on to it as he explained. The trainer answered all our questions in a very satisfying way and I felt surprised at how much I was able to learn in one day. Usually i get tired of training by the afternoon but this was very engaging right through to the end. Pace was perfect and detail went into the right areas.
Davina Sanders - Scottish Government
Course - PostgreSQL Performance Tuning
Michal was very knowledgable and engaging as a teacher.
Nate Clifton - NIIT (USA) Inc.
Course - PostgreSQL Advanced DBA
new knowledges that can be apply in our system
