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

Lecture

SQL Queries and Syntax

Description

This lecture covers the basics of SQL, including components of the language, syntax of SELECT clause, filtering conditions, aggregation, sorting, and merging. It also introduces spatial information systems and tools for querying spatial data.

In MOOC

Geographical Information Systems 1

Official source

Quiz

Related concepts (32)

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.

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.

Spatial database

A spatial database is a general-purpose database (usually a relational database) that has been enhanced to include spatial data that represents objects defined in a geometric space, along with tools for querying and analyzing such data. Most spatial databases allow the representation of simple geometric objects such as points, lines and polygons. Some spatial databases handle more complex structures such as 3D objects, topological coverages, linear networks, and triangulated irregular networks (TINs).

Geographic data and information

Geographic data and information is defined in the ISO/TC 211 series of standards as data and information having an implicit or explicit association with a location relative to Earth (a geographic location or geographic position). It is also called geospatial data and information, georeferenced data and information, as well as geodata and geoinformation. Approximately 90% of government sourced data has a location component. Location information (known by the many names mentioned here) is stored in a geographic information system (GIS).

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 (56)

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.

Bush fires in the Sahelian area MOOC: Geographical Information Systems 1

Explores the causes and consequences of bush fires in the Sahelian area, emphasizing the role of Geographic Information Systems.

Data modeling: Geographic Information Systems MOOC: Geographical Information Systems 1

Introduces data modeling in the context of Geographic Information Systems, covering the added value and methods used.

DDL, DML, Views MOOC: Geographical Information Systems 1

Covers SQL data definition, manipulation, and views in databases.

Geometric spatial queries MOOC: Geographical Information Systems 1

Covers SQL queries for exploring spatial geometries and their properties in a database.

Related concepts (32)

SQL

Geographic information system

Spatial database

Geographic data and information

Microsoft SQL Server