SQL for Data Analysis
Beginner MySQL Business Intelligence
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 (
[ 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
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)
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.
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.
Get a Reminder
Rating | 4.6★ based on 125 ratings |
---|---|
Length | 4.5 total hours |
Starts | On Demand (Start anytime) |
Cost | $21 |
From | Udemy |
Instructors | Maven Analytics, John Pauler, John Pauler - SQL | MySQL | Data Analysis |
Download Videos | Only via the Udemy mobile app |
Language | English |
Subjects | Data Science Programming |
Tags | Databases Development Database Design & Development |
Get a Reminder
Similar Courses
What people are saying
easy to follow
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.
This was a fantastic course with great easy to follow intuitive examples.
Great instructor, information was well explained and easy to follow with example.
I look forward to completing the rest of this course I find this course very easy to follow, very detailed explanations for the total beginners Well-structured course with detail db and examples.
its good Well structured and easy to follow Nothing is perfect Satisfied Excellent course.
Read more
analytics & business intelligence
I'm definitely jumping onto Advanced SQL for Analytics & Business Intelligence.
However, after starting the John’s “Advanced SQL & MySQL for Analytics & Business Intelligence”, I decided to purchase this course due to two primary reasons: 1) I really enjoy John’s teaching style and 2) I like having MySQL Workbench hosted on my machine locally.
Read more
so far it
So far it has ben a great match It has been easy to understand and follow for a complete beginner like myself.
Excellent, want more examples I have learned a lot of things from this course : ) So far it's been informative and easy to follow.
Read more
understanding of sql
I initially took the course just to get some understanding of SQL but have learned enough SQL to apply some pretty good fundamental queries at work on some of our databases.
If you're a student needing understanding of SQL and how to use it, I would recommend this course.
Read more
good course for
Good course for beginners... Where slightly advanced features are introduced and explained and worked gradually.. Will definitely recommend this.
Challenging but worth it Good course for a beginner I already have extensive training in MySQL and use it myself on a daily basis.
Read more
recommend this course
I would definitely recommend this course to anyone looking for a good intro and I plan to check out the advanced course once I've put in a little more practice at work.
I'd recommend this course to someone already acquainted with SQL who wants to quickly refresh basic SQL concepts before diving deeper into the subject.
maven analytics
Thank you team Maven Analytics for this amazing course.
Thank you John and Maven Analytics for the wonderful course.
I have also completed several of Maven Analytics' courses before.
Maven Analytics has not disappointed me yet on the quality and content of their courses and this one delivers just the same.
Thank you Maven Analytics & John Pauler nice I am a little over halfway through the course after having completed a few other SQL courses on Udemy and this is far superior.
Read more
very well
The instructor explains very well and I can catch up everything so far.
In total, very well worth the time and effort!
Very well aligned to the topics.
Very well thought out course and made MySQL and SQL very easy to understand.
Read more
advanced sql
Anyway, in the advanced SQL course, which is very interesting by the way, the semicolon is just simply there between queries with a one-second comment about it.
If there's an advanced SQL course coming from this instructor, COUNT ME IN.
very simple
Amazing content and each concept is explained in a very simple and sequential way.
The course content is presented in a very simple and to the point manner without missing out on any of the intricacies.Best Udemy course I have done thus far.
Read more
use it
I use it as reference for my job everyday.
experience with
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.
Read more
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Supervisor Sales, Business Analysis and Database marketing $53k
Analysis Coordinator $65k
discharge analysis $68k
Operation Analysis $73k
Security Analysis $84k
Process Analysis $84k
Structural analysis $92k
IT Analysis $95k
Analysis $95k
Analysis Engineer 1 $103k
Business Analysis/Business Systems Analysis $120k
Database Administrator/Database Developer $127k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | 4.6★ based on 125 ratings |
---|---|
Length | 4.5 total hours |
Starts | On Demand (Start anytime) |
Cost | $21 |
From | Udemy |
Instructors | Maven Analytics, John Pauler, John Pauler - SQL | MySQL | Data Analysis |
Download Videos | Only via the Udemy mobile app |
Language | English |
Subjects | Data Science Programming |
Tags | Databases Development Database Design & Development |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course