Sale!

Advanced SQL: MySQL Data Analysis & Business Intelligence – Udemy

(10 customer reviews)

$23

Category:

Description

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

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)

Course content

  • Getting Started
  • Prerequisite Skills
  • MySQL Intro & Setup
  • Analyzing Traffic Sources
  • Analyzing Website Performance
  • MID-COURSE PROJECT
  • Analysis for Channel Portfolio Management
  • Analyzing Business Patterns and Seasonality
  • Product Analysis
  • User Analysis

10 reviews for Advanced SQL: MySQL Data Analysis & Business Intelligence – Udemy

  1. Donny Phan

    Super practical. Lessons are catered towards anyone looking to find work in this industry. It felt very comprehensive and gave me a broad understanding of the programming spectrum

  2. Madhav raj Verma

    Thanks for your great effort. i am fully satisfied with this course the way you teach and your explanation are very clear ,The content you provide in your course no one can do this at this price.

  3. Sachin Gupta

    I really didn’t want to leave a low rating as Angela is a great teacher. The 1st half of this course was terrific. The 2nd half was terrible. Under the justification of “teaching students how to figure things out on their own”, pretty much all videos and all explanations were dropped. You were just told what to do, given links to documentation and told to figure it out on your own. I understand doing that to some degree, but to revert to that entirely for nearly half the content barely makes this a course. It’s just a list of things for you to learn, then you’re left on your own to learn them. The 2nd half was so bad, especially the data science component, that I didn’t bother finishing the course.

  4. Vincent Beaudet

    Amazing 40 days course.
    Angela is a great teacher.
    The other 60 days are all about web developement, interacting with web pages, on your own with little to no explanations. I did not expect that at all. I wanted to learn more about software and scripting.
    This left me disappointed , confused and i started to doubt myself. Not a fun experience after the amount of effort i’v put in this course.

    Exercices format and explanations for the first 40 days were worth it tho.

  5. Ben K

    Not just an introduction to python, but really helps you learn fundamental aspects of python and coding in general. Some parts may require some knowledge on the subject (data science comes to mind) and there is quite some web development in the course. So, a few areas were not completely to my liking (I would have liked to see it done differently), but this course deserves the 5 stars in my opinion.

  6. Omid Alikhel

    I found the method a bit difficult when a code is written and then changed back to something different, with no enough explanation of how something happened and where it came from or a step by step explanation of why something is happening, i have no doubt in the instructors talent, but we are beginners!

  7. Alica Cverdeľová

    I love this course, Angela explained it very easily and clearly from the beginning, but I loved her 1 minute final videos, which ended later: What a pity.
    BUT I felt a little disappointed now with the project Day 39/40. Where I was maximally lost, I could not come out of where to look for anything and it was poorly explained and the biggest mistake was that there were no videos with explanations, I think it was quite a complicated project where many things were used and no explanation, only the final results. And they carried a few things in the projects before, so I had her project run once and it showed her the mistake as well as me, so in that case you have to leave it at that and what else is a shame. It’s hard to do a project when you don’t see what’s going on there.
    I’m a little worried about the next few weeks, and I hope it won’t be a waste of time.

  8. Szymon Kozak

    I think that the course tutor is really good in giving right information to learn at the right time. Thanks to this fact, my understanding of coding in python after 29 days of learning is above my expectations.

  9. Begoña Ruiz Diaz

    Ha sido la mejor elección que podría haber hecho.

  10. Vaibhav Sachdeva

    I want to thank Angela for making such an amazing course. It really helped me explore more things with python.

Add a review

Your email address will not be published.