Learn 12 Basic SQL Concepts in 15 Minutes (project files included!)
🎉 Early Black Friday Savings! 🎉 Save $160 on a full year of Maven Pro 👉 https://bit.ly/4C13VCQ 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! 🔗 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/ ⏱️ 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.
Suggested videos

Is this the end for Data Analysts? (my honest take on AI)
Maven Analytics · 8:27

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3
Adam Finer - Learn BI · 17:40

Which Tool Handles a Multi-Level Bill of Materials Best? | Excel vs Power BI vs SQL vs Python
Maven Analytics · 39:58

SQL Explained in 100 Seconds
Fireship · 2:23

dbt for Beginners | What the SQL code actually looks like
Maven Analytics · 5:24

Learn SQL Basics in Just 15 Minutes!
Kenji Explains · 16:57

Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)
Maven Analytics · 19:04

All SQL Fundamentals Explained in 10 Minutes | Learn SQL Basics for Beginners | SQL Crash Course
Learn with Whiteboard · 10:55

Pivoting in SQL | Create a Summary Table with CASE and GROUP BY
Maven Analytics · 4:49

Learn SQL in 5 minutes! (Can you?)
Data36 - Online Data Science Courses · 6:54

Snowflake for SQL Users: Set This Up Before Your First Query
Maven Analytics · 3:20

Learn 12 Advanced SQL Concepts in 20 Minutes (project files included!)
Maven Analytics · 21:50