As Published In

Oracle 11g Anti-Hacker’s Cookbook
Oracle Business Intelligence 11g Developers Guide
Oracle APEX Best Practices
Effective MySQL: Replication Techniques in Depth
Oracle SOA Suite 11g Administrator’s Handbook
Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos
Oracle Exalogic Elastic Cloud Handbook
Oracle Database 11g: Data Warehousing and Business Intelligence Solutions Cookbook
Java Programming
Oracle WebLogic Server 12c: First Look
Oracle BPM Suite 11g Developer’s Cookbook
Effective MySQL: Backup and Recovery
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals
Oracle Advanced PL/SQL Developer Professional Guide
Beginning Database Design, Second Edition
Oracle Database 11g Release 2 Performance Tuning Tips and Techniques
Agile Oracle Application Express
Oracle BAM 11g R1 Handbook
PeopleSoft for the Oracle DBA, Second Edition
Java 7 Recipes
Oracle Service Bus 11g Development Cookbook
Migrating to the Cloud: Oracle Client/Server Modernization
Oracle JDeveloper 11g R2 Cookbook
Expert Indexing in Oracle Database 11g
Oracle BPM Suite 11g Handbook
OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide
Expert Oracle and Java Security: Programming Secure Oracle Database Applications with Java
Oracle WebLogic Server 11g Administration Handbook
Oracle Core: Essential Internals for DBAs and Developers 

Excerpted from Oracle Magazine November/December 2012

Oracle 11g Anti-Hacker’s Cookbook

By Adrian Neagu
Packt
This book covers the most-important security measures as well as tips and tricks that can be used for better Oracle Database 11g security. The author uses real-world scenarios to show you how to secure the Oracle Database server from different perspectives and against different attack scenarios. Almost every chapter has a possible threats section, which describes the major dangers that can be confronted. The initial chapters cover how to defend your operating system, network, data, and users. The defense scenarios are linked and designed to prevent these attacks. The later chapters cover Oracle Database Vault, Oracle Virtual Private Database, Oracle Label Security, and Oracle Audit Vault. The author also demonstrates how to perform a security assessment against the operating system and the database. 

Oracle Business Intelligence 11g Developers Guide

By Mark Rittman
Oracle Press
This Oracle Press guide explains how to build business intelligence (BI) applications using Oracle Business Intelligence 11g. It covers how to execute effective queries, build accurate models, use scorecards and key performance indicators, create dynamic reports, set up dashboards, and publish to smartphones and wireless devices. The author also describes how to integrate BI applications with Oracle Fusion Middleware security, Oracle WebLogic Server, and Web services. Aimed at developers creating BI solutions using Oracle’s platform, this book also covers Oracle Exalytics In-Memory Machine, a hardware appliance that combines Oracle Business Intelligence and Oracle TimesTen In-Memory Database, for “speed of thought” analytics. 

Oracle APEX Best Practices

By Alex Nuijten, Iloon Ellen-Wolff, and Learco Brizzi
Packt
Oracle APEX Best Practices guides you through the development of real-world applications and gives you a broader view of Oracle Application Express to help you maximize its capabilities. The book covers setting up an Oracle Application Express environment, testing and debugging, security, and getting the most out of SQL and PL/SQL. It is filled with best practices on how to best use Oracle Application Express. Both new and experienced application developers will benefit from Oracle APEX Best Practices. 

Effective MySQL: Replication Techniques in Depth

By Ronald Bradford and Chris Schneider
Oracle Press
Effective MySQL: Replication Techniques in Depth describes what is needed to understand and implement MySQL replication to build scalable solutions. This book includes detailed syntax examples to demonstrate the features, options, and limitations of native MySQL replication. It provides an evaluation of new replication features and additional third-party product implementations, and helps you to ensure that your MySQL environment can support the various high-availability needs of your business. This guide helps you to master the strengths and limitations of native asynchronous replication in a MySQL topology and identify the important features to improve replication for growing business requirements. You will also learn how to recognize the key business factors to determine your optimal high-availability needs and gain an understanding of the benefits of using MySQL replication for failover scenarios. 

Oracle SOA Suite 11g Administrator’s Handbook

By Ahmed Aboulnaga and Arun Pareek
Packt
This book provides detailed explanations of the core administrative and management activities associated with Oracle SOA Suite. It includes information for end-to-end administration of Oracle SOA Suite 11g and also delves into advanced topics such as silent installs, cloning, backup and recovery, and high-availability installations. The book begins with managing composite applications, deployments, and lifecycles, and then moves on to monitoring instances, service engines, Oracle WebLogic Server, and composite applications. Toward the end, the authors take you through identifying faults and exceptions, troubleshooting approaches, and securing various components. The book explains core concepts while providing real-world implementation specifics.
 

Excerpted from Oracle Magazine September/October 2012

Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos

By Porus Havewala
Packt
Learn about Oracle Enterprise Manager 12c Cloud Control’s capabilities from an Oracle Certified Master. Using enterprise examples and case studies, learn to install Oracle Enterprise Manager 12c or upgrade from earlier versions, discover components automatically, collect configuration information, compare configurations, and enforce security compliance. The book also provides techniques for automated provisioning and patching using the new Designer/Operator roles; covers database change management capabilities; and shows how to discover, monitor, and manage Oracle Exadata Database Machine. Management of Oracle E-Business Suite and Oracle’s Siebel and PeopleSoft applications is covered, along with physical-to-virtual scenarios and infrastructure-as-a-service and database-as-a-service cloud setup and operation. 

Oracle Exalogic Elastic Cloud Handbook

By Tom Plunkett, TJ Palazzolo, and Tejas Joshi
Oracle Press
Written by members of the Oracle Exalogic X-Team—the elite group that supports strategic Oracle Exalogic customers—this guide was created for architects, administrators, and developers. It begins by describing the Oracle Exalogic Elastic Cloud hardware, software, and solution architecture, and then explores Oracle Exalogic administration and development. Topics include strategies and tips for deploying Oracle Exalogic successfully, advice and techniques for building private cloud applications, and points to consider when running packaged applications on Oracle Exalogic. System optimization, security, and migration of legacy applications from other platforms are also covered in detail. 

Oracle Database 11g: Data Warehousing and Business Intelligence Solutions Cookbook

By John Heaton
Packt
Master key techniques and components involved in effectively visualizing and analyzing information with this practical guide, packed with recipes for project management and project delivery. New and advanced techniques for extract, transform, and load (ETL) and extract, load, and transform (ELT) are covered, along with data modeling using Oracle SQL Developer Data Modeler. Readers will learn how to build logical and physical data models, how to build a presentation data model using Oracle Business Intelligence Enterprise Edition, how to create data discovery scripts that uncover data issues and gaps, and how to reverse-engineer source data models. Mapping information, semantic definitions, and security models are also covered. 

Java Programming

Edited by Poornachandra Sarang
Oracle Press
Java Programming features hands-on programming exercises and examples based on the author’s 10-plus years of teaching Java. The book covers all new Java features, including multilingual support, support for JavaScript and other scripting languages, JavaFX, and other modifications to the language. Other topics—including inheritance, exception handling, I/O, threads, network programming, events, GUI, applets, collections, strings, utility classes, and new features in JDK 7—are part of this comprehensive, expert-level guide to Java 7 programming. 

Oracle WebLogic Server 12c: First Look

By Michel Schildmeijer
Packt
Explore new Oracle WebLogic Server features using real-world examples. The book defines and explains all the concepts of Oracle WebLogic Server 12c, and then covers new features of Java Platform, Enterprise Edition (Java EE) and Java Platform, Standard Edition (Java SE) along with development of Java EE 6 applications. Readers will learn about integration and management of Oracle WebLogic Server 12c in Oracle Exalogic and cloud environments, including integration with Oracle Enterprise Manager Cloud Control 12c. Other topics include integrated services such as Oracle Coherence, JDBC, and Java Message Service, and components such as Oracle Virtual Assembly Builder, Oracle Traffic Director, and Exabus (the Oracle Exalogic I/O subsystem).

Excerpted from Oracle Magazine July/August 2012

Oracle BPM Suite 11g Developer’s Cookbook

By Vivek Acharya
Packt
Oracle BPM Suite 11g Developer’s Cookbook will help readers learn how to develop rich, interactive business processes using Oracle Business Process Management Suite 11g. A common process model based on Business Process Model and Notation is presented to the specific role assigned to readers in each chapter. The book is divided into four sections: modeling; implementation; measuring; and deployment, migration, and runtime. Each chapter offers practical, task-based recipes. 

Effective MySQL: Backup and Recovery

By Ronald Bradford and Patrick Galbraith
Oracle Press
Effective MySQL: Backup and Recovery offers a no-nonsense approach to one of the most critical tasks of an operational DBA—performing, testing, and verifying backup and disaster recovery procedures. It helps DBAs understand the limitations and quirks associated with MySQL backups. This is key to ensuring that the important business information that has been backed up and the method used to recover it will meet business needs. The book drills down into real-world problems and provides succinct, proven formulas for achieving faster backups and gaining greater overall understanding of the systems—regardless of the DBA’s experience level. The book includes a “Five Minute DBA” chapter that presents a real-world scenario and the correct way to manage it. 

Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial

By David Hecksel, Bernard Wheeler, Peter C. Boyd-Bowman, and Julien Testut
Packt
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial offers readers all the information they require to get up and running with Oracle Data Integrator, Oracle’s data integration platform for high-speed data transformation and movement between different systems. Following an example scenario, this book covers essential information about the Oracle Data Integrator architecture. It provides details about using the product across different databases and file types such as XML. Other topics include orchestrating data integration workflows, error management, operational management and monitoring, and more. This book is a resource for extract, transform, and load developers; software developers; and DBAs who want to get hands-on experience with Oracle Data Integrator quickly. 

Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals

Edited by Cameron Lackpour
Auerbach Publications
Learn advanced techniques for building analytical models, reporting systems, and forecasting applications using Oracle Essbase. This book, written by some of the most experienced Oracle Essbase practitioners around the world, covers infrastructure, datasourcing and transformation, database design, calculations, automation, APIs, reporting, and project implementation. The book includes practical cases that stem from the authors’ decades of combined experience using Oracle Essbase tools and techniques. The authors are committed to showing readers the right way to work with Oracle Essbase. Their motto: “We love Essbase and hate to see it done wrong.” 

Oracle Advanced PL/SQL Developer Professional Guide

By Saurabh Gupta
Packt
Master PL/SQL concepts with Oracle Advanced PL/SQL Developer Professional Guide. The book starts with an overview of PL/SQL and outlines the characteristics and benefits of the language. It then covers advanced PL/SQL features that include code writing using collections, tuning recommendations using result caching, and enforcing row-level security. The book also dives deep into the use of Oracle SQL Developer, employing best practices in database environments and safeguarding the vulnerable areas in PL/SQL code to avoid code injection. The book can serve as a study guide for the Oracle Advanced PL/SQL Developer Certified Professional certification. Each major certification topic is covered in a separate chapter, with practice questions included at the end of every chapter.

Excerpted from Oracle Magazine May/June 2012

Beginning Database Design, Second Edition

By Clare Churcher
Apress
Beginning Database Design, Second Edition, provides short, easy-to-read explanations of how to get database design right the first time. It is aimed at novice designers, especially those who are doing ad hoc design as a result of employing end-user tools such as Oracle Application Express, Microsoft Access, and Microsoft Excel. The author offers numerous examples to help readers avoid the many pitfalls faced by new and not-so-new database designers.

The book helps designers ask and answer important questions about their data so they can understand the problems they are trying to solve and create a pragmatic design capturing the essential—while leaving the door open for refinements and extension at a later stage. 

Oracle Database 11g Release 2 Performance Tuning Tips and Techniques

By Richard Niemiec
Oracle Press
Oracle Certified Master Richard Niemiec shows you how to systematically identify and eliminate database performance problems in this updated Oracle Press book. Filled with real-world case studies and best practices, the book details the latest monitoring, troubleshooting, and optimization methods. Learn how to find and fix bottlenecks, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered. In addition, Niemiec discusses how to properly index and partition Oracle Database 11g Release 2; work with Oracle Exadata and Oracle Exalogic Elastic Cloud; and efficiently manage disk drives, RAID arrays, and memory. 

Agile Oracle Application Express

By Patrick Cimolini and Karen Cannell
Apress
Agile Oracle Application Express shows how skilled, motivated, and self-organizing developers can realize the commercial benefits of Oracle Application Express by coupling it with an agile software development approach to iteratively design, create, and deliver quality applications on time and within budget. You will learn why Oracle Application Express is well suited to agile processes, with its support for rapid prototyping and team development. The authors also discuss how support for enabling technologies such as SQL, HTML, CSS, and JavaScript in Oracle Application Express allows you to deliver any type of Web application to meet your development needs. 

Oracle BAM 11g R1 Handbook

By Pete Wang
Packt
Oracle BAM 11g R1 Handbook is a practical best-practices tutorial focused entirely on Oracle Business Activity Monitoring, which enables business service and process monitoring through real-time data streaming and operational reports. Packed with best practices, the book covers business activity monitoring migration, high-availability configuration, and more. Wang dives straight into the architecture of Oracle Business Activity Monitoring 11g before moving on to managing business activity, monitoring server securities, populating data objects, and performing load testing, as well as building an Oracle Application Development Framework–based report. This intermediate-to-advanced guide includes step-by-step instructions and an accompanying demo project that will guide SOA report developers through application development and producing dashboards and reports. 

PeopleSoft for the Oracle DBA, Second Edition

By David Kurtz
Apress
PeopleSoft for the Oracle DBA, Second Edition, is written for DBAs charged with supporting an Oracle’s PeopleSoft system, and especially those responsible for troubleshooting and resolving PeopleSoft performance issues. In this revised edition, readers will learn about the internet architecture in PeopleSoft applications and its use of Oracle Tuxedo. The book includes full coverage of key database issues such as indexing, connectivity, and tablespace usage as they apply to PeopleSoft applications.

The author also provides advice on managing and troubleshooting performance issues in a PeopleSoft environment, including how to pinpoint problems within the code.

Excerpted from Oracle Magazine March/April 2012

Expert Indexing in Oracle Database 11g

By Darl Kuhn, Sam Alapati, and Bill Padfield
Apress
Database system performance is a top concern in today’s world, where access and activity are driven by the proliferation of phones, tablets, and other computing devices as well as PCs. Expert Indexing in Oracle Database 11g focuses on the one database structure at the heart of almost all performance issues: the index. In one compact reference volume, the book outlines the different types of indexes available in Oracle Database 11g and explains the circumstances in which each type of index is best applied. It also helps developers recognize when queries aren’t using indices as the developer intended, and it explains in detail how to manage indexing for maximum performance. 

Oracle JDeveloper 11g R2 Cookbook

By Nick Haralabidis
Packt
Available in RAW (read as it is written) format, this cookbook is a task-based guide to the complete Oracle Fusion Applications development lifecycle using Oracle JDeveloper 11g Release 2 and Oracle Application Development Framework (Oracle ADF). Readers will learn about deploying, debugging, testing, profiling, and optimizing Oracle ADF applications with Oracle JDeveloper 11g Release 2. With more than 120 recipes, the book helps readers learn concepts such as setting up application workspaces and projects; they’ll then delve into specific components such as entity objects, view objects, application modules, and more. Practical recipes with Oracle ADF Faces, UI components, and backing beans are included. 

Migrating to the Cloud: Oracle Client/Server Modernization

By Tom Laszewski and Prakash Nauduri
Syngress
IT professionals who choose service-oriented, Web-based cloud architectures for database migrations, desktop application migrations, or IT infrastructure consolidation projects can use this book to plan, budget, design, execute, and roll out their projects. Focusing on Oracle cloud relational database technology and Oracle Fusion Middleware as the target cloud-based architecture, the book recommends tools, strategies, and best practices for migrating legacy applications to service-oriented, Web-based cloud architectures for IT efficiency, agility, and lower total cost of ownership. The authors advise readers on how to determine the amount of effort and financial investment that a database and application migration might involve, and share a real-world case study. 

Oracle Service Bus 11g Development Cookbook

By Guido Schmutz, Edwin Biemond, Jan van Zoggel, Mischa Kölliker, and Eric Elzinga
Packt
With more than 80 task-based, immediately usable recipes, this book shows readers how to create a simple service on the Oracle Service Bus and shares strategies for working efficiently with the Oracle Enterprise Pack for Eclipse. It then covers ways to send and consume messages through the Java Message Service transport (both topics and queues), and other transport technologies such as Enterprise JavaBeans transport, HTTP transport, and poller transports. Communicating with the database, communicating with Oracle SOA Suite, reliable message processing, and other topics are also covered. The last two chapters discuss how to achieve message- and transport-level security on Oracle Service Bus. 

Java 7 Recipes

By Josh Juneau, Carl Dea, Freddy Guime, and John O’Conner
Apress
This book offers solutions to common programming problems encountered while developing Java-based applications. Updated to cover the newest features and techniques, Java 7 Recipes provides code examples involving Servlets, JavaFX 2.0, XML, Swing, and more. This book uses the popular problem-solution format: readers can look up the specific programming problem they want to solve, read the solution, and apply that solution directly in their own code. The authors focus on problems and solutions rather than on the Java programming language itself. Readers are free to crib from the book and apply the code examples in their own projects.

Excerpted from Oracle Magazine January/February 2012

In his new book, Oracle database expert Jonathan Lewis provides just the essential information about Oracle Database internals that every DBA needs for troubleshooting—no more, no less. Oracle Database’s extensive feature set is built on a core infrastructure that manages transactions and the ability to commit and roll back changes, protects the integrity of the database, enables backup and recovery, and allows for scalability to thousands of users all accessing the same data. By gaining an understanding of the essential core, DBAs will be able to solve most performance, backup, and recovery problems they face on a daily basis. 

Oracle WebLogic Server 11g Administration Handbook

Oracle WebLogic Server 11g Administration Handbook leads readers through the migration to, and optimization of, Oracle WebLogic Server 11g—the industry’s most comprehensive Java platform for developing, deploying, and integrating enterprise applications. Author Sam Alapati demonstrates everything needed to install, configure, manage, and secure the platform. He explains the entire process—beginning with the basics—of building, maintaining, and tuning the backbone product on which all Oracle Fusion Middleware and Oracle Fusion Applications are built. Find out how to use the Oracle WebLogic Server Administration Console feature, employ command-line and scripting tools, implement failover and migration capabilities, and generate reliable backups. Troubleshooting, tuning, and security procedures are also covered. 

Expert Oracle and Java Security: Programming Secure Oracle Database Applications with Java

This book provides resources that all Java and Oracle Database application programmers need to ensure that they have guarded the security of the data and the identities entrusted to them. Readers will learn to consider potential vulnerabilities and to apply best practices in secure Java and PL/SQL coding. Author David Coffin also shows you how to encrypt data in transit and at rest; to accomplish single sign-on with Oracle proxy connections; to generate and distribute two-factor authentication tokens from the Oracle server using pagers, cell phones (SMS), and e-mail; and to securely store and distribute Oracle application passwords. 

OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide

The Oracle Database 11g: SQL Fundamentals I exam is the first stepping-stone to obtaining the Oracle Certified Associate certification for Oracle Database 11g. SQL is used in every major relational database today, and understanding its real-world application is key to becoming a successful DBA. This book provides the tools to develop the essential skills to pass the Oracle Database 11g: SQL Fundamentals I exam and use those skills in daily life as a SQL developer or DBA. Beginners are introduced to concepts in a logical manner, while more-experienced practitioners can use the book as a reference to jump to relevant concepts directly. 

Oracle BPM Suite 11g Handbook

Written by experts with years of real-world experience in the science and art of business process management (BPM), Oracle BPM Suite 11g Handbook is a balanced combination of essential BPM concepts. It includes various methodology aspects related to successful BPM adoption in an organization, best practices, and a detailed treatment of all the features and functionalities of Oracle Business Process Management Suite 11g Release 1. The author team includes senior members of the product management group for Oracle Fusion Middleware and subject-matter experts from the Oracle enterprise architecture team. The book serves as a complete introduction and essential reference for developers, managers, business analysts, and enterprise and solution architects.

Look for other Oracle books at oracle.com/technetwork/community/bookstore.