A Guide to Django ORM | Master the Art of Querying Database

Name: A Guide to Django ORM | Master the Art of Querying Database
Rating: 4.4 (49 reviews)

Learn about virtual environment, models, migration, meta classes, database relationships, queryset API methods in Django

Created byPrabin Baniya

Last updated 1/2022

English

What you'll learn

Creating Virtual Environment in Python and Setting Up Django Project in that virtual environment.
Writing Models in Django
Performing CRUD Operation via Django ORM
Learning about different queryset API provided by Django ORM like order_by, values, only, defer, select related, prefetch related
Getting Familiar with Q objects and F expressions

Course content

5 sections • 27 lectures • 3h 14m total length

IDE and Code Editor for Django1:18
Explore the IDEs and lightweight code editors you can use for Django projects, and learn how to download and set up the tools across different operating systems.
DB Browser For SQlite0:40
Introduction to Virtual Environment in Linux and Windows6:24
Django Project and App Setup7:31
Learn to create a single Django project and blog app, set up a virtual environment, and add category, post, and comment models with a user authentication model.

Introduction to Models6:54
Introduction to Migrations8:40
Learn how Django migrations synchronize models with the database schema by creating migration files and applying them with makemigrations and migrate.
Django Admin Panel5:36
Different Model Field Types4:39
Different Model Field Options11:12
Explore Django ORM model field options, including null, blank, default, unique, choices, max_length, primary keys, and auto fields, with practical category and post examples.
Database Relationships in Django11:42
Explore Django ORM relationships for many-to-one and many-to-many, using User, Category, and Post models, with foreign keys and cascade delete, and admin-based category assignment.
Primary Key and Verbose Field Name7:56
Model Methods9:36
Meta Options4:28
CHALLENGE : Writing Models For Comments App7:41
Build a Django ORM comments app by defining a blog post model and a comment model with a many-to-one relationship, linking comments to a user.

Database CRUD Operation - Part 121:20
Database CRUD Operation - Part 213:33
order_by, values, only, defer8:21
union, intersection, difference7:33
Performing Field Lookups9:37
Querying Database Relationships11:10
Complex Lookup Using Q objects6:29
Learn how to perform complex lookups using Q objects to combine conditions with or and and, filter comments on a post, and apply not to exclude admin comments.
F expression8:51
Master how Django ORM F expressions let you reference database fields in queries without loading them into memory, then filter posts by published on and last updated on times.
select related and prefetch related7:26
Learn how select_related and prefetch_related optimize Django ORM queries, reduce database hits, and efficiently fetch related objects like categories, users, and posts in one or few queries.
Performing Raw SQL Query2:06
Execute raw SQL queries using the Django ORM to retrieve post instances and print their titles, demonstrating how raw queries return object instances and can be iterated.

Requirements

Basics of Python
Object Oriented Programming Using Python
Database Management System [Optional]

Description

In this course, you are going to learn various concepts related to Django ORM. Django ORM is a core and powerful component of the Django Framework. Using this ORM, we can simplify the database-related operations in an object-oriented way. In this course, you are going to learn how to model for a Blogging project. The agenda is not to make a blogging site, but to teach you about what can you do with the Django ORM and what Django ORM has to offer, to make your project performant. Then, we will deep dive into querying the database which is the most important section of this course. Without knowing how to query the database, you are never going to feel confident as a Django developer. So, you will be taught different things about queryset API provided by Django ORM in order to interact with the databases. You are going to learn various methods which are used in CRUD operations. Like order_by, values, only, defer, select_related, prefetch_related, Q objects, F expressions, raw SQL query, and many more.

At the end of this course, you will get familiar with the following topics, and you can apply this learning in any Django project.

Virtual Environments
Creating and Setting up Django Project in a virtual environment
Writing Models
Migrations
Django Admin Panel
Database Relationships
Primary Key, Verbose Name
Model Methods
Meta Options
Database CRUD Operation
Using order_by, values, only, defer methods
Performing union, intersection, and difference using Django ORM
Performing field Lookups
Querying Database Relationships
About Q objects, F expression
Select Related and Prefetch Related
Performing raw SQL query
and many more

Who this course is for:

Beginner Python developer curious about web development using Django
Any developer who wants to understand how to setup Django in virtual environment.
Any django developer who wants to understand how to write models in Django.
Any django developer who want to understand how to query the database.
Any django developer who wants to understand Django ORM

A Guide to Django ORM | Master the Art of Querying Database

What you'll learn

Explore related topics

Course content

Installation and Setup4 lectures • 16min

Course Material1 lecture • 1min

Introduction to Models10 lectures • 1hr 18min

Querying the Database10 lectures • 1hr 36min

Further Study Material2 lectures • 4min

Requirements

Description

Who this course is for: