Complex SQL Query Breakdown Step By Step

[@baruchben-david4196]

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.

[@DatabaseStar]

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!

[@maxyudin]

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!

[@DatabaseStar]

Thanks for sharing, glad you found my videos helpful!

[@kvanniekerk3792]

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.

[@DatabaseStar]

Thanks for the comment! I'm glad you found it helpful. A UML diagram would also be helpful as you suggested.

[@WestCoastKop]

Fantastic tutorial, it's really helpful to understand how to break down the subqueries and visualize each table/column

[@DatabaseStar]

Thanks, glad you found it helpful!

[@punkyM637]

Thank you for all your videos!! I thoroughly enjoy them

[@DatabaseStar]

No problem, glad you like them!

[@oracle_professor]

Excellent work Database Star

[@DatabaseStar]

Thanks!

[@karthikbala3342]

The main Summing sum(ss.ts), sum(ss.tas) ... series are of no use as they are grouped by content id and only one content id is there per college_id , like a one to one mapping so there is no 2 content id to get another sum in the main query apart from the summation of total submission or views and the summation. Also the condition sum(ss.ts) 0 ... series is not needed instead we can say ss.ts 0... ... as ts,tas,tv,tuv all already represents sum of total submission or views. Please let me know if my understanding is correct.

[@DatabaseStar]

That's a good point! I believe that could work.

[@attaullahkhan2504]

Kindly make more videoa like this... thanks in advance.

[@DatabaseStar]

Thanks, sure I can do that.

[@kumarmv-lo1rm]

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.

[@DatabaseStar]

Glad it's helpful! Sure I can do one with a with clause, unions, and joins.

[@patyue5012]

Nice content! Thanks.

[@DatabaseStar]

Glad you like it!

[@ai-oo9ls]

i just started learning sql, i want to ask when should i use procedure ?

[@DatabaseStar]

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.

[@Learn_IT_with_Azizul]

very important content but sound is so low... plz have a look. ty

[@DatabaseStar]

The sound seems fine in this video when i compare it to other videos on KZbin. My older videos had low sound because my old microphone but this one should be OK.

[@rustyspottedcat8885]

Its all about ... sets of all sets ... that doesnt contain themselves.

[@DatabaseStar]

That's a good point!

[@KUMAR-q3o2q]

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

[@DatabaseStar]

I'm not sure I fully understand the issue, but I think you could join the two tables together based on common values.

[@sabuein]

Thank you.

[@DatabaseStar]

You're welcome!

[@jorso163]

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

[@DatabaseStar]

I'm not sure why that would be happening. I assume it's something that should happen by default.