Hi Team,
   Can anyone suggest a good reference/book/tutorial for SQL?  I have asked Tim via separate means.
Regards,
Ian

Ian


I went through this and I (my opinion only) think the answer is no.

There are lots of SQL books out there (probably the best respected are Joe Celko's) but ultimately I found the best way to learn was to continually solve little problems, find a nice comfortable brick wall, and ask questions.

The problem I had was none of the books answered the questions I had at the time. There's also the dialect problem. You can go totally out of your skull finding a nice easy solution and then realising its for SQL Server and uses stuff specific to it.

Roy Lambert

Ian,

The best reference book but not a tuturial:
SQL:1999 - Understanding the Relational Language Components
Jim Melton and Alan R. Simon

--
Fernando Dias
[Team Elevate]

Fernando


I don't dispute the recommendation but this is one of my points about dialects. So far we have (according to Wikipedia)  SQL-86, SQL-89, SQL-92, SQL:2003, SQL:2006, SQL:2008, SQL:2011, SQL:2016

ElevateDB was developed according to the SQL 2003 standard, lacks some features but has some extensions. I'm not a guru and don't understand what the differences are between the 1999 standard and the 2003 one or the ElevateDB one, apart from the fact that Tim nicely says which bits are extensions. Shame there's nothing saying "this bit left out"

As a reference document I think Tim's manual or the OLH are very good and generally have some nice examples.


Roy Lambert

Roy,

I'm also not a guru, but Jim Melton is.
The differences between SQL:1999 and SQL 2003 are minimal, considering the SQL implemented by Elevate.
Also, this book has the advantage of being neutral in terms of dialects as it's focused on the standard.
I'd say that if you have this book and the EDB manual and OLH, you have everything you need to be productive with EDB.
 
--
Fernando Dias
[Team Elevate]