AI engineering glossary · SQL databases
What is postgreSQL?
PostgreSQL (also called Postgres): A powerful open-source relational database system known for standards compliance, strong transactions and extensibility, including JSON support and extensions. It is widely used in production for web and analytics workloads.
PostgreSQL: an example
A startup runs its orders, users and payments tables on PostgreSQL.
Related terms
More SQL databases terms
- Primary key
- Query optimizer
- RANK and DENSE_RANK
- Recursive CTE
- Referential integrity
- Relational algebra
- Relational database
- Replication
Where you learn it
PostgreSQL is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.