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