since everyone else is posting sql resources, i might as well too...
beginner tutorials.
this does seem to be the one thing most could brush up on...
as we are winding down the term, one thing i want to make clear. this class is probably doing better than any ciss243 class i've had. we are getting further and you all seem to have a good understanding - most of the problems you are running into are smaller - detail kind of things - crossing the t's and dotting the i's as opposed to conceptual issues...
the one thing most everyone could improve upon is the db stuff!!!
microsoft developer's network's asp.net site -
become familiar with this resource. it is comprehensive - can be a bit hard to find what you want and they seem to move pages from time to time...tons of great material though...
one of the most troublesome things people have with this class is when forming a dynamic sql statement where all the " ' and &'s go. it really is not that hard, once you get the idea. i plan on covering that in detail tonight
a reminder - keep blogging folks!
i have talked to a few folks about how sometimes throughout the term students feel a bit lost, and then how it comes together at the end. i don't think this is necessarily a bad thing. for example, in this course, up to last week or so, we studied a bunch of pieces and only now are we putting them together. the dilemma is, if you spend too much time on the individual pieces, it can be confusing because they are out of context. however, if you try to jump in and cover "the whole" without an understanding of the pieces, well, that doesn't work either. i really feel this class is starting to come together for a lot of people, and to extend it, for those i had in several classes, i think ALL the pieces are connceting. i recall my own education, a lot of what i learned did not even fit together until i started actually using the stuff on jobs.