SQL BASICS - RECOMMED BOOKS. RESOURCES

[jobillborf]

GREETINGS, I AM USING CRYSTAL REPORTS 8 CONNECTED TO A ORACLE DATABASE. PLEASE HELP, I AM INTERESTED IN LEARNING THE SQL BEHIND CRYSTAL. COULD YOU PLEASE RECOMMEND SOME BOOKS, WEB SITES OR RESOURCES I COULD USE. I KNOW VERY LITTLE ABOUT SQL CODE.

THANKS

 

[MalcolmW]

forum220 is ANSI SQL, which is the standard SQL that most databases support, although each database has its own enhancements and variations on the standard.
SQL for Dummies is a good intro to the basics.
SQL for Smarties (Joe Celko) is a more advanced book.
Plus, you should also pick up a book that focusses specifically on Oracle PL/SQL, maybe someone else knows a good one. It is probably a good idea to learn both the generic ANSI SQL, as well as PL/SQL, so that you are able to write SQL code not just in an Oracle environment.
Malcolm Wynden
malcolm@wynden.net

 

[darwin101]

Do a search for tutorial and SQL on google.com.
Books by Johnathan Gennick and Stephen Furstein (sp?) are very good. SQL in 21 days is also worth reading. You should be able to learn a great deal from web tutorials. Oracle's complete reference is a good book to have. They also are making a 101 series that teach the beginners. If you need books check out bookpool.com..... much cheaper than the other big guys.