March 22, 2004 at 3:00 pm
After posting a question requesting help for a syntax problem, the following question arises:
Is there any tutorial for understanding syntax which might take its student through some excercises to help get the student grounded in syntax fundamentals?
TIA
GaryA
March 22, 2004 at 3:40 pm
When you say Syntax fundamentals are you meaning SELECT, UPDATE, DELETE, TRUNCATE, JOIN and such or T-SQL specifically cause there are lot's of books out there but the For Dummies series generally does just great.
March 22, 2004 at 4:07 pm
if you mean how to read the syntax in the documentation, then I'd look up resources on BNF (Backus-Naur Form) or EBNF.
regards
Billy
March 22, 2004 at 5:28 pm
Sorry for poorly stating the question, but thanks for all the help.
I was specifically meaning the syntax presented in BOL for how to construct whatever needed to be constructed.
I think this means understanding BNF (Backus-Naur Form) or EBNF.
I am also referring myself to BOL "syntax conventions" topics.
Again my thanks to all.
GaryA
March 23, 2004 at 8:22 am
Some of the best books for general SQL syntax are those written by Joe Celko. They are not SQL Server specific.
Another one is Guru's Guide to Transact-SQL by Ken Henderson. This one is specific to SQL Server.
March 23, 2004 at 10:21 am
For EBNF conventions try:
http://www.garshol.priv.no/download/text/bnf.html
http://cui.unige.ch/db-research/Enseignement/analyseinfo/AboutBNF.html
Francis
March 23, 2004 at 11:59 am
Thanks to all.
I will get and read the Guru's Guide to Transact-SQL by Ken Henderson.
I will read the URL provided by fhanlon.
Again, thanks.
GaryA
April 4, 2004 at 11:31 pm
Have a look at http://www.sqlcourse.com/
For basic syntax and online excercises. There is also a more advanced course at http://www.sqlcourse2.com/
Cheers,
Angela
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply