Django ORM Deep Dive - Introduction to Databases & SQL

preview_player
Показать описание
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:

📌 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
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:

𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:

📚 𝗙𝘂𝗿𝘁𝗵𝗲𝗿 𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗮𝗻𝗱 𝗶𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻:

#django #python #webdevelopment #database #sql
Рекомендации по теме
Комментарии
Автор

after your video about proxy models, i decided to watch the entire series and here i am lesson1 done😎

lnhznbo
Автор

Never seen this kind of 'straight to the point' videos, great content to learn Django ORM, Love from Bangladesh.

SaifulIslam-mevb
Автор

You look and talk like Sick Boy from Trainspotting who got sober and started to make this awesome videos. Great content!

jeremiaszgoti
Автор

I greatly appreciate the SQL refresh. Thank you so much! If it's possible, I would love to see more raw SQL examples in the future, especially for complex Django queries. It would help us understand to what sql, Django querysets translate to.

tobidegnon
Автор

Great intro to SQL. The principles are explained in a clear language. Thank you.

rorisangsitoboli
Автор

On Udemy I found course about ORM Rs.3999 quite expensive for me you are providing all this stuff for free
I am very grateful to you.

prashlovessamosa
Автор

It's happening 😅. I can't believe it. Thanks very much. Looking out for much more.

AmoahDevLabs
Автор

I work as a Django developer, but I like watching your videos instead any famous movies

Developer_python_
Автор

well explained.Connecting Django app to multiple databases and how to link them is something i wish you could add as a topic in this series

djtoon
Автор

Thank you so much for this. Would love some tutorials on query and performance optimization, especially how to do complex calculations with subqueries.

MrValVet
Автор

Thank you for putting up the effective teaching methods for us . Great Job! much appreciations💯

bugsbunny-
Автор

Thanks a lot. series is going to be very important for django learners.

sidds
Автор

Congratulations, on the fantastic content.
Subqueries, Conditional Expressions is something I would really like you to cover, I have also had some problems with Indexes and Constraints, I also believe it would be a very relevant content.

digital-tree
Автор

Your videos are amazing! Thanks for your work

qsvsgbz
Автор

Please create series on Django + Reflex, Using Django to handle backend, Reflex to frontend, Using this combination No javascript required

maheshpol
Автор

Just found your channel looking forward to learn awesome stuff from you.

prashlovessamosa
Автор

Бро ты красава! продолжай дальше и огромное тебе спасибо!

dimamichaelis
Автор

That's what I was searching for! Thanks a lot

adhd_arti
Автор

you can use sqlite extension instead of DB browser

SHUBHAMTIWARI-utji
Автор

Can I get access to the database used in this video please. I'd like to follow along with how you use the data in Django. Thanks a lot.

johnburrell