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.
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 RUclips. My older videos had low sound because my old microphone but this one should be OK.
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!
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
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 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.
Thanks very much for the kind words! That’s what I am aiming for with my videos, so it’s good to hear it’s been achieved!
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.
Thanks for the comment! I'm glad you found it helpful. A UML diagram would also be helpful as you suggested.
very important content but sound is so low... plz have a look. ty
The sound seems fine in this video when i compare it to other videos on RUclips. My older videos had low sound because my old microphone but this one should be OK.
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!
Thanks for sharing, glad you found my videos helpful!
Fantastic tutorial, it's really helpful to understand how to break down the subqueries and visualize each table/column
Thanks, glad you found it helpful!
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
I'm not sure I fully understand the issue, but I think you could join the two tables together based on common values.
Kindly make more videoa like this... thanks in advance.
Thanks, sure I can do that.
Excellent work Database Star
Thanks!
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
I'm not sure why that would be happening. I assume it's something that should happen by default.
I was looking for something like this. This really helps. Thanks.
Is it possible to do one with the with clause and unions and joins all together.
Glad it's helpful! Sure I can do one with a with clause, unions, and joins.
Its all about ... sets of all sets ... that doesnt contain themselves.
That's a good point!
i just started learning sql, i want to ask when should i use procedure ?
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.
Thank you for all your videos!! I thoroughly enjoy them
No problem, glad you like them!
Thank you.
You're welcome!
Nice content! Thanks.
Glad you like it!