Practice writing basic queries in SQL in this hands-on, interactive course with coding challenges in CoderPad.
Overview
Syllabus
Introduction
- Talking to your database in SQL
- What you should know
- Exploring the lab environment
- 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
- Next steps
Taught by
David Gassner
