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
Introduction
- SQL code challenges
- Using GitHub Codespaces with this course
- Exploring the databases and running SQL code
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
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