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

Module outline

• Introducing Structured Query Language in InfoWorks WS Pro
• Building simple SQL queries for selection sets
• Updating data using SQLs
• Analyzing simulation results using SQLs
• Understanding complex SQL queries