Pengetahuan tentang Administrasi database PostgreSQL sangat diperlukan, terutama untuk seorang Database Administrator (DBA). Dengan pengetahuan Administrasi Database seorang Database Administrator dapat mengelola Database dalam berbagai hal, contohnya antara lain backup data, recovery data, manage memory, manage storage, high availibility dan masih banyak pengetahuan lain yang akan didapat. Selain dapat mengelola database seorang Database Administrator yang memiliki kemampuan Administrasi Database juga dapat mengatasi permasalahan yang terjadi pada server database seperti sql tuning, performance tuning, vacuum dan lain-lain.
i3 menyediakan training yang membahas tentang Postgresql Administration secara lengkap. Berikut adalah detail dari materi yang akan dibahas di kelas Postgresql Administration Complete:
Introduction to Postgresql
– History of PostgreSQL
– Facts of PostgreSQL
– Major Features of PostgreSQL
– General Database Limit
– Database Objects Name
System Architecture
– Architectural Summary
– Process and Memory Architecture
– Utility Processes
– Connection Request-Response
– Disk Read Buffering Disk
– Write Buffering
– Background Writer Cleansing Scan
– Commit and Checkpoint
– Statement Processing
– Physical Database Architecture
– Data Directory Layout
– Installation Directiory Layout
– Page Layout
Installation
– OS User and Permissions
– Installation Options
– Installation of PostgreSQL
– Setting Environmental Variables
Database Cluster
– Database Clusters
– Creating a Database Cluster
– Starting and Stoping the Server
– Connecting to the Server using psql
Configuration
– Setting Server Parameters
– Access Control
– Connection Settings
– Security and Authentication Settings
– Memory Settings
– Query Planner Settings
– WAL Settings
– Log Management
– Background Writer Settings
– Statement Behavior
– Vacuum Cost Settings
– Autovacuum Cost Settings
– Configuration file includes
Creating and Managing Database
– Object Hierarchy
– Creating Databases
– Users
– Access Control
– Creating Schemas
– Schema Search Path
User Tools
– Connecting to a database
– PSQL Command Line Parameters
– Entering PSQL Commands
– PSQL Meta-Commands
– PSQL SET Parameter
-Information Command
– PgAdmin-4
Security
– Authentication and Authorization
– Levels of Security
-pg_hba.conf file
– Object Ownership
– Application Access Parameters
SQL Primer
– Data Types
– Structured Query Language (SQL)
– Tables and Constraints
– Manipulating Data
– Creating Other Database Objects
– Introduction to various SQL Functionalities
Backup and Recovery
– Backup Types
– SQL Dump Backups
– SQL Dump Options
– Handling Large Databases
– Restoring SQL Dumps
– Cluster Dump
– Offline Backups
– Online Directory Backups
– Database Recovery
– Point in Time Recovery (PITR)
Routine Maintenance
– Database Maintenance
– Optimizer Statistics
– Vacuum
– Autovacuum
– Routine Reindexing
– Cluster
Data Dictionary
– The System Catalog Schema
– System Information Tables
– System Information Functions
– System Administration Functions
– System Information Views
Moving Data
– Loading Flat Files
– Import and Export using COPY
– Example of COPY command
– Using COPY FREEZE for performance
Tablespace
– Tablespaces and Data Files
– pg_global and pg_default
– Advantages of Tablespaces
– Creating Tablespaces
– Changing Default Tablespace
– Usage Example
– Altering Tablespaces
– Dropping Tablespaces
Extension
– Introduction of extensions
– Install Extensions
– Module Indexes
Connection Pooling
– Installing PgPool
– Configuring pgpool
– Running pgpool
– Installing pgbouncer
– Configuring pgbouncer
– Running pgbouncer
Table Partitioning
– Implementing Partitioning
– Managing Partitioning
– Partitioning and constraint exclusion
– Alternate partitioning method
WAL Archiving
– Transaction Log
– WAL Archiving
– Configuring WAL Archive
– The Archiver Process
Streaming Replication
– Replication Overview
– Streaming Replication
– Replication using Repmgr
Jika anda ingin mengasah kemampuan anda dalam mengolah PostgreSQL Database, kami PT.Inovasi Informatika Indonesia siap membantu anda untuk Training dan Sertifikasi bersama trainer-trainer kami yang berpengalaman di bidangnya.