| 1 | 10 | 1) 10% There are couple of things that I would like O'Naill to cover, but mostly glad that he didn't | ||||||||||||||||
| 1 | 20 | ~20% (tablespaces, checkpoints) Chapter 1: Selected Database Instance Installation Topics. Most of what is listed is too product-specific, so I have no problem with O'Neill's coverage. Both books are working towards their respective focuses, which are much different in this case. | ||||||||||||||||
| 1 | 30 | 30% Chapter 1: Selected Database Instance Installation Topics | ||||||||||||||||
| 2 | 0 | 2) 0% Would be interested in learning a little more about SQL Plus | ||||||||||||||||
| 2 | 10 | ~10% (saving query results to a file, command files) Chapter 2: SQL*Plus Again this is fairly Oracle-specific, but O'Neill's very short coverage was acceptable. We learned more in class than was in the book on this topic, though. | ||||||||||||||||
| 2 | 75 | 75% Chapter 2: sql*plus | ||||||||||||||||
| 3 | 0 | 3) 0% Also think that learning to deal with a user's account is a useful tool | ||||||||||||||||
| 3 | 20 | 20% (privileges in terms of GRANT/REVOKE is familiar) Chapter 3: Database Users Again quite Oracle-specific. | ||||||||||||||||
| 3 | 33 | 33% Chapter 3: Database Users | ||||||||||||||||
| 4 | 20 | 4) 20% I would prefer that table manipulations would be better covered by the O'Neill since its one of the most important features in the database. | ||||||||||||||||
| 4 | 75 | ~75%. Chapter 4: Tables I find all concepts familiar, but only about 75% was covered from what I remember of O'Neill. Partitioning and table comments get into the product-specific areas. | ||||||||||||||||
| 4 | 80 | 80% Chapter 4: Tables | ||||||||||||||||
| 5 | 20 | 5) 10% Glad that we didn't cover indexing in the freater details than we did, because it was confusing enough. | ||||||||||||||||
| 5 | 34 | 34% Chapter 5: Indexes | ||||||||||||||||
| 5 | 70 | 70%. Chapter 5: Indexes Some of the partitioning stuff, and unbalanced index detection aren't in O'Neill to my knowledge. | ||||||||||||||||
| 6 | 85 | 6) 85% Constraints make a good deal in database design, so I think it was helpful to learn constraints. | ||||||||||||||||
| 6 | 90 | 90% Chapter 6: Constraints | ||||||||||||||||
| 6 | 90 | 90%. Chapter 6: Constraints It would be nice if O'Neill covered constraints a little farther, I think. | ||||||||||||||||
| 7 | 80 | 80%. Chapter 7: Views Reaching the divergence of theory and practice. I found O'Neill's view coverage decent. | ||||||||||||||||
| 7 | 86 | 86% Chapter 7: Views | ||||||||||||||||
| 7 | 95 | 7) 95% Both books cover similar amounts on VIEWs, which implies that this topic is very important in database implementation, and therefore I am glad that it was covered by O'Neill. | ||||||||||||||||
| 8 | 0 | 8) 0% Security is the major issue in any computer related field nowadays, I would prefer if we would cover that as well. | ||||||||||||||||
| 8 | 9 | 9% Chapter 8: Security | ||||||||||||||||
| 8 | 10 | 10%. Chapter 8: Security Security and authentication at this level can get very product-specific, since it is not standardized through SQL. It's rather good that O'Neill didn't go too far into this sort of thing. | ||||||||||||||||
| 9 | 25 | 25%. Chapter 9: Space Management Oracle allows fined-grained control of those issues, but I don't feel that it's O'Neill's role to go into that depth. | ||||||||||||||||
| 9 | 75 | 9) 75% Space managing is also one of the primary concerns for any designer, good thing that we did cover it in this course. | ||||||||||||||||
| 9 | 100 | 100% Chapter 9: Space Management | ||||||||||||||||
| 10 | 0 | 0%. Chapter 10: PL/SQL This is not really relevant for O'Neill - it's an Oracle developer's topic. | ||||||||||||||||
| 10 | 10 | 10) 10% A lot of unclear and unfamiliar topics for me, so I am glad that we didn't have to cover most of those. | ||||||||||||||||
| 10 | 92 | 92% Chapter 10: PL/SQL | ||||||||||||||||
| 11 | 5 | 11) 5% Haven't heard anything about cursors, but I would like to barely cover it enough to know what it is without going into details. | ||||||||||||||||
| 11 | 35 | ~35%. Chapter 11: Querying Data O'Neill covers cursors to some extent, although we really didn't go there in class. | ||||||||||||||||
| 11 | 56 | 56% Chapter 11: Querying Data | ||||||||||||||||
| 12 | 0 | 0% Chapter 12: Built-In Packages | ||||||||||||||||
| 12 | 0 | 0%. Chapter 12: Built-in Packages Not familiar at all. | ||||||||||||||||
| 12 | 10 | 12) 10% Don't really regret that we didn't cover any built in packages. | ||||||||||||||||
| 13 | 80 | 13) 80% Have hardly any understanding of triggers since it's a complicated topic. And I don't find it that important to be studied in any greater details. | ||||||||||||||||
| 13 | 90 | 90%. Chapter 13: Triggers If I recall, we covered triggers decently in O'Neill, and I think the treatment could have been more in-depth, since the functionality is fairly common and standard-ish. | ||||||||||||||||
| 13 | 100 | 100% Chapter 13: Triggers | ||||||||||||||||
| 14 | 0 | 14) 0% Glad that O'Neill didn't' cover any SQL tuning. I first have to learn how to operate SQL before I would want to tune it. | ||||||||||||||||
| 14 | 40 | 40% Chapter 14: SQL Statement Tuning | ||||||||||||||||
| 14 | 40 | 40%. Chapter 14: SQL Statement tuning O'Neill covered the very basic way: EXPLAIN PLAN and stuff like that, but more advanced ways and optimizer hinting is product specific, and O'Neill shouldn't go further. | ||||||||||||||||
| 15 | 15 | 15%. Chapter 15: Database Tuning These sorts of issues are not product-specific, although ways of retrieving system statistics would be. I think O'Neill should go further into these sorts of issues. | ||||||||||||||||
| 15 | 20 | 15) 20% Again, good thing that we didn't cover the database tuning in greater details, because it seems like there is a lot of deep and complicated procedures. | ||||||||||||||||
| 15 | 54 | 54% Chapter 15 Database Tuning | ||||||||||||||||
| 16 | 35 | 16) 35% I think that amount of relational database we covered is enough for this course, even though I have very poor understanding of it. | ||||||||||||||||
| 16 | 35 | ~35% ?. Chapter 16: Create an Object Relational Database Chapter 4 is O'Neill's coverage of ORDBMS stuff, and we haven't covered that at all... I'm not terribly qualified to comment on the coverages. | ||||||||||||||||
| 16 | 100 | 100% Chapter 16: Create an Object Relational Database | ||||||||||||||||
| 17 | 0 | 17) 0% This is a chapter that definitely needs to be studied since database is closely related to web application. Plus, web application is something that interests me a lot. | ||||||||||||||||
| 17 | 0 | 0%. Chapter 17: Oracle Web App. Server This is not really database material - it's barely relevant for the Oracle book. | ||||||||||||||||
| 17 | 63 | 63% Chapter 17: Oracle Web Application Server | ||||||||||||||||