EasyEnv
PostgreSQL
IntermediateLesson 5 of 1430 min · hands-on

SELECT and WHERE

Part of the PostgreSQL course

You have a table with a few thousand rows in it and you need seven of them. Not all of them, not the first hundred, the seven that match a rule you have in your head: published last month, rated above four, written by someone whose name starts with K. Scrolling is not an answer.

Open the terminal, give this lesson a fresh database of its own, and connect to it as postgres (lesson 02 explains the sudo -u postgres) ...

Want to learn PostgreSQL SELECT and WHERE in a real environment?

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

Start this lessonSELECT and WHERE

What you'll learn

  • SELECT specific columns
  • WHERE with AND OR
  • BETWEEN
  • IN
  • LIKE and ILIKE
  • IS NULL
  • ORDER BY
  • LIMIT and OFFSET

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

SELECT and WHERE - PostgreSQL (English) | Engineering Courses