As Published In
Oracle Magazine

Book Beat

 

Expert Consolidation in Oracle Database 12c
Oracle Database 12c Performance Tuning Recipes
Oracle Database 12c New Features
Oracle NoSQL Database
Oracle Essentials, 5th Edition
Oracle Database 12c: The Complete Reference
Oracle Enterprise Manager Cloud Control 12c Deep Dive
RMAN Recipes for Oracle Database 12c
Oracle Database 12c: Install, Configure, and Maintain Like a Professional
Getting Started with Oracle WebLogic Server 12c: Developer’s Guide
Oracle Big Data Handbook
Pro Oracle Database 12c Administration
Oracle Enterprise Manager Cloud Control 12c Deep Dive
Oracle WebLogic Server 12c Advanced Administration Cookbook
Database Cloud Storage: The Essential Guide to Oracle Automatic Storage Management
Expert Oracle RAC 12c
Oracle Business Intelligence Applications
Oracle GoldenGate 11g Handbook
Oracle Application Express for Mobile Web Applications
Oracle ADF 11gR2 Development Beginner’s Guide
Oracle SOA BPEL PM 11g R1: A Hands-On Tutorial
Oracle Enterprise Manager 12c Administration Cookbook
MySQL Workbench: Data Modeling and Development
Oracle SQL Tuning with Oracle SQLTXPLAIN
OCA Oracle Solaris 11 System Administration Exam Guide (Exam 1Z0-821)
Oracle WebLogic Server 12c—Distinctive Recipes
Building and Managing a Cloud Using Oracle Enterprise Manager 12c
Oracle Exadata Recipes
Expert Oracle Enterprise Manager 12c
Managing Multimedia and Unstructured Data in the Oracle Database
Expert MySQL, Second Edition
Oracle ADF Real World Developer’s Guide
Oracle SOA Suite 11g Developer’s Cookbook
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 January/February 2014


Expert Consolidation in Oracle Database 12c

By Martin Bach
Apress
Learn how to reduce data management costs and increase data center efficiency with Expert Consolidation in Oracle Database 12c. The book guides you through planning and implementing a consolidated Oracle Database installation using many of the new features in Oracle Database 12c. You’ll learn to identify candidates for consolidation and to recognize instances that are best left as standalone databases. Author Martin Bach, an Oracle Certified Master, also covers working with clustered systems and Oracle Automatic Storage Management in a consolidated environment. In addition, he discusses using the Oracle Enterprise Manager Cloud Control feature of Oracle Enterprise Manager 12c as a monitoring and management dashboard. Bach’s focus is driving readers toward a cost-effective environment that is efficient in both technology and human resources.

 

Oracle Database 12c Performance Tuning Recipes

By Sam Alapati, Darl Kuhn, and Bill Padfield
Apress
Oracle Database 12c Performance Tuning Recipes is a ready reference for database administrators in need of immediate help with performance issues relating to Oracle Database 12c. The book takes an example-based approach, wherein each chapter covers a specific problem domain. Each chapter includes recipes for how to perform common tasks in that chapter’s domain. Solutions in the recipes are backed by clear explanations of background and theory. If you have a performance-related task, you’re likely to find a recipe and a solution for it here.

 

Oracle Database 12c New Features

By Robert Freeman
Oracle Press
Learn how to maximize the new capabilities of Oracle Database 12c. Author and Oracle ACE Robert Freeman provides essential information to get you up and running quickly on Oracle Database 12c. The book offers commentary from Oracle Database expert and Oracle Magazine columnist Tom Kyte, with additional contributions by Oracle Database experts Eric Yen and Scott Black. It features detailed coverage of upgrading to Oracle Database 12c; architectural changes; performance improvements; and new features for backup and recovery, administration, data warehousing, and information lifecycle management.

 

Oracle NoSQL Database

By Maqsood Alam, Aalok Muley, Chaitanya Kadaru, and Ashok Joshi
Oracle Press
Written by members of the Oracle NoSQL Database product development team, this book is an authoritative primer for Oracle’s big data software stack. Learn how to use Oracle NoSQL Database to store big data in low-cost, low-impact, highly scalable and available data stores. Gain a real-world understanding of how Oracle NoSQL Database integrates with Oracle’s other big data solutions, with coverage of Oracle NoSQL Database architecture, installation, configuration, application development, administration, security, and more. The book features actual use cases of Oracle NoSQL Database, emphasizing the success stories and the business problems solved.

 

Oracle Essentials, 5th Edition

By Rick Greenwald, Robert Stackowiak, and Jonathan Stern
O’Reilly Media
This book distills an enormous amount of information about Oracle Database 12c into one volume. Ideal for novice and experienced DBAs, developers, managers, and users, Oracle Essentials walks you through technologies and features in Oracle Database 12c. Complete with illustrations and hints, this fifth edition provides a one-stop overview of Oracle Database 12c. The book begins with an introduction to Oracle Database and the evolution of the relational database, a summary of key features, and the role of Oracle Fusion Middleware. Other topics include core concepts in the architecture of Oracle Database, including pluggable databases, installation, data structures and datatypes, managing an Oracle database, security options, basic principles of multiuser concurrency, transaction processing, backup and recovery, cloud, and more.


Excerpted from Oracle Magazine November/December 2013


Oracle Database 12c: The Complete Reference

By Bob Bryla and Kevin Loney
Oracle Press
Oracle Database 12c: The Complete Reference shows readers how to use the new tools and cloud enhancements of Oracle Database 12c to maintain a scalable, highly available enterprise platform and reduce complexity. This authoritative guide covers database installation, configuration, tuning, and administration and shows you how to build and populate Oracle databases, perform effective queries, design applications, and secure data. The book also contains a comprehensive appendix covering Oracle Database commands, keywords, features, and functions. Electronic content includes all code examples from the book and a PDF e-book.

 

Oracle Enterprise Manager Cloud Control 12c Deep Dive

By Michael New, Edward Whalen, and Matthew Burke
Oracle Press
Oracle Enterprise Manager Cloud Control 12c Deep Dive reveals the best ways to implement a robust Oracle Enterprise Manager 12c Cloud Control infrastructure and how to use many of the tool’s advanced features and management packs to administer an IT environment. The book is divided into four major parts, the first of which focuses on installing, configuring, securing, and maintaining the Oracle Enterprise Manager 12c Cloud Control infrastructure. Part II details best practices for the advanced capabilities used to administer the most commonly monitored targets: databases, hosts, storage, and middleware. Part III features a high-level description of management packs. Part IV shows how to manage Oracle E-Business Suite with related packs and their accelerators.

 

RMAN Recipes for Oracle Database 12c

By Darl Kuhn, Sam Alapati, and Arup Nanda
Apress
Oracle’s flagship database product includes a wide-ranging set of features to aid database administrators in the all-important tasks of data recovery and safeguarding against data loss. Oracle Recovery Manager (Oracle RMAN) is at the heart of that feature set and is the tool most often used to initiate database backup and recovery operations. RMAN Recipes for Oracle Database 12c provides an example-driven approach to database recovery with Oracle RMAN and provides step-by-step solutions for the gamut of backup and recovery tasks that an administrator might need to perform. Readers will also learn how Oracle Database can manage backup files via the Fast Recovery Area, how to automate backup and recovery tasks with scripts, how to troubleshoot Oracle RMAN problems and optimize Oracle RMAN performance, and how to recover a lost control file or online redo log.

 

Oracle Database 12c: Install, Configure, and Maintain Like a Professional

By Ian Abramson, Michael Abbey, Michelle Malcher, and Michael Corey
Oracle Press
Filled with easy-to-follow tutorials, this guide provides detailed coverage of core Oracle Database 12c concepts, the role of the administrator, and enterprise database capabilities. The book is an essential beginner’s resource that walks readers through database configuration, administration, programming, backup and recovery, and high availability. Each chapter includes a list of specific skills, practical exercises for applying those skills, self-assessments for checking projects, expert Q&A sections, and quizzes to test mastery of the material. It also includes in-depth introductions to SQL and PL/SQL, advice for managing large databases, and information on using Oracle’s engineered systems.

 

Getting Started with Oracle WebLogic Server 12c: Developer’s Guide

By Fabio Mazanatti Nunes and William Markito Oliveira
Packt
Getting Started with Oracle WebLogic Server 12c: Developer’s Guide provides a practical, hands-on introduction to Oracle WebLogic Server 12c. Written for beginners and intermediate users, the book will help developers create a complete Java Platform, Enterprise Edition 6 application leveraging Oracle WebLogic Server features such as Java Message Service (JMS), SOAP, and RESTful web services. It includes content on Oracle WebLogic Server’s key features and step-by-step instructions, with screenshots and code samples, to help readers understand and apply important concepts.

 

Oracle Big Data Handbook

By Tom Plunkett, Brian Macdonald, Bruce Nelson, Mark Hornick, Helen Sun, Khader Mohiuddin, Debra Harding, Gokula Mishra, Robert Stackowiak, Keith Laker, and David Segleau
Oracle Press
Cowritten by members of Oracle’s big data team, Oracle Big Data Handbook provides coverage of Oracle’s products for acquiring, organizing, analyzing, and leveraging unstructured data. The book discusses technologies essential for successful big data implementations—including Apache Hadoop, Oracle Big Data Appliance, Oracle Big Data Connectors, Oracle NoSQL Database, Oracle Endeca solutions, Oracle Advanced Analytics, and Oracle’s open source R offerings—and offers strategies for using them. The handbook also includes best practices for migrating from legacy systems to an enterprise big data infrastructure.


Excerpted from Oracle Magazine September/October 2013


Pro Oracle Database 12c Administration

By Darl Kuhn
Apress

In Pro Oracle Database 12c Administration, author Darl Kuhn lays out real-world techniques that lead to success as an Oracle DBA. He gives clear explanations on how to perform critical tasks and weaves in theory where necessary without bogging the reader down in unnecessary detail. If you have “buck stops here” responsibility for an Oracle database, then Pro Oracle Database 12c Administration is the book you need to help elevate yourself to the level of elite Oracle DBA. The author has written books on a variety of IT topics including SQL, performance tuning, Linux, backup and recovery, Oracle Recovery Manager, and database administration.

 

Oracle Enterprise Manager Cloud Control 12c Deep Dive

By Michael New, Edward Whalen, and Matthew Burke
Oracle Press
Oracle Enterprise Manager Cloud Control 12c Deep Dive reveals the best ways to implement a robust Oracle Enterprise Manager 12c Cloud Control infrastructure and how to use many of the tool’s advanced features and management packs to administer an IT environment. The book is divided into four major parts, the first of which focuses on installing, configuring, securing, and maintaining the Oracle Enterprise Manager 12c Cloud Control infrastructure. Part II details best practices for the advanced capabilities used to administer the most commonly monitored targets: databases, hosts, storage, and middleware. Part III features a high-level description of management packs. Part IV shows how to manage Oracle E-Business Suite with related packs and their accelerators.

 

Oracle WebLogic Server 12c Advanced Administration Cookbook

By Dalton Iwazaki
Packt
Oracle WebLogic Server 12c Advanced Administration Cookbook guides you through 70 recipes beginning with the basics of Oracle WebLogic Server 12c installation and passing through JDBC, Java Message Service (JMS), cluster configuration, and tuning. Each chapter covers a specific topic with complex solutions simplified and explained. The book covers the day-by-day tasks of an Oracle WebLogic administrator, and it’s enhanced with tips for building an Oracle WebLogic Server production environment focused on stability, high availability, and performance. It is ideal for those who know the basics of Oracle WebLogic Server but want to dive into more-advanced topics.

 

Database Cloud Storage: The Essential Guide to Oracle Automatic Storage Management

By Nitin Vengurlekar and Prasad Bagal
Oracle Press
This Oracle Press guide contains the latest information on the inner workings of the Oracle Automatic Storage Management feature of Oracle Database and Oracle’s cloud storage management. Database Cloud Storage: The Essential Guide to Oracle Automatic Storage Management explains how to build and manage a scalable cloud storage infrastructure with Oracle Automatic Storage Management. Readers will learn how to configure cloud storage solutions, build disk groups, use data striping and mirroring, and optimize performance. Details on ensuring consistency across server and storage platforms, maximizing data redundancy, and administering Oracle Automatic Storage Management are also included. Written by members of the team that developed and managed Oracle Automatic Storage Management, the guide covers practical day-to-day usage, general operations, best practices, and tips and techniques.

 

Expert Oracle RAC 12c

By Syed Jaffar Hussain, Tariq Farooq, Riyaj Shamsudeen, and Kai Yu
Apress
Expert Oracle RAC 12c, written by experienced Oracle Real Application Clusters (Oracle RAC) engineers, teaches you how to understand and implement Oracle RAC and how to reduce the total cost of ownership of an Oracle RAC database. This book provides deep understanding of Oracle RAC concepts and implementation details that you can apply to your operational practices. Successful Oracle RAC operation hinges upon a fast-performing network interconnect, and this book dedicates a chapter to that important topic.


Excerpted from Oracle Magazine July/August 2013


Oracle Business Intelligence Applications

By Simon Miller and William Hutchinson
Oracle Press
Oracle Business Intelligence Applications shows you how to deliver intuitive, role-based intelligence for everyone in an organization. The authors—master principal sales consultants at Oracle who specialize in Oracle Business Intelligence Applications—provide complete coverage of implementing and operating Oracle Business Intelligence Applications. They also explain how to enable better decision-making and optimize business processes based on accurate information. The book includes case studies and advanced scenarios based on real-world experiences from Oracle’s presales team. 

Oracle GoldenGate 11g Handbook

By Robert Freeman
Oracle Press
This book walks you through implementing Oracle GoldenGate—a real-time transactional change data capture, transformation, and delivery solution—from basic architecture to tips and tricks. Author Robert Freeman guides database professionals through advanced topics such as multimaster replication and conflict resolution. Each chapter of Oracle GoldenGate 11g Handbook features workshops that you can use to install, configure, and run Oracle GoldenGate 11g. The book also emphasizes the heterogeneous capabilities of Oracle GoldenGate and provides step-by-step instructions that show how to move disparate data from current and legacy systems to an Oracle database. 

Oracle Application Express for Mobile Web Applications

By Roel Hartman, Christian Rokitta, and David Peake
Apress
Oracle Application Express for Mobile Web Applications helps you translate your knowledge of Oracle Application Express into developing for mobile devices. This book walks you through all the required steps to build a Web application that will run on phones, tablets, and other mobile devices. You will learn how to make enterprise reporting and business functions accessible to mobile devices; how to customize the look and feel of your applications; and how to respond to gestures such as swiping and pointing. The book also shows you how to enhance mobile applications through the use of plug-ins and how to deploy applications into the Apple and Android stores. 

Oracle ADF 11gR2 Development Beginner’s Guide

By Vinod Krishnan
Packt
This book shows you how to implement Web-based applications using Oracle Application Development Framework 11g Release 2 (Oracle ADF 11g Release 2). Oracle ADF 11gR2 Development Beginner’s Guide covers the basics of development and then steps through more-complex topics, following a tutorial approach. Author Vinod Krishnan starts with installation and configuration and then covers topics such as working with the model layer and model data, followed by displaying and binding data. 

Oracle SOA BPEL PM 11g R1: A Hands-On Tutorial

By Ravi Saraswathi and Jaswant Singh
Packt
Oracle SOA BPEL PM 11g R1: A Hands-On Tutorial is your guide to learning Business Process Execution Language (BPEL) and creating basic and complex BPEL processes using Oracle JDeveloper and Oracle BPEL Process Manager. Following instructions, you will create and configure adapters, human workflow, and advanced BPEL orchestration. You will also practice deploying, testing, debugging, tuning, error handling, and troubleshooting processes. In addition, you will see how to integrate Oracle BPEL Process Manager with Oracle Service Bus, Oracle Business Rules, and Oracle Business Activity Monitoring. Finally, you will learn how to achieve scalability, high availability, and failover and failback capabilities to deliver business continuity and disaster recovery objectives.


Excerpted from Oracle Magazine May/June 2013


Oracle Enterprise Manager 12c Administration Cookbook

By Dhananjay Papde, Vipul Patel, and Tushar Nath
Packt

Oracle Enterprise Manager allows Oracle administrators to manage their Oracle installations and selected other applications and provides a one-stop place to manage and maintain the entire infrastructure in any organization. Oracle Enterprise Manager 12c Administration Cookbook starts with the installation and upgrade of an Oracle Enterprise Manager installation and then takes you through the process of using Oracle Enterprise Manager 12c to configure and monitor your Oracle application and database servers, including supported Oracle Fusion Middleware products. The book covers monitoring the infrastructure and includes recipes for creating and cloning databases and creating templates. It also discusses installation and upgrade options. 

MySQL Workbench: Data Modeling and Development

By Michael McLaughlin
Oracle Press
Written by Oracle ACE Michael McLaughlin, MySQL Workbench: Data Modeling and Development helps developers learn how to effectively use the MySQL Workbench graphical user interface for database modeling, reverse engineering, and interaction with MySQL database without writing SQL statements. The book covers the interface and explains how to accomplish tasks by presenting best practices visually. Annotated screen shots demonstrate all interactions with the tool, and text explains the how, what, and why of each interaction. 

Oracle SQL Tuning with Oracle SQLTXPLAIN

By Stelios Charalambides
Apress
Oracle SQL Tuning with Oracle SQLTXPLAIN is a practical guide to SQL tuning the way Oracle’s own experts do it, using a tool called SQLTXPLAIN. Using this simple tool—downloadable from My Oracle Support—you’ll learn how to tune even the most-complex SQL. Firmly based in real-world problems, this book helps you reclaim system resources and avoid the most common bottleneck in overall performance: badly tuned SQL. You’ll learn how the optimizer works, how to take advantage of its latest features, and when it’s better to turn those features off. 

OCA Oracle Solaris 11 System Administration Exam Guide (Exam 1Z0-821)

By Michael Ernest
Oracle Press
Written by an Oracle Solaris expert who has been teaching courses on Oracle Solaris for the last 15 years, this book covers all objectives of the OCA Oracle Solaris 11 System Administration Exam. Author Michael Ernest also highlights key exam information and potential exam pitfalls. Practice questions at the end of every chapter test comprehension and simulate actual exam questions. The CD-ROM that accompanies the book features additional practice exam questions in the form of two complete practice exams that mirror the actual exam in content, style, tone, format, and difficulty. In addition to preparing you for the OCA exam, this exam guide also serves as a system administrator’s reference guide for Oracle Solaris 11. 

Oracle WebLogic Server 12c—Distinctive Recipes

By Frank Munz
munz & more
This book is an anthology of best practices in Oracle WebLogic Server administration, architecture, performance tuning, and monitoring. It was written for software architects, administrators, and developers who are familiar with Oracle WebLogic Server and want to know more. Author Frank Munz provides recommendations, discussions, best practices, deployable projects, Webcast videos, and directions on when to use a feature—and when not to. Other topics include the merged Java Virtual Machine, using JMX with your own applications, stuck threads, JDBC myths, effectively detecting memory leaks, Java EE examples (including deployments and NetBeans projects), Oracle Fusion Middleware, and using Oracle WebLogic Server in the cloud. Author Frank Munz is the 2011 recipient of the Oracle Excellence Award for Technologist of the Year: Cloud Architect. 


Excerpted from Oracle Magazine March/April 2013


Building and Managing a Cloud Using Oracle Enterprise Manager 12c

By Madhup Gulati, Adeesh Fulay, and Sudip Datta
Oracle Press

Building and Managing a Cloud Using Oracle Enterprise Manager 12c combines the science and art of leveraging Oracle technologies to build a cloud from scratch or to build on existing IT investments. The authors teach you how to quickly design and implement the various aspects of a cloud lifecycle, from setup to delivery to operation, with a focus on Oracle Enterprise Manager 12c. Strategies and best practices for building a solid cloud foundation for increased operational efficiency, greater business agility, and reduced costs are included.

 

Oracle Exadata Recipes

By John Clarke
Apress
Oracle Exadata Recipes takes an example-based, problem/solution approach in showing how to size, install, configure, manage, monitor, optimize, and migrate Oracle Database workloads on and to Oracle Exadata Database Machine. Whether you’re an Oracle DBA, UNIX/Linux administrator, storage administrator, network administrator, or Oracle developer, Oracle Exadata Recipes provides effective and proven solutions to accomplish a wide variety of tasks on Oracle Exadata Database Machine. You will learn how to install and configure Oracle Exadata, manage your Oracle Exadata hardware infrastructure, monitor and troubleshoot performance issues, and manage smart scan and cell offload processing.

 

Expert Oracle Enterprise Manager 12c

By Kellyn Pot’Vin, Anand Akela, Gokhan Atil, Alex Gorbachev, Niall Litchfield, Leighton Nelson, and Pete Sharman
Apress
DBAs and system administrators are expected to offer increasing levels of service for 24/7 systems and cloud environments. Oracle Enterprise Manager 12c offers robust, end-to-end intelligent management of the complete systems environment. Expert Oracle Enterprise Manager 12c covers basic monitoring and configuration, advanced metric extensions, and plug-ins while providing real-life scenarios and demonstrations that will help you become familiar with using the Oracle Enterprise Manager 12c console.


Excerpted from Oracle Magazine January/February 2013


Oracle ADF Real World Developer’s Guide

By Jobinesh Purushothaman
Packt
Oracle Application Development Framework (Oracle ADF) in combination with Oracle JDeveloper offers visual and declarative approaches to enterprise application development. With the help of many real-world examples, this book will teach you to build scalable rich enterprise applications using Oracle ADF. Author Jobinesh Purushothaman starts off by introducing the Oracle JDeveloper development environment and design time features. Then he shows you how to build a full-stack enterprise application using Oracle ADF. You will also learn how to use Oracle ADF to build business services, enable validation for the data model, declaratively build user interfaces for business services, and enable security across application layers. 

Oracle Exalytics Revealed

By Mark Rittman
Oracle Press
Enable your organization to analyze large amounts of data via rich visual dashboards using Oracle Exalytics In-Memory Machine. Written by Oracle ACE Director Mark Rittman, this e-book offers comprehensive coverage of Oracle Exalytics In-Memory Machine, Oracle’s preintegrated business intelligence platform. Oracle Exalytics Revealed begins with an overview of the product and its capabilities and then provides complete details on installation, configuration, administration, maintenance, and creation of the in-memory adaptive data mart that powers speed-of-thought dashboards. Additionally, Rittman offers expert tips for integrating with both Oracle and non-Oracle enterprise datasources. 

Oracle SOA Suite 11g Developer’s Cookbook

By Antony Reynolds and Matt Wright
Packt
Whether you’re using Oracle SOA Suite as an integration tool or as the foundation of your SOA, your goal is a reliable SOA implementation. Oracle SOA Suite 11g Developer’s Cookbook gives you the knowledge to achieve that, through numerous tips and tricks for extending and enhancing your applications. The book equips you with invaluable information about Oracle SOA Suite development that can usually only be gained through experience. The cookbook’s recipes distill real-world experience into an easily applicable form. Throughout the book you’ll encounter high-level challenges such as building a reliable Oracle SOA Suite cluster and detailed development problems such as avoiding errors in Oracle BPEL assignment statements. Along the way you’ll also learn about configuring identity providers and managing transaction boundaries. 

Expert MySQL, Second Edition

By Charles Bell
Apress
This reference book is a must-have for systems integrators, engineers, and software developers working with MySQL server code. Author Charles Bell shows you how to modify the code, create your own storage engine, build your own authentication plug-ins, and even add your own functions and commands to the SQL language. Expert MySQL, Second Edition, also provides extensive details and examples of the inner workings of MySQL and presents information on key aspects of MySQL internals. You’ll learn about internal query representation, how the optimizer creates execution plans, and how to exert control over those plans for optimal performance in your environment. High availability and replication are also covered.

Managing Multimedia and Unstructured Data in the Oracle Database

By Marcelle Kratochvil
Packt
Managing Multimedia and Unstructured Data in the Oracle Database will help you gain an understanding of how to manage all data, especially multimedia. Starting with the basic principles of unstructured data and detailing the concepts behind multimedia warehouses and digital asset management systems, this book describes how to load this data, search against it, display it intelligently, and deliver it to customers and users. Author Marcelle Kratochvil explains how all these concepts work within the Oracle Database 11g Release 2 environment and how to tune the database effectively to manage this data.


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


Oracle Core: Essential Internals for DBAs and Developers

By Jonathan Lewis
Apress

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

By Sam Alapati
Oracle Press

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

By David Coffin
Apress

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

By Steve Ries
Packt

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

By Manoj Das, Manas Deb, and Mark Wilkins
Oracle Press

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.