Learn 12 Basic SQL Concepts in 15 Minutes (project files included!)

Save up to 50% off Maven Pro Plans! ➡️ https://bit.ly/4cXXTHo

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.
🎉 UP TO 50% OFF SPRING SAVINGS 🎉

AI is reshaping every industry, and the professionals who will thrive aren’t waiting to figure it out. They’re building real skills right now.

You can, too!

For Spring Savings, you can choose from 3 great offers through May 14th:

👉 Monthly plan: 25% off your first 3 months ($36.75/mo)
👉 Annual plan: 50% off your first year ($199.50/yr)
👉 Lifetime access: 50% off, forever ($849.50)

All Maven Pro memberships include:

✓ Unlimited access to ALL courses & learning paths
✓ Customized learning plans
✓ Guided projects
✓ Skills assessments
✓ Showcase portfolio builder
✓ Free practice data sets
✓ Private student dashboard
✓ Live instructor chat support

Plus something brand NEW, launching soon...👀

Build job-ready AI + data skills, all in one membership.

SAVE NOW 👉 https://bit.ly/4cXXTHo

🔗 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

------

DETAILED SETUP STEPS:

1. Download MySQL: https://dev.mysql.com/downloads/mysql/
Download the installer for your operating system, go through the setup steps and accept the default options. When asked to pick a root password, choose a password that you'll remember because you'll need it for a later step in the installation process.

2. Download MySQL Workbench: https://dev.mysql.com/downloads/workbench/
Download the installer for your operating system, go through the setup steps and accept the default options.

3. Connect MySQL Workbench and MySQL
Open up MySQL Workbench and double click on the icon below the text "MySQL Connections". Enter in the root password you chose in step 1. You are now ready to use MySQL Workbench.

4. Download project files: https://maven-datasets.s3.amazonaws.com/YouTube+Downloads/maven-student-grades-db.zip
Unzip the project files and open up the create_student_grades_db.sql script in MySQL Workbench. Go to the Query drop down, and click Execute All to create the students table. You should now be able to follow along with the demo.

------

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!

Видео Learn 12 Basic SQL Concepts in 15 Minutes (project files included!) канала Maven Analytics