Oracle SQL developer 2.1 : database design and development using this feature-rich, powerful, user-extensible interface

This book is written using a practical approach that guides you through different practical scenarios. It provides a brief introduction to the topics; this way you can quickly get to know the main features, start being productive with the tool, and grow with it at a fast pace. You won't have to spend too much time getting to the basics of the tool and can immediately progress towards the advanced tips. Using this practical approach you don't have to spend valuable time trying to decipher arid reference manuals; you can easily set up the practical scenarios, and try to follow up the presentations. The images used in the book come from real scenarios, and the output is always explained so you can easily interpret what is being displayed on the screen after issuing the commands. This book is aimed at all Oracle professionals who interact with the database through the data and database utilities and are willing to optimize their interaction with it. Entry-level users will get acquainted with the best practices to get their job done in a timely and efficient manner. Advanced users will find useful tips and How-Tos that will help them focus on getting the most out of the database utilities and fine-tune batch processing.

In Detail

The hot new data analysis trends involve business intelligence and analytics. The technology that supports business intelligence and analytics better than anything else is today's multidimensional OLAP technology - and there is none better than Oracle Essbase! Although storing data in a cube and developing analytical applications leaves many people grasping for understanding, especially if their experience is with relational databases, embracing OLAP technology will pay big dividends in the long run.

It's easy to develop multidimensional analytic OLAP solutions when you have got this Oracle Essbase book to hand. It is a step-by-step guide to timeless Essbase fundamentals, which takes you from a basic software installation through to launching a fully functioning Essbase database cube.

This book will guide you through every stage of installing Oracle's Essbase software on your analytic server, the Essbase Administration Services client, and the client software itself. You will learn, in easy-to-understand language, the concepts of multidimensional database technology as you are taken step by step through building an actual Essbase application complete with database, database calculation scripts, and database report scripts.

Once you have your system built and functional, the next course of instruction covers the available automation features included in your Essbase software package and how to use them. These chapters alone are worth the price of admission!As an IT professional you quite rightly have a desire to understand multidimensional OLAP - this book gives you that understanding. Should you wish to embark on an exciting career as an Essbase developer/administrator, this book provides a fantastic foundation from which to grow.

Best of all, this book is filled with the tips and tricks that you can only get from many years and countless hours spent playing with Essbase. You get them all in just the time it takes you to complete this book.

A complete step-by-step guide covering timeless Essbase fundamentals to gain an immediate understanding of multidimensional database technology

Approach

This book uses a practical step-by-step approach with the next chapter always building on the knowledge foundation created by the previous chapter.

Understanding and really grasping the multidimensional concept is difficult enough without a lot of confusing jargon thrown in. This book speaks to the reader in plain English with plenty of easy-to-follow examples. You will create, build, and maintain data for a fictional automobile company.

Who this book is for

This book is primarily for the IT professional who has a good understanding of IT principles and processes but is a multidimensional OLAP novice. Experienced OLAP professionals will also gain insight from this book.

Simply put, if you are in the IT field and wish to gain a functional level of knowledge in the world of Oracle Essbase, whether it be for a developer role or a PM or BA role, this is the book you need.

In Detail

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.

Book Reviews

hemantoracledba.blogspot.comI have being reading the "Oracle 10g/11g Data and Database Management Utilities" eBook.I appreciate the chapters on SQL Loader,External Tables,RMAN,Session Management (locking and waiting for locks, killing sessions, resource manager, ASH, even Service Registration) {never before have I seen all these topics put together in a Chapter....................} - Hemant Chitale

Ask AnanthaFor a long time, there has been a demand for technical details of what a database administrator deals in his day-to-day life and this book addresses to this need. The book explains in detail the various tools the DBAs would use and then discusses the feature enhancements done in 11g. Also examples constitute a sizable portion of the book which are nice to have in a book of this magnitude.In short this book deserves its place in your custody and will prove to be best in times of database administration activities -Anantha Narayanan

Approach

This book is written using a practical approach that guides you through different practical scenarios. It provides a brief introduction to the topics; this way you can quickly get to know the main features, start being productive with the tool, and grow with it at a fast pace. You won't have to spend too much time getting to the basics of the tool and can immediately progress towards the advanced tips.

Using this practical approach you don't have to spend valuable time trying to decipher arid reference manuals; you can easily set up the practical scenarios, and try to follow up the presentations. The images used in the book come from real scenarios, and the output is always explained so you can easily interpret what is being displayed on the screen after issuing the commands.

Who this book is for

This book is aimed at all Oracle professionals who interact with the database through the data and database utilities and are willing to optimize their interaction with it.

Entry-level users will get acquainted with the best practices to get their job done in a timely and efficient manner. Advanced users will find useful tips and How-Tos that will help them focus on getting the most out of the database utilities and fine-tune batch processing.

In Detail

As technology rapidly evolves, many developers are looking for valuable tools to assist them with their daily tasks. When dealing with databases, a clean, easy-to-navigate interface for working and browsing is essential. Oracle SQL Developer is a graphical user interface that makes life much 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 way. It enhances productivity and simplifies your database development tasks. Although the SQL Developer journey looks simple and easy, there are many areas that can go undiscovered, leaving you just scratching the surface.

It's easy to get started and master this powerful tool with this book to hand. It will provide you with in-depth details about all aspects of using SQL Developer to assist you in your day-to-day database tasks and activities. You will learn to utilize SQL Developer's extensible environment to support your ongoing needs

This book offers detailed instructions for installing, configuring, and effectively using Oracle SQL Developer. You will learn how to utilize every feature of this development tool and make the most out of it. While none of the tasks are complex, the book progresses from the easy, most commonly used features, such as browsing objects and writing queries in the SQL Worksheet, to the more involved and possibly less frequently used features, such as Tuning and Testing SQL and PL/SQL, and adding User Extensions, and finally to those features used by a smaller more targeted audience, such as Migrations, Oracle APEX, and the Data Modeler. Throughout the book there are tips and suggestions gathered as a result of working with the current SQL Developer user base. This book will also show you how to assess the health of your database with built-in as well as customized reports.

By the end of the book you will be confident in making the best use of SQL Developer, and be able to set up and maintain a productive environment for quick and easy database development.

Use the powerful GUI to browse your database objects, run SQL statements and scripts, and create, edit, debug, and test PL/SQL code in a highly productive environment

Approach

Covering SQL Developer fundamentals as well more intermediate and advanced topics, this book uses in-depth explanation and detailed examples to help you get the most out of Oracle SQL Developer. The book has a modular structure, so that you can dip into any chapter that covers your current area of focus and get going.

Who this book is for

This book is for Oracle developers who want to ease their database development, and enhance their productivity using Oracle SQL Developer. You should have a programming knowledge of SQL and PL/SQL, and a general familiarity with Oracle database concepts.

In Detail

XML is an open standard for creating markup languages and exchanging structured documents and data over the Internet. JDeveloper 11g presents an effective, quick, and easy-to-use means of processing XML documents.

Inspired by the author's previous XML articles for the Oracle community, this expanded hands-on tutorial guides newcomers and intermediate users through JDeveloper 11g and XML document development. It offers up-to-date information on working with the latest version of JDeveloper, and brand new information on JAXB 2.0 support in JDeveloper 11g. Filled with illustrations, explanatory tables, and comprehensive instructions, this book walks the reader through the wide assortment of JDeveloper's capabilities.

Oracle's JDeveloper 11g is an Integrated Development Environment that provides a visual and declarative approach to application development. Over the course of 14 chapters, readers will get hands-on with JDeveloper as the comprehensive and self-contained tutorials provide clear instruction on the key XML tasks that JDeveloper can accomplish.

Filled with practical information and illustrated examples, this book shows the reader how to create, parse, and store XML documents quickly, as well as providing step-by-step instructions on how to construct an XML schema and use the schema to validate an XML document.

Oracle's XML Developer Kit (XDK) offers a set of components, tools, and utilities for developing XML-based applications, and developers will find the detailed XDK coverage invaluable. Later chapters are given over to using XPath, transforming XML with XSLT, and using the JSTL XML Tag Library.

Moving through the book, a chapter on the JAXB 2.0 API shows you how to bind, marshal and unmarshal XML documents, before we finally delve into comparing XML documents, and converting them into PDF and Excel formats. In all, this book will enable the reader to gain a good and wide-ranging understanding of what JDeveloper has to offer for XML processing.

A practical hands-on guide to processing XML documents in JDeveloper 11g

Approach

This book is for newcomer and intermediate Java developers who want to work with XML documents using JDeveloper 11g. No previous knowledge of JDeveloper is assumed but the reader will need to be comfortable in XML and Java environments.

Who this book is for

Employing a comprehensive tutorial-based approach, this easy-to-follow book shows the reader various means of processing XML documents using the power of Oracle's JDeveloper 11g. In next to no time, the reader will be able to create, format, transform, compare, and schema validate XML documents with Oracle's IDE.

In Detail

Scheduler (DBMS_SCHEDULER) is included in Oracle Database and is a tool for the automation, management, and control of jobs. It enables users to schedule jobs running inside the database such as PL/SQL procedures or PL/SQL blocks, as well as jobs running outside the database like shell scripts. Scheduler ensures that jobs are run on time, automates business processes, and optimizes the use of available resources.

You just need to specify a fixed date and time and Scheduler will do the rest. What if you don't know the precise time to execute your job? Nothing to worry about, you can specify an event upon which you want your job to be done and Scheduler will execute your job at the appropriate time. Although scheduling sounds quite easy, it requires programming skills and knowledge to set up such a powerful, intelligent scheduler for your project.

This book is your practical guide to DBMS_SCHEDULER for setting up platform-independent schedules that automate the execution of time-based or event-based job processes. It will show you how to automate business processes, and help you manage and monitor those jobs efficiently and effectively. It explains how Scheduler can be used to achieve the tasks you need to make happen in the real world. With a little understanding of how the Scheduler can be used and what kind of control it gives, you will be able to recognize the real power that many known enterprise-class schedulers - with serious price tags - cannot compete with.

You will see how running a specific program can be made dependent on the successful running of certain other programs, and how to separate various tasks using the built-in security mechanisms. You will learn to manage resources to balance the load on your system, and gain increased database performance.

A practical guide for Database Administrators and Developers to setting up enterprise class job scheduling

Approach

This is your practical guide to setting up a working environment and using Oracle Scheduler. Packed with simple examples and clear explanations, real-life scenarios are discussed to make you comfortable in implementing them in your own system.

Who this book is for

This book is intended for Administrators and Developers who currently use tools like cron, DBMS_JOB, and the task manager, but who now want more control or who have a need to scale up to tools that can handle the network. Complex tasks can be built that easily control business process and enable the completion of important tasks in limited time.

The reader is expected to have some experience of Oracle Database Management, and a working knowledge of SQL and PL/SQL.

In Detail XML is an open standard for creating markup languages and exchanging structured documents and data over the Internet. JDeveloper 11g presents an effective, quick, and easy-to-use means of processing XML documents. Inspired by the author's previous XML articles for the Oracle community, this expanded hands-on tutorial guides newcomers and intermediate users through JDeveloper 11g and XML document development. It offers up-to-date information on working with the latest version of JDeveloper, and brand new information on JAXB 2.0 support in JDeveloper 11g. Filled with illustrations, explanatory tables, and comprehensive instructions, this book walks the reader through the wide assortment of JDeveloper's capabilities. Oracle's JDeveloper 11g is an Integrated Development Environment that provides a visual and declarative approach to application development. Over the course of 14 chapters, readers will get hands-on with JDeveloper as the comprehensive and self-contained tutorials provide clear instruction on the key XML tasks that JDeveloper can accomplish. Filled with practical information and illustrated examples, this book shows the reader how to create, parse, and store XML documents quickly, as well as providing step-by-step instructions on how to construct an XML schema and use the schema to validate an XML document. Oracle's XML Developer Kit (XDK) offers a set of components, tools, and utilities for developing XML-based applications, and developers will find the detailed XDK coverage invaluable. Later chapters are given over to using XPath, transforming XML with XSLT, and using the JSTL XML Tag Library. Moving through the book, a chapter on the JAXB 2.0 API shows you how to bind, marshal and unmarshal XML documents, before we finally delve into comparing XML documents, and converting them into PDF and Excel formats. In all, this book will enable the reader to gain a good and wide-ranging understanding of what JDeveloper has to offer for XML processing. A practical hands-on guide to processing XML documents in JDeveloper 11gApproach This book is for newcomer and intermediate Java developers who want to work with XML documents using JDeveloper 11g. No previous knowledge of JDeveloper is assumed but the reader will need to be comfortable in XML and Java environments. Who this book is for Employing a comprehensive tutorial-based approach, this easy-to-follow book shows the reader various means of processing XML documents using the power of Oracle's JDeveloper 11g. In next to no time, the reader will be able to create, format, transform, compare, and schema validate XML documents with Oracle's IDE Annotation. As technology rapidly evolves, many developers are looking for valuable tools to assist them with their daily tasks. When dealing with databases, a clean, easy-to-navigate interface for working and browsing is essential. Oracle SQL Developer is a graphical user interface that makes life much 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 way. It enhances productivity and simplifies your database development tasks. Although the SQL Developer journey looks simple and easy, there are many areas that can go undiscovered, leaving you just scratching the surface. It_s easy to get started and master this powerful tool with this book to hand. It will provide you with in-depth details about all aspects of using SQL Developer to assist you in your day-to-day database tasks and activities. You will learn to utilize SQL Developer_s extensible environment to support your ongoing needs This book offers detailed instructions for installing, configuring, and effectively using Oracle SQL Developer. You will learn how to utilize every feature of this development tool and make the most out of it. While none of the tasks are complex, the book progresses from the easy, most commonly used features, such as browsing objects and writing queries in the SQL Worksheet, to the more involved and possibly less frequently used features, such as Tuning and Testing SQL and PL/SQL, and adding User Extensions, and finally to those features used by a smaller more targeted audience, such as Migrations, Oracle APEX, and the Data Modeler. Throughout the book there are tips and suggestions gathered as a result of working with the current SQL Developer user base. This book will also show you how to assess the health of your database with built-in as well as customized reports. By the end of the book you will be confident in making the best use of SQL Developer, and be able to set up and maintain a productive environment for quick and easy database development This book uses a practical step-by-step approach with the next chapter always building on the knowledge foundation created by the previous chapter. Understanding and really grasping the multidimensional concept is difficult enough without a lot of confusing jargon thrown in. This book speaks to the reader in plain English with plenty of easy-to-follow examples. You will create, build, and maintain data for a fictional automobile company. This book is primarily for the IT professional who has a good understanding of IT principles and processes but is a multidimensional OLAP novice. Experienced OLAP professionals will also gain insight from this book. Simply put, if you are in the IT field and wish to gain a functional level of knowledge in the world of Oracle Essbase, whether it be for a developer role or a PM or BA role, this is the book you need. This is your practical guide to setting up a working environment and using Oracle Scheduler. Packed with simple examples and clear explanations, real-life scenarios are discussed to make you comfortable in implementing them in your own system. This book is intended for Administrators and Developers who currently use tools like cron, DBMS_JOB, and the task manager, but who now want more control or who have a need to scale up to tools that can handle the network. Complex tasks can be built that easily control business process and enable the completion of important tasks in limited time. The reader is expected to have some experience of Oracle Database Management, and a working knowledge of SQL and PL/SQL. "Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources. You don't have to reinvent the wheel, just learn how to properly use the Oracle Utilities to achieve your goals. This is what this book is about; it covers topics oriented towards data management, session management, batch processing, massive deployment, troubleshooting, and how to make the most out of the frequently used DBA tools to improve your daily work"--Resource description page Develop high-performance multidimensional analytic OLAP solutions with Oracle Essbase 9 with this book and eBook