Note
More Notebooks will be uploaed in the comming week
This repository stores the exercise notebooks of the Coursera course Managing Big Data with MySQL.
Exercise Jupyter Notebooks can be viewed using nbviewer
- Exercise 1: Looking at Your Data
- Exercise 2: Selecting Data Subsets using WHERE
- Exercise 3: Formatting Selected Data
- Exercise 4: Summarizing Your Data
- Exercise 5: Summaries of Groups of Data
- Exercise 6: Common Pitfalls of Gourped Data
The course teaches the basics of MySQL queries in business analytics. The key concepts of querying a single table is summarized by the following diagrams
Note that the actual excuation order of SQL queries is different with the order we write them. The following diagram shows the the difference.