Expires in:
4D
4H
40M
24S
SQL is a skill that every data professional should have in the arsenal.
And the best part? ANYONE can start learning SQL in just a matter of minutes – for free!
In this video, we'll cover 12 basic SQL concepts for the complete beginner:
Relational databases
Queries
SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY
LIMIT
COUNT
DISTINCT
LEFT JOIN
…all in less than 15 minutes! We use MySQL Workbench in this tutorial, but the code will run in any SQL editor.
Course Outline
Introduction
0:15
What is SQL?
0:47
What is a relational database?
0:56
SQL editors
2:08
Demo data
2:23
SELECT & FROM
2:37
WHERE
3:51
ORDER BY
4:50
GROUP BY
5:38
HAVING
7:44
The Big 6
9:29
LIMIT
10:50
COUNT
11:15
DISTINCT
12:00
LEFT JOIN + more...
13:05
Alice Zhao
Lead Data Science Instructor
Alice Zhao is a seasoned data scientist and author of the book, SQL Pocket Guide, 4th Edition (O'Reilly). She has taught numerous courses in Python, SQL, and R as a data science instructor at Maven Analytics and Metis, and as a co-founder of Best Fit Analytics.
Recommended
learning:
