Expert Oracle Application Express, 2nd Edition is newly updated for APEX 5.0 and brings deep insight from some of the best APEX practitioners in the field today. You'll learn about important features in APEX 5.0, and how those can be applied to make your development work easier and with greater impact on your business. Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database. The framework rests upon Oracle's powerful PL/SQL language, enabling power users and developers to rapidly develop applications that easily scale to hundreds, even thousands of concurrent users. APEX has seen meteoric growth and is becoming the tool of choice for ad-hoc application development in the enterprise. The many authors of Expert Oracle Application Express, 2nd Edition build their careers around APEX. They know what it takes to make the product sing-developing secure applications that can be deployed globally to users inside and outside a large enterprise. The authors come together in this book to share some of their deepest and most powerful insights into solving the difficult problems surrounding globalization, configuration and lifecycle management, and more. New in this edition for APEX 5.0 is coverage of Oracle REST Data Services, map integration, jQuery with APEX, and the new Page Designer. You'll learn about debugging and performance, deep secrets to customizing your application u ser interface, how to secure applications from intrusion, and about deploying globally in multiple languages. Expert Oracle Application Express, 2nd Edition is truly a book that will move you and your skillset a big step towards the apex of Application Express development. Contains all-new content on Oracle REST Data Services, jQuery in APEX, and map integration Addresses globalization and other concerns of enterprise-level development Shows how to customize APEX for your own application needs

Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c About This Book * Learn advanced application development features of Oracle Database 12c and prepare for the 1Z0-146 examination * Build robust and secure applications in Oracle PL/SQL using the best practices * Packed with feature demonstrations and illustrations that will help you learn and understand the enhanced capabilities of Oracle Database 12c Who This Book Is For This book is for Oracle developers responsible for database management. Readers are expected to have basic knowledge of Oracle Database and the fundamentals of PL/SQL programming. Certification aspirants can use this book to prepare for 1Z0-146 examination in order to be an Oracle Certified Professional in Advanced PL/SQL. What You Will Learn * Learn and understand the key SQL and PL/SQL features of Oracle Database 12c * Understand the new Multitenant architecture and Database In-Memory option of Oracle Database 12c * Know more about the advanced concepts of the Oracle PL/SQL language such as external procedures, securing data using Virtual Private Database (VPD), SecureFiles, and PL/SQL code tracing and profiling * Implement Virtual Private Databases to prevent unauthorized data access * Trace, analyze, profile, and debug PL/SQL code while developing database applications * Integrate the new application development features of Oracle Database 12c with the current concepts * Discover techniques to analyze and maintain PL/SQL code * Get acquainted with the best practices of writing PL/SQL code and develop secure applications In Detail Oracle Database is one of the most popular databases and allows users to make efficient use of their resources and to enhance service levels while reducing the IT costs incurred. Oracle Database is sometimes compared with Microsoft SQL Server, however, Oracle Database clearly supersedes SQL server in terms of high availability and addressing planned and unplanned downtime. Oracle PL/SQL provides a rich platform for application developers to code and build scalable database applications and introduces multiple new features and enhancements to improve development experience. Advanced Oracle PL/SQL Developer's Guide, Second Edition is a handy technical reference for seasoned professionals in the database development space. This book starts with a refresher of fundamental concepts of PL/SQL, such as anonymous block, subprograms, and exceptions, and prepares you for the upcoming advanced concepts. The next chapter introduces you to the new features of Oracle Database 12c, not limited to PL/SQL. In this chapter, you will understand some of the most talked about features such as Multitenant and Database In-Memory. Moving forward, each chapter introduces advanced concepts with the help of demonstrations, and provides you with the latest update from Oracle Database 12c context. This helps you to visualize the pre- and post-applications of a feature over the database releases. By the end of this book, you will have become an expert in PL/SQL programming and will be able to implement advanced concepts of PL/SQL for efficient management of Oracle Database. Style and approach The book follows the structure of the Oracle Certification examination but doesn't restrict itself to the exam objectives. Advanced concepts have been explained in an easy-to-understand style, supported with feature demonstrations and case illustrations.

Building on your existing SQL skills, this book teaches you how to apply useful jQuery techniques to applications developed using the Oracle Application Express (APEX) development tool. Pro jQuery in Oracle Application Express covers the fundamentals you need to start enhancing your applications, with some practical examples that you'll want in your own applications tomorrow. jQuery is a framework already utilized by APEX, and by learning the basics of jQuery you can leverage the flexible dynamic actions provide and see your applications raise the bar. Discover why you should embrace HTML5, CSS, and jQuery library capabilities, and how they can enhance the user experience. Oracle Application Express is a mature, browser-based, rapid-development environment with a strong community base around the #orclapex tag. jQuery is a language for the browser, with it you can treat your web page as if it were a database, interacting with a range of features and functions that can make you into a more constructive, more efficient developer. Exemplifies how productive APEX, CSS, and jQuery can be Transforms your PL/SQL skills to CSS and jQuery Provides jQuery snippets to enhance your application UX

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. A practical roadmap for database upgrade, migration, and transformationThis Oracle Press guide provides best practices for migrating between different operating systems and platforms, transforming existing databases to use different storage or enterprise systems, and upgrading databases from one release to the next. Based on the expert authors' real-world experience, Oracle Database Upgrade, Migration & Transformation Tips & Techniques will help you choose the best migration path for your project and develop an effective methodology. Code examples and detailed checklists are included in this comprehensive resource. Leverage the features of Oracle Data Guard to migrate an Oracle Database Use Oracle Recovery Manager, transportable tablespace sets, and transportable database toolsets to migrate between platforms Migrate databases with export/import Use Oracle GoldenGate for zero or near-zero downtime migrations Take advantage of the Cross-Platform Transportable Tablespace Set utility Migrate to new storage platforms using the features of Oracle Automatic Storage Management Upgrade to Oracle Database 12c with the Database Upgrade Assistant tool Move seamlessly to Oracle's engineered systems Migrate to the cloud

In this text, John Garmany leverages his ability to explain complex issues in plain English into a one-of-a-kind book for SQL and SQL*Plus beginners. This book is intended for anyone who needs to extract Oracle data and format reports. John reveals even more secrets for quickly and easily producing stunning reports from Oracle. Unknown to most Oracle professionals, special SQL extraction techniques and SQL*Plus commands can be used to quickly create complex reports, without buying expensive third-party reporting tools. Best of all, John Garmany's exciting second edition shares more working samples in his online code depot than before. Your time savings from a single script is worth the price of this great book. Easy Oracle SQL is your introduction to using SQL and SQL*Plus with an Oracle database. Whether you are just learning SQL or just need a handy reference, this book will provide you with proven methods to building queries and reports using SQL. Each concept is explained in detail with multiple examples and exercises at the end of each section. Also included is a section detailing how to effectively use SQL*Plus to not only create and run queries but also to create quality reports and scripts. This book will have you up and using SQL quickly and efficiently.

Beginning Oracle Database 12c Administration is your entry point into a successful and satisfying career as an Oracle Database Administrator. The chapters of this book are logically organized into four parts closely tracking the way your database administration career will naturally evolve. Part 1 "Database Concepts" gives necessary background in relational database theory and Oracle Database concepts, Part 2 "Database Implementation" teaches how to implement an Oracle database correctly, Part 3 "Database Support" exposes you to the daily routine of a database administrator, and Part 4 "Database Tuning" introduces the fine art of performance tuning. Beginning Oracle Database 12c Administration provides information that you won't find in other books on Oracle Database. You'll discover not only technical information, but also guidance on work practices that are as vital to your success as are your technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." (It is the editor's favorite chapter too!) If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible. You will grasp the key aspects of theory behind relational database management systems and learn how to: * Install and configure an Oracle database, and ensure that it's properly licensed; * Execute common management tasks in a Linux environment; * Defend against data loss by implementing sound backup and recovery practices; and * Improve database and query performance.

Expert Oracle SQL: Optimization, Deployment, and Statistics is about optimizing individual SQL statements, especially on production database systems. This Oracle-specific book begins by assuming you have already identified a particular SQL statement and are considering taking steps to improve its performance. The book describes a systematic process by which to diagnose a problem statement, identify a fix, and to implement that fix safely in a production system. You'll learn not only to improve performance when it is too slow, but also to stabilize performance when it is too variable. You'll learn about system statistics and how the Cost-Based Optimizer uses them to determine a suitable execution plan for a given statement. That knowledge provides the foundation from which to identify the root cause, and to stabilize and improve performance. Next after identifying a problem and the underlying root cause is to put in place a solution. Expert Oracle SQL: Optimization, Deployment, and Statistics explains how to apply various remedies such as changing the SQL statement, adding hints, changing the physical design, and more, and how they can be brought to bear on fixing a problem once and for all. Rolling a change out smoothly is an important topic when dealing with tuning and optimization. Expert Oracle SQL: Optimization, Deployment, and Statistics does not let you down in this critical area. The book contains two chapters of good information from an experienced professional on how to safely deploy changes into production so that your systems remaining running and available throughout the deployment process. Describes a systematic approach to tuning Oracle SQL Explains how things are supposed to work, what can go wrong, and how to fix it Takes you through the steps needed to stabilize performance in your production systems

Beginning Oracle PL/SQL gets you started in using the built-in language that every Oracle developer and database administrator must know. Oracle Database is chock-full of built-in application features that are free for the using, and PL/SQL is your ticket to learning about and using those features from your own code. With it, you can centralize business logic in the database, you can offload application logic, and you can automate database- and application-administration tasks. Author Don Bales provides in Beginning Oracle PL/SQL a fast-paced and example-filled tutorial. Learn from Don's extensive experience to discover the most commonly used aspects of PL/SQL, without wasting time on obscure and obsolete features. The author takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule: cover what's most needed and used by PL/SQL professionals and avoid what's not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL. Covers the key topics that matter, including variables and datatypes, executing statements, working with cursors, bulk operations, real-world objects, debugging, testing, and more. Teaches you to write production-level, object-oriented PL/SQL. You'll explore relational PL/SQL, but unlike most other books on the subject, this one emphasizes the use of PL/SQLs object-oriented features as well. Guides you in working through real examples of using of PL/SQL. You'll learn PL/SQL by applying it to real-world business problems, not by heavy theory.

Expert Consolidation in Oracle Database 12c is your key to reducing data management costs and increasing data center efficiency. Consolidation and cloud computing are converging trends sweeping the industry. The same technologies enabling cloud computing enable consolidation as well, leading to savings on all fronts from the amount of power used for servers to the amount of floor space consumed to the number of administrators needed to manage an installation. Yet the consolidation process can be a long and winding road. Success requires planning, and consideration to the impacts on supporting infrastructure.Expert Consolidation in Oracle Database 12c guides you through planning and implementing a consolidated Oracle Database installation using the many new features built into the latest release of Oracle's database management system. You'll learn to identify candidates for consolidation and to recognize instances that are best left stand-alone. The book guides in working with clustered systems and ASM storage in the consolidated environment. Focus is given to Oracle Enterprise Manager 12c Cloud Control as a monitoring and management dashboard. Always the goal is to drive towards a cost-effective environment that is efficient both in technology and people. Focuses on the new consolidation features in Oracle Database 12c Helps you evaluate and correctly decide when to consolidate Leads to cost savings and improved data center efficiency

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Maximize Application Performance on Oracle ExadataWritten by an enterprise architect specializing in applications on Oracle's engineered systems, Running Applications on Oracle Exadata: Tuning Tips & Techniques reveals proven methods for configuring and tuning Oracle Exadata to achieve peak results from applications. You'll get complete details on application migration, consolidation, and administration. Deliverunparalleled enterprise application performance on Oracle Exadata using the best practices provided in this Oracle Press guide. Understand Oracle Exadata architecture, hardware components, and software features Achieve peak performance from online transaction processing (OLTP) systems Size Oracle Exadata for applications using comparative and predictive methods Migrate and consolidate applications to Oracle Exadata Monitor, manage, and administer all Oracle Exadata components to ensure high availability and performance Develop and implement a backup and recovery strategy Learn best practices for running applications on Oracle Exadata Code examples in the book are available for download at OraclePressBooks.com

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Oracle Endeca Information Discovery Best PracticesMaximize the powerful capabilities of this self-service enterprise data discovery platform. Master Competitive Analytics with Oracle Endeca Information Discovery reveals how to unlock insights from any type of data,regardless of structure. The first part of the book is a complete technical guide to the product's architecture, components, and implementation. The second part presents a comprehensive collection of business analytics use cases in various industries, including financial services, healthcare, research, manufacturing, retail, consumer packaged goods, and public sector. Step-by-step instructions on implementing some of these use cases areincluded in this Oracle Press book. Install and manage Oracle Endeca Server Design Oracle Endeca Information Discovery Studio visualizations to facilitate user-driven data exploration and discovery Enable enterprise-driven data exploration with Oracle Endeca Information Discovery Integrator Develop and implement a fraud detection and analysis application Build a healthcare correlation application that integrates claims, patient, and operations analysis;partners; clinical research; and remote monitoring Use an enterprise architecture approach to incrementally establish big data and analytical capabilities

Practical Oracle Database Appliance is a hands-on book taking you through the components and implementation of the Oracle Database Appliance. Learn about architecture, installation, configuration, and reconfiguration. Install and configure the Oracle Database Appliance with confidence. Make the right choices between the various configurations in order to realize your performance requirements. Manage and monitor the appliance to meet business requirements. Protect your data through proper backup and recovery procedures. Oracle Database is one of the most relied-up databases in industry. For many years Oracle Database was a software product that had to be installed and configured at no small expense. The Oracle Database Appliance makes Oracle Database into a plug-and-play proposition: Plug the appliance into the wall socket, and turn it on. That's it. You have a running database server. This book takes you through that beginning point and beyond, helping you to realize in your own organization the ease of deployment and management represented by the appliance. Covers the Oracle Database Appliance from architecture through configuration. Provides a technical resource for system- and database administrators. Examines practical use cases for the Oracle Database Appliance.

Enterprise Manager 12c (EM12c), Oracle's newest and fully-integrated enterprise management product, now provides a complete cloud lifecycle management solution and enterprise environment management interface. Expert Oracle Enterprise Manager 12c opens up the secrets of this incredible management tool, saving you time while enhancing your visibility as someone management can rely upon to deliver reliable database service in today's increasingly chaotic and change-driven IT environment. Expert Oracle Enterprise Manager 12c covers all the topics you demand and need to function effectively, from basic monitoring and configuration to advanced metric extensions and plugins. Real-life scenarios and demonstrations place you in the comfort zone of using the EM12c console, and the experienced author team provides deep understanding of the inner workings of this new Enterprise Manager. Database administrators and system administrators are expected to offer increasing levels of service for 24X7 systems and newer cloud environments. Em12c offers robust, end-to-end intelligent management of the complete environment. It includes direct, real-time integration with Oracle's online knowledgebase.Expert Oracle Enterprise Manager 12c helps you master this important tool and manage any challenge that comes your way. * Provides example solutions to everyday problems through EM12c features. * Explains the changes in EM12c, included trusted extensions. * Focuses on advanced aspects of the EM12c interface. What you'll learn * Installation and agent employment * Patching and provisioning * Advanced techniques for managing and monitoring * Use of EM12c in cloud environments, with RAC, and for Exadata * Creation of EM12c plugins and metric extensions * High-availability and disaster-recovery options with EM12c * Incident Manager and EM12c job management Who this book is for Expert Oracle Enterprise Manager 12c is for database administrators who are ready to upgrade, or who have already upgraded to Enterprise Manager 12c. The book also appeals to system administrators who may have responsibility for helping support Oracle Database environments -- including RAC and Exadata -- at the enterprise level.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Best Practices for Implementing Continuous Integration with HudsonOptimize productivity while reducing risk and complexity by adopting a highly agile, "automate everything" software design philosophy. HudsonContinuous Integration in Practice shows you how to streamline and stabilize each process in your development lifecycle. Get expert tips for deploying a Hudson server, managing test and reporting frameworks, using source code management (SCM), and incorporating third-party CI tools. Distributed builds, plugin development, and system administration are also covered in this Oracle Press guide. Install, configure, and secure Hudson Automate build, integration, release, and deployment processes Set up jobs and add SCM from the Web-based GUI Administer QA tools, issue trackers, and build notifiers Incorporate IDEs, browsers, desktops, and mobile devices Publish Hudson build artifacts to Oracle Middleware utilities Work with plug-in manager and develop your own plugins Create custom dashboards and organize your jobs with views Develop a custom publisher, recorder, and notifier for your jobs

Oracle RMAN for Absolute Beginners is a gentle introduction to the use of Oracle's Recovery Manager software to make backups of an Oracle database, and to restore all or part of a database in the event that data loss occurs. It is often said that a database administrator's #1 job responsibility is to be able to recover from data loss. If you're new to the Oracle platform, or you're new to database administration in general, you can hardly go wrong by making it your first priority to learn to backup and recover the database that has been entrusted into your hands. This book is short and sweet at just 200 pages. Focus lies on the mainstream use cases. Recovery Manager, or RMAN as it is called, is a powerful and complex tool that can be intimidating at first. Author Darl Kuhn understands the need to focus on the core use cases, building your confidence in the tool, and in your ability to recover from lost database files, and even to recover your entire database should that become necessary. Oracle RMAN for Absolute Beginners shows how to backup your database. That's the first job. You'll learn to backup the entire database, and to create incremental backups that in turn can speed restore and recovery operations. Then you'll learn to recover from lost data files, lost redo log files, lost control files, and even to restore the entire database from scratch. You'll even learn how to clone a database for development and test purposes by backing the database up on one system and restoring it onto another. Author Darl Kuhn has a decade and a half of experience in writing about, and teaching Oracle Database backup and recovery. If you are newly responsible for an Oracle Database, you can hardly do better than to pick up a copy of Oracle RMAN for Absolute Beginners.

Oracle continues to implement amazing programs to aid the Oracle DBA. This book shows how powerful Oracle utilities are encapsulated into special DBMS packages. Properly used, these DBMS packages can aid the DBA in every aspect of their job. Specifically, DBMS packages provide the underlying foundation for many of the Oracle Enterprise Manager (OEM) screens; therefore, a skilled DBA with in-depth knowledge of DBMS packages can learn to write and apply sophisticated scripts to replicate the online functionality in a batch mode. Knowing when and how to use DBMS packages is key to a DBA's success in administering and monitoring their database. This book contains insider information on how to determine which Oracle packages are best to use in real world situations. The examples supplied in this book will be a powerful tool for any experienced DBA or developer interested in escaping from a reliance on queries or a GUI interface. The detail given in this book is unlike any others on the market today. This book is not for beginners. These are powerful utilities to be used only by experienced DBAs and developers who need to perform powerful system-wide operating system internal operations on their Oracle databases.

Expert Oracle Application Express Security covers all facets of security related to Oracle Application Express (APEX) development. From basic settings that can enhance security, to preventing SQL Injection and Cross Site Scripting attacks, Expert Oracle Application Express Security shows how to secure your APEX applictions and defend them from intrusion. Security is a process, not an event. Expert Oracle Application Express Security is written with that theme in mind. Scott Spendolini, one of the original creators of the product, offers not only examples of security best practices, but also provides step-by-step instructions on how to implement the recommendations presented. A must-read for even the most experienced APEX developer, Expert Oracle Application Express Security can help your organization ensure their APEX applications are as secure as they can be.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Master Oracle Fusion Applications Design and PersonalizationDeliver highly adaptable business applications that bolster productivity and drive informed decision-making. Oracle Fusion Applications Development and Extensibility Handbook contains best practices, real-world case studies, and technical deep dives. Discover how to manage design- and run-time customizations, extend existing UIs and build new ones, secure your applications, and integrate with other systems. This Oracle Press guide offers complete coverage of the latest cloud and SOA-based features. Explore Oracle Fusion Applications components and architecture Plan, develop, debug, and deploy customizations Extend out-of-the-box functionality with Oracle JDeveloper Modify web applications using Oracle Composer Incorporate Oracle SOA Suite 11g composites Validate code through sandboxes and test environments Secure data using authorization, authentication, and encryption Design and distribute personalized BI reports Automate jobs with Oracle Enterprise Scheduler Change appearance and branding of your applications with the Oracle ADF Skin Editor Extend and customize CRM with Application Composer

Oracle Application Express for Mobile Web Applications is an action driven book, taking you by the hand through all required steps in building your very own web application that will run on phones, tablets, and other mobile devices. Because you've built every piece of it yourself, you will know exactly how every tiny part is used and how you can tweak it to your own -- or your customer's -- taste. Oracle Application Express is widely known in the Oracle community as a great tool for creating web applications suitable for desktop browsers. Features have now been added to open up the world of mobile browsing, bringing the simplicity and expressiveness of Appliction Express to bear in developing applications to run with an almost-native look and feel on platforms such as iOS, Android, and Windows Phone. Oracle Application Express for Mobile Web Applications helps you translate your knowledge of Oracle Application Express into developing for mobile devices. The book and its running example provide all the knowledge you need to create professional looking mobile web applications. * Takes you through building a mobile web application from start to finish.* Gives insight into the components necessary for a professional looking mobile application. * Helps you become an even better and more all-round Oracle Application Express developer. What you'll learn * Build mobile applications to run from iPhones, iPads, Android devices, and Windows-based phones and tablets. * Make enterprise reporting and business functions accessible to mobile devices. * Customize the look-and-feel of your mobile applications. * Respond to gestures such as swiping and pointing, and to changes in device orientation. * Enhance mobile applications through the use of plugins. * Deploy applications into the Apple and Android stores. Who this book is for Oracle Application Express for Mobile Web Applications is aimed at Oracle Application Express developers wanting to develop and deploy applications for use on mobile devices. The book is also useful to any developer in an Oracle Database environment who is looking for a cheap and cheerful way to extent business functions and reporting to mobile devices.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Proven PL/SQL Optimization SolutionsIn Oracle PL/SQL Performance Tuning Tips & Techniques, Oracle ACE authors with decades of experience building complex production systems for government, industry, and educational organizations present a hands-on approach to enabling optimal results from PL/SQL. The book begins by describing the discovery process required to pinpoint performance problems and then provides measurable and repeatable test cases. In-depth coverage of linking SQL and PL/SQL is followed by deep dives into essential Oracle Database performance tuning tools. Real-world examples and best practices are included throughout this Oracle Press guide. Follow a request-driven nine-step process to identify and address performance problems in web applications Use performance-related database tools, including data dictionary views, logging, tracing, PL/SQL Hierarchical Profiler, PL/Scope, and RUNSTATS Instrument code to pinpoint performance issues using call stack APIs, error stack APIs, and timing markers Embed PL/SQL in SQL and manage user-defined functions Embed SQL in PL/SQL using a set-based approach to handle large volumes of data Properly write and deploy data manipulation language triggers to avoid performance problems Work with advanced datatypes, including LOBs and XML Use caching techniques to avoid redundant operations Effectively use dynamic SQL to reduce the amount of code needed and streamline system management Manage version control and ensure that performance fixes are successfully deployed Code examples in the book are available for download.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Transform Big Data into Insight"In this book, some of Oracle's best engineers and architects explain how you can make use of big data. They'll tell you how you can integrate your existing Oracle solutions with big data systems, using each where appropriate and moving data between them as needed." -- Doug Cutting, co-creator of Apache Hadoop Cowritten by members of Oracle's big data team, Oracle Big Data Handbook provides complete coverage of Oracle's comprehensive, integrated set of products for acquiring, organizing, analyzing, and leveraging unstructured data. The book discusses the strategies and technologies essential for a successful big data implementation, including Apache Hadoop, Oracle Big Data Appliance, Oracle Big Data Connectors, Oracle NoSQL Database, Oracle Endeca, Oracle Advanced Analytics, and Oracle's open source R offerings. Best practices formigrating from legacy systems and integrating existing data warehousing and analytics solutions into an enterprise big data infrastructure are also included inthis Oracle Press guide. Understand the value of a comprehensive big data strategy Maximize the distributed processing power of the Apache Hadoop platform Discover the advantages of using Oracle Big Data Appliance as an engineered system for Hadoop andOracle NoSQL Database Configure, deploy, and monitor Hadoop and Oracle NoSQL Database using Oracle Big Data Appliance Integrate your existing data warehousing and analytics infrastructure into a big data architecture Share data among Hadoop and relational databases using Oracle Big Data Connectors Understand how Oracle NoSQL Database integrates into the Oracle Big Data architecture Deliver faster time to value using in-database analytics Analyze data with Oracle Advanced Analytics (Oracle R Enterprise and Oracle Data Mining), Oracle R Distribution, ROracle, and Oracle R Connector for Hadoop Analyze disparate data with Oracle Endeca Information Discovery Plan and implement a big data governance strategy and develop an architecture and roadmap

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 the Oracle Exadata Database Machine. Whether you're an Oracle Database administrator, 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 the Exadata Database Machine. You can feel confident using the reliable solutions that are demonstrated in this book in your enterprise Exadata environment. Managing Oracle Exadata is unlike managing a traditional Oracle database. Oracle's Exadata Database Machine is a pre-configured engineered system comprised of hardware and software, built to deliver extreme performance for Oracle Database workloads. Exadata delivers extreme performance by offering an optimally balanced hardware infrastructure with fast components at each layer of the engineered technology stack, as well as a unique set of Oracle software features designed to leverage the high-performing hardware infrastructure by reducing I/O demands.Let Oracle Exadata Recipes help you translate your existing Oracle Database knowledge into the exciting new growth area that is Oracle Exadata. * Helps extend your Oracle Database skillset to the fast-growing, Exadata platform * Presents information on managing Exadata in a helpful, example-based format * Clearly explains unique Exadata software and hardware features What you'll learn * Install and configure Exadata * Manage your Exadata hardware infrastructure * Monitor and troubleshoot performance issues * Manage smart scan and cell offload processing * Take advantage of Hybrid Columnar Compression * Deploy Smart Flash Cache and Smart Flash Logging * Ensure the health of your Exadata environment Who this book is for Oracle Exadata Recipes is for Oracle Database administrators, Unix/Linux administrators, storage administrators, backup administrators, network administrators, and Oracle developers who want to quickly learn to develop effective and proven solutions without reading through a lengthy manual scrubbing for techniques. Readers in a hurry will appreciate the recipe format that sets up solutions to common tasks as the centerpiece of the book.Table of Contents * Exadata Hardware * Exadata Software * How Oracle Works on Exadata * Workload Qualification * Sizing Exadata * Preparing for Exadata * Administration and Diagnostics Utilities * Backup and Recovery * Storage Administration * Network Administration * Patching and Upgrades * Security * Monitoring Exadata Storage Cells * Host and Database Performance Monitoring * Smart Scan and Cell Offload * Hybrid Columnar Compression * I/O Resource Management and Instance Caging * Smart Flash Cache and Smart Flash Logging * Storage Indexes * Post-Installation Monitoring Tasks * Post-Install Database Tasks

This is a cookbook that covers more than 80 different recipes to teach you about different aspects of Oracle ADF Faces. It follows a practical approach and covers how to build your components for reuse in different applications. This book will also help you in tuning the performance of your ADF Faces application. If you are an ADF developer who wants to harness the power of Oracle ADF Faces to create exceptional user interfaces and reactive applications, this book will provide you with the recipes needed to do just that. You will not need to be familiar with Oracle ADF Faces, but you should be comfortable with Java application development, Java EE frameworks, and JSF. This book is also for ADF developers who know how to use Oracle ADF Faces but who want to know what's new in Oracle ADF Faces 12c.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. A Complete Study System for OCA Exam 1Z0-061Prepare for the Oracle Certified Associate Oracle Database 12c SQL Fundamentals I exam with this Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-061, including: Data retrieval using the SQL SELECT statement Restricting and sorting data Single-row functions Using conversion functions and conditional expressions Reporting aggregated data with the group functions Displaying data from multiple tables with joins Using subqueries to solve problems Using the set operators Manipulating data with DML statements Using DDL statements to create and manage tables Electronic content includes: 150+ practice exam questions with detailed answers and explanations Score report performance assessment tool PDF copy of the book

Pro Oracle SQL, Second Edition unlocks the power of SQL in the Oracle database--one of the most potent SQL implementations on the market today. To master it requires a multi-pronged approach: learn the language features, learn how and why the language features work, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets. Karen Morton has updated the content for Oracle version 12c and helps you master powerful aspects of Oracle SQL from the inside-out. You'll learn analytic functions, the MODEL clause, and advanced grouping syntax--features that will help in creating good queries for reporting and business intelligence applications. Pro Oracle SQL, Second Edition also helps you minimize parsing overhead, read execution plans, test for correct results, understand performance management, and exert control over SQL execution in your database. You'll learn when to create indexes, how to verify that they make a difference, how to use SQL Baselines and Profiles to optimize and stabilize SQL execution plans, and much more.You'll also understand how SQL is optimized for working in sets, and that the key to getting accurate results lies in making sure that queries ask clear and precise questions. Pro Oracle SQL, Second Edition helps you work at a truly professional level in the Oracle dialect of SQL. You'll master the language, the tools to work effectively with the language, and the right way to think about a problem in SQL. * Endorsed by the OakTable Network, a group of Oracle technologists well-known for their rigorous and scientific approach to Oracle Database performance * Comprehensive--goes beyond the language with a focus on what you need to know to write successful queries and data manipulation statements. * Performance focused--teaches you how to measure the performance of your SQL statements and not just the syntax.What you'll learn * Master powerful SQL features implemented in the Oracle Database * Understand how the Oracle Optimizer develops execution plans * Read and interpret SQL execution plans * Quickly diagnose and fix badly performing SQL * Control execution plans through hints, profiles, and plan baselines * Optimize queries within packaged applications without touching the code * Recognize when not to waste time on SQL that is performing optimally Who this book is for Pro Oracle SQL, Second Edition is aimed at developers and database administrators who submit SQL for execution by an Oracle database. Readers should already know the basic four SQL statements, and be ready to learn deeply about Oracle's specific implementation of the language, including Oracle-specific features and syntax. Readers should also want to learn about Oracle Database features such as analytic queries, the MODEL clause, and the WITH clause (subquery factoring) that are designed to help developers and database administrators exert control over their SQL environment and its execution.