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: Importing website pageview data - MySQL Tutorial
From the course: Advanced MySQL Database Administration
Challenge: Importing website pageview data
- [Instructor] Alright, we're ready for your assignment on importing pageview data. So Molly's come to you and she has this detailed February pageview data that she's pulled out of the web analytics tool. She'd like you to load that into the central database so that we can tie it to all of the other great data you've put together. So take a look at the attachment that Molly sent. You'll want to look at the pageview data structure, then create a website pageviews table that matches that structure. And then you can go ahead and upload that dataset. Give it a shot, come back and watch the solution video, and we'll talk through the results. Good luck.
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.