Oracle Project Portfolio Management Cloud 2017 Implementation
Essentials (1Z0-964) is a certification exam provided by Oracle that
assesses a candidate’s knowledge and skills in implementing and managing
Oracle's Project Portfolio Management (PPM) Cloud solutions. The certification attests your skills in the various aspects of project management cloud like project planning, execution, resource management, financial management,
and portfolio analysis. The exam certifies your skills in complying with the best practices in Oracle's project and portfolio
management cloud-based tool. Why is Oracle Project Portfolio Management Cloud 2017 Implementation Essentials (1Z0-964) important?
Attests to your skills in Oracle's Project Portfolio Management Cloud implementations.
Boosts career opportunities in project management and portfolio analysis.
Showcases your ability to manage project costs, resources, and schedules effectively.
Validates your Oracle's PPM cloud implementation's compliance with industry standards for project management practices.
Increases your knowledge of integrating financial management with project execution.
Globally recognized certificate.
Improves your credibility for senior roles in project management roles within Oracle environments.
Who should take the Oracle Project Portfolio Management Cloud 2017 Implementation Essentials (1Z0-964) Exam?
Oracle PPM Cloud Consultants
Project Managers
Portfolio Managers
Resource Managers
Financial Analysts specializing in project finance
Implementation Consultants for Oracle PPM
Cloud Solutions Architects focusing on project management
IT Project Managers
Skills Evaluated
Candidates taking the certification exam on the Oracle Project Portfolio Management Cloud 2017 Implementation Essentials (1Z0-964) is evaluated for the following skills:
Implementing and configuring Oracle Project Portfolio Management Cloud.
Managing project planning, execution, and resource allocation.
Understanding financial management processes related to projects.
Analyzing project performance and portfolio health.
Configuring dashboards and reporting for project management insights.
Integrating PPM with other Oracle Cloud applications.
Utilizing best practices in project and portfolio management.
Oracle Project Portfolio Management Cloud 2017 Implementation Essentials (1Z0-964) Certification Course Outline The Oracle Project Portfolio Management Cloud 2017 Implementation Essentials (1Z0-964) Certification covers the following topics -
Module 1. Declaring PL/SQL Variables
Recognize valid and invalid identifiers
Listing the uses of variables, declare and initialize variables, use bind variables
Listing and describing various data types using the %TYPE and %ROWTYPE attributes
Module 2. Writing Executable Statements
Identifying lexical units in a PL/SQL block
Using built-in SQL functions in PL/SQL and sequences in PL/SQL expressions
Describing when implicit conversions take place and when explicit conversions have to be dealt with
Writing nested blocks and qualify variables with labels
Writing readable code with appropriate indentation
Module 3. Writing SQL in PL/SQL
Creating PL/SQL executable blocks using DML and transaction control statements
Making use of the INTO clause to hold the values returned by a SQL statement
Module 4. Writing Control Structures
Identifying the uses and types of control structures (IF, CASE statements and expressions)
Constructing and identifying loop statements
Using EXIT and CONTINUE statements inside loops
Module 5. Working with Composite Data Types
Creating user-defined PL/SQL records
Creating a record with the %ROWTYPE attribute
Creating an INDEX BY table and INDEX BY table of records
Describing the differences among records, collections, and collections of records
Initializing collections and records
Module 6. Using Explicit Cursors
Distinguishing between implicit and explicit cursors and use SQL cursor attributes
Declaring and controlling explicit cursors, use simple loops and cursor FOR loops to fetch data
Declaring and using cursors with parameters
Locking rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause
Module 7. Handling Exceptions
Defining PL/SQL exceptions
Recognizing unhandled exceptions
Handling different types of exceptions (internally defined exceptions, predefined exceptions and user-defined exceptions)
Propagating exceptions
Module 8. Using PL/SQL Subprograms
Differentiating between anonymous blocks and subprograms
Creating a simple procedure and invoke it from an anonymous block
Identifying benefits of subprograms
Module 9. Creating Procedures and Using Parameters
Creating a procedure with parameterrs
Using named notation
Working with procedures (create, invoke and remove procedures)
Handling exceptions in procedures and display a procedure's information
Module 10. Creating Functions
Differentiating between a procedure and a function
Describing the uses of functions
Working with functions (create, invoke and remove functions)
Module 11. Creating Packages
Identifying the benefits and the components of packages
Working with packages (create package specification and body, invoke package subprograms, remove a package and display package information)
Overloading package subprograms and use forward declarations
Module 12. Working with Packages
Using package types and variables
Using packaged constants and functions in SQL
Using ACCESSIBLE BY to restrict access to package subprograms
Module 13. Using Dynamic SQL
Describing the execution flow of SQL statements
Using Native Dynamic SQL (NDS)
Binding PL/SQL types in SQL statements
Module 14. Design Considerations for PL/SQL Code
Creating standard constants and exceptions
Writing and calling local subprograms
Controlling the run-time privileges of a subprogram
Performing autonomous transactions
Using NOCOPY hint, PARALLEL ENABLE hint and DETERMINISTIC clause
Using bulk binding and the RETURNING clause with DML
Module 15. Creating Compound, DDL, and Event Database Triggers
Creating triggers on DDL statements
Creating triggers on system events
Describing different types of triggers and their uses
Module 16. Using the PL/SQL Compiler
Describing the PL/SQL compiler and features
Using the PL/SQL compiler initialization parameters
Using the PL/SQL compile time warnings
Module 17. Managing PL/SQL Code
Describing and using conditional compilation
Code-based access controlling: granting roles to program units
Whitelisting code access with the ACCESSIBLE BY clause