Django 4.X Orm Mastery

Learn and master building and interacting with databases within a Django project

What you'll learn
Prepare an environment ready to develop Python Django applications
@ Level 1 - Describe the underpinning role of object-relational mapping and the Django ORM
@ Level 1 – Connect Django applications to SQLite and PostgreSQL database technologies
@ Level 1 – Build Django models to model foreign keys, many-to-many and one-to-many relationships
@ Level 1 – Create and propagate changes to database tables from within a Django project
@ Level 1 – Using a variety of methods, create and save data to a database from within a Django database
@ Level 1 – Query and filter subsets of data from a database utilising a variety Queryset API features
@ Level 1 – Inspect and explore the SQL that is generated and executed by the Django ORM
@ Level 1 – Create raw SQL queries to query a database
@ Level 1 – Update single and multiple records
@ Level 1 – Select and delete records
@ Level 1 – Work with Docker to connect a Django Projects to Postgres databases hosted within a Docker container
@ Level 1 – Impliment a variety of filed lookup keywords to return subsets of data from a specified table
@ Level 1 – Impliment a variety of utility QuerySet API methods to limit and order data returned from a query
Requirements
Prior experience of using the django framework would be advantageous
Knowledge of relational database principles would be advantageous
Description
This course is designed to be an introduction to the Django Framework ORM (Object–relational mapping) through applied learning. In this course you’ll learn about the features of the Django ORM. By better understanding features of the Django ORM, you will learn how to interact with databases from within a Django project, like you would with SQL. You will learn how to administrate tables and perform common Create, Return, Update and Delete (CRUD) operations through the Django ORM. This course is designed to be an introduction to the Django Framework ORM (Object–relational mapping) through applied learning. I have collated and structured a course which I believe to be introductory Django ORM topics. You can see from the course structure that we refer to these introductory topics as level 1. There are 3 planned levels on the topic of the Django ORM, so much more to come.Django 4.x ORM Mastery series level 1. The first section of the course accommodates those who are completely new to the subject matter, you’ll learn how to prepare the working environment ready to follow along with tutorials and scaffold underpinning knowledge related to Object–relational mapping. Next, you’ll discover how to build database tables by creating Django models and propagating changes to the database through migrations. Finally, you’ll learn how to interact with the Django QuerySet API to create return update and delete data in the database.In addition to this core learning, we have embedded into the course an optional introduction to SQL. SQL is the language used to communicate with the database to perform changes. We get under the hood and learn how to create SQL to perform database operations manually.

Overview

Section 1: Django 4.x ORM Mastery

Lecture 1 Course Introduction

Lecture 2 Why learn Django ORM?

Section 2: Python Installation

Lecture 3 Section Introduction

Lecture 4 Python Installation - Mac OS

Lecture 5 Python Installation - Windows 10 or 11 OS

Section 3: Create Isolated Python Environments

Lecture 6 Section Introduction

Lecture 7 Why virtual isolate environments?

Lecture 8 Create a new Virtual Environment on MacOS

Lecture 9 Create a new Virtual Environment on Windows 10/11

Section 4: Preparing the Development Environment

Lecture 10 Section Introduction

Lecture 11 Visual Studio Code and Venv Setup on MacOS

Lecture 12 Create a new Virtual Environment on Windows 10/11

Lecture 13 VSCode Extensions used in this course

Section 5: Django ORM [Level 1] - Object Relational Mapping

Lecture 14 Section Introduction

Lecture 15 Introducing Object Relational Mapping Concept

Lecture 16 Django ORM – Models, QuerySet API and Managers

Section 6: Working with SQLite Database [Level 1]

Lecture 17 Section Introduction

Lecture 18 Introducing SQLite databases

Lecture 19 Connect an SQLite database to a Django project

Section 7: Models [Level 1] - Building Models

Lecture 20 Section Introduction

Lecture 21 Section setup guide - step-by-step

Lecture 22 Section setup guide (CodeBase-0)

Lecture 23 Database Terminology

Lecture 24 Create your first Django model

Lecture 25 Adding a string representation of a model

Lecture 26 The model verbose field name

Lecture 27 Introducing django model field types

Lecture 28 Introducing Django model field options

Lecture 29 Defining model primary keys

Lecture 30 Defining model Foreign Keys

Lecture 31 Defining one-to-one model relationships

Lecture 32 Defining Many-to-Many model relationships

Lecture 33 Introducing model meta options

Section 8: Migrations [Level 1] - Committing to the Database

Lecture 34 Section Introduction

Lecture 35 Migrate model changes to the database schema

Section 9: QuerySet API [Level 1] - Inspecting Queries & Performance Analysis

Lecture 36 Section Introduction

Lecture 37 Section setup guide - Codebase-1

Lecture 38 Inspect queries with the query attribute

Lecture 39 Inspect queries - connection and reset queries

Lecture 40 Pretty print SQL

Section 10: QuerySet API [Level 1] - Utility

Lecture 41 Section Introduction

Lecture 42 Counting returned queryset objects

Lecture 43 Conveniently View data returned in queryset objects

Section 11: QuerySet API [Level 1] - Create and Save Objects

Lecture 44 Section Introduction

Lecture 45 Section setup guide - Codebase-1

Lecture 46 Getting familiar with the database design (optional)

Lecture 47 Insert data into a single table with create()

Lecture 48 Insert data into a single table with save()

Lecture 49 Explore the difference between save() and create()

Lecture 50 SQL Insert - Executing custom SQL Inserts

Lecture 51 Insert into single table with foreign key

Lecture 52 SQL Insert - Working with datetime fields and foreign keys

Lecture 53 Insert data into a single table with a many-to-many relationship

Lecture 54 SQL Insert – Working with many-to-many relationships

Lecture 55 Insert data into multiples tables & using atomic operations

Lecture 56 Insert data into a single table with a one-to-one relationship

Lecture 57 Insert multiple objects into single table – bulk create

Lecture 58 Query Profiling – bulk_create() vs create() performance analysis

Lecture 59 Creating and automating a set of Django Fixtures

Section 12: QuerySet API [Level 1] - Retrieving objects

Lecture 60 Section Introduction

Lecture 61 Section setup guide (Codebase-2)

Lecture 62 Return all objects from a single table – all()

Lecture 63 SQL – Return all objects from a single table

Lecture 64 Retrieving single objects from a single table – get()

Lecture 65 SQL – Return single objects from a single table

Lecture 66 Filter & Exclude - Retrieving specific objects

Lecture 67 SQL – Filter retrieving objects – filter()

Lecture 68 Retrieve objects from multiple tables through a foreign key relationship

Lecture 69 SQL - Retrieve objects foreign key relationship

Lecture 70 Retrieve objects from multiple tables through a one-to-one relationship

Lecture 71 Retrieve objects from multiple tables through a many-to-many relationship

Section 13: QuerySet API [Level 1] - Update Fields/Records

Lecture 72 Section Introduction

Lecture 73 Section setup guide (Codebase-2)

Lecture 74 Modify existing data for a specified record in a table

Lecture 75 Implementing update_or_create()

Lecture 76 bulk_update records in a single table

Section 14: QuerySet API [Level 1] - Delete Records

Lecture 77 Section Introduction

Lecture 78 Section setup guide (Codebase-2)

Lecture 79 Delete single and multiple objects

Section 15: Working with PostgreSQL Database [Level 1]

Lecture 80 Section introduction

Lecture 81 Docker introduction

Lecture 82 Installing Docker MacOS

Lecture 83 Installing Docker Desktop for Windows 10/11

Lecture 84 Create a Postgres Docker container

Lecture 85 Configuring Django to work with a PostgreSQL database

Section 16: QuerySet API [Level 1] - Field lookup keywords arguments

Lecture 86 Section Introduction

Lecture 87 Section setup guide (Codebase-3)

Lecture 88 Field lookups

Lecture 89 Field lookup contains

Lecture 90 Field lookup with greater or less than

Lecture 91 Field lookup with start or end with

Lecture 92 Field lookup range

Lecture 93 Field lookup Day Week Month

Section 17: QuerySet API [Level 1] - QuerySet Ordering and Limiting

Lecture 94 Section Introduction

Lecture 95 Section setup guide (Codebase-3)

Lecture 96 Ordering a new QuerySet

Lecture 97 Reverse the output of a new QuerySet

Lecture 98 Return the first or last object matched by the queryset

Lecture 99 Return the earliest or latest object matched by the QuerySet

Lecture 100 Limit the objects returned from a QuerySet

Section 18: QuerySet API [Level 1] - Practical Exercises & Answers

Lecture 101 Section Introduction

Lecture 102 Section setup guide (Codebase-4)

Lecture 103 Reintroducing the database design and dataset

Lecture 104 Retrieve all sub-products for an individual product

Lecture 105 Retrieve a product featured image

Lecture 106 Retrieve all values associated to a sub-product

Lecture 107 Retrieve the product attributes for a given product type

Lecture 108 Retrieve all products associated to product attribute id:1

Lecture 109 Retrieve all sub-products that has less than 50 units left in stock

Lecture 110 Retrieve all sub-products which have been stock checked in the last month

Lecture 111 Retrieve all woman shoe products

Lecture 112 Retrieve all woman shoes by the xyz brand

Lecture 113 Retrieve all products associated to the xyz brand

Developers, Students, Enthusiasts new to the Django Framework,Developers, Students, Enthusiasts looking to refresh their knowledge of the Django ORM