MySQL Tutorial for Beginners [Full Course]

Поділитися
Вставка
  • Опубліковано 9 чер 2024
  • 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

КОМЕНТАРІ • 9 тис.

  • @programmingwithmosh
    @programmingwithmosh  2 роки тому +338

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

  • @zeheero
    @zeheero 4 роки тому +1909

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

  • @cash80flow
    @cash80flow 3 роки тому +2694

    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.

  • @dipo7974
    @dipo7974 Рік тому +627

    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
      @lindalolly6318 Рік тому +2

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

    • @GauravSingh-di3dd
      @GauravSingh-di3dd Рік тому +1

      on which platfrom did you learned from him ??

    • @victoradeogo8244
      @victoradeogo8244 Рік тому +2

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

    • @MeetPatel-rn7ht
      @MeetPatel-rn7ht Рік тому +3

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

    • @samb23692
      @samb23692 Рік тому +5

      Overemployed?

  • @mapa5000
    @mapa5000 Рік тому +19

    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
    @pawenobis5386 5 років тому +3115

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

  • @abuazzan462
    @abuazzan462 3 роки тому +258

    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
      @diegogamboa3773 2 роки тому

      copied

    • @fracasgaming4837
      @fracasgaming4837 2 роки тому

      What a shole 😂😂

    • @user-hy6dd6en9l
      @user-hy6dd6en9l 2 роки тому

      what could anyone be learning this on mobile lmao

    • @Sebastian7659
      @Sebastian7659 2 роки тому +19

      @@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
      @Mr3sfor Рік тому +1

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

  • @The_Iron_Yuppie
    @The_Iron_Yuppie Рік тому +14

    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

  • @chamarapanakaduwa
    @chamarapanakaduwa 7 місяців тому +2

    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.

  • @programacao3024
    @programacao3024 Рік тому +318

    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
      @mxdtv4911 Рік тому

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

    • @user-cv5mb8jn6d
      @user-cv5mb8jn6d Рік тому +17

      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
      @RohanShirke-ic8bd Рік тому

      @@mxdtv4911 link is in the description.

    • @user-xf3ru9wm6e
      @user-xf3ru9wm6e 6 місяців тому

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

    • @theworldstoriez1806
      @theworldstoriez1806 6 місяців тому

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

  • @yunusemrahulucay4953
    @yunusemrahulucay4953 2 роки тому +236

    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.

  • @QwertyQwerty-ni5om
    @QwertyQwerty-ni5om Рік тому +1

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

  • @sakthipriya8653
    @sakthipriya8653 11 місяців тому +5

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

  • @harishubwanali126
    @harishubwanali126 4 роки тому +118

    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
      @nadiaou5287 4 роки тому

      Excellent

    • @najmoosman1723
      @najmoosman1723 4 роки тому +3

      How long did it take u?

    • @brahimbelmouhand9888
      @brahimbelmouhand9888 3 роки тому +1

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

    • @chanduvamsi1841
      @chanduvamsi1841 3 роки тому +2

      @@brahimbelmouhand9888 yeah PHP is a little annoying tbh.

    • @GroteGlon
      @GroteGlon 4 місяці тому

      @@brahimbelmouhand9888 php is just ass to work with

  • @tomc8888
    @tomc8888 3 роки тому +19

    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!

  • @VeeryBird
    @VeeryBird 6 місяців тому +13

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

    • @BosAli-yh8df
      @BosAli-yh8df Місяць тому

      9:09 10 10

    • @BosAli-yh8df
      @BosAli-yh8df Місяць тому

      So we all go out too 3 so much 3

    • @BosAli-yh8df
      @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

  • @akhilbunnyy
    @akhilbunnyy Рік тому +3

    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.

  • @snakeyez26
    @snakeyez26 3 роки тому +49

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

  • @gautamnarayan3113
    @gautamnarayan3113 Рік тому +98

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

  • @siphiwehlabano3272
    @siphiwehlabano3272 7 місяців тому +1

    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.

  • @ezhankhan1035
    @ezhankhan1035 7 місяців тому +3

    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!

  • @sktlmarat
    @sktlmarat 4 роки тому +191

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

    • @KB-pk5ze
      @KB-pk5ze 4 роки тому +1

      Same

    • @arshamazami159
      @arshamazami159 4 роки тому +13

      University don't teach you all

    • @theHoneyBee474
      @theHoneyBee474 4 роки тому

      I agree!

    • @tomaszyarlett8681
      @tomaszyarlett8681 4 роки тому +21

      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
      @frankp6790 2 роки тому

      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

  • @leahpalimeri4330
    @leahpalimeri4330 3 роки тому +194

    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
      @powpowouchy5 3 роки тому +4

      congrats...what were the questions like?

    • @collinwalker7543
      @collinwalker7543 3 роки тому +2

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

    • @priderintegratedfarmsltd.9875
      @priderintegratedfarmsltd.9875 3 роки тому +1

      congrats dear

    • @leahpalimeri4330
      @leahpalimeri4330 3 роки тому +1

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

    • @leahpalimeri4330
      @leahpalimeri4330 3 роки тому +1

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

  • @kseke25
    @kseke25 Місяць тому

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

  • @skatebrothers06
    @skatebrothers06 Рік тому +3

    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!

  • @SirTurtle
    @SirTurtle 3 роки тому +26

    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
    @loriganni8251 4 роки тому +81

    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
      @aali6749 2 роки тому

      Someone provide me the cheat sheet

  • @adnanhashem98
    @adnanhashem98 Рік тому +2

    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.

  • @jdchaconm.250
    @jdchaconm.250 10 місяців тому

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

  • @iglasgow
    @iglasgow 3 роки тому +21

    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.

  • @rogyn8484
    @rogyn8484 Рік тому +7

    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!

  • @litbro8180
    @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.

  • @hamaamcabdalaaxmed7345
    @hamaamcabdalaaxmed7345 2 роки тому +372

    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
      @johnedwards5147 2 роки тому +3

      edx has some free classes online to this regard.

    • @shabink7363
      @shabink7363 2 роки тому

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

    • @zachzobair3875
      @zachzobair3875 2 роки тому +1

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

    • @minimoe2008
      @minimoe2008 2 роки тому

      @@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
      @zachzobair3875 2 роки тому

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

  • @vincentsicca
    @vincentsicca Рік тому +60

    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
      @RiRi-ku6xz Рік тому

      Is this enough sql for entery level data analyts?

    • @ss877S
      @ss877S 11 місяців тому

      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
      @Ethan_here230 3 місяці тому

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

    • @chandanns9877
      @chandanns9877 3 місяці тому

      ​@@ss877Seven me can u share the infro?

  • @AMAR-pc6ht
    @AMAR-pc6ht Рік тому +1

    DONE with the course.. Thanks alot MOSH uncle!

  • @murators4732
    @murators4732 Рік тому +1

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

  • @renjing
    @renjing 3 роки тому +79

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

    • @adnanmustafa73
      @adnanmustafa73 3 роки тому +1

      That's a demeaning thing to say about someone

    • @sayamqazi
      @sayamqazi 3 роки тому +7

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

  • @temursoliev5802
    @temursoliev5802 2 роки тому +63

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

  • @leemarkchavez9673
    @leemarkchavez9673 Рік тому +1

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

  • @bryanparis7779
    @bryanparis7779 10 місяців тому

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

  • @deepquest
    @deepquest 3 роки тому +12

    Dear Mosh,
    I am beginner to MYSQL and I have watched many videos on UA-cam 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 UA-cam 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.

  • @user-ou2vo9iq4k
    @user-ou2vo9iq4k 3 роки тому +85

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

    • @KuldeepAdhe
      @KuldeepAdhe 3 роки тому +2

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

    • @cgrtemelkuran7933
      @cgrtemelkuran7933 3 роки тому

      Thanks man!

    • @ahmadshafi4778
      @ahmadshafi4778 3 роки тому

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

    • @ahmadshafi4778
      @ahmadshafi4778 3 роки тому

      Can you help me with that pleasee 🥺

    • @Kokodew
      @Kokodew 3 роки тому

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

  • @satyathummala1381
    @satyathummala1381 11 місяців тому

    Too good! Have'nt learned anything so fast! Thanks Mosh🤞

  • @RajneeshDabral
    @RajneeshDabral 4 місяці тому +6

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

    • @seanhutchins1
      @seanhutchins1 4 місяці тому

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

  • @karol700
    @karol700 3 роки тому +22

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

  • @manojuppala3941
    @manojuppala3941 3 роки тому +22

    this channel is heaven for learning.

  • @valeriomusumeci1388
    @valeriomusumeci1388 Рік тому +1

    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!

  • @theoneprince777
    @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….

  • @FukaErY
    @FukaErY 4 роки тому +200

    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
      @abdallahalkhassaky9506 3 роки тому

      @@slimanemesbah7003 I would like to :)

    • @mohabedr5030
      @mohabedr5030 3 роки тому

      fuck you

    • @sudheer596
      @sudheer596 3 роки тому

      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.

  • @pjguitar15
    @pjguitar15 3 роки тому +9

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

  • @Cahangir
    @Cahangir 8 місяців тому

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

  • @user-ue9ls8eb4r
    @user-ue9ls8eb4r Рік тому

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

  • @AnkJyotishAaman
    @AnkJyotishAaman 4 роки тому +9

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

  • @erimun
    @erimun 5 років тому +32

    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
      @nomadicfathersons 3 роки тому

      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.
      ua-cam.com/video/TeAKe5bUQHg/v-deo.html -installation process of mysql
      ua-cam.com/video/zzK3EuFQ5J8/v-deo.html - connection with mysql workbench
      ua-cam.com/video/LwLJjZaotek/v-deo.html
      ua-cam.com/video/QEEJvKAQaQA/v-deo.html
      ua-cam.com/video/at94bZ5hFSs/v-deo.html

    • @akhilreddykomma2965
      @akhilreddykomma2965 2 роки тому

      @@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
      @akshayak373 2 роки тому

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

    • @ambersmith4186
      @ambersmith4186 2 роки тому

      Hello dear

  • @riyadhossain1706
    @riyadhossain1706 Рік тому

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

  • @levito.27
    @levito.27 Рік тому +5

    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
      @ApartmentAbuDhabi Рік тому

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

    • @martinkamau4437
      @martinkamau4437 Рік тому

      Hey man where is the link 😢

  • @dreamwork69
    @dreamwork69 Рік тому +16

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

    • @ApartmentAbuDhabi
      @ApartmentAbuDhabi Рік тому

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

    • @faizansaeed9126
      @faizansaeed9126 Рік тому

      @@ApartmentAbuDhabi what sort of Guidance you are seeking?

  • @EndangeredProdigy
    @EndangeredProdigy 4 роки тому +25

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

    • @eb5333
      @eb5333 4 роки тому

      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
      @nehalkamble1747 2 роки тому

      @Pranita N windows

  • @patienceokereke3061
    @patienceokereke3061 8 місяців тому

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

  • @user-wb6nh6cb2n
    @user-wb6nh6cb2n 10 місяців тому +4

    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
      @68ahil 8 місяців тому

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

  • @bsmaheshkumar5328
    @bsmaheshkumar5328 4 роки тому +16

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

    • @AjitKumar-in4vn
      @AjitKumar-in4vn 4 роки тому +1

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

  • @Shrishtayyyy
    @Shrishtayyyy 5 років тому +17

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

  • @PristineHub360
    @PristineHub360 8 місяців тому

    Thank you for this course Mosh, you are amazing !! Very comprehensive!

  • @GunjanKumar-md1nd
    @GunjanKumar-md1nd Рік тому

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

  • @azamghesmati4764
    @azamghesmati4764 3 роки тому +28

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

    • @shikharnegi2806
      @shikharnegi2806 3 роки тому +1

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

  • @rogerbloise2258
    @rogerbloise2258 3 роки тому +6

    This guy was born to teach! Congratulations, Mosh!

  • @Anthony_Garcia_
    @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

  • @sa7ak
    @sa7ak Рік тому

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

  • @adorefun5175
    @adorefun5175 4 роки тому +200

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

    • @tasnimsarker4653
      @tasnimsarker4653 4 роки тому +2

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

    • @stoonchee
      @stoonchee 4 роки тому

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

    • @excelsquad8518
      @excelsquad8518 4 роки тому

      Select Subscribe Mosh
      From youtube
      Where Programming with mosh

    • @suziewilliams3194
      @suziewilliams3194 Місяць тому

      I love this

  • @AWholeLottaLola
    @AWholeLottaLola 4 роки тому +10

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

  • @glakionmendoza8068
    @glakionmendoza8068 Рік тому

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

  • @jitangagravat5379
    @jitangagravat5379 Рік тому

    Really helpful as always! Thank you so much Mosh!

  • @HayleyChit
    @HayleyChit 3 роки тому +20

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

  • @aliguliyev2122
    @aliguliyev2122 3 роки тому +46

    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

  • @JoshStasio884
    @JoshStasio884 10 місяців тому

    I haven't even started yet and THANK you for having this be also for windows

  • @michaelcopple1736
    @michaelcopple1736 3 місяці тому

    Mosh, this is getting really easy. I'm liking this. I will most likely jump onboard the Masterclass soon.

  • @sahilshintre4123
    @sahilshintre4123 2 роки тому +12

    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
      @akshayak373 2 роки тому

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

    • @sahilshintre4123
      @sahilshintre4123 2 роки тому

      @@akshayak373 is it in the description?

  • @anon5992
    @anon5992 5 років тому +11

    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
      @Don6641 4 роки тому +1

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

  • @AbdelwahabShandy
    @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.

  • @karincentenaro356
    @karincentenaro356 Рік тому

    love your videos, man, learning and building my foundatios as programmer, thank you

  • @antho_pic
    @antho_pic 3 роки тому +10

    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.

  • @AS-tc
    @AS-tc 3 роки тому +47

    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
      @thevoiceofhope3694 2 роки тому

      Being Specific is time wise and quick performance better clarity!

    • @aali6749
      @aali6749 2 роки тому

      Someone provide me the cheat sheet

    • @karan200590
      @karan200590 2 роки тому

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

    • @rubiehaya2705
      @rubiehaya2705 Рік тому

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

    • @karan200590
      @karan200590 Рік тому

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

  • @user-tp1ec3rq1r
    @user-tp1ec3rq1r 4 місяці тому

    really impresive. thank you so much

  • @user-my7vr7pq9d
    @user-my7vr7pq9d 7 місяців тому

    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!

  • @shreyashgorai9616
    @shreyashgorai9616 3 роки тому +9

    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.

  • @daodaostar
    @daodaostar 3 роки тому +11

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

  • @jorgeburgos6502
    @jorgeburgos6502 Місяць тому

    Thank you so much, this is very helpful for school.

  • @deepakchdhr
    @deepakchdhr Рік тому

    Thanks for this quick and fantastic tutorial Mosh!

  • @pistachio7585
    @pistachio7585 3 роки тому +4

    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
      @bryce3851 2 роки тому

      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

  • @hawaiijim
    @hawaiijim 2 роки тому +24

    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.

  • @aniketkumarbarnwal2629
    @aniketkumarbarnwal2629 10 місяців тому

    Hats off to your man!! Really loved the video

  • @wallywashington8894
    @wallywashington8894 7 місяців тому

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

  • @_mabuhay
    @_mabuhay Рік тому +6

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

    • @ApartmentAbuDhabi
      @ApartmentAbuDhabi Рік тому

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

  • @raingodes
    @raingodes 2 роки тому +3

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

  • @ateeqahmed1176
    @ateeqahmed1176 11 місяців тому +1

    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

  • @rahmahmohamed5058
    @rahmahmohamed5058 9 місяців тому

    Great video, with plenty of useful exercises. Highly recommend! 🇬🇧

  • @magorzatakozowska6474
    @magorzatakozowska6474 5 років тому +20

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

    • @akhilreddykomma2965
      @akhilreddykomma2965 2 роки тому

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

  • @sijoalexv
    @sijoalexv 2 роки тому +27

    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!

  • @banteesahay2835
    @banteesahay2835 Рік тому

    Excellent way of teaching the concepts. Thank you Mosh!

  • @scriptles
    @scriptles Місяць тому

    Excellent video, watching this to refresh my memory and it's amazing. Great job.