skip to content
Oracle SQL Developer. Preview this item
ClosePreview this item
Checking...

Oracle SQL Developer.

Author: Ajith Narayanan
Publisher: Birmingham : Packt Publishing, Limited Jan. 2016.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Summary:
Learn Database design, development, and administration using the feature-rich SQL Developer 4.1 interfaceAbout 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  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Databases; Computers
Additional Physical Format: Erscheint auch als:
Narayanan, Ajith. Oracle SQL Developer
Druck-Ausgabe
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Ajith Narayanan
ISBN: 9781785281273 1785281275 9781782174714 1782174710
OCLC Number: 951673113
Description: 1 online resource
Contents: Cover --
Copyright --
Credits --
About the Author --
About the Reviewer --
www.PacktPub.com --
Table of Contents --
Preface --
Chapter 1: Getting Started with SQL Developer 4.1 --
Preparing your environment --
Finding and downloading the software --
Downloading and installing the Java Development Kit --
Installing and starting SQL Developer --
Working with different platforms --
Migrating settings from a previous release --
Maintaining your environment --
Verifying the current release --
Using Check for Updates --
Managing the system folder and other files --
Alternative installations of SQL Developer --
Oracle JDeveloper --
Oracle Database 12c --
Troubleshooting --
A quick overview --
Sample schemas --
Creating your first connection --
Using basic commands in the SQL Worksheet --
Browsing and updating data --
Running reports --
Navigating around SQL Developer --
Managing SQL Developer windows --
Tiling windows --
Splitting documents --
Maximizing detail --
Resetting the window layout --
Database certification matrix (Oracle & Third-Party) --
Finding more help --
Summary --
Chapter 2: Database Connections and SQL Worksheet --
Working with the Connections navigator --
Opening connections --
Working with database objects --
Display editors --
General display editors --
Working with the display editors --
Using the SQL display editor --
Working with the data grids --
Reviewing other database object nodes --
Working with PL/SQL objects --
Accessing objects you don't own --
Other users --
Synonyms and filters --
Recycle Bin --
Creating new database objects --
Editing database objects --
putting context menus to work --
Editing objects --
Script Runner/Running scripts --
Execution plan --
Autotrace pane --
DBMS Output pane --
OWA output pane --
Query Builder --
Command-line interface for SQL formatting --
SQL Worksheet "hints" for formatting output. Database configuration --
initialization parameters --
Automatic undo management --
Current database properties --
Restore points --
Data Pump --
Export Jobs --
Import Jobs --
Performance --
Snapshots (filtered) --
Baselines --
Baseline templates --
Automatic Database Diagnostic Monitor (ADDM) --
ASH Report Viewer --
AWR --
RMAN Backup/Recovery --
Backup jobs --
Backup sets --
Image copies --
RMAN settings --
Scheduled RMAN actions --
Resource manager --
Consumer group mappings --
Consumer groups --
Plans --
Settings --
Statistics --
Scheduler --
Global Attributes --
Job Classes --
External Destinations --
Security --
Audit Settings --
Profiles --
Roles --
Users --
Storage --
Archive Logs --
Control Files --
Datafiles --
Redo Log Groups --
Rollback Segments --
Tablespaces --
Temporary Tablespace Groups --
Summary --
Chapter 6: SQL Developer Accessibility --
Screen reader readability --
Keyboard access --
Font and color choices --
No audio-only feedback --
Screen magnifier usability --
Change the editor or tabbed view of a file --
Read text in a multi-line edit field --
Read the line number in the source editor --
Customize the accelerators keys --
The look and feel of SQL Developer --
Customize syntax highlighting --
Display line numbers in Code Editor --
Timing for completion insight --
Specify the columns in the Debugger --
Summary --
Chapter 7: Importing, Exporting, and Working with Data --
Exporting data --
Exporting instance data --
Exporting table data --
Setting up the export file --
Exporting SQL DML --
Exporting to HTML --
Supporting export for SQL*Loader --
Exporting to Microsoft Excel --
Exporting to XML --
Exporting DDL (Metadata) --
Exporting table DDL --
Selecting multiple tables for DDL export --
Using the Database Export wizard to export DDL and data --
Starting the export wizard --
Selecting objects for generation. Specifying objects --
Running the script --
Importing data --
Importing data from SQL script files --
Importing data from XLS and CSV files --
Creating a table on XLS import --
Summary --
Chapter 8: Database Connections and JDBC Drivers --
Working with Oracle connections --
Using alternative Oracle connection types --
Reviewing the Basic connection --
Accessing the tnsnames.ora file --
Accessing LDAP server details --
Creating advanced connections with JDBC URLs --
Connecting to Oracle TimesTen --
Reviewing JDBC drivers --
Oracle JDBC thin driver (Type IV driver) --
Oracle JDBC thick driver (Type II driver) --
SQL Developer's shipped drivers --
Using different authentication methods --
Using proxy authentication --
Using the Kerberos authentication --
Creating non-Oracle database connections --
Setting up JDBC drivers --
Using Check for Updates --
Manually adding JDBC drivers --
Summary --
Chapter 9: Introducing SQL Developer Data Modeler --
Oracle SQL Developer Data Modeler --
Feature overview --
Integrated architecture --
Getting started --
Oracle clients and JDBC drivers --
Creating your first models --
Importing from the Data Dictionary --
Creating a database connection --
Using the Import Wizard --
Reviewing the results --
Working with diagrams and their components --
Formatting the elements --
Controlling the layout --
Adjusting the level of detail displayed --
Adjusting the width and height across the model --
Analysis, design, and generation --
The flow of work --
Starting with analysis (top down) --
Importing existing models (bottom up) --
Building the relational model --
Logical models --
Creating constraints, domains, and setting default values --
Working with domains --
Creating domains --
Introducing forward and reverse engineering --
Forward engineering --
Reverse engineering models --
Creating relational models. Building the physical model --
Importing a schema from the Data Dictionary --
Generating the DDL --
Creating a new model --
Summary --
Chapter 10: Extending SQL Developer --
Introducing extensibility --
Extensibility in SQL Developer --
Who builds extensions? --
Why extend? --
SQL Developer XML extension types --
Adding an XML extension --
Sharing user-defined reports --
Adding display editors --
Examples of display editors --
Building the XML file for a display editor --
Working with context menus --
Adding a context menu to the connections menus --
Passing parameters --
Creating a utility using context menus --
Including the user-defined extension for context menus --
Adding new nodes to the Connections navigator --
Including user-defined extensions for a navigator node --
Adding a new tree to the navigator --
Working with extensions --
Controlling existing extensions --
Adding in new Java extensions --
Removing extensions --
Sharing extensions --
Summary --
Chapter 11: Working with Application Express --
Setting the scene --
Setting up Application Express --
Creating a workspace and database schema --
Creating an Application Express user --
Browsing applications in SQL Developer --
Creating a connection in SQL Developer --
Browsing and working with schema objects --
Browsing the applications --
Mapping objects from SQL Developer to Application Express --
Tuning SQL and PL/SQL code using SQL Developer --
Working with Region Source SQL --
Tuning with Explain Plan --
Working with PL/SQL code --
Replacing the anonymous block in Application Express --
Managing applications in SQL Developer --
Importing applications --
Modifying applications --
Deploying applications --
Controlling services --
Reporting on applications using SQL Developer --
Summary --
Chapter 12: Working with SQL Developer Migrations --
Introducing SQL Developer Migrations.

Abstract:

Learn Database design, development, and administration using the feature-rich SQL Developer 4.1 interfaceAbout 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] DBAWho This Book Is ForThis 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 themIn DetailAt 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 approachThis 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.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.

Similar Items

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/951673113> # Oracle SQL Developer.
    a schema:Book, schema:CreativeWork, schema:MediaObject ;
    library:oclcnum "951673113" ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/2906726713#Place/birmingham> ; # Birmingham
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/enk> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/2906726713#Topic/database_design> ; # Database design
    schema:about <http://experiment.worldcat.org/entity/work/data/2906726713#CreativeWork/oracle_computer_file> ; # Oracle (Computer file)
    schema:author <http://experiment.worldcat.org/entity/work/data/2906726713#Person/narayanan_ajith> ; # Ajith Narayanan
    schema:bookFormat schema:EBook ;
    schema:datePublished "Jan. 2016" ;
    schema:description "Learn Database design, development, and administration using the feature-rich SQL Developer 4.1 interfaceAbout 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] DBAWho This Book Is ForThis 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 themIn DetailAt 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 approachThis 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."@en ;
    schema:description "Cover -- Copyright -- Credits -- About the Author -- About the Reviewer -- www.PacktPub.com -- Table of Contents -- Preface -- Chapter 1: Getting Started with SQL Developer 4.1 -- Preparing your environment -- Finding and downloading the software -- Downloading and installing the Java Development Kit -- Installing and starting SQL Developer -- Working with different platforms -- Migrating settings from a previous release -- Maintaining your environment -- Verifying the current release -- Using Check for Updates -- Managing the system folder and other files -- Alternative installations of SQL Developer -- Oracle JDeveloper -- Oracle Database 12c -- Troubleshooting -- A quick overview -- Sample schemas -- Creating your first connection -- Using basic commands in the SQL Worksheet -- Browsing and updating data -- Running reports -- Navigating around SQL Developer -- Managing SQL Developer windows -- Tiling windows -- Splitting documents -- Maximizing detail -- Resetting the window layout -- Database certification matrix (Oracle & Third-Party) -- Finding more help -- Summary -- Chapter 2: Database Connections and SQL Worksheet -- Working with the Connections navigator -- Opening connections -- Working with database objects -- Display editors -- General display editors -- Working with the display editors -- Using the SQL display editor -- Working with the data grids -- Reviewing other database object nodes -- Working with PL/SQL objects -- Accessing objects you don't own -- Other users -- Synonyms and filters -- Recycle Bin -- Creating new database objects -- Editing database objects -- putting context menus to work -- Editing objects -- Script Runner/Running scripts -- Execution plan -- Autotrace pane -- DBMS Output pane -- OWA output pane -- Query Builder -- Command-line interface for SQL formatting -- SQL Worksheet "hints" for formatting output."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/2906726713> ;
    schema:genre "Databases; Computers"@en ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <http://worldcat.org/entity/work/data/2906726713#CreativeWork/narayanan_ajith_oracle_sql_developer> ;
    schema:name "Oracle SQL Developer."@en ;
    schema:productID "951673113" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/951673113#PublicationEvent/birmingham_packt_publishing_limitedjan_2016> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/2906726713#Agent/packt_publishing_limited> ; # Packt Publishing, Limited
    schema:url <http://proquest.safaribooksonline.com/9781785281273> ;
    schema:url <http://www.totalboox.com/book/id-711760529931186311> ;
    schema:url <https://proquest.safaribooksonline.com/9781785281273> ;
    schema:url <https://ebookcentral.proquest.com/lib/liverpool/detail.action?docID=4520746> ;
    schema:url <https://ezproxy.spl.org/login?url=https://proquest.safaribooksonline.com/9781785281273> ;
    schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=4520746> ;
    schema:url <http://VH7QX3XE2P.search.serialssolutions.com/?V=1.0&L=VH7QX3XE2P&S=JCs&C=TC0001831389&T=marc&tab=BOOKS> ;
    schema:url <http://public.ebookcentral.proquest.com/choice/publicfullrecord.aspx?p=4520746> ;
    schema:url <http://cdn.totalboox.com/static/covers/PT/9e0ae6e4fb13087-b.jpg> ;
    schema:workExample <http://worldcat.org/isbn/9781782174714> ;
    schema:workExample <http://worldcat.org/isbn/9781785281273> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/951673113> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/2906726713#Agent/packt_publishing_limited> # Packt Publishing, Limited
    a bgn:Agent ;
    schema:name "Packt Publishing, Limited" ;
    .

<http://experiment.worldcat.org/entity/work/data/2906726713#CreativeWork/oracle_computer_file> # Oracle (Computer file)
    a schema:CreativeWork ;
    schema:name "Oracle (Computer file)" ;
    .

<http://experiment.worldcat.org/entity/work/data/2906726713#Person/narayanan_ajith> # Ajith Narayanan
    a schema:Person ;
    schema:familyName "Narayanan" ;
    schema:givenName "Ajith" ;
    schema:name "Ajith Narayanan" ;
    .

<http://worldcat.org/entity/work/data/2906726713#CreativeWork/narayanan_ajith_oracle_sql_developer>
    a schema:CreativeWork ;
    rdfs:label "Narayanan, Ajith. Oracle SQL Developer" ;
    schema:description "Erscheint auch als:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/951673113> ; # Oracle SQL Developer.
    .

<http://worldcat.org/isbn/9781782174714>
    a schema:ProductModel ;
    schema:isbn "1782174710" ;
    schema:isbn "9781782174714" ;
    .

<http://worldcat.org/isbn/9781785281273>
    a schema:ProductModel ;
    schema:isbn "1785281275" ;
    schema:isbn "9781785281273" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.