From the course: Advanced MySQL Database Administration

Unlock this course with a free trial

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

Solution: Importing website pageview data

Solution: Importing website pageview data - MySQL Tutorial

From the course: Advanced MySQL Database Administration

Start my 1-month free trial Buy for my team

Solution: Importing website pageview data

“

- [Instructor] All right, this is the solution video for the assignment on importing pageview data. So after having the discussion with Molly, the website manager, about improving your data infrastructure and starting to tie Website Pageview Data into the rest of the data that you have in the database, Molly has come back with this February pageview data that she was able to pull out of the web analytics tool. She'd like your help in getting it into the database so that she can tie it to all of the other rich data that you have. Let's jump into Workbench and I'll walk you through it. All right, so the first thing that we're going to need to do before we import the website_pageviews data is actually create that table, and we'll start with a CREATE TABLE statement, and we'll call it website_pageviews. And per usual, we'll open it and close it and end the query. And first we'll have a website pageview ID column, and that'll be a BIGINT. We'll have a created at timestamp and that'll be a…

Contents