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.com/YouTube+Downloads/maven-student-grades-db.zip

👉 Download MySQL: https://dev.mysql.com/downloads/mysql/

👉 Download MySQL Workbench: https://dev.mysql.com/downloads/workbench/

👉 Write SQL code in your browser with SQLite Online: https://sqliteonline.com/

👉 Check out Alice's Advanced SQL Querying course: https://bit.ly/3ZgI0Xa

👉 Full Maven Course Library: https://bit.ly/3XtWLDW

👉 Follow us on LinkedIn:

Alice Zhao: https://www.linkedin.com/in/alicexzhao/
Maven Analytics: https://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 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!

Тэги:

#basic_sql #sql_basics #learn_sql #how_to_use_sql #learn_data_science #data_scientist #sql_beginners #Learn_sql #learn_sql_for_beginners #how_to_learn_sql #sql #mysql #data_science #sql_tutorial_for_beginners #free_sql_course #data_analytics #sql_course #learn_mysql #mysql_course #SQL_clause #sql_tutorial #what_is_cte #data #analytics #maven #analysis #course #education #remote_jobs #data_career #Data_course #data_analyst_job #Data_analyst #sql_for_beginners #mysql_tutorial

Скачать видео