SQL

Table of Contents

Structured Query Language (pronounced either as sequel or “ess-queue-ell,” depending on who you talk to) is used for managing and querying relational database management systems (RDBMS), as well as running analysis. The language will differ slightly depending on the database provider.

SQL preview — Using SQL to create lines running from the centroids of origins and destinations.

How to Spot

SQL is most useful for data engineers, data scientists and data analysts. It has a heavy reliance on “the big 6” commands: SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY.

SQL commands are also always written IN CAPITAL LETTERS. For spatial analysis, you will also often see functions that start with ST... (which stands for Spatial & Temporal) — this includes functions like ST_BUFFER, ST_CENTERMEDIAN and ST_POLYGONIZE.

Table of Contents

SQL

How to Spot

SQL is most useful for data engineers, data scientists and data analysts. It has a heavy reliance on “the big 6” commands: SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY.