Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Book for SQL and PL/SQL

 
Ayan Biswas
Ranch Hand
Posts: 104
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there any single good book where SQL and PL/SQL is covered in depth.
 
chris webster
Bartender
Posts: 2407
33
Linux Oracle Postgres Database Python Scala
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No, but there are lots of good SQL books, and lots of good PL/SQL books, though.

For SQL in general, you probably need a general introduction to SQL and relational databases. There are lots of these, so maybe ask on the JDBC forum for recommendations.

For SQL with a specific Oracle focus, you could look at the exam guide for the Oracle Certified Associate exams, which will give you all the info on Oracle's implementation of SQL, including any Oracle-specific functions etc.

For PL/SQL there is another Oracle exam guide, but my own favourite is Steven Feuerstein's Oracle PL/SQL Programming, which has been the definitive PL/SQL book for many years in its various editions.

There is also an excellent book called Mastering Oracle PL/SQL by Connor MacDonald which includes some excellent material on high performance PL/SQL for dealing with large volumes of data.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic