SQL Basics

Concept	Description
Tables	Structured data organized into rows and columns
Queries	Retrieve, manipulate, and modify data in tables
Constraints	Rules applied to columns to enforce data integrity

SQL Queries

SELECT	Retrieve data from one or more tables
INSERT	Insert new rows into a table
UPDATEModify existing data in a table

SQL Joins

Join Type	Description
INNER JOIN	Returns records with matching values in both tables
LEFT JOIN	Returns all records from the left table and the matched records from the right table