Django ORM Deep Dive - Introduction to Databases & SQL

In this video, we'll introduce relational databases, and will cover important foundational topics such as the anatomy of a database (tables, rows, columns), data types, and primary keys and foreign keys.

We'll also look at how to use SQL to query a database to find records in tables, and to do more complex operations such as aggregating data, grouping data, and joining tables with SQL joins.

This video serves as an introduction to a wider course on the Django ORM and database tools.

▶️ Full Playlist:
   • Django ORM Deep Dive  

📌 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
00:00 Intro
02:01 Databases in Django
03:20 SQLite and Django’s DATABASES setting
05:07 DB Browser for SQLite
07:20 Column Data Types
08:06 Primary Keys
09:49 Foreign Keys
13:06 SQL CREATE TABLE statements
14:41 Querying records with SQL
15:55 Filtering records with WHERE clauses in SQL
20:05 Selecting particular columns in SQL
21:00 Aggregating and grouping in SQL
24:05 Ordering in SQL with ORDER BY
25:02 Joining tables by Foreign Key in SQL

☕️ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲:
To support the channel and encourage new videos, please consider buying me a coffee here:
https://ko-fi.com/bugbytes

𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:
📖 Blog: https://bugbytes.io/posts/
👾 Github: https://github.com/bugbytes-io/
🐦 Twitter:   / bugbytesio  

📚 𝗙𝘂𝗿𝘁𝗵𝗲𝗿 𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗮𝗻𝗱 𝗶𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻:
Databases in Django: https://docs.djangoproject.com/en/4.2...
DB Browser for SQLite: https://sqlitebrowser.org/
SQLite: https://www.sqlite.org/index.html
Django DATABASES setting: https://docs.djangoproject.com/en/4.2...

#django #python #webdevelopment #database #sql