Test your SQL skills with these concise challenges.
Overview
Syllabus
Introduction
- SQL code challenges
- Using GitHub Codespaces with this course
- Exploring the databases and running SQL code
- 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
- 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
Taught by
Scott Simpson
