EasyEnv
PostgreSQL
IntermediateLesson 1 of 1420 min · hands-on

What is PostgreSQL

Part of the PostgreSQL course

Imagine you are keeping track of every customer, order, and product for a small shop in a spreadsheet. It works, right up until two people try to edit it at the same time, or the sheet grows past a few hundred thousand rows and every click makes the fans spin, or someone fat-fingers a formula and every total on the page goes wrong at once.

This lesson is pure reading, on purpose. Before you type a single line of SQL in the next lesson, it is worth being clear on what a database actually is, what "relational" means, and the vocabulary (ACID, MVCC) you will hear constantly from here on. There is no code to run yet. Take your time. ...

Want to learn PostgreSQL What is PostgreSQL in a real environment?

Click below, get a fresh Linux box with PostgreSQL ready to go, and work through What is PostgreSQL hands-on with an AI tutor that knows your code.

Start this lessonWhat is PostgreSQL

What you'll learn

  • Relational database
  • ACID
  • MVCC
  • Postgres vs MySQL vs SQLite
  • Where Postgres shines

Read this lesson in your language

All lessons in this course

14 lessons
  1. 1What is PostgreSQL20 min
  2. 2psql and First Commands25 min
  3. 3Creating Databases and Tables30 min
  4. 4Data Types25 min
  5. 5SELECT and WHERE30 min
  6. 6Joins35 min
  7. 7Aggregates and Grouping30 min
  8. 8Indexes35 min
  9. 9Transactions and Isolation35 min
  10. 10Functions and Triggers35 min
  11. 11JSONB and Arrays35 min
  12. 12EXPLAIN and Query Tuning35 min
  13. 13Backup and Restore25 min
  14. 14Capstone: Design a Schema60 min

Explore other courses

What is PostgreSQL - PostgreSQL (English) | Engineering Courses