Django DRF ORM Query Fundamentals

سرفصل های دوره

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

1 - Introduction

1 -Course Introduction

2 - Preparing For Development

1 -2.zip

1 -Module Primer

2 -New Developers Guide VSCode for Windows & MacOS

3 -Project VSC settings, Linting and Formatting Setup

4 -New Developers Guide Docker Desktop

5 -Creating a PostgreSQL and Django Service with Docker

6 -Creating a new Django DRF Project within Docker

3 - Fundamentals - Building Database Tables

1 -3.zip

1 -Module Primer

1 -erd.zip

2 -Introducing the Database Schema and ERD (Entity Relationship Diagram)

3 -Defining Database Tables with Django Models

4 -Common Data Types (Strings, Numbers, Boolean)

5 -Date and Time Fields

6 -Required, Null and Blank Fields

7 -Default Values

8 -Unique Values

9 -Creating Primary Keys

10 -Creating Foreign Keys

11 -On-Delete Behaviour

12 -Defining Many-To-Many Relationships

13 -Creating a One-to-One Relationship

14 -Final Model Implementation

15 -Django Admin - Registering Django Models

16 -Exporting the Django Database as SQL

17 -Automating Database Tables - PostgreSQL Initialisation Script

4 - Fundamentals - Inserting, Updating and Deleting Data

1 -4.zip

1 -Module Primer

2 -Django DRF View Options

3 -Introduction to API Request Cycle

4 -Introducing Viewsets and Serializers

5 -Inserting Data with Create and Save

6 -Bulk insert with Bulk Create

7 -Updating Existing Records with Save()

8 -Partial Updates with Save()

9 -Handling Simple One-to-Many Inserts

10 -Handling One-to-One Insert with Nested Serializers

11 -Handling Many-to-Many Inserts

12 -Deleting Records

13 -Delete Bulk Records with Custom Action

14 -Building & Automating Initial Database Seed Data

5 - Fundamentals Querying the Database

1 -5.zip

1 -Module Primer

2 -Retrieving Data all()

3 -Retrieving Data values()

4 -Retrieving Data only()

5 -Filtering Records with filter()

6 -3 Approaches for Passing Data to Server

7 -Dynamic Filtering with Query Parameters

8 -Dynamic Filtering with URL Path Parameters

9 -Using Exclude

10 -Sorting Results with .order_by() (ASCDESC)

11 -Retrieving the First and Last Record

12 -Implementing Django REST Framework pagination

13 -Removing Duplicates Records with .distinct()

6 - Fundamentals Filtering

1 -6.zip

1 -Module Primer

2 -Using Logical Operators AND with Q Objects

3 -Using Logical Operators OR with Q Objects

4 -Using Logical Operators NOT with Q Objects

5 -Comparison Operators

6 -Pattern Matching

7 -Using in for List Filtering

8 -Using Range for Value Ranges

9 -Limiting with List Slicing

7 - Fundamentals Joins, Querying Relationships

1 -7.zip

1 -Module Primer

2 -SQL Inner Join

3 -Django ORM Inner Join with One-to-Many Relationships

4 -Aliases with Annotate and F Expressions

5 -Reverse Query One-to-Many Relationships

6 -Inner Join for One-to-One Relationships Forward

7 -Inner Join for One-to-One Relationships Reverse

8 -Raw SQL and RawQuerySet Inner Join Example

9 -Many-to-Many Relationships with Prefetch_Related

8 - Fundamentals Aggregation and Grouping

1 -8.zip

1 -Module Primer

2 -Counting Records with Count

3 -Summing Values with Sum

4 -Calculating Averages with AVG

5 -Using Group By to Aggregate Data

6 -Filtering Aggregated Results with Having

7 -Finding Min and Max Values

8 -F Field-to-Field Comparisons and Calculations

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy