I have to say that your explanations are clear and informative, well-organized. Thank you. You've helped break a difficult subject into bite-sized pieces I can handle.
I'm self-taught in SQL, and I use simple queries because that's all I need to achieve my goals. But I've missed this kind of explanation in my past when I googled tutorials that were faintly intelligible and confusing. Been subscribed for a while now and have watched a couple dozen of your videos. Thanks for your work!
Brilliant explanation, thank you. I have recently started getting more invested in understanding data and how SQL works to aid that journey. Complex queries have till now intimidated me, but your explanation made perfect sense and is actually a logical yet simple way to decompose a complex query to its constituent parts. Thank you indeed. I was thinking of using a UML diagram to replace your diagram boxes as then I can see the structure clearer.
The sound seems fine in this video when i compare it to other videos on RU-vid. My older videos had low sound because my old microphone but this one should be OK.
I've got another video on using stored procedures on my channel, ("Store procedures are better than raw SQL") which has some more detail, but there are a few advantages: easier design if there are many people or applications accessing a database, better to handle complex logic that can't be done in a regular SQL statement.
I have a doubt. I have table with two fields, one field is array in table 1 uID | Contact 2 | 1221,1223 3 | 1123 Now value of 1221 and 1223 are in table Two. I want a query to join table 1 and table 2 using array of field2
Sir,when i am exporting data i couldn't see the ongoing exporting details in Oracle SQL developer like how many rows exporting is going on like this and how to enable this ,please help me