From the course: Advanced SQL for Application Development
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
Overview of object-relational mapping
From the course: Advanced SQL for Application Development
Overview of object-relational mapping
- [Narrator] Now in this section of the course, we're going to take a look at object relational mapping, and we'll start with a brief overview. Now when we talk about relational databases and object-oriented models, we're really talking about two different ways or two different models for representing data, specifically entities. Now, relational databases, they model entities using an ordered set of attributes. Now, we typically call those rows and the formal name is tuples, but in general it's safe to think of 'em as just like rows that are organized into collections and we call these collections tables. Now, object-oriented models, on the other hand, are organized around two concepts called class and instance. Now, a class or classes describe the structure of an object, and an instance, or instances, those are actual objects that store data about a particular entity, so these are some key terms you want to keep in…
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)
-
-
-
-