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
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%
