MySQL Tutorial for Beginners [Full Course]

Learn MySQL from scratch! 📚 This beginner-friendly tutorial covers SQL essentials for working with databases.
🚀 Want a complete MySQL deep dive?
- Check out my full course: bit.ly/2uAoPM3
- Subscribe for more awesome content: goo.gl/6PYaGF
✋ Want more? Follow me on:
- Twitter: / moshhamedani
- Facebook: / programmingwithmosh
- Instagram: / codewithmosh.official
- LinkedIn: / codewithmosh
📕 Get the FREE goodies:
- SQL cheat sheet: bit.ly/2JCO73l
- Scripts to create databases: bit.ly/3rvtqdO
📖 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

[@programmingwithmosh]

🔥 Want to master MySQL? Get the full MySQL course: bit.ly/2uAoPM3 👍 Subscribe for more SQL tutorials like this: goo.gl/6PYaGF

[@peterkim9263]

Z

[@antoniogomez2931]

@@peterkim9263 lp

[@fantematics]

where do I see the zip file ?

[@conniegriffiths245]

@@fantematics click the show more button on the description above

[@marquiswillis5490]

Aaaa999900

[@cash80flow]

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.

[@pspk70]

True. A good teacher indeed !

[@SIlentZedrikMusic]

Same here sir.

[@akshayswami5898]

Please share Udemy link

[@zekerifatima9692]

I really enjoyed d program 🙏🏻🙏🏻🙏🏻🙏🏻

[@codewitharjun9157]

actually he is just too good

[@zeheero]

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

[@TomasLarrain]

Thank you!

[@javiermeza2557]

was pulling my hairs out. thanks

[@matthewranger1758]

Thank you so much, i thought i did something wrong for a moment!

[@camilagrandas446]

Thank you so much!

[@Thund3rKatZ]

Thank-you

[@dipo7974]

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!

[@lindalolly6318]

Don't you want to teach how to use it, i can get it right

[@GauravSingh-di3dd]

on which platfrom did you learned from him ??

[@victoradeogo8244]

Kindly give a clue of the platform from which you learnt from him to be proficient enough for two jobs

[@MeetPatel-rn7ht]

Do you please mind shadowing how you built your career in SQL?

[@samb23692]

Overemployed?

[@mapa5000]

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 !

[@pawenobis5386]

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

[@nabarupghosh9743]

@@programmingwithmosh you said and its done.... All my friends watch you

[@midhunmp3639]

Exactly......

[@arunrocketz]

True

[@naveenverma2390]

true

[@MuhammadBelloYabo]

Honestly.

[@yunusemrahulucay4953]

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.

[@TranAquarius]

Thank alot

[@gurshansinghbrar8466]

Thanx man

[@evansiaf8110]

You are a BEAST! thanks man

[@othmansuleyman6624]

It worked! Thanks

[@prajnaparamita3008]

Thank you so much !

[@akhilbunnyy]

Thanks Mosh, you're Awesome.I've learned React JS, Node JS, DSA and now MYSQL from you more than what i learned during my graduation.

[@QwertyQwerty-ni5om]

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

[@snakeyez26]

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

[@abuazzan462]

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

[@diegogamboa3773]

copied

[@fracasgaming4837]

What a shole 😂😂

[@user-hy6dd6en9l]

what could anyone be learning this on mobile lmao

[@Sebastian7659]

@@user-hy6dd6en9l I am currently sitting at the airport with a delayed flight and thought this would be good to just watch and review, and scribble notes in my notebook for later. Just because it doesn't make sense to you doesn't mean it's not practical for someone else.

[@Mr3sfor]

@@user-hy6dd6en9l me cz if u use ur friend's computer u will understand the pain

[@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

[@tomc8888]

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!

[@programacao3024]

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

[@mxdtv4911]

can you send me the script to create database in this video

[@user-cv5mb8jn6d]

1:43:50 Joining Multiple Tables 1:58:02 Outer Joins 2:02:50 Outer Join Between Multiple Tables 2:11:51 The USING Clause 2:16:56 Cross Joins 2:23:40 Unions 2:37:20 Inserting Multiple Rows 2:48:46 Creating a Copy of a Table 2:59:58 Updating Multiple Rows 3:04:48 Using Subqueries in Updates

[@RohanShirke-ic8bd]

@@mxdtv4911 link is in the description.

[@user-xf3ru9wm6e]

1:30:15 why did he just use JOIN and not use INNER JOIN ?

[@theworldstoriez1806]

​@@user-xf3ru9wm6e inner join and join both are same . Either of them can be used but both works the same

[@siphiwehlabano3272]

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.

[@sakthipriya8653]

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

[@leahpalimeri4330]

Hi Mosh, I needed to brush up on SQL for a job interview, this was so helpful, and I got the job. Thank you so much!

[@powpowouchy5]

congrats...what were the questions like?

[@collinwalker7543]

aesome! do you remember some of the questions the interviewer asked?

[@priderintegratedfarmsltd.9875]

congrats dear

[@leahpalimeri4330]

​@@powpowouchy5 sorry for late response, few select and one join question.

[@leahpalimeri4330]

@@collinwalker7543 sorry for late response, few select and one join question.

[@iglasgow]

I have taken a few courses online and this is by far the most helpful guide to learning SQl I have seen so far. Thank you so much for posting this tutorial free.

[@ezhankhan1035]

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!

[@adnanhashem98]

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.

[@gautamnarayan3113]

Probably the best crash courses I’ve ever taken. The pace and material is just so easy to understand. Thank you so much Mosh!

[@Aswinimamilla]

Where is the material

[@bayaansanni1216]

Looking for the material too

[@harishubwanali126]

I learnt HTML AND PYTHON now MySQL all of them with Lecture Mosh but people out there thinks I went to University Thanks a lot Sir🙏

[@nadiaou5287]

Excellent

[@najmoosman1723]

How long did it take u?

[@brahimbelmouhand9888]

I also learnt Javascript,C#,Java and CSS.... I am now learning SQL, PHP sucked so I stopped right away

[@chanduvamsi1841]

@@brahimbelmouhand9888 yeah PHP is a little annoying tbh.

[@GroteGlon]

@@brahimbelmouhand9888 php is just ass to work with

[@riyadhossain1706]

It's very helpful for those who are getting started with SQL. Thank you so much for such an awesome crash course.

[@theoneprince777]

I love this thank you I’m currently into html css and JavaScript I’m trying to learn as much as I can in a year to see which way I’m going to go in life so far I love coding is awesome that you can see an outcome….

[@SirTurtle]

I just did an exam and 24 hours ago I didn't know anything about it. Today I woke up and learned EVERYTHING I needed for the exam in this video. Thank you is not enough, you literally made me pass the year. I love you

[@loriganni8251]

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.

[@aali6749]

Someone provide me the cheat sheet

[@skatebrothers06]

woohoo! I got the practice question right at 1:24:00! some of these I can't get right, but it's exciting when I get your exercises right. great study guide thanks mosh!

[@rogyn8484]

Wonderful! I was watching in the past many different online Tutorials but way how you present the things and how you are going step by step making sure that all is understandable is just amazing. You deserved all subscribers that you have!

[@hig1234geu]

hey where is the zip file ?

[@shayansiddiqui3806]

@@hig1234geu in the description

[@deepquest]

Dear Mosh, I am beginner to MYSQL and I have watched many videos on KZbin for beginners. But, none of them have explained concepts very well. But after completing your videos, I can say you the best among all videos of MySQL on KZbin because you know from where to start and how to teach. Thank you. I wish to learn more on MySQL but I have no money to purchase your course.

[@hamaamcabdalaaxmed7345]

The feeling when you finish all of this in just 4 days is unbelievable. Thank you mosh for stepping out your comfort zone and giving us free valuable lectures that'd may be cost us a lot of money if we were to take from other courses online.

[@johnedwards5147]

edx has some free classes online to this regard.

[@shabink7363]

please give me link to scripts used to create databases for this course.....Please

[@zachzobair3875]

@@shabink7363 If you copy + paste the link into a new tab, it should work -- don't click on the link!

[@minimoe2008]

@@zachzobair3875 Zach, what link sir? I can't find anything that directs you to the zip file. That or the link is broke now. Would you share it?

[@zachzobair3875]

@@minimoe2008 In the description of this video, under where it says "📔Scripts to create the databases in this course:" there's a bitly link. Don't click on the link, but just copy + paste it into a new tab and then it should start the download for you

[@user-ue9ls8eb4r]

This tutorial is the best! It's so useful, and the exercises help retain all the knowledge. Thank you so much!

[@valeriomusumeci1388]

Mosh please, just take my money and keep doing what you are doing! The clearance, the recap ability, the schemes, everything youu make complex stuff understandable , and i m soooo lazy about even leaving comments on youtube. Your website will be my new library, you deserve to be paid for this u put effort and truly understand the point of view of who's learning. Well, nothing else to add,. Oh yes one thing actually, make something about php please ahaha cheers!

[@vincentsicca]

Thanks Mosh! Your channel has quickly accelerated my career towards a position of Data Scientist. Currently employed with a major global employer as a Data Analyst and interviewing next week for a Data Scientist position. Thank you for all that you do!

[@RiRi-ku6xz]

Is this enough sql for entery level data analyts?

[@ss877S]

hello sir , I am a beginner at data scientist but I am not able to get a job please guide me what are the most important skills we need to learn for a good job/internship. please help

[@Ethan_here230]

Knowledge of sql, database management systems, big data should suffice​@@ss877S

[@chandanns9877]

​@@ss877Seven me can u share the infro?

[@temursoliev5802]

The tutorials are truly simple to understand and taught in a very beginner-friendly way. Thank you, Mosh! I love your channel!

[@user-romana1980]

Урарззз€

[@leemarkchavez9673]

Amazing Tutorial! I think you've helped me a lot for my SQL exam! Thank you, Mosh!!!

[@levito.27]

Hey Mosh, i wanna thank you for your effort in these videos, i'm working full time while doing also a full time study software developer in my free time, i have to teach myself with books i got from the school, but as a beginner it seemed so difficult and impossible to do. i'm watching your videos beside my books and it all becomes a lot easier, i even decided to buy your courses, i hope to graduate in 2 years and finally work at a job that i really like, thank you again for the help :)

[@ApartmentAbuDhabi]

can you guide me to abt sql, i really need the guidiance, I will be highly in debt of you

[@martinkamau4437]

Hey man where is the link 😢

[@AWholeLottaLola]

_I was struggling with SQL _*_immensely_*_ until I came across this video, as the other tutorials I had used were confusing or not very useful. Even though some things are different for me because I'm on Windows & not Mac instead, you've still been very helpful and I'm grateful for that so thanks so much!_

[@FukaErY]

Hi, this is truly a fantastic lecture, I had sql classes like 15 years ago during my bachelor studies ;-) forgot everything and now recovered everything! This a super high quality course and a great video. I highly recommend it. Many-many great thank-you-s Mosh it is very informative and extremely well explained, and you have a pleasant voice :-) a nice english easy to unterstand for non natives. Just for info: for those who had issues installing mysql on windows, I had to install first visual studio this was a manual installation required by the wizard. I installed even python, even though Mosh said this is not useful. After several attempts, and considerable time loss, I just installed both at the same time to go faster. After these two installations, it worked perfectly. Certainly, visual studio was the one blocking it all. Best, t

[@abdallahalkhassaky9506]

@@slimanemesbah7003 I would like to :)

[@mohabedr5030]

fuck you

[@sudheer596]

Hey, But I am still not able to get it even after installation of Visual Studio. MySql installer is unable to verify/check my Visual Studio installation. Can you guide me.

[@litbro8180]

Mosh is great. I knew SQL already but haven’t used it in a while and needed a brush up. This was perfect on 1.5x speed.

[@jdchaconm.250]

Easy to understand and follow, very dynamic and I agree with y'all, Mosh is a great teacher!

[@sktlmarat]

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

[@KB-pk5ze]

Same

[@arshamazami159]

University don't teach you all

[@theHoneyBee474]

I agree!

[@tomaszyarlett8681]

Uni is useless. Lecturers & tutors literally teach nothing and expect students to understand everything. Then they justify their incompetence & laziness by referring to the so-called "research-based" learning style. Students are in fact paying for the bachelor certificate, not education.

[@frankp6790]

University is a money gran scheme, it's just for the "prestige", just to go outside and say "hey, I graduated from X university", that's all

[@antho_pic]

Hello Mosh, Even as a non-native English speaker, I was able to understand everything and master it. The video was well thought-out. I'm so thankful for you help. Thank you Mosh.

[@VeeryBird]

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

[@BosAli-yh8df]

9:09 10 10

[@BosAli-yh8df]

So we all go out too 3 so much 3

[@BosAli-yh8df]

To 26 we all so it to see you all We you too baby love you slos so I don't know 3

[@murators4732]

even three years later your lecture doesnt get old... that is amazing in the tech industry :D Thank you. At least I understood it.

[@AnkJyotishAaman]

Tons of love from India!! I can recommend this course to anyone who is starting from scratch worth watching God Bless You!!

[@shreyashgorai9616]

Best tutorial I've seen so far. I was going through many tutorials in youtube until I came across this one. I am getting hands on experience along with understanding the theory. Probably the most simplistic video on SQL I have seen so far. The way you explain, it just easily get into the brain without giving unnecessary extra focus. Keep up the good work Mosh.

[@AMAR-pc6ht]

DONE with the course.. Thanks alot MOSH uncle!

[@Anthony_Garcia_]

You're such a legend Mosh. I'm learning this for my college courses and you're way better than any of their material. Thanks man

[@martinkamau4437]

Help me to get the link please

[@pjguitar15]

From how you teach and how this video tutorial is designed, I can say you are a very organized person.

[@Shrishtayyyy]

Crisp concise and to the point perfect explanation! It was Very helpful, Thank you :)

[@irithel]

Hi Mosh, thank you for this course. I have always enjoyed the course and the content you create. Would there be any PHP (and Laravel Framework) course?

[@ktsfi7804]

Thank you Mosh. It is a GREAT HELP!

[@hawaiijim]

40:50 FYI, using for *not equals* adheres to the SQL standard. MySQL's support for != is programmer-friendly, but may not work when using other relational database management systems.

[@raingodes]

Hey Mosh! If you are reading this…. HIGH FIVE!! I’ve just purchased the full sql course, and the course itself along with how you advertise and charge for it, is a SUPER PRODUCT! I recommend it to everyone! Thanks a lot for what you do and how you do it!!

[@kseke25]

This is such a great course. Better than where I’m currently studying right now. I’m glad I’ve found this!

[@Cahangir]

You know exactly what a newbie needs, great teaching. Thanks a lot!

[@renjing]

I have been working at an educational institution for years. And I can tell that Mosh is born to be a teacher.

[@adnanmustafa73]

That's a demeaning thing to say about someone

[@sayamqazi]

@@adnanmustafa73 how is that demeaning, acknowledging that someone is really really talented at teaching.

[@daodaostar]

Half an hour of listening, now i fall in love with the coding, thank you Mosh, thank you very much, you are such a great teacher🙌🏼🙌🏼🙌🏼

[@user-wb6nh6cb2n]

This is amazing. I studied MySql back in 2015 when i was doing my Bachelors, my current job is asking my to write mysql queries and this course was the right one to remind me of everything forgotten. Thank you so much Mosh! You are a great guy! Thanks a lot.

[@68ahil]

What's ur salary per month? Is it enough?

[@genereuseturabawe1767]

It took me like 4 days to complete the whole course. This was a very rewarding experience. I was always looking forward to learning the next topic, very convient for beginners.

[@atrikashow8118]

how many hours have you put in that course every day?

[@chennupalliharish7126]

where is the zipfile link

[@AS-tc]

FYI for the beginners taking going through this tutorial, wrt schemas - it's good to be in the habbit of always specifying a schema before the table itself, so that later down the line (for longer and multiple queries) you don't get confused as to what is what (in some cases aliasing isn't enough to aleviate confusion)

[@thevoiceofhope3694]

Being Specific is time wise and quick performance better clarity!

[@aali6749]

Someone provide me the cheat sheet

[@karan200590]

databases are downloaded but only product table is showing after running and refreshing. all other tables are absent. what to do?///

[@rubiehaya2705]

@@karan200590 same problem. Were you able to fix it?

[@karan200590]

@@rubiehaya2705 yes...load the databases separately...

[@dreamwork69]

I wanna say thanks to your tutorials that I found my baby steps to both Python and MySQL studying. Really much appreciated!

[@ApartmentAbuDhabi]

can you guide me to abt sql, i really need the guidiance, I will be highly in debt of you

[@faizansaeed9126]

@@ApartmentAbuDhabi what sort of Guidance you are seeking?

[@user-my7vr7pq9d]

Every second in this video is valued! so useful! easily understand, that I can finish almost half of the top 50 SQL interview questions just after watching this video even though I have zero experience with databases before!

[@patienceokereke3061]

This is lovely… thank you Mosh. Just checked the files again. I just got the zip file. Thank you again.

[@erimun]

Just yesterday I installed SQL server ready to learn SQL. Didn't know you were to post this video.Thanks a lot Mosh... I always like your tutorials...This will be very helpful.

[@nomadicfathersons]

There is a huge chance you want make project with mysql & java. But there is no exact tutorial that you are finding. For java developer. kzbin.info/www/bejne/ipakfJhrl7qEfsk -installation process of mysql kzbin.info/www/bejne/sKuuZHire7ZogJo - connection with mysql workbench kzbin.info/www/bejne/gqive52QltSnm80 kzbin.info/www/bejne/h3aoe6mBdraUh6M kzbin.info/www/bejne/l6WcZZWQas15idU

[@akhilreddykomma2965]

@@nomadicfathersons How to import databases. And also I didn't get databases that are given by mosh sir even after refreshing. please help me to solve the problem.

[@akshayak373]

where is the zip file attached for this databse?? can anyone please help me?

[@ambersmith4186]

Hello dear

[@sijoalexv]

I have gone through this course from the beginning to end. It was a wonderful tutorial and now I could write basic sequel queries with confident. I was having very less knowledge about and was not confident in writing queries before. Thank you Mosh and keep up the good work!

[@somasripavankumar9132]

Are you able to download cheet sheet?

[@arjunbhardwaj2883]

3:05:50 We are also getting customer_id = 3 (first_name = 'freddi') because we added 50 more points as the customer was born before 1985 (see previous exercise 3:00:00)

[@mauryarajput386]

At 26:26 - on windows, you can use the shortcut Ctrl+Shift+Enter to execute your query without going every time for the flash button inside the top row of the query box.

[@bsmaheshkumar5328]

After watching all your tutorials on different languages, I'd like to declare you as one of the top KZbinr in respect with teaching Oops concept. Hats off you sir. You are just exceptional.

[@AjitKumar-in4vn]

can you help me for installing mysql, my server part was not working. I'm from Mumbai , can call me...9586210188

[@sahilshintre4123]

I recommended your video to another person today so I had to come back to your video 2 years after I first saw it. I watched your video, learned SQL in 2 days, cracked my job interview with highest marks and it's been 2 years since I'm working there. This video took me from a rookie to a Senior Data Analyst. Thank you!

[@akshayak373]

where is the zip file attached for this databse?? can anyone please help me?

[@sahilshintre4123]

@@akshayak373 is it in the description?

[@rajatverma1688]

3:07:54 you need to put client_id instead of * in the select subquery to delete record form invoices table.

[@glakionmendoza8068]

Wow! I really love that you have made exercises at the end of each tutorial, super helpful.

[@rogerbloise2258]

This guy was born to teach! Congratulations, Mosh!

[@pistachio7585]

I initially took Accountancy for College but couldn't finish school for reasons. But a relative of mine offered me a job but I had to learn about computer stuff and told me I could begin with SQL. I'm an old soul and am no tech geek but you teach so well, I actually started having fun learning this!!! You're like a guardian angel to me thank you so much Mosh!!!!!

[@bryce3851]

Wow similar story but I dropped out and went to my cousin to learn to become data analyst this is exactly where he had me start I mean he told me to start learning sql from w3schools but to get use to data .. lol

[@ibrahimmohamoudbile3424]

Just completed and this is my first ever sql ‘anything related’ course 😅 I hope I continue and this becomes my field 🤞

[@sa7ak]

I just purchased it ( SQL) thanks man, you are great! greetins from Greece!!

[@DuaneDibbley59]

Liking the look of this video so far, hopefully it’ll help with my degree course.

[@anon5992]

Both School and university made me hate SQL, and i learned nothing after going to several classes and spend years in those place. now i love SQL and i learned everything i needed and even further than what they could teach. Mosh you're hero, thank you for sharing this for free

[@Don6641]

I had that same experience, very glad that I came across that amazing tutorial

[@AbdelwahabShandy]

From Egypt, I thank you where you are. I searched a lot for a channel like this. I was looking for this content, and I only found it here. Thank you. Thank you very much for this wonderful effort.

[@shannon4166]

Surprisingly I can follow it very well and quite understand this basic. Although I need around 3 days to complete this 3 hours videos because I make my own note for myself (and that's take a lot of time since I need to understand how it's work while make a note) and this is worth it. I just need finish few more course. Thank you so much for this video, it's help me to learn basic SQL!

[@user-ou2vo9iq4k]

If the ZIP file is not downloading for you, try to copy paste the address into your address bar. Hope this helps.

[@KuldeepAdhe]

Thanks bro.. I was struggling from last 15min...

[@cgrtemelkuran7933]

Thanks man!

[@ahmadshafi4778]

I downloaded it but it showed mysql installer web community ...

[@ahmadshafi4778]

Can you help me with that pleasee 🥺

[@Kokodew]

@@ahmadshafi4778 just copy the address and paste in search bar

[@littleone498]

The course is AMAZING ! One thing I really wish was demonstrated however, is the full creation of the databases. I know there was a sheet sheet provided but I am really interested in the why each command was written. I would have loved to see you manually create each database and explaining what you are typing as you are writing the script. You have an amazing way of explaining things and thus far this has been the best video i have watched

[@johnedwards5147]

I was wondering the same thing, how the "back-story," if you will of the base was written?

[@amenleethiopia7460]

badbad

[@aakashmehta709]

can someone attach the cheat sheat the above link is not working

[@MyBinaryLife]

i imagine those more advanced topics are in the other 7 hours of the full course, this is just the first 3 hours of his 10 hour course

[@Paragparashar03]

@@aakashmehta709 subscribe first and then u can download

[@ateeqahmed1176]

Mosh, i'm not even kidding but i was lost on the internet for days. Only after that i found your tutorial and i have to say you teach the best. I wish i would have found you earlier. Thanks mate for wonderful video

[@wallywashington8894]

it doesn't get more clear the way you explained it thank you for making it easy for me and for so many more

[@ganyrehs]

Really helpful info! Although I'm currently learning MS SQL Server 2019, this video is SUPER informative and easy to understand! I wish my professor would post up videos describing more info on the user interface and it's functions. He kinda left us in deep water so we can learn how to swim on our own. Sometimes it's worth explaining things in detail to reduce confusion and misunderstandings for students.

[@HayleyChit]

Absolutely amazing course - thank you!!! Just leaving a comment for the algorithm ;)

[@Mupaose]

Hello, this is really great content that makes in easier for anyone to understand. I would like to ask in regards to joins, specifically OUTER JOINS, when you have more than 2 tables and would like to show data the missing data from the middle table, how would that work?

[@GunjanKumar-md1nd]

You made it so easy to install sql server on Macbook Pro. Thank you!

[@EndangeredProdigy]

This is an amazing tutorial. VERY easy to understand and I love the exercises. THANK YOU!

[@eb5333]

its easy if you can do it in parallel. I installed all, but script ends with the errors. It seems something doesn't work for my sys

[@nehalkamble1747]

@Pranita N windows

[@manojuppala3941]

this channel is heaven for learning.

[@quanchichen2695]

I have to say it is the best SQL introduction tutorial in the world! I will soon watch the full 10-hour complete tutorial on your website! Thanks, Mosh! Please keep going!

[@bryanparis7779]

Many thanks for this video Mosh! I really needed it in order to understand more about the SQL.

[@aliguliyev2122]

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

[@karma_yogi_42]

just like in the video description

[@likevideo00]

thanks, great job

[@5g3yashwanth71]

Thanks

[@tachocalvinensoh9271]

Amazing

[@SuyogItsMadness]

JUST A MINOR CORRECTION : 😊 At 3:07:55 This will give you an "Error: Operand should contain 1 column(s)" because we are selecting * all columns. So instead of selecting all, we have to select only client_id DELETE FROM invoices WHERE client_id = (SELECT client_id FROM clients WHERE name = 'Myworks'); and MOSH you are Awesome 🔥

[@alispeaks6182]

Thank You Mosh After roaming for many days on different tutorials this is the best I stumbled upon. Bundle of thanks

[@akshayagarwal9311]

Completed this course in a total of 6 sittings of half n hour each. I have not taken any other SQL course online, but I can assure this is a great course with precise content, managable pace and interesting exercises that solidify the lectures taught. Going to purchase the full course which is just under $11 or (Rs. 950). Thanks for the great course, Mosh!

[@pravatkumargupta4083]

have you purchased?

[@akshayagarwal9311]

@@pravatkumargupta4083 yes

[@thorlikondasrinivasaruntej9736]

This course is AWESOME ! sir, I learn lot may concepts in this video in very clear cut manner through your beautiful examples. Mosh sir if you don't mind can you please provide remaining sessions in your KZbin channel for free its helps for our career.

[@jonathonm6613]

A note on the solutions to the regular expressions exercises: On the first one, the query is for customers whose first name *contains* Amber or Elka, not customers whose first names *is* Amber or Elka. In this data set it doesn't make a difference, but if there was someone whose first name was Amberosa or something like that, the query would return them.

[@user-qy8dg4rm8i]

Thank you so much for great work! I'm sure that it's extremely useful course for everyone.

[@Avvaball__my_Teleqram_id]

For more enquiries reach out⬆️🆙.