Syntax tutorial

Question

Syntax tutorial

Gary Andrews

SSCommitted

Points: 1639
More actions
March 22, 2004 at 3:00 pm

#107862

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

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

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.

bp SSCarpal Tunnel Points: 4656 More actions · Answer 2

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

Gary Andrews SSCommitted Points: 1639 More actions · Answer 3

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

Robert Stewart Hall of Fame Points: 3399 More actions · Answer 4

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.

fhanlon SSChampion Points: 13131 More actions · Answer 5

For EBNF conventions try:

http://www.garshol.priv.no/download/text/bnf.html

http://cui.unige.ch/db-research/Enseignement/analyseinfo/AboutBNF.html

Francis

Gary Andrews SSCommitted Points: 1639 More actions · Answer 6

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

Angela But Hall of Fame Points: 3848 More actions · Answer 7

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

Syntax tutorial

Cookies on SQLServerCentral