filmov
tv
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:
📌 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
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
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
Django - Subquery, OuterRef and Exists objects for Database SQL Subqueries
Django : Django subquery and annotations with OuterRef
How to Write Complicated Queries in Django With F Expressions
Django : Django QuerySet annotate with Subquery
Django : Using Subquery to annotate a Count
16. Aggregation and Annotation in Django | Advance Topic
Django : Django subquery using QuerySet
Django : Django annotate query set with a count on subquery
PYTHON : how to subquery in queryset in django?
PYTHON : Simple Subquery with OuterRef
Simple Subquery with OuterRef
Join with subquery in Django ORM (2 Solutions!!)
How to use annotate and aggregate on Django querysets
Intro to Django's Annotate
Projekt 179 – Odbočka o Django subquery
DjangoCon 2018 - Making smarter queries with advanced ORM resources
#33. Класс F, Value и метод annotate() | Уроки по Django 4
Ivaylo Donchev - Django queries optimization
Django Model Inheritance - InheritanceManager from django-model-utils
Django Full Course - 3.1 - Aggregation. Join related models and aggregate
#35. Группировка записей. Вычисления на стороне СУБД | Уроки по Django 4...
Django : Django Prefetch with custom queryset which uses managers method
Django Aggregation & Annotation / values() and values_list() functions
Django : Django Queryset only() and defer()
Комментарии