From the course: Advanced MySQL Database Administration

Unlock this course with a free trial

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

Solution: Creating website sessions

Solution: Creating website sessions - MySQL Tutorial

From the course: Advanced MySQL Database Administration

Start my 1-month free trial Buy for my team

Solution: Creating website sessions

“

- [Instructor] All right, this is the solution video for your assignment on tracking website sessions. As a reminder, your marketing lead, Brent has come to you because he has this website sessions data and he wants it to tie into the database so that he can marry it to the order data. This is a pretty typical use case where the marketing team is going to want to understand how they're driving revenue so that they can optimize into high-performing channels and improve the business. And your job as the database administrator is to facilitate the tracking on the backend. So we've already got the orders data in the database and that data contains a website session id. So now we're going to need to create a website_sessions table and bring in all of this data that Brent has. So let's jump into Workbench and I'll walk you through it. And before we actually go through this using Workbench, I want to just open up that file so that we can see what that data looks like from Brent. So here…

Contents