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
- SQL tutorial from W3 Schools
- Intro to SQL course from Khan Academy
- Learn SQL course from Codecademy
- Introduction to SQL course from DataCamp
- Relational databases and SQL course from Stanford University
- Understanding the basics of SQL and relational databases
PostgreSQL-specific
- postgrestutorial.com
- PostgreSQL tutorial from Tutorials Point
- Awesome Postgres list of curated resources
YouTube courses
- SQL Tutorial from freeCodeCamp.org
- Learn basic SQL in 15 minutes from BI for Beginners
- MySQL tutorial for beginners from Programming with Mosh
Working with SQL in Glide
- Event recap: Building Glide apps on SQL data
- Introduction to Glide data sources
- PostgreSQL data sources in Glide
- MySQL data sources in Glide
- Google Cloud SQL data sources in Glide
- Microsoft SQL Server data sources in Glide
SQL hosting providers
- Neon: Serverless PostgreSQL host
- Planetscale: Fully-managed MySQL
- Google Cloud SQL
- Microsoft Azure SQL
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:
- FROM/JOIN and the ON conditions
- WHERE
- GROUP BY
- HAVING
- SELECT (window functions happen here)
- ORDER BY
- LIMIT