SQL Queries and Syntax

Related lectures (32)

Introduces the relational model and relational algebra, focusing on SQL and its operations for effective database management.

Explores methods and tools for integrating vector layers in QGIS, including SQL queries and boolean operators.

Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.

Covers merging and embedded queries in SQL for Geographic Information Systems.

Covers the principles and practice of georeferencing images using various formats and software tools like QGIS.

Covers observation units in GIS, focusing on vector and image modes.

Covers the practical use of QGIS for spatial data analysis and visualization, including georeferencing historical maps and manipulating vector data.

Covers geographic information storage challenges, data types, methods, and formats, emphasizing structured data and centralizing data access.

Covers geometric properties of discrete variables in GIS, including location, size, and shape.

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

Covers the storage of geographic information using vector and grid formats, coordinate reference systems, and image formats.

Covers the origins and types of NoSQL databases, focusing on MongoDB and CRUD operations.

Page 2 of 2