Book Review: Oracle SQL Developer 2.1

For a long time, you have to rely on third-party tools for database development for the Oracle Database. All these tools have their market share and are good for their audience. When introduced in September 2005, Oracle SQL Developer started to take on this competition and shortly got a good market share. While gaining momentum more and more features have been added and deserve a book describing its use and features.

The Author

This book is written by Sue Harper, product manager for Oracle SQL Developer, SQL Developer Data Modeler, and SQL Developer Migrations.

The Book

The 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.

Recommendation

Although 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 Details

Title Oracle SQL Developer 2.1
Author Sue Harper
Paperback 496 pages
ISBN 13 978-1-847196-26-2
Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

This is my blog for things I found useful during my work as Senior Solution Architect for Identity Management and Service-oriented Architecture at Oracle. All text expressed on this blog is my own opinion and not related to my employer.

Search

Top Tags
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today