Pengetahuan tentang Administrasi database PostgreSQL sangat diperlukan, terutama untuk sseorang 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 di bahas 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.