Advanced SQL: MySQL for Data Analysis
0% Completed
Subtitle Guide – Hướng dẫn thêm phụ đề
01 – Getting Started
02 – Prerequisite Skills
03 – MySQL Intro & Setup
Subtitle File Resource
Reading
001 Introduction
Video - 00:00:25 mins
002 MySQL Installation Overview
Video - 00:02:27 mins
003 Mac Download - MySQL Community Server
Video - 00:04:53 mins
004 Mac Download - MySQL Workbench
Video - 00:02:51 mins
005 PC Download - MySQL Community Server
Video - 00:07:41 mins
006 Connecting MySQL Workbench to the Server
Video - 00:02:20 mins
007 MySQL Workbench Interface
Video - 00:01:34 mins
008 Creating the Maven Fuzzy Factory Database
Video - 00:07:52 mins
009 Getting to Know the Database
Video - 00:04:20 mins
010 USE mavenfuzzyfactory
Video - 00:02:27 mins
04 – Analyzing Traffic Sources
Subtitle File Resource
Reading
001 Introduction
Video - 00:00:19 mins
002 Analyzing Top Traffic Sources
Video - 00:18:59 mins
003 ASSIGNMENT Finding Top Traffic Sources
Video - 00:02:17 mins
004 SOLUTION Finding Top Traffic Sources
Video - 00:04:03 mins
005 ASSIGNMENT Traffic Source Conversion Rates
Video - 00:01:05 mins
006 SOLUTION Traffic Source Conversion Rates
Video - 00:04:51 mins
008 ASSIGNMENT Traffic Source Trending
Video - 00:00:58 mins
009 SOLUTION Traffic Source Trending
Video - 00:04:50 mins
010 ASSIGNMENT Bid Optimization for Paid Traffic
Video - 00:02:13 mins
011 SOLUTION Bid Optimization for Paid Traffic
Video - 00:05:12 mins
012 ASSIGNMENT Trending w Granular Segments
Video - 00:01:31 mins
013 SOLUTION Trending w Granular Segments
Video - 00:05:42 mins
05 – Analyzing Website Performance
Subtitle File Resource
Reading
001 Introduction
Video - 00:00:19 mins
002 Analyzing Top Website Pages
Video - 00:16:42 mins
003 ASSIGNMENT Finding Top Website Pages
Video - 00:00:59 mins
004 SOLUTION Finding Top Website Pages
Video - 00:03:15 mins
005 ASSIGNMENT Finding Top Entry Pages
Video - 00:01:08 mins
006 SOLUTION Finding Top Entry Pages
Video - 00:07:58 mins
007 Analyzing Bounce Rates
Video - 00:14:21 mins
008 ASSIGNMENT Calculating Bounce Rates
Video - 00:00:40 mins
009 SOLUTION Calculating Bounce Rates
Video - 00:09:26 mins
010 ASSIGNMENT Analyzing Landing Page Tests
Video - 00:02:12 mins
011 SOLUTION Analyzing Landing Page Tests
Video - 00:11:56 mins
012 ASSIGNMENT Landing Page Trend Analysis
Video - 00:01:09 mins
013 SOLUTION Landing Page Trend Analysis
Video - 00:07:40 mins
014 Building Conversion Funnels
Video - 00:17:19 mins
015 ASSIGNMENT Building Conversion Funnels
Video - 00:01:26 mins
016 SOLUTION Building Conversion Funnels
Video - 00:07:53 mins
017 ASSIGNMENT Analyzing Conversion Funnel Tests
Video - 00:01:49 mins
018 SOLUTION Analyzing Conversion Funnel Tests
Video - 00:06:57 mins
06 – MID-COURSE PROJECT
07 – Analysis for Channel Portfolio Management
Subtitle File Resource
Reading
001 Introduction
Video - 00:00:32 mins
002 Analyzing Channel Portfolios
Video - 00:09:04 mins
003 ASSIGNMENT Analyzing Channel Portfolios
Video - 00:01:21 mins
004 SOLUTION Analyzing Channel Portfolios
Video - 00:04:44 mins
005 ASSIGNMENT Comparing Channel Characteristics
Video - 00:00:50 mins
006 SOLUTION Comparing Channel Characteristics
Video - 00:04:11 mins
007 ASSIGNMENT Cross-Channel Bid Optimization
Video - 00:01:12 mins
008 SOLUTION Cross-Channel Bid Optimization
Video - 00:03:22 mins
009 ASSIGNMENT Analyzing Channel Portfolio Trends
Video - 00:01:06 mins
010 SOLUTION Analyzing Channel Portfolio Trends
Video - 00:07:23 mins
011 Analyzing Direct, Brand-Driven Traffic
Video - 00:07:21 mins
012 ASSIGNMENT Analyzing Direct Traffic
Video - 00:01:51 mins
013 SOLUTION Analyzing Direct Traffic
Video - 00:08:22 mins
08 – Analyzing Business Patterns and Seasonality
Subtitle File Resource
Reading
001 Analyzing Business Patterns
Video - 00:06:36 mins
002 ASSIGNMENT Analyzing Seasonality
Video - 00:01:07 mins
003 SOLUTION Analyzing Seasonality
Video - 00:05:33 mins
004 ASSIGNMENT Analyzing Business Patterns
Video - 00:01:19 mins
005 SOLUTION Analyzing Business Patterns
Video - 00:09:16 mins
09 – Product Analysis
Subtitle File Resource
Reading
001 Introduction
Video - 00:00:20 mins
002 Analyzing Product Sales
Video - 00:07:03 mins
003 ASSIGNMENT Product-Level Sales Analysis
Video - 00:01:05 mins
004 SOLUTION Product-Level Sales Analysis
Video - 00:02:18 mins
005 ASSIGNMENT Analyzing Product Launches
Video - 00:01:06 mins
006 SOLUTION Analyzing Product Launches
Video - 00:04:26 mins
007 Analyzing Product-Level Website Pathing
Video - 00:09:43 mins
008 ASSIGNMENT Product-Level Website Pathing
Video - 00:01:42 mins
009 SOLUTION Product-Level Website Pathing
Video - 00:10:44 mins
010 ASSIGNMENT Building Product-Level Conversion Funnels
Video - 00:01:55 mins
011 SOLUTION Building Product-Level Conversion Funnels
Video - 00:13:07 mins
012 Cross-Selling Product Portfolio Analysis
Video - 00:09:33 mins
013 ASSIGNMENT Cross-Sell Analysis
Video - 00:01:20 mins
014 SOLUTION Cross-Sell Analysis
Video - 00:12:28 mins
015 ASSIGNMENT Product Portfolio Expansion
Video - 00:01:00 mins
016 SOLUTION Product Portfolio Expansion
Video - 00:04:47 mins
017 Analyzing Product Refund Rates
Video - 00:04:59 mins
018 ASSIGNMENT Analyzing Product Refund Rates
Video - 00:01:11 mins
019 SOLUTION Analyzing Product Refund Rates
Video - 00:04:06 mins
10 – User Analysis
Subtitle File Resource
Reading
001 Introduction
Video - 00:00:16 mins
002 Analyzing Repeat Visit Purchase Behavior
Video - 00:06:48 mins
003 ASSIGNMENT Identifying Repeat Visitors
Video - 00:00:57 mins
004 SOLUTION Identifying Repeat Visitors
Video - 00:05:49 mins
005 ASSIGNMENT Analyzing Time to Repeat
Video - 00:00:55 mins
006 SOLUTION Analyzing Time to Repeat
Video - 00:04:40 mins
007 ASSIGNMENT Analyzing Repeat Channel Behavior
Video - 00:01:00 mins
008 SOLUTION Analyzing Repeat Channel Behavior
Video - 00:03:23 mins
009 ASSIGNMENT Analyzing New Repeat Conversion Rates
Video - 00:00:52 mins
010 SOLUTION Analyzing New Repeat Conversion Rates
Video - 00:02:53 mins
11 – FINAL PROJECT
12 – Wrapping Up
Please download the course resource files below, including:
Advanced_MySQL_Analysis.pdf (these are the course slides)
create_mavenfuzzyfactory_vApril2022.sql (this is the updated SQL script you will use to create the database)
preparing_workbench.sql (this is a SQL file you will use to alter some settings to make the database creation go smoothly)
Maven Fuzzy Factory Mid Course and Final Project Files (2 files, each containing solution SQL scripts that you can use to reference after complete the mid-course and final projects – but try on your own first…no peeking!)
NOTE: If you have trouble downloading the files, right-click and open the link in a new tab. If you continue to experience issues (i.e. 403 errors) please click here to download the files.
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%
