fnoobx.blogg.se

1. ADVENTUREWORKS DATABASE QUERY EXERCISES PDF SOFTWARE
2. ADVENTUREWORKS DATABASE QUERY EXERCISES PDF CODE

When I tried using this file in my own code, I got an error. I still don't understand in one of the final assignments how the instructor used the table dsv1069.events_big (or something like that that wasn't listed as one of the files we had access to).

ADVENTUREWORKS DATABASE QUERY EXERCISES PDF SOFTWARE

Some of the solutions were fine, but others spawned errors when I cut and pasted them into Mode (the software we used). There also seemed to be some errors in the solution codes. You just had to write something in the discussion box to unlock the solutions video. To be fair, I'm not sure anyone actually looked at or read the discussion threads. Basically, everyone just wrote "done" or something like that. But no one EVER responded! So I stopped asking for help. I had trouble with some of the early assignments and (as instructed) asked for help in the discussion. More time should have been taken explaining the coding concepts, rather than watching mistakes.Īlso, there wasn't much discussion.

ADVENTUREWORKS DATABASE QUERY EXERCISES PDF CODE

I understand that the instructor wanted us to "see" that everyone, even experts, make silly mistakes when they code (like forget ,'s or the mis-name variables), but watching mistakes being made in EVERY solutions video was too much. The teaching style was frustrating for me, though. And the 'solution' does not provides the numbers needed to properly grade the works. The whole test was just a replication of something seen the last week of the course what we were told the previous weeks was of no use at all in there.

If I did right, these graphs did not add anything to the solution compared to a simple table. These problems are long reported by other learners on the forum, without being corrected.Īnd the final test? I found the instructions very poor: we had to do two graphs without being told what question they should answer. Some of the instructions were out of date (using databases that were not provided) or sometimes the solutions gave results different from what we would get typing the exact same code. On the whole, I don't really understand how such a course can be put online without more serious proof testing. It is a unfortunate we have no access to the code in a format that could be copy-pasted neither in the instructions nor in the solutions. We should have had access to slides, with the code on one side and comments on the other, such as in the previous course. Watching the videos was truly painful: I don't understand the virtues of watching someone type with all the typing noise, the countless mistakes and few proper explanation. The whole course was poorly structured or at least I couldn't understand the logic between the lessons.