| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
|
Index > Oracle Books > SQL and SQL*Plus
| ||
|
SQL Cookbook (Cookbooks (O'Reilly)) by Anthony Molinaro Highly recommended! | The Cookbook series has always been a reference for users that had at least some knowledge of the subject.
But even if you are just starting out, you can get started right away with writing commands. And since this book covers the major SQL formats, you won't be left out. I bought this book because an application uses Oracle and I was able to do what I needed to do. The great thing about the cookbook series is that... Great book!!! |
|
Backup and Recovery by W. Curtis Preston Highly recommended! | The book is pretty well rounded and has overviews of different backup and recovery practices in addition to diving into the nuts and bolts of specific methods. Overall it is excellently written. |
|
SQL Pocket Guide by Jonathan Gennick Highly recommended! | Out of my several books on SQL, this is the one that I use most often. I find it most useful as it is very easy to use and has a good coverage on the subject. The keywords index is invaluable for finding the right information in the book.
The pocket guide covers syntax differences between SQL, MySQL and Oracle and provide comprehensive explanations to various properties. Highly recommended for anyone working with SQL and/or MySQL. |
|
Oracle Database 10g SQL (Osborne ORACLE Press Series) by Jason Price, McGraw-Hill Highly recommended! | I would highly recommend this reference for anyone. Organized well, good examples, and thorough. |
|
SQL Hacks by Andrew Cumming, Gordon Russell Highly recommended! | These hacks aren't for the beginning user, but for more advanced users. The authors explain the hacks, which can be written for any of a number of different databases, but then they explain necessary changes to allow a user of a differing db product to use the hacks as well.
MySQL, SQL Server, Postgres, Oracle among the ones covered. If you are looking to make a step up from a decent database user to a very good one, this is a book for you. |
|
Optimizing Oracle Performance by Cary Millsap, Jeff Holt Highly recommended! | This book is so interesting that on a couple occasions I've fallen asleep reading it, because I want to "find out what happens next" -- not because it is boring. Even the chapter on queueing theory that has a lot of math in it is understandable and interesting, even though I have a mild aversion to math...
It has highlighted a lot of very useful techniques to ensure you focus on the true problems, and not the various ratios we've taken as absolute truth for so many years. I can't wait to try these concepts out! |
|
OCA/OCP: Introduction to Oracle9i SQL Study Guide by Chip Dawes, Biju Thomas |
I just passed the 1z0-007 exam yesterday. I dont have a lot of experience with oracle, but this book helped me learn all the important concepts for the exam and helped me pass it in my first attempt. I recommend this book to anyone who is looking to pass the exam. However, the usefulness of this book ends there. It is not very useful and the explanations are not detailed enough for learning more about the technology itself. |
|
Oracle SQL by Example, Third Edition by Alice Rischert Highly recommended! | You will like this book! I knew absolutely nothing about SQL, but this book will put your mind at ease. The author is easygoing and writes what could be a very tough topic in a non-intimating way. Believe me, this book will quickly become your best friend when it comes to learning SQL/Oracle. This book is so ...
Now the downside: I would say the only confusing part is uploading the tutorial database (which you have to do from the author's website. It will take a little brainpower and a few aspirin because the directions on the author's website assume some previous knowledge. But trust me; you will eventually get it to work. I should tell you that it would be helpful, not necessary, but helpful to know a little bit about relational databases (like MS Access) before you tackle Oracle. Anther thing to know is that the author tells you that you need the Standard or Professional full editions, which would be very expensive and only necessary if you own a Fortune 500 company! But, thankfully, you do not need the full versions. All you need is the Express Edition to practice on and the book tutorials are well suited to it. The Express Edition is free software downloadable from Oracle's website, and really, it's all the casual hobbyist needs anyway and it's plenty powerful. Now, for those who are not familiar with Oracle, it has a completely different look and feel from ...like MS Access, for example. Oracle looks like DOS and initially feels just as clunky. But, it will grow on you. You also can apply the SQL concepts to Microsoft SQL Server if you want to learn another DB. So if you are really serious and dedicated about learning databases, and don't mind a difficult initial set up, buy this book. |
|
Mastering Oracle SQL, 2nd Edition by Sanjay Mishra, Alan Beaulieu | I'm no SDE, but I had a need to learn enough SQL to enable me to hit my company's Data Warehouse tables directly and employ some complex joins. This was the book recommended to me, and it did the trick. I sat down and began reading it and was quickly writing increasingly complex queries. I found the explanations ... |
|
Implementing Database Security and Auditing: Includes Examples for Oracle, SQL Server, DB2 UDB, Sybase by Ron Ben Natan Highly recommended! | The book is very practical and timely; it contains the complex of useful rules either dispersed in many different sources or not published at all. For example my colleague who is a DB Oracle administrator in Sony Computer Entertainment distinguished the following recommendations:
· Hardening Oracle environment · Avoiding the use of mod_plsql · Not making a database a web server and not store HTML pages in the database From my perspective the rules concerning Web services and cross-site scripting are the most valuable. Working on these applications I see how vulnerable is a database server due to some security holes; therefore avoiding the holes is important. |
|
Oracle 10g: SQL by Joan Casteel Highly recommended! | No review available! |
|
Oracle SQL Tuning Pocket Reference by Mark Gurry Highly recommended! | This is the best book I've seen for tuning Oracle SQL. It is well written, up to date (includes 9i info), and full of examples and real world experiences. All packed into 100 little pages! Many of the Oracle books I've purchased (especially the tuning references) are just sitting on the shelf collecting dust. ... |
|
Oracle SQL Plus Pocket Reference (Pocket Reference (O'Reilly)) by Jonathan Gennick | ...a good combination of size, price, and content. I have the 3rd edition, which includes an 8-page index. I use this as part of teaching a class in Oracle Developer and recommend it for my students. As the other reviewers recommend, write your name in it...the Oreilly pocket references are easy to misplace, and ...
Drawbacks? I'd like a larger index, although the current one is useful. A little bit more room throughout the book for notes might be handy, although it would enlarge the book a bit. I think the content is about right, although there will always be things one can't find, and other topics which are never used in this type of book. And, as with all the Oreilly pocket references I've seen, there is no colophon, so one must go to the original large book to discover that the insect on the front cover is a moving leaf, Phyllium giganteum, a Malaysian creature which grows to about four inches in length...roughly the width of the book! |
|
Oracle SQL*Plus: The Definitive Guide (Definitive Guides) by Jonathan Gennick | Oracle SQL Plus: The Defnitive Guide
Jonthan Gennick 1-56592-578-5 This book is great for those using the SQL Plus tool. I use SQL Plus for Oracle 8 and 9. This book covers up to 8i but I have not had any trouble using the commands in 9i. I have not tried the commands listed on 10g yet. The book is easy to use since the topics are split into reasonable chapters and the font is ... |
|
Mastering Oracle SQL and SQL*Plus by Lex de Haan Highly recommended! | What a pleasure to pick up a computer book and finish it.
I was completely new to SQL and was looking for a book that would get me started, this was it. What impressed me more was when I came upon an obstacle the response I received from the author was quick and informative. Many thanks Lex |
|
Oracle Data Dictionary Pocket Reference by David C Kreines, David C. Kreines | "ORACLE Data Dictionary Pocket Reference" describes (most of) the ORACLE data dictionary views. This book sorts the DD views according to subjects e.g. "Replication". Normally for each view you will find a sentence about the contents of the view and the columns with datatype and not null constraints (if present). For ... |
|
OCP Introduction to Oracle9i: SQL Exam Guide by Jason Couchman | This is the only book I used to prepare for the OCP 1Z0-007 exam. The Oracle published exam objectives were covered and the sample test questions on CD were good. Other than one or two SQL syntax surprises, I had no problems with the exam. This book may not be adequate if you are unfamiliar with databases, SQL, and ... |
|
Oracle SQL*Loader: The Definitive Guide by Jonathan Gennick, Sanjay Mishra Highly recommended! | This little book is a lifesaver. I have benefitted a lot from the examples provided in this book. SQL Loader can be hard but very easy if you have a guide like this book. |
|
Oracle Utilities Pocket Reference (Pocket Reference (O'Reilly)) by Sanjay Mishra | No review available! |
|
Oracle High-Performance SQL Tuning by Donald K. Burleson | It is a good book for those interested in the internals of sql. The knowledge of the author about the matter is excellent, and his writing style is clear, simple, and funny. |
|
Oracle Utilities: Using Hidden Programs, Import/Export, SQL*Loader, Oradebug, Dbverify, Tkprof and More by Dave Moore, Don Burleson Highly recommended! | I found this book to be a gold chest of useful tips and tricks to using the dozens of Oracle utilities and I even learned many new Oracle utilities that I had never used before that existed! It is great tool for when you need to perform an Oracle DBA task quickly and may not recall the exact syntax or method to use a ... |
|
Oracle Application Server 10g Essentials by Robert Stackowiak, Donald Bales, Rick Greenwald | What the heck is an "application server"? At the simplest level, it is a web server that can make dynamic web pages. Typically, the data in these pages come from a back end SQL server. As the authors show us here, the Oracle server can easily do this, where, unsurprisingly, the database is Oracle's.
But there is more. A common design is for the server to incorporate as much of the business logic as possible, via EJBs. There are extensive descriptions here on how to use the Oracle server for this. This server competes with those from JBoss and IBM's Websphere. Sadly, there is no mention at all of these ... Another recent hot topic is Web Services. These are separate from making dynamic web pages. Rather, it is meant to permit different programs on different computers talk to each other, and for designers to plug these together in some easy fashion. The book gives a short discussion on how Oracle's server can be used for this means. Skimpy. Not that Oracle is necessarily worse off than others who are offering Web Services. The entire field is nascent, and groping for a few big hits. Maybe, just maybe, you might be able to use Oracle's server in building one of these? |
|
Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, and MySQL by Wallace B. McClure, Gregory A. Beamer, IV John J. Croft | There are a number of great things about this book, from my perspective. For me, perhaps the best chapter was the one on the custom ADO.NET provider. Even if you do not want to create a custom provider (and honestly, I do not think I will), reading through that chapter helps explain how the various standard ...
In addition to covering ADO.NET 2.0 proper, the book covers specifically how you can use ADO.NET in very practical ways, interacting with SQL Server, as well as doing server side programming in SQL Server. Unlike one other reviewer, I appreciate the book covering these other areas. While the chapters on topics such as SQL Server server-side programming obviously do not cover all that a dedicated SQL Server book will, it covers most of what you need. I do understand how the term "Professional" in the title might lead a reader to expect one thing or another, but before I buy a book, I tend to read through it and determine if the publisher's idea of "Professional" matches my expectations. |
|
Oracle SQL Tuning & CBO Internals by Kimberly Floss | I was happy with the price and quality of this book. The book has detailed information about the internal workings of the cost based optimizer and the scriptgs were helpful. I could recommend this book to anyone who wants to learn about Oracle SQL internals of the optimzier. |
|
Oracle SQL High-Performance Tuning (2nd Edition) by Guy Harrison Highly recommended! | What a perfect book describing nearly all the method to optimize performance(e.g. index, cluster, explain plan trace, tuning table access and joins, using hints etc) for developers. It provides a clear and detail explanation and somtimes illustration on each optimization methods. The book was written in plain English ... |
|
Oracle Performance Troubleshooting: With Dictionary Internals, SQL & Tuning Scripts (Oracle In-Focus series) by Robin Schumacher, Donald K. Burleson | This book is another in the series of technical volumes published by "Rampant Techpress," published by Don Burleson. The purpose of this book by Robin Schumacher is to suggest and illustrate a robust, comprehensive performance tuning methodology. With this methodology in hand, the author then provide examples and ... |
|
Mastering Oracle SQL by Sanjay Mishra, Alan Beaulieu Highly recommended! | I like this book. It covers some advanced topics of Oracle SQL with some good examples. It doesn't cover everything of SQL statements and grammer, but it does teach you some techniques of writing good queries. It's hard to find similar book on the market. |
|
Oracle SQL: The Essential Reference by David C. Kreines | I have found this book to be an invaluable reference to SQL, PL/SQL, and SQL*Plus syntax and usage. The previous review by Kevin McCormick seems to entirely miss the point of an Essential Reference - it is not intended to teach SQL concepts, and the introduction clearly states this. The book is well organized with ... |
|
Oracle High Performance Tuning for 9i and 10g by Gavin JT Powell | This is an excellent book for the new someone new to performance tuning. It gives very clear and simple explanation to the approach to PT. It is a good mix of technical scripts and verbose. The author is not too chatty neither he is boring. He brings out complex ideas in a simple way without too much of mathematical ... |
|
Oracle SQL: Jumpstart with Examples by Gavin JT Powell, Carol McCullough-Dieter Highly recommended! | I found the Oracle SQL Jumpstart with Examples an excellent Oracle review and reference book.
The authors have provided valuable SQL and general database information. The book covers SQL and basic database structure and syntax, and provides simple and easy to understand examples which are useful for building complex database elements. |
|
Java Programming with Oracle JDBC by Donald Bales | This book is for Java developers who need to get the most out of using JDBC and Oracle (version 8.1.6). Choosing a specific database allows a lot more detail. Other JDBC books may skip database-dependent parts of the API; this book even gives code examples for the hard stuff. It is slow to read end-to-end, but "dipping... |
|
Easy Oracle SQL: Get Started Fast Writing SQL Reports with SQL*Plus (Easy Oracle) by John Garmany, Don Burleson | To people that are new to SQL, John Garmany proves that SQL does NOT stand for Scary Query Language. It is an excellent step-by-step primer to take the uninitiated from clueless to competent. What I think is most impressive, is Mr. Garmany's ability to quickly take the student from creating very simple queries to ... |
|
Oracle 9i: SQL Exam Cram 2 (Exam Cram 1Z0-007) (Exam Cram 2) by Gavin Powell | Better overall then Dawes and Thomas.
This guy writes with experience. Where Dawes and Thomas is mostly a reprint of Oracle Documentation. Better in these areas: - User setup - Single row functions and Group functions. Far more detail on topics. The Book comes with electronic exam, that DOES NOT REQUIRE the CD always be inserted in your computer!!! Negative: Software does not run on a Mac, you will need virtualization software, like virtual PC to run, but it works. |
|
Oracle Performance Tuning 101 by Gaja Krishna Vaidyanatha, Kirtikumar Deshpande, John A. Kostelac Highly recommended! | Gaja knows his stuff, he is the guru. Tuning 101 clearly defines a method to the madness of Oracle tuning. Dig into the wait events, figure out where and what the problem is. While tuning is a art, a scientific methodology can resolve even the most difficult problem. Great writing style, with a bit of humor thrown ... |
|
Oracle SQL Interactive Workbook (2nd Edition) by Alice Rischert | I teach college computer classes, although my BA & MA are in linguistics. The only computer course I've actually taken was a non-credit course in Oracle SQL. I was pretty satisfied with it.
I'm only in lab 2 of 16 in this book, and have already learned MANY new things! It's very well written, giving you a little, testing you a little, etc. I strongly recommend it. |
35 books listed. Updated: 24 Feb 2007 | ||
 |
 |