         PostgreSQL 13 for Developers and Administrators培訓

Introduction

PostgreSQL vs MySQL vs Oracle
Overview of PostgreSQL 13 features and architecture
Getting Started

Setting up a database server
Installing PostgreSQL 13
Creating and accessing a database
SQL syntax, commands, and functions
Configuring a Postgres Database

Data definition, default values, and constraints
Setting up and modifying tables
Managing privileges and security policies
Creating database schemas
Implementing table inheritance and partitioning
Adding, updating, and querying data
Data types, functions, and operators
Using indexes and running full-text search
Understanding concurrency control
Managing a Database Server

Upgrading a PostgreSQL cluster
Securing the server and encrypting data
Configuring server parameters
Enabling client authentication
Setting up access roles and permissions
Managing multiple databases
Performing database maintenance tasks
Backing up and restoring data
Optimizing database performance and reliability
Monitoring database activity and disk usage
Implementing logical replication
Running regression tests
Client-Side Programming

Using the libpq C library and large object interface
Executing embedded SQL statements
Exploring the information schema
Other PostgreSQL client applications
Server-Side Programming

Extending the SQL query language
Writing event trigger functions
Implementing rule systems
Using procedural languages (PLs)
Exploring TCL, Perl, and Python PLs
Executing server programming interfaces
Examples of logical decoding
Tracking replication progress
Troubleshooting

Summary and Next Steps