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

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:
https://github.com/jod35/SQLAlchemy-2...

DB BROWSER FOR SQLITE:
https://sqlitebrowser.org/

PLEASE BUY ME A COFFEE:
https://www.buymeacoffee.com/jod35

GITHUB:
https://github.com/jod35

TWITTER:
  / jod35_  


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