PostgreSQL Tutorial for Beginners
freeCodeCamp.org
Alexandru Cristian teaches PostgreSQL queries for beginners, starting with installing PostgreSQL and pgAdmin on Windows. Each SQL statement comes with a challenge, from SELECT and WHERE to GROUP BY and HAVING.
What you'll learn
- Installing PostgreSQL and pgAdmin
- Selecting and filtering data
- Sorting and limiting results
- Pattern matching with LIKE and ILIKE
- Aggregate functions, GROUP BY and HAVING
