From the course: Advanced MySQL Database Administration
Join today to access over 24,800 courses taught by industry experts.
Challenge: Creating views - MySQL Tutorial
From the course: Advanced MySQL Database Administration
Challenge: Creating views
- [Instructor] All right, in this next assignment, you're going to be creating views that will be used for reporting. So Brent, your marketing lead, has come to you because he'd like you to create a view that will summarize the website session performance for the months of January and February. He would like to see the number of sessions as the metric, and he'd like you to slice that data by year, month, utm_source, and utm_campaign. Your output should look like this. The query needed for this view shouldn't be too challenging for most folks, but just in case, you're going to want to be using group by with four groups and then you'll want to use the count function in order to get the total number of sessions. Give this a shot on your own and come back, and I'll walk you through it in the solution video. 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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.