This content has been marked as final. Show 10 replies
I'd recommend visiting http://asktom.oracle.com/pls/asktom/f?p=100:1:1482635074582322 for a 1/2 hour (or more) a day.
You'll learn a great deal from advanced query writing to how to create scalable applications and so much more.
I won't trivialize the importance of being good with SQL, but if you don't have any other fundamentals to draw on your application designs will likely be sub-optimal (no fancy query in the world will save you from a poorly designed application).
There is also:
Pro Oracle SQL (Amazon)
to be released November 1, 2010.
As for your question
is there anything else you can do with SQL knowledge like creating an application?
then the answer is yes. You should look into PL/SQL, the language for creating procedures, functions etc
which you wrap into packages. Applications typically interact with these packages..
Look here, under "most popular" : http://www.oracle.com/pls/db102/homepage
and you'll find
-Application Developer's Guide - Fundamentals
-PL/SQL User's Guide and Reference
that should keep you busy for a while.
Be aware that many books (you must pay for) only more or less mimic the free documentation!
I can recommend Laurent Schneiders Advanced Oracle SQL Programming.
I disagree. While I know his knowledge is tops and undisputed and all, the book suffers from poor layout and poor wording/ phrasing.
The language is sometimes a bit weird, and explanations very brief.
Several chapters are indeed very basic, and it starts off by printing 6 or 7 pages of insert statements, if I recall correctly. Not very interesting.
I own the book, but it's not on my workdesk.
There are a couple of good chapters (on xml, for example), but all in all I can't recommend it. It is simply not that readable, in my opinion.
I think it would have benefitted from a better editor/ publisher. Some of the figures are not very understandable.
The book's technical reviewer (Shapira) reviews it on Amazon as "Best SQL Reference for Oracle" , which is just downright silly imo.
Read the reviews on Amazon before you buy this book.
I agree, to a certain degree, with Joshua's short review. Laurent Schneiders comment to that review:
+"You probably should avoid buying advanced book and go back to playing Legos if you are a beginner,+
+but I put tremendeous efforts to give good code examples of everything I am explaining. "+
is in itself a good reason not to spend $38 on this book.
Sorry, but there are better books to buy.
I can recommend Laurent Schneiders Advanced Oracle SQL Programming.Thanks Michael & Super Star for your support :-) Nice to read
book suffers from poor layoutI have been myself disappointed by the final "layout" of my book, especially the diagram about MODEL and all the code for insert statements that have been included in the book. Sorry about this. I wish it did not happened.
and poor wording/ phrasingI am not a native English speaker. Probably I should stick to write blogs, as a blog is less academic and grammar/spelling is less a problem.
I am glad some readers could still find interesting content. I spent a lot of time to provide good examples. I cannot disagree more on Examples are weak
And Joshua do not seem to have more fun with Lego than with Oracle http://www.amazon.com/review/R3NZ41EUR8QACO/ref=cm_cr_rdp_perm lol
Sorry, but there are better books to buySure thing, Kyte and Feuerstein to just name two.
Whether we can be surprise by the insert statemtents stored in the book instead of on a depot over Internet (to copy and paste to be able to reply easily), your book contains plenty of good and tricky examples. Despite I'm not developer for a couple of years, it makes me wanted to play again on SQL development on my own and try some challenges.
Anyway, some people are never happy... so maybe you should not be worry too much.
..and next time try another publisher. Not joking.
Maybe also next time just assume the reader knows the basics.
How about teaming up with a couple of other aces or esteemed forum members
and write an Oracle book a'la Celko's SQL Puzzles and Answers? Advanced level, all the way.
If you write another book, I'll buy it and let you know what I think.