SQLAlchemy 2.0 Core Crash Course - Use Python for Seamless Interaction with Relational Databases

preview_player
Показать описание
SQLAlchemy Core allows you to interact with relational databases using statements written in pure Python. This allows you to form queries and use your database without that much knowledge of SQL.

This video will give you a guide on how to connect to an SQL database as well as to Create, Read, Update, and Delete records from your database.

#python #sqlalchemy #sql

SOURCE CODE:

DB BROWSER FOR SQLITE:

PLEASE BUY ME A COFFEE:

GITHUB:

TWITTER:

CHAPTERS:
(0:00) Introduction
(1:27) Setting up the environment
(4:24) Connecting to the database
(7:38) Testing database connection
(11:21) Define database tables
(16:40) The metadata object
(24:31) Create tables in the database
(30:31) Insert statements
(39:29) select statements
(44:46) select-where
(48:19) Update statements
(52:40) delete statements
(54:36) Conclusion
Рекомендации по теме
Комментарии
Автор

The next video is on SQLAlchemy ORM. We shall explore some really interesting changes added to SQLAlchemy. Thanks for watching.

SsaliJonathan
Автор

This video is:
- clearly explained
- modular (explains each part individually)
- beginner friendly
Thank you soo much.

ommahajan
Автор

Both videos, the CORE and the ORM, they are really really useful. Thank you!

namotoninja
Автор

Thanks for the video, very well thought out. One of the best I've seen where you don't waste time going over setups, some of the videos on this topic I have seen spend half an hour just setting up the project before they get to explaining SQLAlchemy. Looking forward to going through your ORM video.

andrewmathenge
Автор

expertly taught. Thank you! Any idea when you will be done with part 2.?

humbletitan
Автор

Almost all the people forgot the good pronunciation, as a non native is very helpfull thats someone really speaks correctly. do you happend to know if I call a connection and save it in a variable that I would happend to pass to 3 different functions why the connection would be broken ? do I have to pass the engine and then connect each time ?

seta
Автор

Great work, my friend. This video is very helpfull. Thank you!

MasterDomai
Автор

I have question is it necessary to learn both sqlalchemy core and sqlalchemy ORM or one is enough

ManVsman..
visit shbcf.ru