On 26.06.19 18:58, a...@zator.com wrote:
Irreproachable argumentation, which in my humble opinion is little or nothing
useful to those who want to enter in the diabolic world of SQL. Especially, if
you have not yet managed to change the chip and find out that for example, you
must carry out a program without using variables.
All the programming gurus I've read, agree that the best way to master a
language (SQL is) is to read code from good programmers and I do not remember
anyone who says that you ask in the forums when you have any questions, and the
sad reality is that it is difficult to find examples of SQL, apart from being
attentive to these pages where sometimes you learn a lot in the code of some
answers.
I understand and empathize absolutely with the O.P. and must add that in the
documentation of SQLite, I have always missed examples and comments that, for
example, can be found in the PHP doc.
Just a thougth.
--
A. J. Millan.
After working for several years in the field (having worked with dBase,
MS-Access, Oracle, DB2 (including DB2 on IBM-AS/400) and MySQL database
applications BEFORE doing any work with SQLite), I find myself
constantly going back to two books which I consider the "Old" and the
"New" Testaments of the SQL bible, if there is such a thing:
Old: "An Introduction To Database Systems" by C. J. Date, ISBN
0-201-82458-2 (I have the 6th edition);
New: "SQL For Smarties: Advanced SQL Programming" by Joe Celko, ISBN
1-55860-576-2 (I have the 2nd edition).
Then there are the SQL ANSI/ISO standards documents themselves, but I
wouldn't look for many hands-on examples there. Of the two books I just
mentioned, Joe Celko's book has the most abundant real-world examples,
but the Date book also has lots of examples albeit on a more basic
level. Caveat: I have read that the latest edition(s) of Joe's book
unfortunately has many typo's, but you should be able to work around
those IMHO.
SQL is, IMHO, very much a "learning by doing" language. The vendor or
programmer of an SQL RDBMS implementation should not be expected to do
much in the way of tutorials except where their implementation might
deviate (or expand upon) the functionality required by the standards
they claim to implement.
HTH,
Bob Hairgrove
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
