Course Highlights
  • 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
Curriculum

5 Topics
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
Setting Expectations - Focus on Business Analysis NOT MySQL Administration

11 Topics
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

47 Topics
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)

10 Topics
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)

2 Topics
Mid-Course Project Intro
SOLUTION: Mid-Course Project

28 Topics
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
SOLUTION: "Bridging" Tables
Multi-Condition Joins
ASSIGNMENT: Multi-Condition Joins
SOLUTION: Multi-Condition Joins
The UNION Operator
UNION Example
ASSIGNMENT: The UNION Operator
SOLUTION: The UNION Operator
QUIZ: Multi-Table Analysis

2 Topics
Final Project Intro
SOLUTION: Final Project

2 Topics
Resources & Next Steps - After this SQL for Beginners Course
BONUS LESSON

  Write a Review

SQL for Data Analysis: Beginner MySQL Business Intelligence

Go to Paid Course