<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Administrators<br />Developers<br />Implementers<br />Systems Administrators</p>Overview<p>Understand the PeopleSoft system architecture, application development methodology, and tool set so you can build and customize PeopleSoft applications efficiently to meet your organizations business requirements. Quickly and efficiently create functionality in PeopleSoft applications to take advantage of the unique capabilities of these applications.<br />Gain Hands-On Experience Using PeopleSoft Application Designer<br />Enrolling in this course will also give you hands-on experience with the Application Designer, the PeopleSoft integrated development environment (IDE). Learn to create and modify PeopleSoft definitions, including fields, records, pages and components. By the end of this course, you'll be able to use Application Designer to create and deploy PeopleSoft classic applications and fluid applications</p><p>This PeopleTools I training introduces the PeopleSoft application development methodology. This 5-day course gives you a general overview of PeopleSoft system architecture, as well as the tool set used to develop new applications or customize existing PeopleSoft applications.</p></div><div id="course-pills-2"><h4>Navigating PeopleSoft Applications</h4><h4>Explaining the PeopleSoft Architecture</h4><h4>Validating Data</h4><h4>Using Application Designer to Develop Applications</h4><h4>Designing the Application</h4><h4>Creating Record Definitions</h4><h4>Building SQL Tables</h4><h4>Creating Page Definitions</h4><h4>Registering Components</h4><h4>Testing Applications</h4><h4>Editing the Portal Registry Structure</h4><h4>Creating Menu Definitions</h4><h4>Understanding the Fluid User Interface</h4><h4>Creating Fluid Pages</h4><h4>Using Delivered CSS</h4></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle Peoplesoft PeopleTools I training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Oracle Peoplesoft PeopleTools I course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

Learning & Development

Oracle Primavera

Online Course Creation

Oracle Fusion HCM

Professional Skills Course (PSC)

Trainers Course

Oracle Peoplesoft PeopleTools I

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>Analyst<br />End User<br />Implementer<br />Manager</p>Overview<p>Create a Work Breakdown Structure<br />Define roles and resources<br />Assign roles<br />Assign resources<br />Analyze resources<br />Optimize the project plan<br />Understand data structures<br />Create a project<br />Add activities<br />View calendars<br />Create relationships<br />Schedule the project<br />Assign constraints<br />Create reports<br />Format schedule data<br />Execute the project</p><p>Enrolling in this course will help you understand P6 Professional's basic features and functionality so you can apply them to your organization's project management processes. You'll also learn how to manage projects on time and within budget</p></div><div id="course-pills-2"><h4>Understanding P6 Data</h4><ul><li>Describing Enterprise and Project-Specific data</li><li>Logging In</li><li>Opening an Existing Project</li><li>Opening and Customizing Layouts</li></ul><h4>Enterprise Project Structure</h4><ul><li>Describing Components of EPS</li></ul><h4>Creating a Project</h4><ul><li>Create a project</li><li>Navigating in the Projects Window</li><li>Viewing Project Details</li></ul><h4>Creating a Work Breakdown Structure</h4><ul><li>Defining a Work Breakdown Structure</li><li>Creating the WBS Hierarchy</li></ul><h4>Adding Activities</h4><ul><li>Describing an Activity and its Components</li><li>Describing Activity Types</li><li>Adding Activities</li><li>Adding a Notebook Topic</li><li>Adding Steps to an Activity</li><li>Assigning Activity Codes</li></ul><h4>Creating Relationships</h4><ul><li>Viewing a Network Logic Diagram</li><li>Relationship Types</li><li>Creating Relationships</li></ul><h4>Scheduling</h4><ul><li>Performing a Forward and Backward Pass</li><li>Describing Float</li></ul><h4>Assigning Constraints</h4><ul><li>Applying an Overall Deadline to a Project</li><li>Apply a Constraint to an Activity</li></ul><h4>Using Reflection Projects</h4><ul><li>Creating a Reflection Project</li><li>Merging Changes</li></ul><h4>Formatting Schedule Data</h4><ul><li>Grouping Activities</li><li>Sorting</li><li>Filtering</li></ul><h4>Roles and Resources</h4><ul><li>Describing Roles and Resources</li><li>Viewing Dictionaries</li></ul><h4>Assigning Roles</h4><ul><li>Assigning Roles to an Activity</li><li>Assign Rates on Roles</li></ul><h4>Assigning Resources</h4><ul><li>Assigning Resources</li><li>Adjusting Budgeted Units/Time</li></ul><h4>Analyzing Resources</h4><ul><li>Displaying the Resource Usage Profile</li></ul><h4>Optimizing the Project Plan</h4><ul><li>Analyzing Schedule Dates</li><li>Shortening a Project Schedule</li><li>Analyzing Resource Availability</li></ul><h4>Baselining the Project Plan</h4><ul><li>Creating a Baseline Plan</li><li>Display Baseline Bars on the Gantt Chart</li></ul><h4>Project Execution and Control</h4><ul><li>Describing Methods for Updating the Schedule</li><li>Using Progress Spotlight</li><li>Statusing Activities</li><li>Rescheduling the Project</li></ul><h4>Reporting Performance</h4><ul><li>Describing Reporting Methods</li><li>Running a Schedule Report</li><li>Creating a report with the Report Wizard</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Primavera P6 Professional Fundamentals Rel 19 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Primavera P6 Professional Fundamentals Rel 19 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Primavera P6

Project Management Professional (PMP)

PRINCE2

Professional Scrum Master (PSM)

Primavera P6 Professional Fundamentals Rel 19

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>System Administrator<br />Administrator<br />Java EE Developer<br />Web Administrator<br />Technical Consultant<br />Security Administrators<br />Technical Administrator</p>Overview<p>Configure WebLogic features including domain templates, system start up, crash recovery, work managers, multi data sources, security policies, and automatic JTA migration<br />Configure Coherence features<br />Perform a rolling upgrade of WebLogic Server<br />Write and run WLST scripts<br />Deploy shared libraries and applications using deployment plans and versioning<br />Configure SSL for WebLogic Server</p><p>This Oracle WebLogic Server 12c: Administration II is a continuation of the Oracle WebLogic Server 12c: Administration I course.</p></div><div id="course-pills-2">This Oracle WebLogic Server 12c: Administration II is a continuation of the Oracle WebLogic Server 12c: Administration I course.</div>

Oracle

Oracle 1Z0-819

Database Administration

Oracle Database

Oracle WebLogic Server 12c - Administration II

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>Application Developers<br />Business Analysts<br />Developer<br />End Users<br />Functional Implementer<br />Java Developer<br />System Analysts<br />Technical Administrator</p>Overview<p>Create administrator-level personalizations<br />Personalize configurable pages<br />Utilize advanced personalization features<br />Implement flexfields on OA Framework-based pages<br />Create custom look and feel definitions<br />Create user-level personalizations</p><p>This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1.</p></div><div id="course-pills-2">This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1.</div>

Oracle Business Intelligence

R12.x Extend Oracle Applications - OA Framework Personalizations

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Data Warehouse Administrator<br />Database Administrators<br />Support Engineer<br />Technical Administrator<br />Technical Consultant</p>Overview<p>Use Oracle Flashback Technologies to recover from human error<br />Use Recovery Manager (RMAN) to create backups and perform recovery operations<br />Use the Data Recovery Advisor to diagnose and repair failures<br />Plan effective backup and recovery procedures<br />Describe the Oracle Database architecture components related to backup and recovery operations<br />Perform an encrypted database backup and restore<br />Perform tablespace point-in-time recovery<br />Configure the database for recoverability<br />Describe Cloud Tooling for Backup and Recovery<br />Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure</p><p>In this Oracle Database 12c R2: Backup and Recovery Workshop, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several failure situations.</p></div><div id="course-pills-2"><h4>Introduction</h4><ul><li>Curriculum Context</li><li>Assess your recovery requirements</li><li>Categories of failures</li><li>Oracle backup and recovery solutions</li><li>Oracle Maximum Availability Architecture</li><li>Oracle Secure Backup</li><li>Benefits of using Oracle Data Guard</li><li>Basic Workshop Architecture</li></ul><h4>Getting Started</h4><ul><li>Core Concepts of the Oracle Database, critical for Backup and Recovery</li><li>Oracle DBA Tools for Backup and Recovery</li><li>Connecting to Oracle Recovery Manager (RMAN)</li></ul><h4>Configuring for Recoverablility</h4><ul><li>RMAN commands</li><li>Configuring and managing persistent settings</li><li>Using the Fast Recovery Area (FRA)</li><li>Control File</li><li>Redo Log File</li><li>Archiving Logs</li></ul><h4>Using the RMAN Recovery Catalog</h4><ul><li>Creating and Configuring the Recovery Catalog</li><li>Managing Target Database Records in the Recovery Catalog</li><li>Using RMAN Stored Scripts</li><li>Maintaining and Protecting the Recovery Catalog</li><li>Virtual Private Catalogs</li></ul><h4>Backup Strategies and Terminology</h4><ul><li>Backup Solutions Overview and Terminology</li><li>Balancing Backup and Restore Requirements</li><li>Backing Up Read-Only Tablespaces</li><li>Data Warehouse Backup and Recovery: Best Practices</li><li>Additional Backup Terminology</li></ul><h4>Performing Backups</h4><ul><li>RMAN Backup Types</li><li>Incrementally Updated Backups</li><li>Fast Incremental Backup</li><li>Block Change Tracking</li><li>Oracle-Suggested Backup</li><li>Reporting on Backups</li><li>Managing Backups</li></ul><h4>Improving Your Backups</h4><ul><li>Compressing Backups</li><li>Using a Media Manager</li><li>Backup and Restore for Very Large Files</li><li>Creating RMAN Multi-section Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets</li><li>Creating and Managing Archival Backups</li><li>Backing Up Recovery Files</li><li>Backing Up the Control File to a Trace File</li><li>Cataloging Additional Backup Files</li></ul><h4>Using RMAN-Encrypted Backups</h4><ul><li>Creating RMAN-Encrypted Backups</li><li>Using Transparent-Mode Encryption</li><li>Using Password-Mode Encryption</li><li>Using Dual-Mode Encryption</li></ul><h4>Diagnosing Failures</h4><ul><li>Reducing Problem Diagnosis Time</li><li>Automatic Diagnostic Repository</li><li>Data Recovery Advisor</li><li>Handling Block Corruption</li></ul><h4>Restore and Recovery Concepts</h4><ul><li>Restoring and Recovering</li><li>Instance Failure and Instance/Crash Recovery</li><li>Media Failure</li><li>Complete Recovery (Overview)</li><li>Point-in-Time Recovery (Overview)</li><li>Recovery with the RESETLOGS Option</li></ul><h4>Performing Recovery, Part I</h4><ul><li>RMAN Recovery in NOARCHIVELOG Mode</li><li>Performing Complete Recovery (of critical and noncritical data files)</li><li>Restoring ASM Disk Groups</li><li>Recovery with Image Files</li><li>Performing Point-in-Time (PITR) or Incomplete Recovery</li></ul><h4>Performing Recovery, Part II</h4><ul><li>Recovery of Server Parameter File, Control File (One and All)</li><li>Redo Log File Loss and Recovery</li><li>Password Authentication File Re-creation</li><li>Index, Read-Only Tablespace, and Temp file Recovery</li><li>Restoring the Database to a New Host</li><li>Disaster Recovery</li><li>Restoring RMAN Encrypted Backups</li></ul><h4>RMAN and Oracle Secure Backup</h4><ul><li>Oracle Secure Backup Overview and Interface Options</li><li>RMAN and OSB: Overview and Basic Process Flow</li><li>Starting with Oracle Secure Backup</li><li>Configuring Oracle Secure Backup for RMAN</li><li>RMAN Backup and Restore Operations</li><li>Oracle Secure Backup Jobs</li><li>Displaying OSB log files and transcripts for RMAN activities</li></ul><h4>Using Flashback Technologies</h4><ul><li>Flashback Technology: Overview and Setup</li><li>Using Flashback Technology to Query Data</li><li>Flashback Table</li><li>Flashback Transaction (Query and Back out)</li><li>Flashback Drop and the Recycle Bin</li><li>Flashback Data Archive</li></ul><h4>Using Flashback Database</h4><ul><li>Flashback Database Architecture</li><li>Configuring Flashback Database</li><li>Performing Flashback Database</li><li>Best Practices for Flashback Database</li></ul><h4>Transporting Data</h4><ul><li>Transporting Data Across Platforms</li><li>Transporting Data with Backup Sets</li><li>Database Transport: Using Data Files</li></ul><h4>Performing Point-in-Time Recovery</h4><ul><li>When to use TSPITR</li><li>TSPITR Architecture</li><li>Performing RMAN TS Point-in-time Recovery</li><li>Recovering Tables from Backups</li></ul><h4>Duplicating a Database</h4><ul><li>Using a Duplicate Database</li><li>Duplicating Database with 'push' and 'pull' techniques</li><li>Choosing Database Duplication Techniques</li><li>Creating a Backup-up Based Duplicate Database</li><li>Understanding the RMAN Duplication Operation</li></ul><h4>RMAN Troubleshooting and Tuning</h4><ul><li>Interpreting RMAN Message Output</li><li>Tuning Principles</li><li>Diagnosing Performance Bottlenecks</li><li>RMAN Multiplexing</li><li>Restore and Recovery Performance Best Practices</li></ul><h4>Cloud Tooling for Backup and Recovery</h4><ul><li>Backup Destinations</li><li>Customize Backup Configuration</li><li>On-Demand Backup and Recovery</li><li>Oracle Backup Cloud Service</li><li>Installing the Backup Module</li></ul><h4>Backup and Recovery Workshop</h4><ul><li>Workshop Structure and Approach</li><li>Business Requirements for Database Availability and Procedures</li><li>Diagnosing the Failures</li></ul></div>

Oracle SQL

Oracle Database 12c R2 - Backup and Recovery Workshop Ed 3

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Administrator<br />Architect<br />Database Administrator</p>Overview<p>To provide an acceptable response time to users and manage resources effectively, you learn how to monitor performance and manage resources within the multitenant container database and its pluggable databases, and within each pluggable database.<br />Another important aspect is the data movement between non-CDBs and pluggable databases, and between pluggable databases.<br />It is also important to understand the procedures of upgrading an Oracle Database multitenant container database or an Oracle Database pluggable database.<br />  Finally, students discover the way multitenant container database and pluggable databases are created and monitored in the Cloud.</p><p>This course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database and its regular and application pluggable databases. You learn why and how to create and manage a multitenant container database and its regular and application pluggable databases, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged pluggable databases in multitenant container databases using various methods.</p></div><div id="course-pills-2"><h4>CDB Basics</h4><h4>CDB and Regular PDBs</h4><h4>Application PDBs and Application Installation</h4><h4>PDB Creation</h4><h4>CDB and PDB Management</h4><h4>Storage</h4><h4>Security</h4><h4>Backup and Duplicate</h4><h4>Recovery and Flashback</h4><h4>Performance Monitoring</h4><h4>Resources Allocation</h4><h4>Data Movement</h4><h4>Upgrade methods</h4></div>

AWS Certified Database

Oracle Database: Managing Multitenant Architecture

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This intermediate-level course requires students have incoming experience working with Oracle Database 18 or higher.</p>Overview<p>Working in a hands-on learning environment led by our expert facilitator, you'll explore:<br />The Oracle Database Architecture<br />Query Optimizer<br />Tuning Container Databases and Pluggable Databases<br />Oracle 19c Tuning features<br />Evaluating Execution Plans<br />Oracle Tuning Tools<br />Using Automatic Workload Repository<br />Join Types<br />AWR Using Baselines<br />Additional AWR performance tools<br />Optimizer Statistics<br />Monitoring a Service<br />Bind Variables and database parameters<br />Oracle's Real Application Testing (RAT)<br />SQL Tuning Advisor<br />Automatic Sql Tuning<br />Sql Plan Management<br />Shared Pool Tuning<br />Tuning the database buffer cache<br />Tuning the PGA (Program Global Area)<br />Automatic Memory Management (AMM)<br />Tuning Segment Space Utilization (ASSM)<br />Automatic Storage Management</p><p>Oracle 19C Database Tuning is an intermediate level course for Oracle database experienced attendees that explores core tuning skills such as Database parameters, SQL Tuning Advisor, SQL Access Advisor, Adaptive SQL plans and more.</p></div><div id="course-pills-2"><h4>Overview Oracle Database Architecture</h4><ul><li>Instance Definition</li><li>Define SGA</li><li>Define Background Processes</li><li>Datafile Definition</li></ul><h4>Query Optimizer</h4><ul><li>SQL Parsing</li><li>Optimizing Terms</li><li>Optimizing Methods</li><li>Query Plan Generation</li><li>Query Plan Control</li></ul><h4>Tuning Container Databases and Pluggable Databases</h4><ul><li>Pluggable tuning parameters</li><li>Define Container tuning structure</li><li>Using PDB$SEED</li><li>Create a new PDB</li><li>Plug and unplug a PDB</li></ul><h4>Oracle 12c Tuning features</h4><ul><li>Identifying and Using Oracle's Heat Map</li><li>12c Compression Levels and Types</li></ul><h4>Evaluating Execution Plans</h4><ul><li>Defining SQL execution plans</li><li>Automatic Workload Repository</li><li>Reading execution plans</li></ul><h4>Oracle Tuning Tools</h4><ul><li>Monitoring tools overview</li><li>Enterprise Manager</li><li>Dynamic Performance Views</li><li>Automatic Workload Repository</li><li>Automatic Database Diagnostic Monitor</li><li>Sql Tuning Advisor</li><li>SQL Access Advisor</li><li>Sql Access Advisor</li><li>DB operation Tuning</li><li>DB operation Active Reporting</li></ul><h4>Using Automatic Workload Repository</h4><ul><li>Defining AWR</li><li>AWR Settings</li><li>Creating AWR Baselines</li></ul><h4>Metrics, Alerts, and Thresholds</h4><ul><li>Defining Metrics</li><li>Setting Alerts</li><li>Setting Corrective Actions</li><li>User Defined Metrics</li><li>Metric Dynamic Views</li></ul><h4>Join Types</h4><ul><li>Nested Loops Join</li><li>Sort Merge join</li><li>Hash Join and Cartesian Join</li><li>Equijoins and Nonequijoins</li><li>Outer Joins</li><li>Semijoins</li></ul><h4>AWR Using Baselines</h4><ul><li>Creating AWR baselines</li><li>Creating AWR Repeating baselines</li><li>Moving Window Baseline</li></ul><h4>Additional AWR performance tools</h4><ul><li>Automatic Maintenance Tasks</li><li>Segment Advisor</li><li>Statistics Gathering</li><li>Automatic Tuning Optimizer</li><li>Automatic Database Diagnostic Monitor</li><li>Active Session History (ASH)</li></ul><h4>Optimizer Statistics</h4><ul><li>Optimizer Statistics Overview</li><li>Table and Index Statistics</li><li>Statistic Preferences</li><li>Statistics Gathering</li><li>e) Locking Statistics, Export/Import Statistics</li><li>Pending and published statistics</li><li>Optimizer Hints</li><li>Optimizer Paths</li><li>Cost Base Optimization</li></ul><h4>Monitoring a Service</h4><ul><li>Overview of what is an Oracle Service</li><li>Creating an Oracle Service for Single instance and RAC</li><li>Monitoring a Service</li><li>Resource Management and a Service</li><li>Enterprise Manager and a Service</li></ul><h4>Bind Variables and database parameters</h4><ul><li>Bind variable definition</li><li>Cursor_sharing parameter</li><li>Adaptive Cursor Sharing</li></ul><h4>Oracle's Real Application Testing (RAT)</h4><ul><li>Sql Performance Analyzer overview</li><li>Sql Performance Analyzer Options</li><li>Database Parameter changes</li><li>Database version changes</li><li>Creating SQL Tuning Sets</li><li>Database Replay Overview</li><li>Database Replay Configuration</li><li>Database Replay Options</li></ul><h4>SQL Tuning Advisor</h4><ul><li>SQL Tuning Advisor: Overview</li><li>SQL Tuning Advisor Limited Mode</li><li>Sql Tuning Advisor Comprehensive mode</li><li>Sql Tuning Profiles</li></ul><h4>SQL Access Advisor</h4><ul><li>SQL Access Advisor: Overview</li><li>Sql Access Advisor options</li><li>SQL Access Advisor and Sql Tuning Sets</li><li>Sql Access Advisor and AWR</li><li>Results and Implementation</li></ul><h4>Automatic Sql Tuning</h4><ul><li>Automatic Sql Tuning Maintenance Task</li><li>Automatic Tuning Optimization implementation(ATO)</li><li>Automatic Tuning Optimization Results</li><li>Enable/Disable Automatic Tuning Optimization</li></ul><h4>Sql Plan Management</h4><ul><li>Sql plan Management and baseline overview</li><li>Enable sql plan management</li><li>Loading Sql Plan baselines into the SGA</li><li>Adaptive plan management</li></ul><h4>Shared Pool Tuning</h4><ul><li>Shared pool architecture</li><li>Shared pool parameters</li><li>Library Cache</li><li>Dictionary cache</li><li>Large pool considerations and contents</li></ul><h4>Tuning the database buffer cache</h4><ul><li>Database buffer cache overview</li><li>Database buffer cache parameters</li><li>Oracle and Dirty reads and writes</li><li>Automatic Shared Memory Management (ASMM)</li><li>Buffer Cache goals and responsibility</li><li>Buffer Cache pools</li></ul><h4>Tuning the PGA (Program Global Area)</h4><ul><li>PGA Overview</li><li>PGA Database Parameters</li><li>Temporary Segments</li><li>Temporary Tablespace</li><li>Sizing the PGA</li></ul><h4>Automatic Memory Management (AMM)</h4><ul><li>Oracle's Automatic Memory Management Overview</li><li>Database Auto-tuned Parameters</li><li>Database Non Auto-tuned Parameters</li><li>Automatic Memory Management Hints and Sizing suggestions</li><li>AMM versus ASMM</li></ul><h4>Tuning Segment Space Utilization (ASSM)</h4><ul><li>Overview of Automatic Segment Space Management</li><li>Defining the DB_BLOCK_SIZE</li><li>Defining DB_nk_CACHE_SIZE parameter</li><li>The DB_BLOCK_SIZE Parameter</li><li>Overview of table compression, block chaining, and block migration</li></ul><h4>Automatic Storage Management</h4><ul><li>Overview of ASM</li><li>Definition of Grid Infrastructure</li><li>ASM Instance</li><li>ASM Diskgroups</li><li>ASM Diskgroup parameters and templates</li><li>ASMCMD</li></ul></div>

Oracle 19c Database Tuning (TTOR21519)

<div id="course-pills-1">Duration<p>4.375 Days</p><p>26.25 CPD hours</p>This course is intended for<p>The target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are: Application designers and database developers Database administrators Web server administrators</p>Overview<p>This eTextbook begins with an explanation of the intent and usage of the PL/SQL programming language for database applications. Important reasons why one should incorporate PL/SQL modules within the application architecture right from the initial design and planning phase are presented. Next one learns how to begin building executable PL/SQL program units. One learns about each of the major segments of a working program and how these interact with each other during program execution, including the important error or exception handling capabilities of the language. The final section goes beyond the basics and begins to explore advanced topics that will be useful later in the Sideris Oracle PL/SQL developer textbook series. One learns techniques and features that allow modular and reusable programs to be developed, increasing productivity and maintainability of database applications.</p><p>his eTextbook introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This textbook will also lay the foundation for the entire Sideris Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications.</p></div><div id="course-pills-2">his eTextbook introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This textbook will also lay the foundation for the entire Sideris Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications.</div>

Microsoft PL-900

Oracle Database 12c: PL/SQL I - Introduction

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is geared for anyone needing to interface with an Oracle database such as end users, business analysts, application developers and database administrators / DBAs.</p>Overview<p>Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course participants will explore:<br />Using PL/SQL programming language for database applications and development<br />incorporating PL/SQL modules within the application architecture from the initial design and planning phase<br />The essentials of building executable PL/SQL program units<br />Each of the major segments of a working program and how these interact with each other during program execution<br />Important error or exception handling capabilities of the language.<br />How database-resident program units can be used as part of the overall database application architecture<br />Applying these new skills to the development of PL/SQL packages.<br />Advanced database programming capabilities and benefits<br />How database triggers can be used as part of an advanced database application design</p><p>Oracle 19c PL/SQL Fundamentals is a three-day, hands-on course that introduces Oracle database programming using the PL/SQL programming language. Throughout the course students will explore the core syntax, structure and features of the language.<br />This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The course also explores applying the newly learned skills to the development of database applications. Participants will learn how to use database-resident stored program units such as procedures, functions, packages and database triggers. Students will also learn about the latest features in Oracle 19c.</p></div><div id="course-pills-2"><h4>Selection &amp; Setup of the Database Interface</h4><ul><li>Considering Available Tools</li><li>Selecting the Appropriate Tool</li><li>Oracle Net Database Connections</li><li>Oracle PAAS Database Connections</li><li>Setup SQL Developer</li><li>Setup SQL *Plus</li><li>Setup JDeveloper</li><li>About BIND and Substitution Variables</li><li>Using SQL Developer</li><li>Using SQL *Plus</li></ul><h4>Choosing a Database Programming Language</h4><ul><li>What is Database Programming</li><li>PL/SQL Programming</li><li>PL/SQL Performance Advantages</li><li>Integration with Other Languages</li></ul><h4>PL/SQL Language Essentials</h4><ul><li>PL/SQL Program Structure</li><li>Language Syntax Rules</li><li>Embedding SQL</li><li>Writing Readable Code</li><li>Generating Readable Code</li><li>Generating Database Output</li><li>SQL * Plus Input of Program Block</li></ul><h4>DECLARE Section</h4><ul><li>About the Declare Section</li><li>Declare Primitive Types</li><li>Declaration Options</li><li>Not Null</li><li>Constant</li><li>Data Dictionary Integration</li><li>% Type</li><li>Declare Simple User-Defined Types</li><li>Type ? Table</li><li>Type ? Record</li><li>Extended User Defined Types</li></ul><h4>BEGIN Section</h4><ul><li>About the Begin Section</li><li>Manipulating Program Data</li><li>Logic Control &amp; Braching</li><li>GOTO</li><li>LOOP</li><li>IF-THEN-ELSE</li><li>CASE</li></ul><h4>EXCEPTION Section</h4><ul><li>About the Exception Section</li><li>Isolating the Specific Exception</li><li>Pragma Exception_INIT</li><li>SQLCODE &amp;SQLERRM Example</li><li>SQL%ROWCOUNT &amp; Select ? Into</li></ul><h4>Beyond the Basics : Explicit Cursors</h4><ul><li>About Explicit Cursors</li><li>Extend Cursor Techniques</li><li>For Update of Clause</li><li>Where Current of Clause</li><li>Using for ? Loop Cursors</li></ul><h4>Introduction Database Resident Programming Units</h4><ul><li>About Database ? Resident Programs</li><li>Physical Storage &amp; Execution</li><li>Types of Stored Program Units</li><li>Stored Program Unit Advantages</li><li>Modular Design Principles</li></ul><h4>Creating Stored Procedures and Functions</h4><ul><li>Stored Procedures &amp; Functions</li><li>Create Procedure / Create Function</li><li>Creating Procedures &amp; Functions</li><li>Raise_Salary() Procedure</li><li>Salary_Valid() function</li><li>The Parameter Specification</li><li>Default Clause</li><li>System &amp; Object Privileges</li><li>Using the Development Tools</li></ul><h4>Executing Stored Procedures and Functions</h4><ul><li>Calling Procedures &amp; Functions</li><li>Unit Testing with Execute</li><li>Anonymous Block Unit Testing</li><li>Specifying a Parameter Notation</li><li>SQL Worksheet Unit Testing</li><li>Calling Functions from SQL</li></ul><h4>Maintaining Stored Programming Units</h4><ul><li>Recompiling Programs</li><li>Mass Recompilation Using UTL_RECOMP()</li><li>Dropping Procedures &amp; Functions</li><li>Drop Procedures &amp; Functions</li><li>Drop Procedure / Function</li><li>Data Dictionary Metadata</li><li>Using USER_OBJECTS</li><li>Using USER_SOURCE</li><li>Using USER_ERRORS</li><li>Using USER_OBJECT_SIZE</li><li>Using USER_DEPENDENCIES</li></ul><h4>Managing Dependencies</h4><ul><li>Dependency Internals</li><li>Tracking Dependencies</li><li>The Dependency Tracking Utility</li><li>SQL Developer Dependency Info</li><li>Dependency Strategy Checklists</li></ul><h4>Creating &amp; Maintaining</h4><ul><li>About Packages</li><li>Creating Packages</li><li>Maintaining Packages</li><li>Performance Considerations</li></ul><h4>Advanced Package Capabilities</h4><ul><li>Definer &amp; Invoker Rights</li><li>White Lists &amp; Accessible By</li><li>Persistent Global Objects</li><li>Defining Initilization Logic</li><li>Object Orientation Support</li></ul><h4>Advanced Cursor Techniques</h4><ul><li>Using Cursor Variables</li><li>Using SYS_REFCURSOR</li><li>Using Cursor Expressions</li></ul><h4>Using System Supplied Packages</h4><ul><li>DBMS_OUTPUT()</li><li>UTL_FILE()</li><li>FOPEN() Example</li></ul><h4>Database Trigger Concepts</h4><ul><li>About Database Triggers</li><li>DML Event Trigger Sub-Types</li><li>Database Trigger Scenario</li><li>Trigger Exhaustion Mechanisms</li><li>Trigger within SQL Worksheet</li></ul><h4>Creating Database Triggers</h4><ul><li>Statement Level Triggers</li><li>Using Raise Application_Error()</li><li>Row-Level Triggers</li><li>Examples of Triggers</li><li>Employee_Salary_Check Example</li><li>Employee_Journal Example</li><li>Budget_Event Example</li><li>Instead of Triggers</li><li>Triggers within and Application</li></ul><h4>Maintaining Database Triggers</h4><ul><li>Call Syntax</li><li>Trigger Maintenance Tasks</li><li>Show Errors Trigger</li><li>Drop Trigger</li><li>Alter Trigger</li><li>Multiple Triggers for a Table</li><li>Handling Mutating Table Issues</li></ul><h4>Implementing System Event Triggers</h4><ul><li>What are System Event Triggers</li><li>Defining the Scope</li><li>Available System Events</li><li>System Event Attributes</li></ul></div>

Programming Fundamentals

Database Programming

Oracle 19c PL/SQL Fundamentals (TTOR12019)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Data Warehouse AdministratorDatabase Administrators</p>Overview<p>Use the Oracle Database tuning methodology appropriate to the available toolsUtilize database advisors to proactively tune an Oracle Database InstanceUse the tools based on the Automatic Workload Repository to tune the databaseDiagnose and tune common SQL related performance problemsDiagnose and tune common Instance related performance problemsUse Enterprise Manager performance-related pages to monitor an Oracle DatabaseGain an understanding of the Oracle Database Cloud Service</p><p>In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, you will be introduced to Oracle Database Cloud Service.</p></div><div id="course-pills-2"><h4>Introduction</h4><ul><li>Course Objectives</li><li>Course Organization</li><li>Course Agenda</li><li>Topics Not Included in the Course</li><li>Who Tunes?</li><li>What Does the DBA Tune?</li><li>How to Tune</li><li>Tuning Methodology</li></ul><h4>Basic Tuning Diagnostics</h4><ul><li>Performance Tuning Diagnostics</li><li>Performance Tuning Tools</li><li>Tuning Objectives</li><li>Top Timed Events</li><li>DB Time</li><li>CPU and Wait Time Tuning Dimensions</li><li>Time Model</li><li>Dynamic Performance Views</li></ul><h4>Using Automatic Workload Repository</h4><ul><li>Automatic Workload Repository Overview</li><li>Automatic Workload Repository Data</li><li>Enterprise Manager Cloud Control and AWR</li><li>Snapshots</li><li>Reports</li><li>Compare Periods</li></ul><h4>Defining the Scope of Performance Issues</h4><ul><li>Defining the Problem</li><li>Limiting the Scope</li><li>Setting the Priority</li><li>Top SQL Reports</li><li>Common Tuning Problems</li><li>Tuning During the Life Cycle</li><li>ADDM Tuning Session</li><li>Performance Versus Business Requirements</li></ul><h4>Using Metrics and Alerts</h4><ul><li>Metrics and Alerts Overview</li><li>Limitation of Base Statistics</li><li>Benefits of Metrics</li><li>Viewing Metric History Information</li><li>Viewing Histograms</li><li>Server-Generated Alerts</li><li>Setting Thresholds</li><li>Metrics and Alerts Views</li></ul><h4>Using Baselines</h4><ul><li>Comparative Performance Analysis with AWR Baselines</li><li>Automatic Workload Repository Baselines</li><li>Moving Window Baseline</li><li>Baselines in Performance Page Settings</li><li>Baseline Templates</li><li>AWR Baseslines</li><li>Creating AWR Baselines</li><li>Managing Baselines with PL/SQL</li></ul><h4>Using AWR-Based Tools</h4><ul><li>Automatic Maintenance Tasks</li><li>ADDM Performance Monitoring</li><li>Using Compare Periods ADDM</li><li>Active Session History</li><li>New or Enhanced Automatic Workload Repository Views</li><li>Emergency Monitoring</li><li>Real-time ADDM</li></ul><h4>Real-Time Database Operation Monitoring</h4><ul><li>Overview</li><li>Use Cases</li><li>Defining a Database Operation</li><li>Scope of a Composite Database Operation</li><li>Database Operation Concepts</li><li>Identifying a Database Operation</li><li>Enabling Monitoring of Database Operations</li><li>Identifying, Starting, and Completing a Database Operation</li></ul><h4>Monitoring Applications</h4><ul><li>What is a Service?</li><li>Service Attributes</li><li>Service Types</li><li>Creating Services</li><li>Managing Services in a Single-Instance Environment</li><li>Where are Services Used?</li><li>Using Services with Client Applications</li><li>Services and Pluggable Databases</li></ul><h4>Identifying Problem SQL Statements</h4><ul><li>SQL Statement Processing Phases</li><li>Role of the Oracle Optimizer</li><li>Identifying Bad SQL</li><li>Top SQL Reports</li><li>SQL Monitoring</li><li>What is an Execution Plan?</li><li>Methods for Viewing Execution Plans</li><li>Uses of Execution Plans</li></ul><h4>Influencing the Optimizer</h4><ul><li>Functions of the Query Optimizer</li><li>Selectivity</li><li>Cardinality and Cost</li><li>Changing Optimizer Behavior</li><li>Optimizer Statistics</li><li>Extended Statistics</li><li>Controlling the Behavior of the Optimizer with Parameters</li><li>Enabling Query Optimizer Features</li></ul><h4>Reducing the Cost of SQL Operations</h4><ul><li>Reducing the Cost</li><li>Index Maintenance</li><li>SQL Access Advisor</li><li>Table Maintenance for Performance</li><li>Table Reorganization Methods</li><li>Space Management</li><li>Extent Management</li><li>Data Storage</li></ul><h4>Using SQL Performance Analyzer</h4><ul><li>Real Application Testing: Overview</li><li>Real Application Testing: Use Cases</li><li>SQL Performance Analyzer: Process</li><li>Capturing the SQL Workload</li><li>Creating a SQL Performance Analyzer Task</li><li>SQL Performance Analyzer: Tasks</li><li>Parameter Change</li><li>SQL Performance Analyzer Task Page</li></ul><h4>SQL Performance Management</h4><ul><li>Maintaining SQL Performance</li><li>Maintaining Optimizer Statistics</li><li>Automated Maintenance Tasks</li><li>Statistic Gathering Options</li><li>Setting Statistic Preferences</li><li>Restore Statistics</li><li>Deferred Statistics Publishing</li><li>Automatic SQL Tuning</li></ul><h4>Using Database Replay</h4><ul><li>Using Database Replay</li><li>The Big Picture</li><li>System Architecture</li><li>Capture Considerations</li><li>Replay Considerations: Preparation</li><li>Replay Considerations</li><li>Replay Options</li><li>Replay Analysis</li></ul><h4>Tuning the Shared Pool</h4><ul><li>Shared Pool Architecture</li><li>Shared Pool Operation</li><li>The Library Cache</li><li>Latch and Mutex</li><li>Diagnostic Tools for Tuning the Shared Pool</li><li>Avoiding Hard Parses</li><li>Reducing the Cost of Soft Parses</li><li>Sizing the Shared Pool</li></ul><h4>Tuning the Buffer Cache</h4><ul><li>Oracle Database Architecture: Buffer Cache</li><li>Buffer Cache: Highlights</li><li>Database Buffers</li><li>Buffer Hash Table for Lookups</li><li>Working Sets</li><li>Buffer Cache Tuning Goals and Techniques</li><li>Buffer Cache Performance Symptoms</li><li>Buffer Cache Performance Solutions</li></ul><h4>Tuning PGA and Temporary Space</h4><ul><li>SQL Memory Usage</li><li>Performance Impact</li><li>Automatic PGA Memory</li><li>SQL Memory Manager</li><li>Configuring Automatic PGA Memory</li><li>Setting PGA_AGGREGATE_TARGET Initially</li><li>Limiting the size of the Program Global Area (PGA)</li><li>SQL Memory Usage</li></ul><h4>Automatic Memory</h4><ul><li>Oracle Database Architecture</li><li>Dynamic SGA</li><li>Granule</li><li>Memory Advisories</li><li>Manually Adding Granules to Components</li><li>Increasing the Size of an SGA Component</li><li>Automatic Shared Memory Management: Overview</li><li>SGA Sizing Parameters: Overview</li></ul><h4>Performance Tuning Summary with Waits</h4><ul><li>Commonly Observed Wait Events</li><li>Additional Statistics</li><li>Top 10 Mistakes Found in Customer Systems</li><li>Symptoms</li></ul><h4>Oracle Database Cloud Service: Overview</h4><ul><li>Database as a Service Architecture, Features and Tooling</li><li>Software Editions: Included Database Options and Management Packs</li><li>Accessing the Oracle Database Cloud Service Console Automated Database Provisioning</li><li>Managing the Compute Node Associated With a Database Deployment</li><li>Managing Network Access to Database as a Service Scaling a Database Deployment</li><li>Performance Management in the Database Cloud Environment</li><li>Performance Monitoring and Tuning</li><li>What Can be Tuned in a DBCS Environment?</li></ul></div>

Oracle Database 12c - Performance Management and Tuning

<strong>Enhance your skills in formatting, printing, and generating reports using Oracle Primavera Project Manager P6 PPM Professional Client. This intermediate-level course provides practical techniques to effectively manage projects and optimize your project management processes.</strong>
        <p>Oracle Primavera is a comprehensive enterprise project portfolio management software that offers a wide range of features, including project management, scheduling, risk analysis, resource management, collaboration, and integration with other enterprise software systems like Oracle and SAP ERP. In this course, you will gain in-depth knowledge of planning, scheduling, and controlling projects using Oracle Primavera P6 PPM Professional.

The course begins with a solid understanding of the software's fundamentals and progresses to cover formatting the display, group, sort, and layout functionalities, as well as applying and creating filters. You will also explore printing, generating reports, and utilizing the visualizer tool. Additionally, you will discover alternative methods for organizing project data effectively.

By the end of this course, you will have acquired the necessary skills to format, print, and run reports using Oracle Primavera Project Manager P6 PPM Professional Client, empowering you to efficiently manage projects.</p>
        <h2>What You Will Learn</h2><p>Gain insights into layouts and filtering options<br>Master the art of formatting bars and progress line displays on the Gantt chart<br>Explore techniques for grouping, sorting, and laying out project data<br>Understand the use of filters, and learn how to apply, create, and modify them<br>Learn the process of executing printing, generating reports, and utilizing the visualizer tool<br>Discover alternative methods for organizing project data efficiently</p>
        <h2>Audience</h2><p>This course is best suited for program managers and project control staff evaluating the software against your organizational requirements, project schedulers who wish to use the software to schedule and control projects, database managers who wish to understand how to set up and administer a database, and experienced project personnel who wish to learn how to schedule and control a project.<br><br>You will need a computer with Primavera; Microsoft Office proficiency is required as a prerequisite. Understanding project planning, scheduling, control, and management processes is necessary.</p>
        <h2>Approach</h2><p>With a learner-centric approach, this course provides clear explanations of concepts, followed by practical demonstrations of software functionality, and reinforces learning through interactive student workshops.</p>
        <h2>Key Features</h2><p>Hands-on workshops focusing on formatting the bar chart and organizing project data * Workshop on effective techniques for using filters and printing in Oracle Primavera P6 * Workshop to creating and utilizing activity codes and UDF to enhance project organization</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Formatting-Printing-and-Reporting-with-Oracle-Primavera-P6-PPM</p>
        <h2>About the Author</h2><h3>Paul E. Harris </h3><p>Paul E. Harris holds an honors degree in civil engineering obtained in the UK and is a certified cost engineer through AACEI International, a PRINCE2 registered practitioner, and a 'Managing Successful Programs' registered practitioner. He has worked in the project controls industry for a number of years and has assisted many companies in a range of industries to set up and run project control systems. His Melbourne, Australia-based company, Eastwood Harris Pty Ltd., offers project controls consulting and training services worldwide with a strong focus on Microsoft Project and Oracle Primavera software.</p>
        <h2>Course Outline</h2><h4>1. Introduction to the Course</h4><p>This section provides an introduction to the course.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction and Workshop Instructions on Formatting, Printing, and Reports</p><p style='margin: 0'>This video provides an overview of the course and instructions on some basic prerequisites and steps to be taken to take advantage of the course to the fullest.</p></td></tr></tbody></table><br><h4>2. Formatting the Display</h4><p>This section focuses on formatting the display.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to this section on formatting the display part.</p></td></tr><tr><td style='padding: 15px;'><p>2. Project Window, Understanding Forms, Formatting the Bars, Progress Lines</p><p style='margin: 0'>Explore the project window, gain understanding of forms, learn how to format bars, and work with progress lines in this comprehensive video.</p></td></tr><tr><td style='padding: 15px;'><p>3. Columns, Row Height, Timescale, Attachments, Fonts, Colors, and Line Numbers</p><p style='margin: 0'>Discover how to manipulate columns, adjust row height, manage timescale, handle attachments, play with fonts and colors, and work with line numbers in this informative video.</p></td></tr><tr><td style='padding: 15px;'><p>4. Summary</p><p style='margin: 0'>Summarizing the section on formatting the display, this video recaps the key concepts covered so far.</p></td></tr><tr><td style='padding: 15px;'><p>5. Workshop - Formatting the Bar Chart</p><p style='margin: 0'>Dive into the practical side as this video guides you through hands-on exercises on formatting bar charts.</p></td></tr></tbody></table><br><h4>3. Group, Sort, and Layout</h4><p>This section focuses on group, sort, and layout on group, sort, and layout.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>Get introduced to the section on group, sort, and layout, and understand the significance of these features in project management.</p></td></tr><tr><td style='padding: 15px;'><p>2. Group and Sort Activities and Understanding Layouts</p><p style='margin: 0'>Learn how to effectively group and sort activities and gain insights into understanding and optimizing project layouts in this instructional video.</p></td></tr><tr><td style='padding: 15px;'><p>3. Summary</p><p style='margin: 0'>Summarizing the section on group, sort, and layout, this video provides a concise overview of the concepts covered thus far.</p></td></tr><tr><td style='padding: 15px;'><p>4. Workshop - Organizing Your Data</p><p style='margin: 0'>Engage in a workshop-style video where you will acquire practical skills for organizing your project data efficiently.</p></td></tr></tbody></table><br><h4>4. Filters</h4><p>This section talks about filters.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to the section on filters, explaining their importance in streamlining project data.</p></td></tr><tr><td style='padding: 15px;'><p>2. Understanding Filters, Applying a Filter, Creating and Modifying a Filter</p><p style='margin: 0'>Gain a deep understanding of filters, learn how to apply them to your project data, and discover the process of creating and modifying filters in this comprehensive video.</p></td></tr><tr><td style='padding: 15px;'><p>3. Activity: Critical Path Visibility</p><p style='margin: 0'>Participate in an activity-based video focusing on critical path visibility and how filters can enhance your understanding of it.</p></td></tr><tr><td style='padding: 15px;'><p>4. Summary</p><p style='margin: 0'>Recapping the section on filters, this video provides a concise summary of the concepts covered so far.</p></td></tr><tr><td style='padding: 15px;'><p>5. Workshop - Filters</p><p style='margin: 0'>Put your knowledge into practice as this video guides you through the process of creating filters to accomplish specific project activities.</p></td></tr></tbody></table><br><h4>5. Printing, Reports, and Visualizer</h4><p>This section focuses on printing, reports, and visualizer.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video introduces the topics of printing, reports, and the visualizer, highlighting their significance in project management.</p></td></tr><tr><td style='padding: 15px;'><p>2. Printing</p><p style='margin: 0'>Explore the intricacies of printing project data as this video covers various aspects related to printing in project management.</p></td></tr><tr><td style='padding: 15px;'><p>3. Reports</p><p style='margin: 0'>Delve into the world of project reports as this video discusses different types of reports and their importance in project analysis.</p></td></tr><tr><td style='padding: 15px;'><p>4. Publish to a Website</p><p style='margin: 0'>Discover the "Publish Project Website" function that enables you to share project data on a website, allowing easy access and collaboration.</p></td></tr><tr><td style='padding: 15px;'><p>5. Visualizer</p><p style='margin: 0'>Understand the visualizer, a powerful graphics reporting tool, and learn how to leverage its capabilities for effective project communication.</p></td></tr><tr><td style='padding: 15px;'><p>6. Claim Digger - Schedule Comparison</p><p style='margin: 0'>Uncover the benefits of Claim Digger, a tool that enables you to compare and evaluate changes made to project schedules in later versions of a report.</p></td></tr><tr><td style='padding: 15px;'><p>7. Summary</p><p style='margin: 0'>Summarizing the section on printing, reports, and the visualizer, this video provides a concise overview of the concepts covered so far.</p></td></tr><tr><td style='padding: 15px;'><p>8. Workshop - Printing</p><p style='margin: 0'>Engage in a workshop-style video where you will issue a report for management feedback and learn how to set up headers and footers for your project documents.</p></td></tr></tbody></table><br><h4>6. Other Methods of Organizing Project Data</h4><p>This section explains other methods of organizing project data.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>Get introduced to the section on other methods of organizing project data and understand their role in efficient project management.</p></td></tr><tr><td style='padding: 15px;'><p>2. Understanding Project Breakdown Structures</p><p style='margin: 0'>This video provides a comprehensive understanding of project breakdown structures and their significance in organizing project data effectively.</p></td></tr><tr><td style='padding: 15px;'><p>3. Activity Codes, UDFs, WBS Category, Resource Codes, Cost Accounts</p><p style='margin: 0'>Explore various methods such as activity codes, user-defined fields (UDFs), WBS categories, resource codes, and cost accounts for organizing project data in this informative video.</p></td></tr><tr><td style='padding: 15px;'><p>4. Assignment Codes and Role Codes</p><p style='margin: 0'>Discover the features of assignment codes and role codes, gaining an overview of how they enhance project organization and management.</p></td></tr><tr><td style='padding: 15px;'><p>5. Summary</p><p style='margin: 0'>Summarizing the section on other methods of organizing project data, this video provides a concise overview of the concepts covered so far.</p></td></tr><tr><td style='padding: 15px;'><p>6. Workshop - Activity Codes and User-Defined Fields (UDFs)</p><p style='margin: 0'>Engage in a workshop-style video where you will create activity codes to represent project departments' responsibilities and learn how to utilize user-defined fields (UDFs) effectively.</p></td></tr></tbody></table>

Packt

Project Management

Enhance your skills in formatting, printing, and generating reports using Oracle Primavera Project Manager P6 PPM Professional Client. This intermediate-level course provides practical techniques to effectively manage projects and optimize your project management processes.

Formatting, Printing, and Reporting with Oracle Primavera P6 PPM

General Admission

<strong>With an emphasis on intermediate-level abilities, this course covers Oracle Primavera Project Manager P6 PPM Professional Client's advanced features. The tool's database administration and setup instructions are also included. Upgrade your skills in Oracle Primavera Project Manager P6 PPM Professional Client with this advanced course.</strong>
        <p>Primavera is an enterprise project portfolio management software. It includes project management, scheduling, risk analysis, opportunity management, resource management, and collaboration and control capabilities, and integrates with other enterprise software such as Oracle and SAP's ERP systems. This course aims to teach students the advanced features of the Oracle Primavera Project Manager P6 PPM Professional tool.

You will start by exploring scheduling options and setting a baseline for the project. Then you will move to understanding user preferences and admin preferences and exploring other methods of organizing project data in Primavera. You will also look at managing the enterprise environment of Primavera. Exciting features such as 'global change' and how to schedule multiple projects will help you a lot in managing your project smoothly. Finally, you will look at the utility part of the Primavera tool in detail.

By the end of the course, you will have successfully learned the advanced features of the Primavera Project Manager P6 PPM Professional tool.

The resource files are uploaded on the GitHub repository at: https://github.com/PacktPublishing/Primavera-P6-PPM-Professional-Advanced-Features</p>
        <h2>What You Will Learn</h2><p>Explore scheduling options and setting a baseline<br>Understand user preferences and admin preferences<br>Explore other methods of organizing project data<br>Manage the enterprise environment of Primavera<br>Learn how to schedule multiple projects using Primavera<br>Look at the utilities part</p>
        <h2>Audience</h2><p>This course is best suited for program managers and project control staff evaluating the software against your organizational requirements, project schedulers who wish to learn how to use the software to schedule and control projects, database managers who wish to understand how to set up and administer a database, and experienced project personnel who wish to learn how to schedule and control a project.<br><br>You will need your computer with Oracle Primavera P6 loaded and experience in using application software such as Microsoft Office.</p>
        <h2>Approach</h2><p>This course follows the approach of explaining first, then a practical demonstration of the software functionality, followed up with student workshops to reinforce the learning.</p>
        <h2>Key Features</h2><p>Workshop on WBS (Work Breakdown Structure), LOEs (Level of Effort), and setting the baseline * Workshop working on codes and User-Defined Fields (UDFs) * Workshop on the Global Change feature</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Primavera-P6-PPM-Professional-Advanced-Features</p>
        <h2>About the Author</h2><h3>Paul E. Harris </h3><p>Paul E. Harris holds an honors degree in civil engineering obtained in the UK and is a certified cost engineer through AACEI International, a PRINCE2 registered practitioner, and a 'Managing Successful Programs' registered practitioner. He has worked in the project controls industry for a number of years and has assisted many companies in a range of industries to set up and run project control systems. His Melbourne, Australia-based company, Eastwood Harris Pty Ltd., offers project controls consulting and training services worldwide with a strong focus on Microsoft Project and Oracle Primavera software.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p>This section provides an introduction to the course.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction and Workshop Instructions</p><p style='margin: 0'>This video provides an overview of the course and guides you with the instructions to be followed in order to achieve the most out of this course.</p></td></tr></tbody></table><br><h4>2. Scheduling Options and Setting a Baseline</h4><p>This section focuses on the scheduling options and setting a baseline in the Primavera P6 tool.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to the section to scheduling options and setting a baseline.</p></td></tr><tr><td style='padding: 15px;'><p>2. Understanding Date Fields</p><p style='margin: 0'>This video explains the data fields options in the tool.</p></td></tr><tr><td style='padding: 15px;'><p>3. Scheduling Options - General Tab</p><p style='margin: 0'>In this video, we will look at the general tab of schedule options that has a number of options to be understood before progressing ahead with a schedule.</p></td></tr><tr><td style='padding: 15px;'><p>4. Setting the Baseline</p><p style='margin: 0'>This video explains what is meant by setting a baseline in a tool. We will be able to compare the current project's progress against the baseline. Here, we will look at two types of baselines: management/contract baselines and last-period status baselines.</p></td></tr><tr><td style='padding: 15px;'><p>5. Limitations on Viewing Baseline Data</p><p style='margin: 0'>This video explains the limitations on viewing baseline data.</p></td></tr><tr><td style='padding: 15px;'><p>6. Summary</p><p style='margin: 0'>This video helps you out with a summary of the section so far.</p></td></tr><tr><td style='padding: 15px;'><p>7. Workshop - WBS, LOEs, and Setting the Baseline</p><p style='margin: 0'>In this video, we will look at how WBS (Work Breakdown Structure) and LOE (Level of Effort) activities work, and then create and assign a baseline.</p></td></tr></tbody></table><br><h4>3. User Preferences and Admin Preferences</h4><p>This section focuses on the user preferences and admin preferences.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to the section on user preferences and admin preferences.</p></td></tr><tr><td style='padding: 15px;'><p>2. User Preferences</p><p style='margin: 0'>This video demonstrates the user preferences option.</p></td></tr><tr><td style='padding: 15px;'><p>3. Admin Menu</p><p style='margin: 0'>This video explains the admin menu options.</p></td></tr><tr><td style='padding: 15px;'><p>4. Admin Preferences</p><p style='margin: 0'>This video demonstrates the admin preferences option.</p></td></tr><tr><td style='padding: 15px;'><p>5. Miscellaneous Defaults</p><p style='margin: 0'>In this video, you will look at miscellaneous defaults: currencies, financial periods, default project, and language.</p></td></tr><tr><td style='padding: 15px;'><p>6. Summary</p><p style='margin: 0'>This video helps you out with a summary of the section so far.</p></td></tr></tbody></table><br><h4>4. Other Methods of Organizing Project Data</h4><p>This section focuses on other methods of organizing project data.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to the section on other methods of organizing project data.</p></td></tr><tr><td style='padding: 15px;'><p>2. Understanding Project Breakdown Structures</p><p style='margin: 0'>This video helps you understand project breakdown structures.</p></td></tr><tr><td style='padding: 15px;'><p>3. Activity Codes, UDFs, WBS Category, Resource Codes, Cost Accounts</p><p style='margin: 0'>This video talks about activity codes, UDFs (user-defined fields), WBS category (work breakdown structure), resource codes, and cost accounts.</p></td></tr><tr><td style='padding: 15px;'><p>4. Assignment Code New to P6 Version 20</p><p style='margin: 0'>This video is about the assignment code. It is aimed at providing an overview of the new assignment code feature in the latest version of Primavera P6 (Version 20).</p></td></tr><tr><td style='padding: 15px;'><p>5. Summary</p><p style='margin: 0'>This video helps you out with a summary of the section so far.</p></td></tr><tr><td style='padding: 15px;'><p>6. Workshop 19 - Activity Codes and User-Defined Fields (UDFs)</p><p style='margin: 0'>In this video, you will create an activity code to represent the departments' responsibilities for the project and then create some UDFs.</p></td></tr></tbody></table><br><h4>5. Global Change</h4><p>This section focuses on the global change feature of the Primavera tool.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to the section on global change.</p></td></tr><tr><td style='padding: 15px;'><p>2. The Basic Concepts and Specifying the Change Statement</p><p style='margin: 0'>This video shows the basic concepts and specifying the change statement.</p></td></tr><tr><td style='padding: 15px;'><p>3. More Advanced Examples of Global Change</p><p style='margin: 0'>This video explores some more advanced examples of global change.</p></td></tr><tr><td style='padding: 15px;'><p>4. Summary</p><p style='margin: 0'>This video helps you out with a summary of the section so far.</p></td></tr><tr><td style='padding: 15px;'><p>5. Workshop 20 - Global Change</p><p style='margin: 0'>In this video, you will copy the current schedule dates and activity durations into the user-defined fields created in the previous workshop. Then, you will display a bar using these user-defined fields and use global change to edit some durations.</p></td></tr></tbody></table><br><h4>6. Managing the Enterprise Environment</h4><p>This section focuses on how to manage the enterprise environment.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to the section on managing the enterprise environment.</p></td></tr><tr><td style='padding: 15px;'><p>2. Multiple User Data Display Issues</p><p style='margin: 0'>This video explains multiple user data display issues.</p></td></tr><tr><td style='padding: 15px;'><p>3. EPS, Project Portfolios, OBS, Users, Security Profiles</p><p style='margin: 0'>This video explains about the EPS (Enterprise Project Structure), project portfolios, OBS (Organizational Breakdown Structure), users, and security profiles.</p></td></tr><tr><td style='padding: 15px;'><p>4. Project Codes, Filtering, Grouping, and Sorting Projects in the Projects Window</p><p style='margin: 0'>This video talks about project codes, filtering, grouping, and sorting projects in the projects window.</p></td></tr><tr><td style='padding: 15px;'><p>5. Summarizing Projects, Job Services, Tracking Window</p><p style='margin: 0'>In this video, you will learn how to summarize projects, job services, and the tracking window.</p></td></tr><tr><td style='padding: 15px;'><p>6. Summary</p><p style='margin: 0'>This video helps you out with a summary of the section so far.</p></td></tr></tbody></table><br><h4>7. Multiple Project Scheduling</h4><p>This section focuses on multiple project scheduling in detail.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to the section on multiple project scheduling.</p></td></tr><tr><td style='padding: 15px;'><p>2. Multiple Projects in a P6 Project, Multiple P6 Projects Representing One Project</p><p style='margin: 0'>This video explains multiple projects in the P6 project, and multiple P6 projects representing one project.</p></td></tr><tr><td style='padding: 15px;'><p>3. Refresh Data and Commit Changes, and Check Who Has the Project Open</p><p style='margin: 0'>This video shows how to refresh data and commit changes. Moving ahead, you will also be able to know who has the project open.</p></td></tr><tr><td style='padding: 15px;'><p>4. Restoring Baselines for Multiple Projects</p><p style='margin: 0'>This video explains restoring baselines for multiple projects.</p></td></tr><tr><td style='padding: 15px;'><p>5. Summary</p><p style='margin: 0'>This video helps you out with a summary of the section so far.</p></td></tr></tbody></table><br><h4>8. Utilities</h4><p>This section explains the utilities features.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to the section on utilities.</p></td></tr><tr><td style='padding: 15px;'><p>2. Reflection Projects, Advanced Scheduling Options, and Audit Trail Columns</p><p style='margin: 0'>In this video, you will learn about the reflection projects, advanced scheduling options, and audit trail columns.</p></td></tr><tr><td style='padding: 15px;'><p>3. Excel and Project: Import and Export Tool</p><p style='margin: 0'>This video focuses on the Primavera built-in tool for importing and exporting to and from Excel. You will also look at how to import and export a project to and from the Primavera tool.</p></td></tr><tr><td style='padding: 15px;'><p>4. Check In and Check Out, UN/CEFACT XML Format, Online HTML Help</p><p style='margin: 0'>This video explains how to check in and check out of the database. After that, you will look at the UN/CEFACT XML format and check whether it is supported by Primavera or not, and finally, see how to get online HTML help.</p></td></tr><tr><td style='padding: 15px;'><p>5. Summary</p><p style='margin: 0'>This video helps you out with a summary of the section so far.</p></td></tr></tbody></table>

With an emphasis on intermediate-level abilities, this course covers Oracle Primavera Project Manager P6 PPM Professional Client's advanced features. The tool's database administration and setup instructions are also included. Upgrade your skills in Oracle Primavera Project Manager P6 PPM Professional Client with this advanced course.

Oracle Primavera P6 PPM Professional Advanced Features

<strong>This course teaches intermediate-level skills in Primavera Project Manager P6 PPM professional client. 

Explore user and admin preferences, create roles and resources, assign expenses, and resource optimization. Discover methods to resolve conflicts and update schedules. Improve your project management skills with the latest techniques and workshops.</strong>
        <p>Primavera is an enterprise project portfolio management software. It includes project management, scheduling, risk analysis, opportunity management, resource management, and collaboration and control capabilities, and integrates with other enterprise software such as Oracle and SAP's ERP systems. This course aims to teach students about creating and assigning resources, along with updating a resource schedule with the Oracle Primavera Project Manager P6 PPM Professional tool. 

You will start by exploring user and administration preferences and scheduling options. Then, you will be understanding and creating resources and roles in Primavera software. Following that, you will be assigning roles, resources, and expenses using the Primavera tool. Then, you will learn how to optimize resources and see methods of resolving resource peaks and conflicts resource leveling; this is one of the most important features of any project management tool. Finally, you will be updating the resourced schedule using the Primavera tool in detail. 

By the end of the course, you will be able to successfully create and assign resources along with updating a resource schedule with Primavera Project Manager P6 PPM Professional Client.

The code files and all resource files are uploaded on the GitHub repository at: 
https://github.com/PacktPublishing/Resource-Management-with-Oracle-Primavera-P6-PPM-Professional</p>
        <h2>What You Will Learn</h2><p>Explore user and admin preferences along with the scheduling options<br>Create resources, roles, and the resources window<br>Study how to assign roles, resources, and expenses<br>Explore how to optimize resources<br>See methods of resolving resource peaks and conflicts in resource leveling<br>Learn to update a resourced schedule</p>
        <h2>Audience</h2><p>This course is best suited for program managers and project control staff evaluating the software against organizational requirements. The project schedulers and experienced project personnel who wish to learn how to use the software to schedule and control projects will gain a lot.<br><br>You will need the Oracle Primavera P6 tool and experience in using application software such as Microsoft Office. Individuals with an understanding of how projects are planned, scheduled, and controlled, including understanding the project management processes applicable to your projects, will be a plus.</p>
        <h2>Approach</h2><p>This course follows the approach of explaining first, followed by a practical demonstration of the software functionality, and followed up with student workshops to reinforce the learning.</p>
        <h2>Key Features</h2><p>Practical workshop on adding resources to the database * Practical workshop on assigning resources and expenses to activities * Practical workshop on resources optimization and updating a resourced schedule</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Resource-Management-with-Oracle-Primavera-P6-PPM-Professional</p>
        <h2>About the Author</h2><h3>Paul E. Harris</h3><p>Paul E. Harris holds an honors degree in civil engineering obtained in the UK and is a certified cost engineer through AACEI International, a PRINCE2 registered practitioner, and a 'Managing Successful Programs' registered practitioner. He has worked in the project controls industry for a number of years and has assisted many companies in a range of industries to set up and run project control systems. His Melbourne, Australia-based company, Eastwood Harris Pty Ltd., offers project controls consulting and training services worldwide with a strong focus on Microsoft Project and Oracle Primavera software.</p>
        <h2>Course Outline</h2><h4>1. Introduction to Resource Management</h4><p></p><br><h4>2. User Preferences and Admin Preferences</h4><p></p><br><h4>3. Creating Roles and Resources</h4><p></p><br><h4>4. Assigning Roles, Resources and Expenses</h4><p></p><br><h4>5. Resource Optimization</h4><p></p><br><h4>6. Updating a Resourced Schedule</h4><p></p>

This course teaches intermediate-level skills in Primavera Project Manager P6 PPM professional client. 

Explore user and admin preferences, create roles and resources, assign expenses, and resource optimization. Discover methods to resolve conflicts and update schedules. Improve your project management skills with the latest techniques and workshops.

Resource Management with Oracle Primavera P6 PPM Professional

<strong>This course aims to teach users how to set a baseline and update an un-resourced project with Oracle Primavera P6 PPM Professional. This course teaches intermediate-level skills in Primavera project manager P6 PPM professional client.</strong>
        <p>The resource files for this title have been updated. Primavera is an enterprise project portfolio management software. It includes project management, scheduling, risk analysis, opportunity management, resource management, collaboration, and control capabilities, and integrates with other enterprise software such as Oracle and SAP's ERP systems. This course is designed to teach participants the essential skills needed to set up baselines, track progress, and perform baseline comparisons using Oracle Primavera P6 PPM Professional.

You will start with understanding date fields, followed by scheduling options-general tab. The topics that you will learn further are setting the baseline and limitations on viewing baseline data; practical methods of the recording process and understanding the concepts; updating the schedule, progress spotlight, and update progress, suspend, and resume; scheduling the project; comparing progress with the baseline; progress line display on the Gantt chart; checking list before updating schedule, in-progress schedule checklist, and corrective actions.

By the end of the course, you will have a strong grasp of setting baselines, effectively tracking progress, and performing accurate baseline comparisons in Primavera P6 PPM Professional.</p>
        <h2>What You Will Learn</h2><p>Understand date fields and scheduling options in Primavera P6 PPM<br>Set up baselines and overcome limitations in viewing baseline data<br>Employ practical methods for recording project progress<br>Update project schedules and comprehend progress displayed on Gantt charts<br>Compare project progress with baselines and take corrective actions<br>Follow a checklist for effectively updating unresourced schedules</p>
        <h2>Audience</h2><p>This course is best suited for program managers and project control staff evaluating the software against your organizational requirements, project schedulers who wish to learn how to use the software to schedule and control projects, database managers who wish to understand how to set up and administer a database, and experienced project personnel who wish to learn how to schedule and control a project.<br><br>You will need your computer with Oracle Primavera P6 loaded and experience in using application software such as Microsoft Office.</p>
        <h2>Approach</h2><p>This course follows a structured approach, providing explanations of key concepts, practical demonstrations of software functionality, and engaging workshops to reinforce learning.</p>
        <h2>Key Features</h2><p>Learn to set baselines and update projects using Primavera P6 PPM Professional * Workshop on understanding WBS, LOE activities, and baseline creation * Workshop on tracking project progress and comparing with the established baseline</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Baselines-and-Updating-a-Project-with-Oracle-Primavera-P6-PPM</p>
        <h2>About the Author</h2><h3>Paul E. Harris </h3><p>Paul E. Harris holds an honors degree in civil engineering obtained in the UK and is a certified cost engineer through AACEI International, a PRINCE2 registered practitioner, and a 'Managing Successful Programs' registered practitioner. He has worked in the project controls industry for a number of years and has assisted many companies in a range of industries to set up and run project control systems. His Melbourne, Australia-based company, Eastwood Harris Pty Ltd., offers project controls consulting and training services worldwide with a strong focus on Microsoft Project and Oracle Primavera software.</p>
        <h2>Course Outline</h2><h4>1. Introduction and Workshop Instructions</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction and Workshop Instructions</p><p style='margin: 0'>This video provides an overview of the course and instructions on some basic prerequisites and steps to be taken to take advantage of the course to the fullest.</p></td></tr></tbody></table><br><h4>2. Scheduling Options and Setting a Baseline</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to the section. Here, you will understand a basic idea about the scheduling options and setting a baseline.</p></td></tr><tr><td style='padding: 15px;'><p>2. Understanding Date Fields</p><p style='margin: 0'>Understanding date fields is the focus of this video, where we explore the various date field options available in the tool and their significance in project scheduling.</p></td></tr><tr><td style='padding: 15px;'><p>3. Scheduling Options - General Tab</p><p style='margin: 0'>In this video, we will look at the general tab of the schedule option, which has a number of options to be understood before progressing ahead with a schedule. Here, you will be examining the specific settings and configurations related to scheduling in the Primavera P6 tool.</p></td></tr><tr><td style='padding: 15px;'><p>4. Setting the Baseline</p><p style='margin: 0'>This video explains what is meant by setting a baseline in a tool. We will be able to compare the current project's progress against the baseline. Here, we will look at two types of baselines: management/contract baselines and last-period status baselines.</p></td></tr><tr><td style='padding: 15px;'><p>5. Limitations on Viewing Baseline Data</p><p style='margin: 0'>In this video, we explore the limitations on viewing baseline data, shedding light on the factors that may affect the visibility and accessibility of baseline information.</p></td></tr><tr><td style='padding: 15px;'><p>6. Summary</p><p style='margin: 0'>This video provides a comprehensive summary of the section, offering a concise recap of the key concepts and techniques covered throughout the videos.</p></td></tr><tr><td style='padding: 15px;'><p>7. Workshop - WBS, LOEs, and Setting the Baseline</p><p style='margin: 0'>In this video, we will delve into the practical aspects of project management, focusing on Work Breakdown Structure (WBS), Level of Effort (LOE) activities, and the process of creating and assigning a baseline. Discover how WBS and LOE activities contribute to effective project planning and execution, and gain insights into their implementation. Follow along as we demonstrate the step-by-step process of creating a comprehensive WBS and determining LOE activities for your project.</p></td></tr></tbody></table><br><h4>3. Updating an Un-Resourced Schedule</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction to Data Structure</p><p style='margin: 0'>This video provides an introductory overview of the section, offering key insights into the topics and concepts that will be covered in detail. Here, you will get the basic idea about how to update an un-resourced schedule.</p></td></tr><tr><td style='padding: 15px;'><p>2. Practical Methods of Recording Progress</p><p style='margin: 0'>Discover practical methods of recording progress and gain a deeper understanding of the underlying concepts involved in updating an un-resourced schedule.</p></td></tr><tr><td style='padding: 15px;'><p>3. Understanding the Concepts and Updating the Schedule</p><p style='margin: 0'>In this video, we will cover updating the schedule, progress spotlight, and update progress, suspend and resume, scheduling the project, comparing progress with the baseline, progress line display on the Gantt chart, checking the list before updating the schedule, in-progress schedule checklist, and corrective actions.</p></td></tr><tr><td style='padding: 15px;'><p>4. Summary</p><p style='margin: 0'>This video provides a comprehensive summary of the section, offering a concise recap of the key concepts and techniques covered throughout the videos.</p></td></tr><tr><td style='padding: 15px;'><p>5. Workshop - Progressing and Baseline Comparison</p><p style='margin: 0'>This is the workshop video, where we will dive into the practical aspects of monitoring project progress and comparing it with the established baseline using the Primavera P6 tool. This video is a step-by-step process of updating the project schedule, recording actual progress, and conducting a thorough comparison with the baseline.</p></td></tr></tbody></table>

This course aims to teach users how to set a baseline and update an un-resourced project with Oracle Primavera P6 PPM Professional. This course teaches intermediate-level skills in Primavera project manager P6 PPM professional client.

Baselines and Updating a Project with Oracle Primavera P6 PPM

Master the art of project planning, scheduling, and resource management with Oracle Primavera P6 PPM Professional. The course offers a streamlined approach to efficiently manage projects and includes workshops for intermediate-level users to apply their knowledge in practice.

Planning and Control with Oracle Primavera P6 PPM Professional

This course is designed for project managers and planners who need to plan and manage projects without resources in Oracle Primavera P6 PPM. You will learn how to navigate the user interface, create project plans, define activities, and manage project timelines without relying on resource constraints.

Creating an Unresourced Project with Oracle Primavera P6 PPM

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					<div><p>The innovative <strong>Primavera P6 Beginner &amp; Intermediate Training</strong> has been compiled with the assistance and expertise of industry professionals. It has been carefully crafted to meet the business requirements needed for an outstanding contribution to this role and the career path beyond it. By enrolling in this tutorial, a significant advantage can be gained by the student for securing their dream job and building an excellent reputation in this sector.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div><p>This popular <strong>Primavera P6 Beginner &amp; Intermediate Training</strong> has been designed to help dedicated individuals train to become the absolute best in this business field. Many other entrepreneurs and talented students have already completed this course, and others like it, empowering them to move onto satisfying and rewarding careers. This unique <strong>Primavera P6 Beginner &amp; Intermediate Training</strong> course is perfectly suited for those dedicated and ambitious individuals who are committed to genuinely becoming the best in the business. </p><p>The <strong>Primavera P6 Beginner &amp; Intermediate Training</strong> is recognised and accredited by CPD standards, so all contents are guaranteed to be accurate and reputable, adding valuable competencies and qualifications to a CV, making anyone stand out from other potential candidates or business rivals. For added convenience, the <strong>Primavera P6 Beginner &amp; Intermediate Training</strong> consists of a range of educational modules that allow study sessions to be organised at any time and any place</p><p>When the final assessment of the <strong>Primavera P6 Beginner &amp; Intermediate Training </strong>has been completed, a certificate of completion is supplied to evidence newly acquired skills and knowledge. This will provide a significant boost for job-seeking or entry into a new and exciting career path. The valuable qualification from the <strong>Primavera P6 Beginner &amp; Intermediate Training</strong> course can help to make all the difference in a dynamic employment sector and can also be validated on our website.</p><p>We are aware that a student's lifestyles and work ethics may not allow much time for a dedicated study session, so the <strong>Primavera P6 Beginner &amp; Intermediate Training</strong> has been specifically designed to be taken at a personally selected pace, and the hours that are suited to each individual. Full access is immediately available after registration, and this can be achieved via any online device, and at any global location you are sighted at.  </p><p>Our fully-trained tutors are committed to helping you throughout the course, and will instantly respond to any queries that are sent to them via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>

Course Cloud

Primavera P6 Beginner & Intermediate Training

<p><strong>Primavera P6 for Beginners</strong></p><p>Turn your skills into a competitive advantage that is recognised globally and endorsed for quality by QLS, the UK's most reputable high-quality course auditor.</p><p>Having problems keeping track of your chores and projects? Don't worry, we'll show you a tool that will make the procedure easier with Primavera software, which is a well-known project management system and will teach you how to use it to plan, schedule, and execute your projects. To get started, all you need is a computer with Primavera P6 installed and an internet connection. Enrol now to improve your management skills!</p><p>This premium QLS endorsed Primavera P6 for Beginners course comes with intensive study modules, dedicated tutor assistance, customer support, flexible learning opportunity and a globally recognised certification all-together. Thus, successful completion of our Primavera P6 for Beginners course will give you limitless opportunities anywhere and everywhere, since the value of QLS endorsed courses are quite high, to say the least!!</p><p>What's more, the quality of our first-class course is uncompromising for both you and us. You will be taught the richest of materials from this exquisite Primavera P6 for Beginners course, enabling you to open up a vast world of opportunities for you to grasp and gain success from. For the price point, this course is actually an absolute steal! It's an investment you absolutely do not want to miss out on!</p><p>So, why delay any longer? Benefit your career progression by joining us today and distinguish yourself as, unquestionably, the most skilled one in your workplace!</p><p><strong>Why Learn with us: </strong></p><p>We, as one of the leading e-learning service providers across the globe, strive to provide all our learners with the best e-learning experience possible that can make a real difference in their career progression.</p><p><strong>Our Service for the </strong><strong>Primavera P6 for Beginners</strong><strong> Includes: </strong></p><ul><li>Intensive Study Notes</li><li>Tutor Support</li><li>Customer Support</li><li>Assignment Help</li><li>QLS Endorsed Certificate</li><li>24/7 Learning Portal Access</li><li>Widely Compatible Study Materials</li></ul><p><strong>Course Curriculum of </strong><strong>Primavera P6 for Beginners</strong></p><ul><li><strong>Module 01:</strong> Introduction</li><li><strong>Module 02:</strong> Navigating the Workspace</li><li><strong>Module 03:</strong> The Enterprise Project Structure (EPS)</li><li><strong>Module 04:</strong> Creating a New Project in P6</li><li><strong>Module 05:</strong> Setting Up Calendars in P6</li><li><strong>Module 06:</strong> Creating a Work Breakdown Structure in P6</li><li><strong>Module 07:</strong> Adding Activities in P6</li><li><strong>Module 08:</strong> Adding Schedule Logic in P6</li><li><strong>Module 09:</strong> Completing the Schedule in P6</li><li><strong>Module 10:</strong> Layouts in P6</li><li><strong>Module 11:</strong> Scheduling Exercise</li><li><strong>Module 12:</strong> Scheduling Exercise Answers</li><li><strong>Module 13:</strong> Bonus Learning Section</li></ul><p><strong>Assessment &amp; Certification</strong></p><p>Learners must submit a comprehensive summarised assignment on all the units that will be assessed by our expert tutor if all the learning outcomes are met as per the standard set by QLS. After the quality check, the learner will be provided with the Primavera P6 for Beginners certificate.</p><p><strong>Endorsed Certificate of Achievement from the Quality Licence Scheme</strong></p><p>An endorsed certificate will be issued to learners at the end of the course as recognition of course completion. Provided that learner completes all the assessment of a course can claim for certificate.</p><p><strong>Endorsement:</strong></p><p>QLS endorsed this certified course as a highly qualified, non-regulated provision and training programme. There will be a trainer to answer all your questions including your progression routes into further higher education.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        10 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>Our course is open for everyone. This Primavera P6 for Beginners is ideal for those who aspire to gain in-depth knowledge &amp; efficient skill to embark into the relevant sector as a promising potential.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>There are no formal requirements needed for this Primavera P6 for Beginners course. So learners do not require any prior qualifications to enrol in this course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p><strong>Primavera P6 for Beginners course opens opportunities to explore numbers of careers as given below:</strong></p><ul><li>Primavera P6 Planner.£500 - £540 per day</li><li>Project Planner.£75,000 - £85,000 per annum</li><li>Bid Engineering Project Manager.£40,000 - £50,000 per annum</li><li>Project Controls Analyst: £30,000 - £45,000 per year</li><li>Estimator: £30,000 - £45,000</li></ul>
                        </div>

Kingston Open College

Project Management Qualification (PMQ)

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

Primavera P6 for Beginners - QLS Endorsed

<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>

				</div>
				<div>
				<div>
					<div><p><span>Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This Primavera P6 Professional Training Course</span><span> has been specially designed to help learners gain a good command of Primavera P6 Professional Training</span><span>, providing them with a solid foundation of knowledge to become a qualified professional.</span></p><p><span>Through this Primavera P6 Professional Training Course</span><span>, you will gain both practical and theoretical understanding of Primavera P6 Professional Training</span><span> that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.</span></p><p><span>Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.</span></p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
																					</div>
				</div>
				</div>
				<div>
				<h2>Learning outcome</h2>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Get a deep understanding of the Primavera P6 Professional Training Course just in hours not years</span>
									</li>
								<li>
											<span>
													</span>
										<span>Familiar yourself with the recent development and updates of the relevant industry</span>
									</li>
								<li>
											<span>
													</span>
										<span>Know how to use your theoretical and practical knowledge to adapt in any working environment</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get help from our expert tutors anytime you need</span>
									</li>
								<li>
											<span>
													</span>
										<span> Access to course contents that are designed and prepared by industry professionals</span>
									</li>
								<li>
											<span>
													</span>
										<span>Study at your convenient time and from wherever you want </span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
						</div>
			</div>
		</div>
				<div>
			<div>
					<div>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
																					</div>
				</div>
				</div>
				<div>
				<h2>Requirements</h2>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>No formal qualifications required, anyone from any academic background can take this course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to any internet-enabled smart device.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<h2>Why should I take this course?</h2>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>1+ hours of on-demand video lectures and downloadable resources.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Affordable premium-quality E-learning content, you can learn at your own pace.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will receive a completion certificate upon completing the course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Internationally recognized Accredited Qualification will boost up your resume.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will learn the researched and proven approach adopted by successful salespeople to transform their careers.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will be able to incorporate various practical sales techniques successfully and understand your customers better.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section><div>
                            <div>
                                <h2>Course Curriculum</h2>
                            </div>
                            			<div>
				

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"><strong>Primavera P6 Professional Training Course</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Module 01: Introduction</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Module 02: Navigating the Workspace</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Module 03: The Enterprise Project Structure (EPS)</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Module 04: Creating a New Project in P6</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Module 05: Setting Up Calendars in P6</td><td><span>🕐 00:08:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Module 06: Creating a Work Breakdown Structure in P6</td><td><span>🕐 00:08:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Module 07: Adding Activities in P6</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Module 08: Adding Schedule Logic in P6</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Module 09: Completing the Schedule in P6</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Module 10: Layouts in P6</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Module 11: Scheduling Exercise</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Module 12: Scheduling Exercise Answers</td><td><span>🕐 00:01:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Module 13: Bonus Learning Section</td><td><span>🕐 00:01:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
		                        </div>

Skill Up

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Primavera P6 Professional Training Course

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is designed for operators and schedulers who perform duties that are related to batch workload automation.</p>Overview<p>In this course, you learn how to perform the following tasks:Explain the production terminology used with IBM Workload Scheduler and its production planning processMonitor production batch workload processesManage production batch workloadCreate and modify scheduling objectsSchedule new workloadsForecast future workloadsMigrate workload definitions from test to production environmentsCreate and maintain reports about production workloads</p><p>This course provides professional report authors an opportunity to learn report building techniques using relational data models. Demonstrations and exercises will illustrate and reinforce key concepts during this learning opportunity.</p></div><div id="course-pills-2"><h4>IBM Workload Scheduler Introduction</h4><ul><li>About Workload Automation</li><li>IBM workload automation offerings</li><li>IBM Workload Scheduler terminology</li><li>Workload Scheduler user interfaces</li><li>Getting started with Application Lab</li><li>Getting started with the Dynamic Workload Console</li><li>Connecting the console to Workload Scheduler</li><li>Getting started with the command-line interfaces</li></ul><h4>Using the Application Lab Interface</h4><ul><li>Using the processes status overview page</li><li>Managing processes</li><li>Using other Application Lab functions</li></ul><h4>Monitoring Workload Scheduler Production</h4><ul><li>Monitoring Workload Scheduler production by using queries</li><li>Using the Workload Dashboard</li><li>Monitoring system status and health</li><li>Monitoring plan objects</li><li>Using the What-if Analysis interface</li><li>Monitoring the plan graphically</li></ul><h4>Managing Workload Scheduler Production</h4><ul><li>Managing the scheduling environment</li><li>Managing scheduling objects in the plan</li></ul><h4>Creating Scheduling Objects</h4><ul><li>Using the Workload Designer</li><li>Creating scheduling objects</li><li>Creating variables and variable tables</li><li>Creating prompts and resources</li><li>Creating calendars</li><li>Defining jobs</li></ul><h4>Scheduling, Forecasting, and Migrating Workloads</h4><ul><li>Creating job streams</li><li>Applying jobs to job streams</li><li>Setting time and date restrictions</li><li>Using advanced scheduling options</li><li>Creating job stream definitions by using composer</li><li>Creating and using event rules</li><li>Forecasting and previewing future dates</li><li>Exporting and importing scheduling definitions</li><li>Using Workload Application Templates</li></ul><h4>Reporting with Workload Scheduler</h4><ul><li>Using reporting features</li><li>Using Common Reporting with Workload Scheduler</li><li>Using the batch reporting utility</li><li>Using the preformatted text-based report utilities</li></ul></div>

27 Oracle Primavera courses delivered Online

Oracle Peoplesoft PeopleTools I

By Nexus Human

Primavera P6 Professional Fundamentals Rel 19

By Nexus Human

Oracle WebLogic Server 12c - Administration II

By Nexus Human

R12.x Extend Oracle Applications - OA Framework Personalizations

By Nexus Human

Oracle Database 12c R2 - Backup and Recovery Workshop Ed 3

By Nexus Human

Oracle Database: Managing Multitenant Architecture

By Nexus Human

Oracle 19c Database Tuning (TTOR21519)

By Nexus Human

Oracle Database 12c: PL/SQL I - Introduction

By Nexus Human

Oracle 19c PL/SQL Fundamentals (TTOR12019)

By Nexus Human

Oracle Database 12c - Performance Management and Tuning

By Nexus Human