久久综合色88_欧美激情国产日韩精品一区18_午夜精品一区二区三区在线观看 _自拍日韩亚洲一区在线

PostgreSQL Essentials培訓(xùn)

Introduction

System Architecture and Internals

Process Architecture

Memory Internals

Storage Architecture

Installations

Downloading PostgreSQL

Preparing System for Installation

Install PostgreSQL

Create, Start, Stop a Database Server

Viewing Information

PSQL Tool

Connecting ta Database

Executing SQL

psql Meta Commands

PGAdmin4

Connecting ta Database

Basic Tasks using GUI

Database Designing

Database Users

Creating and Managing Databases

Schemas

Tables

Data Types

Sequences

Views

Materialized Views

Database Backups

Logical or SQL Dump Backups

Physical Backups - Offline

Physical Backups - Online

Archiving

Restoring Backups

Restoring SQL Dumps

Restoring Offline Backups

Point in Time Recovery

Partial Restore

Proactive Maintenance

Database Statistics

Data Fragmentation and Vacuuming

Data Re-organization

Automatic Maintenance Configuration

Re-indexing

System Parameters

Parameter File

Changing Server Parameters

Resource Parameters

Planner Parameters

Logging Parameters

Transaction Logging Parameters