Oracle SQL Developer（Paperback）

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

About This Book

• 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

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.

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

In Detail

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.

Style and approach

This book follows a step-by-step approach and is in a conversational and easy-to-follow style. Screenshots , and detailed explanations of the basic and advanced features of SQL Developer 4.1 that will make your work and life easy.

學習使用功能豐富的SQL Developer 4.1介面進行資料庫設計、開發和管理

關於本書
- 探索所有對Oracle資料庫開發人員、架構師和管理員有用的SQL Developer 4.1功能
- 了解這個來自Oracle的免費工具如何在多年間演變成一個完整的工具，為Oracle和第三方資料庫使用者提供便利
- 作者Ajith Narayanan擁有10年以上的Oracle [APPS] DBA工作經驗

本書適合對資料庫管理負責的Oracle開發人員。您需要具備SQL和PL/SQL的程式知識，並熟悉基本的Oracle資料庫概念。

您將學到什麼
- 安裝並瀏覽SQL Developer 4.1中引入的所有高級功能
- 瀏覽、創建、編輯和刪除（刪除）資料庫物件
- 使用SQL工作表執行SQL語句和腳本，編輯和調試PL/SQL代碼，操作和匯出（卸載）數據
- 執行所有與DBA相關的活動，如導入/導出、調優和分析資料庫性能問題
- 使用資料模型工具快速分析、創建和編輯數據模型
- 通過探索APEX相關頁面，啟用和使用RESTful服務來擴展SQL Developer的功能
- 使用現有報表和自定義腳本創建新的自定義報表
- 瞭解如何連接到第三方資料庫並與其順利工作

詳細內容
在某些情況下，DBA需要在工作中支援數百個資料庫。在這種情況下，使用像putty這樣的命令行工具會增加困難，而SQL Developer通過提供配備功能的圖形用戶界面，可以增強用戶體驗並提高效率，從而使開發人員、DBA或DB架構師的工作更輕鬆。DBA面板、報表、資料模型工具和資料挖掘工具等功能只是其豐富功能的幾個例子，而其對APEX、REST服務、timesten和第三方資料庫驅動程式的支援則展示了其可擴展性。

無論您是資料庫新手還是經驗豐富的資料庫專家，本書都將幫助您了解資料庫結構和不同類型的物件，以有效地組織企業數據。本書以增量方式介紹SQL Developer 4.1工具的功能，從安裝、建立資料庫連接到使用不同面板。通過按照每章的步驟進行順序操作，您將迅速掌握SQL Developer 4.1。

風格和方法
本書採用逐步指南的方式，以對話式和易於理解的風格撰寫。詳細解釋SQL Developer 4.1的基本和高級功能，並提供截圖，使您的工作和生活更輕鬆。