Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
コース概要
- 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
要求
There are no specific requirements needed to attend this course. It is recommended to start with this training if you have never taken a formal training of PostgreSQL
14 時間
お客様の声 (5)
リモート デスクトップでも同様に進めることができました。私は試して学ぶのが好きです。
Clare - BCP Council
コース - PostgreSQL Essentials
Machine Translated
知識豊富で簡潔な説明。
Ella - BCP Council
コース - PostgreSQL Essentials
Machine Translated
実践的な演習
Peter - BCP Council
コース - PostgreSQL Essentials
Machine Translated
幅広い情報を網羅しており、Michalは質問などに素晴らしかったです
Dominic Bryant - BCP Council
コース - PostgreSQL Essentials
Machine Translated
Really flexible with topics and amount of work in each area to fit with our knowledge.