From the course: MySQL Database Administration

Unlock this course with a free trial

Join today to access over 24,500 courses taught by industry experts.

Primary keys and foreign keys demo

Primary keys and foreign keys demo - MySQL Tutorial

From the course: MySQL Database Administration

Start my 1-month free trial Buy for my team

Primary keys and foreign keys demo

“

- [Instructor] All right, so for this lecture, I'd like to build on what we just learned about primary keys and foreign keys. And I'd like to actually take you through a live demo on a pretty robust set of data so that you can see this in action. Let's jump into Workbench and I will walk you through the Maven Fuzzy Factory Mini dataset. All right, so the first thing I'm going to do is run a use on mavenfuzzyfactorymini. You should have this schema in your schemas tab as well. So just go ahead and hit Run. So first thing, let's take a look at all the tables that are in this schema. So when we look at these tables, we've got order_item_refunds_mini, we've got order_items_mini. orders_mini, and then website_pageviews_non_normalized. And don't worry about what non normalized is. We will get to that pretty soon in this course. For now, let's work with the orders table and the order_items and order_item_refunds. So before I show you what's actually in this dataset, let me give you a quick…

Contents