Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Django DRF ORM Query Fundamentals

Name: Django DRF ORM Query Fundamentals
Rating: 4.6 (20 reviews)

Learn Django DRF and master database interactions and queries in Django with DRF & PostgreSQL.

Created byVery Academy

Last updated 6/2025

English

What you'll learn

Design and implement relational database tables using Django ORM.
Define models, relationships (One-to-One, One-to-Many, Many-to-Many), and constraints.
Understand and apply primary keys, foreign keys, and unique constraints.
Perform CRUD (Create, Read, Update, Delete) operations efficiently with Django ORM.
Handle bulk inserts, bulk updates, and nested relationships in Django REST Framework.
Implement automated database seeding for initial project setup.
Retrieve data efficiently using all(), values(), only(), filter(), and other ORM methods.
Implement dynamic filtering using query parameters & URL paths in DRF.
Apply ordering, pagination, and duplicate removal for API performance.
Write complex queries using Q Objects, logical operators (AND, OR, NOT), and range filters.
Optimize queries with select_related and prefetch_related for better performance.
Perform SQL JOINs and understand how Django ORM translates them into queries.
Use raw SQL queries and custom querysets when necessary.
Perform COUNT, SUM, AVG, MIN, MAX operations in Django ORM.
Use GROUP BY & HAVING for advanced query results.
Compare field values dynamically with F Expressions.
Implement Django REST Framework serializers, viewsets, and API endpoints.
Handle nested relationships in serializers for complex data structures.
Expose database queries via optimized API endpoints.

Course content

8 sections • 84 lectures • 10h 27m total length

Course Intro0:52

Module Primer2:37
New Developers Guide: VSCode for Windows & MacOS9:44
Project VSC settings, Linting and Formatting Setup5:46
New Developers Guide: Docker Desktop10:48
Learn to use Docker Desktop to create consistent development environments with images, containers, and volumes, enabling quick spin up, teardown, and safe data persistence for apps.
Creating a PostgreSQL and Django Service with Docker16:48
Creating a new Django DRF Project within Docker13:32

Module Primer1:54
Introducing the Database Schema and ERD (Entity Relationship Diagram)6:11
Explore how an entity relationship diagram visualizes a database schema, detailing one-to-many, one-to-one, and many-to-many relationships with through tables, and use it to guide Django model design.
Defining Database Tables with Django Models2:35
Common Data Types (Strings, Numbers, Boolean)6:26
Date and Time Fields3:23
Explore Django date and time fields, including date, time, and datetime types, with auto_now and auto_now_add for created and updated timestamps, plus practical use cases and examples.
Required, Null and Blank Fields5:02
Default Values2:51
Define and apply default values for database fields to ensure consistency and meaningful data, using examples like integer defaults and boolean defaults, guided by data dictionary and business requirements.
Unique Values2:18
Creating Primary Keys1:40
Creating Foreign Keys6:09
On-Delete Behaviour6:21
Learn how Django's on delete behavior governs what happens to child records when a parent is deleted, covering cascade, set null, set default, do nothing, protect, and restrict.
Defining Many-To-Many Relationships4:39
Creating a One-to-One Relationship3:29
Final Model Implementation4:05
Implement final Django models by adding string representations, enforce unique together on the order and product link table, and introduce a quantity field to prevent duplicates.
Django Admin - Registering Django Models16:59
Exporting the Django Database as SQL6:00
Learn how to export your Django database as SQL to initialize PostgreSQL, using manage.py sqlmigrate to generate table creation scripts, save to a file, and prepare Docker-based setups.
Automating Database Tables - PostgreSQL Initialisation Script17:47
Connect Django to a Postgres database and automate table creation with a dockerized init script, enabling automatic schema setup, migrations, and admin user creation.

Module Primer2:44
Django DRF View Options8:43
Introduction to API Request Cycle6:18
Understand how a client request travels through the API: from HTTP methods and URL routing to viewset endpoints, server processing, database queries, and returning a JSON response.
Introducing Viewsets and Serializers25:19
Inserting Data with Create and Save23:10
Learn to insert data in django drf with create and save inside a viewset, using a serializer to validate input and return 201 created or 400 bad request.
Bulk insert with Bulk Create9:22
Updating Existing Records with Save()5:03
Learn how to update existing records with save in Django DRF by retrieving a record by primary key, validating with a serializer, and applying updates via the update endpoint.
Partial Updates with Save()2:48
Handling Simple One-to-Many Inserts4:18
Handling One-to-One Insert with Nested Serializers32:40
Handling Many-to-Many Inserts15:36
Deleting Records9:56
Delete Bulk Records with Custom Action12:38
Building & Automating Initial Database Seed Data10:39

Module Primer2:02
Retrieving Data: all()17:05
Learn how to use Django ORM and DRF to fetch all records with the all() method, serialize results to JSON, and expose a category endpoint while logging SQL queries.
Retrieving Data: values()9:24
Retrieving Data: only()4:29
Filtering Records with filter()7:00
3 Approaches for Passing Data to Server9:36
Dynamic Filtering with Query Parameters7:25
Learn to implement dynamic filtering with query parameters in Django DRF, including an endpoint that uses the active query parameter to filter categories by is_active true or false.
Dynamic Filtering with URL Path Parameters5:07
Using Exclude2:47
Learn how Django DRF ORM uses exclude to filter queries by omitting records that match a condition, the opposite of filter, with examples using is_active and slug fields.
Sorting Results with .order_by() (ASC/DESC)5:58
Retrieving the First and Last Record4:17
Implementing Django REST Framework pagination10:46
Removing Duplicates Records with .distinct()5:40
Django ORM Challenges1:07
Tackle Django ORM query challenges to test and sharpen your Django query skills, following along step by step with a Docker-based setup and downloadable source code.
Challenge 1_1 - Retrieve All Active Products Only3:10
Challenge 1_2 - Select Product Names and Prices Only (QuerySet)2:26
Challenge 1_3 - Get the First Product Created2:32
Challenge 1_4 - Get the Most Recently Added Product2:52
Challenge 1_5 - Retrieve All Exclude Active Products2:50
Challenge 1_6 - Filter Products by Price and Category2:52

Module Primer1:48
Using Logical Operators AND with Q Objects11:00
Using Logical Operators OR with Q Objects2:19
Using Logical Operators NOT with Q Objects8:49
Comparison Operators5:36
Pattern Matching6:12
Explore Django ORM pattern matching with contains, icontains, and startswith to filter text fields, note case sensitivity, and learn indexing and trigram/full-text search tips for large datasets.
Using in for List Filtering3:22
Using Range for Value Ranges4:24
Limiting with List Slicing5:32

Module Primer2:09
SQL Inner Join7:55
Django ORM Inner Join with One-to-Many Relationships24:03
Aliases with Annotate and F Expressions3:52
Reverse Query One-to-Many Relationships14:42
Inner Join for One-to-One Relationships Forward8:04
Inner Join for One-to-One Relationships Reverse6:20
Query the reverse side of a one-to-one relationship in Django DRF by using a related name, serializers, and select_related to return only products with related stock via an inner join.
Raw SQL and RawQuerySet Inner Join Example8:59
Many-to-Many Relationships with Prefetch_Related15:27
Explore many-to-many relations with a through table between product and promotion events, using prefetch_related to optimize cross-table data retrieval and inner-join-like behavior in Python with Django serializers and reverse relations.

Module Primer1:34
Develop aggregation and grouping in Django DRF to summarize data with count, sum, average, min, max; apply group by and having to filter groups and improve reporting speed.
Counting Records with Count14:36
Summing Values with Sum10:18
Explore the Django ORM sum function across models, using values, annotate, and aggregate to compute total prices and order costs with F expressions.
Calculating Averages with AVG4:25
Learn how to calculate averages in Django DRF ORM with the average function, including per-category averages using annotate, and how Django uses group by behind the scenes.
Using Group By to Aggregate Data8:18
Filtering Aggregated Results with Having2:02
Finding Min and Max Values3:52
Learn to use Django ORM min and max to compute overall and per-category price ranges, annotate results, and order by id, with serializer fields for min price and max price.
F Field-to-Field Comparisons and Calculations5:18

Requirements

No programming experience required

Description

This course is designed to help you master Django ORM (Object-Relational Mapping) and Django REST Framework (DRF) to build scalable, database-driven APIs. You’ll start from the fundamentals of database design and queries and progress to advanced filtering, joins, and optimizations—all while integrating with DRF to expose your data through APIs.

Course Overview

Module 1: Introduction

Get an overview of the course, its structure, and what you'll achieve by the end.

Module 2: Setting Up Your Development Environment

Install and configure VSCode, Docker, and PostgreSQL.
Set up Django + DRF in a Dockerized environment for real-world development.

Module 3: Defining Database Tables with Django ORM

Learn how to define models, relationships (One-to-Many, Many-to-Many, One-to-One), and constraints.
Work with common data types like strings, numbers, and booleans.
Implement primary keys, foreign keys, and unique constraints.
Automate database table creation with PostgreSQL initialization scripts.

Module 4: Inserting, Updating, and Deleting Data

Work with ViewSets and Serializers to insert, update, and delete records via DRF.
Learn bulk operations, nested inserts, and handling related objects.
Automate database seeding for quick project setup.

Module 5: Querying the Database Efficiently

Retrieve records using all(), values(), only().
Implement dynamic filtering with query parameters & URL paths.
Handle sorting, pagination, and duplicate removal.

Module 6: Advanced Filtering & Query Optimization

Use Q Objects for complex queries (AND, OR, NOT).
Apply pattern matching, range filters, and logical operators.
Optimize queries using list slicing and efficient filtering techniques.

Module 7: Joins & Querying Relationships

Perform INNER JOINs using Django ORM.
Use prefetch_related and select_related for query optimization.
Write raw SQL queries when ORM isn’t enough.

Module 8: Aggregation & Grouping

Count, sum, and average values efficiently.
Use GROUP BY, HAVING, and field-to-field comparisons for advanced analytics.

Why Take This Course?

Build real-world, scalable APIs using Django DRF & PostgreSQL.
Master Django ORM to work with databases effectively.
Optimize queries for performance and scalability.
Learn best practices for structuring DRF applications.

Who is this for?

Developers new to Django DRF and ORM.
Backend engineers looking to optimize query performance.
Anyone who wants to build efficient, scalable REST APIs.

By the end of this course, you'll be confident in designing and querying databases while building production-ready Django REST APIs!

Who this course is for:

Anyone looking to learn Django DRF

Django DRF ORM Query Fundamentals

What you'll learn

Explore related topics

Course content

Introductions1 lecture • 1min

Preparing For Development6 lectures • 59min

Fundamentals - Building Database Tables17 lectures • 1hr 38min

Fundamentals - Inserting, Updating and Deleting Data14 lectures • 2hr 49min

Fundamentals: Querying the Database20 lectures • 1hr 49min

Fundamentals: Filtering9 lectures • 49min

Fundamentals: Joins, Querying Relationships9 lectures • 1hr 32min

Fundamentals: Aggregation and Grouping8 lectures • 50min

Requirements

Description

Who this course is for: