SQL and Relational Algebra Exercises in PCRS
Project Leads: Ilir Dema, Diane Horton, Michael Liut, Andrew Petersen
Support for SQL and relational algebra (RA) exercises in PCRS is in beta. Currently, instructors can create SQL and RA exercises, and students can submit solutions and receive immediate feedback. Unlike the other languages PCRS supports, visualization of execution is not yet supported, but other basic PCRS features, like support for videos and non-programming exercises, are available.
The current video content is organized by weeks, aligned with the delivery of the Introduction to Databases course at the University of Toronto Mississauga.
- Week 1 (3 videos)
- Welcome (1 videos)
- Asynchronous Component (2 videos)
- Week 2 (6 videos)
- Asynchronous Component (6 videos)
- Week 3 (5 videos)
- Asynchronous Component (5 videos)
- Week 4 (5 videos)
- Asynchronous Component (5 videos)
- Week 5 (8 videos)
- Asynchronous Component (8 videos)
- Week 6 (6 videos)
- Asynchronous Component (6 videos)
- Week 7 (5 videos)
- Asynchronous Component (5 videos)
- Week 8 (3 videos)
- Asynchronous Component (3 videos)
- Week 9 (3 videos)
- Asynchronous Component (3 videos)
- Week 10 (0 videos)
- Week 11 (0 videos)
- Week 12 (0 videos)
PCRS, including SQL support, is open source and is available for download.