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

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

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.

1. Virtual Environments

2. Creating and Setting up Django Project in a virtual environment

3. Writing Models

4. Migrations

5. Django Admin Panel

6. Database Relationships

7. Primary Key, Verbose Name

8. Model Methods

9. Meta Options

10. Database CRUD Operation

11. Using order_by, values, only, defer methods

12. Performing union, intersection, and difference using Django ORM

13. Performing field Lookups

14. Querying Database Relationships

15. About Q objects, F expression

16. Select Related and Prefetch Related

17. Performing raw SQL query

    and many more