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

Programming 16-Bit PIC Microcontrollers in C: Learning to Fly the PIC 24 (Embedded Technology)
Programming 16-Bit PIC Microcontrollers in C: Learning to Fly the PIC 24 (Embedded Technology)
A Microchip insider tells all on the newest, most powerful PICs ever!

FREE CD-ROM includes source code in C, the Microchip C30 compiler, and MPLAB SIM software

Includes handy checklists to help readers perform the most common programming and debugging tasks

The new 16-bit PIC24 chip provides embedded programmers
...
SHARKS in the MOAT: How to Create Truly Secure Software
SHARKS in the MOAT: How to Create Truly Secure Software
Believe it or not, there is a striking similarity between medieval castle design and how we protect networks and data in the 21st century. By examining how our ancestors fought off invading armies, it becomes much easier to understand the latest strategies for keeping hackers at-bay. This book is designed for anyone who wants to understand how...
Practicing Software Engineering in the 21st Century
Practicing Software Engineering in the 21st Century
This technological manual explores how software engineering principles can be used in tandem with software development tools to produce economical and reliable software that is faster and more accurate. Tools and techniques provided include the Unified Process for GIS application development, service-based approaches to business and information...

Coding Interviews: Questions, Analysis & Solutions
Coding Interviews: Questions, Analysis & Solutions

This book is about coding interview question of software and Internet companies. It covers five key factors which determine performance of candidates: (1) the basics of programming languages, data structures and algorithms, (2) approaches to writing code with high quality, (3) tips to solve difficult problems, (4) methods to optimize code,...

You Don't Know JS: Async & Performance
You Don't Know JS: Async & Performance

No matter how much experience you have with JavaScript, odds are you don’t fully understand the language. As part of the "You Don’t Know JS" series, this concise yet in-depth guide focuses on new asynchronous features and performance techniques—including Promises, generators, and Web Workers—that let...

Design Patterns (Wordware Applications Library)
Design Patterns (Wordware Applications Library)
Design patterns books have been gaining popularity since languages like Java and C++ first became widely used. Since Microsoft released its first truly object-oriented language, .NET, software designers from an even broader range of business and programming spheres have been looking for ways to refine and write better code. Many have turned toward...
©2019 LearnIT (support@pdfchm.net) - Privacy Policy