Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Oracle SQL Developer

Buy
Oracle SQL Developer, 9781785281273 (1785281275), Packt Publishing, 2016

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. 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 approach

This 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.

(HTML tags aren't allowed.)

Aix and Linux Interoperabilty
Aix and Linux Interoperabilty
This IBMR Redbook discusses interoperability in terms of UNIX to UNIX cross platform data sharing and user/system management. This redbook also demonstrates the similarities and differences between the AIXR and Linux operating systems.

This redbook is intended to help IT specialists who have AIX systems and Linux systems in their
...
Dynamic Behavior of Materials, Volume 1: Proceedings of the 2018 Annual Conference on Experimental and Applied Mechanics (Conference Proceedings of the Society for Experimental Mechanics Series)
Dynamic Behavior of Materials, Volume 1: Proceedings of the 2018 Annual Conference on Experimental and Applied Mechanics (Conference Proceedings of the Society for Experimental Mechanics Series)
Dynamic Behavior of Materials, Volume 1 of the Proceedings of the 2018 SEM Annual Conference & Exposition on Experimental and Applied Mechanics, the first volume of eight from the Conference, brings together contributions to this important area of research and engineering.  The collection presents early findings and...
FPGA Design: Best Practices for Team-based Design
FPGA Design: Best Practices for Team-based Design

In August of 2006, an engineering VP from one of Altera’s customers approached Misha Burich, VP of Engineering at Altera, asking for help in reliably being able to predict the cost, schedule and quality of system designs reliant on FPGA designs.

At this time, I was responsible for defining the design flow requirements for...


Joe Celko's Trees and Hierarchies in SQL for Smarties
Joe Celko's Trees and Hierarchies in SQL for Smarties
In my book SQL For Smarties 2nd edition (Morgan-Kaufmann, 2000),
I wrote a chapter on a programming technique for representing trees and
hierarchies in SQL as nested sets. This technique has become popular enough
that I have spent almost every month since SQL For Smarties was released
explaining the technique in Newsgroups and
...
Elements of Distributed Algorithms: Modeling and Analysis with Petri Nets
Elements of Distributed Algorithms: Modeling and Analysis with Petri Nets

Distributed Computing is rapidly becoming the principal computing paradigm in diverse areas of computing, communication, and control. Processor clusters, local and wide area networks, and the information highway evolved a new kind of problems which can be solved with distributed algorithms. In this textbook a variety of distributed algorithms...

Global Mobile : Connecting without walls, wires, or borders
Global Mobile : Connecting without walls, wires, or borders

With the proliferation of Wi-Fi hotspots and advances in mobile-phone technology, there aren't many excuses today for not being in contact with your friends, family and business associates when you travel. Using just your laptop computer and cell phone, you can stay connected from all around the globe. But not so fastdo you...

©2020 LearnIT (support@pdfchm.net) - Privacy Policy