Level Up: SQL
1h 4mIntermediate2022-11-09
Authors
Scott Simpson
Creating Technology Courses as a Senior Staff Author at LinkedIn
Course details
These concise (less than 3:30) SQL challenges let you stretch your brain and test your talents. Instructor Scott Simpson frames the challenges in real-world scenarios you might encounter. Tasks range from creating a table to store party guest information to creating a query to find books to feature for a library event.
Skills covered
SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - SQL code challenges
- 02 - Using GitHub Codespaces with this course
- 03 - Exploring the databases and running SQL code
1. In the Restaurant
- 04 - Create invitations for a party
- 05 - Create a table to store information
- 06 - Print a menu
- 07 - Sign a customer up for your loyalty program
- 08 - Update a customer's personal information
- 09 - Remove information from the database
- 10 - Log customer responses to an invitation
- 11 - Look up reservations
- 12 - Take a reservation
- 13 - Take a delivery order
- 14 - Track your customer's favorite dishes
- 15 - Prepare a report of your top customers
2. At the Library
- 16 - Check book availability
- 17 - Add new books to the library
- 18 - Check out books
- 19 - Check for books due back
- 20 - Return books to the library
- 21 - Encourage patrons to check out books
- 22 - Find books to feature for an event
- 23 - Book statistics