On Fri, 1 Aug 2008, David Nelson wrote: > You addressed Dwight's example, but not his question -- which is whether > there is a resource for answering questions like this.
dave, I thought that my recommendation of Mike Owens' book was a pointer to a reference that would answer questions such as this. Regardless, here's another one: Rick van der Laan's "Introduction to SQL, 4th Edition." It is an outstanding introduction to DDL (Data Definition Language; that is, how to design and normalize a database schema) and DML (Data Manipulation Language; that is, how to enter, retrieve, and alter data in tables). And for those who want to refine their knowledge and skills, I highly reccomend any of Joe Celko's books. I read his columns in Data Based Advisor in the 1980s and 1990s as well as his books. Last year I had a need to better understand time-based queries so I wrote to him for pointers to resources. He recommended Rick's book. As an aside, most dbms have datetime data types but do not fully (or even adequately) support time as presented in the SQL standard. Because most business (and scientific) databases have a very strong time element associated with queries and reports this lack surprises me. Anyway, Dave, if that's not sufficient, please ask and I'll try to provide better answers. 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
