First understand SQL. Then discover PostgreSQL.
SQL is a language used to talk to databases. It helps us create, read, update, and delete data.
PostgreSQL is a powerful database system. It understands SQL and uses it to store and manage data.
Imagine you have a school notebook with information about students. You want to find one student's marks. SQL gives you a way to ask the database for that information.
| Student | Age | Mark |
|---|---|---|
| Arun | 14 | 85 |
| Priya | 15 | 92 |
| Ravi | 14 | 78 |
This line simply means: "Show me everything in the students table." SQL turns that plain request into the table you see on the left.
PostgreSQL is a database management system. It stores data and lets applications work with that data — using SQL as the main way to ask questions.
The words you use to ask the librarian a question.
The organised place that actually stores and manages every book.
SQL and PostgreSQL are not the same thing.
SQL tells a database what you want to do.
Software that stores and manages data, and understands SQL commands.
A school has thousands of student records. Let's find students who scored more than 80.
| Name | Mark |
|---|---|
| Arun | 85 |
| Priya | 92 |
Click any row to see a simple explanation.
A language.
Software that manages databases.
Does not store your data by itself.
Stores and manages your data.
Tells the database what you want.
Performs the operations and manages storage.
Used with many different database systems.
One specific system that supports SQL.
You tell the waiter "Give me a pizza." Your words are the instruction. SQL works the same way with a database.
This is an instruction to the database. PostgreSQL receives it and works with the stored data — just like the kitchen receiving your order.
Click a command below and watch PostgreSQL return the result. No real database needed — this uses sample data.
Learn SQL first. Then learn PostgreSQL next. SQL teaches you how to talk to databases. PostgreSQL teaches you how a real, powerful database system works with SQL.
The language used to communicate with databases.
A powerful database system that uses SQL.
SQL is the language. PostgreSQL is the database system.