Just finished reading chapter 4 in it entirety. I still need to work through the exercises and in book examples, then develop my own homework that will test my skills to writing sufficient code for these ideas.
I'm feeling like I did before I took the 461 test last time that I understand the code much better READING it, but the practice of writing it is where I am weaker. Chapter four was a big chapter on subqueries (nesting), table expressions (derived tables, CTE, views, and Inline Table Functions), Apply opperators, and Set opperators (Union, Union All, Intersect, Except). This is a big chunk of stuff to integrate and learn to write squeaky clean. The next chapter is windowing which is something that I think they covered inadvertently in this chapter because some of the examples in the book had to due with ROW_NUMBER(), which is kind of a windowing feature; as well as examples in which you had to "find the two lowest priced items from supplier xyz that each have a unique categoryid". Speaking of which, that's a pretty good homework assignment. I should look over the DB to become more familiar with it so that I'm able to play around with it more.
I don't want to move onto chapter 5 until I'm comfortable writing some queries base in Chapter 4.
Cheers until next time!
No comments:
Post a Comment