From the course: Advanced MySQL Data Analysis

Unlock this course with a free trial

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

Getting to know the database

Getting to know the database - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Getting to know the database

“

- [Instructor] All right. Now that we've installed the database, let's spend a little bit of time just getting to know it before we jump into the exercises. So here we have an overview of what's in the Maven Fuzzy Factory database. We have website sessions and website page views. We have orders and order items. And we have products and order item refunds as well. In general, this is pretty typical of an eCommerce database. In reality, you're going to have a lot more tables. I've stripped this course down to just some of the most critical and fundamental tables, which host some of the key data that an eCommerce database analyst would be working with on a daily basis. So the orders data is where we store the purchases that customers are placing, and we've got an ID value associated. We always have a timestamp of when that occurred. We have a website session ID so that we can associate that with all the data in the website sessions table, we've got a user ID, the primary product of that…

Contents