• Understand the value that BPMN brings to process modelling
• Understand the opportunities and challenges of adopting BPMN
• Learn the semantics of the BPMN shapes and how best to use them
• Explore the best practices for using BPMN to model processes

• Understand the value that BPMN and UML brings to process modelling
• Understand the opportunities and challenges of adopting BPMN
• Learn the semantics of the BPMN shapes and how best to use them
• Explore the best practices for using BPMN to model processes
• Understand the value of Unified Modelling Language (UML) Activity Diagrams
• Understand the value of Unified Modelling Language (UML) Use Case Diagrams

• Understand the Software Development Life Cycle
• Understand the history and current application of Object Technology
• Describe business processes using UML
• Relate business models to system requirements
• Understand Modelling techniques using Use-Case
• Understand Modelling techniques using Interaction and Sequence Diagrams
• Understand What a Communication Diagram is
• Develop UML Models in an iterative process

• Describe Business Process Management Fundamentals
• Use Business Process Management 11g and 12c for process modeling,
• Use Business Process Management 11g and 12c simulation, analytics,
• Use Business Process Management 11g and 12c for business rules and workflow
• Implement Processes

• Describe Oracle Fusion Middleware (FMW)
• Identify and describe FMW and SOA Suite 11g components
• Install and Configure FMW, SOA and BPM 11g
• Identify the system administration tools for managing FMW
• Access FMW Control
• Understand Oracle’s Business Process Management methodology
• Understand Oracle’s Business Process Management Governance Framework
• Appreciate BPA and BPM Suite Tools and how they interact
• Understand BPM Suite Tools and Technology

• Understand Relational Database Concepts
• Understand Types of Databases Models
• Understand Gathering Requirements for Database Design
• Create an Entity Relationship Diagram by identifying entities, attributes, relationships and constraints from a set of requirements
• Normalize the Entity Relationship Diagram to third Normal form
• Enhance the Entity Relationship Diagram to utilize several data modeling techniques
• Create a Data Flow Diagram by identifying processes, external agents, information stores and information flows
• Create a Data Flow Diagram that show how the information flows and how it is being transformed
• Engineer the Entity Relationship Model into an initial relational database design
• Optimize the Relational Database Design
• Complete the Physical Model and generate the DDL

• Understand patterns and frameworks that can facilitate building more flexible and re-usable software components
• Understand the object-oriented software development process, including object-oriented methodologies and workflows
• Perform object-oriented analysis and design and Follow a software development process using an OO software project
• Gather system requirements through interviews with stakeholders
• Analyze system requirements to determine the use cases and domain model of the problem domain (the Requirements model)
• Manage complexity of artifacts; describe the problem and proposed solution
• Create a system architecture (the Architecture model) supporting the nonfunctional requirements (NFRs) and development constraints
• Create a system design (the Solution model) supporting the functional requirements (FRs)
• Use object-oriented technologies and the widely adopted graphical modelling language - the Unified Modelling Language (UML) version 2.x

• Describe new challenges faced when capturing requirements
• Describe software engineering life cycle concepts and processes for managing software projects
• Describe the phases of software engineering (analysis, delivery, and management)
• Describe the UML and Use-Case Modelling
• Understand the Analysis Phase of the Requirements Managements processV
• Describe and understand Scope Management
• Understand Stakeholder Needs
• Describe the Functional and Non-Functional Requirements
• Outline the Requirements Managements process
• Describe the Requirements Management discipline
• Explain how to achieve business objectives and IT needs
• Explain how to use UML Use-Cases to document details about a requirementFoundations of Object-Oriented Software Engineering

• Describe Business Process Management Fundamentals
• Use Business Process Management 11g and 12c for process modeling,
• Use Business Process Management 11g and 12c simulation, analytics,
• Use Business Process Management 11g and 12c for business rules and workflow
• Implement Processes

• Describe Oracle Fusion Middleware (FMW)
• Identify and describe FMW and SOA Suite 11g and 12c components
• Install and Configure FMW, SOA and BPM 11g and 12c
• Identify the system administration tools for managing FMW
• Access FMW Control
• Applying Oracle’s Business Process Management methodology
• Understand Oracle’s Business Process Management Governance Framework
• Appreciate BPA and BPM Suite Tools and how they interact
• Understand BPM Suite Tools and Technology
• Learn how to use Oracle BPM Suite for BPM project solutions
• Understand Oracle’s Business Process Management Governance Framework
• Understand how BPM interoperates with SOA and Business Rules Engines
• Understand concepts such BPMN, Process Frameworks, Process Maturity
• Understand Process Assessment, Process Performance Measurement, Process Ownership etc
• Describe basic BPMN modelling concepts
• Use BPMN modelling notation to document business process
• Describe process models using Business Process Composer and BPM Studio
• Create business rules that condition flow through a model
• Develop a human workflow task routing
• Describe how Business Analysts, Developers, and others can collaborate on BPM projects
• Explain the role of simulations for process optimisation
• Simulate a process model to identify bottlenecks
• List the tasks involved in implementing a BPM process
• Describe how end users participate in a business process
• Use Business Process Workspace to display monitoring data
• Explain how Oracle BAM can help monitor the performance of deployed processes
• Understand and Identify the default process metrics tracked by Oracle BPM

• Define the history and current application of object technology
• Explain what the UML represents
• Explain abstraction
• Encapsulation
• Modularity and hierarchy
• Describe the physical structure of a class
• Identify the relationship between a class and an object
• Define polymorphism and generalization
• Understand Class Diagrams
• Understand State Machine Diagrams
• Understand Deployment Diagram

• Understand Concepts of Object Orientation
• Understand Requirements Management
• Understand Analysis and Design
• Understand Architectural Analysis
• Understand Use-Case Analysis
• Understand Identify Design Elements
• Understand Identify Design Mechanisms
• Describe the Run-time Architecture
• Describe Distribution
• Understand Use-Case Design
• Understand Subsystem Design
• Understand Class Design
• Understand Database Design Overview
• Map Persistent Design Classes To The Data Model
• Describe Best Practices of Software Engineering

• Apply requirements management techniques to define a clear statement of product requirements
• Capture and document requirements with use-case modelling techniques
• Develop requirements in an iterative process
• Describe a documentation hierarchy and standards for defining levels of requirements for a product
• Use requirement attributes and traceability to help manage scope and change throughout product lifecycle
• Use requirements to drive ongoing design, test, and user documentation activities

• Identify the characteristics and benefits of visual modeling
• Cite the four principles of visual modeling
• Identify the role of the Unified Modeling Language (UML) in modeling
• List four ways that the UML is used
• Determine when to use visual modeling
• Describe abstraction, encapsulation, modularity, and hierarchy
• Explain the physical structure of a class
• Describe the relationship between a class and an object
• Define polymorphism and generalization

• Describe the concept of system behavior and how to capture it in a use-case model
• Describe the benefits of use-case modeling
• Explain how to create, read, and interpret use-case models and activity diagrams

• Show the relationship between system behavior, use cases, and use-case models
• Identify the benefits of using use-case models
• Find and describe the actors and use cases in a problem statement
• Create a use-case model and activity diagrams using UML 2.0 notation

• Describe Oracle Fusion Middleware (FMW)
• Describe the Oracle SOA Suite 11g/12c architecture
• Identify and describe SOA Suite 11g/12c components
• Identify and describe SOA Standards
• Identify and describe SOA Governance
• Identify and describe BPM Governance
• Identify and describe SOA and Enterprise Application Integration

• Describe Oracle Fusion Middleware (FMW)
• Describe the Oracle SOA Suite 11g/12c architecture
• Identify and describe SOA Suite 11g/12c components
• Identify and describe SOA Standards
• Identify and describe SOA Governance
• Identify and describe BPM Governance
• Identify and describe SOA and Enterprise Application Integration

• Describe Oracle Fusion Middleware (FMW)
• Describe the Oracle SOA Suite 11g/12c architecture
• Identify and describe SOA Suite 11g/12c components
• Identify and describe SOA Standards
• Understand Basic SOA Analysis and Design concepts
• Understand how to approach SOA Projects
• Create a SOA Composite application using JDeveloper.
• Test SOA composite application
• Deploy a SOA composite application

• Describe Oracle Fusion Middleware (FMW)
• Describe the Oracle SOA Suite 11g architecture
• Identify and describe SOA Suite 11g components
• Identify and describe SOA Standards
• Identify and describe SOA Governance
• Identify and describe BPM Governance
• Identify and describe SOA and Enterprise Application Integration

• Describe Oracle Fusion Middleware (FMW)
• Describe the Oracle SOA Suite 11g architecture
• Identify and describe SOA Suite 11g components
• Identify and describe SOA Standards
• Understand Basic SOA Analysis and Design concepts
• Understand how to approach SOA Projects
• Create a SOA Composite application using JDeveloper.
• Test SOA composite application
• Deploy a SOA composite application

• Describe Oracle Fusion Middleware (FMW)
• Describe the Oracle SOA Suite 11g and 12c architecture
• Identify and describe SOA Suite 11g components
• Identify and describe SOA Standards
• Identify and describe SOA Governance
• Install SOA Suite 11g – includes BAM and BPM Suite11g
• Install and configure Oracle JDeveloper 11g and ADF components
• Identify the system administration tools for managing SOA Suite 11g
• Identify and describe SOA and Enterprise Application Integration
• Start and stop instances of WebLogic Server by using FMW Control
• Explore BAM and BPM Suite 11g Components
• Understand SOA Suite EDN – Event Driven Network
• Understand Basic SOA Analysis and Design concepts
• Understand how to approach SOA Projects
• Create a SOA Composite application using JDeveloper
• Test SOA composite application
• Deploy a SOA composite application

• Understand Relational Database Concepts
• Understand Types of Databases Models
• Understand Gathering Requirements for Database Design
• Understand the Stages of Database system Development
• Understand Oracle Database Development Tools
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL to generate and retrieve customised data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data in the Oracle Database

• Describe the basic architecture and concepts of Microsoft SQL Server 2014
• Understand the similarities and differences between Transact-SQL and other computer languages
• Write SELECT queries
• Query multiple tables
• Sort and filter data
• Describe the use of data types in SQL Server
• Modify data using Transact-SQL
• Use built-in functions
• Group and aggregate data
• Use subqueries
• Use table expressions
• Use set operators
• Use window ranking, offset and aggregate functions
• Implement pivoting and grouping sets
• Execute stored procedures
• Program with T-SQL
• Implement error handling
• Implement transactions

• Understand Relational Database Concepts
• Understand Types of Databases Models
• Understand Gathering Requirements for Database Design
• Understand the Stages of Database system Development
• Writing SELECT queries
• Sorting and filtering data
• Using SQL aggregate functions
• Using SET operators
• Writing joins to query multiple tables
• Using built-in functions
• Using Subqueries
• Inserting, updating, deleting and merging rows
• Transaction control
• Creating and using views
• Using table expressions
• Enhanced Grouping and Pivoting data
• Using Windowing ranking, offset and ranking functions
• Creating and using Stored Procedures
• Controlling Program Flow
• Using Dynamic SQL
• Implementing Error Handling
• Improving Query Performance

• Understand Relational Database Concepts
• Understand SQL Server Data Tools
• Writing SELECT queries
• Sorting and filtering data
• Using SQL aggregate functions
• Using SET operators
• Writing joins to query multiple tables
• Using built-in functions
• Using Subqueries
• Inserting, updating, deleting and merging rows
• Transaction control
• Creating and using views
• Using table expressions
• Enhanced Grouping and Pivoting data
• Using Windowing ranking, offset and ranking functions
• Creating and using Stored Procedures
• Controlling Program Flow
• Using Dynamic SQL
• Implementing Error Handling
• Improving Query Performance

• Comprehend fundamentals of Database Administration
• Comprehend Querying Databases
• Comprehend Data warehouse fundamentals
• Comprehend fundamentals of OLAP cubes
• Use SQL Server to implement a Data Warehouse
• Manage operations in SQL Server 2012 Databases
• Design and implement Business Intelligence Solutions in SQL Server 2012
• Comprehend fundamentals of Cloud Computing and SQL Azure

• Create database objects
• Work with data
• Modify data
• Troubleshoot and optimize
• Install and configure
• Maintain instances and databases
• Optimize and troubleshoot
• Manage data
• Implement security
• Extract and transform data
• Load data
• Configure and deploy SSIS solutions
• Build data quality solutions

• Designing, configuring, installing, and administering the business intelligence platform of SQL 2014
• Designing databases for Analysis Services
• Designing BI solution architecture
• Administering, maintaining and troubleshooting SSAS database
• Designing tabular data models
• Generating reports with SRSS (SQL Server Reporting Services)
• Planning the complete BI infrastructure
• Creating Reporting Solutions
• Designing ETL Solutions
• Provisioning Hardware and Software services
• Designing Data mart and data warehouse structure
• Designing OLAP (Online Analytical Processing) cubes
• Integrating applications with business applications such as SharePoint etc.

• Designing, configuring, installing, and maintaining databases in a Microsoft enterprise set up
• Implementing and troubleshooting database objects in SQL Server
• Querying SQL 2014/2016 Server
• Administering SQL Server 2014 database environments
• Implementing data warehouse with SQL server 2014/2016
• Designing solutions for SQL 2014/2016 databases

• Introduction to RDBMS
• Introduction to Database Modelling
• Oracle Database: Introduction to SQL - 1Z0-071
• Oracle Database: SQL Tuning Workshop - 1Z0-117
• Oracle Database: Program with PL/SQL - 1Z0-149
• Oracle Database: Advanced PL/SQL 1Z0-148

• Object Oriented Concepts
• OCA Java SE 7 Programmer I certification
• OCP Java SE 7 Programmer II certification
• OCE JEE6 WCD certification
• Building RIA with JSF and PrimeFaces
• OCE JEE 6 EJB certification
• OCE JEE 6 JPA certification
• OCE JEE 6 JWS certification

• Learn to Install RStudio and work on R interface
• Learn the basics of R programming including objects, classes, vectors, attributes etc.
• Write functions including generic functions using various methods and loops
• Install various packages and work effectively in the R environment
• Select and modify values as required
• Learn to use Vectorized Coding and Use Cases
• Cover the concepts of R Notation, S3 System and Closures
• Become proficient in writing a fundamental program and perform analytics with R

• Understand Data Science
• Understand Data Science Tools and Technology
• Understand R
• Data Modeling in R
• Visualize and explore data
• Data Exploration in R
• Data Visualisation in R
• Profiling and Analyzing Datasets

• Using Spark to work with data
• Preprocessing data for machine learning in Spark
• Building machine learning models in Spark
• Using R at scale with R Server on Spark

• Basics of R Programming
• Naive Bayes
• k-nearest neighbor algorithm
• Support vector machines
• Random forests
• Sentiment Analysis using R

• General Concepts on Artificial Intelligence
• General Concepts on Machine Learning
• Linear Regression
• Logistic Regression
• Association Rules- Market Basket Analysis
• Recommendation system
• Item Based collaborative
• User Based Collaborative

• Comprehend key Hadoop distributors
• Comprehend Hadoop Architecture
• Comprehend HDFS
• Comprehend MapReduce
• Comprehend Backup and Recovery
• Comprehend Monitoring the Cluster
• Comprehend Hadoop Resource Management
• Comprehend Cluster Troubleshooting
• Comprehend Installation, Configuration and Implementation
• Comprehend Hadoop debugging, development, and execution of workflows and algorithms
• leverage Hive, Oozie, Pig, Flume, Sqoop, and other Hadoop ecosystem projects
• Create custom components such as InputFormats and WritableComparables to administer complex data types
• Write and execute joins to link data sets in MapReduce

• Hadoop fundamentals
• Big Data Approach
• RDBMS Vs. Hadoop
• Introduction to Hadoop
• Hadoop Architecture
• HDFS, YARN, Hadoop setup
• Cloudera Manager
• Ambari
• Job scheduling and monitoring

• Ingesting Data using Sqoop
• Sqoop properties and commands
• Integrating Sqoop with RDBMS
• Sqoop features and example scenarios
• Ingesting Data using Flume
• Flume properties and setup
• Flume and streaming
• Flume Vs. Kafka

• Introduction to Pig
• Pig programming and commands
• Pig interactive shell
• Analyzing complex data using Pig
• Using Pig functions
• Introduction to Hive
• Hive Metastore
• Writing queries using Hive
• Joins and grouping
• Impala architecture
• Impala Vs. Hive
• Queries using Impala

• Spark Basics
• Spark MlLib Library
• Install and configure intelliJ for Spark development
• Logistic Regression
• Linear Regression
• ALS
• KMeans

• Describe key concepts of data science and machine learning
• Describe key concepts of machine learning
• Understand Open Source Machine learning tools including R and Python
• Understand Open Source Machine learning Platforms
• Understand Commercial Machine learning tools including Microsoft Azure Machine Learning
• Prepare data for predictive modelling
• Visualize and explore data
• Develop Machine learning solutions using R and Python
• Develop R Machine learning solutions using Microsoft AzureML
• Develop Machine learning solutions using Microsoft AzureML Studio
• Create supervised and unsupervised machine learning models

• Translate business questions into Machine Learning problems to understand what your data is telling you
• Explore and analyze data from the Web, Word Documents, Email, Twitter feeds, NoSQL stores, Relational Databases and more, for patterns and trends relevant to your business
• Build Decision Tree, Logistic Regression and Naïve Bayes classifiers to make predictions about your customers’ future behaviors as well as other business critical events
• Use K-Means and Hierarchical Clustering algorithms to more effectively segment your customer market or to discover outliers in your data
• Discover hidden customer behaviors from Association Rules and Build Recommendation Engines based on behavioral patterns
• Use biologically-inspired Neural Networks to learn from observational data as humans do
• Investigate relationships and flows between people, computers and other connected entities using Social Network Analysis

• Store, manage, and analyze unstructured data
• Select the correct big data stores for disparate data sets
• Process large data sets using Hadoop to extract value
• Query large data sets in near real time with Pig and Hive
• Plan and implement a big data strategy for your organization

• Develop highly scalable and cost-efficient applications with MongoDB
• Build efficient MongoDB data models for enterprise-scale applications
• Enhance performance with indexing and sharding
• Manage consistency with write concern and read preference
• Process data and compute results with aggregation pipelines and MapReduce

• Apply the BI Meta Model (BIMM) to turn desired outcomes into actions
• Choose between a strategic and a tactical application of BI
• Map operational data to a data warehouse
• Design a BI solution for a business problem

• Perform a functional decomposition of your organisation
• Diagram and document business processes as use cases
• Capture workflows in Business Process Model and Notation (BPMN)
• Apply UML diagrams to document your business objects and their states
• Use a CASE tool to refine business analysis models and documentation

• Data Science and Machine Learning Overview
• Understand Data Science and Big Data Processing
• Understand Spark
• Making a Case for Spark
• Understand Major components of Spark programming
• Understand Major components of Spark programming
• Understand Major components of Spark programming
• Describe Spark MLlib and Data Types
• Describe Spark ML on Azure
• Describe Azure HDInsight Spark Clusters
• Spark MLlib Basic Statistics
• Understand Clustering on Spark
• Understand Regression on Spark
• Applying Regression and Classification on Spark

• Explain what machine learning is
• Describe the main categories of machine learning techniques
• Identify the steps in the machine learning process
• Describe what CRISP-DM is
• Describe Data Exploration and Preparation
• Describe classification and how classification can be supervised or unsupervised
• Explain and Discuss Evaluation of Machine Learning Models
• Explain Regression, Cluster Analysis, and Association Analysis
• Define what the regression task is
• Explain the difference between regression and classification
• Construct models that learn from data using widely available open source tools
• Analyze big data problems using scalable machine learning algorithms on Spark

• Describe and Understand Data Science and Machine Learning
• Describe the main categories of machine learning techniques
• Describe and Understand the Data Science Process
• Identify the steps in the machine learning process
• Describe what CRISP-DM is
• Describe and Understand Oracle Advanced Analytics Tools
• Describe Oracle Data Miner
• Understand R Technologies in Oracle
• Describe Oracle R Enterprise Server
• Describe and Understand Data Science Algorithms supported by Oracle
• Describe and Understand AI and Machine Learning Techniques supported by Oracle
• Install and Configure Oracle Advanced Analytics
• Describe Data Exploration and Preparation
• Describe classification and how classification can be supervised or unsupervised
• Understand and Perform Clustering Methods
• Understand and apply Association Rules
• Understand and apply Regression Analysis
• Understand and apply Classification Methods
• Understand and apply Neural Networks
• Understand and apply Solutions Deployment

• Describe and Understand Data Science and Machine Learning
• Describe the main categories of machine learning techniques
• Describe and Understand the Data Science Process
• Identify the steps in the machine learning process
• Describe what CRISP-DM is
• Describe and Understand Microsoft Analytics Tools
• Describe Oracle Data Miner
• Understand R Technologies in Microsoft
• Describe Microsoft R Enterprise Server
• Describe and Understand Data Science Algorithms supported by Microsoft
• Describe and Understand AI and Machine Learning Techniques supported by Microsoft
• Install and Configure Microsoft Advanced Analytics
• Describe Data Exploration and Preparation
• Describe classification and how classification can be supervised or unsupervised
• Understand and Perform Clustering Methods
• Understand and apply Association Rules
• Understand and apply Regression Analysis
• Understand and apply Classification Methods
• Understand and apply Neural Networks
• Understand and apply Solutions Deployment

• Gain a high-level understanding of Apache Spark
• Understand Resilient Distributed Datasets (RDDs) in Apache Spark
• Understand notebooks on Apache Spark
• Understand Spark ML
• Understand Spark SQL
• Understand Hive in Apache Spark
• Understand R on Apache Spark
• Understand Spark Streaming
• Understand machine learning with Spark MLlib

• Describe key concepts of Data Science
• Understand Open Source Data Science tools including R and Python
• Understand Open Source Data Science Tools and Platforms
• Understand Commercial Data Science tools including Microsoft Azure Machine Learning
• Prepare data for predictive modelling
• Visualize and explore data
• Develop Data Science solutions using R
• Develop R based Data Science solutions using Microsoft Azure ML
• Develop Data Science solutions using Microsoft Azure ML Studio
• Create supervised and unsupervised machine learning models

• Describe key concepts of Data Science
• Understand Open Source Data Science tools including R and Python
• Understand Open Source Data Science Tools and Platforms
• Understand Commercial Data Science tools including Microsoft Azure Machine Learning
• Prepare data for predictive modelling
• Visualize and explore data
• Develop Data Science solutions using Python
• Develop Python based Data Science solutions using Microsoft Azure ML
• Develop Data Science solutions using Microsoft Azure ML Studio
• Create supervised and unsupervised Data Science models

• Describe key concepts of Data Science
• Understand Open Source Data Science tools including R and Python
• Understand Open Source Data Science Tools and Platforms
• Understand Commercial Data Science tools including Microsoft Azure Machine Learning
• Prepare data for predictive modelling
• Visualize and explore data
• Develop Data Science solutions using Python
• Develop R based Data Science solutions using Microsoft Azure ML
• Develop Machine learning solutions using Microsoft Azure ML Studio
• Create supervised and unsupervised Data Science models

• Describe key concepts of machine learning
• Understand Open Source Machine learning tools including Python
• Understand Open Source Machine learning Tools and Platforms
• Understand Commercial Machine learning tools including Microsoft Azure Machine Learning
• Prepare data for predictive modelling
• Visualize and explore data
• Develop Machine learning solutions using Python
• Develop R and Python Machine learning solutions using Microsoft Azure ML
• Develop Machine learning solutions using Microsoft AzureML Studio
• Create supervised and unsupervised machine learning models

• Describe key concepts of machine learning
• Understand Open Source Machine learning tools including Python
• Understand Open Source Machine learning Tools and Platforms
• Understand Commercial Machine learning tools including Microsoft Azure Machine Learning
• Prepare data for predictive modelling
• Visualize and explore data
• Develop Machine learning solutions using Python
• Develop Python Machine learning solutions using Microsoft Azure ML
• Develop Machine learning solutions using Microsoft Azure ML Studio
• Create supervised and unsupervised machine learning models

• Describe key concepts of machine learning
• Understand Open Source Machine learning tools including R
• Understand Open Source Machine learning Tools and Platforms
• Understand Commercial Machine learning tools including Microsoft Azure Machine Learning
• Develop Machine learning solutions using R
• Develop R Machine learning solutions using Microsoft Azure ML
• Develop Machine learning solutions using Microsoft Azure ML Studio
• Prepare data for predictive modelling
• Visualize and explore data
• Create supervised and unsupervised machine learning models

• Describe key concepts of data science and machine learning
• Describe key concepts of machine learning
• Understand Open Source Machine learning tools including R and Python
• Understand Open Source Machine learning Platforms
• Understand Commercial Machine learning tools including Microsoft Azure Machine Learning
• Prepare data for predictive modelling
• Visualize and explore data
• Develop Machine learning solutions using R and Python
• Develop R Machine learning solutions using Microsoft AzureML
• Develop Machine learning solutions using Microsoft AzureML Studio
• Create supervised and unsupervised machine learning models

• Describe key concepts of data science and machine learning
• Understand Open Source Machine learning tools including KNIME, R and Python
• Understand Open Source Machine learning Platforms
• Understand Commercial Machine learning tools including Oracle Advanced Analytics and Microsoft Azure Machine Learning
• Develop Machine learning solutions using R and Python
• Develop R Machine learning solutions using Microsoft Azure ML
• Develop Machine learning solutions using Microsoft Azure ML Studio
• Prepare data for predictive modelling
• Visualize and explore data
• Create supervised and unsupervised machine learning models

• Describe key concepts of machine learning
• Understand Open Source Machine learning tools including R, KNIME and Python
• Understand Open Source Machine learning Platforms
• Understand Commercial Machine learning tools including IBM SPSS, Oracle Analytics, Microsoft Azure ML
• Visualize and explore data
• Create supervised and unsupervised machine learning models
• Develop Machine learning solutions using R and Python
• Develop R Machine learning solutions using Microsoft Azure ML
• Develop Machine learning solutions using Microsoft Azure ML Studio
• Prepare data for predictive modelling

• Describe key concepts of data science and machine learning
• Describe key concepts of machine learning
• Understand Open Source Data Science tools and Platforms including Spark, R and Python
• Understand Open Source Machine learning Tools and Platforms
• Understand Commercial Data Science tools including Microsoft Azure ML Studio and Oracle Advanced Analytics
• Learn to Install and Configure R and Python
• Learn to Configure Microsoft Azure ML for R and Python Development
• Prepare data for predictive modelling
• Visualize and explore data
• Create supervised and unsupervised machine learning models
• Develop Data Science solutions using R on Azure ML Platform
• Develop Machine learning solutions using R and Python
• Develop Machine learning solutions Microsoft Azure Notebooks
• Develop Data Science solutions using Microsoft Azure ML Studio

• Describe key concepts of data science and machine learning
• Understand Open Source Machine learning tools including R and Python
• Understand Open Source Machine learning Platforms
• Understand Commercial Machine learning tools including Microsoft Azure Machine Learning
• Set Up a R Environment for Development
• Set Up a Python Environment for Development
• Prepare data for predictive modelling
• Visualize and explore data
• Develop Data Science solutions using R
• Develop R solutions using Microsoft Azure ML
• Develop Data Science solutions using Microsoft Azure ML Studio
• Develop Machine learning solutions using Microsoft Azure ML Studio
• Create supervised and unsupervised machine learning models

• Describe key concepts of data science and machine learning
• Understand Open Source Data Science tools and Platforms including Spark, R and Python
• Understand Open Source Machine learning Tools and Platforms
• Understand Commercial Data Science tools including Microsoft Azure ML Studio,IBM SPSS and Oracle Advanced Analytics
• Learn to Install and Configure R and Python
• Learn to Configure Microsoft Azure ML for R and Python Development
• Prepare data for predictive modelling
• Visualize and explore data
• Create supervised and unsupervised machine learning models
• Develop Data Science solutions using R on Azure ML Platform
• Develop Machine Learning solutions using Microsoft Azure Notebooks
• Develop Data Science solutions using Microsoft Azure ML Studio

• Gain a high-level understanding of big data and Hadoop on HDInsight
• Understand Hadoop Components: MapReduce and HDFS
• Understand Hadoop Components: YARN and Apache Tez
• Understand HDInsight
• Understand HCatalog
• Understand development with Hive
• Understand development with Pig
• Understand development with HBase
• Understand Apache Storm on HDInsight
• Understand HDInsight clusters, cluster type, and configuration
• Understand extensibility and customizing HDInsight clusters using script actions
• Understand cluster security and operations
• Understand monitoring and managing Hadoop with Ambari web UI
• Understand Hadoop Clusters in HDInsight
• Gain a high-level understanding of Apache Spark
• Understand Resilient Distributed Datasets (RDDs) in Apache Spark
• Understand notebooks on Apache Spark
• Understand Spark with Azure HDInsight
• Understand Spark ML
• Understand Spark SQL
• Understand Hive and Power BI in Apache Spark
• Understand Spark Streaming
• Understand machine learning with Spark MLlib
• Understand R Server on HDInsight with Apache Spark

• Gain a high-level understanding of big data and Hadoop on HDInsight
• Understand Hadoop Components: MapReduce and HDFS
• Understand Hadoop Components: YARN and Apache Tez
• Understand HDInsight
• Understand HCatalog
• Understand development with Hive
• Understand development with Pig
• Understand development with HBase
• Understand Apache Storm on HDInsight
• Understand HDInsight clusters, cluster type, and configuration
• Understand extensibility and customizing HDInsight clusters using script actions
• Understand cluster security and operations
• Understand monitoring and managing Hadoop with Ambari web UI
• Understand Hadoop Clusters in HDInsight

• Gain a high-level understanding of Apache Spark
• Understand Resilient Distributed Datasets (RDDs) in Apache Spark
• Understand notebooks on Apache Spark
• Understand Spark with Azure HDInsight
• Understand Spark ML
• Understand Spark SQL
• Understand Hive and Power BI in Apache Spark
• Understand Spark Streaming
• Understand machine learning with Spark MLlib
• Understand R Server on HDInsight with Apache Spark

• Microsoft Big Data Fundamentals
• How to implement Hadoop on HDInsight
• Hive and Tez: Querying Big Data Essentials
• Pig, Sqoop, Oozie, and Mahout Essentials
• HBase Essentials
• Storm Essentials

• Gain a high-level understanding of SQL Server 2016/2017
• Understand the mission-critical and hybrid capabilities of SQL Server
• Gain a high-level understanding of Azure Data Services
• Gain a high-level understanding of Modern Data Warehouse
• Gain a high-level understanding of SQL Server BI
• Gain a high-level understanding of SQL Server Enterprise Information Management
• Gain a high-level understanding of Power BI
• Gain a high-level understanding of Azure Machine Learning
• Gain a high-level understanding of Azure Data Factory
• Gain a high-level understanding of SQL Server R Services
• Gain a high-level understanding of Hadoop on Azure
• Gain a high-level understanding of Azure Data Lake
• Gain a high-level understanding of Apache Spark

• Understand Data Warehousing Concepts
• Understand key SQL Data Warehouse concepts
• Understand the Data Warehouse and ETL Development Lifecycle
• Understand SQL Data Warehouse topology and architecture
• Understand Azure Data Warehouse database design
• Understand ETL (data access, data export) in SQL Data Warehouse
• Learn how to Extract, Transform, and Load (ETL) Data in Azure SQL Data Warehouse
• Understand data movement and distribution theory in SQL Data Warehouse
• Understand big data and SQL Server integration
• Understanding Azure Data Warehouse to BI integration, including with Power BI

• Gain a high-level understanding of SQL Server
• Understand the new features in SQL Server 2016
• Understand SQL Server In-Memory Optimization (OLTP)
• Understand SQL Server In-Memory Data Warehouse capabilities
• Understand SQL Server 2016 high-availability features
• Understand SQL Server 2016 SQL Server security features
• Understand SQL Server 2016 Query Store and Live Query Statistics
• Understand SQL Server 2016 Temporal Tables
• Understand the integration of SQL Server 2016 with big data sources with PolyBase
• Understand SQL Server 2016 Stretch Database
• Gain a high-level understanding of SQL Server R Services Analytics
• Understand SQL Server 2016 R Services integration

• Gain a high-level understanding of SQL Server
• Understand the new features in SQL Server 2017
• Understand SQL Server In-Memory Optimization (OLTP)
• Understand SQL Server In-Memory Data Warehouse capabilities
• Understand SQL Server 2017 high-availability features
• Understand SQL Server 2017 SQL Server security features
• Understand SQL Server 2017 Query Store and Live Query Statistics
• Understand SQL Server 2017 Temporal Tables
• Understand the integration of SQL Server 2017 with big data sources with PolyBase
• Understand SQL Server 2017 Stretch Database
• Gain a high-level understanding of SQL Server R Services Analytics
• Understand SQL Server 2017 R Services integration

• Learn to Plan and Scope your SQL Server Data Warehouse Projects
• Understand BI and Warehouse Architecture Frameworks
• Understand the BI and Warehouse Development Process
• Learn to Manage SQL Server Warehouse Projects
• Understand the Data Warehouse and ETL Development Lifecycle
• Understand Data Warehousing Concepts
• Understand Dimension Modelling
• Understand key SQL Server Data Warehouse concepts
• Understand SQL Data Warehouse topology and architecture
• Understand Azure Data Warehouse database design
• Understand ETL (data access, data export) in SQL Data Warehouse
• Understand data movement and distribution theory in SQL Data Warehouse
• Understand big data and SQL Server integration
• Understanding Azure Data Warehouse to BI integration, including with Power BI

• Fundamentals of normalization and why it's important to transactional databases
• How to develop logical and physical data models
• How to model data security, privacy and protection requirements
• When and where to model database-specific performance requirements
• How model-driven development fits in a DevOps or agile environment
• How to avoid schema drift and other data anti-patterns

• Understand Relational Database Modelling
• Identify Oracle Database Development Tools
• Install your Oracle Software
• Understand the Oracle Database 11g Enterprise Edition Options
• Understand the Oracle Database Architecture
• Identify the major structural components of the Oracle Database 11g
• Manage objects with data dictionary views
• Manage schema objects
• Run data definition language (DDL) statements to create and manage schema objects
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data
• Employ SQL & PL/SQL functions to generate and retrieve customized data
• Create PL/SQL Triggers
• Create PL/SQL Stored Procedures and Functions
• Create PL/SQL Packages

• Basics of the Oracle® Database Architecture
• Shared Memory Areas
• Installing Oracle Software
• Managing an Oracle® Instance
• Oracle® Managed Files
• Server Side Parameter File
• Oracle® Data Dictionary
• Control Files and Redo Log Files
• Managing the Physical Database Structure
• Managing Tablespaces and Datafiles
• Temporary Segments
• Storage Structures and Undo Data
• Block Utilization
• Undo Space Management
• Managing Database Objects
• Indexes
• Integrity Constraints
• Managing Database Users
• System Privileges
• Object Privileges
• Roles
• Backup and Recovery Concepts
• Perform Database Backups

• Run data definition language (DDL) statements
• Identify the major structural components of the Oracle Database
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data

• Write Executable Statements
• Declaring PL/SQL Variables
• Working with Composite Data Types
• Conditionally control code flow (loops, control structures)
• Explicit cursors
• Handle runtime errors
• Describe stored procedures and functions

• Design, build, and use a relational database using proven methods
• Ensure database designs accurately model business requirements
• Normalize and denormalize your data to optimize performance
• Work with integrity constraints
• Automatically generate database documentation using CASE tools

• Run data definition language (DDL) statements
• Identify the major structural components of the Oracle Database
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data
• Employ SQL & PL/SQL functions to generate and retrieve customized data
• Create PL/SQL Triggers
• Create PL/SQL Stored Procedures and Functions

• List the features of Oracle Database
• Describe the salient features of Oracle Cloud
• Discuss the theoretical and physical aspects of a relational database
• Describe Oracle server's implementation of RDBMS and object relational database management system (ORDBMS)
• Understand SQL statements, as well as the Oracle Relational Database.
• Use SQL Developer.
• Write reports using SQL statements.
• Manipulate data in relational tables and save the data.
• Understand the concepts of relational databases and the powerful SQL programming language.
• Write reports using SQL Statements

• Add new users with different levels of access privileges
• Manage schema objects
• Run data definition language (DDL) statements to create and manage schema objects
• Manage objects with data dictionary views
• Control database access to specific objects
• Manipulate large data sets in the Oracle database by using subqueries
• Manage data in different time zones
• Write multiple-column subqueries
• Use scalar and correlated subqueries
• Use the regular expression support in SQL

• Identify the major structural components of the Oracle Database
• Create reports of aggregated data
• Write SELECT statements that include queries
• Retrieve row and column data from tables
• Run data manipulation statements (DML) in Oracle Database 12c
• Create tables to store data
• Utilize views to display data
• Control database access to specific objects
• Manage schema objects
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Manage objects with data dictionary views
• Write multiple-column sub-queries
• Employ SQL functions to retrieve customized data
• Use scalar and correlated sub-queries
• Create reports of sorted and restricted data

• Run data definition language (DDL) statements
• Identify the major structural components of the Oracle Database
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data
• Employ SQL & PL/SQL functions to generate and retrieve customized data
• Create PL/SQL Triggers
• Create PL/SQL Stored Procedures and Functions

• Run data definition language (DDL) statements
• Identify the major structural components of the Oracle Database
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data
• Employ SQL & PL/SQL functions to generate and retrieve customized data
• Create PL/SQL Triggers
• Create PL/SQL Stored Procedures and Functions

• Run data definition language (DDL) statements
• Identify the major structural components of the Oracle Database
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data
• Employ SQL & PL/SQL functions to generate and retrieve customized data
• Create PL/SQL Triggers
• Create PL/SQL Stored Procedures and Functions

• Run data definition language (DDL) statements
• Identify the major structural components of the Oracle Database
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data
• Employ SQL & PL/SQL functions to generate and retrieve customized data
• Create PL/SQL Triggers
• Create PL/SQL Stored Procedures and Functions

• Introduction to PL/SQL Programming
• PL/SQL Blocks
• Creating an Anonymous Block
• Write Executable Statements
• Declaring PL/SQL Variables
• Working with Composite Data Types
• Conditionally control code flow (loops, control structures)
• Explicit cursors
• Handle runtime errors
• Describe stored procedures and functions

• Introduction to PL/SQL Programming
• PL/SQL Blocks
• Creating an Anonymous Block
• Write Executable Statements
• Declaring PL/SQL Variables
• Working with Composite Data Types
• Conditionally control code flow (loops, control structures)
• Explicit cursors
• Handle runtime errors
• Describe stored procedures and functions

• Introduction to PL/SQL Programming
• PL/SQL Blocks
• Creating an Anonymous Block
• Write Executable Statements
• Declaring PL/SQL Variables
• Working with Composite Data Types
• Conditionally control code flow (loops, control structures)
• Explicit cursors
• Handle runtime errors
• Describe stored procedures and functions

• Introduction to PL/SQL Programming
• PL/SQL Blocks
• Creating an Anonymous Block
• Write Executable Statements
• Declaring PL/SQL Variables
• Working with Composite Data Types
• Conditionally control code flow (loops, control structures)
• Explicit cursors
• Handle runtime errors
• Describe stored procedures and functions

• Understand Relational Database Modelling
• Identify Oracle Database Development Tools
• Install your Oracle Software
• Understand the Oracle Database 18/19c Enterprise Edition Options
• Understand the Oracle Database Architecture
• Identify the major structural components of the Oracle Database 11g
• Manage objects with data dictionary views
• Manage schema objects
• Run data definition language (DDL) statements to create and manage schema objects
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data
• Employ SQL & PL/SQL functions to generate and retrieve customized data
• Create PL/SQL Triggers
• Create PL/SQL Stored Procedures and Functions
• Create PL/SQL Packages

• Understand Relational Database Modelling
• Identify Oracle Database Development Tools
• Install your Oracle Software
• Understand the Oracle Database 21c Enterprise Edition Options
• Understand the Oracle Database Architecture
• Identify the major structural components of the Oracle Database 11g
• Manage objects with data dictionary views
• Manage schema objects
• Run data definition language (DDL) statements to create and manage schema objects
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data
• Employ SQL & PL/SQL functions to generate and retrieve customized data
• Create PL/SQL Triggers
• Create PL/SQL Stored Procedures and Functions
• Create PL/SQL Packages

• Manage PDB snapshots
• Encrypt data in PDBs and isolate PDB keystore
• Monitor performance in CDBs and PDBs
• Audit users in CDB and PDBs
• Protect data with Database Vault policies in CDB and PDBs
• Manage a CDB fleet
• Manage resource allocation between PDBs and within a PDB
• Use Data Pump operations from a non-CDB or CDB into a PDB
• Upgrade 11g to 12c CDBs or PDBs
• Upgrade 12c CDBs or PDBs to 12c R2
• Configure and create a CDB
• Create, clone, unplug, plug, relocate, proxy, switch over and drop PDBs
• Startup and shutdown CDBs and PDBs
• Manage tablespaces in CDB and PDBs
• Manage common and local users, roles, privileges, profiles, objects in CDBs and PDBs
• Manage PDB lockdown profiles
• Backup, duplicate, recover and flashback CDB and PDBs

• Manage PDB snapshots
• Encrypt data in PDBs and isolate PDB keystore
• Monitor performance in CDBs and PDBs
• Audit users in CDB and PDBs
• Protect data with Database Vault policies in CDB and PDBs
• Manage a CDB fleet
• Manage resource allocation between PDBs and within a PDB
• Use Data Pump operations from a non-CDB or CDB into a PDB
• Upgrade 12c CDBs or PDBs to 18c
• Configure and create a CDB
• Create, clone, unplug, plug, relocate, proxy, switch over and drop PDBs
• Startup and shutdown CDBs and PDBs
• Manage tablespaces in CDB and PDBs
• Manage common and local users, roles, privileges, profiles, objects in CDBs and PDBs
• Manage PDB lockdown profiles
• Backup, duplicate, recover and flashback CDB and PDBs

• Manage PDB snapshots
• Encrypt data in PDBs and isolate PDB keystore
• Monitor performance in CDBs and PDBs
• Audit users in CDB and PDBs
• Protect data with Database Vault policies in CDB and PDBs
• Manage a CDB fleet
• Manage resource allocation between PDBs and within a PDB
• Use Data Pump operations from a non-CDB or CDB into a PDB
• Upgrade 12c CDBs or PDBs to 18c
• Configure and create a CDB
• Create, clone, unplug, plug, relocate, proxy, switch over and drop PDBs
• Startup and shutdown CDBs and PDBs
• Manage tablespaces in CDB and PDBs
• Manage common and local users, roles, privileges, profiles, objects in CDBs and PDBs
• Manage PDB lockdown profiles
• Backup, duplicate, recover and flashback CDB and PDBs

• Manage PDB snapshots
• Encrypt data in PDBs and isolate PDB keystore
• Monitor performance in CDBs and PDBs
• Audit users in CDB and PDBs
• Protect data with Database Vault policies in CDB and PDBs
• Manage a CDB fleet
• Manage resource allocation between PDBs and within a PDB
• Use Data Pump operations from a non-CDB or CDB into a PDB
• Upgrade 12c CDBs or PDBs to 18c
• Configure and create a CDB
• Create, clone, unplug, plug, relocate, proxy, switch over and drop PDBs
• Startup and shutdown CDBs and PDBs
• Manage tablespaces in CDB and PDBs
• Manage common and local users, roles, privileges, profiles, objects in CDBs and PDBs
• Manage PDB lockdown profiles
• Backup, duplicate, recover and flashback CDB and PDBs

• Describe Oracle Database architecture
• Explain Oracle Database Cloud Service (DBCS) architecture and features
• Manage an Oracle Database instance
• Configure the Oracle Network environment
• Create and manage DBCS database deployments
• Create and manage storage structures
• Configure the database to support your applications
• Manage database security and implement auditing
• Create and manage users
• Implement basic backup and recovery procedures
• Manage and move data
• Move data between databases and files
• Employ basic monitoring procedures and manage performance
• Monitor the database and manage performance
• Create and manage Database Cloud Service database deployments

• Describe Oracle Database architecture
• Explain Oracle Database Cloud Service (DBCS) architecture and features
• Manage an Oracle Database instance
• Configure the Oracle Network environment
• Create and manage DBCS database deployments
• Create and manage storage structures
• Configure the database to support your applications
• Manage database security and implement auditing
• Create and manage users
• Implement backup and recovery procedures
• Manage and move data
• Move data between databases and files
• Employ monitoring procedures and manage performance
• Monitor the database and manage performance
• Create and manage Database Cloud Service database deployments

• 1Z0-071 -- Oracle Database 19c: Certified Associate - SQL Fundamentals
• 1Z0-149 -- Oracle Database 19c: Program with PL/SQL - Certified Associate
• 1Z0-082 -- Oracle Database 19c: Administration Fundamentals I Certified Associate

• Describe Oracle Database architecture
• Explain Oracle Database Cloud Service (DBCS) architecture and features
• Manage an Oracle Database instance
• Configure the Oracle Network environment
• Create and manage DBCS database deployments
• Create and manage storage structures
• Configure the database to support your applications
• Manage database security and implement auditing
• Create and manage users
• Implement backup and recovery procedures
• Manage and move data
• Move data between databases and files
• Employ monitoring procedures and manage performance
• Monitor the database and manage performance
• Create and manage Database Cloud Service database deployments

• Describe Oracle Database architecture
• Describe Oracle Database 21c blockchain architecture
• Explain Oracle Database Cloud Service (DBCS) architecture and features
• Manage an Oracle Database instance
• Configure the Oracle Network environment
• Create and manage DBCS database deployments
• Create and manage storage structures
• Configure the database to support your applications
• Manage database security and implement auditing
• Create and manage users
• Implement basic backup and recovery procedures
• Manage and move data
• Move data between databases and files
• Employ basic monitoring procedures and manage performance
• Monitor the database and manage performance
• Create and manage Database Cloud Service database deployments

• 1Z0-071 -- Oracle Database 19c: Certified Associate - SQL Fundamentals
• 1Z0-149 -- Oracle Database 19c: Program with PL/SQL - Certified Associate
• 1Z0-082 -- Oracle Database 19c: Administration Fundamentals I Certified Associate

• 1Z0-071 -- Oracle Database 21c: Certified Associate - SQL Fundamentals
• 1Z0-149 -- Oracle Database 21c: Program with PL/SQL - Certified Associate
• 1Z0-082 -- Oracle Database 21c: Administration Fundamentals I Certified Associate

• Oracle Database: Introduction to Database Modelling
• 1Z0-071 -- Oracle Database: Certified Associate - SQL Workshop I
• 1Z0-149 -- Oracle Database: Certified Professional - SQL and PL/SQL Fundamentals
• 1Z0-082 -- Oracle Database: Admin, Install and Upgrade Accelerated
• 1Z0-082 -- Oracle Database: Backup and Recovery Workshop
• 1Z0-082 -- Oracle Database: Managing Multitenant Architecture

• Enter data, retrieve information in the form of a query, access online Help
• Access and navigate within Oracle Applications using the user interface
• Identify the benefits of R12 Applications footprint
• Understand major architectural components
• Understand shared entities, key business flows, and integration points
• Describe and define the concepts of System Administration
• Describe and define fundamentals of Flexfields
• Understand Multi-Org, Workflow and Alerts
• Understand Daily Business Intelligence Oracle Applications
• Understand Fusion Intelligence for Oracle Applications
• Understand the steps for completing the full accounting cycle
• Understand the ledger concept
• Apply concepts of Legal Entity and Ledger
• Understand how Oracle General Ledger integrates with the eBusiness Suite of applications
• Implement features of Journal Creation, Posting, Reversal, Recurring of Journal
• Implement functionalities around Mass Allocation and Revaluation
• Apply concepts of Consolidation
• Implement features of Translation
• Implement features of Financial Reporting

• Enter data, retrieve information in the form of a query, access online Help
• Access and navigate within Oracle Applications using the user interface
• Identify the benefits of R12 Applications footprint
• Understand major architectural components
• Understand shared entities, key business flows, and integration points
• Describe and define the concepts of System Administration
• Describe and define fundamentals of Flexfields
• Understand Multi-Org, Workflow and Alerts
• Understand Daily Business Intelligence Oracle Applications
• Understand Fusion Intelligence for Oracle Applications
• Understand the steps for completing the full accounting cycle
• Understand the ledger concept
• Apply concepts of Legal Entity and Ledger
• Understand how Oracle General Ledger integrates with the eBusiness Suite of applications
• Implement features of Journal Creation, Posting, Reversal, Recurring of Journal
• Implement functionalities around Mass Allocation and Revaluation
• Apply concepts of Consolidation
• Implement features of Translation
• Implement features of Financial Reporting

• Enter data, retrieve information in the form of a query, access online Help
• Access and navigate within Oracle Applications using the user interface
• Identify the benefits of R12 Applications footprint
• Understand major architectural components
• Understand shared entities, key business flows, and integration points
• Describe and define the concepts of System Administration
• Describe and define fundamentals of Flexfields
• Understand Multi-Org, Workflow and Alerts
• Understand Daily Business Intelligence Oracle Applications
• Understand Fusion Intelligence for Oracle Applications
• Understand the Order to Cash Lifecycle
• Understand the Oracle Receivables process
• Manage parties and customer accounts
• Process invoices using Auto-Invoice
• Utilize the bill presentment architecture processes
• Set up credit management
• Implement the receipt process
• Implement tax processing and period closing

• Enter data, retrieve information in the form of a query, access online Help
• Access and navigate within Oracle Applications using the user interface
• Identify the benefits of R12 Applications footprint
• Understand major architectural components
• Understand shared entities, key business flows, and integration points
• Describe and define the concepts of System Administration
• Describe and define fundamentals of Flexfields
• Understand Multi-Org, Workflow and Alerts
• Understand Daily Business Intelligence Oracle Applications
• Understand Fusion Intelligence for Oracle Applications
• Understand the Order to Cash Lifecycle
• Understand the Oracle Receivables process
• Manage parties and customer accounts
• Process invoices using Auto-Invoice
• Utilize the bill presentment architecture processes
• Set up credit management
• Implement the receipt process
• Implement tax processing and period closing

• Enter data, retrieve information in the form of a query, access online Help
• Access and navigate within Oracle Applications using the user interface
• Identify the benefits of R12 Applications footprint
• Understand major architectural components
• Understand shared entities, key business flows, and integration points
• Describe and define the concepts of System Administration
• Describe and define fundamentals of Flexfields
• Understand Multi-Org, Workflow and Alerts
• Understand Daily Business Intelligence Oracle Applications
• Understand Fusion Intelligence for Oracle Applications
• Apply concepts of Procure-to-Pay process flow
• Implement key features of Oracle Payables
• Implement key functionalities of Suppliers
• Implement functionalities around Invoices
• Implement key features of Payments
• Implement key features of Expense Reports and Credit Cards

• Enter data, retrieve information in the form of a query, access online Help
• Access and navigate within Oracle Applications using the user interface
• Identify the benefits of R12 Applications footprint
• Understand major architectural components
• Understand shared entities, key business flows, and integration points
• Describe and define the concepts of System Administration
• Describe and define fundamentals of Flexfields
• Understand Multi-Org, Workflow and Alerts
• Understand Daily Business Intelligence Oracle Applications
• Understand Fusion Intelligence for Oracle Applications
• Apply concepts of Procure-to-Pay process flow
• Implement key features of Oracle Payables
• Implement key functionalities of Suppliers
• Implement functionalities around Invoices
• Implement key features of Payments
• Implement key features of Expense Reports and Credit Cards

• Enter data, retrieve information in the form of a query, access online Help
• Access and navigate within Oracle Applications using the user interface
• Identify the benefits of R12 Applications footprint
• Understand major architectural components
• Understand shared entities, key business flows, and integration points
• Describe and define the concepts of System Administration
• Describe and define fundamentals of Flexfields
• Understand Multi-Org, Workflow and Alerts
• Understand Daily Business Intelligence Oracle Applications
• Understand Fusion Intelligence for Oracle Applications
• Perform the document approval process
• Define requisitions
• Enter purchase order agreements
• Create purchase orders
• Create planned purchase orders
• Enter purchase order releases
• View tax information
• Use the professional buyer’s workcenter
• Understand receiving
• View purchasing inquiries
• Use purchasing approvals, security, and control
• Understand supply based management
• Enter and manage requests for quotes (RFQs)
• Set up receipt accounting
• Understand all standard purchasing functions
• Run purchasing reports

• Enter data, retrieve information in the form of a query, access online Help
• Access and navigate within Oracle Applications using the user interface
• Identify the benefits of R12 Applications footprint
• Understand major architectural components
• Understand shared entities, key business flows, and integration points
• Describe and define the concepts of System Administration
• Describe and define fundamentals of Flexfields
• Understand Multi-Org, Workflow and Alerts
• Understand Daily Business Intelligence Oracle Applications
• Understand Fusion Intelligence for Oracle Applications
• Perform the document approval process
• Define requisitions
• Enter purchase order agreements
• Create purchase orders
• Create planned purchase orders
• Enter purchase order releases
• View tax information
• Use the professional buyer’s workcenter
• Understand receiving
• View purchasing inquiries
• Use purchasing approvals, security, and control
• Understand supply based management
• Enter and manage requests for quotes (RFQs)
• Set up receipt accounting
• Understand all standard purchasing functions
• Run purchasing reports

• Enter data, retrieve information in the form of a query, access online Help
• Access and navigate within Oracle Applications using the user interface
• Identify the benefits of R12 Applications footprint
• Understand major architectural components
• Understand shared entities, key business flows, and integration points
• Describe and define the concepts of System Administration
• Describe and define fundamentals of Flexfields
• Understand Multi-Org, Workflow and Alerts
• Understand Daily Business Intelligence Oracle Applications
• Understand Fusion Intelligence for Oracle Applications
• Understand the structure of an inventory organization in Oracle Inventory
• Define items in Oracle Inventory
• Understand the concept of move orders
• Learn to implement locator, revision, serial, and lot control for items
• Perform inventory transactions such as inter-organisation transfer
• Understand how to create units of measure
• Understand how to create reservations
• Understand how to view on-hand quantities
• Understand how to define material statuses
• Understand how to define and maintain a cycle count
• Create an ABC ranking of items to be used in cycle counting
• Understand the overall inventory process in Oracle Inventory
• Define inventory items for Oracle Supply Chain Applications
• Perform inventory replenishment
• Perform ABC classification and cycle count
• Perform inventory transactions
• Use mobile devices to perform inventory transactions

• Enter data, retrieve information in the form of a query, access online Help
• Access and navigate within Oracle Applications using the user interface
• Identify the benefits of R12 Applications footprint
• Understand major architectural components
• Understand shared entities, key business flows, and integration points
• Describe and define the concepts of System Administration
• Describe and define fundamentals of Flexfields
• Understand Multi-Org, Workflow and Alerts
• Understand Daily Business Intelligence Oracle Applications
• Understand Fusion Intelligence for Oracle Applications
• Understand the structure of an inventory organization in Oracle Inventory
• Define items in Oracle Inventory
• Understand the concept of move orders
• Learn to implement locator, revision, serial, and lot control for items
• Perform inventory transactions such as inter-organisation transfer
• Understand how to create units of measure
• Understand how to create reservations
• Understand how to view on-hand quantities
• Understand how to define material statuses
• Understand how to define and maintain a cycle count
• Create an ABC ranking of items to be used in cycle counting
• Understand the overall inventory process in Oracle Inventory
• Define inventory items for Oracle Supply Chain Applications
• Perform inventory replenishment
• Perform ABC classification and cycle count
• Perform inventory transactions
• Use mobile devices to perform inventory transactions

• Enter data, retrieve information in the form of a query, access online Help
• Access and navigate within Oracle Applications using the user interface
• Identify the benefits of R12 Applications footprint
• Understand major architectural components
• Understand shared entities, key business flows, and integration points
• Describe and define the concepts of System Administration
• Describe and define fundamentals of Flexfields
• Understand Multi-Org, Workflow and Alerts
• Understand Daily Business Intelligence Oracle Applications
• Understand Fusion Intelligence for Oracle Applications
• Set up organizations that correspond to your business units in Oracle Applications
• Understand the order-to-cash lifecycle
• Explain shipping flows within the order-to-cash lifecycle
• Set up and use shipping entities to perform shipping-related activities
• Set up multiple organization access control for Oracle Order Management
• Define subinventories, units of measure, and items
• Define item orderability rules
• Define user defined attributes for orders and lines
• Define customers, invoice information, and credit checking
• Explain tax-related setup steps
• Set up profile options and system parameters
• Set up processing constraints, defaulting rules and transaction types
• Use scheduling and workflow
• Define holds

• Enter data, retrieve information in the form of a query, access online Help
• Access and navigate within Oracle Applications using the user interface
• Identify the benefits of R12 Applications footprint
• Understand major architectural components
• Understand shared entities, key business flows, and integration points
• Describe and define the concepts of System Administration
• Describe and define fundamentals of Flexfields
• Understand Multi-Org, Workflow and Alerts
• Understand Daily Business Intelligence Oracle Applications
• Understand Fusion Intelligence for Oracle Applications
• Set up organizations that correspond to your business units in Oracle Applications
• Understand the order-to-cash lifecycle
• Explain shipping flows within the order-to-cash lifecycle
• Set up and use shipping entities to perform shipping-related activities
• Set up multiple organization access control for Oracle Order Management
• Define subinventories, units of measure, and items
• Define item orderability rules
• Define user defined attributes for orders and lines
• Define customers, invoice information, and credit checking
• Explain tax-related setup steps
• Set up profile options and system parameters
• Set up processing constraints, defaulting rules and transaction types
• Use scheduling and workflow
• Define holds

• Enter data, retrieve information in the form of a query, access online Help
• Access and navigate within Oracle Applications using the user interface
• Identify the benefits of R12.1 Applications footprint
• Understand major architectural components
• Understand shared entities, key business flows, and integration points
• Describe and define the concepts of System Administration
• Describe and define fundamentals of Flexfields
• Understand Multi-Org, Workflow and Alerts
• Understand Daily Business Intelligence Oracle Applications
• Understand Fusion Intelligence for Oracle Applications
• Understand the Expense Report Process
• Use Oracle Internet Expenses
• Setup and Implement Oracle Internet Expenses
• Using the Disconnected Expense Report Process
• Configure and use Expense Templates
• Establish Credit Card Programs
• Describe Credit Card Transactions Accounting
• Understanding the Approval Process
• Customising Internet Expenses
• Audit Automation Setup and Management

• Enter data, retrieve information in the form of a query, access online Help
• Access and navigate within Oracle Applications using the user interface
• Identify the benefits of R12.2 Applications footprint
• Understand major architectural components
• Understand shared entities, key business flows, and integration points
• Describe and define the concepts of System Administration
• Describe and define fundamentals of Flexfields
• Understand Multi-Org, Workflow and Alerts
• Understand Daily Business Intelligence Oracle Applications
• Understand Fusion Intelligence for Oracle Applications
• Understand the Expense Report Process
• Use Oracle Internet Expenses
• Setup and Implement Oracle Internet Expenses
• Using the Disconnected Expense Report Process
• Configure and use Expense Templates
• Establish Credit Card Programs
• Describe Credit Card Transactions Accounting
• Understanding the Approval Process
• Customising Internet Expenses
• Audit Automation Setup and Management

On successful Completion of the Functional Foundation course you will be able to:

• Understand the Oracle Applications Footprint
• Navigate Oracle Applications
• Understand Legal Entities, Tools and Applications
• Understand Flexfields
• Describe person types
• Understand how to represent your workforce using Oracle HRMS
• Identify components of the assignment
• Describe collective agreements
• Describe HRMS and HRMS workforce reports
• Identify the different workers in your enterprise
• Demonstrate how to manage assignments
• Demonstrate how to enter disability information
• Describe how to terminate a person
• Demonstrate how to transfer employees
• Demonstrate how to create people records
• Describe the key workforce concepts in Oracle HRMS
• Use reporting tools to track your workforce, and ensure you meet corporate objectives
• Organize your workforce exactly as your enterprise requires
• Manage a global workforce while addressing local country requirements
• Recognize Self-Service HR Capabilities.

On successful Completion of the Functional Foundation course you will be able to:

• Understand the Oracle Applications Footprint
• Navigate Oracle Applications
• Understand Legal Entities, Tools and Applications
• Understand Flexfields
• Describe person types
• Understand how to represent your workforce using Oracle HRMS
• Identify components of the assignment
• Describe collective agreements
• Describe HRMS and HRMS workforce reports
• Identify the different workers in your enterprise
• Demonstrate how to manage assignments
• Demonstrate how to enter disability information
• Describe how to terminate a person
• Demonstrate how to transfer employees
• Demonstrate how to create people records
• Describe the key workforce concepts in Oracle HRMS
• Use reporting tools to track your workforce, and ensure you meet corporate objectives
• Organize your workforce exactly as your enterprise requires
• Manage a global workforce while addressing local country requirements
• Recognize Self-Service HR Capabilities.

• Recognize the Oracle Time and Labor product
• Recognize the timecard building blocks
• Understand the different flexible implementation options that OTL provides
• Recognize the element setup process for OTL
• Learn how to define approval periods and styles for timecards
• Understand time entry rules for validation
• Learn about timecard layouts and preferences
• Understand Oracle Time and Labor Rules (OTLR)
• Identify how the time management structures and policies fit together
• Configure OTLR
• Learn how to assign structures and policies to workers
• Transfer timecards to Batch Element Entry (BEE) and Oracle Projects
• Understand how to set up and use Change and Late Audit (CLA)
• Describe the advantages and flexibility of entry-level processing
• Use Timecard Dashboard
• Learn how OTL archives and restores timecard data

• Understand the benefits of iRecruitment
• Create setup information required to work with iRecruitment
• Configure iRecruitment pages
• Create and manage assessments
• Create and update vacancies
• Approve vacancies
• Search for jobs online
• Register with iRecruitment
• Create resumes online
• Apply for jobs
• Perform candidate searches
• Process candidates
• Progress applicants
• Create and update job offers to applicants
• Approve offers
• Create and send offers to applicants
• Hire applicants using Oracle HRMS and Oracle SSHR
• Search for vacancies assigned to agencies
• Create details of agency candidates
• Work with applicants as agency users
• Analyze recruitment process
• Generate recruitment letters

On successful Completion of the Talent and Workforce Management course you will be able to:

• Understand Recruitment Process and Lifecycle
• Understand Recruitment Activities
• Understand Selection Processing
• Understand The Hiring Process
• Understand Employment Relationships
• Understand Representing the Workforce
• Understand Managing Employment Information
• Understand Terminating and Rehiring an Employee
• Understand Career Management
• Understand the Performance Management Framework
• Understand Defining Competencies
• Understand Defining Appraisals
• Understand the use of SSHR to Manage Careers

On successful Completion of the Recruitment and Talent Management course you will be able to:

• Understand Recruitment Process and Lifecycle
• Understand Recruitment Activities
• Understand Selection Processing
• Understand The Hiring Process
• Understand Employment Relationships
• Understand Representing the Workforce
• Understand Managing Employment Information
• Understand Terminating and Rehiring an Employee
• Understand Career Management
• Understand the Performance Management Framework
• Understand Defining Competencies
• Understand Defining Appraisals
• Understand the use of SSHR to Manage Careers

• Understand the Oracle Applications Footprint
• Understand the Oracle Applications Architecture
• Identify the Oracle HRMS product family
• Recognise the Oracle HRMS products and applications infrastructure
• Navigate Oracle Applications user interface.
• Understand Legal Entities, Tools and Applications
• Understand Multiple-Organization and Multiple-Organization Access control (MOAC)
• Understand and perform System Administration activities
• Describe how Oracle HRMS meets enterprise challenges
• Describe the strategic value of human capital management
• Recognize the organizational structures in Oracle HRMS
• Identify the work structure components and their usage
• Define the unique structure of business entities such as jobs, positions, and grades
• Describe the recruitment and hiring processes
• Identify talent management features such as competencies, skills, and suitability matching
• Recognize the workforce relationship in Oracle HRMS
• Describe the basic process of compensation and benefits management
• Recognise Self-Service HR capabilities.
• Identify elements as building blocks of HRMS data
• Describe some of the key features from the Oracle Time and Labour solution
• Describe some of the key features from the Oracle Learning Management solution
• Recognise how Oracle Payroll integrates with other products in the HRMS family
• Identify the key components of the Oracle Payroll solution
• Describe some of the key features Oracle Payroll provides to manage payroll activities
• Identify the key features of Oracle Fast Formula
• Define key and descriptive Flexfields
• Identify and Setup Security in Oracle HCM/HRMS.

• Identify the compensation management tools that Oracle HRMS provides
• Identify and explain compensation management features and benefits
• Identify salary components, salary basis, and salary elements
• Learn how to administer salary changes
• Learn how to enter and maintain compensation survey data
• Learn how to set up grade rates, pay scales, and scale rates
• Understand the grade/step progression business process
• Understand the HCM/HRMS Total Compensation model
• Define and manage elements
• Handle benefits enrollments
• Explain the framework for Compensation and Benefits setup and administration in Oracle HCM/HRMS
• Discuss the use of elements to represent different types of earnings and deductions in Oracle HCM
• Discuss how the same elements are used by HCM, Payroll and Benefits and discuss any differences
• Explain the difference between recurring and nonrecurring types of elements
• Recognise the predefined elements in Oracle HCM
• Identify the predefined elements installed with Oracle HRMS products
• Explain the use of Elements to represent values for different types of earnings and deductions
• Explain the differences between recurring and nonrecurring types of elements
• Implement and administer Compensation Workbench
• Set up and administer Individual Compensation Distributions (ICD)
• Maintain a vehicle repository and allocate company vehicles to employees
• Use absence types, categories, and reasons to track and report employee absences

• Understand the Oracle Applications Footprint
• Navigate Oracle Applications
• Identify the types of payroll processes available in Oracle HRMS
• Identify the payroll lifecycle periods
• Use Advance Pay and RetroPay
• Make balance adjustments
• Make corrections, rollbacks, reversals, and retries
• Use the special features of Oracle Payroll
• View and adjust employee balances
• Understand the payroll lifecycle
• Run payrolls using batch and QuickPay processes
• Run prepayments and payments processes
• Run costing and transfer to GL processes
• Manage exceptions and corrections

• Create competencies and competency profiles
• Define competency requirements for business groups, organizations, and jobs
• Record worker qualifications
• Configure appraisals using appraisal and assessment templates and conduct appraisals
• Assess competencies and objectives during appraisals
• Create objectives in the Objectives Library
• Create performance management plans to manage workforce performance
• Use performance management tasks to set objectives and manage appraisals in a performance management plan

• Understand the terminology and concepts used in SSHR
• Identify which functions are available and understand the difference between employee and manager functions
• Understand how different users can use self-service applications
• Understand the architecture of the E-business Suite
• Understand how self-service functions operate
• Understand how different elements determine how the function operates
• Understand how Workflow Builder operates
• Understand how Oracle Application Framework operates
• Understand how Data Security operates
• Learn how to create custom menus containing required functions
• Understand the different approvals mechanisms
• Use Oracle Approvals Management
• Configure approvals
• Understand which self-service applications are available in HRMS
• Integrate and access personal information and absence policies on a third party applications
• Configure elements of SSHR to suit your requirements

• Explain the fundamentals of receivables
• Maintain customers
• Enter receivables
• Enter, apply, and review payments
• Process Payment Predictor
• Perform account aging and communication
• Manage credit, collections, and exceptions
• Maintain receivables
• Update receivables
• Transfer receivables
• Process exceptions and collections
• Process multiple currencies
• Interface with U.S. Federal Systems
• Run financial and SCM reports

• Explain the fundamentals of receivables
• Maintain customers
• Enter receivables
• Enter, apply, and review payments
• Process Payment Predictor
• Perform account aging and communication
• Manage credit, collections, and exceptions
• Maintain receivables
• Update receivables
• Transfer receivables
• Process exceptions and collections
• Process multiple currencies
• Interface with U.S. Federal Systems
• Run financial and SCM reports

• Maintain customers
• Enter bills online
• Create consolidated bills
• Work with billing interfaces
• Create recurring bills
• Copy a group of bills
• Research bills
• Use accumulations
• Generate invoices
• Adjust bills
• Generate deferred revenue
• Generate unbilled revenue accrual
• Create InterUnit customers and bills
• Manage installment bills
• Use multiple currencies
• Run reports

• Maintain customers
• Enter bills online
• Create consolidated bills
• Work with billing interfaces
• Create recurring bills
• Copy a group of bills
• Research bills
• Use accumulations
• Generate invoices
• Adjust bills
• Generate deferred revenue
• Generate unbilled revenue accrual
• Create InterUnit customers and bills
• Manage installment bills
• Use multiple currencies
• Run reports

• Create contracts
• Work with milestones
• Create billing plans
• Create revenue recognition plans
• Book and manage revenue
• Amend a contract
• Renew a contract

• Create contracts
• Work with milestones
• Create billing plans
• Create revenue recognition plans
• Book and manage revenue
• Amend a contract
• Renew a contract

• Set up user preferences
• Manage journal entries
• Process journals
• Use commitment control
• Use Open Item accounting
• Use Inter/IntraUnit accounting
• Process multiple currencies
• Process allocations
• Maintain budgets
• Calculate average balance
• Manage interim and year-end processing
• Run reports

• Set up user preferences
• Manage journal entries
• Process journals
• Use commitment control
• Use Open Item accounting
• Use Inter/IntraUnit accounting
• Process multiple currencies
• Process allocations
• Maintain budgets
• Calculate average balance
• Manage interim and year-end processing
• Run reports

• Define inventory facility structure
• Define inventory items
• Maintain containers
• Stock material (Putaway)
• Discuss cross docking
• Setup demand fulfillment options
• Create material stock requests
• Reserve inventory
• Pick inventory
• Ship inventory
• Define transaction accounting rules
• Replenish inventory
• Transfer stock
• Count inventory stock
• Maintain par locations
• Maintain inventory
• Run reports

• Define inventory facility structure
• Define inventory items
• Maintain containers
• Stock material (Putaway)
• Discuss cross docking
• Setup demand fulfillment options
• Create material stock requests
• Reserve inventory
• Pick inventory
• Ship inventory
• Define transaction accounting rules
• Replenish inventory
• Transfer stock
• Count inventory stock
• Maintain par locations
• Maintain inventory
• Run reports

• Maintain employee profiles
• Prepare travel authorizations
• Prepare cash advances
• Prepare expense reports
• Process expense report exceptions
• Prepare time reports and time adjustments
• Use commitment control with Expenses
• Manage approvals in Expenses
• Process expense payments
• Post expense transactions
• View accounting transactions in Expenses
• Describe how to run reports in PeopleSoft Enterprise

• Maintain employee profiles
• Prepare travel authorizations
• Prepare cash advances
• Prepare expense reports
• Process expense report exceptions
• Prepare time reports and time adjustments
• Use commitment control with Expenses
• Manage approvals in Expenses
• Process expense payments
• Post expense transactions
• View accounting transactions in Expenses
• Describe how to run reports in PeopleSoft Enterprise

• Set up PeopleSoft Enterprise Purchasing foundation tables
• Set up vendor data
• Create item categories and purchasing kits
• Create requisitions and source to purchase orders
• Manage receipts
• Manage change orders
• Configure procurement options

• Set up PeopleSoft Enterprise Purchasing foundation tables
• Set up vendor data
• Create item categories and purchasing kits
• Create requisitions and source to purchase orders
• Manage receipts
• Manage change orders
• Configure procurement options

• Describe PeopleSoft Query
• Create simple queries
• Create queries using multiple records
• Export query results
• Create, design and format Oracle BI Publisher
• Standardize reports

• Maintain vendor records
• Enter different types of vouchers
• Manage vouchers
• Use control groups
• Work with Recurring Voucher Contracts
• Process payments
• Perform batch processing
• Perform inquiries
• Run Financials and SCM Reports

• Maintain vendor records
• Enter different types of vouchers
• Manage vouchers
• Use control groups
• Work with Recurring Voucher Contracts
• Process payments
• Perform batch processing
• Perform inquiries
• Run Financials and SCM Reports

• Add and maintain assets
• Adjust and transfer assets
• Perform physical inventory
• Understand composite asset processing
• Work with leased assets
• Work with asset budgeting
• Retire assets
• Archive asset information
• Process depreciation
• Use user-defined depreciation
• Calculate depreciation
• Create accounting entries
• Integrate with other applications
• Use group asset processing
• Change assets in mass
• Track repairs and service
• Work with joint venture processing
• Run reports

• Add and maintain assets
• Adjust and transfer assets
• Perform physical inventory
• Understand composite asset processing
• Work with leased assets
• Work with asset budgeting
• Retire assets
• Archive asset information
• Process depreciation
• Use user-defined depreciation
• Calculate depreciation
• Create accounting entries
• Integrate with other applications
• Use group asset processing
• Change assets in mass
• Track repairs and service
• Work with joint venture processing
• Run reports

• Set up user preferences
• Manage journal entries
• Process journals
• Use commitment control
• Use Open Item accounting
• Use Inter/IntraUnit accounting
• Process multiple currencies
• Process allocations
• Maintain budgets
• Calculate average balance
• Manage interim and year-end processing
• Run reports

• Set up user preferences
• Manage journal entries
• Process journals
• Use commitment control
• Use Open Item accounting
• Use Inter/IntraUnit accounting
• Process multiple currencies
• Process allocations
• Maintain budgets
• Calculate average balance
• Manage interim and year-end processing
• Run reports

• Explain the fundamental concepts of Order Management
• Maintain customer information
• Establish products and items
• Define transportation and freight
• Create communications
• Establish holds
• Establish pricing adjustments
• Create sales order entries
• Use advanced CSR options
• Create sales quotes
• Maintain buying agreements
• Create counter sales
• Use express order entry
• Define order bills
• Define returned material authorizations

• Explain the fundamental concepts of Order Management
• Maintain customer information
• Establish products and items
• Define transportation and freight
• Create communications
• Establish holds
• Establish pricing adjustments
• Create sales order entries
• Use advanced CSR options
• Create sales quotes
• Maintain buying agreements
• Create counter sales
• Use express order entry
• Define order bills
• Define returned material authorizations

• Define planning and budgeting
• Explain the budgeting integrations at a high level
• Design a planning model
• Use flexible formulas
• Update a planning model
• Use the planning workspace
• Use line item activities
• Use mass adjustments and allocations
• Use position budgeting
• Use asset budgeting
• Use budget analysis and reporting

• Define planning and budgeting
• Explain the budgeting integrations at a high level
• Design a planning model
• Use flexible formulas
• Update a planning model
• Use the planning workspace
• Use line item activities
• Use mass adjustments and allocations
• Use position budgeting
• Use asset budgeting
• Use budget analysis and reporting

• Create projects in PeopleSoft
• Maintain projects in PeopleSoft
• Organize projects
• Analyze projects
• Manage resource transactions
• Explain the basics of project integration
• Explain Projects integration with Asset Management
• Explain Projects integration with General Ledger
• Explain Projects integration with Procurement
• Explain Projects integration with Time and Labor
• Explain Projects integration with Expenses
• Explain Projects integration with third-party applications

• Create projects in PeopleSoft
• Maintain projects in PeopleSoft
• Organize projects
• Analyze projects
• Manage resource transactions
• Explain the basics of project integration
• Explain Projects integration with Asset Management
• Explain Projects integration with General Ledger
• Explain Projects integration with Procurement
• Explain Projects integration with Time and Labor
• Explain Projects integration with Expenses
• Explain Projects integration with third-party applications

• Prepare and submit proposals
• Describe cost-sharing
• Manage awards and projects
• Apply transactions to Grants
• Prepare and submit protocols
• Manage award billing
• Manage award revenue
• Manage advances
• Establish continuation proposals
• Perform the award close out process
• Run Financial and SCM reports

• Prepare and submit proposals
• Describe cost-sharing
• Manage awards and projects
• Apply transactions to Grants
• Prepare and submit protocols
• Manage award billing
• Manage award revenue
• Manage advances
• Establish continuation proposals
• Perform the award close out process
• Run Financial and SCM reports

• Create a project
• Create a Work Breakdown Structure
• Add activities
• Customize activity views
• Create relationships
• Schedule the project
• Assign constraints
• View the Enterprise Project Structure
• Optimize the project schedule
• Assign roles and resources
• Analyze resources and costs
• Baseline the project plan
• Execute the project
• Customize dashboards
• Manage risk
• View reports

• Understand portfolio management
• Understand the Primavera approach to portfolio management
• Use and create forms and scorecards
• Customise a scorecard
• Use investor maps, workbooks and dashboards
• Create portfolios
• Enter data in a form
• Use and create processes
• Start a workflow
• Create process links
• Track deliverables in a workbook
• View dashboards
• View an investor map
• View items in Primavera portfolio management

• Define basic terminology of project management
• Identify the project management life cycle
• Understand the project management knowledge areas
• Build a business case for project initiation
• Define project scope and stakeholder expectations
• Define roles and responsibilities for project stakeholders
• Ensure buy-in from your team and sponsors
• Create project management plans for quality, communication, resources, and stakeholder management
• Use advanced scheduling techniques
• Learn to Manage Teams and multiple projects
• Create resource teams
• Use high-level resource planning
• Staff resource requests and use Progress Reporter
• Use resource levelling

• Create a project
• Create a Work Breakdown Structure
• Add activities
• Customize activity views
• Create relationships
• Schedule the project
• Assign constraints
• View the Enterprise Project Structure
• Optimize the project schedule
• Assign roles and resources
• Analyze resources and costs
• Baseline the project plan
• Execute the project
• Customize dashboards
• Manage risk
• View reports
• Manage all Data within P6 Portfolios
• Import and Export data
• Create Portfolios
• Enter and revise data
• Use Scorecards
• Use Dashboards

• Create a project
• Create a Work Breakdown Structure
• Add activities
• Customize activity views
• Create relationships
• Schedule the project
• Assign constraints
• View the Enterprise Project Structure
• Optimize the project schedule
• Assign roles and resources
• Analyze resources and costs
• Baseline the project plan
• Execute the project
• Customize dashboards
• Manage risk
• View reports
• Manage all Data within P6 Portfolios
• Import and Export data
• Create Portfolios
• Enter and revise data
• Use Scorecards
• Use Dashboards

• Create a project
• Create a Work Breakdown Structure
• Add activities
• Customize activity views
• Create relationships
• Schedule the project
• Assign constraints
• View the Enterprise Project Structure
• Optimize the project schedule
• Assign roles and resources
• Analyze resources and costs
• Baseline the project plan
• Execute the project
• Customize dashboards
• Manage risk
• View reports
• Manage all Data within P6 Portfolios
• Import and Export data
• Create Portfolios
• Enter and revise data
• Use Scorecards
• Use Dashboards

• Understand Planning and Scheduling
• Understand Resource and Cost Management
• Understand Projects Office
• Create a project
• Create a Work Breakdown Structure
• Navigating Primavera Cloud
• Configuring Primavera Cloud
• Managing Projects and Costs
• Creating Project Portfolios
• Creating a Capital Portfolio
• Creating a Capital Plan
• Using Budget Planning
• Using Selection Analysis
• Comparing Scenarios
• Approving Scenarios
• Using the Performance Scorecard
• Managing Spending
• Using Workflows
• Understand Reporting and Analytics in Primavera Cloud

• The Query and Analysis Continuum
• OLAP and Business Intelligence Techniques
• Enterprise Reporting Architectures
• Create reports
• Create templates
• Run user-defined reports
• Update shell templates
• Define permissions
• Define data cubes and data views
• Configure dashboards
• View system reports
• Create custom Business Intelligence Publisher reports using data views

• Understand Planning and Scheduling
• Understand Resource and Cost Management
• Understand Projects Office
• Create a project
• Create a Work Breakdown Structure
• Create Workflows
• Plan Work Packages
• Schedule the project
• Assign constraints
• View the Enterprise Project Structure
• Create integrated planning - critical path method (CPM)
• Understand Capital Plan Management
• Create Plan Management
• Managing Projects and Costs
• Create Capital Plan Types and Capital Plans
• Assign roles and resources
• Analyze resources and costs
• Baseline the project plan
• Understand Reporting in Primavera Cloud
• Execute the project
• Manage risk and View reports

• Create a project
• Create a Work Breakdown Structure
• Create a Cost Breakdown Structure
• Add activities and Customize activity views
• Create relationships
• Schedule the project
• Assign constraints
• View the Enterprise Project Structure
• Optimize the project schedule
• Assign roles and resources
• Analyze resources and costs
• Baseline the project plan
• Execute the project
• Manage risk and View reports
• Manage all Data within P6 Portfolios
• Import and Export data
• Enter and revise data
• Understand Planning and Scheduling in P6 and Unifier
• Understand Resource and Cost Management in P6 and Unifier
• Understand Projects Office
• Understand Reporting and Analytics in P6
• Learn P6 Fundamentals and Advanced
• Learn Primavera Unifier: General
• Learn Primavera Unifier: Reporting

• Understand Planning and Scheduling
• Understand Resource and Cost Management
• Understand Projects Office
• Create a project
• Create a Work Breakdown Structure
• Navigating Primavera Unifier
• Configuring Primavera Unifier
• Managing Projects and Costs
• Creating Project Portfolios
• Creating a Capital Portfolio
• Creating a Capital Plan
• Using Budget Planning
• Using Selection Analysis
• Comparing Scenarios
• Approving Scenarios
• Using the Performance Scorecard
• Managing Spending
• Using Workflows
• Understand Reporting in Primavera Unifier

• Project management terminology
• Relationship between project elements
• Project processes
• Project planning and control techniques
• Project cost control
• Metrics related to measuring project performance
• Understand Planning and Scheduling
• Understand Resource and Cost Management
• Understand Projects Office
• Create a project
• Create a Work Breakdown Structure
• Navigating Primavera Unifier
• Configuring Primavera Unifier
• Managing Projects and Costs
• Creating Project Portfolios
• Creating a Capital Portfolio
• Creating a Capital Plan
• Using Budget Planning
• Using Selection Analysis
• Comparing Scenarios
• Approving Scenarios
• Using the Performance Scorecard
• Managing Spending
• Using Workflows
• Understand Reporting in Primavera Unifier

• Project management terminology
• Relationship between project elements
• Project processes
• Project planning and control techniques
• Project cost control
• Metrics related to measuring project performance
• Manage Project Costs
• Award Procurement Items
• Use Contracts, Purchase Orders, and Trends
• Manage Payment Requisitions
• Customize Layouts
• Create the Company Directory
• Create a Project
• Track Drawings
• Communicate Project Information
• Log and Track Submittals
• Document Project Issues
• Record Project Communications

• Project management terminology
• Relationship between project elements
• Project processes
• Project planning and control techniques
• Project cost control
• Metrics related to measuring project performance
• Understand Planning and Scheduling
• Understand Resource and Cost Management
• Understand Projects Office
• Create a project
• Create a Cost Breakdown Structure
• Navigating Primavera Unifier
• Configuring Primavera Unifier
• Managing Projects and Costs
• Creating Project Portfolios
• Creating a Capital Portfolio
• Creating a Capital Plan
• Using Budget Planning

• Understand Planning and Scheduling
• Understand Resource and Cost Management
• Understand Projects Office
• Create a project
• Create a Work Breakdown Structure
• Navigating Primavera Unifier
• Configuring Primavera Unifier
• Managing Projects and Costs
• Creating Project Portfolios
• Creating a Capital Portfolio
• Creating a Capital Plan
• Using Budget Planning
• Using Selection Analysis
• Comparing Scenarios
• Approving Scenarios
• Using the Performance Scorecard
• Managing Spending
• Using Workflows
• Understand Reporting in Primavera Unifier

• Navigate and set preferences
• Use business processes
• Use forms and tasks in business processes
• Use document management
• Manage documents, properties and permissions
• Mark up documents
• Use WBS Cost Management
• Use a project cost sheet
• Use cash flow functionality
• Navigate in the application

• Describe Primavera Enterprise Products
• Understand Project Management Framework
• Understand Project Management Terminology
• Understand Unifier Concepts and Terminology
• Understand Business Processes
• Navigate in the application
• Use business processes
• Use document management
• Mark up documents
• Use WBS Cost Management
• Use cash flow functionality
• Create Reports

• Understand Shell Templates, Shell Manager Configuration, Workflow Setup
• Create Reports, Business Process creation
• Describe uDesigner Process

• Distinguish process types
• Utilize uDesigner
• Follow good design practices Learn business process types
• Create data structures
• Create shells
• Create business processes
• Attribute forms
• Add functionality to forms, such as consolidation of line items
• Add functionality to forms, such asvalidation, auto-population, and linked elements
• Use production bundles

• Learn about cost sheets
• Learn cost attribute forms
• Define business processes
• Define cost-related templates
• Define rules
• Learn WBS code segments

• Why EVM is important
• Establishing and managing scope, schedule, and budget
• Creating a reasonable baseline
• Integrating project planning and EVM
• Monitoring and controlling the baseline
• Monitoring and controlling scope, schedule, and cost
• Collecting and analyzing data
• Forecasting final variances
• Managing change and the impact to EVM
• Difference between EVM in corporations and in the federal environment

• Understand why projects fail or succeed
• Establish a methodology for evaluating, selecting, prioritizing projects
• Identify potential projects and determine their value
• Select appropriate projects to support organizational strategy
• Prioritize projects
• Use advanced techniques to track multiple-project progress
• Manage the enterprise resource pool
• Analyze the portfolio and learn how to increase its effectiveness

• Use project management skills across their organization
• Build performing organization structure and project team.
• Identify and validate your project requirements.
• Establish a project estimates and project schedule.
• Develop a Work Breakdown Structure (WBS).
• Create a project plan.
• Manage overall change control.
• Control project execution processes.
• Terminate a project with a right close-out strategy.
• Understand the basic terms and concepts of Project Management

• Understand the Project Portfolio Management Cloud solution
• Navigate within the product
• Use key features and functionalities offered by specific modules within Oracle Fusion PPM
• Use key components within Project Portfolio Management Cloud and see how they're integrated
• Explain how Fusion Project Portfolio Management and other Oracle applications coexist
• See how Project Management Project Resource Management, Project Controls, Project Costing, Project Billing, Task Management, and Grants Management work together
• Use the reporting tools like OTBI and Smart view for project related reports

• Understand the components of the Fusion UI and common Fusion components
• Understand Fusion Tax
• Understand Fusion GL
Sub Ledger accounting and the Fusion Accounting hub
• Understand Fusion Receivables and Fusion Advanced Collections
• Understand Fusion Payables
Fusion Payments and expenses
• Understand Fusion Fixed Assets

• Understand Fusion Applications
• Understand the components of the Fusion UI and common Fusion components
• Understand Ledgers and Ledger Sets Concepts
• Understand Flexfields and Value Sets
• Understand Data Security and Profile Options
• Understand Fusion General Ledger
• Manage simultaneous accounting for multiple reporting requirements
• Manage Multi Currency Concepts
• Manage Intercompany Transactions
• Manage Allocations
• Understand Configuring Financial Reports

• Understand Fusion Applications
• Understand the components of the Fusion UI and common Fusion components
• Understand Enterprise Structures
• Use the role based security to Ledgers
• Manage simultaneous accounting for multiple reporting requirements
• Manage Multi Currency Concepts
• Manage Intercompany Transactions
• Manage Allocations
• Understand Configuring Financial Reports

• Understand Functional Setup Manager
• Understand the steps to Implement and Configure Fusion General Ledger
• Use the role based security to Ledgers
• Manage simultaneous accounting for multiple reporting requirements
• Manage Multi Currency Concepts
• Manage Intercompany Transactions
• Configure Journal Approval and General Ledger
• Configure consolidations
• Manage Allocations
• Understand Configuring Financial Reports

• Understand Oracle General Ledger
• Explain Intercompany transactions
• Configure ledgers and period close components
• Configure Journal Approval and General Ledger
• Configure consolidations
• Understand the Financial Reporting options
• Use the Rapid Implementation Spreadsheets to implement Oracle Fusion General Ledger

• Work with offerings
• Work with custom implementation tasks and processes
• Work with setup configurations and data
• Work with implementation projects
• Perform setup tasks
• Create & Manage Custom Implementation Projects
• By the end of the class, you will be able to create and manage custom implementation projects

• Describe the concepts and components of Oracle Fusion Applications
• Describe Oracle Fusion Applications Value Proposition
• Understand the Fusion User Interface
• Understand Process Invoicing
• Understand Payments Process
• Understand Expenses Process
• Understand Reporting Process

• Describe Oracle Fusion Applications Value Proposition
• Describe the concepts and components of Oracle Fusion Applications
• Understand the Fusion User Interface
• Process Invoicing
• Process Payments
• Process Expenses
• Process Reporting

• Describe Oracle Fusion Applications Value Proposition
• Describe the concepts and components of Oracle Fusion Applications
• Understand the Fusion User Interface
• Describe Functional Setup Manager
• Process Invoicing
• Process Payments
• Process Expenses
• Process Reporting

• Describe the concepts and components of Oracle Fusion Applications
• Describe Oracle Fusion Applications Value Proposition
• Understand the Fusion User Interface
• Understand the Receivables Process
• Billing and Revenue Management
• Collections Management
• Reporting
• Receipt Management

• Describe the concepts and components of Oracle Fusion Applications
• Describe Oracle Fusion Applications Value Proposition
• Understand the Fusion User Interface
• Understand the Receivables Process
• Billing and Revenue Management
• Collections Management
• Reporting
• Receipt Management

• Describe Oracle Fusion Applications Value Proposition
• Describe the concepts and components of Oracle Fusion Applications
• Understand the Fusion User Interface
• Describe Functional Setup Manager
• Understand the Receivables Process
• Billing and Revenue Management
• Collections Management
• Reporting
• Receipt Management

• Describe the concepts and components of Oracle Fusion Applications
• Describe Oracle Fusion Applications Value Proposition
• Understand the Fusion User Interface
• Procurement Application Overview
• Enterprise Structures
• Purchasing
• Self Service Procurement
• Supplier Portal
• Sourcing

• Describe Oracle Fusion Applications Value Proposition
• Describe the concepts and components of Oracle Fusion Applications
• Understand the Fusion User Interface
• Describe Functional Setup Manager
• Procurement Application Overview
• Enterprise Structures
• Purchasing
• Self Service Procurement
• Supplier Portal
• Sourcing
• Procurement Contract

• Describe Oracle Fusion Applications Value Proposition
• Describe the concepts and components of Oracle Fusion Applications
• Understand the Fusion User Interface
• Describe Functional Setup Manager
• Procurement Application Overview
• Enterprise Structures
• Purchasing
• Self Service Procurement
• Supplier Portal
• Sourcing
• Order Orchestration

• Understand Oracle Fusion Applications and components
• Configure Oracle Assets
• Explain and execute the asset management process
• Manage asset additions and mass additions
• Effectively manage depreciation
• Manage asset adjustment and retirement
• Process asset accounting for corporate and tax books

• Describe Functional Setup Manager
• Configure Oracle Assets
• Explain and execute the asset management process
• Manage asset additions and mass additions
• Effectively manage depreciation
• Manage asset adjustment and retirement
• Process asset accounting for corporate and tax books

• Describe Oracle Fusion Applications Value Proposition
• Describe the concepts and components of Oracle Fusion Applications
• Understand the Fusion User Interface
• Describe key functionality in Financials
• Procurement Supply Chain
• Human Capital
• Describe key functionality in Project Portfolio and Customer Relationship Management
• Describe Fusion Security
• Describe Functional Setup Manager
• Describe the concepts and details SOA Suite 11g
• Describe the concepts and details BPM Suite 11g
• Describe ADF Framework development standards
• Describe Fusion Applications Security Framework

• Identify Fusion Applications
• Understand the Fusion User Interface
• Describe key functionality in Financials, Procurement Supply Chain, Human Capital, Project Portfolio and Customer Relationship Management
• Describe Fusion Security
• Describe Functional Setup Manager

• Understand the Project Portfolio Management Cloud solution
• Navigate within the product
• Use key features and functionalities offered by specific modules within Oracle Fusion PPM
• Use key components within Project Portfolio Management Cloud and see how they're integrated
• Explain how Fusion Project Portfolio Management and other Oracle applications coexist
• See how Project Management Project Resource Management, Project Controls, Project Costing, Project Billing, Task Management, and Grants Management work together
• Use the reporting tools like OTBI and Smart view for project related reports

• Fusion Project Portfolio Management overview
• Navigation User Experience and Personalization
• Oracle Fusion Applications Security Overview
• Fusion Functional Setup Manager Overview
• Configure Fusion Common Applications
• Common project configuration
• Configure Fusion Project Foundation
• Configure Fusion Project Costing
• Configure Fusion Project Control
• Configure Fusion Project Billing
• Configure Project Performance Reporting
• Configure Project Management
• Configure Project Resource Management
• Fusion Project Reporting

• Understand Functional Setup Manager
• Learn how to configure Common Applications for Project Management
• Learn how to define common Project configuration
• Learn how to define Project foundation configuration
• Learn how to define Project costing configuration
• Learn how to define Project control configuration
• Learn how to define Project billing configuration
• Learn how to define Project performance reporting configuration
• Learn how to define Project integration gateway configuration
• Learn how to define Project templates
• Learn how to define transactional business intelligence configuration
• Learn how to define extensions for Project Management
• Learn how to test the setup

• Understand Oracle Fusion Applications and Components
• Navigate Oracle Fusion Applications and Interfaces
• Understand Distributed Order Orchestration process definitions and rules
• Understand Distributed Order Orchestration external interfaces
• Understand Distributed Order Orchestration processing constraints
• Understand Distributed Order Orchestration lookups profiles and source systems
• Understand Global Order Promising lookups, profiles, and source systems
• Understand Global Order Promising sourcing rules and assignment sets
• Understand Global Order Promising available-to-promise rules
• Understand Distributed Order Orchestration transformation details

• Understand Oracle Fusion Applications and Components
• Understand Oracle Fusion Functional Setup Manager
• Learn how to define and manage Distributed Order Orchestration process definitions and rules
• Learn how to manage Distributed Order Orchestration external interfaces
• Learn how to manage Distributed Order Orchestration processing constraints
• Learn how to manage Distributed Order Orchestration lookups profiles and source systems
• Learn how to manage Global Order Promising lookups, profiles, and source systems
• Learn how to define and manage Global Order Promising sourcing rules and assignment sets
• Learn how to define and manage Global Order Promising available-to-promise rules
• Learn how to define and manage Distributed Order Orchestration transformation details

• Understand Oracle Fusion Functional Setup Manager
• Learn how to define and manage Distributed Order Orchestration process definitions and rules
• Learn how to manage Distributed Order Orchestration external interfaces
• Learn how to manage Distributed Order Orchestration processing constraints
• Learn how to manage Distributed Order Orchestration lookups profiles and source systems
• Learn how to manage Global Order Promising lookups, profiles, and source systems
• Learn how to define and manage Global Order Promising sourcing rules and assignment sets
• Learn how to define and manage Global Order Promising available-to-promise rules
• Understand Oracle Fusion Functional Setup Manager
• Understand common applications configuration, including security
• Learn how to define and manage Distributed Order Orchestration transformation details

• Use Oracle Fusion Functional Setup Manager (FSM) to implement Workforce Deployment
• Set up your enterprise and workforce structures
• Create jobs positions and grades
• Perform functional tasks like hiring persons, managing employment and accessing the gallery portrait
• Set up job and person profiles
• Configure security for Global Human Resources data

• Overview of Fusion Products
• Analytics available in Fusion HCM
• Usability Features of Fusion HCM
• Person and Employment Management
• Talent Management Features

• Install and configure an Oracle Database for applications transactions
• Plan for installing Oracle Fusion Applications
• Prepare a provisioning plan using the provisioning tool
• Install, deploy and configure Oracle Fusion Applications
• Start and use Identity Management environment with Fusion Applications
• Perform life cycle operations for Middleware components in Fusion Applications environment
• Start, stop, configure and administer Oracle Fusion Applications processes

• Understand the impacts of key implementation decisions
• Set up and Implement Oracle Project Foundation R12.1
• Describe how the foundation functionality and projects accounting process fit into the Oracle EBS applications
• Define projects in Oracle Projects to track detailed cost and billing information
• Monitor project performance
• Identify key reports
• Describe how the cost accounting process fit into the Oracle E-Business Suite of applications
• Define projects in Oracle Projects to track detailed cost information and monitor project performance
• Setup and enter expenditures
• Perform cost processing, cost adjustments and cross charges
• Setup allocation rules and process allocations
• Describe budgetary controls and integration
• Identify key reports for Costing
• Describe how Project Billing process fits into the Oracle E-Business Suite of applications
• Define a centralized project environment to perform billing activities
• Understand the use of agreements, funding and contract projects
• Generate revenue and invoices, perform related accounting tasks
• Setup and execute interproject billing
• Identify key reports for Billing

• Set up R12.x Oracle Project Management
• Identify the features of Oracle Project Management
• Describe the relationship between Oracle Project Management and Oracle Project Collaboration
• Describe the relationship between Oracle Project Management and Microsoft Project
• Understand the impacts of key implementation decisions
• Manage Workplans
• Manage Budgets and Forecasts
• Manage Progress
• Define Project Performance Reporting
• Report Project Status Inquiry

• Set up R12.1 Oracle Project Costing
• Identify the features of Oracle Project Costing
• Describe how Oracle Project Costing integrates with the Oracle eBusiness Suite
• Understand the impacts of key implementation decisions

• Set up R12.1 Oracle Project Costing
• Identify the features of Oracle Project Costing
• Describe how Oracle Project Costing integrates with the Oracle eBusiness Suite
• Understand the impacts of key implementation decisions

• Describe how Project Billing process fits into the Oracle E-Business Suite of applications
• Define a centralized project environment to perform billing activities
• Understand the use of agreements, funding and contract projects
• Generate revenue and invoices, perform related accounting tasks
• Setup and execute interproject billing
• Identify key reports for Billing

• Set up R12 Oracle Project Resource Management Fundamentals
• Identify the features of Oracle Project Resource Management
• Explain the role of resources in Oracle Project Resource Management
• Understand the impacts of key implementation decisions

• Identify key features of each product in the Oracle Enterprise Project Management Solution
• Integrate the Oracle Project Suite with other applications in the Oracle eBusiness Suite
• Understand the impacts of key implementation decisions
• Set up and Implement Oracle Project Foundation R12.1

• Set up R12.1 Oracle Project Costing
• Identify the features of Oracle Project Costing
• Describe how Oracle Project Costing integrates with the Oracle eBusiness Suite
• Understand the impacts of key implementation decisions
• Understand the impacts of key implementation decisions
• Identify the features of Oracle Project Billing
• Describe how Oracle Project Billing integrates with the Oracle eBusiness Suite
• Set up R12.x Oracle Project Billing

• Define basic terminology of project management
• Identify the project management life cycle
• Understand the project management knowledge areas
• Build a business case for project initiation
• Define project scope and stakeholder expectations
• Define roles and responsibilities for project stakeholders
• Ensure buy-in from your team and sponsors
• Create project management plans for quality, communication, resources, and stakeholder management
• Use advanced scheduling techniques
• Learn to Manage Teams and multiple projects
• Create resource teams
• Use high-level resource planning
• Staff resource requests and use Progress Reporter
• Use resource levelling

• Introduction and Key BI and OLAP Concepts
• Oracle BI Enterprise Edition Products and Architecture
• Understanding BI Publisher Terminology and Concepts
• Configuring the Data Sources
• Working with Data Models
• Using Layout Editor
• Scheduling a Report
• Using BI Publisher Desktop
• Exploring P6 Sample Reports

• Describe the architecture of WebLogic Server including domains, servers and machines
• Install, configure and use WebLogic Server
• Perform routine Oracle WebLogic Server administration functions
• Set up a cluster of servers and distribute applications and resources to the cluster
• Deploy different types of Java EE applications to Oracle WebLogic Server

• Describe the architecture of WebLogic Server including domains, servers and machines
• Install and configure WebLogic Server and SIP Container
• Define a JDBC data source for load balancing and failover
• Configure JMS to guarantee message delivery
• Configure JMS load balancing and failover in a cluster
• Configure JMS store and forward features
• Replicate HTTP sessions using multiple clusters
• Integrate WebLogic Server with an external LDAP server
• Utilise LDAP for authentication
• Configure and monitor server network channels
• Define server work managers
• Create custom domain and extension templates
• Set up a cluster of servers and distribute applications and resources to the cluster
• Deploy different types of Java EE applications to Oracle WebLogic Server
• Describe the architecture of WebLogic Server SIP Container and Coherence
• Configure a highly available database infrastructure using Oracle RAC
• Monitor servers using Diagnostics Framework or WLDF
• Tune a Java VM for performance

• Describe the architecture of WebLogic Server including domains, servers and machines
• Install and configure WebLogic Server and SIP Container
• Define a JDBC data source for load balancing and failover
• Configure JMS to guarantee message delivery
• Configure JMS load balancing and failover in a cluster
• Configure JMS store and forward features
• Replicate HTTP sessions using multiple clusters
• Integrate WebLogic Server with an external LDAP server
• Utilise LDAP for authentication
• Configure and monitor server network channels
• Define server work managers
• Create custom domain and extension templates
• Set up a cluster of servers and distribute applications and resources to the cluster
• Deploy different types of Java EE applications to Oracle WebLogic Server
• Describe the architecture of WebLogic Server SIP Container and Coherence
• Configure a highly available database infrastructure using Oracle RAC
• Monitor servers using Diagnostics Framework or WLDF
• Tune a Java VM for performance

• Describe the architecture of Oracle Cloud and Fusion Middleware
• Describe the architecture of WebLogic Server including domains, servers and machines
• Install, configure, and administer Oracle WebLogic Server
• Install and configure Oracle HTTP Server (OHS)
• Deploy applications to WebLogic Server
• Backup and restore a WebLogic Server domain
• Create a WebLogic Server domain
• Configure and monitor WebLogic Server
• Set up and use node manager
• Configure WebLogic Server database resources
• Create and configure a WebLogic Server cluster
• Create and configure a WebLogic Dynamic cluster
• Configure WebLogic Server's authentication provider

• Describe the architecture of WebLogic Cloud
• Describe Cloud Application Foundation concepts
• Install and configure WebLogic Server
• Describe the architecture of WebLogic Server Coherence
• Create and use domain templates
• Create and use Server Templates
• Configure Clusters
• Create and use Dynamic Clusters
• Configure advanced JDBC features
• Describe ActiveCache (WLS and Coherence)
• Configure a highly available database infrastructure using Oracle RAC
• Configure Network Channels
• Configure Virtual Hosts
• Utilise LDAP for authentication
• Configure SSL for WebLogic Server
• Configure and use WebLogic Diagnostic Framework (WLDF)

• Describe the architecture of WebLogic Cloud
• Describe Cloud Application Foundation concepts
• Install and configure WebLogic Server
• Describe the architecture of WebLogic Server Coherence
• Create and use domain templates
• Create and use Server Templates
• Configure Clusters
• Create and use Dynamic Clusters
• Configure advanced JDBC features
• Describe ActiveCache (WLS and Coherence)
• Configure a highly available database infrastructure using Oracle RAC
• Configure Network Channels
• Configure Virtual Hosts
• Utilise LDAP for authentication
• Configure SSL for WebLogic Server
• Configure and use WebLogic Diagnostic Framework (WLDF)

• Describe the architecture of WebLogic Cloud
• Describe Cloud Application Foundation concepts
• Describe the architecture of WebLogic Server including domains, servers and machines
• Install, configure, and administer Oracle WebLogic Server
• Install and configure Oracle HTTP Server (OHS)
• Describe the architecture of WebLogic Server Coherence
• Create and use domain templates
• Create and use Server Templates
• Configure JDBC features
• Deploy applications to WebLogic Server
• Backup and restore a WebLogic Server domain
• Create a WebLogic Server domain
• Configure and monitor WebLogic Server
• Set up and use node manager
• Configure WebLogic Server database resources
• Create and configure a WebLogic Server cluster
• Create and configure a WebLogic Dynamic cluster
• Configure WebLogic Server's authentication provider
• Describe ActiveCache (WLS and Coherence)
• Configure a highly available database infrastructure using Oracle RAC
• Configure Network Channels
• Configure Virtual Hosts
• Utilise LDAP for authentication
• Configure SSL for WebLogic Server
• Configure and use WebLogic Diagnostic Framework (WLDF)

• Describe Oracle Fusion Middleware (FMW)
• Identify and describe FMW Java components
• Identify and describe FMW system component
• Identify the system administration tools for managing FMW
• Manage log files by using FMW Control
• Access FMW Control
• Start and stop instances of WebLogic Server by using FMW Control
• Deploy applications by using FMW Control
• Monitor a WebLogic Server (WLS) domain with FMW Control
• Monitor applications with FMW Control
• View domain topology through FMW Control
• View diagnostic data with FMW Control
• Centrally manage Java components using the Oracle WebLogic Server Administration Console
• Stop and start FMW Java components
• Use Fusion Middleware Control to diagnose and resolve issues
• Understand Back Up and Recovery of Fusion Middleware Components

• Describe Oracle Fusion Middleware (FMW)
• Install and configure Oracle Fusion Middleware
• Install and configure Oracle SOA Suite 11g
• Install and configure OBIEE 11g
• Install and configure Oracle Data Integrator 11g
• Install and configure JDeveloper 11g
• Install and configure Coherence in a Weblogic Server Environment
• Identify and describe Oracle WebLogic Server 11g
• Identify and describe Oracle SOA Suite 11g
• Identify and describe Oracle BPM Suite 11g
• Identify and describe Oracle Fusion and ADF Architecture
• Identify and describe Oracle JDeveloper 11g
• Identify and describe Oracle Enterprise Performance Management
• Identify and describe Oracle OBIEE 11g
• Identify and describe Oracle Data Integrator 11g
• Describe the Oracle Data Integrator (ODI) system logical architecture
• Identify and describe Oracle DI Java components
• Identify and describe Oracle BI Java components and Oracle BI system component
• Identify the system administration tools for managing Oracle DI and Oracle BIEE
• Describe scenarios in which FMW Control is available
• Access FMW Control and View domain topology through FMW Control
• Start and stop instances of WebLogic Server by using FMW Control
• Deploy applications by using FMW Control
• Centrally manage Oracle DI and Oracle BI components using Fusion Middleware Control
• Centrally manage Oracle DI and Oracle BI Java components using WebLogic Admin Console
• Stop and start Oracle DI and Oracle BI components
• Identify and describe Oracle Fusion High Availability Tools and Products
• Install and configure Oracle Coherence in a Weblogic Server Environment

• Relate WebSphere Application Server to the WebSphere family of products
• Features and standards in WebSphere Application Server 8.5.x
• Architectural concepts related to WebSphere Application Server
• Architectural concepts related to WebSphere Liberty Profile
• Install and configure WebSphere Application Server 8.5.5.x
• Basic concepts of the Java Platform, Enterprise Edition (Java EE 6/7 and Java SE 7)
• Assemble and install server-side Java enterprise applications
• Use WebSphere administrative tools to configure and manage enterprise applications
• Use the wsadmin scripting library
• Configure WebSphere Application Server security
• Deploy applications in clustered environments
• View performance information about server and application components
• Use problem determination tools and log files to troubleshoot problems
• Configure messaging with the service integration bus
• Describe Intelligent Management features
• Describe WebSphere Batch features
• Describe the Liberty profile

• Relate WebSphere Application Server to the WebSphere family of products
• Features and standards in WebSphere Application Server 9.x
• Architectural concepts related to WebSphere Application Server Traditional
• Architectural concepts related to WebSphere Liberty Profile
• Install and configure WebSphere Application Server 9.x Traditional and Liberty Profile
• Basic concepts of the Java Platform, Enterprise Edition (JJava EE 7, Java EE 7 Web Profile and Java SE 8)
• Assemble and install server-side Java enterprise applications
• Use WebSphere administrative tools to configure and manage enterprise applications
• Use the wsadmin scripting library
• Configure WebSphere Application Server security
• Deploy applications in clustered environments
• View performance information about server and application components
• Use problem determination tools and log files to troubleshoot problems
• Configure messaging with the service integration bus
• Describe Intelligent Management features
• Describe WebSphere Batch features
• Describe the Liberty profile
• Install and configure the Liberty profile

• Create a Strategy map within Scorecard
• Create a Strategy tree within Scorecard
• Create a Cause & Effect map within Scorecard
• Create Mission and Vision statements within Scorecard
• Create KPIs
• Create Agents
• Create a stand-alone KPI watchlist
• Create Scorecards and associated objects
• Add Scorecards to a Dashboard
• Create a KPI and KPI watchlist within Scorecard
• Create Objectives within Scorecard
• Create Initiatives within Scorecard
• Create a Perspective within Scorecard
• Create comments for collaboration within Scorecard

• Understand Business Intelligence and OLAP Concepts
• Understand Hyperion FM and Essbase Concepts
• Understand the Analysis, Design of Hyperion FM Applications
• Analyze and enter data in Smart View
• Create reports in Financial Reporting
• Navigate Financial Management
• Translate data
• Enter and calculate data
• Create journal entries
• Enter intercompany data
• Consolidate data

• Understand Business Intelligence and OLAP Concepts
• Understand Hyperion Planning and Essbase Concepts
• Understand the Analysis, Design of Hyperion Planning Applications
• Navigate Workspace in Planning
• Create data forms and folders
• Customize data forms
• Enter data in Planning
• Enter data in Smart View
• Create business rules
• Manage business rules
• Add variables and formulas to business rules
• Manage the approval process
• Create task lists

• Create Planning applications
• Navigate Workspace in Planning
• Create data forms and folders
• Customize data forms
• Enter data in Planning
• Enter data in Smart View
• Create business rules
• Manage business rules
• Add variables and formulas to business rules
• Manage the approval process
• Create task lists
• Identify the Planning installation requirements
• Describe the architecture of WebLogic Server
• Understand WebLogic Server domains, servers and machines
• Install and configure WebLogic Server
• Install and configure Foundation Services and Essbase
• Design and manage Essbase security
• Install and configure Planning
• Verify the Planning installation
• Perform backup, recovery, application migration, and task automation