Django - Subquery, OuterRef and Exists objects for Database SQL Subqueries

In this video, we'll look at Subqueries in Django. We'll see how to use subqueries in annotations, filter statements and with the Exists subclass.
Subqueries can be useful for performing these operations on complex related information, and can exist in the SELECT and WHERE expressions (among others) of an SQL SELECT Query.
☕️ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲:
To support the channel and encourage new videos, please consider buying me a coffee here:
ko-fi.com/bugb...
📌 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
00:00 Intro
00:58 Subqueries in SQL
04:48 Writing Subqueries with Django
16:58 Exists subqueries in Django
▶️ Full Playlist:
• Django ORM Deep Dive
𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:
📖 Blog: bugbytes.io/po...
👾 Github: github.com/bug...
🐦 Twitter: / bugbytesio
📚 𝗙𝘂𝗿𝘁𝗵𝗲𝗿 𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗮𝗻𝗱 𝗶𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻:
Django Subqueries: docs.djangopro...
Django Exists object: docs.djangopro...
#python #django #webdevelopment #database #sql

[@bugbytes3923]

ORM Playlist link: ua-cam.com/video/EsBqIZmR2Uc/v-deo.html

[@oizik]

I'm honestly going to cancel my Netflix account, this whole series is just brilliant! Thank you

[@bugbytes3923]

Thanks so much! Really glad to hear you're enjoying it!

[@shivpratapraj900]

Absolutely enjoying your Django series videos. Please keep uploading this type of video.

[@bugbytes3923]

Thanks a lot, will do!

[@user-jv1uz3pn5s]

"... and we are going to see how to build up nasty select statements ..." 🤣
Pumped already for the rest of the video! Great!!

[@seydinaoumarsamabaly1806]

I think I had underestimated the extent of the power of django orm. Just wow. Thank you so much Master !!!

[@bugbytes3923]

The ORM is so powerful! Thanks as always!

[@Septumsempra8818]

Finally!!! Copilot has been using a lot of Subqueury and OuterRef in code suggestions, but I'm too dumb to understand django docs when i try read up for myself. Thanks for clarifying.

[@bugbytes3923]

Thanks a lot!

[@briancbarrow]

Thanks for these videos! They are very helpful!

[@bugbytes3923]

Thanks a lot Brian, glad to hear they've been useful!

[@khunjohn1054]

I did not know that you could use Exists as filter parameters. This is powerful when you have multi relational structures. One of my projects are heavily based on many to many related to other many to many tables. Again, as usual, great video. Much appreciated.

[@bugbytes3923]

Thanks - filter + Exists() is a very powerful technique, agreed! Thanks a lot for the support.

[@Dorso2009]

Great video as always! Thank you!

[@bugbytes3923]

Thanks a lot!

[@sscapture]

Great!!

[@bugbytes3923]

Thanks a lot!

[@dmitrymikhailovnicepianomu8688]

Priceless!

[@bugbytes3923]

Thank you Dmitry!

[@repotranstech9614]

Cool video as always.Thanks.

[@bugbytes3923]

Thanks a lot!

[@JustPython]

Nice video

[@bugbytes3923]

Thank you!

[@acronproject]

Thanks for this. very useful

[@bugbytes3923]

Thanks for watching!

[@aashayamballi]

thank you!

[@frameff9073]

thank you

[@bugbytes3923]

You’re welcome thanks for watching !

[@frameff9073]

@@bugbytes3923 help me learn htmx-swap-oob Pls 😂

[@endfine9230]

I Came Looking For Copper And I Found Gold

[@bugbytes3923]

Thanks! Nice comment :)

[@coinermk]

Pls sir iam trying all that i can ti see that. i create chat home like for whatsapp. to see the list of people we chat and ordered by their last message tome or from me. pls help me with the algorithm. or if you can help me with the logic in my views

[@Parthshukla759]

Hi sir I am a software dev with 2 yoe,
Is there a way to contribute to your channel, Thanks.