曙海教學(xué)優(yōu)勢
該課程，秉承21年教學(xué)品質(zhì)，以項目實現(xiàn)為導(dǎo)向,面向企事業(yè)單位項目實際需求,講師將會與您分享設(shè)計的全流程以及工具的綜合使用技巧與經(jīng)驗。課程可定制,線下/線上/上門皆可,全國免費報名熱線:4008699035。
曙海培訓(xùn)的課程培養(yǎng)了大批受企業(yè)歡迎的工程師。大批企業(yè)和曙海
建立了良好的合作關(guān)系,合作企業(yè)三十多萬家。曙海的課程得到業(yè)內(nèi)企事業(yè)單位廣泛贊譽。
此培訓(xùn)專為希望從基礎(chǔ)知識中學(xué)習(xí)Postgre?SQL?Database管理員和架構(gòu)師而設(shè)計。
您將學(xué)習(xí)Postgre?SQL體系結(jié)構(gòu)，安裝，設(shè)計以及如何在Postgre?SQL執(zhí)行備份和恢復(fù)數(shù)據(jù)庫。
·?Introduction
·?System Architecture and Internals?
o?Process Architecture
o?Memory Internals
o?Storage Architecture?
?
·?Installations
o?Downloading PostgreSQL?
o?Preparing System for Installation
o?Install PostgreSQL?
o?Create, Start, Stop a Database Server
o?Viewing Information?
?
·?PSQL Tool
o?Connecting to a Database
o?Executing SQL
o?psql Meta Commands
?
·?PGAdmin4
o?Connecting to a Database
o?Basic Tasks using GUI
?
·?Database Designing
o?Database Users
o?Creating and Managing Databases
o?Schemas
o?Tables
o?Data Types
o?Sequences
o?Views
o?Materialized Views
?
·?Database Backups?
o?Logical or SQL Dump Backups
o?Physical Backups - Offline
o?Physical Backups - Online
o?Archiving
?
·?Restoring Backups
o?Restoring SQL Dumps
o?Restoring Offline Backups
o?Point in Time Recovery
o?Partial Restore
?
·?Proactive Maintenance?
o?Database Statistics
o?Data Fragmentation and Vacuuming
o?Data Re-organization
o?Automatic Maintenance Configuration?
o?Re-indexing?
?
·?System Parameters
o?Parameter File
o?Changing Server Parameters
o?Resource Parameters
o?Planner Parameters
o?Logging Parameters
o?Transaction Logging Parameters
