A Guide to Django ORM | Master the Art of Querying Database
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
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
Instructor
- 4.5 Instructor Rating
- 13 Reviews
- 1,037 Students
- 1 Course
I am Full Stack developer (Django + React) who is really enthusiastic to learn, build and deploy the products. I have a good understanding of HTML, CSS, JavaScript, Python, Java. I have built various web application using Django Framework, React.js Library. Currently, I am perusing the bachelor degree in Computer Science and Engineering from India.