Hi !

Does anyone know a good link (or book) where I can learn about the more advanced SQL
(2003) features ? In DBISAM I only used select/insert/update, and I'm a little lost with
all that fancy new stuff in ElevateDB. The SQL manual provides the syntax, but I have to
guess or try out what it's actually doing or what it's good for, and this trial and error
is too time consuming.

This is no complaint, I know I can't expect a SQL-2003-for-dummys to ship with ElevateDB

Regards,

Heiko

Heiko

>This is no complaint, I know I can't expect a SQL-2003-for-dummys to ship with ElevateDB

Damn good idea though.

Roy Lambert

ps I'd also like the name of a good book on the new ElevateDB flavour of SQL

Roy,

<< ps I'd also like the name of a good book on the new ElevateDB flavour of SQL >>

Yes, that would be very useful.  I think we should ask Ole Willy Tuv to recommend one:
he's the SQL standards guru on this newsgroup and others. Ole?

Regards,
Dan

Dan,

<< Yes, that would be very useful.  I think we should ask Ole Willy Tuv to
recommend one: >>

The only SQL book I've read myself is:

SQL:1999 Understanding Relational Language Components
Jim Melton, Alan R. Simon
ISBN 1-55860-456-1

Other sources I use is the SQL standard documents:

ISO/IEC 9075:2003
http://www.iso.org

and the vendor manuals shipped with the RDBMS I work with.

Ole Willy Tuv

I find Joe Celko's books very useful.  
. SQL for Smarties
. SQL Puzzles and Anzwers
. Data & Databases


--
Richard Harding
Windella Computer Knowhow
28 Freeman Drive
Lochinvar NSW 2321
Australia
Phone:   61 2 4930 7336
Mobile:   0419 016 032
email:   rharding@wck.com.au

Heiko,

<< Does anyone know a good link (or book) where I can learn about the more
advanced SQL (2003) features ? In DBISAM I only used select/insert/update,
and I'm a little lost with all that fancy new stuff in ElevateDB. The SQL
manual provides the syntax, but I have to guess or try out what it's
actually doing or what it's good for, and this trial and error is too time
consuming. >>

The Jim Melton book that Ole recommends is very good.  I don't know if he
has an updated 2003 version or not, but the 1999 book covers most of the EDB
SQL already.

--
Tim Young
Elevate Software
www.elevatesoft.com

I use three books

SQL for Dummies  (really)
SQL The Complete Reference
SQL in a Nutshell




On 3/21/07 8:47 AM, in article
2E1E35DF-0892-4EFE-B0C7-BC6967FEA48C@news.elevatesoft.com, "Heiko Knuettel"
<heiko@knuettel.com> wrote:

> Hi !
>
> Does anyone know a good link (or book) where I can learn about the more
> advanced SQL
> (2003) features ?