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.

Challenge: Creating website sessions

Challenge: Creating website sessions - MySQL Tutorial

From the course: Advanced MySQL Database Administration

Start my 1-month free trial Buy for my team

Challenge: Creating website sessions

“

- [Narrator] All right, you're ready for your next assignment where you'll be tracking data related to website sessions. So Brent Cheeseman, your marketing lead, has come to you because he has this website sessions data for January and February, 2014, and he'd like you to create a website sessions table that will eventually tie into the rest of the data in the database. So you're going to need to take a look at the data sets and determine the proper table structure, then create the table, and then import the records. When you're done, you should see 31,110 records, and you can confirm that with a simple select count star. In some of the previous examples, I've given you the table structure, told you which columns to include. In this case, I'd like you to figure that out on your own by looking at the data that Brent is sending over to you. So go ahead and give this a shot, struggle through it on your own, then come back and watch the solution video and we'll talk about how it's done…

Contents