Course Content
Subtitle Guide – Hướng dẫn thêm phụ đề
0/1
Set up subtitle for video – Hướng dẫn thêm phụ đề
01 – Getting Started
0/6
Subtitle File Resource
001 Course Structure Outline
02:07
002 READ ME Important Notes for New Students
003 DOWNLOAD Course Resources
004 Introducing the Course Project
02:16
005 Setting Expectations
02:17
02 – Prerequisite Skills
0/3
Subtitle File Resource
001 Introduction
00:34
002 Prerequisite Skills
04:38
03 – MySQL Intro & Setup
0/11
Subtitle File Resource
001 Introduction
00:25
002 MySQL Installation Overview
02:27
003 Mac Download – MySQL Community Server
04:53
004 Mac Download – MySQL Workbench
02:51
005 PC Download – MySQL Community Server
07:41
006 Connecting MySQL Workbench to the Server
02:20
007 MySQL Workbench Interface
01:34
008 Creating the Maven Fuzzy Factory Database
07:52
009 Getting to Know the Database
04:20
010 USE mavenfuzzyfactory
02:27
04 – Analyzing Traffic Sources
0/13
Subtitle File Resource
001 Introduction
00:19
002 Analyzing Top Traffic Sources
18:59
003 ASSIGNMENT Finding Top Traffic Sources
02:17
004 SOLUTION Finding Top Traffic Sources
04:03
005 ASSIGNMENT Traffic Source Conversion Rates
01:05
006 SOLUTION Traffic Source Conversion Rates
04:51
008 ASSIGNMENT Traffic Source Trending
00:58
009 SOLUTION Traffic Source Trending
04:50
010 ASSIGNMENT Bid Optimization for Paid Traffic
02:13
011 SOLUTION Bid Optimization for Paid Traffic
05:12
012 ASSIGNMENT Trending w Granular Segments
01:31
013 SOLUTION Trending w Granular Segments
05:42
05 – Analyzing Website Performance
0/19
Subtitle File Resource
001 Introduction
00:19
002 Analyzing Top Website Pages
16:42
003 ASSIGNMENT Finding Top Website Pages
00:59
004 SOLUTION Finding Top Website Pages
03:15
005 ASSIGNMENT Finding Top Entry Pages
01:08
006 SOLUTION Finding Top Entry Pages
07:58
007 Analyzing Bounce Rates
14:21
008 ASSIGNMENT Calculating Bounce Rates
00:40
009 SOLUTION Calculating Bounce Rates
09:26
010 ASSIGNMENT Analyzing Landing Page Tests
02:12
011 SOLUTION Analyzing Landing Page Tests
11:56
012 ASSIGNMENT Landing Page Trend Analysis
01:09
013 SOLUTION Landing Page Trend Analysis
07:40
014 Building Conversion Funnels
17:19
015 ASSIGNMENT Building Conversion Funnels
01:26
016 SOLUTION Building Conversion Funnels
07:53
017 ASSIGNMENT Analyzing Conversion Funnel Tests
01:49
018 SOLUTION Analyzing Conversion Funnel Tests
06:57
06 – MID-COURSE PROJECT
0/4
Subtitle File Resource
001 Introduction
00:13
002 ASSIGNMENT Mid-Course Project
01:37
003 SOLUTION Mid-Course Project
30:03
07 – Analysis for Channel Portfolio Management
0/14
Subtitle File Resource
001 Introduction
00:32
002 Analyzing Channel Portfolios
09:04
003 ASSIGNMENT Analyzing Channel Portfolios
01:21
004 SOLUTION Analyzing Channel Portfolios
04:44
005 ASSIGNMENT Comparing Channel Characteristics
00:50
006 SOLUTION Comparing Channel Characteristics
04:11
007 ASSIGNMENT Cross-Channel Bid Optimization
01:12
008 SOLUTION Cross-Channel Bid Optimization
03:22
009 ASSIGNMENT Analyzing Channel Portfolio Trends
01:06
010 SOLUTION Analyzing Channel Portfolio Trends
07:23
011 Analyzing Direct, Brand-Driven Traffic
07:21
012 ASSIGNMENT Analyzing Direct Traffic
01:51
013 SOLUTION Analyzing Direct Traffic
08:22
08 – Analyzing Business Patterns and Seasonality
0/6
Subtitle File Resource
001 Analyzing Business Patterns
06:36
002 ASSIGNMENT Analyzing Seasonality
01:07
003 SOLUTION Analyzing Seasonality
05:33
004 ASSIGNMENT Analyzing Business Patterns
01:19
005 SOLUTION Analyzing Business Patterns
09:16
09 – Product Analysis
0/20
Subtitle File Resource
001 Introduction
00:20
002 Analyzing Product Sales
07:03
003 ASSIGNMENT Product-Level Sales Analysis
01:05
004 SOLUTION Product-Level Sales Analysis
02:18
005 ASSIGNMENT Analyzing Product Launches
01:06
006 SOLUTION Analyzing Product Launches
04:26
007 Analyzing Product-Level Website Pathing
09:43
008 ASSIGNMENT Product-Level Website Pathing
01:42
009 SOLUTION Product-Level Website Pathing
10:44
010 ASSIGNMENT Building Product-Level Conversion Funnels
01:55
011 SOLUTION Building Product-Level Conversion Funnels
13:07
012 Cross-Selling Product Portfolio Analysis
09:33
013 ASSIGNMENT Cross-Sell Analysis
01:20
014 SOLUTION Cross-Sell Analysis
12:28
015 ASSIGNMENT Product Portfolio Expansion
01:00
016 SOLUTION Product Portfolio Expansion
04:47
017 Analyzing Product Refund Rates
04:59
018 ASSIGNMENT Analyzing Product Refund Rates
01:11
019 SOLUTION Analyzing Product Refund Rates
04:06
10 – User Analysis
0/11
Subtitle File Resource
001 Introduction
00:16
002 Analyzing Repeat Visit Purchase Behavior
06:48
003 ASSIGNMENT Identifying Repeat Visitors
00:57
004 SOLUTION Identifying Repeat Visitors
05:49
005 ASSIGNMENT Analyzing Time to Repeat
00:55
006 SOLUTION Analyzing Time to Repeat
04:40
007 ASSIGNMENT Analyzing Repeat Channel Behavior
01:00
008 SOLUTION Analyzing Repeat Channel Behavior
03:23
009 ASSIGNMENT Analyzing New Repeat Conversion Rates
00:52
010 SOLUTION Analyzing New Repeat Conversion Rates
02:53
11 – FINAL PROJECT
0/4
Subtitle File Resource
001 Introduction
00:23
002 ASSIGNMENT Final Project
01:54
003 SOLUTION Final Project
26:43
12 – Wrapping Up
0/1
001 Resources & Next Steps
Advanced SQL: MySQL for Data Analysis
About Lesson

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.

Exercise Files
Resource.zip
Size: 27.46 MB
Previous
Next

Please contact me via telegram

DMCA.com Protection Status