Databases
🏆 Capstone: design and query a database
Final project of the track: an online store with customers, products, orders and order items. It combines JOINs, aggregations and subqueries in real queries.
What you'll learn
- Model the schema of a store (customers, products, orders, order items) with its relationships
- Combine tables with several
JOINs walking through the intermediate order-items table - Compute derived values and totals with
GROUP BYand aggregate functions - Compare rows against computed values using subqueries or CTEs
Lessons
The store's data modelFour related tables: customers, products, orders and order items. Query plan: join, aggregate, compareHow to walk relationships with JOIN, summarize with GROUP BY and compare with subqueries.Practice this module in the app
DevPath is a hands-on course: you read the theory here; in the app you put it into practice with exercises that really run, offline.
Start free in the app →