Glossary of Definitions

Here, you can find some of the most commonly used clauses in SQL.

A singular row in a database consisting of a set of related data

Asking the query to return all columns of the queried tables

Used when you want to add, delete or modify columns from an existing table

Denotes that you want to add column(s) to an existing table

Denotes that you want delete column(s) from an existing table

Used to designate the table that you want to select data from

Used to insert new records into a table

Denotes a field that has not been assigned a value

Modify data in an existing table

Selects data from a database

Used in conjunction with UPDATE to specify which columns we want to update

Filters our table to return only the data that matches our required constraints