Oracle SQL Developer 2.1


Oracle SQL Developer 2.1
eBook: $32.99
Formats: PDF, PacktLib, ePub and Mobi formats
$23.09
save 30%!
Print + free eBook + free PacktLib access to the book: $87.98    Print cover: $54.99
$43.99
save 50%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Reviews
Support
Sample Chapters

[ PACKT CLASSIC ]

  • Install, configure, customize, and manage your SQL Developer environment
  • Includes the latest features to enhance productivity and simplify database development
  • Covers reporting, testing, and debugging concepts
  • Meet the new powerful Data Modeling tool – Oracle SQL Developer Data Modeler
  • Detailed code examples and screenshots for easy learning

Book Details

Language : English
Paperback : 496 pages [ 235mm x 191mm ]
Release Date : December 2009
ISBN : 1847196268
ISBN 13 : 9781847196262
Author(s) : Sue Harper
Topics and Technologies : All Books, Enterprise Products and Platforms, Oracle Database, Enterprise, Oracle
Sorry, the table of contents for this book is not yet available.

Sue Harper

Sue Harper was a senior school mathematics and science teacher by profession. It was this teaching qualification that opened the door to Oracle in South Africa, where Sue started as a SQL, PL/SQL, SQL Forms, and Reports instructor in 1992. Before long she'd added Oracle Designer to her repertoire and soon left for the UK, to join the Designer curriculum development team. Sue was a course writer and then product manager for Oracle Designer for many years, traveling extensively meeting customers and training Oracle staff and instructors. Sue was later product manager for Oracle JDeveloper working with database and modeling tools in that product. Sue is currently product manager for Oracle SQL Developer, SQL Developer Data Modeler, and SQL Developer Migrations. Based at home, Sue works with her team, scattered around the world and customers, running web-based training sessions or helping with individual queries. She frequently attends conferences where she presents SQL Developer material and works with customers on their queries.

Sue lives in West London, where she enjoys walking with her camera and her dog in the extensive local parks and further afield throughout the UK.

Code Downloads

Download the code and support files for this book.


Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

Oracle SQL Developer 2.1 +    Microsoft Exchange Server 2013 PowerShell Cookbook: Second Edition =
50% Off
the second eBook
Price for both: $47.10

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • Build complex queries based on a number of tables using visual Query Builder
  • Assess the health of your database, data structure of your application, and data in that application with built-in as well as user-defined reports
  • Create, compile, and debug PL/SQL code and explore available features to facilitate writing PL/SQL code
  • Integrate your SQL Developer with open source version control systems CVS and Subversion, which allow checking out of files from a repository, editing, and checking them back in
  • Enter and execute your SQL, PL/SQL, and SQL*Plus statements with the SQL Worksheet interface
  • Produce easily replicable scripts that copy and move data from one database instance to another, or from one schema to another
  • Create advanced database connections using a variety of connection and authentication types available for Oracle as well as non-Oracle databases
  • Create, review, and update database schema designs with SQL Developer Data Modeler
  • Augment your environment with features that are specific to your needs by extending your SQL Developer with XML structured user-defined extensions
  • Monitor and manage your Application Express applications by integrating with SQL Developer
  • Set up an easy and quick migration environment for your database schema by using the migration repository
  • Browse and review non-Oracle databases, before using the migration environment to migrate and consolidate databases on the Oracle platform

In Detail

As technology rapidly evolves, many developers are looking for valuable tools to assist them with their daily tasks. When dealing with databases, a clean, easy-to-navigate interface for working and browsing is essential. Oracle SQL Developer is a graphical user interface that makes life much easier by allowing you to browse database objects, run SQL statements and scripts, and create, edit, and debug PL/SQL statements in the most efficient way. It enhances productivity and simplifies your database development tasks. Although the SQL Developer journey looks simple and easy, there are many areas that can go undiscovered, leaving you just scratching the surface.

It’s easy to get started and master this powerful tool with this book to hand. It will provide you with in-depth details about all aspects of using SQL Developer to assist you in your day-to-day database tasks and activities. You will learn to utilize SQL Developer’s extensible environment to support your ongoing needs

This book offers detailed instructions for installing, configuring, and effectively using Oracle SQL Developer. You will learn how to utilize every feature of this development tool and make the most out of it. While none of the tasks are complex, the book progresses from the easy, most commonly used features, such as browsing objects and writing queries in the SQL Worksheet, to the more involved and possibly less frequently used features, such as Tuning and Testing SQL and PL/SQL, and adding User Extensions, and finally to those features used by a smaller more targeted audience, such as Migrations, Oracle APEX, and the Data Modeler. Throughout the book there are tips and suggestions gathered as a result of working with the current SQL Developer user base. This book will also show you how to assess the health of your database with built-in as well as customized reports.

By the end of the book you will be confident in making the best use of SQL Developer, and be able to set up and maintain a productive environment for quick and easy database development.

Use the powerful GUI to browse your database objects, run SQL statements and scripts, and create, edit, debug, and test PL/SQL code in a highly productive environment

Approach

Covering SQL Developer fundamentals as well more intermediate and advanced topics, this book uses in-depth explanation and detailed examples to help you get the most out of Oracle SQL Developer. The book has a modular structure, so that you can dip into any chapter that covers your current area of focus and get going.

Who this book is for

This book is for Oracle developers who want to ease their database development, and enhance their productivity using Oracle SQL Developer. You should have a programming knowledge of SQL and PL/SQL, and a general familiarity with Oracle database concepts.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software