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)
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 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.
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 🙏
Good stuff Mo. As I was watching in a glance and I'll possibly use it as a portfolio beginner project, however I couldn't see where the dataset comes from. Cheers
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.
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.
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 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!
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.
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.
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 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. 👍👍👍👍👍👍
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.
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!!!!! 🙌🏻
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 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?
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 :)
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
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) :(
Hi Mo! Great video! I didn't quite catch how you imported the excel file to PostreSQL. Because you have to import a cvs file or something in advance to do the things you are doing in the video? Or did you make the dataset with the codes? There is something I don't understand about coding, and it's not the codes, but rather how you import your own specific data into these programs. It's possible that I have expressed myself poorly, and I apologize for that. But what I'm wondering is if you have already loaded the Excel sheet you're showing on the right side, or if you simply create the table and the data in the table. Thank you in advance!
Hi there, I didn't import any Excel files in this video. All the code is available in the github repo (create tables, insert values, and all other queries). I left the link in the description box. Thanks a lot for watching 😁
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
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.
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! Great! I'm learning a lot. Thanks for making database understanding very easy! Question, do you have these data available for your audience in any separate file (like excel or any other format) ? You guessed it, I'm thinking of copying those data and use... :)
Thanks a lot for watching! I don't have the data in Excel format, but you can easily export your tables to CSV format using postgres CLI (command line interface).
I already did 😃 Check it out here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-d_2fGS6QVDo.html&ab_channel=DataWithMo or you can see the full roadmap on my website here datawithmo.com/. Thanks a lot for watching!
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 🙏🏾
Hey Sangeet 👋 I’m not sure when I’ll be making a video on dax within power bi, so I’ll try and answer your question here for now. You should use DAX when creating measures.