Test your SQL skills. Follow along with a series of five-minute coding challenges that provide hands-on practice.
Overview
Syllabus
Introduction
- SQL Code Challenges
- 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 a customer's record
- Log customer responses
- Look up reservations
- Take a reservation
- Take a delivery order
- Track your customer's favorite dishes
- Prepare a report of your top five 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
