Django Database ORM Mastery

Set up a lightweight, containerized Django project in Docker with PostgreSQL or MySQL via a one-command setup to prep for the ORM mastery course.

Create a docker-based development environment with Django and PostgreSQL (or MySQL) using docker compose and images. Learn container networking, volumes, and port mapping to start a Django app locally.

Create a Django project inside a docker container with docker compose, then add an inventory app, migrate to Postgres, and run uvicorn for live reload.

Explore the Django ORM by defining models in Python, managing SQL behind the scenes, and building models with field types, relationships, constraints, and configuration to shape a database schema.

Select the right Django model field types—character, text, integer, decimal, boolean, and small integer—mapped to Postgres, using max_length and decimal_places to ensure data integrity and efficiency.

Master Django uniqueness by enforcing unique on a field or via unique constraints across fields, balancing application and database level validation for data integrity.

Explore on delete options in Django ORM to manage foreign key relationships, including cascade, protect, set null, set default, and restrict, ensuring data integrity.

Explore how Django's model metaclass configures behavior beyond fields, setting default ordering, table names, verbose names, admin presentation, and constraints to streamline queries and data integrity.

Learn how to implement the dunder __str__ method in Django models to produce human readable representations, improving admin, shell, and log outputs with key fields such as category name.

Master one-to-many inserts in Django by linking products to categories with a foreign key, using either the category model instance or its id via create or save methods.

Seed your database with initial data by loading CSV files through a PostgreSQL initialization script using the copy command at container startup. Note this bypasses Django validation and signals.

Master filtering with the in lookup to match values from a list, across strings, integers, and foreign keys. Build endpoints using Q objects and get parameters to apply filters.

Master Django range filtering using the built-in range lookup to filter numeric and date ranges with inclusive bounds, and combine with Q objects for dynamic, multi-condition queries.

Explore how Django query sets use Python slicing to limit results. Learn to define start and end indices, apply ordering, and combine slicing with filtering for efficient pagination.

Learn how to centralize reusable filters with custom model managers in Django, encapsulating is_active equals true logic into a single method that returns querysets and remains ORM-friendly.

Master the Django ORM challenge to fetch the first and last five active products by id, deduplicate overlaps, and compare two query strategies including union.

Retrieve orders from the last 30 days by filtering the order model's createdat with a timezone-aware now minus 30 days, using Django utils and time delta.

Build a Django query on the product model using startswith to return products whose names begin with the capital letter W; understand default case sensitivity and the case-insensitive alternative.

Build a Django query that filters the user model by emails ending with example.com, returning their id, username, and email; note endswith is case sensitive.

Explore how to retrieve the 20th most expensive product using Django ORM by ordering by price descending, applying a zero-based slice with offset 19 and limit 1.

Explore inner and left joins and how Django's ORM traverses relationships to combine related records across tables into efficient query results.

Install django from the python package index with pip inside a virtual environment, then create a requirements file and freeze dependencies for a reproducible setup.

Learn to create a new Django project, verify the project runs, and start the development server using manage.py and the runserver command.

Learn to create a new Django app inside a Django project and distinguish the project from the app using the startapp command.

Start the Django development server using runserver on Mac OS, Linux, or Windows, access it at 127.0.0.1:8000, and understand port basics for local testing.

Connect a Django view to a new html template to render a page. Create a templates folder with index.html and have the view return an html response to the browser.

Build and run a pytest-based test to verify the category table exists in a Django app. Leverage pytest-django, configure settings, and handle import errors and automatic model validation.

Develop a structural test to validate that each table's columns and data types match the design, using pi test parameterization with Django models.

Explore how to verify nullable and not nullable fields in a django category model by writing tests that assert each field's null property against expected constraints.

Verify that the category table's slug field is unique by building a Django model test that checks the unique property for the slug and other fields, ensuring design consistency.