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. Fl3'