Resources for learning and working with SQL data

SQL data sources let you build powerful Glide apps on top of your existing databases, like custom GUI frontends that work on any device.

We’re using this post to curate some of the best resources for learning how to work with SQL and use SQL data in Glide. Need SQL help? Tag your posts with sql.

Have resources or advice to share? Reply to the thread and we’ll add it to this post.

Learning SQL

Introductory online courses

PostgreSQL-specific

YouTube courses

Working with SQL in Glide

SQL hosting providers

Helpful tools

Database editors and admin

Other

  • DrawSQL for database schema diagrams

Hot SQL tips

SQL’s order of operations

SQL queries are processed in this order:

  1. FROM/JOIN and the ON conditions
  2. WHERE
  3. GROUP BY
  4. HAVING
  5. SELECT (window functions happen here)
  6. ORDER BY
  7. LIMIT

Reddit threads

9 Likes

Great stuff Andy!

Used to run PostgreSQL a lot in my intern job a few years ago as a Business Intelligence Analyst.

1 Like