Module


22 min.

Structured Query Language in InfoWorks WS Pro


Module overview

For faster data management, WS Pro offers Structured Query Language (SQL) tools for data insert, query, update and delete, schema creation and modification, and data access control.

After completing, you'll be able to:

  • Describe SQLs and how they are applied in WS Pro, then build a simple SQL query to find and select objects.
  • Use SQL queries to build selection sets, update networks, and analyze simulation results.
  • Build complex SQL queries.

Note that you must be running v2024.0 (or newer) of InfoWorks WS Pro in order to use the dataset and follow along with the tutorials.

Module downloads

These downloadable resources will be used to complete units in this module:

Module outline

  • Introducing Structured Query Language in InfoWorks WS Pro