Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-02-15 15:14:40
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence MySQL

Advanced SQL: MySQL Data Analysis & Business Intelligence

Master advanced SQL database coding w/ MySQL Workbench. My SQL course takes your SQL analysis skills to new heights!
Highest Rated
Rating: 4.7 out of 54.7 (1,624 ratings)
21,255 students
Created by Maven Analytics, John Pauler
Last updated 2/2021
English
English [Auto]
30-Day Money-Back Guarantee

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
Curated for the Udemy for Business collection

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 MySQL courses. 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)

______________________________

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)

Featured review

Lane Ferm
Lane Ferm
8 courses
6 reviews
Rating: 5.0 out of 58 months ago
Great course ! I’ll definitely recommend it. I thought it had a few too many assignments, but all in all, excellent. Excited about how much I’ve learned and looking forward to a great career !! Thanks a million !! Excellent instructor !! Tops !!

Course content

12 sections • 104 lectures • 8h 6m total length

  • Preview02:07
  • READ ME: Important Notes for New Students
    01:54
  • DOWNLOAD: Course Resources
    00:23
  • Preview02:16
  • Setting Expectations - Focus on Business Analysis, NOT MySQL Administration
    02:17

  • Introduction
    00:34
  • Preview04:38
  • Prerequisite Skills Quiz
    15 questions

  • Preview00:25
  • MySQL Installation Overview - MySQL Community Server & MySQL Workbench
    02:27
  • Mac Download - MySQL 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
  • Preview04:20
  • USE mavenfuzzyfactory;
    02:26

  • Preview00:19
  • Analyzing Top Traffic Sources
    Preview18:59
  • Preview02:17
  • Preview04:03
  • 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

  • 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

  • Introduction
    00:13
  • ASSIGNMENT: Mid-Course Project
    01:37
  • SOLUTION: Mid-Course Project
    30:03

  • 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 & 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

  • 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

  • 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

Instructors

Maven Analytics
Award-Winning Analytics & Business Intelligence Training
Maven Analytics
  • 4.6 Instructor Rating
  • 147,236 Reviews
  • 448,316 Students
  • 20 Courses

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience.

Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand.

John Pauler
Analytics Expert
John Pauler
  • 4.7 Instructor Rating
  • 5,920 Reviews
  • 36,779 Students
  • 4 Courses

Over a decade of Analytics experience for companies ranging from Fortune 500 to early stage startups. I work with data from websites, customers, marketing channels, and software products. I have been a pure play Analyst, and I have also led large Marketing P&Ls and served as a Product Owner. Throughout it all, I've made data mastery a pillar of my career, and am excited to share my experience on Udemy.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.