MySQL Tutorial for Beginners [Full Course]
VloĆŸit
- Äas pĆidĂĄn 1. 06. 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
![Eminem - Houdini [Official Music Video]](http://i.ytimg.com/vi/22tVWwmTie8/mqdefault.jpg)
đ„ Want to master MySQL? Get the full MySQL course: bit.ly/2uAoPM3
đ Subscribe for more SQL tutorials like this: goo.gl/6PYaGF
Z
@@peterkim9263 lp
where do I see the zip file ?
@@fantematics click the show more button on the description above
Aaaa999900
Note to everyone: If the tables is stuck at fetching, just restart the MySQL application and it should fix the infinite queuing.
Thank you!
Thank you so much, i thought i did something wrong for a moment!
Thank you so much!
Thank-you
Thank you. I have been waiting for past 30 minutes.
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.
True. A good teacher indeed !
Same here sir.
Please share Udemy link
I really enjoyed d program đđ»đđ»đđ»đđ»
actually he is just too good
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!
Don't you want to teach how to use it, i can get it right
on which platfrom did you learned from him ??
Kindly give a clue of the platform from which you learnt from him to be proficient enough for two jobs
Do you please mind shadowing how you built your career in SQL?
Overemployed?
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 !
Mosh, you should be under the United Nations legal protection. You are a world's treasure!
@@programmingwithmosh you said and its done....
All my friends watch you
Exactly......
True
true
Honestly.
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.
Thank alot
Thanx man
You are a BEAST! thanks man
It worked! Thanks
Thank you so much !
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.
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
I truly cannot thank you enough for this. Probably the most simple, straightforward, and comprehensive tutorial I've ever seen. Thank you.
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đ
Excellent
How long did it take u?
I also learnt Javascript,C#,Java and CSS.... I am now learning SQL, PHP sucked so I stopped right away
@@brahimbelmouhand9888 yeah PHP is a little annoying tbh.
@@brahimbelmouhand9888 php is just ass to work with
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.
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!
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.
Probably the best crash courses Iâve ever taken. The pace and material is just so easy to understand. Thank you so much Mosh!
Where is the material
Looking for the material too
After many struggles, the best SQL course which I have gone through . Thanks Mosh â€
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!
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.
Someone provide me the cheat sheet
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!
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.
Thank you so much! I have never watched such a clear tutorial, very clear and also friendly! You make MySQL seem easy.
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
I understood more in 3 hours from your video than from 16 lectures in university. Thank you sir!
Same
University don't teach you all
I agree!
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.
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
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!
hey where is the zip file ?
@@hig1234geu in the description
As a teacher I really appreciate the hands-on examples that are given, very well made!
9:09 10 10
So we all go out too 3 so much 3
To 26 we all so it to see you all We you too baby love you slos so I don't know 3
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
copied
What a shole đđ
what could anyone be learning this on mobile lmao
@@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.
@@user-hy6dd6en9l me cz if u use ur friend's computer u will understand the pain
The tutorials are truly simple to understand and taught in a very beginner-friendly way. Thank you, Mosh! I love your channel!
ĐŁŃĐ°ŃĐ·Đ·Đ·âŹ
It's very helpful for those who are getting started with SQL.
Thank you so much for such an awesome crash course.
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!
Dear Mosh,
I am beginner to MYSQL and I have watched many videos on CZcams 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 CZcams 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.
From how you teach and how this video tutorial is designed, I can say you are a very organized person.
even three years later your lecture doesnt get old... that is amazing in the tech industry :D
Thank you. At least I understood it.
This is such a great course. Better than where Iâm currently studying right now. Iâm glad Iâve found this!
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!
congrats...what were the questions like?
aesome! do you remember some of the questions the interviewer asked?
congrats dear
â@@powpowouchy5 sorry for late response, few select and one join question.
@@collinwalker7543 sorry for late response, few select and one join question.
Tons of love from India!!
I can recommend this course to anyone who is starting from scratch worth watching
God Bless You!!
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âŠ.
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.
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
@@slimanemesbah7003 I would like to :)
fuck you
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.
If the ZIP file is not downloading for you, try to copy paste the address into your address bar. Hope this helps.
Thanks bro.. I was struggling from last 15min...
Thanks man!
I downloaded it but it showed mysql installer web community ...
Can you help me with that pleasee đ„ș
@@ahmadshafi4778 just copy the address and paste in search bar
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 :)
can you guide me to abt sql, i really need the guidiance, I will be highly in debt of you
Hey man where is the link đą
DONE with the course.. Thanks alot MOSH uncle!
Crisp concise and to the point perfect explanation! It was Very helpful, Thank you :)
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.
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.
What's ur salary per month? Is it enough?
Easy to understand and follow, very dynamic and I agree with y'all, Mosh is a great teacher!
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!
Is this enough sql for entery level data analyts?
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
Knowledge of sql, database management systems, big data should sufficeâ@@ss877S
â@@ss877Seven me can u share the infro?
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!!
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.
This tutorial is the best! It's so useful, and the exercises help retain all the knowledge. Thank you so much!
this channel is heaven for learning.
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.
edx has some free classes online to this regard.
please give me link to scripts used to create databases for this course.....Please
@@shabink7363 If you copy + paste the link into a new tab, it should work -- don't click on the link!
@@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?
@@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
Amazing Tutorial! I think you've helped me a lot for my SQL exam! Thank you, Mosh!!!
You know exactly what a newbie needs, great teaching. Thanks a lot!
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
can you send me the script to create database in this video
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
@@mxdtv4911 link is in the description.
1:30:15 why did he just use JOIN and not use INNER JOIN ?
â@@user-xf3ru9wm6e inner join and join both are same . Either of them can be used but both works the same
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
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
Help me to get the link please
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!
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.
I have been working at an educational institution for years. And I can tell that Mosh is born to be a teacher.
That's a demeaning thing to say about someone
@@adnanmustafa73 how is that demeaning, acknowledging that someone is really really talented at teaching.
two years back i got a job due to this video. I just saw again today on my suggestion videos
so, can one get a job if they know MYSQL inside and out but have no work history in database management?
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!
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!
Are you able to download cheet sheet?
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 CZcams channel for free its helps for our career.
I just purchased it ( SQL)
thanks man, you are great!
greetins from Greece!!
This is lovely⊠thank you Mosh. Just checked the files again. I just got the zip file. Thank you again.
_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!_
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.
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.
how many hours have you put in that course every day?
where is the zipfile link
Best tutorial I've come across. Simple and on point, very easy to understand. Thanks, Mosh!!
For more enquiries reach outâŹïžđ
I wanna say thanks to your tutorials that I found my baby steps to both Python and MySQL studying. Really much appreciated!
can you guide me to abt sql, i really need the guidiance, I will be highly in debt of you
@@ApartmentAbuDhabi what sort of Guidance you are seeking?
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.
Wow! I really love that you have made exercises at the end of each tutorial, super helpful.
Just completed and this is my first ever sql âanything relatedâ course đ I hope I continue and this becomes my field đ€
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 đ„
This guy was born to teach! Congratulations, Mosh!
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
Excellent video, watching this to refresh my memory and it's amazing. Great job.
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.
After watching all your tutorials on different languages, I'd like to declare you as one of the top CZcamsr in respect with teaching Oops concept. Hats off you sir. You are just exceptional.
can you help me for installing mysql, my server part was not working. I'm from Mumbai , can call me...9586210188
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
Best SQL course I have found! Only one issue. "IN-ven-tory" (maybe it's different for the British)
26:30 the shortcut on windows is shift+control+enter
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.
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.
czcams.com/video/TeAKe5bUQHg/video.html -installation process of mysql
czcams.com/video/zzK3EuFQ5J8/video.html - connection with mysql workbench
czcams.com/video/LwLJjZaotek/video.html
czcams.com/video/QEEJvKAQaQA/video.html
czcams.com/video/at94bZ5hFSs/video.html
@@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.
where is the zip file attached for this databse?? can anyone please help me?
Hello dear
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!
have you purchased?
@@pravatkumargupta4083 yes
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!
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)
Being Specific is time wise and quick performance better clarity!
Someone provide me the cheat sheet
databases are downloaded but only product table is showing after running and refreshing. all other tables are absent. what to do?///
@@karan200590 same problem. Were you able to fix it?
@@rubiehaya2705 yes...load the databases separately...
Absolutely amazing course - thank you!!! Just leaving a comment for the algorithm ;)
I haven't even started yet and THANK you for having this be also for windows
Thank you for this course Mosh, you are amazing !! Very comprehensive!
This is an amazing tutorial. VERY easy to understand and I love the exercises. THANK YOU!
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
@Pranita N windows
Fantastic course, fantastic clear explanation!! Thank you so much for all your hard work and effort to make this complex topic so concise, informative, easy to comprehend, and very clear language for even non-technical people to follow and learn from. All the very best with your future topics, you will definitely have more followers!!! Best greetings from London :)
Mosh, this is getting really easy. I'm liking this. I will most likely jump onboard the Masterclass soon.
Thank You Mosh
After roaming for many days on different tutorials this is the best I stumbled upon. Bundle of thanks
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.
Someone provide me the cheat sheet
@@aali6749 I'm need it too, please put it here if u find it
please give me link to scripts used to create databases for this course.....Please
@@shabink7363 Ask some with a mac or iPhone to download it and give it you, because this can only be opened in Safari.
@@aali6749 programmingwithmosh.com/wp-content/uploads/2019/03/SQL-Cheat-Sheet.pdf - here u go
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);
But why doesnt it display any data on the table? just the column names?
@@pakiuss12 yes same query
@@nikhiljunnarkar6736 its because there are no records matching the condition.
i can 100% guarantee that no is better than MOSH... you are the best boss. i will purchase your full tutorial...God bless you
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.
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đđŒđđŒđđŒ
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
I was wondering the same thing, how the "back-story," if you will of the base was written?
badbad
can someone attach the cheat sheat the above link is not working
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
@@aakashmehta709 subscribe first and then u can download
Thank you so much for such a wonderful course Mosh !! It was indeed helpful with lots of tips.