SQL Practice: Basic Queries

Practice writing basic queries in SQL in this hands-on, interactive course with coding challenges in CoderPad.

Introduction

• Talking to your database in SQL
• What you should know
• Exploring the lab environment

1. Code Challenges

• Solution: Get sorted data from a table
• Solution: Retrieve data from multiple tables
• Solution: Retrieve data filtered on a range
• Solution: Retrieve aggregated data
• Solution: Get data filtered with a string pattern
• Solution: Find the most expensive order
• Solution: Find the average of orders

Conclusion

• Next steps