From the course: Advanced SQL for Application Development
Unlock the full course today
Join today to access over 24,700 courses taught by industry experts.
Challenge: Create an ORM model
From the course: Advanced SQL for Application Development
Challenge: Create an ORM model
(chill music) - [Instructor] Here's a challenge to test your understanding of SQLAlchemy. I'd like you to define a class using SQLAlchemy that corresponds to a suppliers table. Now we'll keep this simple. The suppliers table will have four columns, a supplier ID, a supplier name, a supplier region, and a supplier level. Now the supplier ID and supplier level, those are of type integer. The supplier name and the supplier region are variable character strings and also you should know that the supplier ID is the primary key.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Overview of object-relational mapping1m 23s
-
Introduction to SQLAlchemy3m 5s
-
(Locked)
Installing SQLAlchemy1m 20s
-
(Locked)
Query with SQLAlchemy9m 47s
-
(Locked)
Limitations of ORM and cautionary advice2m 10s
-
(Locked)
Challenge: Create an ORM model37s
-
(Locked)
Solution: Create an ORM model54s
-
(Locked)
-
-
-
-