| Author |
Attn: Database gurus
|
|
| prezbedard 2004-03-18, 12:31 pm |
| I work with and have the responsibility for several ms access databases on regular basis and would like to learn SQL in more depth to expand more db knowledge but I don't want to limit my to ms access so my question is which one of these general SQL books would you guys/gals recommend.
SQL FUNDAMENTALS, 2/E
SQL: THE COMPLETE REFERENCE, 2/E
SQL BIBLE
Thanks | |
|
| SQL Bible I would say for starters. The complete reference may be a bit much to start with. Keep in mind almost all RDBMSs have their own specific dialect of sequel. | |
| prezbedard 2004-03-18, 1:13 pm |
| Well I'm not completely new to SQL I know the basics. I've played around with MySQL some bsides ms access. I know about the different dialects. It seems that the SQL FUNDAMENTALS, 2/E one does cover the different dbs. I want something that would be for all levels so it would start beginnner/intermidiate to advanced. Would the SQL Bible suffice for that?
Thanks | |
| prezbedard 2004-03-18, 1:18 pm |
| I just read the write up on SQL Bible though it seems like a good book it say it covers Oracle, IBM DB2, and Microsoft SQL Server. No mention of MySQL. I assume MS SQL server is uses the same syntax as ms access. | |
|
| quote:
Originally posted by prezbedard
I just read the write up on SQL Bible though it seems like a good book it say it covers Oracle, IBM DB2, and Microsoft SQL Server. No mention of MySQL. I assume MS SQL server is uses the same syntax as ms access.
MySQL is mostly the same except for the special functions it has. At any rate, I wouldn't buy a book on it since all the docs are freely available on the web.
MS SQL used standard SQL, the SQL in Access is kind of fcuked up looking with all those parens and brackets. But although not as messy as the design-view generated queries, they are compatible. | |
|
| quote:
Originally posted by prezbedard
Well I'm not completely new to SQL I know the basics. I've played around with MySQL some bsides ms access. I know about the different dialects. It seems that the SQL FUNDAMENTALS, 2/E one does cover the different dbs. I want something that would be for all levels so it would start beginnner/intermidiate to advanced. Would the SQL Bible suffice for that?
Thanks
Well the Complete Reference is probably best for ALL levels, but it is, like it says, more of a reference book than anything and is not too helpful when you are learning stuff. It is quite helpful when you already know what you want to do but just need the syntax or specifics though. I'd stick with the bible for now. | |
| prezbedard 2004-03-18, 2:11 pm |
| Thanks for the input. |
|
|
|