Oracle

Participants learn to use Warehouse Builder to define both relational dimensional models and multidimensional models, deploy a single logical model to multiple physical targets using multiple named configurations and how to handle slowly changing dimensions. Extraction of data from non-Oracle sources using code templates, usage of the Warehouse Builder ETL and data integration features of the Enterprise ETL Option of the Oracle database are discussed. Participants also use Warehouse Builder to define both relational dimensional models and multidimensional models. This functionality requires the Oracle Warehouse Builder Enterprise ETL/ODI EE option. Learn To: Use Warehouse Builder to define both relational dimensional models and multidimensional models Deploy a single logical model to multiple physical targets using multiple named configurations Handle slowly changing dimensions Extract data from non-Oracle sources using code templates Use the Warehouse Builder ETL and data integration features of the Enterprise ETL Option of the Oracle database Use Warehouse Builder to define both relational dimensional models and multidimensional models A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

This Predictive Analytics using Oracle Data Mining Ed 1 training will review the basic concepts of data mining. Expert Oracle University instructors will teach you how to leverage the predictive analytical power of Oracle Data Mining, a component of the Oracle Advanced Analytics option. Learn To: Explain basic data mining concepts and describe the benefits of predictive analysis. Understand primary data mining tasks, and describe the key steps of a data mining process. Use the Oracle Data Miner to build, evaluate, apply, and deploy multiple data mining models. Use Oracle Data Mining’s predictions and insights to address many kinds of business problems. Deploy data mining models for end-user access, in batch or real-time, and within applications.

This Oracle GoldenGate 12c: Management Pack Overview training introduces you to GoldenGate management. Once a GoldenGate installation is up and running, you'll learn how it must be monitored, maintained and managed Install and configure GoldenGate instances. Use Oracle GoldenGate Monitor. Use Enterprise Manager Cloud Control to administer replication. Report on alerts. Generate statistics. Examine the history of GoldenGate installation.

The course covers the Oracle GoldenGate 12c (12.3) Java adapter and Big Data/NoSQL modules which allow relational databases to integrate with the Hadoop ecosystem and NoSQL databases such as MongoDB and Cassandra. Each Hadoop component or NoSQL database is adequately introduced, the various parameters and configuration options are explained and where appropriate best practices are demonstrated. Lab practices complete the didactic experience of students who have the chance to configure and perform data replication between an Oracle RDBMS (relational database management system) and the various technologies supported by the Oracle GoldenGate for Big Data software.

This Oracle Enterprise Data Quality 12c: Profile, Audit and Operate training teaches you how to understand, check and cleanse the quality of your data with Oracle Enterprise Data Quality. Learn how to import, profile, audit, transform and export data and to create Oracle Enterprise Data Quality processes and jobs. Identify data problems and check data validity. Import and export data. Check data quality using audit processors. Create data quality processes and jobs to run in batch and real-time. Reuse configuration in different processes. Transform data for auditing. Set up audit checks on the data and export the data. Deploy strategies to re-use your work by publishing processors, creating and importing packages and making use of data interfaces and run profiles. Understand Oracle Enterprise Data Quality's Server Console user interface and its Customer Data Extension Pack. By taking this course, you'll develop the knowledge and skills that allow your business to automate data quality processes using jobs that run in batch, saving time and energy. You'll know how to configure web services to run data quality processes in real-time.

This Oracle GoldenGate 12c training covers installing and configuring advanced features of the product, including active-active replication and conflict detection/resolution. Explore in more depth topics introduced in the fundamentals course, such as Event Marker and Advanced Data Transformation techniques. Implement 3-way, Multi-Master configurations and experiment with Oracle RAC, integrating Oracle GoldenGate with Oracle clusters. Configure Oracle GoldenGate replication in a multi-tenant database supporting pluggable databases (PDBs.) Enrolling in this Oracle GoldenGate 12c training will help you develop your installation and configuration skills. By interacting with top Oracle instructors, you will be able to ask questions as you learn to solidify your understanding. Learn How To: Explain Oracle GoldenGate advanced configuration options. Describe and take advantage of the Integrated Capture feature and the recently introduced Integrated Replicat feature to replicate complex data types and compressed data. Integrate the Database File System (DBFS) with Oracle GoldenGate to achieve Maximum Availability. Configure and implement the Oracle GoldenGate Event Marker system. Enable data transformation based on event records in the transaction logs or in the trail files. Perform zero-downtime database migration. Set up and manage advanced deployment models, like 3-node multi master replication configuration. Master Oracle GoldenGate facilities to detect and resolve data conflicts in active-to-active replication implementations. Use a simulated Oracle RAC configuration to experiment with the Oracle GoldenGate Clusterware-aware facilities, which ensure seamless data replication in case of node failure. Benefits to You Integrate your organization's disparate data across heterogeneous databases for improved decision-making. Become more efficient at configuring and implementing the more advanced features of Oracle GoldenGate used together with the Oracle RDBMS 12c. Enable Zero-Downtime Migration Enable Zero-Downtime Migration: this course also allows you to simulate a system upgrade. You will develop the skills needed to survive an aborted migration, incurring zero data loss. Hone these skills by engaging in hands-on demonstrations and exercises. Active-Active Replication and CDR You will also build two-way and three-way active-active replication configurations. Explore both basic and advanced conflict detection and resolution (CDR). Review basic product-provided CDR, with more advanced custom CDR techniques implemented using SQLEXEC and stored procedures. Configure Integrated Extract Groups Configure Integrated Extract Groups and Integrated Replicat groups: the Integrated Extract feature and the recently introduced Integrated Replicat feature are also covered in depth. You will learn to configure integrated extract groups operating in both local and downstream deployment modes and to configure Integrated Replicat groups, which enable automatic, dependency-aware parallel apply streams for dramatically improved data delivery performance. Learn to Utilize Advanced Features Upon completing this course, you will be able to utilize the more advanced features of Oracle GoldenGate 12c, including: integrated capture, integrated delivery, active-active replication, conflict detection and resolution, DDL/DML replication, Oracle GoldenGate event marker subsystem, advanced data manipulation and transformation techniques and advanced data mapping. In addition, you will use a simulated Oracle RAC configuration to experiment with the Oracle GoldenGate Clusterware-aware facilities, which ensure seamless data replication in case of node failure.

This Oracle GoldenGate 12c Troubleshooting and Tuning training teaches you how to gather and examine evidence; you’ll also learn to solve case problems, diagnose their cause and find methods of resolution. Each of these practices challenges you to diagnose and troubleshoot the issue using GoldenGate software. Learn To: Use GGSCI commands for gathering process evidence. Use the Oracle GoldenGate troubleshooting tools like Knowledge Documents, Documentation, SHOWSYNTAX parameter and the Logdump utility. Troubleshoot problems in areas such as extraction, replication, missed transactions, mapping, synchronization, SQLEXEC, file maintenance and more. Identify what causes slow startups. Monitor lag and statistics. Identify network and disk bottlenecks. Perform tuning of Manager, Extract and Replicate. Diagnose and tune the latest Integrated Extract, available since release 11.2.0.4 of the Oracle RDBMS, and Integrated Replicat, available since release 12c of the Oracle RDBMS. Benefits to You By enrolling in this course, you'll develop deeper knowledge of Oracle GoldenGate 12c performance tuning methods. Expert instructors will teach you how to identify the causes of slow startups, evaluate lag statistics and solve network and disk bottlenecks. Utilize all of the existing GoldenGate tools, such as GGSCI and Logdump, the health check scripts and the Streams Performance Advisor (UTL_SPADV) to troubleshoot system issues occurring to both classic extract/replicat and integrated extract/replicate. Explore Platforms This training is on a Linux platform; however many of the troubleshooting techniques are equally applicable to a Windows or iSeries platform. The databases used for source and target are Oracle 12cR1. Many of the techniques are also applicable to DB2, SQL Server, MySQL, etc.

The Exalogic engineered system provides your mission-critical applications with a high performance, reliable, and secure ecosystem. Oracle Exalogic Elastic Cloud 2.x for Architects helps ensure that IT organizations can successfully integrate their applications into this unique environment that includes InfiniBand networks, ZFS storage, and virtual data centers. Learn To: Create an Exalogic implementation road map. Design Exalogic accounts and vServers to support an application. Identify key best practices related to Exalogic networking and storage. Plan for backup, disaster recovery, and patches. IT Road Map Identify the core design decisions and implementation tasks for Exalogic deployments, from installation through production, maintenance, and disaster recovery. Multitenancy Design accounts, vServers, networks, and distribution groups to support an implementation. Learn how best to isolate network and storage data within a shared Exalogic infrastructure. Networks and Storage Design public and private networks on the InfiniBand fabric along with NFS projects and shares on the Exalogic storage appliance.

This Oracle Exalogic Elastic Cloud 2.x: Middleware Deployment training teaches you how to effectively implement an Oracle Fusion Middleware application on the Oracle Exalogic platform. Use a hands-on learning approach to deploy a typical middleware application that takes advantage of the unique storage, network and cloud characteristics of Exalogic. Note: No hands on lab environment for the TOD course. Learn To: Plan, implement and tune the Fusion Middleware on a Virtual Data Center. Configure shared storage and hosts to support Oracle middleware. Identify the Middleware Cloud Assets to support the deployment. Create Accounts, Virtual Networks, Virtual Servers and Distribution Groups. Work with SDP, RDMA, and IMB to optimize the performance and sclability of WebLogic Server, Coherence and Tuxedo. Install and Configure Oracle Traffic Director to intelligently load balance traffic to a middleware cluster.

This Exalogic Elastic Cloud training gives you the skills to create and use cloud resources in a virtual data center. Learn how to use Exalogic Control to manage virtual accounts, networks, storage and servers. Note: No hands on lab environment for the TOD course. Companies want to realize the benefits of a private cloud but at the same time avoid the risks in building such a complex infrastructure. Exalogic Elastic Cloud: Cloud Management teaches you about a comprehensive virtual data center solution that's also secure and easy to use. Learn To: Use Exalogic's Infrastructure as a Service (IaaS) capabilities. Provision and monitor accounts in a virtual data center. Create and use virtual network and storage resources. Create and manage virtual servers. Benefits to You Optimize your virtual data center using best practices for cloud management. Better understand the aspects of Exalogicâ™s virtual networks, storage volumes, virtual servers, and more, so that your organization can reap the benefits of a private cloud, but avoid the risks. Self-Service IT This course will teach you how to use the Exalogic Control browser interface to quickly deploy all of your applications on the Exalogic hardware as virtual servers. Develop these new skills through in-class lectures and hands-on exercises. Multi-Tenancy Enrolling in this course will also allow you to explore the use of cloud accounts to control resource usage. You'll learn to maintain application isolation in your cloud through virtual networks and virtual storage. Automation Through hands-on exercises led by expert Oracle instructors, find out how to use the Exalogic Control command line interface to script and automate common cloud management tasks. Interact with instructors through open Q & A sessions that allow you to dig deeper into the Oracle Exalogic Elastic Cloud. This course is appropriate for X2-2, X3-2, and X4-2 users.

This Exalogic Elastic Cloud training gives data center administrators the necessary skills to configure, manage, and monitor the hardware and software components of Oracle Exalogic. Learn how to apply Oracle's best practices regarding shared storage, networking, high availability, and backup and recovery. Note: No hands on lab environment for the TOD course. This Oracle Exalogic Elastic Cloud 2.x: System Administration training helps you develop a deeper understanding of how Exalogic Elastic Cloud provides a high performance, high density, reliable and scalable data center solution based on ZFS storage, InfiniBand networking, Oracle VM and Oracle Linux. These unique components require specialized knowledge and skills; please note that this course is appropriate for X2-2, X3-2 and X4-2 users. Learn To: Describe the initial configuration an Exalogic machine. Connect to and manage all Exalogic hardware components. Configure, mount, and monitor ZFS storage shares. Configure and monitor InfiniBand networks. Perform backup and recovery on an Exalogic system. Benefits to You Painlessly and seamlessly integrate Exalogic into your existing data center. Develop the knowledge and skills to use the right tools to monitor, secure and troubleshoot Exalogic systems, including the hardware and virtualization infrastructure. Explore Shared Storage Use the Oracle ZFS Storage Appliance to create shared file systems. Mount shared storage to hosts, and then monitor storage health and performance. Learn InfiniBand Networking Gain insight into the unique configuration and performance characteristics of Exalogic InfiniBand (IB). Monitor gateway and spine switches, including VNICs, VLANs, and partitions. Understand Lifecycle Management Perform regular system health checks and backups, and restore components if problems occur. Gather logs and other diagnostic information to help troubleshoot issues.

This Oracle Data Integrator course covers advanced techniques for using Oracle Data Integrator 12c (ODI). You learn how to implement high-performance movement and transformation of data among various platforms. Learn how to: Develop and customize Knowledge Modules with substitution methods and Java Perform data integration and transformation among various platforms using advance techniques Design advanced ODI mappings, procedures, and packages to perform EL-T data transformations Use variables to create reusable packages Automate ODI tasks by using the Groovy script editor Extract data from different types of complex file Use ODI web services and perform integration of ODI in an enterprise environment and SOA Set up ODI security by implementing a strongly secured approach with non-generic profiles and external user authentication Implement integration strategies with ODI by using best practices and an example using GoldenGate Create and populate cubes and dimensions

This Using Oracle Enterprise Manager Cloud Control 13c training teaches you how to use Enterprise Manager Cloud Control to monitor and manage your enterprise-computing environment. You'll learn how to use the Cloud Control framework, the out-of-box capability to manage Oracle targets, individually or in groups with templates, monitor the compliance of targets, use the job system to automate commonly performed tasks, view and compare configurations and create and use predefined and customized reports. Learn To: Navigate and monitor the overall health of your Cloud Control system.  Organize targets and groups. Setup targets monitoring, alerts and notifications. Use the job system to create and manage jobs to automate commonly performed tasks.  View, search and compare configurations. Explain provisioning and manage targets patching. Use compliance policies and evaluate policy violations. Use BI Publisher to generate custom reports.

This Oracle Data Integrator workshop details the new features and techniques of using Oracle Data Integrator 12c (ODI) for implementing high-performance movement. Expert Oracle University instructors will help you explore transformation of data among various platforms. Learn To: Perform transformation of data among various platforms using Oracle Data Integrator 12c . Design ODI Mappings and Packages to perform ELT data transformations. Debug and troubleshoot ODI mappings and packages using Step by Step debugger. Perform data integration and transformation among various platforms using advanced techniques. Integrate ODI 12c with Oracle Warehouse Builder, Oracle GoldenGate and OPSS Enterprise Roles. Create ODI agents using Common Administration Model.

Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services. Oracle Data Integrator’s Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process and transform the data – the approach that optimizes performance, scalability and lowers overall solution costs. Learn To: Use Oracle Data Integrator to perform transformation of data among various platforms. Design ODI mappings, procedures, and packages to perform ELT data transformations. Administer ODI resources and set up security with ODI. Perform data integration and transformation among various platforms. Use the ODI graphical interface to define procedures, packages, and ELT jobs. Set up and maintain a secure, multi-user ODI environment. Implement changed data capture with ODI. Use ODI Web services and perform integration of ODI with SOA.

This Oracle WebLogic Server 12c: Administration II training is a continuation of Oracle WebLogic Server 12c: Administration I. It teaches you how to perform important administrative tasks, employing best practices that enable you to make the most of your WebLogic applications. Learn To: Upgrade WebLogic products without disrupting client applications. Create and use domain templates. Deploy shared libraries and applications using advanced deployment techniques. Configure advanced JDBC features. Create and run WLST scripts. Interact and manage WLS using REST. Configure and use Coherence*Web and managed Coherence servers. Create and work with simple domain partitions.

This Oracle Enterprise Data Quality 12c: Match and Parse training (based on Oracle Enterprise Data Quality version 12.1.3) teaches you how to configure match processors to find and optionally merge exact and similar (fuzzy) matching records. You’ll learn how to create sophisticated match rules, configure merge options and review match results. Learn To: Configure match processors to identify and optionally merge matching records. Use parse processors to extract key data from free text fields. Use the address verification processor and interpret its results. Standardize data using a number of Oracle Enterprise Data Quality processors. Use and interpret results from the Oracle Enterprise Data Quality Address Verification server. Tailor a customer data extension pack parse processor to extract, standardize and re-structure data from a free text field. Configure the Parse processor from scratch. Reach a semantic understanding of free text by using the Phrase Profiler. Understand EDQ’s Customer Data Services Pack and case management functionality.

This Oracle GoldenGate Veridata 12c: Essentials training teaches you all about the Oracle GoldenGate Veridata Server that coordinates processing and initiates database comparisons. You'll explore the Oracle GoldenGate Veridata Agent that communicates with the database and the GoldenGate Veridata Web that acts as a client to the server. Install Veridata on a Linux platform. Configure Oracle GoldenGate Veridata. Run simple and complex compares to verify data synchronization. Identify and correct maybe-out-of-sync (MOOS) and confirmed-out-of-sync (COOS) data without interrupting ongoing transactions. Schedule manual and automatic repairs of out-of-sync conditions. By taking this course, you'll develop expertise that you didn't have before using Oracle GoldenGate Veridata 12c. As a result, you'll be able to better leverage this solution to help you achieve your business goals.