Merging queries, embedded queries

About
Privacy
Disclaimer

Graph Chatbot

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.

Vector-Vector Data Layer Interactions MOOC: Geographical Information Systems 2

Covers interactions between vector layers in GIS, including geometric properties, spatial arrangement, autocorrelation, altitude models, and SQL equivalents.

Topological spatial queries MOOC: Geographical Information Systems 1

Covers SQL queries for spatial relations and operators in Geographic Information Systems.

Spatial Geometric Queries MOOC: Geographical Information Systems 1

Covers SQL queries for exploring spatial geometries' characteristics and properties in geographic information systems.

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 Wrangling with Hive: Managing Big Data Efficiently

Covers data wrangling techniques using Apache Hive for efficient big data management.

Wildfires in Sahel: Case Study MOOC: Geographical Information Systems 1

Covers the role of GIS in managing wildfires in the Sahel region.

Thematic attributes and classification MOOC: Geographical Information Systems 2

Covers statistical thematic mapping, types of thematic maps, and discretization methods for representing and classifying dataset characteristics.

Visual Variables MOOC: Geographical Information Systems 2

Introduces visual variables in thematic maps and the semiology of graphics.

Case Study: Pollution of Ebrie Lagoon

Explores GIS through a case study on Ebrie Lagoon pollution and the methodology to assess and address environmental issues.

DDL, DML, Views MOOC: Geographical Information Systems 1

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

Spatial Autocorrelation: An Introduction to GIS MOOC: Geographical Information Systems 2

Covers spatial autocorrelation in GIS, including global autocorrelation, weighting schemes, Moran's I, and contiguity ratio.

Discrete variables: Geometric properties MOOC: Geographical Information Systems 2

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

Conditional queries: An Introduction to GIS MOOC: Geographical Information Systems 1

Covers conditional queries and joins in GIS, explaining operators and attribute selection based on conditions.

Vector-Vector Integration: Methods and Tools MOOC: Geographical Information Systems 2

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

Creating Test Databases MOOC: Geographical Information Systems 1

Covers the creation of test databases for SQL queries using Spatialite and Postgis with QGIS.

Page 1 of 2