Oracle SQL Developer
Learn Database design, development,and administration using the feature-rich SQL Developer 4.1 interface
Published on 8. July 2025
344 pages
978-1-78217-471-4 (ISBN)
Description
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 DescriptionAt 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.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 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.
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 DescriptionAt 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.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 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.
All prices
More details
Edition
Digital original
Language
English
Place of publication
Birmingham
United Kingdom
Target group
Professional and scholarly
US School Grade: College Graduate Student
Edition type
Digital original
File size
34,34 MB
ISBN-13
978-1-78217-471-4 (9781782174714)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Persons
Narayanan Ajith :
Ajith Narayanan is the chief technology officer (CTO) of InfraStack-Labs in Bangalore, India, and has more than 11 years of work experience as an Oracle [apps] DBA and platform architect with expertise in infrastructure architecture, capacity planning, and performance tuning of medium to large e-business suite environments. He holds a postgraduate degree with PGDBA (finance) from Symbiosis, Pune, an M.S. (software systems) from BITS Pilani, a BE (electronics and communication) from Amrita Institute of Technology, and a diploma (computer technology) from Sree Narayana Guru Institute of Technology. He has worked in different technical positions as an Oracle DBA, APPS DBA, Oracle apps platform architect, and configuration management technical leader in companies such as GE, Dell, JP MorganChase, Oracle, and TCS. Ajith was at GE before joining InfraStack-Labs. He is also a regular speaker at national and international Oracle user group conferences such as SANGAM, NZOUG, DOAG, UKOUG, OTN APAC Tour, AIOUG Tech Days, and so on. His white papers have been published on the Oracle Technology Network in English, Portuguese, and Spanish. Ajith is currently serving the ORACLERACSIG board as the web seminar chair (from October 2015), and has previously served the board as the website chair (September 2011 to September 2013).Harper Susan :
Sue Harper was a senior school mathematics and science teacher by profession. It was this teaching qualification that opened the door to Oracle in South Africa, where Sue started as a SQL, PL/SQL, SQL Forms, and Reports instructor in 1992. Before long she'd added Oracle Designer to her repertoire and soon left for the UK, to join the Designer curriculum development team. Sue was a course writer and then product manager for Oracle Designer for many years, traveling extensively meeting customers and training Oracle staff and instructors. Sue was later product manager for Oracle JDeveloper working with database and modeling tools in that product. Sue is currently product manager for Oracle SQL Developer, SQL Developer Data Modeler, and SQL Developer Migrations. Based at home, Sue works with her team, scattered around the world and customers, running web-based training sessions or helping with individual queries. She frequently attends conferences where she presents SQL Developer material and works with customers on their queries. Sue lives in West London, where she enjoys walking with her camera and her dog in the extensive local parks and further afield throughout the UK.
Ajith Narayanan is the chief technology officer (CTO) of InfraStack-Labs in Bangalore, India, and has more than 11 years of work experience as an Oracle [apps] DBA and platform architect with expertise in infrastructure architecture, capacity planning, and performance tuning of medium to large e-business suite environments. He holds a postgraduate degree with PGDBA (finance) from Symbiosis, Pune, an M.S. (software systems) from BITS Pilani, a BE (electronics and communication) from Amrita Institute of Technology, and a diploma (computer technology) from Sree Narayana Guru Institute of Technology. He has worked in different technical positions as an Oracle DBA, APPS DBA, Oracle apps platform architect, and configuration management technical leader in companies such as GE, Dell, JP MorganChase, Oracle, and TCS. Ajith was at GE before joining InfraStack-Labs. He is also a regular speaker at national and international Oracle user group conferences such as SANGAM, NZOUG, DOAG, UKOUG, OTN APAC Tour, AIOUG Tech Days, and so on. His white papers have been published on the Oracle Technology Network in English, Portuguese, and Spanish. Ajith is currently serving the ORACLERACSIG board as the web seminar chair (from October 2015), and has previously served the board as the website chair (September 2011 to September 2013).Harper Susan :
Sue Harper was a senior school mathematics and science teacher by profession. It was this teaching qualification that opened the door to Oracle in South Africa, where Sue started as a SQL, PL/SQL, SQL Forms, and Reports instructor in 1992. Before long she'd added Oracle Designer to her repertoire and soon left for the UK, to join the Designer curriculum development team. Sue was a course writer and then product manager for Oracle Designer for many years, traveling extensively meeting customers and training Oracle staff and instructors. Sue was later product manager for Oracle JDeveloper working with database and modeling tools in that product. Sue is currently product manager for Oracle SQL Developer, SQL Developer Data Modeler, and SQL Developer Migrations. Based at home, Sue works with her team, scattered around the world and customers, running web-based training sessions or helping with individual queries. She frequently attends conferences where she presents SQL Developer material and works with customers on their queries. Sue lives in West London, where she enjoys walking with her camera and her dog in the extensive local parks and further afield throughout the UK.
Content
Table of Contents
Getting Started with SQL Developer
Database Connections and SQL Worksheets
The Power of SQL Reports
Working with SQL, PL/SQL, and Tuning Tools
SQL Developer for DBA
SQL Developer Accessibility Information
Importing, Exporting, and Working with Data
Database Connections and JDBC Drivers
SQL Developer Data Modeler
Extending SQL Developer
Working with Application Express
Working with SQL Developer Migrations
Oracle Data Miner 4.1
REST Data Services and REST Development
Getting Started with SQL Developer
Database Connections and SQL Worksheets
The Power of SQL Reports
Working with SQL, PL/SQL, and Tuning Tools
SQL Developer for DBA
SQL Developer Accessibility Information
Importing, Exporting, and Working with Data
Database Connections and JDBC Drivers
SQL Developer Data Modeler
Extending SQL Developer
Working with Application Express
Working with SQL Developer Migrations
Oracle Data Miner 4.1
REST Data Services and REST Development
