Oracle SQL Developer

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

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.