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!
Advanced SQL MySQL Data Analysis Business Intelligence
File Size :
3.48 GB
Total length :
8h 11m

Category

Instructor

Maven Analytics

Language

Last update

Last updated 10/2022

Ratings

4.6/5

Advanced SQL MySQL Data Analysis Business Intelligence

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

Advanced SQL MySQL Data Analysis Business Intelligence

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!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 AssessmentIn 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 & InstallFor 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 & OptimizationIn 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 & TestingIn 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 meetingChannel Analysis & OptimizationIn 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 AnalysisIn 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 AnalysisIn 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 investorsUnlike 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 videoDownloadable MySQL ebookQuizzes and hands-on projectsMid-course and Final SQL projects30-day money-back guaranteeIMPORTANT 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!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.

Overview

Section 1: Getting Started

Lecture 1 Course Structure & Outline

Lecture 2 READ ME: Important Notes for New Students

Lecture 3 DOWNLOAD: Course Resources

Lecture 4 Introducing the Course Project – Play the Role of Business Analyst

Lecture 5 Setting Expectations – Focus on Business Analysis, NOT MySQL Administration

Section 2: Prerequisite Skills

Lecture 6 Introduction

Lecture 7 Prerequisite Skills – Taught in my SQL Database for Beginners course

Section 3: MySQL Intro & Setup

Lecture 8 Introduction

Lecture 9 MySQL Installation Overview – MySQL Community Server & MySQL Workbench

Lecture 10 Mac Download – MySQL Community Server

Lecture 11 Mac Download – MySQL Workbench

Lecture 12 PC Download – MySQL Community Server & MySQL Workbench

Lecture 13 Connecting MySQL Workbench to the Server

Lecture 14 MySQL Workbench Interface

Lecture 15 Creating the Maven Fuzzy Factory Database

Lecture 16 Getting to Know the Database

Lecture 17 USE mavenfuzzyfactory;

Section 4: Analyzing Traffic Sources

Lecture 18 Introduction

Lecture 19 Analyzing Top Traffic Sources

Lecture 20 ASSIGNMENT: Finding Top Traffic Sources

Lecture 21 SOLUTION: Finding Top Traffic Sources

Lecture 22 ASSIGNMENT: Traffic Source Conversion Rates

Lecture 23 SOLUTION: Traffic Source Conversion Rates

Lecture 24 Bid Optimization & Trend Analysis

Lecture 25 ASSIGNMENT: Traffic Source Trending

Lecture 26 SOLUTION: Traffic Source Trending

Lecture 27 ASSIGNMENT: Bid Optimization for Paid Traffic

Lecture 28 SOLUTION: Bid Optimization for Paid Traffic

Lecture 29 ASSIGNMENT: Trending w/ Granular Segments

Lecture 30 SOLUTION: Trending w/ Granular Segments

Section 5: Analyzing Website Performance

Lecture 31 Introduction

Lecture 32 Analyzing Top Website Pages & Entry Pages

Lecture 33 ASSIGNMENT: Finding Top Website Pages

Lecture 34 SOLUTION: Finding Top Website Pages

Lecture 35 ASSIGNMENT: Finding Top Entry Pages

Lecture 36 SOLUTION: Finding Top Entry Pages

Lecture 37 Analyzing Bounce Rates & Landing Page Tests

Lecture 38 ASSIGNMENT: Calculating Bounce Rates

Lecture 39 SOLUTION: Calculating Bounce Rates

Lecture 40 ASSIGNMENT: Analyzing Landing Page Tests

Lecture 41 SOLUTION: Analyzing Landing Page Tests

Lecture 42 ASSIGNMENT: Landing Page Trend Analysis

Lecture 43 SOLUTION: Landing Page Trend Analysis

Lecture 44 Building Conversion Funnels & Testing Conversion Paths

Lecture 45 ASSIGNMENT: Building Conversion Funnels

Lecture 46 SOLUTION: Building Conversion Funnels

Lecture 47 ASSIGNMENT: Analyzing Conversion Funnel Tests

Lecture 48 SOLUTION: Analyzing Conversion Funnel Tests

Section 6: MID-COURSE PROJECT

Lecture 49 Introduction

Lecture 50 ASSIGNMENT: Mid-Course Project

Lecture 51 SOLUTION: Mid-Course Project

Section 7: Analysis for Channel Portfolio Management

Lecture 52 Introduction

Lecture 53 Analyzing Channel Portfolios

Lecture 54 ASSIGNMENT: Analyzing Channel Portfolios

Lecture 55 SOLUTION: Analyzing Channel Portfolios

Lecture 56 ASSIGNMENT: Comparing Channel Characteristics

Lecture 57 SOLUTION: Comparing Channel Characteristics

Lecture 58 ASSIGNMENT: Cross-Channel Bid Optimization

Lecture 59 SOLUTION: Cross-Channel Bid Optimization

Lecture 60 ASSIGNMENT: Analyzing Channel Portfolio Trends

Lecture 61 SOLUTION: Analyzing Channel Portfolio Trends

Lecture 62 Analyzing Direct, Brand-Driven Traffic

Lecture 63 ASSIGNMENT: Analyzing Direct Traffic

Lecture 64 SOLUTION: Analyzing Direct Traffic

Section 8: Analyzing Business Patterns and Seasonality

Lecture 65 Analyzing Business Patterns & Seasonality

Lecture 66 ASSIGNMENT: Analyzing Seasonality

Lecture 67 SOLUTION: Analyzing Seasonality

Lecture 68 ASSIGNMENT: Analyzing Business Patterns

Lecture 69 SOLUTION: Analyzing Business Patterns

Section 9: Product Analysis

Lecture 70 Introduction

Lecture 71 Analyzing Product Sales & Product Launches

Lecture 72 ASSIGNMENT: Product-Level Sales Analysis

Lecture 73 SOLUTION: Product-Level Sales Analysis

Lecture 74 ASSIGNMENT: Analyzing Product Launches

Lecture 75 SOLUTION: Analyzing Product Launches

Lecture 76 Analyzing Product-Level Website Pathing

Lecture 77 ASSIGNMENT: Product-Level Website Pathing

Lecture 78 SOLUTION: Product-Level Website Pathing

Lecture 79 ASSIGNMENT: Building Product-Level Conversion Funnels

Lecture 80 SOLUTION: Building Product-Level Conversion Funnels

Lecture 81 Cross-Selling & Product Portfolio Analysis

Lecture 82 ASSIGNMENT: Cross-Sell Analysis

Lecture 83 SOLUTION: Cross-Sell Analysis

Lecture 84 ASSIGNMENT: Product Portfolio Expansion

Lecture 85 SOLUTION: Product Portfolio Expansion

Lecture 86 Analyzing Product Refund Rates

Lecture 87 ASSIGNMENT: Analyzing Product Refund Rates

Lecture 88 SOLUTION: Analyzing Product Refund Rates

Section 10: User Analysis

Lecture 89 Introduction

Lecture 90 Analyzing Repeat Visit & Purchase Behavior

Lecture 91 ASSIGNMENT: Identifying Repeat Visitors

Lecture 92 SOLUTION: Identifying Repeat Visitors

Lecture 93 ASSIGNMENT: Analyzing Time to Repeat

Lecture 94 SOLUTION: Analyzing Time to Repeat

Lecture 95 ASSIGNMENT: Analyzing Repeat Channel Behavior

Lecture 96 SOLUTION: Analyzing Repeat Channel Behavior

Lecture 97 ASSIGNMENT: Analyzing New & Repeat Conversion Rates

Lecture 98 SOLUTION: Analyzing New & Repeat Conversion Rates

Section 11: FINAL PROJECT

Lecture 99 Introduction

Lecture 100 ASSIGNMENT: Final Project

Lecture 101 SOLUTION: Final Project

Section 12: Wrapping Up

Lecture 102 Resources & Next Steps

Lecture 103 BONUS LESSON

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 Information:

Udemy | English | 8h 11m | 3.48 GB
Created by: Maven Analytics

You Can See More Courses in the Business >> Greetings from CourseDown.com

New Courses

Scroll to Top