I am not from IT, age 54 and Mechanical Engineer with 30 years experience in Plant Maintenance. I am learning with your instructions and the video step by step. Same way I have learnt Python, HTML5, CSS, JS, NodeJS, Docker, VSCode, C#, MySQL, PostgreSQL, MongoDB, Git and GitHub, NoSQL, etc. and I am still looking for new things to be learned ! Thank you from India, for the simple and easy to follow videos.
Really appreciate the effort you put into this! It's hard to walk this journey alone but because of people like you things are easier to handle 🙏 Would love to see some advanced SQL as well!
What a great video !🔥🔥 I am just beginning my way to become a data analyst and your tutorial is absolutely amazing❤ I hope that this tutorial is just the beginning and you will upload tutorials for rest of the roadmap (Excel, tableau, Power BI,....etc)
I loved this! I just finished the tutorial and as a fresh graduate right out of university looking to start off a career in data analytics, this video was so comprehensive and well taught out, unlike other companies with dummy dataset that was "too easy". I know how difficult it must have been for you to upload, great job man! An advanced SQL tutorial covering CTEs and triggers will be very much appreciated! :)
I'm so glad you found the video helpful! CTEs might be on the way, but I have another video on WINDOW FUNCTIONs. Check that out maybe if you haven't seen it yet.
Really helpful! Previously took a sql course on coursera, and this video helps me consolidate what I learnt and clear some more complicated concepts. Thank you!
i came from your excel tutorial playlist and now I'm here in sql! thank you so much for putting an effort to help us in this journey, it's very much appreciated 🙏
I am extremely grateful for this incredible tutorial. I can't recall who recommended your channel, but I deeply appreciate them as well. You have no idea how beneficial your tutorial has been for me. I will practice with your code to improve my SQL skills. Thanks again.
Great to see you actually put a course about this online! Thank you for your efforts. I'd like to do a suggestion: is it possible for you to make a course intermediate to advanced SQL for people like me? I have some issues finding a structured course on for this level on SQL online and I think you would be a great person for me to learn from! :)
Hi Wijnand, great suggestion! I will certainly release a 2nd course on advanced SQL queries, just don't exactly know when yet (hopefully within the next 2-3 months). Thank you so much for watching 😃
I was literally about to ask you if you could do this!!! So far your videos have been so great. I love how you explain everything as we go along. 🎉 I'll let you know what I think! 😊
Thank you for your effort in doing this SQL database course Mo. I'm already at the capstone module of Google's DA course and still a bit lost. I kinda understand how SQL works now, especially the primary, foreign and composite keys.
thanks MOCHEN 😄😁🥰!! even though am not Data Analyst, but as full-stack web dev, this 70min saved weeks of my time, so I will contribute to this repo, by pulling request, with improved readability commit, and png screenshot of tables.
Invested so much money into a Master program to only come out feeling lost and uneducated. You are amazing and make me feel like I can do it. Thank you for all of your knowledge, skills, and time putting this together. ❤New subscriber here!
I'm glad you liked it. It was not a time constraint, it was a choice. My channel is focused around data analysis and these are 90% of the queries you'll need for data analysis jobs. I want to give you only what you need, and nothing more to save you the time and hassle of learning random, cool, but unnecessary things.
I really like the video tutorial you saved in your channel, I will watch again the tutorial for the second time for me to master the basic concept. Thank you very much for these lectures. Have a great day and and keep on posting educational videos/lectures about Data science.
I thank you very, very much. you guided me on my way to data analyst. my english is not very good, I hope you understand me. the video was great, I analyzed all the examples. 👍👍👍👍👍👍
I want to thank you for creating this amazing tutorial. I just finished my Google Data Analysis Course on Coursera and found this very useful and well-explained. Can't wait to start with a job hunt. Thank you again, you don't have an idea how helpful your tutorial was for me.
This is such a well made and helpful video...Thank you for taking the time to do this. You are such a talented teacher! I look forward to your future videos. THANK YOU!
Thank you so much. You channel has been incredibly valuable to me as I begin my journey in analytics. I've learned from from you than I have in school. Your videos inspire to keep working hard and you make it easy to learn with you. May God bless you for sharing your knowledge.
Hello mr Chen thank you so much for your videos 🙏🏿..I am an aspiring Data analyst planning to explore A secondary School student from Nigeria.. hoping to learn more things from your tutorials sir😊
Thanks so much. You really help me finding a good roadmap to learn SQL. I will appreciate a lot other tutoriels like this one in Power BI and Excel if it's possible.
question for length how can you then look at the max length of the email without having an error that says column "email_length" does not exist example SELECT email, LENGTH(email) AS email_length, Max(email_length) FROM employees
Well done for such a great work. I think the speed was high so I suggest you break the video into topics such that you will take your time to explain very well. More grease to your elbow. Great video❤
Hi there, nicely done with the tutorials. Bring it more, im seriously interesting in Data Science. Working with pandas and numpy at the moment Cheers :)
Hi Mo, great explanation. Thanks for this. Can you also do a comparation between Tableau vs Power BI and the one you would prefer? looking forward for more content!!!!! 🙌🏻
So I'm new to this but can i still finish this video and be able to work with Microsoft SQL? If not is there a playlist for that in particular because that's what i have installed . Thanks 🙏🏾
At 1:05:04, I want to use this subquery to find all the coffee shop in US, here is the code I wrote: SELECT coffeeshop_name FROM SHOPS WHERE city_id IN (select city_id from locations where country = 'United States'); For some reason, this returned with coffeeshop_id 1,2,3,4 (including United Kingdom coffeeshop) and 5 is missing (5 also belong to US) Just wondering where did I go wrong from here. I apprecited if you could look at the above code) :(
Do you think a person needs strong math skills to be a day analyst and eventually make it to 200K+? I am a fast learner but never really liked school so my math skills are really good when it comes to everyday computations. I almost never need a calculator but barely passed statistics in college mostly due to ADHD and not learning well in a structured setting.
Hi Mo, really grateful to find your training video 😊 I am brand new to SQL, had to ask how was data get transferred into SQL to create the table please? I have followed all the coding steps but no table was created. I must have missed an important step here…. Could you please help.xx
Hi there 😃 If you follow the code exactly sequentially, then you should definitely have your tables created. Could you please try again from the beginning?
love the content by the way, my question is I have a data set that doesn't have a primary key or foreign key the rows repeat so when I try to link it to another data set it is impossible because i don't know how to create a primary key or foreign. Do you have anything like this?
@@mo-chen i have been working on it for years and I can't do it...lol..I tried making a table with unique primary Id and when I link it to the other tables ..it doesn't work. I guess One day I will find a video on this. I am currently going to look at your playlist on SQL..I really like your voice and can sit through a video. There are other voices that are to high pitch and I just can't watch. I am so glad I found your channel.
@@mo-chen Great course really, thank you. The thing that worries me now is that I find SQL easier than expected so far. It worries me because there is probably something that I am missing. But after learning Python for a while, I feel like SQL is on the level of HTML and CSS almost. Suddenly that Data Analyst job seems much closer than I thought, however something tells me that my overconfidence right now will bring me some pain in the future.😀
I'm at 57:48, and kinda stuck INNER JOIN as it's suddenly s.coffeeshop_name,.. (I don't full understand the "alias" and how it named like that "s.coffeeshop"). It took a while before I figured it out through w3school. As a beginner, I would suggest you to go through/add this part in the future tutorial, as it's fundamental before moving on to a more complex code. It also could be that I have no previous coding experience so it was confusing at first try LOL
So I’m following along with the tutorial . When I insert the dates specifically I keep getting Error: date/time field value out of range: “29/08/2016” Hint : perhaps you need a different “datastyle” setting. Sql state: 22008 Character: 239 I’m using data type DATE for the hire_date definition so I don’t understand
I am not from IT, age 54 and Mechanical Engineer with 30 years experience in Plant Maintenance. I am learning with your instructions and the video step by step. Same way I have learnt Python, HTML5, CSS, JS, NodeJS, Docker, VSCode, C#, MySQL, PostgreSQL, MongoDB, Git and GitHub, NoSQL, etc. and I am still looking for new things to be learned ! Thank you from India, for the simple and easy to follow videos.
Really appreciate the effort you put into this! It's hard to walk this journey alone but because of people like you things are easier to handle 🙏 Would love to see some advanced SQL as well!
Hey Larissa 👋 Thanks so much for watching! I will for sure make an advanced SQL course, hopefully soon rather than later 😃
I’ve learnt more from Mo than attending actual classes… 👏🏾👏🏾
I'm so glad you found the video useful, thanks a lot for watching 😄
For real…
Isn’t it sad that CZcamsrs can teach better than actual TEACHERS and they teach it for FREE!!!
@@Dennisaj yea, I just wish recruiters would value non-college learning as much as a degree
What a great video !🔥🔥
I am just beginning my way to become a data analyst and your tutorial is absolutely amazing❤
I hope that this tutorial is just the beginning and you will upload tutorials for rest of the roadmap (Excel, tableau, Power BI,....etc)
Thank you so much for watching! I really hope so too that I’ll be able to make more tutorials like this 😃
I love the video! It is a change of scenery after boring SQL classes at uni! Can't wait for the new one :)
I loved this! I just finished the tutorial and as a fresh graduate right out of university looking to start off a career in data analytics, this video was so comprehensive and well taught out, unlike other companies with dummy dataset that was "too easy". I know how difficult it must have been for you to upload, great job man!
An advanced SQL tutorial covering CTEs and triggers will be very much appreciated! :)
I'm so glad you found the video helpful! CTEs might be on the way, but I have another video on WINDOW FUNCTIONs. Check that out maybe if you haven't seen it yet.
Really helpful! Previously took a sql course on coursera, and this video helps me consolidate what I learnt and clear some more complicated concepts. Thank you!
Thanks for watching, I'm glad you found the video useful 😃
i came from your excel tutorial playlist and now I'm here in sql! thank you so much for putting an effort to help us in this journey, it's very much appreciated 🙏
I am extremely grateful for this incredible tutorial. I can't recall who recommended your channel, but I deeply appreciate them as well. You have no idea how beneficial your tutorial has been for me. I will practice with your code to improve my SQL skills. Thanks again.
Glad it was helpful!
Great to see you actually put a course about this online! Thank you for your efforts. I'd like to do a suggestion: is it possible for you to make a course intermediate to advanced SQL for people like me? I have some issues finding a structured course on for this level on SQL online and I think you would be a great person for me to learn from! :)
Hi Wijnand, great suggestion! I will certainly release a 2nd course on advanced SQL queries, just don't exactly know when yet (hopefully within the next 2-3 months). Thank you so much for watching 😃
I was literally about to ask you if you could do this!!! So far your videos have been so great. I love how you explain everything as we go along. 🎉 I'll let you know what I think! 😊
Thanks a lot Maricuz!
thanks Mo, this is really good reminder about SQL basics that I used for my hiring test!
I'm glad you found it useful, thanks for watching 😁
Thank you for your effort in doing this SQL database course Mo. I'm already at the capstone module of Google's DA course and still a bit lost. I kinda understand how SQL works now, especially the primary, foreign and composite keys.
Hi Anj 👋 I’m glad you liked the video, thanks a lot for watching!
thanks MOCHEN 😄😁🥰!!
even though am not Data Analyst,
but as full-stack web dev,
this 70min saved weeks of my time,
so I will contribute to this repo,
by pulling request,
with improved readability commit,
and png screenshot of tables.
Thanks so much for improving the readability 🙏 I’ll quickly review it when I get the chance. I’m glad the video helped you learn faster 😃
Invested so much money into a Master program to only come out feeling lost and uneducated. You are amazing and make me feel like I can do it. Thank you for all of your knowledge, skills, and time putting this together. ❤New subscriber here!
Great to have you here on the channel!
Very goog lesson, Mo Chen!!!
I'm brazilian beginner in SQL.
Thankyou ❤1 hour of clear information intead of 450 hours of unclear info on other platforms that only waste your time
Most of the things covered in an one hour video. Thank you!
I’m glad you found it useful! Thanks a lot for watching 😃
Great video, it's almost everything a beginner to SQL hopes to find, thank you Mo
Glad it was helpful!
The explanations could have been more detailed but I understand the time constraints, overall I loved the content.❤
I'm glad you liked it. It was not a time constraint, it was a choice. My channel is focused around data analysis and these are 90% of the queries you'll need for data analysis jobs. I want to give you only what you need, and nothing more to save you the time and hassle of learning random, cool, but unnecessary things.
@@mo-chen Gotcha!💯
Thank you so much! You helped me learn faster for my university exam
Glad I could help! Good luck with your exam 😁
Great video to learn....Great work brother ....
Thanks a lot for watching Naresh 😃
You explain everything so good.....waiting for the advance sql tutorial from you Mo :)
Thanks a lot for watching Vedo 😃
I really like the video tutorial you saved in your channel, I will watch again the tutorial for the second time for me to master the basic concept. Thank you very much for these lectures. Have a great day and and keep on posting educational videos/lectures about Data science.
I'm very glad you like the content Johayber 😄Thanks so much for watching!
@@mo-chen You're welcome sir I want to become a Data Scientist as because I need this to my field as a chemistry student
thank you for your time and effort
amzing video , you will blow up soon !
Thanks so much for watching!
I thank you very, very much. you guided me on my way to data analyst. my english is not very good, I hope you understand me. the video was great, I analyzed all the examples. 👍👍👍👍👍👍
Please make more videos like this on other coding language like java.. I love this.. Thanks bro..
I would love to when my time allows it 😁 Thanks so much for watching!
I want to thank you for creating this amazing tutorial. I just finished my Google Data Analysis Course on Coursera and found this very useful and well-explained. Can't wait to start with a job hunt. Thank you again, you don't have an idea how helpful your tutorial was for me.
thank you so much. Applying to new job and have been studying all your videos!
Hi David 👋 I'm glad you find the content useful! Thanks for watching 😃
This is such a well made and helpful video...Thank you for taking the time to do this. You are such a talented teacher! I look forward to your future videos. THANK YOU!
Thanks so much for the kind words and for watching 😁
Thanks Mo. Watched this before I did a certification course in Coursera and it was a breeze. Thanks again!
hi! which certification course did u do
@@noorqaiser9353 SQL Basics for Data Science Specialization by UC Davies
Thank you for this. I will watch this now. Keep on sharing my friend - Glenn
Thanks so much for watching 😃
Thank you, Mo! This tutorial is awesome, you're an inspiration!
Thanks so much Marianne for the kind words 😃
Thank you so much, absolutely wonderful
I'm glad you liked it, thanks so much for watching 😄
Thank you so much. You channel has been incredibly valuable to me as I begin my journey in analytics. I've learned from from you than I have in school. Your videos inspire to keep working hard and you make it easy to learn with you. May God bless you for sharing your knowledge.
Great to hear! Thanks so much for watching 😁
Thank you so much for your tutorial. You don't know hou much this helps me in my professional carreer. Best!
Thank you for this great lesson. very well laid out and good pace. I'll be able to refer back to this for a very long time.
Hello mr Chen thank you so much for your videos 🙏🏿..I am an aspiring Data analyst planning to explore
A secondary School student from Nigeria.. hoping to learn more things from your tutorials sir😊
where do you i get the sql file to follow along?
yooo thanks 4 the work you put in this one! Cheers & keep it up 🤘😔🤘
No problem at all, thank you for watching 😃
16:55 When Mo turned into a Sigma!!!! and great tutorial by the.
I'm glad you liked it! Thanks a lot for watching 😁
Thank you so much! You are doing a great work.
Thank you so much for watching Emerson!
thanks for this MO. thanks for taking the time to post this and help a lot of people.
Glad it was helpful!
@@mo-chen really grateful. 🙏😊you have simplimfied things that were quite vague to me in my other resources. Bless you more. :)
This is very helpful! Thanks for putting this all out! ❤
I’m glad you liked it! Thanks for watching 😃
Thank you for so many visuals! Thats' what I needed for sure
I'm glad you liked the video F K! Thanks a lot for watching 😃
Thank you Mo, you are doing awesome
Thanks so much for sticking around on the channel 😃 I'm very glad you're still here!
After watching just a minute i subscribed❤😅
Thanks so much. You really help me finding a good roadmap to learn SQL. I will appreciate a lot other tutoriels like this one in Power BI and Excel if it's possible.
Glad it was helpful!
Great content, so many topics covered in just 1 hour.
Thanks a lot for watching, I'm glad you liked it 😃
question for length how can you then look at the max length of the email without having an error that says
column "email_length" does not exist
example
SELECT email, LENGTH(email) AS email_length, Max(email_length)
FROM employees
Thankyou so much... Please also cover cte and window fxns too🎉🙌
I’m glad you liked it! I will try my best, there will be more sql videos coming for sure 😃 Thanks a lot for watching!
finally a hot SQL teacher
Thank you!
Well done for such a great work. I think the speed was high so I suggest you break the video into topics such that you will take your time to explain very well. More grease to your elbow. Great video❤
Great work! Thats exactly what i needed
I'm glad you liked it Aidar 😁 Thanks a lot for watching!
Thank you very much fior a succinct and informative demonstration.
Completed kindly make another one a Advanced one please it would be helpful.
I will for sure make a course on advanced SQL queries just not exactly sure when yet 😅
I love your content friend, greetings from Perú.
Thanks a lot for watching Angelo 😁
Amazing work Mo! Thank you for all the hard work you put into this project. This is really quite helpful 🙏
Glad you enjoyed it!
Hi there, nicely done with the tutorials. Bring it more, im seriously interesting in Data Science. Working with pandas and numpy at the moment Cheers :)
All the best with your data science journey! Thank you so much for watching 😄
Great one! Much appreciated!
Glad it helped! Thanks for watching 😁
Excellent tutorial even if the speed is so fast......
This is great! thank you Mo
Thank you for watching, I’m glad you liked the video!
Very useful video, really liked how visual everything was
That’s great, thanks so much for watching!
Hi Mo, great explanation. Thanks for this. Can you also do a comparation between Tableau vs Power BI and the one you would prefer? looking forward for more content!!!!! 🙌🏻
Thanks so much for watching! It's a great video idea 😁
So I'm new to this but can i still finish this video and be able to work with Microsoft SQL? If not is there a playlist for that in particular because that's what i have installed . Thanks 🙏🏾
Thanks you very much for your work!
Thanks so much for watching, I'm glad you liked it 😁
Great tutorial!!
Thank you!!!
I'm glad you liked it Francisco! Thanks for watching 😃
At 1:05:04, I want to use this subquery to find all the coffee shop in US, here is the code I wrote:
SELECT coffeeshop_name
FROM SHOPS
WHERE city_id IN (select city_id
from locations
where country = 'United States');
For some reason, this returned with coffeeshop_id 1,2,3,4 (including United Kingdom coffeeshop) and 5 is missing (5 also belong to US)
Just wondering where did I go wrong from here. I apprecited if you could look at the above code) :(
Wow, i have not seen it yet, but thanks in advance for your contributions to this community. Cheers Mo
Thank you santilo76 😁
Awesomely Explained.
I'm glad you liked it Prashant 😁 Thanks a lot for watching!
Great tutorial - thank you
great video! thanks!
Thank you for watching 😃
You are Amazing Although i am also learnign SQL from Coursera UC Davis
Thanks a lot for watching and good luck with your sql learning 😁
Thanks !!!!@@mo-chen
Do you think a person needs strong math skills to be a day analyst and eventually make it to 200K+? I am a fast learner but never really liked school so my math skills are really good when it comes to everyday computations. I almost never need a calculator but barely passed statistics in college mostly due to ADHD and not learning well in a structured setting.
Hi Mo, really grateful to find your training video 😊 I am brand new to SQL, had to ask how was data get transferred into SQL to create the table please? I have followed all the coding steps but no table was created. I must have missed an important step here…. Could you please help.xx
Hi there 😃 If you follow the code exactly sequentially, then you should definitely have your tables created. Could you please try again from the beginning?
5:34 this mail names are kinda sussy, i liked that lol
Top stuff 🎉
Thank you 😃
Great explanationn❤❤❤❤ , You are great teacher , i am learning so much from your channel , waiting for more videos
Thank you for the kind words!
Very nice explanation.... Great 👍
great content Mo!
Thanks a lot for watching Leonardo!
Great Video. Very useful and easy to understand.
Glad it was helpful!
I have been using ssms, what's the difference with PostgreSQL? and will my knowledge of ssms apply to PostgreSQL?
can anyone help me.. i cant find pgadmin after i downloaded it
Could someone tell me why he uses a 23:13 update instead of directly inserting all the data into the table through 'insert into'?
New subscriber, thank you
I’m glad you liked it, thanks for the sub 😃
amazing
Glad you think so!
Plz make video on Power Bi also
Where can I get this 24:26 data to put into the query..?
love the content by the way, my question is I have a data set that doesn't have a primary key or foreign key the rows repeat so when I try to link it to another data set it is impossible because i don't know how to create a primary key or foreign. Do you have anything like this?
My best bet would be to create a composite key that is unique
@@mo-chen i have been working on it for years and I can't do it...lol..I tried making a table with unique primary Id and when I link it to the other tables ..it doesn't work. I guess One day I will find a video on this. I am currently going to look at your playlist on SQL..I really like your voice and can sit through a video. There are other voices that are to high pitch and I just can't watch. I am so glad I found your channel.
Hi, Mo. I have a trouble. When I run the SELECT * FROM employees, why my all of my coffeeshop_id (FK) is still filled with null(s) in each employee?
17:44, Dang, I hit F5 but refreshed your video instead 😆
🤣
@@mo-chen Great course really, thank you. The thing that worries me now is that I find SQL easier than expected so far. It worries me because there is probably something that I am missing. But after learning Python for a while, I feel like SQL is on the level of HTML and CSS almost. Suddenly that Data Analyst job seems much closer than I thought, however something tells me that my overconfidence right now will bring me some pain in the future.😀
where do i find the table code to copy and paste you said is on the link below , which one ?
It's in the description at the bottom 😁
thankyou sir for this
Hi Moe! Thanks for this but whe I copy that entire cope and press run but it doesnt show the table? that should easily show the table right?
Hi the video isnt sharp enough for easy seeing of the characters . kindly work on the sharpness of the videos. thanks so much
Try adjusting your picture quality or internet connection please. The video is sharp for sure at 1080p.
I'm at 57:48, and kinda stuck INNER JOIN as it's suddenly s.coffeeshop_name,.. (I don't full understand the "alias" and how it named like that "s.coffeeshop"). It took a while before I figured it out through w3school. As a beginner, I would suggest you to go through/add this part in the future tutorial, as it's fundamental before moving on to a more complex code.
It also could be that I have no previous coding experience so it was confusing at first try LOL
Thank you so much for all the amazing work! I cant access the git repo for code. Can you please help me with that?
So I’m following along with the tutorial . When I insert the dates specifically I keep getting Error: date/time field value out of range: “29/08/2016”
Hint : perhaps you need a different “datastyle” setting.
Sql state: 22008
Character: 239
I’m using data type DATE for the hire_date definition so I don’t understand
My date style was ISO,MDY i formatted the hire dates this way and it worked.
Nice one Josh! Good job figuring it out 😁
Hi mo l had done 3projects of Excel and your project that you shared in another video now how can get just the data and do it by my self
Where do you get your tshirts? Im looking for some oversized one like the one you’re wearing and it seems like a great fit!
Funny enough you’re not the first one to ask this 😃 The brand is called Uniqlo, and they’re really affordable and good quality.