SQL for Data Analysis: Beginner MySQL Business Intelligence from Udemy

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.

What's inside

Learning objectives

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

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

Syllabus

Getting Started

Course Structure & Outline - MySQL Database for Beginners

READ ME: Important Notes for New Students

DOWNLOAD: Course Resources

Introducing the Course Project - Play the Role of Business Analyst

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.

MySQL Intro & Setup

Introduction to Installing MySQL and MySQL Workbench for Beginners

Why Learn SQL From Scratch? The Ultimate MySQL Bootcamp is Worth It!

History & SQL "Flavors" (MySQL, MS SQL Server, SQL Lite, T SQL, Microsoft SQL)

MySQL Installation Overview

Mac Download - Community Server

Mac Download - MySQL Workbench

PC Download - Community Server + Workbench

Connecting Workbench to the Server

MySQL Workbench Interface

Creating the Maven Movies Database

QUIZ: MySQL Intro & Setup

Single Table Analysis (PART 1)

Introduction to Databases and SQL Querying

Getting to Know the Database

The "Big 6" Statements and Clauses of SQL Queries

The SELECT Statement - Your SQL Querying Starts Here

The FROM Clause - Tell the Server Which Table Your SQL Query Will Pull Data From

SELECT * FROM

The USE Statement

Selecting Specific Columns

ASSIGNMENT: SELECT & FROM

SOLUTION: SELECT & FROM

SELECT DISTINCT

ASSIGNMENT: SELECT DISTINCT

SOLUTION: SELECT DISTINCT

The WHERE Clause

Common WHERE Operators

ASSIGNMENT: The WHERE Clause

SOLUTION: The WHERE Clause

Combining WHERE & AND

ASSIGNMENT: WHERE & AND

SOLUTION: WHERE & AND

Combining WHERE & OR

ASSIGNMENT: WHERE & OR

SOLUTION: WHERE & OR

Combining WHERE & IN

The LIKE Operator

LIKE Wildcard Examples

ASSIGNMENT: The LIKE Operator

SOLUTION: The LIKE Operator

The GROUP BY Clause

GROUP BY Example

PRO TIP: Using Comments & Aliases

ASSIGNMENT: GROUP BY

SOLUTION: GROUP BY

Multiple Dimension GROUP BY Clauses

Grouping with Aggregate Functions

ASSIGNMENT: Aggregate Functions

SOLUTION: Aggregate Functions

The HAVING Clause

HAVING Example

ASSIGNMENT: The HAVING Clause

SOLUTION: The HAVING Clause

The ORDER BY Clause

ORDER BY Example

ASSIGNMENT: The ORDER BY Clause

SOLUTION: The ORDER BY Clause

RECAP: The "Big 6"

QUIZ: Single Table Analysis (PART 1)

Single Table Analysis (PART 2)

The CASE Statement

CASE Example

Common CASE Operators

ASSIGNMENT: The CASE Statement

SOLUTION: The CASE Statement

PRO TIP: "Pivoting" with COUNT & CASE

COUNT & CASE Demo

ASSIGNMENT: COUNT & CASE

SOLUTION: COUNT & CASE

QUIZ: Single Table Analysis (PART 2)

MID-COURSE PROJECT

Mid-Course Project Intro

SOLUTION: Mid-Course Project

Analyzing Multiple Tables with Joins

Introduction to SQL JOINs and Querying Multiple Tables

Normalization & Cardinality

Relationship Diagrams

Multi-Table Querying

Reviewing the Maven Movies Database

Common JOIN Types

INNER JOIN

INNER JOIN Example

ASSIGNMENT: INNER JOIN

SOLUTION: INNER JOIN

LEFT JOIN

LEFT JOIN Example

ASSIGNMENT: LEFT JOIN

SOLUTION: LEFT JOIN

RIGHT JOIN

LEFT vs. INNER vs. RIGHT JOIN

FULL OUTER JOIN

PRO TIP: "Bridging" Unrelated Tables

ASSIGNMENT: "Bridging" Tables

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Focuses on the specific use case of a MySQL database for a DVD rental shop

Appropriate for students with limited SQL and database analysis experience

Teaches the 'Big 6' statements and clauses for SQL querying

Develops skills in selecting, sorting, filtering, and grouping data in a structured manner

Covers a range of topics, including data retrieval, manipulation, and analysis

Instructors are SQL experts and MySQL practitioners

Reviews summary

Great introduction to mysql

Learners say this course is perfect for beginners looking to learn the fundamentals of SQL and MySQL. Students praise the great introduction to the topic and recommend it to anyone getting started with SQL.

Learners find the course helpful for applying SQL skills at work.

"I have learned enough SQL to apply some pretty good fundamental queries at work on some of our databases."

Students are overall happy with the course.

"This was a great course as an intro to MySQL."

The course is well suited for students new to SQL.

"I initially took the course just to get some understanding of SQL"

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in SQL for Data Analysis: Beginner MySQL Business Intelligence with these activities:

Refresh SQL basics

Show steps

Solidify your understanding of basic SQL concepts to enhance your comprehension of the course material.

Browse courses on SQL Syntax

Show steps

Review SQL SELECT, INSERT, UPDATE, and DELETE statements.
Practice writing SQL queries to retrieve, modify, and delete data.

Review SQL Fundamentals Concepts

Show steps

Reviewing SQL Fundamentals will help you to better understand and apply the concepts being covered in this course.

Show steps

Review the SQL SELECT statement
Review the SQL FROM clause
Review the SQL WHERE clause
Review the SQL GROUP BY clause
Review the SQL ORDER BY clause

Explore MySQL Workbench tutorials

Show steps

Enhance your proficiency in using MySQL Workbench to navigate and analyze the provided Maven Movies database.

Browse courses on MySQL Workbench

Show steps

Follow tutorials on installing and setting up MySQL Workbench.
Explore the MySQL Workbench interface and its features.
Complete guided exercises on creating and managing databases.

Nine other activities

Expand to see all activities and additional details

Show all 12 activities

Solve SQL practice problems

Show steps

Strengthen your problem-solving skills by practicing SQL queries in a structured environment.

Browse courses on SQL Queries

Show steps

Access online SQL practice platforms or resources.
Attempt solving SQL queries of varying难度 levels.
Review your solutions and identify areas for improvement.

Join a Study Group

Show steps

Joining a study group will allow you to learn from and collaborate with other students who are also taking this course.

Show steps

Find a study group that meets your schedule and learning style
Attend the study group meetings regularly
Participate in discussions
Help other students with their questions

SQL Writing Exercises

Show steps

Practice writing SQL queries to improve understanding of syntax and data manipulation.

Browse courses on SQL

Show steps

Review the course material on SQL syntax and data types.
Find a dataset or create a small sample database.
Write SQL queries to retrieve, filter, and sort data.
Test the queries and analyze the results.

Build a Sample Database

Show steps

Building a sample database will allow you to apply the skills and knowledge you are learning in this course in a practical setting.

Browse courses on Database Creation

Show steps

Design the database schema
Create the database tables
Insert data into the database
Query the database
Write a report on your findings

SQL Study Group

Show steps

Collaborate with peers to discuss SQL concepts, practice writing queries, and troubleshoot problems.

Browse courses on SQL

Show steps

Find a group of students with similar interests and skill levels.
Establish a regular meeting time and location.
Take turns leading discussions and presenting SQL challenges.
Provide feedback and support to each other.

Join a SQL study group

Show steps

Collaborate with peers to enhance your understanding of SQL concepts and problem-solving approaches.

Show steps

Join an online or in-person SQL study group.
Participate in discussions, ask questions, and share knowledge.
Collaborate on SQL projects and assignments.

Advanced SQL Techniques Tutorial

Show steps

Follow online tutorials or take a short course to learn advanced SQL techniques, such as window functions and subqueries.

Browse courses on SQL

Show steps

Identify a specific SQL technique that you want to learn.
Find a reputable online tutorial or course that covers the topic.
Follow the instructions and complete the exercises.
Apply the new technique to your own data analysis projects.

Mentor junior SQL learners

Show steps

Reinforce your own understanding of SQL concepts by guiding and supporting junior learners.

Browse courses on Peer Support

Show steps

Volunteer or sign up to mentor junior SQL learners.
Provide guidance, answer questions, and review code.
Share your knowledge and experience to help others succeed.

Read 'SQL Queries for Mere Mortals'

Show steps

Gain a comprehensive understanding of SQL queries and their practical applications.

View SQL Queries for Mere Mortals: A Hands-On Guide... on Amazon

Show steps

Obtain a copy of 'SQL Queries for Mere Mortals'.
Read through the book, focusing on the chapters relevant to the course content.

Career center

Learners who complete SQL for Data Analysis: Beginner MySQL Business Intelligence will develop knowledge and skills that may be useful to these careers:

Data Analyst

A Data Analyst extracts, cleans, and visualizes data from structured or unstructured sources. Courses such as this one can be a helpful aid in improving query-writing skills in MySQL, which is a powerful tool that makes data manipulation considerably easier. Data Analysts also routinely use SQL to access and analyze data, and this course provides a solid introduction to SQL at a level that can be helpful for data analysts.

See salaries and explore the career path for Data Analyst

Business Analyst

Business Analysts use data to gain insights into business operations and make recommendations for improvement. This course may be helpful for building a foundation in data analysis with SQL for those interested in a career as a Business Analyst.

See salaries and explore the career path for Business Analyst

Database Administrator

Database Administrators will often need to create and manage databases, and this course covers topics such as creating and managing databases as well as how to get data into and out of the databases, making it helpful for those interested in getting into or advancing in this career.

See salaries and explore the career path for Database Administrator

Software Engineer

Software Engineers work on designing, developing and maintaining software applications, and many will need to be able to use SQL to interact with databases as part of their day to day work. Courses such as this one, which introduce SQL and how to perform data analysis in MySQL can be a good starting point for building these skills.

See salaries and explore the career path for Software Engineer

Data Scientist

Data Scientists use data to build models that can be used to make predictions or recommendations. This course may be helpful to Data Scientists for building a foundation in SQL data analysis in MySQL, which can be used to manipulate data prior to building data models.

See salaries and explore the career path for Data Scientist

Product Manager

Product Managers often need to rely on data to make decisions about their products and how to build them. Courses such as this one can help build a foundation in SQL, which can be a valuable skill for a Product Manager when accessing and analyzing data.

See salaries and explore the career path for Product Manager

Marketing Analyst

Marketing Analysts use data to understand marketing campaigns and make decisions about how to improve them. Courses such as this one can be a good starting point for building the SQL skills necessary for accessing and manipulating data used by marketing analysts.

See salaries and explore the career path for Marketing Analyst

Financial Analyst

Financial Analysts use data to make recommendations about investments and financial decisions. Courses such as this one can help build a foundation in SQL, which is often used by financial analysts to access and analyze financial data.

See salaries and explore the career path for Financial Analyst

Operations Research Analyst

Operations Research Analysts use data to design and evaluate systems and processes. Courses such as this one can be a helpful starting point for building the skills necessary to analyze data with SQL, which is a useful skill for Operations Research Analysts.

See salaries and explore the career path for Operations Research Analyst