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
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
By Adrian Neagu
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.
By Mark Rittman
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.
By Alex Nuijten, Iloon Ellen-Wolff, and Learco Brizzi
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.
By Ronald Bradford and Chris Schneider
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.
By Ahmed Aboulnaga and Arun Pareek
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.
By Porus Havewala
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.
By Tom Plunkett, TJ Palazzolo, and Tejas Joshi
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.
By John Heaton
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.
Edited by Poornachandra Sarang
By Michel Schildmeijer
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).
By Vivek Acharya
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.
By Ronald Bradford and Patrick Galbraith
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.
By David Hecksel, Bernard Wheeler, Peter C. Boyd-Bowman, and Julien Testut
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.
Edited by Cameron Lackpour
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.”
By Saurabh Gupta
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.
By Clare Churcher
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.
By Richard Niemiec
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.
By Patrick Cimolini and Karen Cannell
By Pete Wang
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.
By David Kurtz
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.
By Darl Kuhn, Sam Alapati, and Bill Padfield
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.
By Nick Haralabidis
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.
By Tom Laszewski and Prakash Nauduri
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.
By Guido Schmutz, Edwin Biemond, Jan van Zoggel, Mischa Kölliker, and Eric Elzinga
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.
By Josh Juneau, Carl Dea, Freddy Guime, and John O’Conner
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.
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 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.
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.
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.
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.