PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.
PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.
PostgreSQL possesses robust feature sets including Multi-Version Concurrency Control (MVCC), point in time recovery, granular access controls, tablespaces, asynchronous replication, nested transactions, online/hot backups, a refined query planner/optimizer, and write ahead logging. It supports international character sets, multi-byte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. PostgreSQL is highly scalable both in the quantity of data it can manage and in the number of concurrent users it can accommodate.
The course provides the learner with an extensive knowledge of PostgreSQL Database Administration with real time examples.
Topics covered are:
PostgreSQL Process and Memory Architecture
Installation of PostgreSQL v12 - Windows and Linux
Setup PostgreSQL v12 Environment Variables - Windows and Linux
PostgreSQL Page Layout
Database Directory Layout
PostgreSQL Configuration Files
Cluster in PostgreSQL (Initdb,Start/Stop,Reload/Restart Cluster)
Createdb/Dropdb, Createuser/Dropuser Utility
Create Schema and Schema Search Path
Psql Interface Commands
Pg System Catalogs
Working with PostgreSQL Objects
CRUD Operations
Table Inheritance
Table Partitioning
Tablespace in PostgreSQL
Backup, Continuous Archiving and PITR (Point-in-Time-Recovery)
Explain plan and Query Execution Cost
Maintenance (Updating Planner Statistics, Vacuum, Routine Reindex & Cluster)
Data Fragmentation
Transaction ID wraparound, Vacuum freeze, Auto_Vacuum Demon
Pgadmin 4
Uninstall PostgreSQL v12 on Windows and Linux
Bonus Module
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.