FULL SQL DATABASE COURSE | Learn SQL in 70 minutes

┋Professional Certificates┋

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

Thanks so much for taking a little time out of your day to watch this!

[dianastryzhak]

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

[bbcg]

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 🙏

[gabrielias]

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

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

[kingofaz]

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_cch]

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

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

[kennybuuuuu]

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!

[mohamedabdelmenem]

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)

[Svgcibay]

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

[lenheimsy]

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

[thebook]

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.

[mariannedelarosa]

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

[lifeviz]

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

[Mikoaj-iegt]

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

[Anj-dhmc]

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.

[johnadoga]

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

[michaelkirkby]

Thank you very much fior a succinct and informative demonstration.

[zhouyangh]

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

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