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.
Break into small groups and work together to answer the questions.
Each member of the group should be coding along in their own notebooks.
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.
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.