Introducing Structured Query Language in InfoWorks WS Pro

Any referenced datasets can be downloaded from "Module downloads" in the module overview.

Video quiz

Which of the following enables the user to carry out a wide range of data analysis on large quantities of data quickly and efficiently?

(Select one)
Select an answer

1/1 questions left unanswered

Structured Query Language (SQL) is a database computer language designed for managing data in relational database management systems.

A presentation slide defining SQL and its scope, which includes data insert, query, update, delete, schema creation, and data access control.

The SQL language is sub-divided into several language elements.

A presentation slide describing SQL language elements, including clauses, expressions, predicates, queries, and statements.

InfoWorks WS Pro implements its own subset of SQL for selecting and updating network objects using specific criteria.

A presentation slide describing SQL implementation in InfoWorks WS Pro as flexible and powerful for performing a wide range of data analysis, with an image of a GeoPlan displaying SQL results.

The WS Pro SQL dialog allows you to create SQL queries manually or using the SQL builder.

A presentation slide describing the use of the WS Pro SQL dialog to create SQL queries manually or using the SQL builder, including an image of the dialog with a completed query.