FC-12 - Structured Query Language (SQL) and attribute queries

You are currently viewing an archived version of Topic Structured Query Language (SQL) and attribute queries. If updates or revisions have been published you can find them at Structured Query Language (SQL) and attribute queries.

Author and Citation Info: 

DiBiase, D., DeMers, M., Johnson, A., Kemp, K., Luck, A. T., Plewe, B., and Wentz, E. (2006). Structured Query Language (SQL) and attribute queries. The Geographic Information Science & Technology Body of Knowledge. Washington, DC: Association of American Geographers. (2nd Quarter 2016, first digital).

Learning Objectives: 
  • Define basic terms of query processing (e.g., SQL, primary and foreign keys, table join)
  • Create an SQL query to retrieve elements from a GIS
  • Explain the basic logic of SQL syntax
  • Demonstrate the basic syntactic structure of SQL