MySQL for Data Analysis - SQL Database for Beginners
4.7 (2,190 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
21,032 students enrolled

MySQL for Data Analysis - SQL Database for Beginners

Learn SQL for Business Intelligence w/ MySQL Workbench. Intro to Relational Databases (apply to PostgreSQL & Oracle SQL)
Bestseller
4.7 (2,190 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
21,032 students enrolled
Last updated 6/2020
English
English [Auto]
Current price: $121.99 Original price: $174.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6 hours on-demand video
  • 4 articles
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Course content
Expand all 113 lectures 05:55:18
+ Getting Started
5 lectures 05:35
READ ME: Important Notes for New Students
01:54
DOWNLOAD: Course Resources
00:12

This is NOT your run of the mill PHP MySQL course, where you just get surface level exposure to building databases and writing SQL queries. Instead of trying to cover both building databses using PHP + MySQL and SQL querying, this course stays away from building and maintenance, so that we can go really deep on analyzing data that is already in a MySQL database. We start with the basics, so even if you've never written SQL code before, this course is a good fit for aspiring Database Analysts.

Preview 01:19
+ MySQL Intro & Setup
10 lectures 24:36
Introduction to Installing MySQL and MySQL Workbench for Beginners
00:19
Why Learn SQL From Scratch? The Ultimate MySQL Bootcamp is Worth It!
01:09
MySQL Installation Overview
01:21
MAC Download: Community Server
04:20
MAC Download: MySQL Workbench
02:15
PC Download: Community Server + Workbench
07:37
Connecting Workbench to the Server
01:56
MySQL Workbench Interface
01:37
Creating the Maven Movies Database
01:37
QUIZ: MySQL Intro & Setup
5 questions
+ Single Table Analysis (PART 1)
46 lectures 01:51:19
Introduction to Databases and SQL Querying
00:24
Getting to Know the Database
03:52
The "Big 6" Statements and Clauses of SQL Queries
02:18
The SELECT Statement - Your SQL Querying Starts Here
00:47
The FROM Clause - Tell the Server Which Table Your SQL Query Will Pull Data From
00:39
SELECT * FROM
06:00
The USE Statement
03:19
Selecting Specific Columns
04:18
ASSIGNMENT: SELECT & FROM
01:24
SOLUTION: SELECT & FROM
02:38
SELECT DISTINCT
02:13
ASSIGNMENT: SELECT DISTINCT
00:39
SOLUTION: SELECT DISTINCT
02:00
The WHERE Clause
01:30
Common WHERE Operators
04:59
SOLUTION: The WHERE Clause
02:23
Combining WHERE & AND
04:22
ASSIGNMENT: WHERE & AND
00:39
SOLUTION: WHERE & AND
01:37
Combining WHERE & OR
03:38
ASSIGNMENT: WHERE & OR
00:42
SOLUTION: WHERE & OR
03:21
Combining WHERE & IN
04:35
LIKE Wildcard Examples
05:06
ASSIGNMENT: The LIKE Operator
00:30
SOLUTION: The LIKE Operator
02:28
The GROUP BY Clause
01:43
GROUP BY Example
03:18
PRO TIP: Using Comments & Aliases
05:32
ASSIGNMENT: GROUP BY
00:37
SOLUTION: GROUP BY
02:01
Multiple Dimension GROUP BY Clauses
03:14
Grouping with Aggregate Functions
02:08
ASSIGNMENT: Aggregate Functions
00:55
SOLUTION: Aggregate Functions
03:23
The HAVING Clause
01:44
HAVING Example
02:54
ASSIGNMENT: The HAVING Clause
00:54
SOLUTION: The HAVING Clause
03:11
The ORDER BY Clause
01:31
ORDER BY Example
04:16
ASSIGNMENT: The ORDER BY Clause
00:30
SOLUTION: The ORDER BY Clause
01:47
QUIZ: Single Table Analysis (PART 1)
7 questions
+ Single Table Analysis (PART 2)
9 lectures 31:46
The CASE Statement
02:43
CASE Example
05:43
Common CASE Operators
04:18
ASSIGNMENT: The CASE Statement
00:39
SOLUTION: The CASE Statement
03:47
PRO TIP: "Pivoting" with COUNT & CASE
02:54
COUNT & CASE Demo
07:35
ASSIGNMENT: COUNT & CASE
00:52
SOLUTION: COUNT & CASE
03:15
QUIZ: Single Table Analysis (PART 2)
5 questions
+ MID-COURSE PROJECT
2 lectures 07:47
Mid-Course Project Intro
01:42
SOLUTION: Mid-Course Project
06:05
+ Analyzing Multiple Tables with Joins
27 lectures 01:10:19
Normalization & Cardinality
03:47
Relationship Diagrams
01:10
Multi-Table Querying
01:09
Reviewing the Maven Movies Database
01:44
Common JOIN Types
02:30
INNER JOIN
01:35
INNER JOIN Example
05:49
ASSIGNMENT: INNER JOIN
00:42
SOLUTION: INNER JOIN
04:13
LEFT JOIN
01:44
LEFT JOIN Example
04:43
ASSIGNMENT: LEFT JOIN
00:42
SOLUTION: LEFT JOIN
03:57
RIGHT JOIN
01:41
FULL OUTER JOIN
01:27
PRO TIP: "Bridging" Unrelated Tables
06:51
ASSIGNMENT: "Bridging" Tables
00:57
SOLUTION: "Bridging" Tables
04:25
Multi-Condition Joins
02:40
ASSIGNMENT: Multi-Condition Joins
00:44
SOLUTION: Multi-Condition Joins
04:42
The UNION Operator
02:15
UNION Example
03:51
ASSIGNMENT: The UNION Operator
00:32
SOLUTION: The UNION Operator
02:41
QUIZ: Multi-Table Analysis
7 questions
+ FINAL PROJECT
2 lectures 16:58
Final Project Intro
02:04
SOLUTION: Final Project
14:54
+ Wrapping Up
2 lectures 01:25
Resources & Next Steps - After this SQL for Beginners Course
00:38
More from Maven Analytics
00:47
+ SNEAK PEEK: Advanced SQL for Analytics & Business Intelligence
8 lectures 01:00:16
SNEAK PEEK: What's Next? Advanced Databases and SQL Querying!
02:07
SNEAK PEEK: Analyzing Top Traffic Sources
19:27
SNEAK PEEK: Assignment - Finding Top Traffic Sources
02:37
SNEAK PEEK: Solution - Finding Top Traffic Sources
04:23
SNEAK PEEK: Analyzing Bounce Rates & Landing Page Tests
14:41
SNEAK PEEK: Assignment - Analyzing Landing Page Tests
02:30
SNEAK PEEK: Solution - Analyzing Landing Page Tests
12:17
SNEAK PEEK: Final Project - Advanced SQL for Analytics & Business Intelligence
02:14
+ SNEAK PEEK: MySQL Database Administration - SQL Database for Beginners
2 lectures 25:16
SNEAK PEEK: Creating a Table Using a SQL Query
06:03
SNEAK PEEK: Creating Enhanced Entitity Relationship Models
19:13
Requirements
  • MySQL Workbench and Community Server for Mac or Windows/PC (we’ll walk you through the free install process)
  • Basic understanding of database fundamentals encouraged, but not required
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

  • 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)

______________________________


Most students in this course enroll in our full MySQL LEARNING PATH, designed to help you build a deep, expert-level MySQL skill set:

  1. MySQL Database Administration

  2. MySQL Data Analysis (Beginner) (You are here)

  3. MySQL Data Analysis (Advanced)

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!

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)