Mediaspace scheduled maintenance: Aug 25, 2026 07:00 - 12:00 AM. During this time, videos will be temporarily unavailable. Check status updates.

Lecture

Merging queries, embedded queries

Description

This lecture introduces the principles of merging queries in SQL, including UNION, INTERSECT, and EXCEPT operations, as well as embedded queries within the WHERE clause, demonstrating how to use them in Geographic Information Systems.

In MOOC

Geographical Information Systems 1

Official source

Quiz

Related concepts (32)

Geographic information system

A geographic information system (GIS) consists of integrated computer hardware and software that store, manage, analyze, edit, output, and visualize geographic data. Much of this often happens within a spatial database, however, this is not essential to meet the definition of a GIS. In a broader sense, one may consider such a system also to include human users and support staff, procedures and workflows, the body of knowledge of relevant concepts and methods, and institutional organizations.

SQL

Structured Query Language (SQL) (ˌɛsˌkjuːˈɛl S-Q-L, sometimes ˈsiːkwəl "sequel" for historical reasons) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables. Introduced in the 1970s, SQL offered two main advantages over older read–write APIs such as ISAM or VSAM.

Query optimization

Query optimization is a feature of many relational database management systems and other databases such as NoSQL and graph databases. The query optimizer attempts to determine the most efficient way to execute a given query by considering the possible query plans. Generally, the query optimizer cannot be accessed directly by users: once queries are submitted to the database server, and parsed by the parser, they are then passed to the query optimizer where optimization occurs.

Geographic information science

Geographic information science (GIScience, GISc) or geoinformation science is a scientific discipline at the crossroads of computational science, social science, and natural science that studies geographic information, including how it represents phenomena in the real world, how it represents the way humans understand the world, and how it can be captured, organized, and analyzed. It is a sub-field of geography, specifically part of technical geography.

Microsoft SQL Server

Microsoft SQL Server is a proprietary relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet). Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

Related lectures (33)

SQL Queries and Syntax MOOC: Geographical Information Systems 1

Covers the basics of SQL, including components of the language and syntax of SELECT clause.

Query Fusion, Nested Queries MOOC: Geographical Information Systems 1

Covers query fusion, nested queries, and SQL operators in a geographical context.

Querying a database: the SQL language MOOC: Geographical Information Systems 1

Covers the SQL language for interacting with databases through structured queries, including selecting, filtering, aggregating, and sorting data.

Vector-Vector Interactions

Covers interactions between vector layers in GIS using QGIS tools.

SQL: Data Manipulation and Views MOOC: Geographical Information Systems 1

Covers SQL data manipulation language, including DDL and DML commands.

Related concepts (32)

Geographic information system

SQL

Query optimization

Geographic information science

Microsoft SQL Server