> The online SQL quizzes are pretty cool little puzzles but the only truly exciting part of the class was creating a website using a large database as the final project, which I can't imagine will be offered in the online version.
The year I took it, they couldn't get the Oracle licenses sorted out in time so they forewent the entire final project. They ended up just talking about XPath and Data Warehousing instead (both of which seemed way too enterprise-y to me at the time to commit either to long-term memory). The schema design stuff I found helpful, if only to drill into my mind the importance of data normalization.
The year I took it, they couldn't get the Oracle licenses sorted out in time so they forewent the entire final project. They ended up just talking about XPath and Data Warehousing instead (both of which seemed way too enterprise-y to me at the time to commit either to long-term memory). The schema design stuff I found helpful, if only to drill into my mind the importance of data normalization.