Django Database ORM Mastery

[Srbija]

Django Database Orm Mastery
Last updated 2/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 11.99 GB | Duration: 25h 14m

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



What you'll learn
Setup and prepare an environment ready to develop Python Django applications
@ Level 1 - Connect Django applications to multiple database technologies and perform a variety of queries to create return update and delete data
@ Level 1 - Connect a Django application to multiple database technologies utilising Docker container technologies
@ Level 1 - Propagate changes to database tables structures
@ Level 1 - Build raw SQL queries to interact with database from within a Django project
@ Level 1 - Implement a variety of QuerySet API methods to limit, order and optimise performance
@ Level 1 - Implement a design methodology design and subsequently build and query a database
@ Level 2 - Advance knowledge of topics introduce at level 1
@ Level 2 - Implement Proxy Models & Abstract Classes
@ Level 2 - Incorporate Django Signals
@ Level 2 - Implement Django User Models and customizations
@ Level 2 - Implement Django Model Permissions
@ Level 2 - Implement Caching to enhance performance
@ Level 2 - Database testing
@ Level 2 - Q-Objects, Annotations, Fixtures, F() expressions, Prefetch

Requirements
Prior experience in using the Django framework would be advantageous
Knowledge of relational database principles would be advantageous
Having a computer would definitely be advantageous

Description
One of the most powerful features of Django is its Object-Relational Mapper (ORM). In a Django project, the Django ORM provides the tools to rapidly build database interactions without needing to learn Structured Query Language (SQL). This course helps you start your journey mastering database interactions using the Django ORM to build scalable and performant Django applications.This course is currently in its first iteration and includes level 1 of 3 planned levels. Each level will be a separate course. You will find subsequent levels in our course library for levels 2 and 3 of this course. At level 1 you will learn how to build, administrate tables and perform common Create, Return, Update and Delete (CRUD) operations through the Django ORM. The courseware at level 1 scaffolds the learning, building towards a final case study where we first design and subsequently develop and query the database. Learners may track their knowledge through optional section assessments leading towards a final level assessment (section and level assessments are a feature coming very soon).We believe that to master Django database interactions and performance, it can be beneficial to underpin knowledge, learning to interact with a database from a Django project through raw SQL queries. Subsequently, learners may follow optional tutorials learning the underlying SQL used to interact with a database and perform operations.I hope you enjoy the course and fulfil your learning objective. Don't forget to visit us on our YouTube Channel, Very Academy, where you can further interact with the community and explore other free supplementary content.

Overview
Section 1: Django Database ORM Mastery

Lecture 1 Course Induction

Section 2: Setup Guides

Lecture 2 [Windows] Installing Python 3.9.5

Lecture 3 [Windows] Visual Studio Code Induction

Lecture 4 [Windows ] Creating Virtual Environments

Lecture 5 [macOS] Installing Python 3.9.5

Lecture 6 [macOS] Visual Studio Code Induction

Lecture 7 [macOS] Creating Virtual Environments

Lecture 8 Visual Studio Code Extensions

Section 3: [Optional] Django Framework Introduction Exercise

Lecture 9 Preparing a new Virtual Environment

Lecture 10 Introducing the Python Package Index

Lecture 11 Installing the Django Framework

Lecture 12 Creating a new Django project

Lecture 13 Creating a new Django application

Lecture 14 Registering a new Django application

Lecture 15 Starting the Django Development Server

Lecture 16 Understanding the Django Request-Response Cycle

Lecture 17 Creating a unique URL pattern

Lecture 18 Writing a new view

Lecture 19 Creating a new HTML template

Lecture 20 Relating an HTML template to a view

Lecture 21 Installing a Django application from a requirements.txt file

Section 4: Django ORM Primer

Lecture 22 Object Relational Mapping Primer

Lecture 23 Models and Field Primer

Lecture 24 Model Manager Primer

Lecture 25 QuerySet Primer

Lecture 26 Backend Primer

Section 5: Backend Setup

Lecture 27 PostgreSQL Docker Setup

Section 6: L1: Working with an SQLite Database

Lecture 28 Section Introduction

Lecture 29 Introducing SQLite databases

Lecture 30 Connect an SQLite database to a Django project

Section 7: L1: Building Models

Lecture 31 Section Introduction

Lecture 32 Section setup guide - step-by-step

Lecture 33 Section setup guide (CodeBase-0)

Lecture 34 Introducing Django models

Lecture 35 Adding a string representation of a model

Lecture 36 The model verbose field name

Lecture 37 Introducing django model field types

Lecture 38 Introducing Django model field options

Lecture 39 Defining model primary keys

Lecture 40 Defining model Foreign Keys

Lecture 41 Defining one-to-one model relationships

Lecture 42 Defining Many-to-Many model relationships

Lecture 43 Introducing model meta options

Section 8: L1: Migrations

Lecture 44 Section Introduction

Lecture 45 Migrate model changes to the database schema

Section 9: L1: Inspecting Queries & Performance Analysis

Lecture 46 Section Introduction

Lecture 47 Section setup guide - Codebase-1

Lecture 48 Inspect queries with the query attribute

Lecture 49 Inspect queries - connection and reset queries

Lecture 50 Pretty print SQL

Section 10: L1: Utility

Lecture 51 Section Introduction

Lecture 52 Counting returned queryset objects

Lecture 53 Conveniently View data returned in queryset objects

Section 11: L1: Create and Save Objects

Lecture 54 Section Introduction

Lecture 55 Section setup guide - Codebase-1

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

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

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

Lecture 59 SQL Insert - Executing custom SQL Inserts

Lecture 60 Insert into single table with foreign key

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

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

Lecture 63 SQL Insert - Working with many-to-many relationships

Lecture 64 Insert data into multiples tables & using atomic operations

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

Lecture 66 Insert multiple objects into single table - bulk create

Lecture 67 Query Profiling - bulk_create() vs create() performance analysis

Lecture 68 Creating and automating a set of Django Fixtures

Section 12: L1: Retrieving objects

Lecture 69 Section Introduction

Lecture 70 Section setup guide (Codebase-2)

Lecture 71 Return all objects from a single table - all()

Lecture 72 SQL - Return all objects from a single table

Lecture 73 Retrieving single objects from a single table - get()

Lecture 74 SQL - Return single objects from a single table

Lecture 75 Filter & Exclude - Retrieving specific objects

Lecture 76 SQL - Filter retrieving objects - filter()

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

Lecture 78 SQL - Retrieve objects foreign key relationship

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

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

Section 13: L1: Update Fields/Records

Lecture 81 Section Introduction

Lecture 82 Section setup guide (Codebase-2)

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

Lecture 84 Implementing update_or_create()

Lecture 85 bulk_update records in a single table

Section 14: L1: Delete Records

Lecture 86 Section Introduction

Lecture 87 Section setup guide (Codebase-2)

Lecture 88 Delete single and multiple objects

Section 15: L1: Implementing PostgreSQL Database & Docker

Lecture 89 Section introduction

Lecture 90 Docker introduction

Lecture 91 Installing Docker MacOS

Lecture 92 Installing Docker Desktop for Windows 10/11

Lecture 93 Create a Postgres Docker container

Lecture 94 Configuring Django to work with a PostgreSQL database

Section 16: L1: Field Lookup Keywords Arguments

Lecture 95 Section Introduction

Lecture 96 Section setup guide (Codebase-3)

Lecture 97 Field lookups

Lecture 98 Field lookup contains

Lecture 99 Field lookup with greater or less than

Lecture 100 Field lookup with start or end with

Lecture 101 Field lookup range

Lecture 102 Field lookup Day Week Month

Section 17: L1: QuerySet Ordering and Limiting

Lecture 103 Section Introduction

Lecture 104 Section setup guide (Codebase-3)

Lecture 105 Ordering a new QuerySet

Lecture 106 Reverse the output of a new QuerySet

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

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

Lecture 109 Limit the objects returned from a QuerySet

Section 18: L1: Practical Exercises & Answers

Lecture 110 Section Introduction

Lecture 111 Section setup guide (Codebase-4)

Lecture 112 Reintroducing the database design and dataset

Lecture 113 Retrieve all sub-products for an individual product

Lecture 114 Retrieve a product featured image

Lecture 115 Retrieve all values associated to a sub-product

Lecture 116 Retrieve the product attributes for a given product type

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

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

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

Lecture 120 Retrieve all woman shoe products

Lecture 121 Retrieve all woman shoes by the xyz brand

Lecture 122 Retrieve all products associated to the xyz brand

Section 19: Level 1: Case Study - Ecommerce Inventory | Design | Build | Query

Lecture 123 Case Study Introduction

Lecture 124 Case Study Resources

Lecture 125 Design - Design methodology

Lecture 126 Design - Define the purpose

Lecture 127 Design - Requirement analysis

Lecture 128 Design - Defining the preliminary list of fields

Lecture 129 Design - Defining the preliminary subjects/entities

Lecture 130 Design - Refining the fields and tables

Lecture 131 Design - Naming fields and tables

Lecture 132 Design - Establishing Keys

Lecture 133 Design - Field Specifications

Lecture 134 Design - Table Relationships

Lecture 135 Design - Table Relationships - update fields

Lecture 136 Design - Business Rules

Lecture 137 Design - Django / Application Rules

Lecture 138 Build - Create the tables and fields

Lecture 139 Data - Create data - Django Admin Site

Lecture 140 Data - Create data - Django fixtures

Lecture 141 Data - Create data - Management command

Section 20: Django Signals

Lecture 142 Introducing Signals and the Observer Pattern

Lecture 143 Recieving Signals

Lecture 144 Receiving Signals Specifying a Model

Section 21: Custom Model Fields

Lecture 145 Introducing Custom Model Fields

Lecture 146 Creating a Custom field Subclass

Lecture 147 Creating a Custom Order Field

Lecture 148 Custom field Subclass - Converting Values to and From a Database

Section 22: Creating Many-to-Many Relationship Customisations

Lecture 149 Learning Objectives: Advancing Many-to-Many

Lecture 150 Re-cap - Many-to-Many relationship

Lecture 151 Specifying a Many-to-Many Intermediate Model

Lecture 152 Django Admin Many-to-Many Intermediate Model Configuration

Lecture 153 Querying a Many-to-Many Custom Intermediate Model

Lecture 154 Related Object Reference Reverse Queries

Lecture 155 Extend a Many-to-Many intermediate model with custom fields

Section 23: L2: Django User Model

Lecture 156 Section Intro - Django User Model

Lecture 157 Introducing the Django User Model

Lecture 158 Changing the User Model Behaviour (Proxy Model)

Lecture 159 Store extra information about the existing User Model (User Profile)

Lecture 160 Inherit and add extra fields to the user table (AbstractUser)

Section 24: Model Manager

Lecture 161 Model Manger Role and Implimentation

Lecture 162 Model Manager Naming

Lecture 163 Model Manager Extra Methods

Lecture 164 Modify Initial QuerySet

Section 25: [Additional Content] Introducing Linters and Formatters

Lecture 165 Introducing Linters and Formatters

Lecture 166 Black

Lecture 167 Flake8

Lecture 168 Microsoft Python Extension

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

Hidden Content

Give reaction to this post to see the hidden content.

Hidden Content

Give reaction to this post to see the hidden content.

Hidden Content

Give reaction to this post to see the hidden content.

Hidden Content

Give reaction to this post to see the hidden content.