Lecture

Conditional Queries

Description

This lecture introduces conditional queries in the context of geographic information systems, covering the syntax of conditional queries, understanding how joins work, and the use of WHERE clause for filtering data. The lecture also explains operators like IN, BETWEEN, IS NULL, and LIKE, and how to combine conditions using AND and OR. It delves into different types of joins, such as INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN, to combine information from multiple tables based on common fields.

In MOOCs (2)

Instructor

et nostrud

Culpa tempor ex magna cupidatat est cillum. Nostrud do ad exercitation esse eu. Labore minim cupidatat in cillum mollit laboris sit consectetur ut amet. Non esse magna officia non consectetur eu.

Official source

https://mediaspace.epfl.ch/media/0_ouxuoreu

About this result

This page is automatically generated and may contain information that is not correct, complete, up-to-date, or relevant to your search query. The same applies to every other page on this website. Please make sure to verify the information with EPFL's official sources.

Ontological neighbourhood

Computer engineering

Databases: Relational databases

Economics

Microeconomics: Financial economics

Theoretical computer science

Programming language theory: High-level programming languages

Related lectures (38)

Graph Chatbot

Chat with Graph Search

Ask any question about EPFL courses, lectures, exercises, research, news, etc. or try the example questions below.

DISCLAIMER: The Graph Chatbot is not programmed to provide explicit or categorical answers to your questions. Rather, it transforms your questions into API requests that are distributed across the various IT services officially administered by EPFL. Its purpose is solely to collect and recommend relevant references to content that you can explore to help you answer your questions.