SQL Notes

Introduction to SQL
SQL stands for Structured Query Language and is used to manage relational databases. SQL
stands for Structured Query Language and is used to manage relational databases. SQL stands for
Structured Query Language and is used to manage relational databases. SQL stands for Structured
Query Language and is used to manage relational databases. SQL stands for Structured Query
Language and is used to manage relational databases. SQL stands for Structured Query Language
and is used to manage relational databases. SQL stands for Structured Query Language and is
used to manage relational databases. SQL stands for Structured Query Language and is used to
manage relational databases. SQL stands for Structured Query Language and is used to manage
relational databases. SQL stands for Structured Query Language and is used to manage relational
databases. SQL stands for Structured Query Language and is used to manage relational
databases. SQL stands for Structured Query Language and is used to manage relational
databases. SQL stands for Structured Query Language and is used to manage relational
databases. SQL stands for Structured Query Language and is used to manage relational
databases. SQL stands for Structured Query Language and is used to manage relational
databases. SQL stands for Structured Query Language and is used to manage relational
databases. SQL stands for Structured Query Language and is used to manage relational
databases. SQL stands for Structured Query Language and is used to manage relational
databases. SQL stands for Structured Query Language and is used to manage relational
databases. SQL stands for Structured Query Language and is used to manage relational
databases.
Database Concepts
Tables, rows, columns, primary keys and foreign keys. Tables, rows, columns, primary keys and
foreign keys. Tables, rows, columns, primary keys and foreign keys. Tables, rows, columns,
primary keys and foreign keys. Tables, rows, columns, primary keys and foreign keys. Tables,
rows, columns, primary keys and foreign keys. Tables, rows, columns, primary keys and foreign
keys. Tables, rows, columns, primary keys and foreign keys. Tables, rows, columns, primary keys
and foreign keys. Tables, rows, columns, primary keys and foreign keys. Tables, rows, columns,
primary keys and foreign keys. Tables, rows, columns, primary keys and foreign keys. Tables,
rows, columns, primary keys and foreign keys. Tables, rows, columns, primary keys and foreign
keys. Tables, rows, columns, primary keys and foreign keys. Tables, rows, columns, primary keys
and foreign keys. Tables, rows, columns, primary keys and foreign keys. Tables, rows, columns,
primary keys and foreign keys. Tables, rows, columns, primary keys and foreign keys. Tables,
rows, columns, primary keys and foreign keys.
SELECT Statement
Used to retrieve data from database tables. Used to retrieve data from database tables. Used to
retrieve data from database tables. Used to retrieve data from database tables. Used to retrieve
data from database tables. Used to retrieve data from database tables. Used to retrieve data from
database tables. Used to retrieve data from database tables. Used to retrieve data from database
tables. Used to retrieve data from database tables. Used to retrieve data from database tables.
Used to retrieve data from database tables. Used to retrieve data from database tables. Used to
retrieve data from database tables. Used to retrieve data from database tables. Used to retrieve
data from database tables. Used to retrieve data from database tables. Used to retrieve data from
database tables. Used to retrieve data from database tables. Used to retrieve data from database
tables.
WHERE Clause
Filters records based on specified conditions. Filters records based on specified conditions. Filters
records based on specified conditions. Filters records based on specified conditions. Filters records
based on specified conditions. Filters records based on specified conditions. Filters records based
on specified conditions. Filters records based on specified conditions. Filters records based on
specified conditions. Filters records based on specified conditions. Filters records based on
specified conditions. Filters records based on specified conditions. Filters records based on
specified conditions. Filters records based on specified conditions. Filters records based on
specified conditions. Filters records based on specified conditions. Filters records based on
specified conditions. Filters records based on specified conditions. Filters records based on
specified conditions. Filters records based on specified conditions.
ORDER BY
Sorts records in ascending or descending order. Sorts records in ascending or descending order.
Sorts records in ascending or descending order. Sorts records in ascending or descending order.
Sorts records in ascending or descending order. Sorts records in ascending or descending order.
Sorts records in ascending or descending order. Sorts records in ascending or descending order.
Sorts records in ascending or descending order. Sorts records in ascending or descending order.
Sorts records in ascending or descending order. Sorts records in ascending or descending order.
Sorts records in ascending or descending order. Sorts records in ascending or descending order.
Sorts records in ascending or descending order. Sorts records in ascending or descending order.
Sorts records in ascending or descending order. Sorts records in ascending or descending order.
Sorts records in ascending or descending order. Sorts records in ascending or descending order.
INSERT Statement
Adds new records into a table. Adds new records into a table. Adds new records into a table. Adds
new records into a table. Adds new records into a table. Adds new records into a table. Adds new
records into a table. Adds new records into a table. Adds new records into a table. Adds new
records into a table. Adds new records into a table. Adds new records into a table. Adds new
records into a table. Adds new records into a table. Adds new records into a table. Adds new
records into a table. Adds new records into a table. Adds new records into a table. Adds new
records into a table. Adds new records into a table.
UPDATE Statement
Modifies existing records in a table. Modifies existing records in a table. Modifies existing records in
a table. Modifies existing records in a table. Modifies existing records in a table. Modifies existing
records in a table. Modifies existing records in a table. Modifies existing records in a table. Modifies
existing records in a table. Modifies existing records in a table. Modifies existing records in a table.
Modifies existing records in a table. Modifies existing records in a table. Modifies existing records in
a table. Modifies existing records in a table. Modifies existing records in a table. Modifies existing
records in a table. Modifies existing records in a table. Modifies existing records in a table. Modifies
existing records in a table.
DELETE Statement
Removes records from a table. Removes records from a table. Removes records from a table.
Removes records from a table. Removes records from a table. Removes records from a table.
Removes records from a table. Removes records from a table. Removes records from a table.
Removes records from a table. Removes records from a table. Removes records from a table.
Removes records from a table. Removes records from a table. Removes records from a table.
Removes records from a table. Removes records from a table. Removes records from a table.
Removes records from a table. Removes records from a table.
JOINS
INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN combine data from tables. INNER JOIN,
LEFT JOIN, RIGHT JOIN and FULL JOIN combine data from tables. INNER JOIN, LEFT JOIN,
RIGHT JOIN and FULL JOIN combine data from tables. INNER JOIN, LEFT JOIN, RIGHT JOIN
and FULL JOIN combine data from tables. INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN
combine data from tables. INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN combine data
from tables. INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN combine data from tables.
INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN combine data from tables. INNER JOIN,
LEFT JOIN, RIGHT JOIN and FULL JOIN combine data from tables. INNER JOIN, LEFT JOIN,
RIGHT JOIN and FULL JOIN combine data from tables. INNER JOIN, LEFT JOIN, RIGHT JOIN
and FULL JOIN combine data from tables. INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN
combine data from tables. INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN combine data
from tables. INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN combine data from tables.
INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN combine data from tables. INNER JOIN,
LEFT JOIN, RIGHT JOIN and FULL JOIN combine data from tables. INNER JOIN, LEFT JOIN,
RIGHT JOIN and FULL JOIN combine data from tables. INNER JOIN, LEFT JOIN, RIGHT JOIN
and FULL JOIN combine data from tables. INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN
combine data from tables. INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN combine data
from tables.
Normalization
Organizes data to reduce redundancy and improve integrity. Organizes data to reduce redundancy
and improve integrity. Organizes data to reduce redundancy and improve integrity. Organizes data
to reduce redundancy and improve integrity. Organizes data to reduce redundancy and improve
integrity. Organizes data to reduce redundancy and improve integrity. Organizes data to reduce
redundancy and improve integrity. Organizes data to reduce redundancy and improve integrity.
Organizes data to reduce redundancy and improve integrity. Organizes data to reduce redundancy
and improve integrity. Organizes data to reduce redundancy and improve integrity. Organizes data
to reduce redundancy and improve integrity. Organizes data to reduce redundancy and improve
integrity. Organizes data to reduce redundancy and improve integrity. Organizes data to reduce
redundancy and improve integrity. Organizes data to reduce redundancy and improve integrity.
Organizes data to reduce redundancy and improve integrity. Organizes data to reduce redundancy
and improve integrity. Organizes data to reduce redundancy and improve integrity. Organizes data
to reduce redundancy and improve integrity.