MySQL for Data Analysis - SQL Database for Beginners (Udemy.com)

Learn SQL for Business Intelligence w/ MySQL Workbench. Intro to Relational Databases (apply to PostgreSQL & Oracle SQL)

Created by: Maven Analytics

Produced in 2020

icon
What you will learn

  • Write SQL queries to explore and analyze databases with MySQL Workbench
  • Learn how to use SQL to extract, sort, filter, and group data quickly and efficiently
  • Analyze data across multiple tables with powerful MySQL JOIN statements
  • Solve practical hands-on assignments and real-world business use cases
  • Master unique tips, tools and case studies that you won't find anywhere else
  • Get LIFETIME access to resource files, quizzes, assignments, and expert support

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100

icon
Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a postgresql course? Or looking for more detail on Maven Analytics's MySQL for Data Analysis - SQL Database for Beginners? Feel free to chat below
Join CourseDuck's Online Learning Discord Community

icon
Course Description

See why this is one of the TOP RATED SQL/MySQL Courses on Udemy:
"Clear presentation of information and with enough repetition of important SQL concepts to help make the information memorable. Loved the frequent practice examples and code debugging exercises!"
- Maggi M.
"I totally loved this course! Everything was very 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.
"John's deep understanding of SQL and database analysis and ability to explain those tools to a newcomer with 0 experience, is really unmatched. I've taken other SQL and MySQL courses and tried reading books, but this course is by far the easiest way to understand SQL. Excited to see more courses from John!"
- Steven M.
______________________________
SQL and MySQL are incredibly powerful tools for managing and analyzing relational databases, and a skill that every Analyst and Business Intelligence professional should have in the arsenal.
In this course, you'll play the role of a business owner who just acquired Maven Movies, a brick and mortar DVD rental shop. Using only a MySQL database and MySQL Workbench, your mission is to learn everything that you can about your new business; including your inventory, staff, and customer behavior.
But don't worry, you're not alone! We'll be right here to guide you from start to finish, sharing crystal clear explanations, MySQL pro tips and best practices, and course quizzes, projects and homework assignments to test your SQL and database analysis skills along the way.
______________________________
COURSE OUTLINE:
  • SQL Intro & MySQL Setup
    We'll start with a quick intro to the SQL landscape and it's common "flavors" (MySQL, SQLite, PostgreSQL, etc), then download and install the tools that we'll need to access and explore our MySQL database (MySQL Community Server + MySQL Workbench)

  • SQL Database Fundamentals (Part 1)
    Once we have our tools installed, we'll quickly review some database fundamentals and begin to explore the 16 tables contained within our MySQL database, containing information about Maven Movies customers, inventory, and transactions.

  • Analyzing Data from Single Tables with MySQL
    In this section we'll start exploring and extracting information from individual tables in our MySQL database, and practice writing SQL queries to select, filter, sort and group our data.

    [MID-COURSE MYSQL PROJECT]

  • SQL Database Fundamentals (Part 2)
    The second half of the course is all about anayzing data from multiple tables in MySQL, so we'll begin with a quick review of relational databases and database analysis: primary vs. foreign keys, relationship cardinality, normalization, etc.

  • Analyzing Multiple Tables via MySQL JOINS
    In this section, we'll review the most common types of SQL joins (INNER, LEFT, RIGHT, OUTER, etc), and explore some more complex MySQL queries to analyze data that bridges multiple tables in our database.

    [FINAL MYSQL PROJECT]


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).
______________________________

Enroll today and get LIFETIME access to:
  • 5+ hours of high-quality video
  • Downloadable MySQL ebook and cheat sheets
  • Quizzes and homework assignments
  • Mid-course and Final SQL projects
  • 30-day money-back guarantee
If you're looking for a hands-on, practical guide to mastering data analysis with SQL/MySQL, this is the course for you!

Happy analyzing!
-John (Lead SQL Instructor & MySQL Expert, Maven Analytics)
______________________________

P.S. Looking to master the full Microsoft Excel, Power BI + SQL stack? Search for "Maven Analytics" and complete the courses below to become a business intelligence ROCKSTAR:
  1. Excel Pro Tips for Power Users
  2. Advanced Excel Formulas & Functions
  3. Data Visualization with Excel Charts & Graphs
  4. Data Analysis with Excel PivotTables
  5. Excel Power Query, Power Pivot & DAX
  6. Up & Running with Power BI Desktop
  7. Publishing to Power BI Service
  8. SQL Database Analysis for Beginners
  9. Advanced MySQL for Analytics & Business Intelligence
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
  • Anyone seeking to learn one of the world's most popular and powerful database programming languages (SQL)
  • Students looking for a hands-on and highly engaging introduction to MySQL for data analysis
  • 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)

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

icon
Instructor Details

Maven Analytics

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 190 countries develop the most sought-after analytics skills, through on-demand courses, personalized skills assessments, curated learning paths, and enterprise training.
Learning new skills shouldn't 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.Over a decade of Analytics experience for companies ranging from Fortune 500 to early stage startups. I work with data from websites, customers, marketing channels, and software products. I have been a pure play Analyst, and I have also led large Marketing P&Ls and served as a Product Owner. Throughout it all, I've made data mastery a pillar of my career, and am excited to share my experience on Udemy.

icon
Reviews

4.7

127 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

The course was spectacular! I have learned a lot from knowing nothing at all about MySQL. The material is reached, explanations are clear and always backed up with examples and assessments. There are two main assignments that require attention and effort to be completed. It has really been an amazing experience and now I am ready to jump in into the Advanced one! Thanks a lot, John!

My goal, when I signed up for this course, was to gain more experience with 'MySQL Workbench' which it has fulfilled this expectation and much more. The course uses a complete data schema for a fictitious company, which allowed me to build upon prior experience with the tables and fields saving much time vs. creating new tables specific to the topic covered. The section on 'Bridging' tables was beneficial and would have been difficult to test without having this complete schema available.

BAD - the course could have put some light on how to import databases in various formats.In real life scenario I would not be getting a readymade sql format based file.GOOD - probably the only SQL course in UDEMY which lays emphasis on WHEN TO USE AND WHY.

This is a good match and brought me back up to speed with SQL, the last video seemed to go out of focus a little bit, number 68, otherwise would have had 5 stars

I needed a good refresher on my SQL since I havent coded with SQL since 2005. This was an easy to follow course that took things at a good pace and broke down the pieces of SQL into good-sized chunks. Was good to work with a single database throughout. In the advanced course (Im hoping is coming) would be nice to work with a couple databases.

The best course to ahead for SQL for everyone exclusively who are into into analytics. Highly recommended and organized at the bestReally great work great John..

I was able to follow through and thoroughly understand the course content clearly and surprisingly found the course projects quite easy yet I have no prior experience with SQL!! I'm definitely jumping onto Advanced SQL for Analytics & Business Intelligence.

I had a college course on SQL a few years ago, but I'm finding this course to be a great refresher. The "Big 6" elements of SQL statements are explained very thoroughly.The second half of the course was much more challenging (and rewarding). In total, very well worth the time and effort! I've already begun recommending this course to professional associates.

Very clear and engaging course. Thank you

Thanks John for your wonderful approach and the course. In this course, I expected to have some more topics like triggers, stored procedure and more. In that regard, it becomes lower than my expectation. It may be because, I had prior exposure, I felt that the course is very entry level. I hope you will supplement this course with more advanced topics and more real data exercises. Please share me the database for exercises.I must also appreciate Udemy for this awesome platform.

Very well explained. I used to fear from SQL but after doing the course am confident that I can understand SQL basic. Thank you

It was a great experience for me analyzing data based on a business. I do enjoy how the training was set up where we had assignments ,examples and solutions.