亚洲国产婷婷六月丁香,亚洲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 to a Database
Executing SQL
psql Meta Commands

PGAdmin4
Connecting to a 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