# Resources for learning and working with SQL data **URL:** \ **Category:** Community Resources\ **Tags:** sql\ **Created:** [February 23, 2024, 5:34pm UTC](https://community.glideapps.com/t/resources-for-learning-and-working-with-sql-data/71098 "2024-02-23T17:34:02Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [February 23, 2024, 5:34pm UTC](https://community.glideapps.com/t/resources-for-learning-and-working-with-sql-data/71098/1 "2024-02-23T17:34:02Z")
SQL data sources let you build powerful Glide apps on top of your existing databases, like [custom GUI frontends that work on any device](https://www.glideapps.com/blog/sql-gui-app?utm_source=community). [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/e/6e2cbb2c0724fb28ad45d077cf30a22c13476089.jpeg "Build Apps On Top of SQL Data Sources Without Code | Glide Apps | No Code") ](https://www.youtube.com/watch?v=r1LEjXOXzrY) 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](https://www.w3schools.com/sql/) - [Intro to SQL course from Khan Academy](https://www.khanacademy.org/computing/computer-programming/sql) - [Learn SQL course from Codecademy](https://www.codecademy.com/learn/learn-sql) - [Introduction to SQL course from DataCamp](https://www.datacamp.com/courses/introduction-to-sql) - [Relational databases and SQL course from Stanford University](https://www.edx.org/learn/relational-databases/stanford-university-databases-relational-databases-and-sql) - [Understanding the basics of SQL and relational databases](https://egghead.io/lessons/supabase-understand-the-basics-of-sql-and-relational-databases) ### PostgreSQL-specific - [postgrestutorial.com](https://www.postgresqltutorial.com/) - [PostgreSQL tutorial from Tutorials Point](https://www.tutorialspoint.com/postgresql/index.htm) - [Awesome Postgres list of curated resources](https://github.com/dhamaniasad/awesome-postgres) ### YouTube courses - [SQL Tutorial from freeCodeCamp.org](https://www.youtube.com/watch?v=HXV3zeQKqGY) - [Learn basic SQL in 15 minutes from BI for Beginners](https://www.youtube.com/watch?v=kbKty5ZVKMY) - [MySQL tutorial for beginners from Programming with Mosh](https://www.youtube.com/watch?v=7S_tz1z_5bA) ### ## Working with SQL in Glide - [Event recap: Building Glide apps on SQL data](https://community.glideapps.com/t/recap-building-glide-apps-on-sql-data/67484) - [Introduction to Glide data sources](https://www.glideapps.com/docs/essentials/data-sources) - [PostgreSQL data sources in Glide](https://www.glideapps.com/docs/essentials/data-sources/postgresql) - [MySQL data sources in Glide](https://www.glideapps.com/docs/essentials/data-sources/mysql) - [Google Cloud SQL data sources in Glide](https://www.glideapps.com/docs/essentials/data-sources/google-cloud-sql) - [Microsoft SQL Server data sources in Glide](https://www.glideapps.com/docs/essentials/data-sources/sql-server) ## SQL hosting providers - [Neon: Serverless PostgreSQL host](https://neon.tech/) - [Planetscale: Fully-managed MySQL](https://planetscale.com/) - [Google Cloud SQL](https://cloud.google.com/sql) - [Microsoft Azure SQL](https://azure.microsoft.com/en-ca/products/azure-sql/database) ## Helpful tools **Database editors and admin** - [TablePlus](https://tableplus.com/) - [DbVisualizer](https://www.dbvis.com/) - [RazorSQL](https://razorsql.com/index.html) - [HeidiSQL](https://www.heidisql.com/) - [Postico2](https://eggerapps.at/postico2/) **Other** - [DrawSQL](https://drawsql.app/) 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 - [Beginner tips for learning SQL](https://www.reddit.com/r/SQL/comments/fcn86j/learning_sql_what_are_some_good_beginner_tips/) - [Tips for learning SQL](https://www.reddit.com/r/SQL/comments/16nxn2c/want_to_learn_sql_any_tips/) - [Best ways to learn SQL](https://www.reddit.com/r/SQL/comments/11qe99b/best_way_to_learn_sql/) - [Tips for Beginners Who Struggle at Solving SQL Queries](https://www.reddit.com/r/SQLServer/comments/137ar6g/tips_for_beginners_who_struggle_at_solving_sql/) ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [February 26, 2024, 4:36pm UTC](https://community.glideapps.com/t/resources-for-learning-and-working-with-sql-data/71098/2 "2024-02-26T16:36:59Z")
---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 26, 2024, 11:20pm UTC](https://community.glideapps.com/t/resources-for-learning-and-working-with-sql-data/71098/3 "2024-02-26T23:20:01Z")
Great stuff Andy! Used to run PostgreSQL a lot in my intern job a few years ago as a Business Intelligence Analyst.