Oracle

The Developing Applications for the Java(TM) EE Platform training helps you develop the knowledge to build and deploy enterprise applications that comply with Java(TM) Platform, Enterprise Edition 6 technology standards. This course is ideal for Sun(TM) Certified Java technology programmers who want to develop enterprise applications that conform to the Java EE platform standards. Learn To: Describe the application model for the Java EE platform and the context for the model. Understand enterprise components and work with (JSP(TM)) technology. Create web services using SOAP and RESTful techniques. Assemble and deploy an application into an application server (Java EE platform runtime environment). Develop expertise using Enterprise JavaBeans(TM) (EJB(TM)) technology. Become familiar wtih the Java Persistence API. Create user interfaces using servlets, JSP technology (JSP pages) and JavaServer Faces (JSF). Develop simple web services for the Java EE platform. Understand RESTful and SOAP web services and the Java technology clients who use them.

This Oracle Database 11g: SQL Tuning Workshop Release 2 training assists database developers, DBAs and SQL developers in identifying and tuning inefficient SQL statements. You’ll explore investigative methods to reveal varying levels of detail about how the Oracle database executes the SQL statement; this helps you determine the root causes of the inefficient SQL statements. Learn To: Use Oracle tools to identify inefficient SQL statements. Use Automatic SQL Tuning. Use Real Time SQL monitoring. Write more efficient SQL statements. Monitor and trace high load SQL statements. Manage optimizer statistics on database objects. Interpret execution plans, and the different ways in which data can be accessed.

This Oracle Database 12c: Analytic SQL for Data Warehousing training teaches you how to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data and exclude branches from the tree structure. You’ll also learn to use regular expressions and sub-expressions to search for, match, and replace strings. In this course, you will be introduced to Oracle Business Intelligence Cloud Service. Learn To: Use SQL with aggregation operators, SQL for Analysis and Reporting functions. Group and aggregate data using the ROLLUP and CUBE operators, the GROUPING function, Composite Columns and the concatenated Groupings. Analyze and report data using Ranking functions, the LAG/LEAD Functions and the PIVOT and UNPIVOT clauses. Perform advanced pattern matching. Use regular expressions to search for, match and replace strings. Gain an understanding of the Oracle Business Intelligence Cloud Service.

In this Oracle Database 11G Advanced PL/SQL training, expert Oracle University instructors will help you explore the advanced features of PL/SQL to design and tune PL/SQL. You’ll learn how it interfaces with the database and other applications in the most efficient manner. Learn To: PL/SQL designing best practices. Create PL/SQL applications that use collections. Implement a virtual private database with fine-grained access control. Write code to interface with external C and Java applications. Write code to interface with large objects and use SecureFile LOBs. Write and tune PL/SQL code effectively to maximize performance.

This Oracle Essbase 11.1.2 Bootcamp teaches you the principal techniques and theories to design Essbase block storage databases. Block storage databases are deployed independently for budgeting, forecasting and planning, and as the underlying data storage and analytic engine for Hyperion Planning applications. Learn To: Create block storage databases. Build rules files. Analyze data with Smart View. Create basic calculations. Extend analysis capabilities. Create a database outline, load data into the database and analyze data with Smart View. Perform advanced analysis on the database by implementing varying attribute dimensions and typed measures. Benefits to You Learn how to improve your organization's performance through better, more informed decisions using Oracle Essbase, the market leading online analytical processing (OLAP) server for Enterprise Performance Management. Become more efficient at forecasting, variance analysis, root cause identification, scenario planning and what-if modeling to better align your organization's resources and improve business results. Calculation Scripts During this course, you'll also create calculation scripts (to calculate data for different scenarios). Design discussions and hands-on activities will help you practice the new skills you're learning. *This course is also suitable for customers using Oracle Essbase 11.1.1.

This Essbase for System Administrators training teaches you to configure, secure, optimize & maintain the Essbase environment for block storage. Learn to aggregate storage applications and maintain databases, including backup, recovery and more. The typical Essbase project is a high visibility, high priority development project designed to enhance bottom line performance. This course will help you develop specific Essbase administrative skills so you're able to support these projects. Learn To: Perform backup, recovery, application migration and task automation. Optimize Essbase system caches. Configure the block storage and aggregate storage kernels. Design and manage Essbase security. Configure, secure, optimize and maintain the Essbase environment for both block storage and aggregate storage applications. Learn Essbase Survival Skills Whether you're a new or seasoned Essbase user, you'll benefit from the Essbase experience and best practices built into the lectures, student guide, numerous exercises and case study. This course will prove to be a valuable addition to your administrator's survival kit

This Oracle Hyperion Financial Reporting training teaches you how to create and manage reports with Financial Reporting. Learn to create objects, books, batches, format reports, add auto calculations and functions and more. Learn To: Describe Financial Reporting architecture and components View reports and set related preferences in EPM Workspace Create reports and report objects (grids, text boxes, charts, images, and templates) Apply member selection with members, lists, and functions for rows, columns, and pages Format reports and define auto calculations and functions in a report Create books and batches to generate reports *This course is suitable for customers using all versions of Oracle Hyperion Financial Reporting 11.1.2

In this course, you learn how to use Oracle Smart View 11.1.2.5, a common Microsoft Office(Excel, Word and PowerPoint) add-in to query, analyze, and share data stored in Essbase databases. In this course you learn how to connect to data sources and create ad-hoc queries and free-form grids. Learn To: Query and analyze data stored in Essbase. Create advanced reports. Set Smart View options. Create reports using Smart Query, Query Designer, and functions. Embed dynamic data points into Microsoft Office documents. Create reports with smart slices. Benefits to You: By enrolling in this course, you'll develop the skills to use Smart Query and Query Designer to create customizable reports with interactive components. You'll get a chance to work with expert Oracle University instructors who can show you how to format reports by using functions

This course focuses on two main development tasks: Query and report building, and dashboard building. You learn to create queries against a relational data source and create reports with Hyperion Interactive Reporting Studio. You begin with a pre-built data model and then learn to request items, filter and sort data, and process queries. Next, you use the results data to create tabular, cross-tabular, chart, and band-style reports. You examine the benefits of dashboards and the default feature set provided in Dashboard Studio templates. You then create dashboards two ways. First you create dashboards with a simple dashboard template that enables you to complete the dashboard building process within Interactive Reporting Studio or Oracle's Hyperion Workspace. Second, you use a dashboard template that provides additional robust dashboard interfaces. With this template, you use both Interactive Reporting Studio and Dashboard Studio to build and configure the dashboards. This includes the use of Live Charts, Gauges other interactive objects. Learn To: Describe Oracle’s Enterprise Performance Management System Query data sources Create tabular, cross-tabular, chart, and band-style reports Analyze report data Create simple dashboards

This Oracle GoldenGate training provides presentations and hands-on practice of the commands, parameters, functions and features for installing and configuring Oracle GoldenGate for Oracle-to-Oracle database replication on a Linux or Windows platform. This Oracle GoldenGate 12c: Fundamentals for Oracle training focuses on Oracle-to-Oracle database replication. Expert Oracle University instructors will deep dive into the Oracle GoldenGate architecture, walking you through various product features. Integrate your organization's disparate data across heterogeneous databases for improved decision-making. Become more efficient at configuring and implementing Oracle GoldenGate.

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.

The Oracle Enterprise Manager Ops Center 12c Virtualizing Systems course describes using Oracle Enterprise Manager Ops Center to manage Oracle VM Server for SPARC implementations, and provides hands on practices that augment your understanding of this virtualization technology. Learn To: Describe virtualization capabilities in Oracle Enterprise Manager Ops Center 12c. Prepare a lab environment for OVMSS virtualization activities. Create and manage storage libraries used to support OVMSS implementations. Create and manage OVMSS servers, guests, and server pools. Migrate OVMSS guests. Build network infrastructures to support OVMSS clouds. Manage I/O Domains. Manage root domains. Work with SR-IOV and Server Pools. Create OVMSS Clouds. Create OVMSS vServers. Benefits To You Benefit by getting an in-depth learning experience using EM Ops Center 12c software to manage Oracle VM Server for SPARC implementations. Explore the Ops Center software to create and manage OVMSS servers and OVMSS guest OS instances, create OVMSS clouds, and manage I/O domains. This course describes managing structures that support OVMSS implementations, including storage libraries and server pools.

This Oracle Enterprise Manager Ops Center 12c Administration Ed 3 training provides the information you need to implement this system management software in your data center. Discussions and hands-on practices provide practical advice and experience focused on successfully using Oracle Enterprise Manager Ops Center 12c Release 3 to manage complex system environments. No hands-on lab environment for TOD Learn To: Deploy Oracle Enterprise Manager Ops Center 12c Release 3 in a data center. Manage and monitor assets using Ops Center. Provision firmware and operating systems. Implement server deployment scenarios using Ops Center. Effectively manage incidents and notifications using Ops Center. Deploy Oracle Solaris Zones using Ops Center. Benefits to You This course provides the practical experience you need to successfully deploy and administer Oracle Enterprise Manager Ops Center 12cR3 in your data center. You'll walk away with a deeper understanding of its underlying technologies and best practices. By participating in hands-on labs, you'll practice installing and employing Oracle Enterprise Manager Ops Center 12cR3 in a variety of use cases, including asset discovery, server deployment, operating system updates and system and hardware management. Explore a Comprehensive Management Solution Oracle Enterprise Manager Ops Center 12cR3 offers a comprehensive management solution for physical and virtual system resources. This enterprise-class solution simplifies asset discovery, deployment, monitoring and management. You will experience server provisioning capabilities, from service processors to operating systems, to firmware. It performs comprehensive update and patch management, manages virtual environments such as Oracle Solaris Zones, Oracle VM Servers for SPARC and x86, and supports hardware management from power up to production. It also enables management of thousands of systems simultaneously.

Oracle Enterprise Manager (EM) Cloud Control 12c: Advanced Configuration Workshop teaches you to maximize availability and scalability with deployment of EM. Learn techniques for disaster recovery, security and command line operations. Learn To: Expand the EM platform to multiple OMSs Recover in case of one OMS failure Understand load balancing within the EM framework Configure access to My Oracle Support Use command line interfaces and configure EM for monitoring Configure EM with a RAC database repository Benefits To You: Discover how Oracle Enterprise Manager 12c can help your organization streamline IT management processes and guide you in your transformation to the cloud. You will see how your organization can realize a 10-20% productivity increase due to labor cost savings resulting from cloud lifecycle management features. You will also see how Enterprise Manager 12c can provide up to ten times faster provisioning of applications in enterprise private clouds.  Configuration Concepts This course will also introduce you to configuration concepts. You'll have an opportunity to solidify them as you navigate through a series of hands-on labs to build a higher available system.

Oracle Enterprise Manager 12c: Cloud Management Workshop training teaches you how to set up Infrastructure, Database and Middleware clouds. Learn to use the Cloud Self Service Portal and investigate consolidation and cloud deployment options. Learn To: Use the Cloud Self Service Portal to request resources in the cloud. Monitor overall resource usage assigned to a self service user. Register an OVM Manager with Enterprise Manager Cloud Control 12c and manage servers, network and storage resources and server pools. Create an Infrastructure cloud and publish software artifacts for deployment by self service users. Create a Platform as a Service Infrastructure Zone and define provisioning credentials for use with it.  Generate Database and Middleware clouds and publish provisioning procedures for deployment by self service users. Setup Metering and Chargeback to enable reporting on cloud usage against cost centers. Use Consolidation Planner to begin investigating the possibility of consolidating infrastructure onto existing or new physical or virtual resources. Benefits To You: Discover how Oracle Enterprise Manager 12c can help your organization streamline IT management processes and guide you in your transformation to the cloud. You will see how your organization can realize a 10-20% productivity increase due to labor cost savings resulting from cloud lifecycle management features. You will also see how Enterprise Manager 12c can provide up to ten times faster provisioning of applications in enterprise private clouds.  Explore Cloud Deployment Models By enrolling in this workshop, you'll get to explore various cloud deployment models. Expert instructors will teach you how to work towards determining what is the best fit for any given circumstances and goals.

This Enterprise Manager Cloud Control 12c training is a foundation course. Expert instructors will help you explore the core functionality of Oracle Enterprise Manager Cloud Control 12c through interactive instruction and hands-on exercises. Learn To: Monitor the overall health of your Cloud Control system. Manage targets, hosts, groups systems and services. Use the job system to create, manage and automate commonly performed tasks. Define rules, monitor and manage incidents. Use the provisioning and patch management framework. View, search and compare configurations. Manage compliance of your systems. Generate custom reports. Benefits to You: By taking this course, you will discover how Oracle Enterprise Manager 12c can help your organization streamline IT management processes and guide you in your transformation to the cloud. You will learn how your organization can realize a 10-20% productivity increase due to labor cost savings resulting from all the cloud management features. Manage an Enterprise-Computing Environment: After a brief review of the underlying architecture, you'll learn to use Cloud Control to manage an enterprise-computing environment. Become familiar with executing tasks like managing and monitoring Cloud Control, managing hosts, groups, systems and services, monitoring targets, using the job system and Enterprise Manager reporting tools, provisioning of software or patching of existing systems, viewing and comparing configurations and managing compliance. Fulfills Oracle Certification Requirements: This course fulfills the training requirement for an Oracle Certification Path. Only Classroom Training, Live Virtual Class or Training On Demand courses fulfill the requirement. Please note that Self-Study and Knowledge Center courses do not fulfill the training requirement.

In the Oracle Enterprise Manager Cloud Control 12c: Install & Upgrade workshop, you will learn about the architecture of Oracle Enterprise Manager Cloud Control 12c and implementation options and perform a standard single-server installation. Understand the available upgrade paths from previous versions, execute a 1-system upgrade from Enterprise Manager 11g Grid Control, a 2-system upgrade from Enterprise Manager 10g Grid Control, and a 1-system upgrade from Enterprise Manager Cloud Control 12c 12.1.0.3. The Oracle Enterprise Manager Cloud Control 12c: Install & Upgrade two day workshop gives you an overview of Oracle Enterprise Manager Cloud Control 12c architecture and hands-on experience in installation and upgrade scenarios. You discuss the key differences between this and previous versions, and implementation options and planning. Learn To: Install Oracle Enterprise Manager Cloud Control 12c. Plan and execute a 1-system and 2-system upgrade from Oracle Enterprise Manager Grid Control and a 1-system upgrade from an earlier version of Oracle Enterprise Manager Cloud Control 12c, all to the latest version of Cloud Control 12c. Benefits To You: Discover how Enterprise Manager Ops Center can help your organization streamline IT management processes and optimize performance to meet your organization’s business requirements. Explore Upgrade Paths By enrolling in this course, you will perform a new single-server installation and then use Agent push functionality to discover targets on a host. You explore the upgrade paths from previous versions and execute a 1-system upgrade from Enterprise Manager 11g Grid Control, a 2-system upgrade from Enterprise Manager 10g Grid Control, and a 1-system upgrade from Enterprise Manager Cloud Control 12c R3.

In the Oracle Enterprise Manager Cloud Control 13c: Install & Upgrade course, you’ll learn about the architecture of Oracle Enterprise Manager Cloud Control 13c, implementation options and you'll perform a standard single-server installation. In this course we will also review the available upgrade paths from previous versions and execute a 1-system upgrade from Enterprise Manager Cloud Control 12c 12.1.0.5 Learn To: Install Oracle Enterprise Manager Cloud Control 13c. Plan and execute a 1-system upgrade from Oracle Enterprise Manager Cloud Control 12c.