SQL Code Challenges

Test your SQL skills with these concise challenges.

Introduction

• SQL code challenges
• Using GitHub Codespaces with this course
• Exploring the databases and running SQL code

1. In the Restaurant

• Create invitations for a party
• Create a table to store information
• Print a menu
• Sign a customer up for your loyalty program
• Update a customer's personal information
• Remove information from the database
• Log customer responses to an invitation
• Look up reservations
• Take a reservation
• Take a delivery order
• Track your customer's favorite dishes
• Prepare a report of your top customers

2. At the Library

• Check book availability
• Add new books to the library
• Check out books
• Check for books due back
• Return books to the library
• Encourage patrons to check out books
• Find books to feature for an event
• Book statistics