Book Review: Oracle SQL Developer 2.1
By Olaf Heimburger on Jun 04, 2010
The AuthorThis book is written by Sue Harper, product manager for Oracle SQL Developer, SQL Developer Data Modeler, and SQL Developer Migrations.
The BookThe book has thirteen chapters. Personally, I understand the first ten chapters as the first part of the book. These chapters cover everything from installing, starting, and using SQL Developer. Surely the part of using SQL Developer is more interesting. Chapters 2, 3, and 4 cover working with the database by browsing the existing data within the tables, through the SQL workshop, or building graphical reports based on the data within the database. These chapters are primarily for the user who just need work with the data.
Next come the chapters for developing PL/SQL and tuning the code or the select statements, working with Source Code Management tools like Subversion (included by default). Importing and Exporting Data finally closes this "part".
The last four chapters cover various advanced topics like working with JDBC drivers to connect to third-party databases, or using proxy authentication to connect to the database; using the data modeler, extending SQL Developer, Working with Application Express, and finally doing migrations with SQL Developer.
RecommendationAlthough this book covers quite a lot of topics implemented by SQL Developer, I missed a chapter about the unit testing functionality for PL/SQL that comes with SQL Developer. One the other hand, the whole book provides valueable input for my daily work, especially when it comes to some dark corners (ie things I haven't used so far) of SQL Developer. The chapter Extending SQL Developer is pretty vague and really deserves a complete book on Extending SQL Developer and JDeveloper.
The DetailsTitle Oracle SQL Developer 2.1
Author Sue Harper
Paperback 496 pages
ISBN 13 978-1-847196-26-2