Studio

Getting Started

In Azure Data Studio, click on the File » Open File… and navigate to SQL-Part-3-Studio.ipynb you downloaded from canvas.

In Your Notebook

Connect to BooksDB before starting work on the studio.

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.

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.

Submitting Your Work

When finished, upload your completed document to canvas!

Tip

Windows Users: when you are saving your edited file from Azure Data Studio, you may need to select the “Notebook” file type when saving the file to your machine.