• views: 26
• date: 1 May 2025
• posted by: AD-TEAM

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

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 OverviewModule 1: IntroductionGet an overview of the course, its structure, and what you'll achieve by the end.Module 2: Setting Up Your Development EnvironmentInstall 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 ORMLearn 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 DataWork 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 EfficientlyRetrieve records using all(), values(), only().Implement dynamic filtering with query parameters & URL paths.Handle sorting, pagination, and duplicate removal.Module 6: Advanced Filtering & Query OptimizationUse 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 RelationshipsPerform 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 & GroupingCount, 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!

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 32 Partial Updates 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 dаta: all()

Lecture 41 Retrieving dаta: values()

Lecture 42 Retrieving dаta: 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




   
   
   

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

Related news:

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.