Overview
This
two hour class will expose students to the basics of the computer
data management language, SQL (Structured Query Language), which
has many applications in ArcGIS.
Examples
will come from Microsoft's Access database which is the basis for
the ESRI's Personal Geodatabase format for the current release of
ArcGIS. However, the instructor will point out differences in "flavor"
between different implementations of SQL where appropriate, in particular
highlighting where and how SQL statement syntax is different in
Microsoft SQL Server 2000, the RDBMS platform for King County GIS
Center Enterprise Geodatabases.
This
workshop will not cover SDE topics (for example, table
creation and the altering of table structures).
Audience
Basics
of SQL is for students who are not familiar with SQL, but will be
encountering it in their ArcGIS workflow to access and manipulate
data.
Goals
- Students will
learn how to use SQL to create SELECT queries against a database.
- Students will
learn other common SQL commands, syntax, and usage.
- Students will
learn how the ArcGIS Select By Attributes dialog can be used to
select data from a spatial (or other) data layer.
- Time permitting,
students will be exposed to more advanced topics using the SELECT
statement.
Topics
Covered
- SELECT
queries.
- Common
SQL commands, syntax, and usage.
- Using
SQL queries within the ArcGIS Select By
Attributes dialog.
Prerequisites
and Recommendations
Basic
ArcGIS skills are assumed. |
