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.

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