From the course: SQL for Testers
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Schema validation
- [Instructor] You might've heard about database schemas before, but what are they? Well, essentially, it's the layout and structure of the data in your database. And in our sample application that we've been looking at, there's a few different tables, and you probably noticed that they're connected to each other in various ways. The schema is just the definition of those various connections and tables in your database. Now, that's all a little abstract, so let's draw it out. I have a picture here of the four tables in our system. So we've got the categories, products, users, and carts tables, and by now you're probably familiar with these from the various examples that we've done throughout this course using them. But we know there's relationships between these tables as well. So this category ID here, that corresponds to the category ID down there, and the cart also has a relationship with other tables, so the user ID…
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.