Ultimate Guide: SQL Tutorial

Click on the SQL tutorial sections below to be taken to a SQL tutorial with an interactive demo of that concept!

SQL SELECT

Retrieves data from a database.

SQL SELECT DISTINCT

SQL SELECT DISTINCT

Retrieves unique data from a database.

SQL WHERE

Filters data based on a condition.

SQL ORDER BY

Sorts the retrieved data.

SQL GROUP BY

Groups rows that have the same values.

SQL HAVING

Filters groups based on a condition.

SQL COUNT

Counts the number of rows.

SQL SUM

Calculates the total sum of a numeric column.

SQL AVG

Calculates the average value of a numeric column.

SQL MIN

Finds the smallest value in a column.

SQL MAX

Finds the largest value in a column.

SQL JOIN

Combines rows from two or more tables.

SQL INNER JOIN

Returns rows when there is at least one match in both tables.

SQL LEFT JOIN

Returns all rows from the left table and matched rows from the right table.

SQL RIGHT JOIN

Returns all rows from the right table and matched rows from the left table.

SQL FULL JOIN

Returns rows when there is a match in one of the tables.

SQL UNION

Combines the result-set of two or more SELECT statements.

SQL CASE

Provides if-then-else logic in SQL.

SQL LIKE

Searches for a specified pattern in a column.

SQL IN

Allows specifying multiple values in a WHERE clause.

SQL BETWEEN

Filters values within a specified range.

SQL ALIAS

Renames a table or a column for the purpose of a query.

SQL LIMIT

Limits the number of rows returned in a query result.

SQL SUBQUERIES

A query nested inside another query.

SQL CORRELATED SUBQUERIES

SQL CORRELATED SUBQUERIES

A subquery that depends on the outer query for its values.

SQL STRING FUNCTIONS

SQL STRING FUNCTIONS

Functions used to manipulate strings.

SQL DATE FUNCTIONS

SQL DATE FUNCTIONS

Functions used to manipulate dates.

SQL CAST and CONVERT

SQL CAST and CONVERT

Converts data from one type to another.

SQL COALESCE

Returns the first non-null value in a list.

SQL NULL Functions

SQL NULL Functions

Functions that handle NULL values.

SQL WINDOW FUNCTIONS

SQL WINDOW FUNCTIONS

Provides aggregate calculations across a set of table rows.

SQL PIVOT and UNPIVOT

SQL PIVOT and UNPIVOT

Rotates table data to and from summary rows to columns.

SQL CTE

Defines a temporary result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement.

Get Started Now

Creating dashboards and reports for your customer has never been easier. Find out how Explo can work for your team.