SQL

What does SQL stand for?

Structured Query Language

What is SQL used for?

• fast and efficient retrieval

• to query data

• to manipulate data

• to define data

• to control data access

SELECT

Retrieves data from a database table

FROM

Specifies the tables to retrieve data from

WHERE

Filters the data based on a specified condition

LIKE

Filters the data based on a specific pattern

AND

Combines multiple conditions in a WHERE clause

OR

Retrieves data when at least one of the conditions is true

DELETE

Removes one or more rows from a table

INSERT

Inserts new rows to a table

DROP

Deletes an existing table and all of its data

JOIN

Combines rows from two or more tables based on a related column

SELECT *

Select all

A%

All data beginning with A

%A

All data ending in A