Hands-On SQL Challenges: Test Your Knowledge
39mIntermediate2025-03-07
Authors
Scott Simpson
Creating Technology Courses as a Senior Staff Author at LinkedIn
Course details
The concise SQL challenges in this course 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.
Learning objectives
Model real-world tasks as logical steps that can be represented with SQL statements.
Describe how to work with related data across multiple database tables.
Use SQL commands to perform real-world tasks with database records.
Learning objectives
Model real-world tasks as logical steps that can be represented with SQL statements.
Describe how to work with related data across multiple database tables.
Use SQL commands to perform real-world tasks with database records.
Skills covered
SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - SQL challenges to test your knowledge
- 02 - Exploring the databases
- 03 - CoderPad tour
1. In the Restaurant
- 04 - Solution - Create invitations for a party
- 05 - Solution - Create a table to store information
- 06 - Solution - Print a menu
- 07 - Solution - Sign a customer up for your loyalty program
- 08 - Solution - Update a customer's personal information
- 09 - Solution - Remove information from the database
- 10 - Solution - Log customer responses to an invitation
- 11 - Solution - Look up reservations
- 12 - Solution - Take a reservation
- 13 - Solution - Take a delivery order
- 14 - Solution - Track your customer's favorite dishes
- 15 - Solution - Prepare a report of your top customers
2. At the Library
- 16 - Solution - Check book availability
- 17 - Solution - Add new books to the library
- 18 - Solution - Check out books
- 19 - Solution - Check for books due back
- 20 - Solution - Return books to the library
- 21 - Solution - Encourage patrons to check out books
- 22 - Solution - Find books to feature for an event
- 23 - Solution - Book statistics
Conclusion
- 24 - Next steps in your SQL journey
Related courses
- Complete Guide to Analytics Engineering
- Scala Essential Training for Data Science
- SQL: Data Reporting and Analysis
- Text to SQL: Amazon Redshift Serverless for Generative SQL in Amazon Q
- SQL Databases in Microsoft Fabric
- Hands-On SQL: Building Data Products in Dremio
- Complete Guide to SQL for Data Engineering: from Beginner to Advanced
- Intermediate SQL for Data Scientists