Using GIS and new to SQL? Start here!

🎓 Learn modern GIS with my new courses! ➡️ https://moderngis.xyz ⬅️
🎉 My modern GIS community is open - Spatial Lab ➡️ https://www.spatialstack.ai/ ⬅️
📖 My Spatial SQL book is out now! ➡️ http://spatial-sql.com/ ⬅️

Welcome to 🌍 Learn Spatial SQL! These videos will help you learn spatial SQL to use in your modern GIS workflows. This first series focuses on SQL basics to help you get up to speed with SQL as fast as possible. This video will cover:

For additional resources discussed in the video check out this link: https://forrest.nyc/spatial-sql-basic-query-structure/

40+ Spatial SQL Resources and Guides: https://forrest.nyc/40-spatial-sql-resources-and-guides/

Learn Spatial SQL Guides: https://forrest.nyc/learn-spatial-sql/

TIMESTAMPS

0:00 Intro
1:15 SELECT
2:59 WHERE
4:26 LIMIT/OFFSET
5:20 ORDER BY
6:13 AND/OR
7:19 IN/NOT IN
8:25 BETWEEN
9:13 LIKE
10:39 CASE/WHEN