Django Drf Orm Query Fundamentals

Django Drf Orm Query Fundamentals
Published 3/2025
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

Master database interactions and queries in Django with DRF & PostgreSQL.
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.

Requirements

No programming experience required

Description

Overview

Section 1: Introduction

Lecture 1 Course Introduction

Section 2: Preparing For Development

Lecture 2 Module Primer

Lecture 3 New Developers Guide: VSCode for Windows & MacOS
Lecture 4 Project VSC settings, Linting and Formatting Setup

Lecture 5 New Developers Guide: Docker Desktop

Lecture 6 Creating a PostgreSQL and Django Service with Docker

Lecture 7 Creating a new Django DRF Project within Docker

Section 3: Fundamentals – Building Database Tables

Lecture 8 Module Primer

Lecture 9 Introducing the Database Schema and ERD (Entity Relationship Diagram)

Lecture 10 Defining Database Tables with Django Models

Lecture 11 Common Data Types (Strings, Numbers, Boolean)

Lecture 12 Date and Time Fields

Lecture 13 Required, Null and Blank Fields

Lecture 14 Default Values

Lecture 15 Unique Values

Lecture 16 Creating Primary Keys

Lecture 17 Creating Foreign Keys

Lecture 18 On-Delete Behaviour

Lecture 19 Defining Many-To-Many Relationships

Lecture 20 Creating a One-to-One Relationship

Lecture 21 Final Model Implementation

Lecture 22 Django Admin – Registering Django Models

Lecture 23 Exporting the Django Database as SQL

Lecture 24 Automating Database Tables – PostgreSQL Initialisation Script

Section 4: Fundamentals – Inserting, Updating and Deleting Data

Lecture 25 Module Primer

Lecture 26 Django DRF View Options

Lecture 27 Introduction to API Request Cycle

Lecture 28 Introducing Viewsets and Serializers

Lecture 29 Inserting Data with Create and Save

Lecture 30 Bulk insert with Bulk Create

Lecture 31 Updating Existing Records with Save()

Lecture 33 Handling Simple One-to-Many Inserts

Lecture 34 Handling One-to-One Insert with Nested Serializers

Lecture 35 Handling Many-to-Many Inserts

Lecture 36 Deleting Records

Lecture 37 Delete Bulk Records with Custom Action
Lecture 38 Building & Automating Initial Database Seed Data

Section 5: Fundamentals: Querying the Database

Lecture 39 Module Primer

Lecture 40 Retrieving Data: all()

Lecture 41 Retrieving Data: values()

Lecture 42 Retrieving Data: only()

Lecture 43 Filtering Records with filter()

Lecture 44 3 Approaches for Passing Data to Server

Lecture 45 Dynamic Filtering with Query Parameters

Lecture 46 Dynamic Filtering with URL Path Parameters

Lecture 47 Using Exclude

Lecture 48 Sorting Results with .order_by() (ASC/DESC)

Lecture 49 Retrieving the First and Last Record

Lecture 50 Implementing Django REST Framework pagination

Lecture 51 Removing Duplicates Records with .distinct()

Section 6: Fundamentals: Filtering

Lecture 52 Module Primer

Lecture 53 Using Logical Operators AND with Q Objects

Lecture 54 Using Logical Operators OR with Q Objects

Lecture 55 Using Logical Operators NOT with Q Objects

Lecture 56 Comparison Operators

Lecture 57 Pattern Matching

Lecture 58 Using in for List Filtering

Lecture 59 Using Range for Value Ranges

Lecture 60 Limiting with List Slicing

Section 7: Fundamentals: Joins, Querying Relationships

Lecture 61 Module Primer

Lecture 62 SQL Inner Join

Lecture 63 Django ORM Inner Join with One-to-Many Relationships

Lecture 64 Aliases with Annotate and F Expressions

Lecture 65 Reverse Query One-to-Many Relationships

Lecture 66 Inner Join for One-to-One Relationships Forward

Lecture 67 Inner Join for One-to-One Relationships Reverse

Lecture 68 Raw SQL and RawQuerySet Inner Join Example

Lecture 69 Many-to-Many Relationships with Prefetch_Related

Section 8: Fundamentals: Aggregation and Grouping

Lecture 70 Module Primer

Lecture 71 Counting Records with Count

Lecture 72 Summing Values with Sum

Lecture 73 Calculating Averages with AVG

Lecture 74 Using Group By to Aggregate Data

Lecture 75 Filtering Aggregated Results with Having

Lecture 76 Finding Min and Max Values

Lecture 77 F Field-to-Field Comparisons and Calculations

Anyone looking to learn Django DRF