SQL Books - DB2/Oracle/SQL Server

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Can anyone please recommend books that cover basic SQL accross DB2/Oracle and SQL Server?

This would be really useful as we use all of the above at work

Cheers,
Dave

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Bumpidy bump

 

There is no such thing as truely generic SQL. There are numerous important differences between the databases you describe and their SQL syntaxes.

You will be able to write portable queries for a subset of your work if you work at it, but not everything. You will certainly not be able to use generic SQL-DML/DDL if you want to create the most optimal solutions as these may involve vendor specific extensions.

O'Reilly and SAMS provide some SQL neutral books.

I'd reccomend a vendor specific book for each DB you will be using. Maybe supplement this with a SQL 101 book if you think it will help.

Books tend to be a personal thing so maybe go to a good bookstore (Foyles?) and pick a few that you think will suit you.

MS SQL comes with BooksOnline which is OK. w3cschools is ok too.

Failing that read the reviews on amazon.com and put in a bulk order and hope for the best.

Thats probably the best I can say, I don't really read many SQL books. The few I have read I don't really rate highly and I had SQL tuition before I read them...

 

You can find ebooks regarding Oracle 10g, 11g, PL/SQL, SQL Server 2005 and MySQL. These books teaches you to install, create and share SQL Server 2005 reports, SQL server rendering, SQL Server reporting, Deploy and maintain report models, SQL Server report servicing and Etc so download following lings..
1. Professional SQL Server 2005 Reporting Services
2. Microsoft SQL Server 2005 Reporting Services Step by Step
3. MySQL Language Reference
4. MySQL Cookbook
5. OCA: Oracle 10g Administration I Study Guide (1Z0-042)
6. Oracle PL/SQL Best Practices
7. Oracle Database 11g: New Features for DBAs and Developers
8. OCP Oracle Database 10g: New Features for Administrators Exam Guide
Thanks..

 

I bought a book a while ago titled SQL programming and it was well laid out and easy to get to grips with. I'd check it out. Best wishes