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
Perkenalan
- Ikhtisar PostgreSQL fitur dan arsitektur
- Python dasar-dasar pemrograman
- Keuntungan Python PostgreSQL
Mulai
- Menginstal PostgreSQL
- Memasang Python, Django atau Flask
- Menginstal psycopg2
- Menghubungkan ke PostgreSQL dengan Python
Python dan SQL Operasi
- Dasar-dasar SQL bahasa
- Database skema dan tabel
- Menulis kueri Python.
- Membuat tabel
- Memasukkan data
- Memanipulasi data
- Menggunakan klausa batas
- Bergabung dengan tabel
- Pencarian teks lengkap
- Bekerja dengan SQLite
- Contoh Python aplikasi
Lanjutan PostgreSQL dengan Python
- Warisan tabel
- Transaksi bersarang
- Tipe yang ditentukan pengguna
- PANDANGAN, MEMILIKI, BERBEDA
- Bekerja dengan tanggal dan waktu
- Kontrol konkurensi multi-versi (MVCC)
- Bagan, grafik, dan laporan menggunakan matplotlib
Administrasi dan Keamanan
- PostgreSQL keamanan data
- Membatasi akses menggunakan daftar putih
- Menerapkan replikasi
- Database migrasi
- Cadangkan dan pulihkan
- Memantau pertanyaan
- Penyetelan kinerja
- Mencegah SQL serangan injeksi
Penyelesaian masalah
Ringkasan dan Langkah Selanjutnya
Requirements
- Pengalaman dengan PostgreSQL
- Python pengalaman pemrograman
Hadirin
- Pengembang
- Administrator
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
