From the course: Advanced MySQL Data Analysis
Join today to access over 24,900 courses taught by industry experts.
Solution: Mid-course project - MySQL Tutorial
From the course: Advanced MySQL Data Analysis
Solution: Mid-course project
Play video to see the transcript
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 the exercise files for this course.
Get started with a free trial today.
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.
Watch this course anytime, anywhere.
Get started with a free trial today.
Contents
-
-
Introduction25s
-
MySQL installation overview2m 27s
-
Mac download: Community Server4m 53s
-
Mac download: MySQL Workbench2m 50s
-
PC download: Community Server + Workbench7m 41s
-
Connecting Workbench to the server2m 20s
-
(Locked)
MySQL Workbench interface1m 34s
-
(Locked)
Creating the Maven Fuzzy Factory database7m 52s
-
(Locked)
Getting to know the database4m 20s
-
(Locked)
USE mavenfuzzyfactory;2m 26s
-
-
-
(Locked)
Introduction19s
-
(Locked)
Analyzing top traffic sources18m 59s
-
(Locked)
Assignment: Finding top traffic sources2m 17s
-
(Locked)
Solution: Finding top traffic sources4m 3s
-
(Locked)
Assignment: Traffic source conversion rates1m 5s
-
(Locked)
Solution: Traffic source conversion rates4m 51s
-
(Locked)
Bid optimization and trend analysis15m 54s
-
(Locked)
Assignment: Traffic source trending58s
-
(Locked)
Solution: Traffic source trending4m 50s
-
(Locked)
Assignment: Bid optimization for paid traffic2m 12s
-
(Locked)
Solution: Bid optimization for paid traffic5m 12s
-
(Locked)
Assignment: Trending with granular segments1m 31s
-
(Locked)
Solution: Trending with granular segments5m 42s
-
(Locked)
-
-
(Locked)
Introduction19s
-
(Locked)
Analyzing top website pages and entry pages16m 42s
-
(Locked)
Assignment: Finding top website pages59s
-
(Locked)
Solution: Finding top website pages3m 15s
-
(Locked)
Assignment: Finding top entry pages1m 7s
-
(Locked)
Solution: Finding top entry pages7m 58s
-
(Locked)
Analyzing bounce rates and landing page tests14m 22s
-
(Locked)
Assignment: Calculating bounce rates39s
-
(Locked)
Solution: Calculating bounce rates9m 25s
-
(Locked)
Assignment: Analyzing landing page tests2m 12s
-
(Locked)
Solution: Analyzing landing page tests11m 56s
-
(Locked)
Assignment: Landing page trend analysis1m 9s
-
(Locked)
Solution: Landing page trend analysis7m 40s
-
(Locked)
Building conversion funnels and conversion paths17m 19s
-
(Locked)
Assignment: Building conversion funnels1m 26s
-
(Locked)
Solution: Building conversion funnels7m 53s
-
(Locked)
Assignment: Analyzing conversion funnel tests1m 49s
-
(Locked)
Solution: Analyzing conversion funnel tests6m 57s
-
(Locked)
-
-
(Locked)
Introduction32s
-
(Locked)
Analyzing channel portfolios9m 4s
-
(Locked)
Assignment: Analyzing channel portfolios1m 20s
-
(Locked)
Solution: Analyzing channel portfolios4m 44s
-
(Locked)
Assignment: Comparing channel characteristics49s
-
(Locked)
Solution: Comparing channel characteristics4m 11s
-
(Locked)
Assignment: Cross-channel bid optimization1m 11s
-
(Locked)
Solution: Cross-channel bid optimization3m 22s
-
(Locked)
Assignment: Analyzing channel portfolio trends1m 6s
-
(Locked)
Solution: Analyzing channel portfolio trends7m 23s
-
(Locked)
Analyzing direct, brand-driven traffic7m 21s
-
(Locked)
Assignment: Analyzing direct traffic1m 50s
-
(Locked)
Solution: Analyzing direct traffic8m 22s
-
(Locked)
-
-
(Locked)
Introduction20s
-
(Locked)
Analyzing product sales and launches7m 3s
-
(Locked)
Assignment: Product-level sales analysis1m 5s
-
(Locked)
Solution: Product-level sales analysis2m 18s
-
(Locked)
Assignment: Analyzing product launches1m 5s
-
(Locked)
Solution: Analyzing product launches4m 26s
-
(Locked)
Analyzing product-level website pathing9m 42s
-
(Locked)
Assignment: Product-level website pathing1m 42s
-
(Locked)
Solution: Product-level website pathing10m 44s
-
(Locked)
Assignment: Building product conversion funnels1m 55s
-
(Locked)
Solution: Building product conversion funnels13m 7s
-
(Locked)
Cross-selling & product portfolio analysis9m 33s
-
(Locked)
Assignment: Cross-sell analysis1m 20s
-
(Locked)
Solution: Cross-sell analysis12m 28s
-
(Locked)
Assignment: Product portfolio expansion1m
-
(Locked)
Solution: Product portfolio expansion4m 47s
-
(Locked)
Analyzing product refund rates4m 59s
-
(Locked)
Assignment: Analyzing product refund rates1m 11s
-
(Locked)
Solution: Analyzing product refund rates4m 6s
-
(Locked)
-
-
(Locked)
Introduction16s
-
(Locked)
Analyzing repeat visit and purchase behavior6m 48s
-
(Locked)
Assignment: Identifying repeat visitors57s
-
(Locked)
Solution: Identifying repeat visitors5m 49s
-
(Locked)
Assignment: Analyzing time to repeat55s
-
(Locked)
Solution: Analyzing time to repeat4m 40s
-
(Locked)
Assignment: Analyzing repeat channel behavior1m
-
(Locked)
Solution: Analyzing repeat channel behavior3m 22s
-
(Locked)
Assignment: Analyzing new and repeat conversion rates52s
-
(Locked)
Solution: Analyzing new and repeat conversion rates2m 53s
-
(Locked)