Learn practical skills, build real-world projects, and advance your career

Master SQL Like A Pro

Data Source: Chinook Open Source Database

alt

In data science, Structured query language (SQL) is bread and butter. Rarely, data scientists don't know SQL. In this project, you'd learn how to retrieve data from an open database, then do some fundamental analysis with some basic SQL queries and aggregate functions to gather valuable insights about our data.

On the other hand, the purpose of creating this project is to help you grab the senses of SQL and show you my credits and understandings of SQL.

“When one teaches, two learn.”

-Robert Heinlein

How to Run the Code

Option 1: Running using free online resources (1-click, recommended): The easiest way to start executing the code is to click the Run button at the top of this page and select Run on Binder. This will set up a cloud-based Jupyter notebook server and allow you to modify/execute the code.

Option 2: Running on your computer locally: To run the code on your computer locally, you'll need to set up Python, download the notebook and install the required libraries. Click the Run button at the top of this page, select the Run Locally option, and follow the instructions.

In this project, we will use the platform called 'Jovian', so we download library first, and it will enable us to save our work as regular intervals using the function - jovian.commit()

!pip install jovian --upgrade --quiet
import jovian
# Execute this to save new versions of the notebook
jovian.commit(project="master-sql-like-a-pro")