Advanced SQL: MySQL for Ecommerce & Web Analytics
Advanced SQL: MySQL for Ecommerce & Web Analytics
Learn data analytics & business intelligence with SQL + MySQL Workbench, and apply your skills to real-world projects!
Created by Maven Anallytics, John Pauler | 8 hours on-demand video course
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.
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
Recommended Course
