Now we’re entering the second half of the class where we delve more into the physical design of databases. Most of this information will be new to me. I’ve have had plenty of work over the years writing SQL scripts and doing basic database design, but never really crossed over into DBA territory. Now we [...]
Archive for February, 2012
Hard to believe I took my mid-term exam already. These 9-week classes go by fast. There’s a ton of information to go through in a short time though. I don’t mind that so much because I’m concentrating on one class at a time. That makes it much easier to focus on the task at hand. [...]
The relational algebra wasn’t so bad. I already understand the basic (and I stress basic) concepts behind set theory. Think of the drawing you may have seen before of two large intersecting circles, with different areas shaded in to represent INTERSECT, DIFFERENCE, UNION, etc. Add to that CROSS PRODUCT and CARTESIAN PRODUCT. These are the [...]
