CS50W - Lecture 4 - SQL, Models and Migrations

TABLE OF CONTENTS

00:00:00 - Introduction
00:00:15 - SQL
00:08:03 - Tables
00:14:23 - SQL Queries
00:30:16 - Joining Tables
00:49:14 - Django Models
00:51:34 - Migrations
00:53:50 - Shell
01:11:16 - Django Admin
01:19:09 - Many-to-Many Relationships
01:40:20 - Users

This course picks up where Harvard University's CS50 leaves off, diving more deeply into the design and implementation of web apps with Python, JavaScript, and SQL using frameworks like Django, React, and Bootstrap. Topics include database design, scalability, security, and user experience. Through hands-on projects, students learn to write and use APIs, create interactive UIs, and leverage cloud services like GitHub and Heroku. By semester’s end, students emerge with knowledge and experience in principles, languages, and tools that empower them to design and deploy applications on the Internet.

***

This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming.

***

HOW TO SUBSCRIBE

HOW TO TAKE CS50

HOW TO JOIN CS50 COMMUNITIES

HOW TO FOLLOW DAVID J. MALAN

***

CS50 SHOP

***

LICENSE

CC BY-NC-SA 4.0
Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International Public License

David J. Malan

[larjasoul]

I actually can't tell if Django is hard or not.
This man explains topics so clearly; I'm convinced he could teach me Hebrew in 8 minutes.

[alseynidiop]

This course makes me shift from PHP to Django.
This guys is a genius.

[Vhc]

Awesome lecture on a difficult topic! This is the type of video you have to watch over and over because it's so dense. He doesn't waste a single second.

[preyankjain]

46:00 start of flights django project
49:52 models.py
53:00 python manage.py shell
56:21 string representation of model function
59:00 linking two models
1:07:00 index.html for loop using the models
1:12:08 creating admin acc in django
1:17:00 adding functions to manipulate data in views.py
1:23:00 adding if empty clause using django in an html file
1:28:00 getting particular data from POST request
1:32:00 dropdown list in html
1:33:56 exclude passengers from a query
1:38:13 configure admin page
1:41:00 add/manage users (login)
1:49:00 authenticate user with username and password
1:51:00 access username in html from django
1:52:39 logout

[donteo]

Brian is awesome, a precious gem in teaching profession, learn much from his teaching in one video which could take years... thanks Brian, hoping you can share more & help more people to acquire Tech Skills!

[syeda.k.]

Brian teaches in 2 hrs what paid courses teach in 2 months

[SUBZERO]

i was afraid i couldnt understand a full course in english but brian has an easy pronunciation and teaching skill, terrific class

[udz]

This one hit hard.

Edit: Yes, the lecture had too much info, but as you start working on 1st part of the project, everything after that feels natural and fun to work on.

[MehediHasan-xdrj]

Their videos are well-directed and they know how to make complex topics as simple as possible, making them impossible to ignore. Thank you, Brian.

[NaifAlqahtani]

Despite my knowledge in SQL from cs50x, which saved me the first 55 minutes of the video, I still need to rewatch and practice everything past that in this week's lecture.

[hashimsulaiman]

I have seen many teachers but Brian is different there is a way he connects one section to the other that makes you get a relationship and he explains had topics in avery simple and inteructive way that you visualise how everything comes about.with this course he has tought me what I have been struggling for six month in just hours.had I began with you I would be miles away
Thanks Brian

[WaiSanLee]

These lectures are fantastic, but Brian is such a bloody fast typer that every time he gets to a section where he's coding I have to set the speed to 0.25 to try and code along, and even then he's faster than me!

[alburnto]

Holy sh-. This lecture made me more interested in Django than the previous one. The ORM blew my mind. Thanks!

[deepheartedcoders]

this man knows AI, Web development, Databases, networking, Algorithms, He is AWESOME

[alanyang]

Thank you Prof. David J. Malan and Brian.

[thomasmoncrief]

Brian goin full beast mode in this one.

[IntheBellyofaWhale]

It was so good I exited fullscreen like 10 times because of the sudden urge to like the video

[axumitedessalegn]

I would recommend taking cs50x before this. Lots of information in this video that assumes you know certain things about python and programming in general. I was able to get through only because of cs50 and the amount of time i put into my final project for cs50. Django seems to have alot more built-in features than Flask or i just don't know flask well enough to use all the features and modules that come with it.

[russelpeter]

Amazing stuff, Brian. You made my Django learning experience so easy & smooth!

[VinaySharma-smdt]

Thank you CS50 for this amazing lecture.