Oracle

This course is for customers implementing R12, R12.1 and R12.2. In this intensive course, you'll learn the concepts and functions that are critical to the System Administrator role. This includes managing security, managing concurrent processing, monitoring your system using Oracle Applications Manager, SOA and web services for system administration, and other related topics. Learn To: Set up and administer security-related features. Monitor Oracle E-Business Suite activities using OAM. Understand the fundamentals of Oracle Workflow, including its setup. Configure flexfields and understand how they are used by Oracle E-Business Suite. Set up and manage profile options, printers, personalizations, and other features. Describe service-oriented architecture (SOA) and manage service life cycle activities. Benefits to You Better understand how to effectively control security, monitor your system, and handle day-to-day system administrator tasks for Oracle E-Business Suite applications, so that your organization can more rapidly realize the full value of Oracle E-Business Suite. Build a Foundation The System Administrator Fundamentals course gives you the foundation to effectively control security and ensure smooth operations for an E-Business Suite installation. Demonstrations and hands-on activities reinforce the fundamental concepts of configuring an Oracle E-Business Suite, as well as handling day-to-day system administrator tasks.

R12.2 Oracle E-Business Suite Fundamentals Ed 1 training helps you build a functional foundation for any E-Business Suite Fundamentals course. It's ideal for those who have implemented Oracle E-Business Suite Release 12, 12.1 or 12.2 Learn To: Access and navigate within Oracle Applications using the user interface. Understand major architectural components in E-Business Suite. Identify and describe the benefits of R12.2 footprint. Explain the basic concepts of System Administration. Define key and descriptive Flexfields. Recognize the different entities shared between multiple applications. Identify features of Multiple Organizations and Multiple Organization Access Control (MOAC). Benefits to You : Get a sound understanding of Oracle E-Business Suite, including navigation, key business flows, functionality, and integration points between products. Smoothly implement and start using the applications, so that your organization can quickly realize the full value of Oracle E-Business Suite. Features & Benefits of Oracle Workflow Use the Workflow Monitor to monitor a Workflow to completion. Describe Alerts and test a Periodic Alert. Describe the features of Oracle Business Intelligence (OBI) Applications.

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

This R12.2 Oracle General Ledger Management Fundamentals will help you maximize accounting process efficiency across the enterprise, while still achieving a high level of information and setup security. It will teach you how Oracle General Ledger integrates with the eBusiness Suite of applications. Learn To: Understand the steps for completing the full accounting cycle, as well as the ledger concept. Describe the various implementation considerations. Use the capabilities of securing data within Oracle General Ledger. Perform simultaneous accounting for multiple reporting requirements. Access and process data for multiple ledgers and legal entities at the same time using the power of ledger sets. Understand how Oracle General Ledger integrates with the eBusiness Suite of applications Understand the steps for completing the full accounting cycle

This Oracle Database Security: Preventive Controls for Developers training teaches you how to use Oracle Database application features to meet the security, privacy and compliance requirements of your organization, as the current regulatory environment requires better application security at the database level. You’ll learn how to secure access to your database applications, while using database features that enhance data access and confidentiality. Learn To: Enumerate Oracle security solutions to meet application security requirements. Define application contexts (locally and accessed globally). Control the data access using Virtual Private Database and Oracle Label Security. Build secure applications using Real Application Security.

In the Using Oracle Key Vault course, you learn how to install, configure, and maintain Oracle Key Vault which is a robust, modern, scalable management platform to centralize encryption keys, Oracle wallets, and Java key stores. Learn To: Install, configure and maintain Oracle Key Vault. Enroll endpoints. Setup a column and tablespace encrypted test case. Upload and download wallets. Use the TDE direct connection. Perform periodic tasks.

In the Oracle Database Security: Detective Controls course, students learn how they can use Oracle Database administration auditing features to meet the compliance requirements of their organization. The current regulatory environment requires better security at the database level. Students learn how to audit the access to their databases and how to use the auditing and compliance features to monitor data access and confidentiality. The course provides suggested Oracle solutions for common problems. Learn To: Enumerate Oracle auditing solutions to monitor database security requirements. Implement Oracle Audit Vault and Oracle Database Firewall. Configure Oracle Audit Vault and Oracle Database Firewall. Explain Oracle Compliance Framework. Configure basic Compliance Framework rules.

The Using Oracle Database Vault with Oracle Database 12c course will teach you how to configure and use Oracle Database Vault. Oracle Database Vault provides powerful, preventive and administrative controls that helps organizations defend against common attack vectors from inside and outside the organization. Learn To: Enable and configure Oracle Database Vault. Configure realms, rule sets, rules, SQL command rules and secure application roles. Define factors to extend rule sets. Run Database Vault reports to view attempted policy violations.

No hands-on lab environment for the Training On-Demand course format In the Oracle Audit Vault and Database Firewall: Policies & Reports course, students will learn how to create audit and Database Firewall policies, use built-in reports, create custom reports, and define alerts. Learn To: Create and provision audit policies for Oracle Databases. Create and publish Database Firewall policies. Configure and respond to alerts. Use and customize built-in reports. Manage entitlements.

In the Oracle Audit Vault and Database Firewall: Install & Configure course, students will learn how to deploy Oracle Audit Vault and Database Firewall. Learn To: Install, configure, and manage the Audit Vault Server. Deploy the Audit Vault Agent. Describe Database Firewall Networking. Install, deploy, and manage a Database Firewall. Install and enable Host Monitoring.

This Introduction to Oracle Database Security Ed 1 training teaches you how to use Oracle Database features to help meet the security, privacy and compliance requirements of your organization. Develop a deep understanding of the security risks and Oracle solutions provided to help address those risks. Learn To: Describe and determine database security requirements. Choose Oracle security solutions to meet security requirements. Implement basic database security. Configure network security. Discover basic security configuration issues.

In the Oracle Database Security: Preventive Controls course, students learn how they can use Oracle Database Security products and technologies to meet the security, privacy and compliance requirements of their organization. The current regulatory environment of the Sarbanes-Oxley Act, HIPAA, the UK Data Protection Act, and others, requires better security at the database level. Students learn how to secure the access to their databases and how to use the Oracle Database Security products and technologies that enhance data access and confidentiality. The course provides suggested Oracle solutions for common problems. Learn To: Choose Oracle Database Security products and technologies to meet security requirements. Secure the database access by database or enterprise users with basic or strong authentication such as SSL, Kerberos and Radius. Protect against database bypass by using Transparent Database Encryption. Use Oracle Wallets and Oracle Key Vault to manage encryption keys. Discover sensitive columns such as Credit Card Numbers by using Application Data Modeling. Minimize sensitive data proliferation to test/dev environments by using Data Masking. Minimize storage costs in test/dev environments by using Data Subsetting. Reduce sensitive data exposure in applications by using Data Redaction. Understand and use Oracle Database Vault.

In this course, participants learn about the best practices for implementing an enterprise data warehouse. Participants identify the hardware elements that influence the throughput and learn how to build a balanced hardware configuration. Participants also review the two classic models: Third normal form (3NF) and star schema and learn how to optimize both models. Participants learn how to convert the logical model into a suitable physical model. Participants also learn how to load data efficiently into the data warehouse and how to use partition exchange load and data compression during the ETL process to improve performance. Finally, participants learn to manage the system workload and resources, to ensure an Enterprise Data Warehouse can run at optimal performance, and explains how parallel execution enables them to fully utilize the system. In addition, participants describe how to gather statistics efficiently. Learn To: Describe how to build a balanced hardware configuration Discuss and apply the two classic models, the third normal form (3NF) or star schema Describe how to convert the logical model into the suitable physical model Describe the various methods to load data efficiently into the data warehouse Use partition exchange load and data compression during staging to improve performance Manage the system workload and resources 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.

In this course, students review the basic concepts of data mining and learn how leverage the predictive analytical power of the Oracle Database Data Mining option by using Oracle Data Miner 11g Release 2. The Oracle Data Miner GUI is an extension to Oracle SQL Developer 3.0 that enables data analysts to work directly with data inside the database. The Data Miner GUI provides intuitive tools that help you to explore the data graphically, build and evaluate multiple data mining models, apply Oracle Data Mining models to new data, and deploy Oracle Data Mining’s predictions and insights throughout the enterprise. Oracle Data Miner’s SQL APIs automatically mine Oracle data and deploy results in real-time. Because the data, models, and results remain in the Oracle Database, data movement is eliminated, security is maximized and information latency is minimized.

Participants learn to load data by executing the mappings or the process flows, use Oracle Warehouse Builder 11g, Release 2 features to manage metadata changes, debug mappings, backup metadata, manage security, and tune the ETL mappings for better performance. Integration of Warehouse Builder with OBI EE, along with the Warehouse Builder architecture and configuration are discussed. Participants learn to retrieve data from different types of sources such as flat files or relational schemas and also to use the different transformation operators to design an ETL task. The usage of Warehouse Builder to define both relational dimensional models and multidimensional models, to deploy a single logical model to multiple physical targets and how to handle slowly changing dimensions are also covered. In addition, 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. This functionality requires the Oracle Warehouse Builder Enterprise ETL/ODI EE option. This course is a combination of Data Integration and ETL with Oracle Warehouse Builder: Part 1 and Data Integration and ETL with Oracle Warehouse Builder: Part 2 courses. Learn To: Retrieve data from different types of sources such as flat files or relational schemas Use the different transformation operators to design an ETL task Load data by executing the mappings or the process flows Use OWB features to manage metadata changes, debug mappings, backup metadata, manage security, and tune the ETL mappings for better performance Integrate Warehouse Builder with OBI EEWarehouse Explain the Warehouse Builder architecture and configuration 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 Oracle Database 11g: OLAP Essentials training will teach you how to progressively build an OLAP data model to support a wide range of business intelligence requirements. Expert Oracle University instructors will teach you how to design OLAP cubes to serve as a summary management resource for existing SQL table queries. Learn To: Design and create an Oracle OLAP data model. Enable query rewrite to OLAP Cube MVs for relational summary management. Easily create OLAP calculations that enrich the analytic content of your data model. Query OLAP data using simple SQL. Implement cube security. Efficiently design cubes for performance and scalability. Create sophisticated reports of OLAP data by using simple SQL queries.

This course will help you understand the basic concepts of administering a data warehouse. You’ll learn to use various Oracle Database features to improve performance and manageability in a data warehouse. Learn To: Implement partitioning. Use parallel operations to reduce response time. Extract, transform and load data. Create, use and refresh materialized views to improve data warehouse performance. Use query rewrite to quickly answer business queries using materialized views. Use SQL access advisor and PL/SQL procedures to tune materialized views for fast refresh and query rewrites. Identify the benefits of partitioning, in addition to using parallel operations to reduce response time for data-intensive operations.

Participants learn to load data by executing the mappings or the process flows, use Oracle Warehouse Builder 11g, Release 2 features to manage metadata changes, debug mappings, backup metadata, manage security, and tune the ETL mappings for better performance. Integration of Warehouse Builder with OBI EE, along with the Warehouse Builder architecture and configuration are discussed. Participants learn to retrieve data from different types of sources such as flat files or relational schemas and also to use the different transformation operators to design an ETL task.