MySQL and R Webinar
Home
Resources
Content
Introduction
Getting Started with PostgreSQL
Writing Queries
Joining Two Tables
Table Structure
Aggregating Results
Creating Tables
dplyr and SQL
Activities
Writing Queries
Joining Two Tables
Table Structure
Aggregating Results
Creating Tables
dplyr and SQL
Data
IMDB
Baseball
Airlines (ETL)
Writing Queries
SELECT...FROM
What table and which columns
AS
column labels
for the result set
WHERE
String Functions
Ranges
Dates
IN
Regular Expressions
ORDER BY
sort the results
LIMIT
LIMIT
: Restrict number of rows returned
OFFSET
: don’t necessarily start at the beginning
Set Operations
Combining Queries