& Construction

Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
& Manufacturing

Professional CAD/CAM tools built on Inventor and AutoCAD
Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
Professional CAD/CAM tools built on Inventor and AutoCAD
Transcript
00:03
Structured Query Language (SQL),
00:06
is a database computer language designed for managing data in relational database management systems,
00:11
and originally based upon relational algebra and calculus.
00:15
Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.
00:24
The SQL language is sub-divided into several language elements, including:
00:29
Clauses, which are constituent components of statements and queries.
00:33
(In some cases, these are optional.)
00:35
Expressions, which can produce either scalar values or tables consisting of columns and rows of data.
00:42
Predicates, which specify conditions that can be evaluated to SQL three-valued logic
00:48
or Boolean true/false/unknown values, and which are used to limit the effects of statements and queries.
00:54
Queries, which retrieve the data based on specific criteria.
00:58
This is the most important element of SQL.
01:01
Statements, which may have a persistent effect on schemata and data,
01:05
or which may control transactions, program flow, connections, sessions, or diagnostics.
01:12
InfoWorks WS Pro implements its own subset of SQL for selecting and updating network objects using specific criteria.
01:21
The SQL tool enables the user to carry out a wide range of data analysis on large quantities of data quickly and efficiently.
01:28
They are both powerful and flexible,
01:30
since there are often multiple ways to get the answer you need.
01:34
The WS Pro SQL dialog allows you to create an SQL query to apply to network objects, the Geoplan window, and simulation results.
01:44
SQLs can also be used in the creation of customized reports.
01:49
A query can be saved and re-run at any time.
01:52
If you are familiar with SQL queries,
01:55
you can type in a query manually or you can use the Field Type and the Field boxes to insert the fields you need.
02:02
Alternatively, you can use the SQL builder, which displays a set of buttons representing the operators that you can include in your query.
Video transcript
00:03
Structured Query Language (SQL),
00:06
is a database computer language designed for managing data in relational database management systems,
00:11
and originally based upon relational algebra and calculus.
00:15
Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.
00:24
The SQL language is sub-divided into several language elements, including:
00:29
Clauses, which are constituent components of statements and queries.
00:33
(In some cases, these are optional.)
00:35
Expressions, which can produce either scalar values or tables consisting of columns and rows of data.
00:42
Predicates, which specify conditions that can be evaluated to SQL three-valued logic
00:48
or Boolean true/false/unknown values, and which are used to limit the effects of statements and queries.
00:54
Queries, which retrieve the data based on specific criteria.
00:58
This is the most important element of SQL.
01:01
Statements, which may have a persistent effect on schemata and data,
01:05
or which may control transactions, program flow, connections, sessions, or diagnostics.
01:12
InfoWorks WS Pro implements its own subset of SQL for selecting and updating network objects using specific criteria.
01:21
The SQL tool enables the user to carry out a wide range of data analysis on large quantities of data quickly and efficiently.
01:28
They are both powerful and flexible,
01:30
since there are often multiple ways to get the answer you need.
01:34
The WS Pro SQL dialog allows you to create an SQL query to apply to network objects, the Geoplan window, and simulation results.
01:44
SQLs can also be used in the creation of customized reports.
01:49
A query can be saved and re-run at any time.
01:52
If you are familiar with SQL queries,
01:55
you can type in a query manually or you can use the Field Type and the Field boxes to insert the fields you need.
02:02
Alternatively, you can use the SQL builder, which displays a set of buttons representing the operators that you can include in your query.
Structured Query Language (SQL) is a database computer language designed for managing data in relational database management systems.
The SQL language is sub-divided into several language elements.
InfoWorks WS Pro implements its own subset of SQL for selecting and updating network objects using specific criteria.
The WS Pro SQL dialog allows you to create SQL queries manually or using the SQL builder.
How to buy
Privacy | Do not sell or share my personal information | Cookie preferences | Report noncompliance | Terms of use | Legal | © 2025 Autodesk Inc. All rights reserved
Sign in to start learning
Sign in for unlimited free access to all learning content.Save your progress
Take assessments
Receive personalized recommendations
May we collect and use your data?
Learn more about the Third Party Services we use and our Privacy Statement.May we collect and use your data to tailor your experience?
Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.