On Mon, Apr 30, 2012 at 03:53:29PM +0100, Simon Slavin scratched on the wall: > > On 30 Apr 2012, at 3:18pm, Arbol One <arbol...@programmer.net> wrote: > > > I am learning SQL using SQLite, can anyone tell me of a good book > > to learn SQL using SQLite? > > Here's the cannonical list: > > <http://www.sqlite.org/books.html> > > The second one down, _Using SQLite_ is by a frequent contributor to > this list, and may suit you best.
"Using SQLite" has a lot of good information, but it might not be the best way to learn SQL. There are only two chapters on the SQL language itself... one chapter on SELECT and one chapter on everything else. It is a pretty shotgun approach to learning SQL, with very little hand-holding. While there are examples of most commands, they're typically quite terse. Part of the reason Using SQLite takes a very quick approach to the SQL language is that there are, literally, hundreds of books and websites out there about learning the SQL language. 95% of that information applies to SQLite. If you're just getting into SQL, one of the more language focused books might be better. If you're really new to language, you can start at the super basics with something like "Head First SQL": http://shop.oreilly.com/product/9780596526849.do Or a more moderate level book, like "Learning SQL": http://shop.oreilly.com/product/9780596007270.do If you really want an SQLite specific book, "The SQL Guide to SQLite" by Rick F. van der Lans might be worth a look: http://www.amazon.com/SQL-Guide-SQLite-Rick-Lans/dp/0557076765/ While I haven't read this specific book, van der Lans is a well known author in the SQL world, and I've read other books, including the iconic "Introduction to SQL": http://www.amazon.com/Introduction-SQL-Mastering-Relational-Database/dp/0321305965/ Intro to SQL is a huge book, and includes a number of very advanced topics. I'm not sure I'd use it as a starter book, but most serious SQL developers have a copy of it (and/or Celko's "SQL for Smarties") around. -j, author of Using SQLite -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
