IIRF Online > Development > Database Design & Development > MySQL > Advanced SQL: MySQL for Ecommerce Data Analysis
Advanced SQL: MySQL for Ecommerce Data Analysis by Udemy
Learn advanced SQL data analysis & business intelligence with SQL + MySQL Workbench, with real-world Ecommerce projects!
Course Highlights
- Write advanced SQL queries to explore and analyze databases with MySQL Workbench
- Learn how to use subqueries and temporary tables to handle complex multi-step data problems
- Solve practical hands-on assignments and real-world eCommerce use cases
- Analyze data across multiple tables with powerful MySQL JOIN statements
- Master unique tips and tools that you won't find anywhere else
- Get LIFETIME access to resource files, quizzes, assignments, and expert support
Skills you will learn!
Curriculum
5 Topics
Course Structure & Outline
READ ME: Important Notes for New Students
DOWNLOAD: Course Resources
Introducing the Course Project - Play the Role of Business Analyst
Setting Expectations - Focus on Business Analysis NOT MySQL Administration
3 Topics
Introduction
Prerequisite Skills - Taught in my SQL Database for Beginners course
Prerequisite Skills Quiz
10 Topics
Introduction
MySQL Installation Overview - MySQL Community Server & MySQL Workbench
Mac Download - MySQL Community Server
Mac Download - MySQL Workbench
PC Download - MySQL Community Server & MySQL Workbench
Connecting MySQL Workbench to the Server
MySQL Workbench Interface
Creating the Maven Fuzzy Factory Database
Getting to Know the Database
USE mavenfuzzyfactory;
13 Topics
Introduction
Analyzing Top Traffic Sources
ASSIGNMENT: Finding Top Traffic Sources
SOLUTION: Finding Top Traffic Sources
ASSIGNMENT: Traffic Source Conversion Rates
SOLUTION: Traffic Source Conversion Rates
Bid Optimization & Trend Analysis
ASSIGNMENT: Traffic Source Trending
SOLUTION: Traffic Source Trending
ASSIGNMENT: Bid Optimization for Paid Traffic
SOLUTION: Bid Optimization for Paid Traffic
ASSIGNMENT: Trending w/ Granular Segments
SOLUTION: Trending w/ Granular Segments
18 Topics
Introduction
Analyzing Top Website Pages & Entry Pages
ASSIGNMENT: Finding Top Website Pages
SOLUTION: Finding Top Website Pages
ASSIGNMENT: Finding Top Entry Pages
SOLUTION: Finding Top Entry Pages
Analyzing Bounce Rates & Landing Page Tests
ASSIGNMENT: Calculating Bounce Rates
SOLUTION: Calculating Bounce Rates
ASSIGNMENT: Analyzing Landing Page Tests
SOLUTION: Analyzing Landing Page Tests
ASSIGNMENT: Landing Page Trend Analysis
SOLUTION: Landing Page Trend Analysis
Building Conversion Funnels & Testing Conversion Paths
ASSIGNMENT: Building Conversion Funnels
SOLUTION: Building Conversion Funnels
ASSIGNMENT: Analyzing Conversion Funnel Tests
SOLUTION: Analyzing Conversion Funnel Tests
3 Topics
Introduction
ASSIGNMENT: Mid-Course Project
SOLUTION: Mid-Course Project
13 Topics
Introduction
Analyzing Channel Portfolios
ASSIGNMENT: Analyzing Channel Portfolios
SOLUTION: Analyzing Channel Portfolios
ASSIGNMENT: Comparing Channel Characteristics
SOLUTION: Comparing Channel Characteristics
ASSIGNMENT: Cross-Channel Bid Optimization
SOLUTION: Cross-Channel Bid Optimization
ASSIGNMENT: Analyzing Channel Portfolio Trends
SOLUTION: Analyzing Channel Portfolio Trends
Analyzing Direct Brand-Driven Traffic
ASSIGNMENT: Analyzing Direct Traffic
SOLUTION: Analyzing Direct Traffic
5 Topics
Analyzing Business Patterns & Seasonality
ASSIGNMENT: Analyzing Seasonality
SOLUTION: Analyzing Seasonality
ASSIGNMENT: Analyzing Business Patterns
SOLUTION: Analyzing Business Patterns
19 Topics
Introduction
Analyzing Product Sales & Product Launches
ASSIGNMENT: Product-Level Sales Analysis
SOLUTION: Product-Level Sales Analysis
ASSIGNMENT: Analyzing Product Launches
SOLUTION: Analyzing Product Launches
Analyzing Product-Level Website Pathing
ASSIGNMENT: Product-Level Website Pathing
SOLUTION: Product-Level Website Pathing
ASSIGNMENT: Building Product-Level Conversion Funnels
SOLUTION: Building Product-Level Conversion Funnels
Cross-Selling & Product Portfolio Analysis
ASSIGNMENT: Cross-Sell Analysis
SOLUTION: Cross-Sell Analysis
ASSIGNMENT: Product Portfolio Expansion
SOLUTION: Product Portfolio Expansion
Analyzing Product Refund Rates
ASSIGNMENT: Analyzing Product Refund Rates
SOLUTION: Analyzing Product Refund Rates
10 Topics
Introduction
Analyzing Repeat Visit & Purchase Behavior
ASSIGNMENT: Identifying Repeat Visitors
SOLUTION: Identifying Repeat Visitors
ASSIGNMENT: Analyzing Time to Repeat
SOLUTION: Analyzing Time to Repeat
ASSIGNMENT: Analyzing Repeat Channel Behavior
SOLUTION: Analyzing Repeat Channel Behavior
ASSIGNMENT: Analyzing New & Repeat Conversion Rates
SOLUTION: Analyzing New & Repeat Conversion Rates
3 Topics
Introduction
ASSIGNMENT: Final Project
SOLUTION: Final Project
2 Topics
Resources & Next Steps
BONUS LESSON
Advanced SQL: MySQL for Ecommerce Data Analysis
Related MySQL Courses
Thank You!
Your review has been submitted successfully.