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:
https://ko-fi.com/bugbytes

? ????????:
00:00 Intro
00:58 Subqueries in SQL
04:48 Writing Subqueries with Django
16:58 Exists subqueries in Django

▶️ Full Playlist:
https://www.youtube.com/playlist?list=PL-2EBeDYMIbQXKsyNweppuFptuogJe2L-

?????? ?????:
? Blog: https://bugbytes.io/posts/
? Github: https://github.com/bugbytes-io/django-orm-series
? Twitter: https://twitter.com/bugbytesio

? ??????? ??????? ??? ???????????:
Django Subqueries: https://docs.djangoproject.com/en/4.2/ref/models/expressions/#subquery-expressions
Django Exists object: https://docs.djangoproject.com/en/4.2/ref/models/expressions/#exists-subqueries

#python #django #webdevelopment #database #sql