Advanced SQL + MySQL for Analytics & Business Intelligence
4.7 (945 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
17,223 students enrolled

Advanced SQL + MySQL for Analytics & Business Intelligence

Master Advanced Databases and SQL Querying. Gain Advanced MySQL Workbench Skills w/ Advanced SQL Queries & Data Analysis
Highest Rated
4.7 (945 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
17,223 students enrolled
Last updated 6/2020
English
English [Auto]
Current price: $121.99 Original price: $174.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 8.5 hours on-demand video
  • 5 articles
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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
Requirements
  • MySQL Workbench and Community Server for Mac or Windows/PC (we’ll walk you through the free install process)
  • Students are expected to have completed our SQL for Beginners course, and have a solid grasp of SELECT statements, aggregate functions, and table joins
Description

IMPORTANT NOTE: This is an advanced SQL course, which builds on the skills covered in our introductory course: MySQL for Data Analysis - SQL Database for Beginners. Please review the prerequisite skills or complete the beginner SQL course before taking this one!

______________________________

See why John is one of the TOP-RATED SQL/MySQL Instructors on Udemy:

"I totally loved this course! Everything was easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn't want to stop learning -- I wanted to keep charging on to the next lesson!"

- Ann S.

"This is an excellent advanced course! I've taken both SQL courses from Maven Analytics and highly recommend both. The best part of this course is the detail they included by building a real world e-commerce database. It's much easier to grasp the concepts when you can see how they're literally applied to scenarios and outcomes as opposed to just theory. Great work!"

- Dan S.

"John's deep understanding of SQL and database analysis and ability to explain those tools is really unmatched. I've taken other SQL and MySQL courses and tried reading books, but this course is by far the most effective. Excited to see more courses from John!"

- Steven M.

______________________________

COURSE DESCRIPTION:

If you want to develop practical, real-world analytics & BI skills using advanced SQL, you're in the right place.


This course is unlike anything you’ve seen before, guaranteed. Instead of using random sample data and obscure demos, we’ll be working with a rich, custom-built eCommerce database that we’ve designed from scratch to help you apply your SQL skills to real projects and learn how to truly THINK like an analyst.


You’ll be playing the role of a newly hired Database Analyst for Maven Fuzzy Factory, an eCommerce start-up, and will be working directly with the CEO, Marketing Director and Website Manager to help grow the business and analyze performance along the way. You'll use a range of advanced SQL tools and techniques, and work through actual projects that data analysts and business intelligence professionals work on every day.

______________________________

COURSE OUTLINE:

  • Prerequisite SQL Skills Assessment

    In this section we'll address the core SQL/MySQL skills that you should be comfortable with before starting the course, including SELECT statements, aggregate functions, and table joins. If you aren't sure how your skills stack up, we've included a quiz to assess your baseline SQL knowledge.


  • MySQL Setup & Install

    For students who haven't completed our intro course, we'll demonstrate exactly how to download and install the tools that we'll need to access MySQL, including MySQL Community Server & MySQL Workbench. We'll share download guides for both Mac & PC, and run our first piece of SQL code to generate the project database that we'll analyze throughout the course.


  • Traffic Analysis & Optimization

    In this section we’ll use MySQL to analyze where our website traffic is coming from, how different sources perform in terms of traffic volume and conversion rates, and how we can adjust bids to optimize our budgets.


  • Website Measurement & Testing

    In this section we'll dive into page-level website data to compare traffic and conversion rates, and use MySQL to build and analyze conversion funnels to help optimize the customer purchase experience.


    ***MID-COURSE PROJECT: Preparing data for the executive board meeting


  • Channel Analysis & Optimization

    In this section we’ll dig deeper into our traffic channel mix, explore paid vs. free traffic, break down performance by device type, and write advanced SQL queries to conduct some time-series analyses to understand trending and seasonality.


  • Product-Level Analysis

    In this section we’ll use MySQL to break down product-level sales and conversion rates, analyze cross-selling patterns, and use refund rates to keep a pulse on quality.


  • User-Level Analysis

    In this section we’ll take a closer look at user behavior and repeat sessions, and use MySQL techniques to identify our most valuable customers and explore which channels they are coming from.


    ***FINAL PROJECT: Building a data-driven growth story for potential investors

______________________________

Unlike other SQL courses, this one is uniquely designed to sharpen your business intelligence and analytical thinking skills; as you complete course projects and exercises, you’ll actually see patterns and trends emerging in the data based on your findings. For those looking to pursue a career in analytics, this course is a must.


Enroll today and get LIFETIME access to:

  • 8+ hours of high-quality video

  • Downloadable MySQL ebook

  • Quizzes and hands-on projects

  • Mid-course and Final SQL projects

  • 30-day money-back guarantee


IMPORTANT NOTE: This course does NOT cover building, altering, or maintaining SQL/MySQL databases. Our goal here is to focus on data exploration and database analysis using MySQL and MySQL Workbench (we'll cover database administration tools in a separate course).


Happy analyzing!

-John (Lead SQL Instructor & MySQL Expert, Maven Analytics)

______________________________


Most students in this course enroll in our full MySQL LEARNING PATH, designed to help you build a deep, expert-level MySQL skill set:

  1. MySQL Database Administration

  2. MySQL Data Analysis (Beginner)

  3. MySQL Data Analysis (Advanced) (You are here)

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

Who this course is for:
  • Analysts or BI professionals looking to quickly retrieve or analyze data stored in relational database systems
  • Excel users looking to shift into a broader business intelligence or database-focused role
  • SQL users looking to develop advanced skills and master one of the world’s most popular and powerful database programming languages
  • Students looking for a hands-on, practical, and highly engaging way to master MySQL for data analysis and business intelligence
  • Anyone looking to pursue a career in data analysis or business intelligence
  • NOTE: This course is NOT for database administrators (we won't cover tools to build or maintain databases in this course)
Course content
Expand all 106 lectures 08:31:24
+ Getting Started
5 lectures 08:49
READ ME: Important Notes for New Students
01:54
DOWNLOAD: Course Resources
00:15
Setting Expectations - Focus on Business Analysis, NOT MySQL Administration
02:17
+ Prerequisite Skills
2 lectures 05:12
Introduction
00:34

This quiz covers the SQL skills that students should be comfortable with already in order to be ready to take this advanced course.

Prerequisite Skills Quiz
15 questions
+ MySQL Intro & Setup
11 lectures 33:24
MySQL Installation Overview - MySQL Community Server & MySQL Workbench
02:27
MAC Download: Community Server
04:53
MAC Download: MySQL Workbench
02:50
PC Download: MySQL Community Server + MySQL Workbench
07:41
Connecting MySQL Workbench to the Server
02:20
MySQL Workbench Interface
01:34
Prepare to Create the Database
00:54
Creating the Maven Fuzzy Factory Database
03:34
USE mavenfuzzyfactory;
02:26
+ Analyzing Traffic Sources
13 lectures 01:07:53
ASSIGNMENT: Traffic Source Conversion Rates
01:05
SOLUTION: Traffic Source Conversion Rates
04:51
Bid Optimization & Trend Analysis
15:54
ASSIGNMENT: Traffic Source Trending
00:58
SOLUTION: Traffic Source Trending
04:50
ASSIGNMENT: Bid Optimization for Paid Traffic
02:12
SOLUTION: Bid Optimization for Paid Traffic
05:12
ASSIGNMENT: Trending w/ Granular Segments
01:31
SOLUTION: Trending w/ Granular Segments
05:42
+ Analyzing Website Performance
18 lectures 01:53:06
Introduction
00:19
Analyzing Top Website Pages & Entry Pages
16:42
ASSIGNMENT: Finding Top Website Pages
00:59
SOLUTION: Finding Top Website Pages
03:15
ASSIGNMENT: Finding Top Entry Pages
01:07
SOLUTION: Finding Top Entry Pages
07:58
Analyzing Bounce Rates & Landing Page Tests
14:21
ASSIGNMENT: Calculating Bounce Rates
00:39
SOLUTION: Calculating Bounce Rates
09:25
ASSIGNMENT: Analyzing Landing Page Tests
02:12
SOLUTION: Analyzing Landing Page Tests
11:56
ASSIGNMENT: Landing Page Trend Analysis
01:09
SOLUTION: Landing Page Trend Analysis
07:40
Building Conversion Funnels & Testing Conversion Paths
17:19
ASSIGNMENT: Building Conversion Funnels
01:26
SOLUTION: Building Conversion Funnels
07:53
ASSIGNMENT: Analyzing Conversion Funnel Tests
01:49
SOLUTION: Analyzing Conversion Funnel Tests
06:57
+ MID-COURSE PROJECT
3 lectures 31:53
Introduction
00:13
ASSIGNMENT: Mid-Course Project
01:37
SOLUTION: Mid-Course Project
30:03
+ Analysis for Channel Portfolio Management
13 lectures 51:17
Introduction
00:32
Analyzing Channel Portfolios
09:04
ASSIGNMENT: Analyzing Channel Portfolios
01:21
SOLUTION: Analyzing Channel Portfolios
04:44
ASSIGNMENT: Comparing Channel Characteristics
00:50
SOLUTION: Comparing Channel Characteristics
04:11
ASSIGNMENT: Cross-Channel Bid Optimization
01:11
SOLUTION: Cross-Channel Bid Optimization
03:22
ASSIGNMENT: Analyzing Channel Portfolio Trends
01:06
SOLUTION: Analyzing Channel Portfolio Trends
07:23
Analyzing Direct, Brand-Driven Traffic
07:21
ASSIGNMENT: Analyzing Direct Traffic
01:50
SOLUTION: Analyzing Direct Traffic
08:22
+ Analyzing Business Patterns and Seasonality
5 lectures 23:50
Analyzing Business Patterns & Seasonality
06:36
ASSIGNMENT: Analyzing Seasonality
01:06
SOLUTION: Analyzing Seasonality
05:33
ASSIGNMENT: Analyzing Business Patterns
01:19
SOLUTION: Analyzing Business Patterns
09:16
+ Product Analysis
19 lectures 01:32:51
Introduction
00:20
Analyzing Product Sales & Product Launches
07:03
ASSIGNMENT: Product-Level Sales Analysis
01:05
SOLUTION: Product-Level Sales Analysis
02:18
ASSIGNMENT: Analyzing Product Launches
01:05
SOLUTION: Analyzing Product Launches
04:26
Analyzing Product-Level Website Pathing
09:42
ASSIGNMENT: Product-Level Website Pathing
01:42
SOLUTION: Product-Level Website Pathing
10:44
ASSIGNMENT: Building Product-Level Conversion Funnels
01:55
SOLUTION: Building Product-Level Conversion Funnels
13:07
Cross-Selling & Product Portfolio Analysis
09:33
ASSIGNMENT: Cross-Sell Analysis
01:20
SOLUTION: Cross-Sell Analysis
12:28
ASSIGNMENT: Product Portfolio Expansion
01:00
SOLUTION: Product Portfolio Expansion
04:47
Analyzing Product Refund Rates
04:59
ASSIGNMENT: Analyzing Product Refund Rates
01:11
SOLUTION: Analyzing Product Refund Rates
04:06
+ User Analysis
10 lectures 27:32
Introduction
00:16
Analyzing Repeat Visit & Purchase Behavior
06:48
ASSIGNMENT: Identifying Repeat Visitors
00:57
SOLUTION: Identifying Repeat Visitors
05:49
ASSIGNMENT: Analyzing Time to Repeat
00:55
SOLUTION: Analyzing Time to Repeat
04:40
ASSIGNMENT: Analyzing Repeat Channel Behavior
01:00
SOLUTION: Analyzing Repeat Channel Behavior
03:22
ASSIGNMENT: Analyzing New & Repeat Conversion Rates
00:52
SOLUTION: Analyzing New & Repeat Conversion Rates
02:53