Book Description:

Master the Powerful Multitenant Features of Oracle Database 12c

Govern a scalable, extensible, and highly available enterprise database environment using the practical information contained in this Oracle Press guide. Written by a team of Oracle Masters, Oracle Database 12c Release 2 Multitenant shows, step-by-step, how to deploy and manage multitenant configurations across IT frameworks of all types and sizes. Find out how to create databases, work with PDBs and CDBs, administer Oracle Net Services, and automate administrative tasks. Backup and recovery, security, and advanced multitenant options are covered in complete detail.

Learn how to:

• Build high-performance multitenant Oracle databases
• Create single-tenant, multitenant, and application containers
• Establish network connections and manage services
• Handle security using authentication, authorization, and encryption
• Back up and restore your mission-critical data
• Work with point-in-time recovery and Oracle Flashback
• Move data and replicate and clone databases
• Work with Oracle’s Resource Manager and Data Guard

Book Description:

* First book on the market that covers building high-performance Java applications on the Oracle database―using the latest versions of both the Oracle database (10g) and the JDBC API (3.0).

* Promotes and explains an “anti black box” approach to Oracle development complete with benchmark code) that will allow developers to write highly efficient, high performance Oracle JDBC applications.

* A new book from the prestigious OakTable Press, which Apress will be strongly promoting and supporting throughout 2004.

Book Description:

If you have mastered the fundamentals of the PL/SQL language and are now looking for an in-depth, practical guide to solving real problems with PL/SQL stored procedures, then this is the book for you.

Book Description:

* Encapsulates the knowledge and experience of some of the foremost experts in Oracle development, the vast majority of whom are also established and successful authors.

* Covers landmark software and techniques (invented by the authors) that have changed the face of Oracle development.

* A broad ranging, anecdotal and humorous title that will appeal to anyone (developers, DBAs, manager, architects etc) involved with and Oracle-based project.

* Simplified code snippets, the book provides real solutions that people can then build upon themselves.

Book Description:

This easy-to-understand tutorial covers Oracle Warehouse Builder from the ground up, and taps into the author’s wide experience as a software and database engineer. Written in a relaxed style with step-by-step explanations, lots of screenshots are provided throughout the book. There are numerous tips and helpful hints throughout that are not found in the original documentation. By following this book, you can use Oracle Warehouse Builder in the best possible way and maximize your learning potential. This book is an update of Oracle Warehouse Builder 11g: Getting Started. This book is a good starting point for database engineers, administrators, and architects who are responsible for data warehouse projects and need to design them and load data into them. If you are someone who wants to learn Oracle Warehouse Builder and expand your knowledge of the tool and data warehousing, this is an ideal book for you. No prior data warehouse or database experience is presumed. All new database and data warehouse technical terms and concepts explained in clear easy-to-understand language.

Book Description:

The new world of cloud computing needs data storage. CouchDB is the scalable, portable, simple database engine that is helping open source cloud architects put their data stores onto a firm foundation. Beginning CouchDBprovides the tools to begin using this very powerful database engine without having to pay license fees for the software, or worry about administrator’s certifications or vast hardware requirements. This book teaches the fundamentals of one of the most powerful database engines ever created for the price of a good lunch. After reading this book and working through the examples, you’ll be able to write your own applications for CouchDB quickly and easily.

• In-depth, non-intimidating guide to CouchDB and how it differs from similar offerings such as SimpleDB and BigTable, and also how it differs from traditional relational and object-oriented databases such as Oracle, SQL Server, and MySQL.
• Detailed explanation of how CouchDB works, its suitability for use in distributed environments, the role of Erlang, and other technical topics in a manner that does not obfuscate methods or results. JavaScript is extremely popular as a development language for CouchDB. No Erlang is required, but a little bit can’t hurt either.
• A tutorial-oriented approach to teaching readers how to use CouchDB, featuring many code examples and listings, as well as screenshots where relevant.

Book Description:

Tagline: Learn about analytic functions, the model clause, row pattern matching, and other powerful features in Oracle SQL

Table of Contents
Part I: Features and Theory
Chapter 1: Joins
Chapter 2: Query Transformations
Chapter 3: Analytic Functions
Chapter 4: Aggregate Functions
Chapter 5: Hierarchical Queries: Connect by
Chapter 6: Recursive Subquery Factoring
Chapter 7: Model
Chapter 8: Row Pattern Matching: match_recognize
Chapter 9: Logical Execution Order of Query Clauses
Chapter 10: Turing Completeness

Part II: PL/SQL and SQL solutions
Chapter 11: When PL/SQL Is Better Than Vanilla SQL
Chapter 12: Solving SQL Quizzes

Appendix A: Useful Oracle Links

Book Description:

Develop cloud-based applications rapidly using the Oracle Application Express (APEX) platform. This book bridges the gap for readers who have experience in developing simple applications but who lack the knowledge needed to develop a comprehensive system.

Cloud Computing Using Oracle Application Express will teach you how to develop a complete general ledger accounting system named The Cloud Accountant which will be accessible through a variety of devices, including desktops, laptops, and the latest smartphones. You will learn how to develop a functional application which can be deployed in your organization, and you will learn many new techniques to further enhance your APEX development skills.

Book Description:

Book Description:

Use this comprehensive guide to study for the Oracle WebLogic Server 12c Administration I Exam 1Z0-133. This book is a unique introductory resource to the WebLogic Server certification for new Oracle Fusion Middleware administrators and a valuable resource for veteran WebLogic Server administrators seeking to update their skills for the 12c certification topics.

It is common sense that passing a certification exam requires a good command of the subject matter, understanding the intricacies surrounding its practice, and having sufficient experience working with the concepts. This book aims to accelerate the process by providing an accurate review of all exam topics, suggesting hands-on practices to gain or reinforce experience working with WebLogic Server, and introducing questions to help candidates become familiar with the format and style of questions found on the actual certification exam.

Oracle WebLogic Server 12c Administration I Exam 1Z0-133 covers the associate level certification with Oracle. Although not dedicated to exam 1Z0-599, the guide is also a valuable foundational resource for those preparing for WebLogic Server 12c implementation specialist level certification. This book:

• Inspects the certification topics in the order that you would likely follow in an on-the-job middleware infrastructure project
• Is a great resource for candidates preparing for the certification, who are unable to start with live or personally-assisted training
• Is a great starting point for those pursuing advanced Oracle WebLogic Server certifications

What You’ll Learn

• Cover all topics on the certification exam 1Z0-133
• Become familiar with the types and format of questions on the certification exam
• Understand and properly describe Oracle WebLogic Server domains and clusters
• Install, configure, maintain, and m

onitor Oracle WebLogic Server

• Deploy and manage applications on Oracle WebLogic Server
• Discover how to use new administration features of Oracle WebLogic Server 12c

Who This Book Is For

Certified Oracle WebLogic administrators seeking to update their Oracle WebLogic Server credentials, as well as experienced WebLogic Server administrators seeking to earn certification for the first time. Non-Oracle administrators seeking to earn a WebLogic Server certification will also find this book useful.

Book Description:

Book Description:

Book Description:

Businesses around the world are paying much greater attention toward database security than they ever have before. Not only does the current regulatory environment require tight security, particularly when dealing with sensitive and personal data, data is also arguably a company’s most valuable asset – why wouldn’t you want to protect it in a secure and reliable database? Oracle Database lets you do exactly that. It’s why it is one of the world’s leading databases – with a rich portfolio of features to protect data from contemporary vulnerabilities, it’s the go-to database for many organizations.

Oracle Database 12c Security Cookbook helps DBAs, developers, and architects to better understand database security challenges. Let it guide you through the process of implementing appropriate security mechanisms, helping you to ensure you are taking proactive steps to keep your data safe. Featuring solutions for common security problems in the new Oracle Database 12c, with this book you can be confident about securing your database from a range of different threats and problems.

Who This Book Is For

This book is for DBAs, developers, and architects who are keen to know more about security in Oracle Database 12c. This book is best suited for beginners and intermediate-level database security practitioners. Basic knowledge of Oracle Database is expected, but no prior experience of securing a database is required.

What You Will Learn

• Analyze application privileges and reduce the attack surface
• Reduce the risk of data exposure by using Oracle Data Redaction and Virtual Private Database
• Control data access and integrity in your organization using the appropriate database feature or option
• Learn how to protect your databases against application bypasses
• Audit user activity using the new auditing architecture
• Restrict highly privileged users from accessing data
• Encrypt data in Oracle Database
• Work in a real-world environment where a multi-layer security strategy is applied

Book Description:

Book Description:

Follow this guide that explains Oracle’s Infrastructure as a Service (IaaS) cloud solution and the tools and capabilities that can help you increase business value, productivity, and performance. You will learn about economic advantages as well as elasticity, unlimited storage, and on-demand capacity computing.

Oracle IaaS: Quick Reference Guide to Cloud Solutions covers Oracle’s service structure as well as its cloud service offerings and cloud models.  It provides detailed guidance regarding the advantages of the specific models, as well as how to create and manage each service. This book contains many real-world case studies, including how to build and configure compute resources to fit the needs of your specific organization. IaaS product offerings covered in this book include:

• Oracle Compute Cloud
• Oracle Storage Cloud
• Oracle Ravello Cloud
• Oracle Container Cloud

What You’ll Learn

• Understand Oracle IaaS products and Oracle Cloud
• Compare existing Oracle cloud products
• Discover IaaS new features
• Master Oracle Cloud Architecture

Who This Book Is For

Oracle database administrators, Oracle developers, and other developers looking to build cloud-based applications.

Book Description:

Best Practices for Oracle WebLogic Server 12c Configuration and Administration

Maintain a high-performance enterprise application framework using the detailed information in this authoritative resource. Through expert instruction and real-world examples, Oracle WebLogic Server 12c Administration Handbook fully explains the latest management tools and techniques. Learn how to work from the Oracle WebLogic Server Administration Console or command line, configure servers and clusters, deploy applications, and optimize application performance. Tuning, troubleshooting, and load balancing are thoroughly covered in this Oracle Press guide.

• Install Oracle WebLogic Server 12c or perform an upgrade
• Manage domains, server instances, networks, and virtual hosts
• Work with the WebLogic Scripting Tool feature and Node Manager
• Build custom network channels and resource adapters
• Monitor performance with the WebLogic Diagnostics Framework feature
• Prioritize requests using Oracle WebLogic Server Work Managers
• Configure Oracle WebLogic clusters and migrate servers and services
• Deploy web applications, Enterprise JavaBeans, and Java EE modules
• Establish security realms and authenticate and authorize users
• Allocate memory, optimize throughput, and tune the Java Virtual Machine

Book Description:

Maximize Application Performance on Oracle Exadata

Written 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. Deliver unparalleled 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

Book Description:

A practical roadmap for database upgrade, migration, and transformation

This 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

Book Description:

Master Oracle SOA Suite 12c

Design, implement, manage, and maintain a highly flexible service-oriented computing infrastructure across your enterprise using the detailed information in this Oracle Press guide. Written by an Oracle ACE director, Oracle SOA Suite 12c Handbook uses a start-to-finish case study to illustrate each concept and technique. Learn expert techniques for designing and implementing components, assembling composite applications, integrating Java, handling complex business logic, and maximizing code reuse. Runtime administration, governance, and security are covered in this practical resource.

• Get started with the Oracle SOA Suite 12c development and run time environment
• Deploy and manage SOA composite applications
• Expose SOAP/XML REST/JSON through Oracle Service Bus
• Establish interactions through adapters for Database, JMS, File/FTP, UMS, LDAP, and Coherence
• Embed custom logic using Java and the Spring component
• Perform fast data analysis in real time with Oracle Event Processor
• Implement Event Drive Architecture based on the Event Delivery Network (EDN)
• Use Oracle Business Rules to encapsulate logic and automate decisions
• Model complex processes using BPEL, BPMN, and human task components
• Establish KPIs and evaluate performance using Oracle Business Activity Monitoring
• Control traffic, audit system activity, and encrypt sensitive data

Book Description:

Design and Deliver Effective Visual Solutions of BI Data

Cowritten by an Oracle ACE Director and an expert in data visualization design specializing in BI and analytics, Data Visualization for Oracle Business Intelligence 11g reveals best practices for presenting data-driven insights with graphs, tables, maps, dashboards, and other methods that will immediately enhance corporate decision-making. Throughout the book, the principles of effective design are emphasized. Leverage the power of this comprehensive business intelligence platform to deliver rich visualizations of business information across the enterprise.

• Create well-organized tables and pivot tables
• Convey data insights with line, bar, pie, waterfall, radar, and other graphs
• Configure MapViews so that you can provide interactive maps and spatial analysis capabilities
• Build advanced visualizations, including trellis charts, gauges, R images, jQuery sparklines, and more
• Use Oracle Business Intelligence Publisher to create pixel-perfect reports from various data sources
• Design effective, interactive BI dashboards
• Use the Oracle Scorecard and Strategy Management module to measure, evaluate, and manage key performance indicators
• Make smart color choices using data science tools