![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 5 of 5 total |
![]() |
Mon, Jun 25 2018 6:21 PM | Permanent Link |
Ian Branch | Hi Team,
Can anyone suggest a good reference/book/tutorial for SQL? I have asked Tim via separate means. Regards, Ian |
Tue, Jun 26 2018 2:29 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 |
Tue, Jun 26 2018 5:11 AM | Permanent Link |
Fernando Dias ![]() | 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] |
Tue, Jun 26 2018 9:44 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 |
Tue, Jun 26 2018 10:59 AM | Permanent Link |
Fernando Dias ![]() | 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] |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |