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 WHEREWhat 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- 1What is PostgreSQL20 min
- 2psql and First Commands25 min
- 3Creating Databases and Tables30 min
- 4Data Types25 min
- 5SELECT and WHERE30 min
- 6Joins35 min
- 7Aggregates and Grouping30 min
- 8Indexes35 min
- 9Transactions and Isolation35 min
- 10Functions and Triggers35 min
- 11JSONB and Arrays35 min
- 12EXPLAIN and Query Tuning35 min
- 13Backup and Restore25 min
- 14Capstone: Design a Schema60 min
Explore other courses
Python
19 lessons 路 9.3h
Go
20 lessons 路 12.3h
React
17 lessons 路 10.2h
Linux
17 lessons 路 8.5h
Docker
13 lessons 路 6.6h
Git
13 lessons 路 5.9h
Kubernetes
14 lessons 路 8h
Ansible
12 lessons 路 6.1h
Bash
12 lessons 路 5.7h
Helm
10 lessons 路 5.4h
GitLab CI
11 lessons 路 5.8h
Jenkins
11 lessons 路 5.3h
MySQL
13 lessons 路 6.8h
Web
14 lessons 路 5.9h
TypeScript
18 lessons 路 7.7h
Vibe Coding
12 lessons 路 5.8h
Prompt Engineering
11 lessons 路 6.2h
Vibe Coding: Fundamentals
12 lessons 路 4.5h
Vibe Coding: Prototype to Production
12 lessons 路 5.5h
Vibe Coding: Multi-Agent Engineering
12 lessons 路 5.3h
Vibe Coding: Advanced Engineering
12 lessons 路 7.3h