In this project I hosted a MySQL server locally using MySQLWorkbench and the site www.sqlteaching.com/ to practice SQL.

Starting Database taken from https://www.analystbuilder.com/courses/mysql-for-data-analytics.

All credits to original publishers.

SQL TOPICS COVERED:

--- INNER JOIN, SELF JOIN, RIGHT JOIN, LEFT JOIN

--- NESTED QUERIES, LIKE, CASE, COALESCE, ALIAS

--- SEARCH, WHERE, DISTINCT,LIMIT, ORDER BY, GROUP BY, SUM, COUNT()