Learn 12 Basic SQL Concepts in 15 Minutes (project files included!)
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.
🔗 Helpful links:
👉 Download project files: https://maven-datasets.s3.amazonaws.c...
👉 Download MySQL Workbench: MySQL: https://dev.mysql.com/downloads/workb...
👉 Write SQL code in your browser with SQLite Online: https://sqliteonline.com/
👉 Full Maven Course Library: https://bit.ly/3XtWLDW
👉 Follow us on LinkedIn:
Alice Zhao: / alicexzhao
Maven Analytics: / maven-analytics
⏱️ Timestamps:
0:00: Intro
0:47: What is SQL?
0:56: What is a relational database?
2:08: SQL editors
2:23: Demo data
2:37: SELECT & FROM
3:51: WHERE
4:50: ORDER BY
5:38: GROUP BY
7:44: HAVING
9:29: The Big 6
10:50: LIMIT
11:15: COUNT
12:00: DISTINCT
13:05: LEFT JOIN
16:10: Practice problems
16:23: Outro
At Maven Analytics, we empower everyday people with life-changing data & AI skills. Head to http://mavenanalytics.io and master in-demand tools like Excel, SQL, Power BI, Tableau, Python and more. Design your own personalized learning plan and get started for FREE!
