The Complete Oracle eBook Bundle

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. This course 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.

• Access 578 pages & 17 hours of content 24/7
• Install OBIEE in Windows & 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, & present it to end users on interactive dashboards
• Build pixel-perfect, printable reports using the embedded BI Publisher feature
• Build agents for actionable insight & 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 w/ the system management tools & methods available for the continuous improvement of your system

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.

• Access 428 pages & 12.5 hours of content 24/7
• Learn & understand the key SQL and PL/SQL features of Oracle Database 12c
• Understand the new Multitenant architecture & 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, & PL/SQL code tracing and profiling
• Implement Virtual Private Databases to prevent unauthorized data access
• Trace, analyze, profile, & debug PL/SQL code while developing database applications
• Integrate the new application development features of Oracle Database 12c w/ the current concepts
• Discover techniques to analyze & maintain PL/SQL code
• Get acquainted w/ the best practices of writing PL/SQL code & develop secure applications

GoldenGate exchanges data among systems in a timely manner and meets the demand for real-time access to information regardless of volume. The new release, 12c, includes an optimized database, intelligent and integrated delivery capabilities, expanded heterogeneity, and tighter security. Perform zero downtime data migration to on-premise or public cloud with GoldenGate’s feature-rich portfolio. Start with the installation and learn the design concepts and enhanced configuration of GoldenGate 12c. Exploit new 12c features to successfully implement GoldenGate on your enterprise. Dive deep into configuring GoldenGate for high availability, DDL support, and reverse processing. Build fast, secure, robust, scalable technical solutions by tuning data delivery and networks. Finally, enrich your data replication knowledge by learning the troubleshooting tips.

• Access 422 pages & 12.5 hours of content 24/7
• Extend GoldenGate’s out-of-the-box functionality to employ its rich features & meet your business objectives
• Deliver best-in-class data integration solutions by integrating GoldenGate w/ other Oracle products
• Deploy data integration solutions effectively to lower your total cost of ownership & increase your ROI
• Extend GoldenGate functionality through APIs & reduce your IT operational expenditure
• Leverage the designs to build efficient, cost-effective data integration solutions
• Enhance system management & monitoring in your GoldenGate environment
• Generate real-time statistics to gauge data throughput & performance
• Evaluate data integration concepts through Oracle’s new Integration Cloud Service offering

At times, DBAs support 100s of databases at work. In such scenarios, using a command-line tool like putty adds to the difficulty, while SQL Developer makes the life of a developer, DBA, or DB architect easier by providing a graphical user interface equipped with features that can bolster and enhance the user experience and boost efficiency. Features such as DBA panel, Reports, Data Modeler, and Data Miner are just a few examples of its rich features, and its support for APEX, REST Services, timesten, and third-party database drivers demonstrate its extensibility. You may be a newbie to databases or a seasoned database expert, either way this book will help you understand the database structure and the different types of objects that organize enterprise data in an efficient manner. This book introduces the features of the SQL Developer 4.1 tool in an incremental fashion, starting with installing them, making the database connections, and using the different panels. By sequentially walking through the steps in each chapter, you will quickly master SQL Developer 4.1.

• Access 344 pages & 10 hours of content 24/7
• Install & navigate through all the advanced features of SQL Developer that were introduced in version 4.1
• Browse, create, edit, & delete (drop) database objects
• Use the SQL worksheet to run SQL statements & scripts, edit and debug PL/SQL code, manipulate and export (unload) data
• Carry out all DBA-related activities such as exporting/importing, tuning, & analyzing database performance issues
• Quickly analyze, create, & edit the data model using data modeler
• Extend the SQL developer capabilities by exploring the APEX related pages, enabling & working w/ RESTful services
• Use the available reports & create new custom reports with custom scripts
• Grasp how to connect to third-party databases & work smoothly with them

Data replication is an important part of any database system that is growing due to today’s demand for real-time reporting and regulatory requirements. GoldenGate has recently become Oracle’s strategic real-time data replication solution. Until now, very little has been written about how to implement GoldenGate in a production enterprise environment where performance, scalability, and data integrity are paramount. This comprehensive practical book will deliver answers to your questions in a clear, concise style, allowing you to progress effectively in a timeline-driven environment. With this ebook in hand, you’ll be designing, installing, and configuring high-performance solutions using GoldenGate in less time than you can say “replicate”.

• Access 280 lectures & 8.5 hours of content 24/7
• Deliver high-speed data replication solutions
• Implement robust Disaster Recovery solutions
• Migrate applications w/ no data loss or downtime
• Configure GoldenGate for High Availability & Scalability
• Troubleshoot & solve data replication problems, including Conflict Handling and Error Detection
• Write your own GoldenGate macros & enhancements
• Configure multi-target replication from a single-source database

The three main responsibilities of a successful DBA are to ensure the availability, recoverability, and performance of any database. To ensure the recoverability of any database, a DBA needs to have a strong backup and recovery skills set. Every DBA is always looking for a reference book that will help them to solve any possible backup and recovery situation that they can come across in their professional life. “Oracle Database 12c Backup and Recovery Survival Guide” contains everything a DBA needs to know to keep data safe and recoverable, using real-life scenarios.

• Access 440 lectures & 13 hours of content 24/7
• Understand all the options available for the backup & recovery of a database to be used in case of a disaster and how to survive it
• Learn how to use RMAN & take advantage of its advanced functionalities
• Use Data Pump for more than just backups, learning how powerful this utility is
• Take advantage of Nologging operations in a safe & proper way
• Perform backups & recovery properly in Multitenant and non-CDB environments
• Take advantage of OEM12c & SQL Developer to fulfil your backup requirements and reduce risk in your organization
• Understand the new features in 12c offered for backup & recovery
• Get familiar w/ the available range of Oracle products for backup & recovery, not only RMAN

Oracle Data Integrator (ODI) is Oracle’s strategic data integration platform for high-speed data transformation and movement between different systems. From high-volume batches, to SOA-enabled data services, to trickle operations, ODI is a cutting-edge platform that offers heterogeneous connectivity, enterprise-level deployment, and strong administrative, diagnostic, and management capabilities. “Oracle Data Integrator 11g Cookbook” will take you on a journey past your first steps with ODI to a new level of proficiency, lifting the cover on many of the internals of the product to help you better leverage the most advanced features.

• Access 352 pages & 10.5 hours of content 24/7
• Understand how to install, secure, & deploy Oracle Data Integrator
• Explore the advanced features of ODI Topology, including creating new technologies & data types
• Learn many new ways to use variables in the product, including in Topology & Knowledge Modules
• Discover the inner workings of the code substitution in ODI to become more proficient w/ Knowledge Modules
• Get to grips w/ reusable coding best practices for interfaces & packages
• Find out more more about using XML & web services in ODI
• Leverage the SDK to expand your solutions
• Review many of the key concepts & best practices of ODI