FC-12 - 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