21.3. Studio: SQL Part 3 - Joins

21.3.1. Getting Started

For this weeks studio fork this GitHub repository and clone to your computer. If you need a refresher on how to do this see Instruction for Using Github w/Jupyter Notebooks.

In Azure Data Studio, click on the open button and navigate to where you saved the git repository you just cloned and open the notebook.

21.3.2. In Your Notebook

The focus of this studio is to get more familiar with JOIN statements and to practice using them.

  1. Break into small groups and work together to answer the questions.

  2. Each member of the group should be coding along in their own notebooks.

  3. In Part 2 of the studio, each person will pick their own month and create two events or promotions, creating queries to support their choices in their own notebook.

  4. Each member of the group should have different questions and queries.

21.3.3. Present to the Class

When the whole class comes back together, each person will present one of the events they created and the query used to solve it.

21.3.4. Submitting Your Work

When finished make sure to push your changes up to GitHub.

Copy the link to your GitHub repository and paste it into the submission box in Canvas for Studio: SQL Part 3 and click Submit.