SQLAlchemy Tutorial For Beginners - Python Simple Social Network Backend

This Database from scratch tutorial will give you an Introduction to Relational Databases using Python SQLAlchemy Library, all by learning how a simple Social Network Backend works.
If you like this video, make sure to like and Subscribe for more! 👍

0:00:00 Intro
0:01:31 What is a Database
0:10:13 Primary & Foreign Keys
0:11:15 Database Relationships
0:14:25 Designing and Drawing Database using a Software
0:22:20 Installing SQLAlchemy
0:23:48 Social Media Users Table
0:30:12 Creating SQLite Database
0:33:17 Browsing Database
0:34:30 Database Commit
0:37:59 Social Media Posts Table
0:44:07 Populating Database with Data
0:49:18 Getting Started with Queries
0:53:26 More Queries
1:00:54 Social Media Likes Table
1:03:46 How a Post Like in Social Media Works
1:08:56 Counting Post Likes
1:12:13 Join Query

Python Beginner's Tutorials Play List:

Get my Python All in-one course, including Python Basics, AI, Data analysis, UI, Web Development, Image/Video Processing, Games Development, Databases and tons of Hands on projects. 🎨🎁

#pythondude #python #pythonprogramming #sqlalchemy

[solcaer]

this is such an amazing tutorial. I don't have a clue how you manage to make things clear enough for a toddler to understand it and still fit so much useful information in, but I'm very grateful

[dipeshsharma]

Thank you it was what i was looking for:)

[shahdadpeykani]

Thank you sir, I was struggling with this topic but now I understood

[mohammadaminmousavi-dc]

Well done my friend. One one the best SQL beginner tutorial.
🙏🙏

[gbvtech]

1:12:45 at line 104 how does it search thru the users table?

[ravinderd.bhatoy]

thanku you for this amazing tutorial :)

[TheIaTaI]

Nice video!
Do social media companies work with ORM or a graph based network?

[ApurvaHegde-lo]

Hello! Is this SQLAlchemy tutorial for v1.x or v2.0 ? There are some significant differences in how things are done between the two.

[aszx-tvpq]

Yo! This is exactly what I am looking for tanx for the content and also plz explain why we conect posts and likes table from output to output?

[emmanuelcudjoe]

What is the difference between Column and mapped_column?

[dipeshsharma]

can you make a video on how to create a fully fledged telegram bot using webhook with deployment too using telegram api

[srvazkez]

why used the __init__😳? Nice video I used my tables without __init__ method what's the difference?

[idopshik]

No, can't watch it. Text is too small.

Has to be 15 lines at most.