Course Overview
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 data analysis and database analytics 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 for analysis and business intelligence.
[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, data modeling 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)
______________________________
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.
FAQ
FAQ area empty
Course curriculum
Chương 1 Getting Started 5 bài · 3 phút
- Course Structure & Outline - MySQL Database for Beginners Học thử 1:36
- READ ME: Important Notes for New Students Học thử
- DOWNLOAD: Course Resources Học thử
- Introducing the Course Project - Play the Role of Business Analyst Học thử 0:33
- Setting Expectations - Focus on Business Analysis, NOT MySQL Administration Học thử 1:19
Chương 2 MySQL Intro & Setup 11 bài · 26 phút
-
Introduction to Installing MySQL and MySQL Workbench for Beginners 0:19
-
Why Learn SQL? 1:09
- History & SQL "Flavors" (MySQL, MS SQL Server, SQL Lite, T SQL, Microsoft SQL) Học thử 2:25
-
MySQL Installation Overview 1:21
- Mac Download - Community Server Học thử 4:53
-
Mac Download - MySQL Workbench 2:50
-
PC Download - Community Server + Workbench 7:41
-
Connecting Workbench to the Server 1:56
-
MySQL Workbench Interface 1:37
-
Creating the Maven Movies Database 1:40
-
QUIZ: MySQL Intro & Setup
Chương 3 Single Table Analysis (PART 1) 47 bài · 1 giờ 51 phút
-
Introduction to Databases and SQL Querying 0:24
-
Getting to Know the Database 3:52
-
The "Big 6" Statements and Clauses of SQL Queries 2:18
-
The SELECT Statement - Your SQL Querying Starts Here 0:47
-
The FROM Clause - Tell the Server Which Table Your SQL Query Will Pull Data From 0:39
-
SELECT * FROM 6:00
-
The USE Statement 3:19
-
Selecting Specific Columns 4:18
-
ASSIGNMENT: SELECT & FROM 1:24
-
SOLUTION: SELECT & FROM 2:38
-
SELECT DISTINCT 2:13
-
ASSIGNMENT: SELECT DISTINCT 0:39
-
SOLUTION: SELECT DISTINCT 2:00
-
The WHERE Clause 1:30
-
Common WHERE Operators 4:59
-
ASSIGNMENT: The WHERE Clause 0:35
-
SOLUTION: The WHERE Clause 2:23
-
Combining WHERE & AND 4:22
-
ASSIGNMENT: WHERE & AND 0:39
-
SOLUTION: WHERE & AND 1:37
-
Combining WHERE & OR 3:38
-
ASSIGNMENT: WHERE & OR 0:42
-
SOLUTION: WHERE & OR 3:21
-
Combining WHERE & IN 4:35
-
The LIKE Operator 2:37
-
LIKE Wildcard Examples 5:06
-
ASSIGNMENT: The LIKE Operator 0:30
-
SOLUTION: The LIKE Operator 2:28
-
The GROUP BY Clause 1:43
-
GROUP BY Example 3:18
-
PRO TIP: Using Comments & Aliases 5:32
-
ASSIGNMENT: GROUP BY 0:37
-
SOLUTION: GROUP BY 2:01
-
Multiple Dimension GROUP BY Clauses 3:14
-
Grouping with Aggregate Functions 2:08
-
ASSIGNMENT: Aggregate Functions 0:55
-
SOLUTION: Aggregate Functions 3:23
-
The HAVING Clause 1:44
-
HAVING Example 2:54
-
ASSIGNMENT: The HAVING Clause 0:54
-
SOLUTION: The HAVING Clause 3:11
-
The ORDER BY Clause 1:31
-
ORDER BY Example 4:16
-
ASSIGNMENT: The ORDER BY Clause 0:30
-
SOLUTION: The ORDER BY Clause 1:47
-
RECAP: The "Big 6" 2:08
-
QUIZ: Single Table Analysis (PART 1)
Chương 4 Single Table Analysis (PART 2) 10 bài · 32 phút
-
The CASE Statement 2:43
-
CASE Example 5:43
-
Common CASE Operators 4:18
-
ASSIGNMENT: The CASE Statement 0:39
-
SOLUTION: The CASE Statement 3:47
-
PRO TIP: "Pivoting" with COUNT & CASE 2:54
-
COUNT & CASE Demo 7:29
-
ASSIGNMENT: COUNT & CASE 0:48
-
SOLUTION: COUNT & CASE 3:15
-
QUIZ: Single Table Analysis (PART 2)
Chương 5 MID-COURSE PROJECT 2 bài · 8 phút
-
Mid-Course Project Intro 1:42
-
SOLUTION: Mid-Course Project 6:05
Chương 6 Analyzing Multiple Tables with Joins 28 bài · 1 giờ 10 phút
-
Introduction to SQL JOINs and Querying Multiple Tables 0:30
-
Normalization & Cardinality 3:47
-
Relationship Diagrams 1:10
-
Multi-Table Querying 1:04
-
Reviewing the Maven Movies Database 1:44
-
Common JOIN Types 2:25
-
INNER JOIN 1:31
-
INNER JOIN Example 5:49
-
ASSIGNMENT: INNER JOIN 0:42
-
SOLUTION: INNER JOIN 4:13
-
LEFT JOIN 1:39
-
LEFT JOIN Example 4:43
-
ASSIGNMENT: LEFT JOIN 0:42
-
SOLUTION: LEFT JOIN 3:57
-
RIGHT JOIN 1:41
-
LEFT vs. INNER vs. RIGHT JOIN 3:18
-
FULL OUTER JOIN 1:27
-
PRO TIP: "Bridging" Unrelated Tables 6:51
-
ASSIGNMENT: "Bridging" Tables 0:57
-
SOLUTION: "Bridging" Tables 4:25
-
Multi-Condition Joins 2:40
-
ASSIGNMENT: Multi-Condition Joins 0:44
-
SOLUTION: Multi-Condition Joins 4:42
-
The UNION Operator 2:15
-
UNION Example 3:51
-
ASSIGNMENT: The UNION Operator 0:32
-
SOLUTION: The UNION Operator 2:41
-
QUIZ: Multi-Table Analysis
Chương 7 FINAL PROJECT 2 bài · 17 phút
-
Final Project Intro 2:04
-
SOLUTION: Final Project 14:54
Chương 8 Wrapping Up 2 bài
-
Resources & Next Steps - After this SQL for Beginners Course
-
BONUS LESSON
Requirment
-
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
Outcomes
-
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
0 Student
4 Courses
0 review