PostgreSQL
PostgreSQL, alternatively known as Postgres, stands as an advanced relational database management system that prioritizes flexibility and SQL compliance. It’s accessible across all major operating systems, encompassing Windows, Linux, macOS, OpenBSD, and FreeBSD. The system adeptly manages diverse workloads, from single computers to data warehouses supporting numerous concurrent users.
PostgreSQL Concepts
- Aggregate Functions
- Array Constructors
- Collations
- Column References
- Comments
- Constants
- Constraints
- Field Selection
- Functions
- Identifier
- Inheritance
- Operators
- Positional Parameters
- Subscripts
- Transactions
- Type Casts
- Window Functions
PostgreSQL contributors
Contribute to Docs
- Learn more about how to get involved.
- Submit feedback to let us know how we can improve Docs.
Learn PostgreSQL on Codecademy
- Learn how to query SQL databases and design relational databases to efficiently store large quantities of data.
- Includes 5 Courses
- With Certificate
- Beginner Friendly.13 hours
- Learn how to setup Jupyter Notebooks and PostGRESQL and run data science projects on your own computer locally!
- Beginner Friendly.1 hour