Awesome tutorial, crystal clear and concise. Finally someone gave a detailed account of the joins and how to address the potential caveats assotiated with. Well done
I have recently been very interested in data science. Must say that this video is highly requested since many beginners struggle with JOINS. Thank you :)
Great video thanks. I have no prior experience of coding but would love to transition into business analytics from sales but often feel as I’m 30, it’s probably too late to learn
I like your other SQL videos. The explanation of the first type of join in this video was clear, but I think that the rest are too fast for most people who don't know them already.
One thing that I thought was potentially confusing in the 3 table join example: a given order# has multiple rows in the order table, each with it's own quantity and amount. When adding return status, it seems to me you'd therefore need to know which row of the order is being returned. If an order can only be returned in total, that strikes me as ambiguous. The visual earlier in the video has row_ID in both tables, but it appears those are not common. There's further evidence of this when seeing the returns table only has consecutive row_IDs and does not have repeats of the order#. From that, I'm gathering that orders are returned only in total (e.g. all rows hit with the return). If true, I find it's confusing to have orders returned in a manner (all rows) which is different from how the order seems to work (each row of the order can have individual characteristics). I didn't see anything in the video that specifies that distinction (all or nothing vs partial return) -apologies if I missed it or there's some other aspect I misunderstood. Btw, really enjoy these videos and how concise they are. Thanks.
Good observation. Bear in mind that this is just dummy data, not real world, but I do take your point. In this case, the returns data only contains an Order_id so that's all we've got to play with. I didn't create this data set BTW. FYI each table will (or at least should) have its own row id so this is normal but they are not related to each other. I'm really happy to hear you're liking the content, more to come soon. Do you have any suggestions for new videos?
do you have any recommendations for free SQL certifications that would look good on a resume for an industrial engineer with 1 year of manufacturing experience and 1 year of database programming experience?
@@LearnBI So should i be making my own small scale projects? In college I made a small scale healthcare database for class, but i dont have access to it anymore.
Yes, you need a portfolio of projects that showcase your talents and understanding of analytics. I’ve create a project on the channel: Data Analyst Portfolio Project - SQL | Step-by-Step Guide From SQL Database to Interactive Dashboard ruclips.net/video/0rB_memC-dA/видео.html
⬇️ START YOU BI JOURNEY HERE ⬇️
🔥 GET THE ULTIMATE GUIDE TO GOOGLE DATA STUDIO 🔥
HEAD ON OVER TO geni.us/datastudiocourse
In which playlist this video is?
Awesome tutorial, crystal clear and concise. Finally someone gave a detailed account of the joins and how to address the potential caveats assotiated with. Well done
I have recently been very interested in data science. Must say that this video is highly requested since many beginners struggle with JOINS. Thank you :)
Thanks for the feedback. Very happy to help!
That was excellent -- you just helped me loads with this video. Thanks mate!
Great to hear!
Great video thanks. I have no prior experience of coding but would love to transition into business analytics from sales but often feel as I’m 30, it’s probably too late to learn
Thanks for the feedback. I didn't start in BI until my 30s so it's definitely not too late!
very clear and short, thank you very much!
You're welcome!
Very insightful for me as a person reskilling to BI
Thanks for the feedback, I'm glad you found it helpful!
I like your other SQL videos. The explanation of the first type of join in this video was clear, but I think that the rest are too fast for most people who don't know them already.
Sorry it wasn't clear for you but hopefully it made you want to find out more. There are loads of videos on RUclips that will go into more detail.
Thank you.
You’re welcome!
One thing that I thought was potentially confusing in the 3 table join example: a given order# has multiple rows in the order table, each with it's own quantity and amount. When adding return status, it seems to me you'd therefore need to know which row of the order is being returned. If an order can only be returned in total, that strikes me as ambiguous. The visual earlier in the video has row_ID in both tables, but it appears those are not common. There's further evidence of this when seeing the returns table only has consecutive row_IDs and does not have repeats of the order#. From that, I'm gathering that orders are returned only in total (e.g. all rows hit with the return). If true, I find it's confusing to have orders returned in a manner (all rows) which is different from how the order seems to work (each row of the order can have individual characteristics).
I didn't see anything in the video that specifies that distinction (all or nothing vs partial return) -apologies if I missed it or there's some other aspect I misunderstood.
Btw, really enjoy these videos and how concise they are. Thanks.
Good observation. Bear in mind that this is just dummy data, not real world, but I do take your point. In this case, the returns data only contains an Order_id so that's all we've got to play with. I didn't create this data set BTW.
FYI each table will (or at least should) have its own row id so this is normal but they are not related to each other.
I'm really happy to hear you're liking the content, more to come soon. Do you have any suggestions for new videos?
In roughly 2:10 you are presenting 2 tables LEFT(Orders) and RIGHT(Managers).
How do you know which one of these two is LEFT and which one is RIGHT?
The Left table is the first table in the select. Got it!
You got it!
Why is returns in the Select area blue?
Have you got a time stamp for me so I know what I should be looking at?
great video...where to find this excel fie:) thanks
I found the excel document
Too much stocks video fillers, not enough area highlight & visual demonstration with the teaching speech. However, good content
Noted!
I'm so grateful for the SQL tutorial video. Thank you for sharing your knowledge. 😊📹💾
do you have any recommendations for free SQL certifications that would look good on a resume for an industrial engineer with 1 year of manufacturing experience and 1 year of database programming experience?
Free SQL certifications aren't going to get you a job. A project portfolio will.
@@LearnBI So should i be making my own small scale projects? In college I made a small scale healthcare database for class, but i dont have access to it anymore.
Yes, you need a portfolio of projects that showcase your talents and understanding of analytics. I’ve create a project on the channel: Data Analyst Portfolio Project - SQL | Step-by-Step Guide From SQL Database to Interactive Dashboard
ruclips.net/video/0rB_memC-dA/видео.html
@@LearnBI awesome, ill check out the video. Thank you for the help!