Skip to main content
Have a personal or library account? Click to login
Oracle SQL Developer Cover

Oracle SQL Developer

Learn Database design, development,and administration using the feature-rich SQL Developer 4.1 interface

Publisher:Packt Publishing Limited
By:  and    
Paid access
|Jul 2025
Product purchase options
This title is not yet available for download
Description

Learn Database design, development,and administration using the feature-rich SQL Developer 4.1 interface

Key Features

  • Explore all the SQL Developer 4.1 features useful for Oracle database developers, architects, and administrators
  • Understand how this free tool from Oracle has evolved over the years and has become a complete tool that makes life easy for Oracle and third-party database users
  • The author, Ajith Narayanan, has a total of 10+ years of work experience as an Oracle [APPS] DBA

Book Description

At times, DBAs support 100s of databases at work. In such scenarios, using a command-line tool like putty adds to the difficulty, while SQL Developer makes the life of a developer, DBA, or DB architect easier by providing a graphical user interface equipped with features that can bolster and enhance the user experience and boost efficiency. Features such as DBA panel, Reports, Data Modeler, and Data Miner are just a few examples of its rich features, and its support for APEX, REST Services, timesten, and third-party database drivers demonstrate its extensibility.

You may be a newbie to databases or a seasoned database expert, either way this book will help you understand the database structure and the different types of objects that organize enterprise data in an efficient manner. This book introduces the features of the SQL Developer 4.1 tool in an incremental fashion, starting with installing them, making the database connections, and using the different panels. By sequentially walking through the steps in each chapter, you will quickly master SQL Developer 4.1.

What you will learn

  • Install and navigate through all the advanced features of SQL Developer that were introduced in version 4.1
  • Browse, create, edit, and delete (drop) database objects
  • Use the SQL worksheet to run SQL statements and scripts, edit and debug PL/SQL code, manipulate and export (unload) data
  • Carry out all DBA-related activities such as exporting/importing, tuning, and analyzing database performance issues
  • Quickly analyze, create, and edit the data model using data modeler
  • Extend the SQL developer capabilities by exploring the APEX related pages, enabling and working with RESTful services.
  • Use the available reports and create new custom reports with custom scripts
  • Grasp how to connect to third-party databases and work smoothly with them

Who this book is for

This book is intended for Oracle developers who are responsible for database management. You are expected to have programming knowledge of SQL and PL/SQL, and must be familiar with basic Oracle database concepts.

Table of Contents

  1. Getting Started with SQL Developer
  2. Database Connections and SQL Worksheets
  3. The Power of SQL Reports
  4. Working with SQL, PL/SQL, and Tuning Tools
  5. SQL Developer for DBA
  6. SQL Developer Accessibility Information
  7. Importing, Exporting, and Working with Data
  8. Database Connections and JDBC Drivers
  9. SQL Developer Data Modeler
  10. Extending SQL Developer
  11. Working with Application Express
  12. Working with SQL Developer Migrations
  13. Oracle Data Miner 4.1
  14. REST Data Services and REST Development
PDF ISBN: 978-1-78217-471-4
Publisher: Packt Publishing Limited
Copyright owner: © 2016 Packt Publishing Limited
Publication date: 2025
Language: English
Pages: 344
Related subjects:
Computer sciences,
Computer sciences, other
BISAC subjects:
COM021000,
COM021040,
COM082000
Thema subjects:
UN,
UND,
UB

People also read