Database design and development using the interface, feature-rich user-extensible strong Install, configure, customize, and manage your SQL Developer environmentIncludes latest features to increase productivity and simplify database developmentCovers reporting, testing, and debugging new strong conceptsMeet Data Modeling tool - Oracle SQL Developer Data ModelerDetailed sample code and screenshots for easy learning In Detail As technology develops rapidly, many developers seek modern tools to assist them in the tasks of everyday. Oracle SQL Developer is a graphical user interface that makes your life easier by allowing you to browse database objects, run SQL statements and scripts, and create, edit, and debug PL / SQL statements in the most efficient. You will learn to use SQL Developer extensible environment to support your ongoing needs. This book offers detailed instructions for installation, configuration, and effectively using Oracle SQL Developer. While there are no complex tasks, the book runs from, the features easily the most frequently used, such as object browsing and query written in SQL Worksheet, to be more involved and may be less frequently used features, such as tuning and testing SQL and PL / SQL, and User Extensions added, and finally to those features used by a smaller audience is more targeted, such as Migration, Oracle APEX, and Data Modeler. This book will show you how to assess the health of your database with built-ins and special reports. At the end of this book you will be confident in making the best use of SQL Developer, and able to manage and maintain a productive environment for the development of the database quickly and easily. What you will learn from this book? Building a complex question based on a number of tables using Query BuilderAssess visual health of your database, your application data structures, and data in applications with built-in and user-defined reportsCreate, compile, and debug PL / SQL code and explore some useful features that are available for makes it easy to write PL / SQL Developer with SQL codeIntegrate your open source version control systems CVS and Subversion, which allows checking a file from an edit, repository, and check them back inEnter and execute your SQL, PL / SQL, and SQL * Plus reports with Spreadsheet Work interfaceProduce easily replicated SQL scripts that copy and move data from one database to another instance, or from one scheme to anotherCreate sophisticated database connection by using different types of connection and authentication are available for Oracle and non-Oracle databasesCreate, review, and update design a database schema with SQL Developer Data ModelerAugment your environment with features that are specific to your needs by extending SQL Developer with XML extensionsMonitor your user defined structured and manage applications by integrating with SQL Express DeveloperSet an easy and fast migration environment for your database schema with Browse the repository using the database migration and reviewing non-Oracle, before use of environmental migration to migrate and consolidate the database on Oracle platform Approach Covering the fundamentals SQL Developer as well as more intermediate and advanced topics, this book uses in-depth explanations and detailed examples to help you get the most out of Oracle SQL Developer. Who is this book written for? This book is for developers who want to ease the development of Oracle databases, and increase productivity by using Oracle SQL Developer. You must have programming knowledge of SQL and PL / SQL, and have a general familiarity with the concept of an Oracle database.