SQL, SPARQL, and Markdown

Learn how to take advantage of data.world's powerful SQL query language here.

SQL.png

The SELECT and FROM Clauses

An introduction to the SELECT and FROM clauses and their related keywords

LIMIT

An introduction to the LIMIT clause.

WHERE and comparison operators

An introduction to the WHERE clause and comparison operators.

ORDER BY

An introduction to the ORDER BY clause.

AND, OR, and NOT

An introduction to the keywords ANDOR and NOT.

Arithmetic Operations

An introduction to the arithmetic operators +, -, *\.

IS NULL and IS NOT NULL

An introduction to the expressions IS NULL and IS NOT NULL.

LIKE and NOT LIKE

An introduction to the LIKE and NOT LIKE keywords.

BETWEEN

An introduction to the keyword BETWEEN.

OFFSET

An introduction to the keyword OFFSET.

Joins

An introduction to table joins including the conditions used in them, and their different types.

CAST

An introduction to the expression CAST.

Aggregations

An introduction to aggregations, aggregation functions, and aggregation modifiers.

GROUP BY and FILTER

An introduction to the GROUP BY clause and FILTER modifier.

HAVING

An introduction to the HAVING clause.

CASE

An introduction to the CASE expression.

IN and NOT IN

An introduction to the expressions IN and NOT IN.

Working With Dates

An introduction to working with dates.