On Wed, 18 Mar 2009, Dermot wrote: > I need get up to speed on a number of aspect of databases. I do need to > grasp SQL syntax but also I also could use a more ideas on schema design > and the process of modelling.
For a well-written, in-depth book on SQL I highly recommend Rick van der Lans' "Introduction to SQL, 4th Ed." Very comprehensive. For schema and normalization insight, as well as structuring your code to prevent future problems, read Joe Celko's "SQL Programming Style." He has other books, such as "SQL for Smarties, 3rd Ed.", but that may be more advanced than you want right now. Check out his other books and you're sure to find what you need. Rich -- Richard B. Shepard, Ph.D. | Integrity Credibility Applied Ecosystem Services, Inc. | Innovation <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users