亚洲国产婷婷六月丁香,亚洲av永久中文无码精品 ,亚洲av成人精品一区二区三区,亚洲av无码乱码在线观看富二代,亚洲av乱码一区二区三区香蕉

課程目錄: PostgreSQL Essentials培訓(xùn)
4401 人關(guān)注
(78637/99817)
課程大綱:

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