Structured Query Language
Similar to an excel spreadsheet
CREATE TABLE <table name> (
<column name> <data type> [<constraint>],
<column name> <data type> [<constraint>]
);
Can we actually get data
What we are doing
what we are selecting
where we are searching
select * from users
where first_name = 'Bryan'
and age = 29;
select * from users
where favorite_color IS NOT NULL;
select * from users
where age BETWEEN 18 AND 109;
select * from users
limit 50;
select * from users
order by age desc;
select avg(age) as average_user_age from users;
select * from users
where name like '%rya%';