SQL - Advanced MySQL for Analytics & Business Intelligence (Udemy.com)

Master Advanced Databases and SQL Querying. Gain Advanced MySQL Workbench Skills w/ Advanced SQL Queries & Data Analysis

( 0 Reviews )

Created by: Maven Analytics

Produced in 2021

What you will 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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 0 / 100

Course Description

IMPORTANTNOTE:
This is an advanced SQL course, which builds on the skills covered in our introductory MySQLcourses. Please review the prerequisite skills or complete the beginner SQLcourse before taking this one!______________________________See why John is one of theTOP-RATEDSQL/MySQLInstructors 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 MySQLand 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 MySQLcourses and tried reading books, but this course is by far the most effective. Excited to see more courses from John!"- Steven M.______________________________COURSEDESCRIPTION:
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 youve seen before, guaranteed. Instead of using random sample data and obscure demos, well be working with a rich, custom-built eCommerce database that weve designed from scratch to help you apply your SQL skills to real projects and learn how to truly THINK like an analyst.
Youll 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 SQLtools and techniques, and work through actual projects that data analysts and business intelligence professionals work on every day.______________________________COURSEOUTLINE:
Prerequisite SQLSkills AssessmentIn this section we'll address the core SQL/MySQL skills that you should be comfortable with before starting the course, including SELECTstatements, 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.
MySQLSetup &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 MySQLCommunity Server &MySQLWorkbench. We'll share download guides for both Mac & PC, and run our first piece of SQLcode to generate the project database that we'll analyze throughout the course.
Traffic Analysis &OptimizationIn this section well 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 MySQLto build and analyze conversion funnels to help optimize the customer purchase experience.***MID-COURSEPROJECT:
Preparing data for the executive board meetingChannel Analysis &OptimizationIn this section well 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 well 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 well take a closer look at user behavior and repeat sessions, and use MySQLtechniques 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, youll 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 LIFETIMEaccess to:
8+hours of high-quality videoDownloadable MySQLebookQuizzes and hands-on projectsMid-course and Final SQLprojects30-day money-back guaranteeIMPORTANTNOTE:
This course does NOTcover building, altering, or maintaining SQL/MySQL databases. Our goal here is to focus on data exploration and database analysis using MySQL and MySQLWorkbench (we'll cover database administration tools in a separate course).
Happy analyzing!-John (Lead SQLInstructor &MySQLExpert, Maven Analytics)______________________________Looking for the full business intelligence stack? Search for "Maven Analytics"to browse our full course library, including Excel, Power BI, MySQL, andTableaucourses!
Who this course is for:
Analysts or BI professionals looking to quickly retrieve or analyze data stored in relational database systemsExcel users looking to shift into a broader business intelligence or database-focused roleSQL users looking to develop advanced skills and master one of the worlds most popular and powerful database programming languagesStudents looking for a hands-on, practical, and highly engaging way to master MySQL for data analysis and business intelligenceAnyone looking to pursue a career in data analysis or business intelligenceNOTE: This course is NOT for database administrators (we won't cover tools to build or maintain databases in this course)

Time: 8h

Instructor Details

Maven Analytics

0.0 Rating
0 Reviews

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