SQLAlchemy 2.0 ORM Crash Course - Manage Relational Databases with Python (SQLAlchemy 2.0)

This video talks about the SLQLAlchemy ORM. In this video, we look into the core concepts of SQLAlchemy ORM and explore its robust features, offering you a step-by-step guide to working with databases seamlessly. We walk through the fundamentals, covering topics such as table creation, schema design, querying, and data manipulation.

SOURCE CODE:

#python #python3 #sqlalchemy

PLEASE BUY ME A COFFEE:

SUBSCRIBE TO MY CHANNEL:

TIMESTAMPS:
(00:00) Introduction
(1:15) Connecting to the database
(6:35) Create Database models
(24:37) Create database tables
(28:38) Create and persist objects
(37:45) Select statements
(42:34) Using sessions to select
(50:07) selects with join
(56:31) Update records
(59:18) Delete records
(1:01:18) Conclusion

[SsaliJonathan]

Hey guys, Thanks so much for watching this video. Just realized it reached 50k views. Please like the video. Thanks

[sma]

This video has saved me HOURS of time, the documentation on the sqlalchemy website is no where near as clear as this video. Keep up the good work!

[peculiar-coding-endeavours]

Mate, great series! Got yourself a fat old like for that. You saved me a ton of time going through the SQLAlchemy docs. Keep it coming!

[HamidHamdi-up]

Thank you very much
It was what I needed

[deliotablang]

this is out the topic. but can you tell me what webcam and setup you using when you creating video like this?

[aitools]

00:10 SQLAlchemy ORM allows us to model and interact with relational databases using Python

02:34 Create a connection object to connect to a database using SQLAlchemy.

07:10 Create a base class for database models using SQLAlchemy ORM

09:37 To map each database table attribute to a class, we need to use the mapped class

14:09 Defining user ID as a foreign key and comment text as a mapped string.

16:28 Create relationships in SQLAlchemy to easily access user-related data.

20:53 Defining relationships between users and comments in SQLAlchemy 2.0 ORM

23:02 Define database models to represent objects and their properties

27:18 Created database tables and checked if the information provided is valid.

29:27 Creating objects using an ORM to persist data in a database

33:42 Using SQLAlchemy's session class to insert model objects into the database.

35:45 Persisting data to the database using SQLAlchemy ORM.

39:51 Querying for usernames and checking against a list of attributes

41:59 Printing the users from the database using SQLAlchemy ORM

46:13 Selecting a user with a specific username using SQLAlchemy ORM.

48:15 Using query.filter_by() allows us to select specific users from the database.

52:28 Accessing a specific comment with related user using SQLAlchemy ORM.

54:31 Selecting data from multiple tables using SQLAlchemy

58:44 Updating and deleting data using SQLAlchemy

1:00:50 SQLAlchemy helps in managing relational databases with Python.

Crafted by Merlin AI.

[makarisilver]

Highly underrated channel. Clear and good explanation that makes it easy to understand. This video helped me a lot to get a better understanding of SQLAlchemy.
Thank you, Sir!

[TomislavMiletic]

Fresh, new content for basics on setting up V2, thank you!

[PedigreeGuitars]

Why use:

class Base(DeclarativeBase):
pass

When you can use:
Base = declarative_base()

?

[raauger]

So far, I think that the tutorial is first class. When I run the code at 27:30 I do not see the table structure SQL. Is this a setting, or am I missing something? I am running Fedora Linux.

[demitryedwards]

Thank you so much for making this video!!! It is so informative, easy to follow along, and easy to understand. Love it!

[munagalasairaghava]

Can you plz help me out, how can i map images to the python?

[VishalSingh-erbl]

hey can you send the official documentation for this

[infuse_keepingyouinformed]

I like the modularization of the code. its so educative. can you do a video with GUI please

[BijouBakson]

could you not get your lighting set up correctly?

[ritikdwivedi]

Thanks man, you saved me so much time.

[nobloat]

Thank you for the great content!
I just want to mention that when using Mapped, nullable=False is set by default so we don't need to specify it like in the old notation. They added this to make things more succinct and Pythonic.

[j.w.]

Great presentation. Can you give info on setting up the DB and Visual studio code env? I plan to reproduce what you show during this weekend.

[jesuschris]

FINALLY, someone who actually knows what they are doing

[Personal-fd]

Thank you very much. Great crash course. I had worked a little bit with this ORM before, but you covered the topics with great examples and helped me tie things together that I have previously missed. Thanks... I just subscribed.