FULL SQL DATABASE COURSE | Beginner to Intermediate in 1 Hour

Подписаться 97 тыс.

Просмотров 123 тыс.

50% 1

┋Resources to take your data analytics skills to the next level┋
Ultimate Data Roadmap: Learn applicable data skills that you can actually use in your workplace in 30 days ➡ mochen.info/ultimate-data-roa...
Ultimate Data Portfolio: Learn how to create an outstanding data portfolio in 3 hours ➡ mochen.info/ultimate-data-por...
1:1 Mentorship: Learn how to advance your career ➡ mochen.info/1-1-mentorship-lp/
Analyst Fundamentals Test: Find out your score in 10 minutes ➡ mochen.info
CourseCareers: Start the FREE Data Analytics Introduction Course Now ➡ coursecareers.com/a/mochen?co...
Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau and Python ➡ • Portfolio Projects
┋Community & Socials┋
/ discord ⬅ Join our Discord Data Community
/ mo_chen1 ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well
/ mo-chen1 ⬅ Daily tips & advice on how to enhance your data analysis skills
/ mo_chen_1 ⬅ Figuring out what I want to do in this space...
┋Professional Certificates┋
CourseCareers ➡ coursecareers.com/a/mochen
Google Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Google Advanced Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Tableau Business Intelligence Professional Certificate ➡ imp.i384100.net/TableauBIAnalyst
Microsoft Power BI Data Analyst Professional Certificate ➡ www.coursera.org/professional...
IBM Data Science Professional Certificate ➡ imp.i384100.net/IBMdataScience
Google Project Management Professional Certificate ➡ imp.i384100.net/GoogleProject...
┋Timestamps┋
00:00 Course outline
03:11 Databases
06:27 Queries, tables and keys
09:39 Windows postgreSQL installation
11:48 MacOS postgreSQL installation
13:54 CREATE TABLE
20:58 INSERT INTO
24:37 SELECT, WHERE, AND & OR
28:49 IN, NOT IN, IS NULL, BETWEEN
32:32 ORDER BY, LIMIT, DISTINCT and Renaming columns
35:09 EXTRACT
36:21 UPPER, LOWER, LENGTH, TRIM
38:30 Concatenation, Boolean expressions and Wildcards
43:02 SUBSTRING, POSITION, COALESCE
46:11 MIN, MAX, AVG, SUM & COUNT
48:16 GROUP BY & HAVING
52:05 CASE (with GROUP BY and for transposing data)
56:18 JOIN & UNION
1:02:31 Subqueries
1:07:15 Bonus - 30 day moving total
1:09:34 Outro
┋Files┋
Github repo for code ➡︎ github.com/mochen862/full-sql...
Install pgAdmin (Windows & Mac) ➡︎ www.postgresql.org/download/
Thanks so much for taking a little time out of your day to watch this!

Опубликовано:

1 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 251

@bbcg0420 7 месяцев назад

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 🙏

@dianastryzhak6392 Месяц назад

I love the video! It is a change of scenery after boring SQL classes at uni! Can't wait for the new one :)

@alvocommunity1940 3 месяца назад

Very goog lesson, Mo Chen!!! I'm brazilian beginner in SQL.

@stluke324 3 месяца назад

Thanks Mo. Watched this before I did a certification course in Coursera and it was a breeze. Thanks again!

@goodboyvincenzo Год назад

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!

@mo-chen Год назад

Hey Larissa 👋 Thanks so much for watching! I will for sure make an advanced SQL course, hopefully soon rather than later 😃

@kingofaz2011 Месяц назад

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.

@lester_cch9877 2 месяца назад

Thank you so much for your tutorial. You don't know hou much this helps me in my professional carreer. Best!

@Svgcibay 7 месяцев назад

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

@michaelkirkby6306 3 месяца назад

Thank you very much fior a succinct and informative demonstration.

@asafzilberberg6648 4 месяца назад

Great tutorial - thank you

@lenheimsy 9 месяцев назад

This is very helpful! Thanks for putting this all out! ❤

@mo-chen 9 месяцев назад

I’m glad you liked it! Thanks for watching 😃

@sandipkadam6041 23 дня назад

Very nice explanation.... Great 👍

@theretroman3862 6 месяцев назад

Great one! Much appreciated!

@mo-chen 6 месяцев назад

Glad it helped! Thanks for watching 😁

@mohamedabdelmenem7810 Год назад

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)

@mo-chen Год назад

Thank you so much for watching! I really hope so too that I’ll be able to make more tutorials like this 😃

@kennylaucw 10 месяцев назад

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!

@mo-chen 10 месяцев назад

Thanks for watching, I'm glad you found the video useful 😃

@mechanosys Месяц назад

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.

@mariannedelarosa8896 Год назад

Thank you, Mo! This tutorial is awesome, you're an inspiration!

@mo-chen Год назад

Thanks so much Marianne for the kind words 😃

@ahmadrazachohan365 7 месяцев назад

Amazing work Mo! Thank you for all the hard work you put into this project. This is really quite helpful 🙏

@mo-chen 7 месяцев назад

Glad you enjoyed it!

@johnadoga9765 7 месяцев назад

Great video, it's almost everything a beginner to SQL hopes to find, thank you Mo

@mo-chen 7 месяцев назад

Glad it was helpful!

@zhouyangh6252 8 месяцев назад

What an amazing video!!! Thank you so much Mo! I couldn't wait for the next Intermediate to Advanced!

@mo-chen 8 месяцев назад

I’m glad you liked it! Hopefully I’ll get to make the intermediate and advanced soon 😃

@Mikoaj-ie6gt 10 месяцев назад

thanks Mo, this is really good reminder about SQL basics that I used for my hiring test!

@mo-chen 10 месяцев назад

I'm glad you found it useful, thanks for watching 😁

@gabby_asiedu21 7 месяцев назад

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❤

@TuMaLife Год назад

I’ve learnt more from Mo than attending actual classes… 👏🏾👏🏾

@mo-chen Год назад

I'm so glad you found the video useful, thanks a lot for watching 😄

@Dennisaj 7 месяцев назад

For real… Isn’t it sad that RU-vidrs can teach better than actual TEACHERS and they teach it for FREE!!!

@julianwilliams3721 Месяц назад

@@Dennisaj yea, I just wish recruiters would value non-college learning as much as a degree

@Anj-dh9mc Год назад

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.

@mo-chen Год назад

Hi Anj 👋 I’m glad you liked the video, thanks a lot for watching!

@thebook9695 4 месяца назад

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.

@maricruz3266 Год назад

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

@mo-chen Год назад

Thanks a lot Maricuz!

@LokeshBiradar63 9 месяцев назад

Most of the things covered in an one hour video. Thank you!

@mo-chen 9 месяцев назад

I’m glad you found it useful! Thanks a lot for watching 😃

@abdusinc2557 8 месяцев назад

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.

@mo-chen 8 месяцев назад

Great to hear! Thanks so much for watching 😁

@wvandrooge Год назад

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

@mo-chen Год назад

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 😃

@aidar7066 Год назад

Great work! Thats exactly what i needed

@mo-chen Год назад

I'm glad you liked it Aidar 😁 Thanks a lot for watching!

@fgbvibeshot9196 Год назад

Thank you for this. I will watch this now. Keep on sharing my friend - Glenn

@mo-chen Год назад

Thanks so much for watching 😃

@marcusthompson6775 11 месяцев назад

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!

@mo-chen 11 месяцев назад

Thanks so much for the kind words and for watching 😁

@annushka7778 Месяц назад

Thankyou ❤1 hour of clear information intead of 450 hours of unclear info on other platforms that only waste your time

@fk4866 11 месяцев назад

Thank you for so many visuals! Thats' what I needed for sure

@mo-chen 11 месяцев назад

I'm glad you liked the video F K! Thanks a lot for watching 😃

@newyork_life_travel Год назад

great video! thanks!

@mo-chen Год назад

Thank you for watching 😃

@tonmanntom4239 Год назад

yooo thanks 4 the work you put in this one! Cheers & keep it up 🤘😔🤘

@mo-chen Год назад

No problem at all, thank you for watching 😃

@ikhsanudin3309 Год назад

This is great! thank you Mo

@mo-chen Год назад

Thank you for watching, I’m glad you liked the video!

@joephiliph12 2 месяца назад

Excellent tutorial even if the speed is so fast......

@ablayendiaye7223 7 месяцев назад

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.

@mo-chen 7 месяцев назад

Glad it was helpful!

@ed684 8 месяцев назад

Thank you so much! You helped me learn faster for my university exam

@mo-chen 8 месяцев назад

Glad I could help! Good luck with your exam 😁

@emersonsilva4955 Год назад

Thank you so much! You are doing a great work.

@mo-chen Год назад

Thank you so much for watching Emerson!

@davidvo2722 Год назад

thank you so much. Applying to new job and have been studying all your videos!

@mo-chen Год назад

Hi David 👋 I'm glad you find the content useful! Thanks for watching 😃

@jmmj5018 7 месяцев назад

thanks for this MO. thanks for taking the time to post this and help a lot of people.

@mo-chen 7 месяцев назад

Glad it was helpful!

@jmmj5018 7 месяцев назад

@@mo-chen really grateful. 🙏😊you have simplimfied things that were quite vague to me in my other resources. Bless you more. :)

@franciscomedinav Год назад

Great tutorial!! Thank you!!!

@mo-chen Год назад

I'm glad you liked it Francisco! Thanks for watching 😃

@ChimdikeOjo-david-ml4wj Месяц назад

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😊

@Loicmartins 9 месяцев назад

Thanks you very much for your work!

@mo-chen 9 месяцев назад

Thanks so much for watching, I'm glad you liked it 😁

@ursugar_ Год назад

Thank you so much, absolutely wonderful

@mo-chen Год назад

I'm glad you liked it, thanks so much for watching 😄

@UniParse 8 месяцев назад

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.

@mo-chen 8 месяцев назад

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 😃

@timothykimari8154 4 месяца назад

thankyou sir for this

@leoCarCampos Год назад

great content Mo!

@mo-chen Год назад

Thanks a lot for watching Leonardo!

@bigbri04 6 месяцев назад

Great Video. Very useful and easy to understand.

@mo-chen 6 месяцев назад

Glad it was helpful!

@kaiokhan2837 Год назад

thank you for your time and effort amzing video , you will blow up soon !

@mo-chen Год назад

Thanks so much for watching!

@karthiksk2962 11 месяцев назад

Great content, so many topics covered in just 1 hour.

@mo-chen 11 месяцев назад

Thanks a lot for watching, I'm glad you liked it 😃

@nareshkumar-cn6jo Год назад

Great video to learn....Great work brother ....

@mo-chen Год назад

Thanks a lot for watching Naresh 😃

@amindouale829 6 месяцев назад

thank you very much...

@mo-chen 6 месяцев назад

Thanks for watching!

@The_GrowthChannel Год назад

Thank you Mo, you are doing awesome

@mo-chen Год назад

Thanks so much for sticking around on the channel 😃 I'm very glad you're still here!

@prashlovessamosa Год назад

Awesomely Explained.

@mo-chen Год назад

I'm glad you liked it Prashant 😁 Thanks a lot for watching!

@carlosfernandez6477 11 месяцев назад

Very useful video, really liked how visual everything was

@mo-chen 11 месяцев назад

That’s great, thanks so much for watching!

@johaybersarip7856 Год назад

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.

@mo-chen Год назад

I'm very glad you like the content Johayber 😄Thanks so much for watching!

@johaybersarip7856 Год назад

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

@harshadasathe6477 8 месяцев назад

Great explanationn❤❤❤❤ , You are great teacher , i am learning so much from your channel , waiting for more videos

@mo-chen 8 месяцев назад

Thank you for the kind words!

@bngleboy 9 месяцев назад

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... :)

@mo-chen 9 месяцев назад

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

@aloSolo 2 месяца назад

where do you i get the sql file to follow along?

@JoaoSantos-dg7xm Год назад

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 :)

@mo-chen Год назад

All the best with your data science journey! Thank you so much for watching 😄

@angelocastilloperz Год назад

I love your content friend, greetings from Perú.

@mo-chen Год назад

Thanks a lot for watching Angelo 😁

@kurosawa1004 9 месяцев назад

New subscriber, thank you

@mo-chen 9 месяцев назад

I’m glad you liked it, thanks for the sub 😃

@aartibarve8680 7 месяцев назад

Thank you so much for all the amazing work! I cant access the git repo for code. Can you please help me with that?

@grapefruitomega3517 Год назад

Top stuff 🎉

@mo-chen Год назад

Thank you 😃

@Zeenrialor 9 месяцев назад

Please make more videos like this on other coding language like java.. I love this.. Thanks bro..

@mo-chen 9 месяцев назад

I would love to when my time allows it 😁 Thanks so much for watching!

@008-memanishankarjha6 5 месяцев назад

Thanku Sir

@dwzard 6 месяцев назад

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?

@nav5991 Год назад

Thankyou so much... Please also cover cte and window fxns too🎉🙌

@mo-chen Год назад

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!

@ZakiXcx Год назад

great work

@mo-chen Год назад

Thanks so much for watching Zaki 😄

@valeriaholovchyk4766 Год назад

Great 🎉🎉

@mo-chen Год назад

Thank you for watching Valeria 😁

@Bee-The-Explorer Год назад

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

@mo-chen Год назад

Thanks so much for watching! It's a great video idea 😁

@rojaskhobragade4882 4 месяца назад

Plz make video on Power Bi also

@IAmLove213 8 месяцев назад

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!

@mo-chen 8 месяцев назад

Great to have you here on the channel!

@thiagonazario2145 6 месяцев назад

amazing

@mo-chen 6 месяцев назад

Glad you think so!

@robinbogwald4514 11 месяцев назад

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!

@mo-chen 11 месяцев назад

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 😁

@robinbogwald4514 11 месяцев назад

@@mo-chen Ok! Thank you for your help , and quick response! Keep up the videos, they are really good :)

@revanthrevanth6948 9 месяцев назад

16:55 When Mo turned into a Sigma!!!! and great tutorial by the.

@mo-chen 9 месяцев назад

I'm glad you liked it! Thanks a lot for watching 😁

@gabrielmaria295 Год назад

good job....

@mo-chen Год назад

Thank you for watching 😃

@rehabramadan7613 8 месяцев назад

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

@user-re4ip5ms9w 2 месяца назад

I have been using ssms, what's the difference with PostgreSQL? and will my knowledge of ssms apply to PostgreSQL?

@javelynhazeldine1847 7 месяцев назад

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

@assyifamulandar3904 3 месяца назад

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?

@zabashhd459 8 месяцев назад

You are Amazing Although i am also learnign SQL from Coursera UC Davis

@mo-chen 8 месяцев назад

Thanks a lot for watching and good luck with your sql learning 😁

@zabashhd459 8 месяцев назад

Thanks !!!!@@mo-chen

@user-re4ip5ms9w 2 месяца назад

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

@i.d.8737 7 месяцев назад

finally a hot SQL teacher

@mo-chen 7 месяцев назад

Thank you!

@monicakristin8144 5 месяцев назад

@yingwang3771 10 месяцев назад

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

@mo-chen 10 месяцев назад

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?

@heyrosanna 26 дней назад

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.

@cheuguy Год назад

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!

@mo-chen Год назад

Funny enough you’re not the first one to ask this 😃 The brand is called Uniqlo, and they’re really affordable and good quality.

@prashlovessamosa Год назад

Completed kindly make another one a Advanced one please it would be helpful.

@mo-chen Год назад

I will for sure make a course on advanced SQL queries just not exactly sure when yet 😅

@santilo76 Год назад

Wow, i have not seen it yet, but thanks in advance for your contributions to this community. Cheers Mo

@mo-chen Год назад

Thank you santilo76 😁

@weekendveda6359 Год назад

Thanks u

@mo-chen Год назад

Thanks a lot for watching!

@sportspsycho2279 8 дней назад

Where can I get this 24:26 data to put into the query..?

@Andy_TKC Год назад

Thank you Mo, luv 😊What do you think of 'Orange Data Mining'?

@mo-chen Год назад

Thanks for watching Andy! I've never used orange data mining, but just googled it and it looks fun 😄

@javelynhazeldine1847 7 месяцев назад

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) :(