SQL Course for Beginners [Full Course]

[@programmingwithmosh]

🔥Want to master SQL? Get the full SQL course: mosh.link/sql-course 📕Get my FREE SQL cheatsheet: mosh.link/sql-cheatsheet 👍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

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

[@meet-p03]

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

[@samb23692]

Overemployed?

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

[@RajneeshDabral]

two years back i got a job due to this video. I just saw again today on my suggestion videos

[@seanhutchins1]

so, can one get a job if they know MYSQL inside and out but have no work history in database management?

[@MohamedAli-dx2fp]

​@@seanhutchins1No

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

[@klonedbat]

Me, too. It was extremely frustrating, and I was about to throw in the towel when this video appeared!

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

[@matthewranger1758]

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

[@camilagrandas446]

Thank you so much!

[@Thund3rKatZ]

Thank-you

[@mysticalbluestar4731]

Thank you. I have been waiting for past 30 minutes.

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

[@王偉力-x7g]

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.

[@JeffreyDraper]

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

[@theworldstoriez1806]

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

[@KaranKumar-Z9]

day 1 1:02:36 day 2 1:24:40 day 3 1:48:20 day 4 2:05:58 day 5 2:35:34

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

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

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

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

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

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

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

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

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

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

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

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

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

[@snakeyez26]

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

[@dailycapsule-9]

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

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

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

[@pkkkpkkk2385]

just wanted to mention it :)

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

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

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

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

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

[@defalia]

2:53:05 You don't actually have to add AS here. After reading the documentation, I learnt that he adds AS to improve readability and make it clear that the table is being created as a result of a SELECT statement, but functionally, it remains completely optional.

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

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

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

[@spadeplayz530]

Went through a lot of videos on yt for SQL didnt understand anything but this course is pretty straightforward and simple . FINALLY i am getting something . THANKS

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

[@aligu7]

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

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

[@Noah.Sh.90]

I've taken various courses before, but this one stands out as the best and clearest I've encountered. Mosh consistently impresses with his informative and transparent tutorials, making learning new skills enjoyable. Excellent job, Mosh-bravo!

[@bakhtiyorkhurramov1324]

OK. I bought a full course of Mosh for SQL yesterday and watched already most of it. I highly recommend subscribing to the course, because it is simply enough to cover all SQL and you will not need to re-open other sources. Thank you, Mosh.

[@tahrin.choudhury]

I cannot download the MySQL on my laptop. It does not look the same how he installed it in this video. Can someone help me?

[@sharmajignesh836]

@Bakhtiyor bro.. How many hours is the course of?

[@AnkJyotishAaman]

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

[@karol700]

26:30 the shortcut on windows is shift+control+enter

[@redpoppymemoirs]

Hi Mosh! I signed up to your course and I want to thank you for making SQL clear and easy. I had enrolled in an online course, but was struggling somehow. But just 1 hour into your course I was able to quickly grasp 9 hours worth of the online I had signed up for. Thank you for sharing your knowledge, passion in this field and gift of teaching with us!

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

[@aarav-anish]

No doubt! This has been the best MySQL course I took so far. And trust me, Mosh has made the things so structured and organised that you will just learn everything inflow. Unlike many theoretical courses available, this taught me a total hands-on instruction beautifully. I highly recommend it for absolute beginners Go for it without a second thought.

[@AmitGupta-yw2wg]

m.kzbin.info/www/bejne/g3SWm5KJr6ifosk

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

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

[@manojuppala3941]

this channel is heaven for learning.

[@elliot4252]

Hey, for the deleting rows code at 3:06:40 you will be given an Error Code: 1241. Operand should contain 1 column(s). This is because the subquery is returning multiple columns when it should only be returning the client id. To fix this issue all we have to do is change the * to client_id in the subquery. Your code will look like this: USE sql_invoicing; DELETE FROM invoices WHERE client_id = ( SELECT client_id FROM clients WHERE name = "Myworks" ) This will fix your operand error, hope this helps :)

[@slimanemesbah7003]

Would you like to join our CS team on WhatsApp

[@phoon95]

Can you explain why is that?

[@engrpalash]

Hi Mosh, I barely write comments in any social web. I am too lazy to do that. But you made me to write something. I found your teaching style is just awesome and second to none. I tried so many paid and free web, videos an ebooks, text books but your one was not boring and I couldn't stop watching. It was concise and precisely tells everything. I finished your tutorial/video about Python and MySQL, both are really awesome. I strongly believe you born as excellent teacher and many of us would like you to see you more successful in online teaching in web such as Udemy, edx or such. Please make structured course with challenges and course material that we can be more benefitted. Many of us wouldn't mind to pay for your professional and enjoying teaching effort at all. Please keep it up. I personally would like you to request make a complete course in Data science. Thank you so much.

[@tasnimsarker4653]

Is there the full mysql course described? Do we need to learn something more on mysql besides this tutorial?

[@ApartmentAbuDhabi]

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

[@chijinduonyenkwere7013]

Hi Mosh, I just started this course, and I am excited because I have read lots of positive comments. I hope to get all I need.

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

[@siddharthmodi5908]

Mosh is the best tutor on internet today. ❤️ And for me you deserve to be on top position in top programming guru. Hats off for your efforts 🙏 Love from india 🇮🇳

[@akashsadhu1430]

Wah modiji wah

[@yutaitadori7318]

Broo pura 10 hr wla course purchase kiya kya ? @sid

[@adorefun5175]

SELECT MySQL Tutorial FROM programming with Mosh WHERE Mosh is a brilliant Teacher

[@tasnimsarker4653]

Hi, Is there the full mysql course described? Do we need to learn something more on mysql besides this tutorial?

[@stoonchee]

we can remove WHERE clause and use asterisk in SELECT, since all are brilliant :)

[@excelsquad8518]

Select Subscribe Mosh From youtube Where Programming with mosh

[@suziewilliams3194]

I love this

[@RubeeRoja]

Watching this in 2024, where the version of MySQL available is 9.01. Some of the instillation steps seemed to be a lot quicker with less steps involved. Despite being a slightly different process, this tutorial was so clear and easy to follow. Thank you! .....Now to continue on the journey : )

[@znza32123]

Hello @Mosh For first exercise from 1:02:31 The REGEXP Operator there is an issue with your result: the actual answer is --WHERE first_name IN ('elka','ambur')-- because the actual request is “first name are ELKA or AMBUR”. Are single and exact words, you suggestion (--where first_name REGEXP ‘elka|ambur’--) will display words which contain elka or ambur, so Aelkara will be displayed too. Thank you for you tutorials.

[@cocolasticot9027]

Yep saw that too :p

[@corymarazzo7417]

In addition to this being the best SQL tutorial, I especially appreciate how fast and error free you typed. Thanks!

[@MartySlice]

Man. Right! Haha. I thought I was a pretty good typer but he challenged the heck out of me, unintentionally of course. Great course

[@sherazmalik3847]

Cory did u view & do the course 2 weeks ago cos now i am trying to do it & cant seem to be able to d.load the same things he has shown in this video. Kindly assist. thank u Cory

[@A_View_From_The_Shire]

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

[@KwizeraJeanLuc-qc9fy]

Thank you sir, truly helpful. And for someone stuck with opening the SQL installation to finish, completely uninstall the app and restart your pc, and re install again and it will work

[@ibukunolu]

What about the tables in 20:30? How did you navigate. They look different and I'm confused.

[@aleksajeremic6189]

Just finished this course, thank you for your hard work, you are a great teacher! It helped a lot!

[@Avvaball__my_Teleqram_id]

For more enquiries reach out⬆️🆙.

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

[@rinlitastar]

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🙌🏼🙌🏼🙌🏼

[@tomvos5594]

Hi Mosh, I'd like to add something; starting from 21.24 you reason that storing the data from John Smith/Elke Twiddel is because when something about said customer changes, only one datasheet has to change because of an internal relationship. Whilst true, one can argue that any arbitrary value can be used for the customer id, like a letter, a word, a hash, or their name. Problems only arise if there would be two of the same values for the customer id, because the wrong customer could be requested because of the internal relationship. So going for a numerical customer id is more out of a (human) necessity in sql. But again, what you're saying is true, this comment is only ment as an addition. Thank you for your tutorial video's

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

Урарззз€

[@gugugaga5867]

For people who are not able to download scripts to create database. Follow this steps 1. Right click on the link. 2. Copy link address 3. Paste the link address to new tab. Seconds methods 1. Right click on the link. 2. Save links as. 3. It's shows -'zip can't be downloaded safely '. Don't discard. 4. Click on " ^ " button and click on "Keep" option.

[@tagng8656]

perfecto

[@gsp064]

When I import sql file, I am getting "Unknown File Encoding" error, giving option Character Set Encoding name: UTF:32Be". If I accept (OK) this, still error Invalid byte sequence in conversion input. Any suggestion ?

[@frankp6790]

Once you download the sample SQL files, where do you store them?

[@miluchiasibala2942]

I love the tone of your teaching voice and visuals. It really helps making learning this, easier!

[@KabirBhae]

the link to the scripts isn't working. can I get any help?

[@afridahamed3535]

@@KabirBhae Try copying the link and pasting it in a new tab, you can see it gets downloaded automatically.. Works for me !

[@ashutoshsahu8196]

That makes the whole video more interesting ............ Really :-)

[@priyanshsingh2437]

I love that the audio is available in HINDI. Thankyou so much Mosh

[@allanregista4422]

OMG, This is what youtube contents supossed to be. You're the real deal man, Nice, tidy loud and clear explanation. I'm autosub to you. Thank you for making this, Brother. GBU.

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

[@هانيالخطَّاب-ح4د]

This mini course is so important and efficient for those who have no idea about SQ LANGUAGE and professional DB managers. A huge information along the 3 hours Thank you a lot Mosh you are brilliant :) Hani ALKhattab Syria

[@ehsanheidarian7516]

Hello dear Mosh, You are a great teacher. The only problem I have found so far is : 3:07:59 your Query is wrong. Instead of * you need to write "client_id" like bellow: Delete From invoices where client_id=( select client_id from clients where name='MyWorks') Thanks for your Amazing video. 👍

[@rogerbloise2258]

This guy was born to teach! Congratulations, Mosh!

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

[@Swanidhi]

Thank you for the great lecture! At 1:09:22, the solution for first names are ELKA or AMBUR is incorrect. Either the question should say first name contains or answer should use first_name in (elka, ambur)

[@visheshraina1879]

Completed 1:12:00 in one go, and fully understood as well. GREAT SERIES !!!

[@visheshraina1879]

going at it again

[@pjguitar15]

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

[@ZachGood]

I have a brief interview tomorrow for a testing position, and this video was a great SQL refresher.

[@thatsmenidhi]

how did the interview go?

[@marcomaturana3740]

Yeah let us know mate!

[@ZachGood]

@@thatsmenidhi It went okay. Not bad, not great.

[@azamghesmati4764]

You are born to be a programmer,proud of you dude

[@shikharnegi2806]

Heyy Azam! Can you please send me the database script cause I'm unable to download it through the given link? Thanks:)

[@andilemaseko5568]

I am so proud of myself for finishing this course even though it was very easy. Mosh is a fantastic teacher and I am really happy with my sql knowledge i have gotten from him. May God bless him and keep him doing the Lord's work.

[@forexdragon]

One of the best IT instructors out there PERIOD! So straight forward and clear teaching. Great job Mosh. Your fan club should be called the 'Mosh pit' haha.

[@DrStinger]

You just made me laugh so hard XD!!

[@bikramoli3686]

@@DrStinger you are jealous about it and when it comes to your knowledge you are joker that laugh on useful things...

[@DrStinger]

Vikram Xettri huh? What are you talking about? I’m not jealous of anything. I was just laughing on what he said. What makes you think I’m jealous???

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

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

[@MustafaAltameemi-m5y]

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?

[@nitishkumarverma756]

at 1:50:48 we can also use select * from order_items oi join order_item_notes oin on( oi.order_Id,oi.product_id)=(oin.order_Id,oin.product_id);

[@pakiuss12]

But why doesnt it display any data on the table? just the column names?

[@nikhiljunnarkar6736]

@@pakiuss12 yes same query

[@endofline5152]

@@nikhiljunnarkar6736 its because there are no records matching the condition.

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

[@raviteja8674]

Hi Mosh, you are amazing. I like the course a lot. The way you explained is too good. Thanks for that. Can you please do a course on NoSQL like MongoDB?

[@Avvaball__my_Teleqram_id]

For more enquiries reach out⬆️🆙.

[@hasanjaved3118]

His nodeJs course contains mongoDB section

[@Priya-d3u8l]

what is a full join???

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

[@adarshsasidharan254]

3:07:53 I just want to point out that in the delete statement, you forgot to remove * and write client_id......thanks for the video

[@ray3529]

thank you! I was wondering why it wasn't working

[@ShahbazG]

anyway, 0 rows affected as there is no invoice for client_id =2 in invoices table, yes?

[@edrosewussah5592]

Thank you, Sir Mosh Hamedani for being a blessing to this generation of IT enthusiast, especially me. I am very grateful to you for your selfless hard work and assistance. You may not realise how much you have been a blessing to me. But 80% of everything I know concerning python, Java, Javascript are due to your support. God bless you in the blessed name of the Lord Jesus Christ, Amen.

[@aali6749]

Someone provide me the cheat sheet

[@erkenovferuz1237]

Jesus is a prophet of God

[@magorzatakozowska6474]

You don't even know how much I appreciate the effort, which you have put into those tutorials. thank you! :D

[@akhilreddykomma2965]

@@programmingwithmosh 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.

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

[@bruto6666]

The tutorial is great, I have seen the other java and python tutorials and your teaching methodology is really GREAT. You are an excellent teacher and I will definitely follow the most advanced SQL and Python that you have on your website. Thank you very much for taking the time to teach more people.

[@aali6749]

Someone provide me the cheat sheet

[@hajdahmanilyes3562]

@@aali6749 I'm need it too, please put it here if u find it

[@shabink7363]

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

[@ammar46]

@@shabink7363 Ask some with a mac or iPhone to download it and give it you, because this can only be opened in Safari.

[@soumyadiptasensharma2055]

@@aali6749 programmingwithmosh.com/wp-content/uploads/2019/03/SQL-Cheat-Sheet.pdf - here u go

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

[@_mabuhay]

This tutorial is drop dead gorgeous! I finished it in one sitting. Thank you sir Mosh!

[@ApartmentAbuDhabi]

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

[@davidabraham1969]

Best SQL course I have found! Only one issue. "IN-ven-tory" (maybe it's different for the British)

[@HJ-gg3kf]

Oh my... this is the BEST SQL lectures I've ever had before

[@BenjaminOrthodox]

I totally agree!

[@sakthipriya8653]

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

[@slayer_dan]

Subhan Allah, What a great effort . Thank you a lot for your hard work and sincerity to the lectures.

[@Hrishiiiii__]

Done with sql , absolutely loved the exercises between each section