I recommend this free online class from Stanford: Introduction to Databases <https://www.coursera.org/course/db>
It's pretty comprehensive (but not too in-depth) if want to get started with database theory. Here's the syllabus copied from the website: This course covers database design and the use of database management > systems for applications. It includes extensive coverage of the relational > model, relational algebra, and SQL. It also covers XML data including DTDs > and XML Schema for validation, and the query and transformation languages > XPath, XQuery, and XSLT. The course includes database design in UML, and > relational design principles based on dependencies and normal forms. Many > additional key database topics from the design and application-building > perspective are also covered: indexes, views, transactions, authorization, > integrity constraints, triggers, on-line analytical processing (OLAP), > JSON, and emerging "NoSQL" systems. You can skip certain sections if you're not interested but I'd recomment going through the entire course, it's worth it. On Mon, Aug 26, 2013 at 8:05 PM, Gerry Snyder <[email protected]>wrote: > O'Reilly just started a 50%-off sale on all ebooks (60% on orders of $100 > or more), good through Sept. 10. A good chance to pick up these or anything > else, SQL-oriented or otherwise. > > The discount code* *is B2S3 (but is also shown on the website). > > > Gerry > * > * > > > On Thu, Jul 18, 2013 at 5:31 AM, Richard Hipp <[email protected]> wrote: > > > On Tue, Jul 9, 2013 at 9:27 PM, Jay A. Kreibich <[email protected]> wrote: > > > > > > > > If you want to learn more about the theory and concepts behind SQL, I > > > would strongly recommend these two books: > > > > > > SQL and Relational Theory (2nd Ed) by C.J. Date > > > http://shop.oreilly.com/product/0636920022879.do > > > > > > Relational Theory for Computer Professionals by C.J. Date > > > http://shop.oreilly.com/product/0636920029649.do > > > > > > > O'Reilly is running a half-price sale on the latter book, today only. > ($16 > > instead of the usual $32.) Use the discount code "DEAL" to claim the > > reduced price. > > > > -- > > D. Richard Hipp > > [email protected] > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Dmitry Pashkevich _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
