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

preview_player
Показать описание
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:

📌 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
00:00 Intro
00:58 Subqueries in SQL
04:48 Writing Subqueries with Django
16:58 Exists subqueries in Django

▶️ Full Playlist:

𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:

📚 𝗙𝘂𝗿𝘁𝗵𝗲𝗿 𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗮𝗻𝗱 𝗶𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻:

#python #django #webdevelopment #database #sql
Рекомендации по теме
Комментарии
Автор

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

oizik
Автор

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

shivpratapraj
Автор

"... and we are going to see how to build up nasty select statements ..." 🤣

Pumped already for the rest of the video! Great!!

jvuzpns
Автор

Thanks for these videos! They are very helpful!

briancbarrow
Автор

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

seydinaoumarsamabaly
Автор

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.

Septumsempra
Автор

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.

khunjohn
Автор

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

coinermk
Автор

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

Parthshukla
Автор

I Came Looking For Copper And I Found Gold

endfine
visit shbcf.ru