| Jadwal Kegiatan Pelatihan |
| Tanggal posting 30-Mar-24 12:08 wib. dilihat sebanyak 3
kali
|
| Jadwal Kegiatan Pelatihan PostgreSql DBA di Bandung, Jakarta, SUrabaya |
| Rp
-Hubungi Whatsapp-
( 3 Days )
|
|
| Posting oleh : Hery Purnama , Whatsapp. 08122334**** |
|
|
|
| Jadwal Kegiatan Pelatihan , Jawa Barat
|
|
|
| |
|
|
| |
jadwalkegiatan.com
|
| |
|
|
|
| |
|
|
| |
 Detail dan Status Jadwal Kegiatan Sampai Dengan November 2024 |
| Waktu Pelaksanaan |
3 Days |
| Biaya |
Rp
-Hubungi Whatsapp- |
| Keterangan |
Silabus Training PostGreSql DBA di Jakarta, Bandung, Surabaya, Indonesia
Trainer : Mr. Hery Purnama
Day 1: PostgreSQL Basics and Installation
Morning Session: Introduction to PostgreSQL
Overview of Relational Databases
Introduction to PostgreSQL
Features and Advantages of PostgreSQL
Understanding SQL and PostgreSQL’s SQL Compliance
Afternoon Session: Installation and Configuration
Preparing for Installation (System Requirements, Planning)
Installing PostgreSQL on Linux, Windows, and macOS
Configuring PostgreSQL Server
Post-installation Tasks and Best Practices
Day 2: Database Administration Essentials
Morning Session: Managing Databases and Users
Creating and Managing Databases
User Management and Authentication Methods
Granting and Revoking Permissions
Database Roles and Privileges
Afternoon Session: Database Maintenance and Performance Tuning
Understanding Database Objects (Tables, Indexes, Views)
Basic SQL Optimization Techniques
Monitoring and Managing Database Performance
Introduction to Logging and Monitoring Tools
Day 3: Advanced Database Administration
Morning Session: Backup and Recovery
Understanding Backup and Restore Strategies
Performing Database Backups (pg_dump, pg_basebackup)
Point-in-time Recovery (PITR)
Disaster Recovery Planning and Best Practices
Afternoon Session: High Availability and Replication
Introduction to High Availability Concepts
Setting up Streaming Replication
Failover and Switchover Procedures
Overview of other Replication Methods (Logical Replication, Slony)
Note: Each session will include a combination of lectures, demonstrations, and hands-on exercises. Participants are encouraged to bring their laptops for practical sessions. Prior knowledge of SQL and basic database concepts is recommended but not required.
Target Audience: This training is suitable for database administrators, system administrators, and IT professionals who are responsible for managing PostgreSQL databases.
Prerequisites: Familiarity with basic SQL commands and general database concepts is beneficial. Participants should have a working knowledge of Linux/UNIX command-line interface for practical exercises.
Trainer: Qualified trainers with extensive experience in PostgreSQL administration will conduct the sessions. |
| |
|
|
| Kontak Kegiatan |
| Nama Kontak |
Hery Purnama |
| Kontak HP / Whatsapp |
08122334****
|
| Lokasi / Venue Kegiatan |
Jl. Sandang , Sukamulya, Ujung Berung |
| |
Jawa Barat, Bandung |
| |
|
| Peta Lokasi Kontak |
|
 |
Perbesar Peta !
Detail peta sesuai alamat lokasi yang tertera di iklan 'Jadwal Kegiatan Pelatihan PostgreSql DBA di Bandung, Jakarta, SUrabaya ' . Di-generate otomatis oleh google map Api update bulan November 2024 .
Informasi selengkapnya silahkan hubungi langsung pemilik iklan kegiatan |
| |
|
|
| |
|
|
| |
|
|
|
|
|
