Welcome Message - What you need to get started
  • Course Infomercial
Loading Software and Data
  • Installation of software
  • Loading our Data
Overview of SQL
  • Overview of SQL
  • A basic introduction to some SQL with GIS data
SQL Data Types
  • SQL Data Types, Part I: Numeric, Boolean, Text
  • SQL Data Types, Part II: Date and Time, Spatial
Traditional SQL
  • Traditional SQL: SELECT, WHERE, conditional expressions, and GROUP BY
  • More fun with GROUP BY
  • CASE Statements
  • Aggregate Functions (average, standard deviation, count, min, max....)
  • Other SQL Commands (ORDER, LIMIT, OFFSET, BETWEEN)
  • Changing data: DROP, CREATE, INSERT, ALTER, UPDATE
  • Writing SQL Functions
Spatial SQL for Vector Geometry
  • Spatial Operations: coordinate system manipulation
  • Spatial operations: Adjacent, Buffer, Contains, Distance, Intersect, more..
  • Spatial Operations: Topological Overlay (ERASE, INTERSECT, IDENTITY)
Spatial SQL for geographic analysis
  • Spatial Interaction: Distance, Adjacency, and Interaction matrices
  • Geographic Analysis: Nearest Neighbor Index