Skip to content

Latest commit

 

History

History
32 lines (27 loc) · 1.72 KB

02-Advanced.md

File metadata and controls

32 lines (27 loc) · 1.72 KB

Advanced Workshop

Prerequisites

You can complete the 4 assessment items for the Intermediate Module.

A Note

The Advanced Workshop is 'Choose Your Own Adventure.' You can choose to work through one of the options, or try all three. Have fun. 😀

Option 1

Build a 'Fakeflix' database and use sql queries to analyze the dataset.

  • Convert at least 30 rows of this csv file of movie data from its current format to a table with data using migrations and seeds.
  • Use migrations and seeds to create a table with at least 15 users. Generate usernames with Faker.js, and make up data about how users watch movies.
  • Use sql queries to analyze the dataset.

Option 2

Discuss SQL with a facilitator or workshop participant

  1. Clearly phrase questions or problems you are having with SQL
  2. Create sample tables to illustrate a question
  3. Adapt solutions proposed by others
  4. Discuss ways to ensure against accidental data loss
  5. Describe security best practices

Option 3

Write advanced SQL queries

  1. Write a query that uses a subquery as a filter
  2. Write a query using a Common Table Expression
  3. Write a query that self joins
  4. Write a query that uses UNION