Expires in:
FREE Course
Self-paced course
Self-paced course
MySQL Data Analysis
MySQL Data Analysis
Course Description
MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI 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, your job is to learn everything you can about your new business, including inventory, staff, and customer behavior.
We’ll start with a quick intro to the SQL language, address some key database fundamentals, and use MySQL to select, filter, sort and group data from individual tables. From there we’ll shift into more complex use cases, and blend data across multiple tables with JOIN queries.
If you’re looking for a hands-on, practical guide to learning data analysis with MySQL, this is the course for you.
Course Description
MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI 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, your job is to learn everything you can about your new business, including inventory, staff, and customer behavior.
We’ll start with a quick intro to the SQL language, address some key database fundamentals, and use MySQL to select, filter, sort and group data from individual tables. From there we’ll shift into more complex use cases, and blend data across multiple tables with JOIN queries.
If you’re looking for a hands-on, practical guide to learning data analysis with MySQL, this is the course for you.
Course Content
8 course hours
19 assignments & solutions
4 quizzes
2 skills assessments
8 CPE credits
Who should take this course
Analysts or BI professionals looking to quickly retrieve or analyze data stored in relational database systems
Excel users looking to shift into a broader BI-focused role
Anyone seeking to learn one of the world's most popular database programming languages
Meet your instructors
John Pauler
Partner & CRO
John brings over 15 years of business intelligence experience to the Maven team, having worked with companies ranging from Fortune 500 to early-stage startups. As a MySQL expert, he has played leadership roles across analytics, marketing, SaaS and product teams.
Featured review
"John's deep understanding of SQL and analytics, and ability to explain these tools to a newcomer with zero experience, is really unmatched. I've taken other courses and tried reading books, but this course is by far the easiest way to understand SQL!"
Steven M.
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
MySQL Data Analysis
MySQL Data Analysis
CPE Accreditation
CPE Credits:
8
Field of Study:
Information Technology
Delivery Method:
QAS Self Study
Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.
*Last Updated: May 25, 2023
Course Description
MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI 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, your job is to learn everything you can about your new business, including inventory, staff, and customer behavior.
We’ll start with a quick intro to the SQL language, address some key database fundamentals, and use MySQL to select, filter, sort and group data from individual tables. From there we’ll shift into more complex use cases, and blend data across multiple tables with JOIN queries.
If you’re looking for a hands-on, practical guide to learning data analysis with MySQL, this is the course for you.
Course Description
MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI 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, your job is to learn everything you can about your new business, including inventory, staff, and customer behavior.
We’ll start with a quick intro to the SQL language, address some key database fundamentals, and use MySQL to select, filter, sort and group data from individual tables. From there we’ll shift into more complex use cases, and blend data across multiple tables with JOIN queries.
If you’re looking for a hands-on, practical guide to learning data analysis with MySQL, this is the course for you.
Curriculum
Meet your instructors
John Pauler
Partner & CRO
John brings over 15 years of business intelligence experience to the Maven team, having worked with companies ranging from Fortune 500 to early-stage startups. As a MySQL expert, he has played leadership roles across analytics, marketing, SaaS and product teams.
Student reviews
John's deep understanding of SQL and analytics, and ability to explain these tools to a newcomer with zero experience, is really unmatched. I've taken other courses and tried reading books, but this course is by far the easiest way to understand SQL!
Steven M.
Very well structured and explained MySQL course. I enjoyed every moment of it and I believe that I've learned a lot about SQL queries. Tasks and the exercise data where very interesting and very 'real work' like. On to analyzing huge data now!!! Many many THANKS for an overall fantastic experience!!!
Goulandris Apostolos
This SQL course has been very informative and presents real life test to knowledge acquired. I am excited at the quality of delivery. Thank you Maven!!!
Yaw Ntow Appiah-kubi
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
MySQL Data Analysis
MySQL Data Analysis
CPE Accreditation
CPE Credits:
8
Field of Study:
Information Technology
Delivery Method:
QAS Self Study
Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.
*Last Updated: May 25, 2023
More courses you may like
FOR INDIVIDUALS
Master data & AI skills
Build data & AI skills to launch or accelerate your career (start for free, no credit card required).
FOR COMPANIES & TEAMS
Transform your workforce
Assess your team's data & AI skills and follow personalized learning plans to close the gaps.
FOR INDIVIDUALS
Master data & AI skills
Build data & AI skills to launch or accelerate your career (start for free, no credit card required).
FOR COMPANIES & TEAMS
Transform your workforce
Assess your team's data & AI skills and follow personalized learning plans to close the gaps.
FOR INDIVIDUALS
Master data & AI skills
Build data & AI skills to launch or accelerate your career (start for free, no credit card required).
FOR COMPANIES & TEAMS
Transform your workforce
Assess your team's data & AI skills and follow personalized learning plans to close the gaps.
Empowering everyday people with life-changing data skills.
DISCOVER
Empowering everyday people with life-changing data skills.
DISCOVER
Empowering everyday people with life-changing data skills.
DISCOVER