Advanced MySQL Data Analysis
With Maven Analytics and John Pauler
Liked by 65 users
Duration: 8h 3m
Skill level: Advanced
Released: 10/18/2024
Course details
MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI professional should have in the arsenal. In this course, learn advanced MySQL techniques and apply them to real-world business challenges using a unique, custom-built ecommerce database.
Instructor John Pauler starts by introducing the course project, installing the tools you'll need to access your database, and reviewing the core SQL skills that you should be comfortable with before starting the course, including SELECT statements, aggregate functions, and table joins. From there, work through a number of analytics deep dives, including traffic analysis and optimization, website measurement and testing, channel mix, product performance, user analysis, and more.
For each topic, John introduces the business concept, reviews the SQL tools that you’ll be applying, and then jumps straight into hands-on exercises and course projects.
Note: This course was created by John Pauler and Maven Analytics. We are pleased to host this training in our library.
Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
Learning
LinkedIn Learning
Certificate of Completion
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructors
Learner reviews
4.9 out of 5
-
5 star 92% -
4 star 8% -
3 star 0% -
2 star 0% -
1 star 0%
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)
What’s included
- Practice while you learn 1 exercise file
- Test your knowledge 9 quizzes
- Learn on the go Access on tablet and phone