02-Advanced.md

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
   • Daily Challenge 2
2. Write a query using a Common Table Expression
   • Daily Challenge 3
3. Write a query that self joins
   • Daily Challenge 8
4. Write a query that uses UNION
   • Daily Challenge 14