Oracle Business Intelligence Enterprise Edition 12c


Book Description

A comprehensive guide from Oracle experts, that will act as your single point of reference for building an Oracle BI 12c system that turns data in actionable insight. About This Book Come, start your first Oracle Business intelligence system and excel in BI with this exhaustive guide An all-encompassing guide for your Oracle business intelligence needs Learn from the self-paced professional guidance and implement Oracle business intelligence using this easy-to-follow guide by our experts Who This Book Is For If your job includes working on data, improving the financial or operational performance of your organization or you are a consultant for the above, then this book is for you. If you have been placed on a business intelligence project, then this book is for you. If you are the Project Manager, Business Analyst or Data Scientist then this book is for you. If you are an end user of Oracle Business Intelligence, then this book is for you too. Having a basic understanding of databases and the use of Business Intelligence is expected, but no knowledge of Oracle BI is required. What You Will Learn Install OBIEE in Windows, including how to create the underlying Weblogic Application server and the required database Build the BI system repository, the vital engine connecting your data to the front end of Oracle BI Develop effective analysis, draw out meaning from the data, and present it to end users on interactive dashboards Build pixel-perfect, printable reports using the embedded BI Publisher feature Build agents for actionable insight and enable your users to act on Business Intelligence at their desktop or on the move Understand the various aspects of securing the Oracle BI system, from data restrictions to whole dashboard access rights Get acquainted with the system management tools and methods available for the continuous improvement of your system In Detail Oracle Business Intelligence Enterprise Edition (OBIEE) 12c is packed full of features and has a fresh approach to information presentation, system management, and security. OBIEE can help any organization to understand its data, to make useful information from data, and to ensure decision-making is supported by facts. OBIEE can focus on information that needs action, alerting users when conditions are met. OBIEE can be used for data analysis, form production, dashoarding, and workflow processes. We will introduce you to OBIEE features and provide a step-by-step guide to build a complete system from scratch. With this guide, you will be equipped with a good basic understanding of what the product contains, how to install and configure it, and how to create effective Business Intelligence. This book contains the necessary information for a beginner to create a high-performance OBIEE 12c system. This book is also a guide that explains how to use an existing OBIEE 12c system, and shows end users how to create. Style and approach This book will take you from one feature to another in a step-by-step manner and will teach how you can create effective business intelligence using Oracle Business Intelligence Enterprise Edition. You will be taught how to create BI solutions and dashboards from scratch. There will be multiple modules in the book, each module spread in chapters, that will cover one aspect of business intelligence in a systematic manner.




Oracle Enterprise Manager Cloud Control 12c Deep Dive


Book Description

Master Oracle Enterprise Manager Cloud Control 12c Achieve peak database efficiency and derive unprecedented value from your corporate assets by implementing an end-to-end cloud computing solution. Oracle Enterprise Manager Cloud Control 12c Deep Dive thoroughly explains best practices for deployment, administration, and monitoring. Learn how to prepare and install Oracle Enterprise Manager Cloud Control 12c, use agents, apply system-wide patches, perform real-time diagnostics, and discover, monitor, and administer hosts, databases, and middleware. Security and select plug-ins are also fully covered in this Oracle Press guide. Install and configure Oracle Enterprise Manager Cloud Control 12c Deploy management agents in one of six available ways Handle security with Cloud Control administrators, roles, and credentials Track performance with SQL monitoring and Active Session History (ASH) analytics Dynamically provision middleware and enterprise applications Work with Oracle Exadata and Oracle Exalogic Elastic Cloud Force policy compliance and employ global change detection Manage and monitor hosts, virtual machines, and server pools




Oracle Fusion Applications Development and Extensibility Handbook


Book Description

Master Oracle Fusion Applications Design and Personalization Deliver 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 Big Data Handbook


Book Description

"Cowritten by members of Oracle's big data team, [this book] 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"--Page 4 of cover.




Best practices and Getting Started Guide for Oracle on IBM LinuxONE


Book Description

IBM® is a Platinum level Partner in the Oracle Partner Network, which delivers the proven combination of industry insight, extensive real-world Oracle applications experience, deep technical skills, and high-performance servers and storage to create a complete business solution with a defined return on investment. From application selection, purchase, and implementation to upgrade and maintenance, we help organizations reduce the total cost of ownership and the complexity of managing their current and future applications environment while building a solid base for business growth. Oracle Database running on Linux is available for deployment on IBM LinuxONE by using Redhat Enterprise Linux (RHEL) or SUSE Linux Enterprise Server (SLES). This enterprise-grade solution is designed to add value to Oracle Database solutions. This IBM Redpaper® publication focuses on accepted good practices for installing and getting started by using Oracle Database, which provides you with an environment that is optimized for performance, scalability, flexibility, and ease-of-management.




Oracle API Management 12c Implementation


Book Description

Learn how to successfully implement API management using Oracle's API Management Solution 12c About This Book Explore the key concepts, goals, and objectives of API Management and learn how to implement it using the Oracle API Management Solution Understand the concepts and objectives of the Application Service Governance (ASG), along with the governance framework that encompasses people, processes, and technology Get to grips with API Management readiness assessments, gap analysis, digital reference architecture, and implementation roadmaps Who This Book Is For This book is for Enterprise Architects, Solution Architects, Technical Architects, and SOA and API consultants who want to successfully implement API Management using the Oracle API Management Solution products. What You Will Learn Understand how to manage a set of APIs Discover the differences and similarities between API Management and SOA Governance, and where and how these two disciplines converge into Application Services Governance (ASG) Grasp information about ASG and how to define an ASG governance framework Understand the challenges for organizations looking to expose APIs to the external world. Identify common scenarios and how to solve them Define an Oracle API management deployment topology Install and configure Oracle API Catalog (OAC), Oracle API Manager (OAPIM), and Oracle API Gateway (OAG) Learn about API subscriptions and API community management with the OAPIM portal Implement Oracle API Manager (OAPIM) including creation, publishing, management and deprecation of APIs In Detail Oracle SOA Governance is a comprehensive, service-orientated governance solution that is designed to make the transition to SOA easier. API management is the discipline that governs the software development lifecycle of APIs. It defines the tools and processes needed to build, publish and operate APIs including the management of the community of developers around it. This book illustrates how to successfully implement API Management in your organization. To achieve this, the importance of defining an API management strategy and implementation roadmap so that capabilities are implemented in the right order and timeframes is described. It starts by describing all of the fundamental concepts around API Management and related disciplines such as SOA Governance and DevOps in order to dispel the confusion surrounding these topics. The book then takes you on the journey of implementing API Management, using a realistic case study of an organization that needs an API Management solution. You will start by identifying the key business drivers to implement APIs and then create an API Management strategy and a roadmap to realize this strategy. You'll then go through a number of use cases, each focused on addressing specific business requirements. These will help you understand each of the Oracle API Management products, how they fit into an overall architecture, and how to implement them. The book concludes by providing some tips and guidelines around defining a deployment topology for the Oracle API Management products and the steps to install them. Style and approach This book is a comprehensive guide to successfully implementing a complete API Management solution from inception to implementation. The initial chapters introduce you to Oracle SOA Governance and API Management and from there, chapters are mainly hands-on and provide a full step-by-step walkthrough of how to implement the products of the Oracle API management solution to address realistic use cases.




Oracle PL/SQL Programming


Book Description

The authors have revised and updated this bestseller to include both the Oracle8i and new Oracle9i Internet-savvy database products.




Oracle 12c: SQL


Book Description

Introduce the latest version of the fundamental SQL language used in all relational databases today with Casteel’s ORACLE 12C: SQL, 3E. Much more than a study guide, this edition helps those who have only a basic knowledge of databases master the latest SQL and Oracle concepts and techniques. Learners gain a strong understanding of how to use Oracle 12c SQL most effectively as they prepare for the first exam in the Oracle Database Administrator or Oracle Developer Certification Exam paths. This edition initially focuses on creating database objects, including tables, constraints, indexes, sequences, and more. The author then explores data query techniques, such as row filtering, joins, single-row functions, aggregate functions, subqueries, and views, as well as advanced query topics. ORACLE 12C: SQL, 3E introduces the latest features and enhancements in 12c, from enhanced data types and invisible columns to new CROSS and OUTER APPLY methods for joins. To help readers transition to further studies, appendixes introduce SQL tuning, compare Oracle's SQL syntax with other databases, and overview Oracle connection interface tools: SQL Developer and SQL Plus. Readers can trust ORACLE 12C: SQL, 3E to provide the knowledge for Oracle certification testing and the solid foundation for pursuing a career as a successful database administrator or developer. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.




Database Administration


Book Description

Giving comprehensive, soup-to-nuts coverage of database administration, this guide is written from a platform-independent viewpoint, emphasizing best practices.




SQL Cookbook


Book Description

A guide to SQL covers such topics as retrieving records, metadata queries, working with strings, data arithmetic, date manipulation, reporting and warehousing, and hierarchical queries.