Brian Baquiran said: > Miguel A Paraz wrote: >> On Thu, May 29, 2003 at 04:25:23PM +0800, Ariz Jacinto wrote: >> >>>maybe it's about time to prepare for the MySQL Professional >>> Certification. >> >> Speaking of, I find myself lacking in database theory know-how. >> I really found it so boring back in college, but it's essential now. >> >> What are good courses that teach how to design tables and queries... >> not things you can learn in the manuals like how to start your db >> engine. :) > > Aside from Oracle-specific training, I've never taken a DB course that I > found > useful. I do have a couple of books that are pretty good, though. > "Practical SQL > Handbook" by Bowman gives a fast intro to SQL and queries, while Joe > Celko's > "SQL for Smarties" and "SQL Puzzles and Answers" have mind-boggling > examples of > real-world SQL. >
Aside from books, ... grep'ing through the documentation that comes with the database usually gives lower seek times :) SQL one of the most useful things you'll learn. I even use it to evaluate student prerequisites like: "CMSC155 = ( CMSC111 OR CMSC121 OR CMSC131 ) AND CMSC101" now replacing all subjects with whether a student passed or now: select '1' where ( TRUE OR TRUE OR FALSE ) AND TRUE; thus giving me an RDBMS-fast boolean expression evaluator. :) -- "There is no security in life, just opportunities." Douglas McArthur -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
