CertForums


Go Back   CertForums > Certification Forums > Microsoft Certification Forums > SQL Exams
Reload this Page SQL Books - DB2/Oracle/SQL Server
Home Forums Register Search Today's Posts Mark Forums Read


SQL Books - DB2/Oracle/SQL Server
Reply
 
Thread Tools Display Modes
  #1  
Old 04-Jun-2009, 10:17 AM
dsmith1983 dsmith1983 is offline
New Member
Posts: 1
  
Reputation
Points: 0 dsmith1983 has no points
Power: 3
Awards
None
Profile
Join Date: 04 Jun 2009
Rep Power: 3
dsmith1983 has no points
SQL Books - DB2/Oracle/SQL Server
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

 
Reply With Quote
  #2  
Old 05-Jun-2009, 10:37 PM
Bluerinse's Avatar
Bluerinse Bluerinse is offline
Senior Moderator
Posts: 8,867
  
Reputation
Points: 4469 Bluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 points
Power: 145
Awards
None
Profile
Join Date: 29 Jun 2003
Location: The Gold Coast, QLD Australia
Certifications: C&G Electronics - MCSA (W2K) MCSE (W2K)
WIP: None but considering SBS
Rep Power: 145
Bluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 pointsBluerinse has over 4000 points
Bumpidy bump

RIP UCM
 
Reply With Quote
  #3  
Old 05-Jun-2009, 11:17 PM
dmarsh dmarsh is offline
Lifetime Member
Posts: 2,500
  
Reputation
Points: 8280 dmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 points
Power: 113
Awards
None
Profile
Join Date: 24 May 2007
Certifications: One or two...
Rep Power: 113
dmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 pointsdmarsh has over 4000 points
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...

Last edited by dmarsh; 05-Jun-2009 at 11:31 PM.
 
Reply With Quote
  #4  
Old 21-Nov-2009, 07:35 AM
rojertwose rojertwose is offline
New Member
Posts: 3
  
Reputation
Points: 0 rojertwose has no points
Power: 2
Awards
None
Profile
Join Date: 14 Nov 2009
Rep Power: 2
rojertwose has no points
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..

lautsprecherkabel
 
Reply With Quote
  #5  
Old 21-Nov-2009, 12:48 PM
onoski's Avatar
onoski onoski is offline
Lifetime Member
Posts: 2,651
  
Reputation
Points: 1667 onoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 points
Power: 49
Awards
None
Profile
Join Date: 08 Mar 2007
Location: London. UK
Certifications: MCP, HNC BIT, ITIL Fdn V3, SDI Fdn
WIP: MCSE 2003
Rep Power: 49
onoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 pointsonoski has over 1500 points
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

Jesus Christ saves, but some people get offended when they hear that. Just puzzled
 
Reply With Quote
Reply

Go Back   CertForums > Certification Forums > Microsoft Certification Forums > SQL Exams
Reload this Page SQL Books - DB2/Oracle/SQL Server

Bookmarks

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
FREE : MS Intro SQL course UKDarkstar Training & Development 2 19-Dec-2008 11:01 AM
Microsoft Releases SQL Server 2008 to Manufacturing, IT Pros wagnerk News 0 07-Aug-2008 04:02 PM
SQL Server 2005 Webcasts shadybrady SQL Exams 0 25-Jun-2008 08:58 AM
The Official Guide to Installing SBS Sparky SBS 17 20-May-2007 10:54 AM


All times are GMT +1. The time now is 12:32 AM.
RSS Contact Us - Support Us - CertForums - Archive - Privacy Statement - Top
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
CertForums.co.uk (C) copyright 2003-2009 All Rights Reserved. Content published on CertForums.co.uk requires permission for reprint.
Lunarpages.com Web Hosting