Learn 12 Basic SQL Concepts in 15 Minutes (project files included!)
3.7 هزار بار بازدید -
2 روز پیش
-
SQL is a skill that
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: maven-datasets.s3.amazonaws.com/YouTube+Downloads/…
👉 Download MySQL Workbench: MySQL: dev.mysql.com/downloads/workbench/
👉 Write SQL code in your browser with SQLite Online: sqliteonline.com/
👉 Full Maven Course Library: bit.ly/3XtWLDW
👉 Follow us on LinkedIn:
Alice Zhao: www.linkedin.com/in/chrisbruehl/
Maven Analytics: www.linkedin.com/company/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 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
2 روز پیش
در تاریخ 1403/07/10 منتشر شده
است.
3,731
بـار بازدید شده