Table of Contents
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web streaming, mobile streaming, download for offline access
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
Requirements
- Internet required
THE EXPERT
Instructor
Christian Screen (@christianscreen) is an Oracle ACE, technologist, and Business Intelligence evangelist with over 20 years of experience in technology ranging from low-level programming, e-commerce, Data Warehousing, Hyperion Enterprise Performance Management, product management, IoT, and of course, analytics. Founder of Art of BI Software and Consulting Group, one of Oracle’s top Oracle Analytics partners in North America, his company was acquired by Datavail (@datavail) Corporation in 2016.
In his spare time, he enjoys writing technical articles, learning new technologies, inventing new products, writing software, spending time with his family, trying to change the world, and running his blog and podcast which are read and heard all across the globe.
Haroun Khan is one of Europe’s leading OBIEE consultants. A computer science graduate of Imperial College, London, he has been involved with OBIEE from its early days as an acquisition from nQuire by Siebel, and subsequently as part of the Oracle family. Haroun worked as a consultant on projects worldwide for Siebel and as a Principal Consultant for Oracle over a period of 10 years. He has specialized in BI and data warehousing over a longer period including time working at MicroStrategy.
Haroun is also an entrepreneur, successfully founding and currently running the online travel site https://www.jrpass.com/. His experience in e-commerce has given him new insight into how analytics is vital to the running of any business nowadays. He engages with cohort analysis, clickstream analytics, and conversion tracking.
He still freelances in leading and designing projects in the traditional BI and data warehousing space. In his downtime, Haroun likes to climb, is an avid squash player, and can sometimes be found prone, deep in despair, as he tries his hands at writing a novel.
Adrian Ward is an Oracle ACE Associate who started working in Siebel Analytics back in 2001 and quickly realized the potential in the technology. He formed the UK’s first independent consultancy focusing purely on OBIEE (nee Siebel Analytics) and Oracle BI Applications. He has led many large successful OBIEE implementations in a wide range of business sectors, from investment banking to military operations. His deep technical OBIEE and BI Applications knowledge has been applied on dozens of projects throughout the globe, including HR, Sales, Service, Pharma, and Custom Analytics, which is enabling hundreds of thousands of users in their day-to-day roles.
He was also one of the first bloggers on Oracle BIEE at http://www.obiee.info and today runs the Addidici OBIEE consultancy, which has operations in the UK, Europe, and South Africa. Adrian runs one of the largest Oracle BI networking groups on LinkedIn — Oracle Business Intelligence, is an active tweeter (@Addidici), is a speaker at Oracle conferences, and helps others learn.
In his spare time, he loves sailing at Hayling Island, skiing, enjoying life with his family, and learning new technologies.
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web streaming, mobile streaming, download for offline access
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
Requirements
- Internet required
THE EXPERT
Instructor
Saurabh K. Gupta is a seasoned database technologist with extensive experience in designing high performance and highly available database applications. His technology focus has been centered around Oracle Database architecture, Oracle Cloud platform, Database In-Memory, Database Consolidation, Multitenant, Exadata, Big Data, and Hadoop. He has authored the first edition of this book. He is an active speaker at technical conferences from Oracle Technology Network, IOUG Collaborate’15, AIOUG Sangam, and Tech Days. Connect with him on his twitter handle (or SAURABHKG) or through his technical blog www.sbhoracle. wordpress.com, with comments, suggestions, and feedback regarding this book.
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web streaming, mobile streaming, download for offline access
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
Requirements
- Internet required
THE EXPERT
Instructor
John P Jeffries has worked in many countries around the world, consulting on the Oracle technology. He is interested in different cultures and enjoys teaching others. At present, John lives and works in Singapore and is employed as a subject matter expert at a global bank, delivering enterprise-wide infrastructure design solutions, particularly in the database private cloud and data replication space. Since he wrote his first book, Oracle GoldenGate 11g Implementer’s Guide, he has been heavily focused on leveraging Oracle’s Fusion Middleware products (including GoldenGate) to address performance, data migration, and data delivery issues.
With over 15 years of experience in Oracle, John has worked for a number of global organizations, such as BT, Siebel Systems, Dell, Thomson Reuters, and Oracle Corporation, to name a few. At Oracle, he worked in advanced customer services on key accounts as a senior principal consultant and became the UK data replication expert, often publishing articles on his own website (http://oracle11ggotchas.com/).
John is an Oracle Certified Professional and a GoldenGate specialist. He gives presentations at ODTUG conferences and continues to share his real-life hands-on experience through his work. Known for his ability to provide robust, effective solutions and workarounds, John delivers his knowledge, tips, and tricks in his new book, Oracle GoldenGate 12c Implementer’s Guide.
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web streaming, mobile streaming, download for offline access
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
Requirements
- Internet required
THE EXPERT
Instructor
Ajith Narayanan is the chief technology officer (CTO) of InfraStack-Labs in Bangalore, India, and has more than 11 years of work experience as an Oracle [apps] DBA and platform architect with expertise in infrastructure architecture, capacity planning, and performance tuning of medium to large e-business suite environments.
He holds a postgraduate degree with PGDBA (finance) from Symbiosis, Pune, an M.S. (software systems) from BITS Pilani, a BE (electronics and communication) from Amrita Institute of Technology, and a diploma (computer technology) from Sree Narayana Guru Institute of Technology.
He has worked in different technical positions as an Oracle DBA, APPS DBA, Oracle apps platform architect, and configuration management technical leader in companies such as GE, Dell, JP MorganChase, Oracle, and TCS. Ajith was at GE before joining InfraStack-Labs.
He is also a regular speaker at national and international Oracle user group conferences such as SANGAM, NZOUG, DOAG, UKOUG, OTN APAC Tour, AIOUG Tech Days, and so on. His white papers have been published on the Oracle Technology Network in English, Portuguese, and Spanish. Ajith is currently serving the ORACLERACSIG board as the web seminar chair (from October 2015), and has previously served the board as the website chair (September 2011 to September 2013).
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web streaming, mobile streaming, download for offline access
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
Requirements
- Internet required
THE EXPERT
Instructor
John P Jeffries has worked in many countries around the world, consulting on the Oracle technology. He is interested in different cultures and enjoys teaching others. At present, John lives and works in Singapore and is employed as a subject matter expert at a global bank, delivering enterprise-wide infrastructure design solutions, particularly in the database private cloud and data replication space. Since he wrote his first book, Oracle GoldenGate 11g Implementer’s Guide, he has been heavily focused on leveraging Oracle’s Fusion Middleware products (including GoldenGate) to address performance, data migration, and data delivery issues.
With over 15 years of experience in Oracle, John has worked for a number of global organizations, such as BT, Siebel Systems, Dell, Thomson Reuters, and Oracle Corporation, to name a few. At Oracle, he worked in advanced customer services on key accounts as a senior principal consultant and became the UK data replication expert, often publishing articles on his own website (http://oracle11ggotchas.com/).
John is an Oracle Certified Professional and a GoldenGate specialist. He gives presentations at ODTUG conferences and continues to share his real-life hands-on experience through his work. Known for his ability to provide robust, effective solutions and workarounds, John delivers his knowledge, tips, and tricks in his new book, Oracle GoldenGate 12c Implementer’s Guide.
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web streaming, mobile streaming, download for offline access
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
Requirements
- Internet required
THE EXPERT
Instructor
Aman Sharma is an Oracle Database consultant and instructor. He holds a Master’s degree in Computer Applications and has been working with Oracle Database for over a decade. His main focus is to understand how Oracle Database works internally. Besides the core database, he has a very strong knowledge of Linux, Solaris, Oracle RAC, Data Guard, RMAN, Oracle Exadata and Oracle Enterprise Manager. He is an Oracle Certified Professional and also an Oracle Certified Expert in Oracle RAC, SQL and Linux. He is also an Oracle Certified Implementation Specialist and a certified Solaris System Administrator. He loves to share his learning with the Oracle community, so when he is not delivering an Oracle= related session, he spends a lot of his time participating in OTN (Oracle Technology Network) discussion forums. He also maintains an Oracle blog (http://blog.aristadba.com), is also on Twitter (@amansharma81), you can reach to him using either ways. He is a strong supporter of user groups and is a member of India Oracle Users Group (http://www.aioug.org) and has been a speaker at various Oracle conferences organized by AIOUG. He is also an associate member of IOUG (http://www.ioug.org). In 2010, he was awarded the prestigious Oracle ACE award from Oracle Corporation.
Francisco Munoz Alvarez has over two decades of experience in consulting, analysis, support, implementation, and migration of Oracle products. He is also an expert in most phases of a database life cycle, for example, development, stabilization, security, backup and recovery, tuning, installations, and data warehouse (ETL) with excellent implementation and support methodologies. He is a popular speaker at many Oracle conferences around the world. He is also the President of CLOUG (Chilean Oracle Users Group), LAOUC (Latin American Oracle Users Group Community, which is the umbrella organization for all of Latin America), and NZOUG (New Zealand Oracle Users Group). He worked as an Associate Technologist for Oracle in Brazil and Chile. He was an Oracle instructor for the New Horizons Centre (Chile) and for Oracle Education (Brazil and Chile). He also worked in the first team to introduce Oracle to South America (Oracle 6 and the beta version of Oracle 7). He was also the first Master Oracle 7 Database Administrator in South America, as well as the first Latin American Oracle professional to be awarded a double ACE (ACE in 2008 and ACE Director in 2009) by Oracle HQ. In 2010, he had the privilege to receive a prestigious Oracle Magazine Editor’s Choice Award as the Oracle Evangelist of the Year—a huge recognition for his outstanding achievements in the Oracle world that includes the creation and organization of the already famous OTN Tours that are the biggest Oracle evangelist events in the world. Currently, Francisco works for Revera Limited, which is a leading provider of utility computing infrastructure and enterprise data management in New Zealand, as the Oracle Professional Services Manager since June 2011. He also maintains an Oracle blog (http://www.oraclenz.org) and you can always contact him through this or Twitter (@fcomunoz) regarding any questions about this book.
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web streaming, mobile streaming, download for offline access
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
Requirements
- Internet required
THE EXPERT
Instructor
Peter C. Boyd-Bowman is a Technical Director and Consultant with the Oracle Corporation. He has over 30 years of software engineering and database management experience, including 12 years of focused interest in data warehousing and business intelligence. Capitalizing on his extensive background in Oracle database technologies dating back to 1985, he has spent recent years specializing in data migration. After many successful project implementations using Oracle Warehouse Builder, and shortly after Oracle’s acquisition of the Sunopsis Corporation, he switched his area of focus over to Oracle’s flagship ETL product: Oracle Data Integrator. Peter holds a BS degree in Industrial Management and Computer Science from Purdue University and currently resides in North Carolina. Peter is a co-author of the book Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial.
Julien Testut is a Product Manager in the Oracle Data Integration group focusing on Oracle Data Integrator. Julien has an extensive background in Data Integration and Data Quality solutions and is a co-author of Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial. Prior to joining Oracle, he was an Applications Engineer at Sunopsis, which was then acquired by Oracle. Julien holds a Masters degree in Software Engineering.
Denis Gray is a Director of Product Management for Data Integration at Oracle. Denis has over 15 years of experience in the data-integration field. For the past seven years, Denis has been an integral part of Oracle Development Organization as a Product Manager within Fusion Middleware, delivering data integration solutions. Prior to this, Denis was a data integration consult for Hyperion Solutions (Oracle). Here, Denis worked at many of the largest Fortune 100 companies, building data warehouses and implementing business intelligence solutions. Denis has a Bachelor’s Degree in Computer Science from the University of Missouri and currently resides in St. Louis, MO. Denis also co-authored the Packt book Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial.
Christophe Dupupet is a Director in the Fusion Middleware Architects Team, where he leads the expertise on ODI. The team works closely with strategic customers that implement ODI, and helps define best practices on the product in terms of architecture, implementation, and operations. Prior to Oracle, Christophe was part of the team that started the operations for Sunopsis in the US, where he lead the technical team (presales, support, and training). Sunopsis was acquired by Oracle in 2006. Christophe holds an Operations Research degree from EISTI in France, a Masters Degree in Operations Research from Florida Tech, and a certificate in Management from Harvard University.
Pay What You Want: The Complete Oracle eBook Bundle for $1
Leave a Reply