SQL Tutorial for Beginners [Full Course]

Learn SQL with MySQL from scratch! 📚 This beginner-friendly tutorial covers SQL essentials for working with databases.

🚀 Want a complete SQL deep dive?

✋ Want more? Follow me on:

📕 Get the FREE goodies:

📖 TABLE OF CONTENT
0:00:00 Introduction
0:01:02 What is SQL?
0:04:24 Cheat Sheet
0:04:50 Installing MySQL on Mac
0:09:48 Installing MySQL on Windows
0:15:08 Creating the Databases for this Course
0:23:40 The SELECT Statement
0:29:30 The SELECT Clause
0:38:18 The WHERE Clause
0:43:35 The AND, OR, and NOT Operators
0:51:38 The IN Operator
0:54:41 The BETWEEN Operator
0:56:53 The LIKE Operator
1:02:31 The REGEXP Operator
1:11:51 The IS NULL Operator
1:14:18 The ORDER BY Operator
1:21:23 The LIMIT Operator
1:24:50 Inner Joins
1:33:16 Joining Across Databases
1:36:03 Self Joins
1:40:17 Joining Multiple Tables
1:47:03 Compound Join Conditions
1:50:44 Implicit Join Syntax
1:53:04 Outer Joins
1:59:31 Outer Join Between Multiple Tables
2:05:50 Self Outer Joins
2:08:02 The USING Clause
2:13:25 Natural Joins
2:14:46 Cross Joins
2:18:01 Unions
2:26:29 Column Attributes
2:29:54 Inserting a Single Row
2:35:40 Inserting Multiple Rows
2:38:58 Inserting Hierarchical Rows
2:44:51 Creating a Copy of a Table
2:53:38 Updating a Single Row
2:57:33 Updating Multiple Rows
3:00:47 Using Subqueries in Updates
3:06:24 Deleting Rows
3:07:48 Restoring Course Databases

💡 Why Learn SQL?
- It's the standard language for working with databases.
- In-demand skill for developers, data scientists, and more.
- MySQL is popular, open-source, and easy to learn.

👉 This tutorial is perfect for you if:
- You're completely new to SQL.
- You want a practical, hands-on approach.
- You work (or want to work) with data.

#programming #coding

[cashflow]

There are no dummies, there are only bad teachers. After taking many udemy courses trying to master SQL without any progress, I finally understand SQL. You are a great teacher.

[zeheero]

Note to everyone: If the tables is stuck at fetching, just restart the MySQL application and it should fix the infinite queuing.

[dipo]

I first learned SQL from you a couple of years ago, now I hold two jobs utilizing the skills I learned here. Thank you for giving me an amazing career!

[mapa]

I've explored a couple of tutorials, and this course is BY FAR the best one ! Thank you so much for sharing your knowledge ! ... I really appreciate it Mosh !

[yunusemrahulucay]

I saw that someone stuck on downloading the sample database querys. I was stuck on that too and i solved it copying the download link and past it a new section and clicking on enter. If you up this more people can see and solve the problem. Thanks for the course by the way. It was really helpful for me.

[pawenobis]

Mosh, you should be under the United Nations legal protection. You are a world's treasure!

[chamarapanakaduwa]

I was stuck with MySQL server installation and about to give up learning database management. When I first installed it myself, it did not accept any password that I gave. I could not establish any connection and move further as it demanded a password but did not allow me to set one. I reinstalled MySql using your video and it worked. You are a life saver.

[The_Iron_Yuppie]

I'm still not confident with the basics, but this was a good foundation. I really like the way this was delivered. I liked the exercises as well

[snakeyez]

I truly cannot thank you enough for this. Probably the most simple, straightforward, and comprehensive tutorial I've ever seen. Thank you.

[programacao]

Exercises:

-- -- -- The SELECT Statement
36:49 The SELECT Clause
42:25 The WHERE Clause
49:02 The AND, OR, and NOT Operators
53:56 The IN Operator
55:53 The BETWEEN Operator
1:00:29 The LIKE Operator
1:08:21 The REGEXP Operator
1:13:02 The IS NULL Operator
1:19:18 The ORDER BY Operator
1:23:36 The LIMIT Operator
1:30:15 Inner Joins
-- -- -- Joining Across Databases
-- -- -- Self Joins

[QwertyQwerty-niom]

Thank you so much! I have never watched such a clear tutorial, very clear and also friendly! You make MySQL seem easy.

[siphiwehlabano]

Thanks, Mosh for the easy-to-understand, easy-to-follow tutorial. I feel a lot more confident.
I split it into 1hr blocks over 3 consecutive days to make it manageable. I'm looking forward to doing the rest.

[tomc]

Mosh, I passed the MTA 98-364 exam and your course is a huge reason why. Your tutorials are the best tech tutorials I've run across, with clear explanations and good hands on examples. Thanks!

[abuazzan]

TABLE OF CONTENT ( For those on mobile)

0:00:00 Introduction
0:01:02 What is SQL?
0:04:24 Cheat Sheet
0:04:50 Installing MySQL on Mac
0:09:48 Installing MySQL on Windows
0:15:08 Creating the Databases for this Course
0:23:40 The SELECT Statement
0:29:30 The SELECT Clause
0:38:18 The WHERE Clause
0:43:35 The AND, OR, and NOT Operators
0:51:38 The IN Operator
0:54:41 The BETWEEN Operator
0:56:53 The LIKE Operator
1:02:31 The REGEXP Operator
1:11:51 The IS NULL Operator
1:14:18 The ORDER BY Operator
1:21:23 The LIMIT Operator
1:24:50 Inner Joins
1:33:16 Joining Across Databases
1:36:03 Self Joins
1:40:17 Joining Multiple Tables
1:47:03 Compound Join Conditions
1:50:44 Implicit Join Syntax
1:53:04 Outer Joins
1:59:31 Outer Join Between Multiple Tables
2:05:50 Self Outer Joins
2:08:02 The USING Clause
2:13:25 Natural Joins
2:14:46 Cross Joins
2:18:01 Unions
2:26:29 Column Attributes
2:29:54 Inserting a Single Row
2:35:40 Inserting Multiple Rows
2:38:58 Inserting Hierarchical Rows
2:44:51 Creating a Copy of a Table
2:53:38 Updating a Single Row
2:57:33 Updating Multiple Rows
3:00:47 Using Subqueries in Updates
3:06:24 Deleting Rows
3:07:48 Restoring Course Databases

[ezhankhan]

Amazing Tutorial! This has been such a brilliant refresher for me. Not only have I quickly refamiliarized myself with SQL, I feel my my confidence and overall knowledge have both increased too. Thanks Mosh!

[sakthipriya]

After many struggles, the best SQL course which I have gone through . Thanks Mosh ❤

[loriganni]

Mosh you made my day. Stuck at home like everyone else and it was great to hear your voice and see your smiling face on my monitor. Thank you for making my SQL refresher so enjoyable! You are a wonderful teacher.

[sktlmarat]

I understood more in 3 hours from your video than from 16 lectures in university. Thank you sir!

[VeeryBird]

As a teacher I really appreciate the hands-on examples that are given, very well made!

[adnanhashem]

Thanks for this tutorial !

I liked the clear presentation and especially the "end-of-chapter" mini-exercises which makes the presented material stick better with the learner.