Practice: Databases

💡 This is your chance to put what you’ve learned into action.

Try solving these practice challenges to check that you understand the concepts.

Submission

To log your practice for credit:

Submit on Gradescope

  • Practice exercises will be graded for completion not correctness. You have to document that you did the work, but we won't be checking if you got it right.
  • You are encouraged to engage with all the exercises listed on the practice page.
  • You are expected to submit only the details requested on the Gradescope submission.

SQLBolt: SELECT Queries Review

Check your knowledge of SELECT queries by completing the review on SQLBolt:

SQL Review: Simple Select Queries

SQLZoo: More SELECT Practice (optional)

Get another perspective on SELECT queries with SQLZoo.

SQLZoo SQL Tutorial

Making it real (optional)

Learn about mock data, and practice making real SQL queries from a python CLI application.

Open "Making it real" in Github Classroom

Show solution video walkthrough