PostgreSQL Database Administrator
PostgreSQL Database Administrator is a course for PostgreSQL database administrators. In this course, we will learn how to install, configure, manage, and optimize PostgreSQL databases.
Objectives
- Understand how to install and configure PostgreSQL Server
- Know how to install and configure PostgreSQL Client
- Know how to manage PostgreSQL databases
- Know how to optimize PostgreSQL databases
- Know how to backup and restore PostgreSQL databases
- Know how to monitor and secure PostgreSQL databases
Target audience
- Database administrators
Lessons
Lesson 1 - Introduction to PostgreSQL Database
PostgreSQL is a powerful and open-source Object-Relational Database Management System (ORDBMS), known for its stability, scalability, and SQL compliance. Initially developed at the University of California, Berkeley, in the 1980s, it has since become one of the most popular open-source databases worldwide.
#database #postgresql #ubuntu #database-administrator
Lesson 2 - PostgreSQL vs. Other Databases
How does PostgreSQL compare with other databases?
#database #postgreSQL #sqlite #mysql #oracle
Lesson 3 - Object Model PostgreSQL
PostgreSQL is an object-relational database management system (ORDBMS). This means it combines features of both relational databases (RDBMS) and object-oriented databases (OODBMS). The object model in PostgreSQL provides features such as user-defined data types, inheritance, and polymorphism, enhancing its capabilities beyond a typical SQL-based RDBMS.
#Database #PostgreSQL #RDBMS Concepts #Object Model #ORDBMS #Object Model PostgreSQL #PostgreSQL DBA
Lesson 4 - PostgreSQL 16 Replication Setup
PostgreSQL has a layer replication feature, allowing data to be copied from one DB to another, creating multiple copies of data. This feature helps distribute data, ensure the latest data, and support replacing the primary server.
#database #replication #ubuntu