<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>Overview<p>Our engaging instructors and mentors are highly-experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will explore:<br />New Features Overview<br />Multitenant New Features<br />Security Features<br />Cloud Services<br />Networking<br />Globalization<br />Big Data Support<br />Database Installation and Configuration<br />Database Tuning<br />Backup and Recovery</p><p>Oracle 19c New Features is a hands-on course that explores the newest features such as Big Data Enhancements, Security, Multitenant features, Oracle Cloud Services, Networking, and much more. Oracle is one of the leading databases in industry today. Learn what their latest flagship product has to offer from industry experts.</p></div><div id="course-pills-2"><h4>Oracle 19c New Features Overview</h4><ul><li>Introduction to Oracle 19c New Features</li></ul><h4>Oracle 19c Multitenant New Features</h4><ul><li>Refreshable PDB Switchover</li><li>PDB Integration with Data Guard</li><li>PDB Snapshot Carousel</li><li>CDB Fleet Management</li></ul><h4>Oracle 19c Security Features</h4><ul><li>Profile Lockdown</li><li>Create a User Defined Master Encryption Key</li><li>Encrypted Passwords in Database Links and Data Pump</li><li>Create Keystores for Pluggable Databases</li><li>Datapump and Unified Auditing</li><li>Schema Only Accounts</li></ul><h4>Oracle 19c Cloud Services</h4><ul><li>Oracle IaaS</li><li>Oracle Saas</li><li>Oracle PaaS</li></ul><h4>Oracle 19c Networking</h4><ul><li>Database Connection Manager</li><li>Database Proxy Support</li><li>Tenant Isolation</li></ul><h4>Oracle 19c Globalization</h4><ul><li>New globalization for Bind Variables</li><li>New Database Local Support</li><li>Additional Unicode Support</li></ul><h4>Big Data Support</h4><ul><li>New Analytic Support</li><li>Data Mining Data Warehouse</li><li>Additional Parallel Processing Support</li><li>Inline External Tables</li></ul><h4>Database Installation and Configuration</h4><ul><li>Zero Downtime Upgrades</li><li>Dry Run Command implementation</li><li>New location for Password File</li><li>Improved Bulk Operations</li></ul><h4>Database Tuning</h4><ul><li>SQL Tuning Advisor and Exadata</li><li>New SQL Tuning Set API</li><li>Concurrent SQL and Sql Performance Analyzer</li><li>Database In Memory Features</li><li>In Memory Support for External Tables</li><li>In Memory Features for Analytics</li></ul><h4>Oracle 19c Backup and Recovery</h4><ul><li>Active Pluggable Cloning</li><li>Pluggable and non Pluggable Database Migration</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle 19c New Features (TTOR20019) 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 19c New Features (TTOR20019) 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

Oracle SQL

Oracle

Oracle Fusion HCM

Oracle 1Z0-819

Trainers Course

Oracle Database

Oracle 19c New Features (TTOR20019)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Data Warehouse AdministratorDatabase AdministratorsDatabase DesignersSupport EngineerTechnical Administrator</p>Overview<p>Monitor the DatabaseManage Database PerformanceImplement Database AuditingConfigure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and TasksSchedule Jobs to Run Inside or Outside of the DatabaseConfigure Oracle Net ServicesConfigure your Database For Backup and Recovery OperationsDescribe Oracle Database ArchitectureManage the Oracle Database InstanceManage Oracle Database Storage structuresCreate and Administer User Accounts</p><p>The Oracle Database 12c: Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance.</p></div><div id="course-pills-2">The Oracle Database 12c: Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance.</div>

AWS Certified Database

Database Administration

Oracle Database 12c - Administration Workshop

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This hands-on course is geared for experienced DBAs already working with Oracle.</p>Overview<p>This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises.  Working in a hands-on learning environment led by our expert facilitator, you'll learn how to:<br />Implement backup and recovery settings and perform backup operations to the media of your choice.<br />Move data between databases and files<br />Use Oracle Database recovery processes to recover from media and other failures.<br />Diagnose and repair data failures<br />Use flashback technologies and data duplication to complement backup and recovery procedures<br />Secure the availability of their database using backup and recovery strategies</p><p>Geared for DBAs and other technical support staff, Oracle Database 19c Backup and Recovery is a hands-on course that allows you to develop appropriate backup and recovery procedures to address their business model and requirements.  Throughout the course you?ll explore how to implement basic backup and recovery procedures, move data between databases and files, and employ basic monitoring procedures. You?ll  also learn how to secure the availability of a database by using appropriate backup and recovery strategies, how to how to perform backup and recovery operations using RMAN, and how to use Flashback features to recover from human error. This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises.  Working in a hands-on learning environment led by our expert facilitator, you?ll learn how to:Implement backup and recovery settings and perform backup operations to the media of your choice.Move data between databases and filesUse Oracle Database recovery processes to recover from media and other failures.Diagnose and repair data failuresUse flashback technologies and data duplication to complement backup and recovery proceduresSecure the availability of their database using backup and recovery strategies</p></div><div id="course-pills-2"><h4>Backup Methods</h4><ul><li>User Managed Backups</li><li>Oracle Managed Backups Types of Failures</li><li>Types of Recoveries</li></ul><h4>Recovery Configuration</h4><ul><li>Configuring the Database for Archivelog</li><li>Configuring the Database for No-Archivelog</li><li>Configuring the Flash Recovery Area</li></ul><h4>Configuring RMAN</h4><ul><li>RMAN Default Settings</li><li>Command Line</li><li>Enterprise Manager</li></ul><h4>RMAN Backups</h4><ul><li>Full RMAN Backup</li><li>Compressed Backups</li><li>Uncompressed Backups</li><li>Partial RMAN Backup</li><li>Incremental Backups</li><li>Change Tracking File</li></ul><h4>Managing Backups</h4><ul><li>Backup Reports</li><li>Backup Maintenance</li><li>Backup Catalog</li><li>Backup Crosscheck</li></ul><h4>RMAN Complete Recovery</h4><ul><li>RMAN Complete Recovery</li><li>Database Recovery</li><li>Tablespace Recovery</li><li>Datafile Recovery</li></ul><h4>RMAN In-Complete Recovery</h4><ul><li>Time Based Recovery</li><li>Sequence Based Recovery</li><li>SCN Based Recovery</li></ul><h4>Non-Database File Recovery</h4><ul><li>Spfile Recovery</li><li>Controlfile Recovery</li><li>Incremental Recovery</li><li>Flash Recovery Area for a Fast Recovery</li></ul><h4>User Managed Backup</h4><ul><li>Configuring User Managed Backups</li><li>Perform a User Managed Backup</li></ul><h4>User Managed Recovery</h4><ul><li>User Managed Complete Recovery</li><li>User Managed Incomplete Recovery</li></ul><h4>Configuring Flashback</h4><ul><li>Flashback Query</li><li>Flashback Drop</li><li>Flashback Database</li></ul><h4>Performing Flashback Recoveries</h4><ul><li>Flashback Query</li><li>Flashback Drop</li><li>Flashback Transaction Query</li><li>Flashback Versions Query</li></ul><h4>Performing Flashback Database</h4><ul><li>Determining the FRA Size</li><li>FRA Retention</li><li>Performing a Flashback Database</li></ul><h4>RMAN Duplicate Command</h4><ul><li>Setting up for a Duplicate Database</li><li>Creating the Duplicate spfiles</li><li>Performing the Duplicate Command.</li></ul><h4>RMAN Recovery Catalog</h4><ul><li>Configuring for the Recovery Catalog</li><li>Creating the Recovery Catalog</li></ul><h4>Backups with the Recovery Catalog</h4><ul><li>Registering the Database with the Recovery Catalog</li><li>Performing Backups with the Recovery Catalog</li></ul><h4>Recoveries with the Recovery Catalog</h4><ul><li>Identifying Type of Recoveries with the Recovery Catalog</li><li>Performing Recoveries with the Recovery Catalog</li></ul><h4>Recovery Catalog Maintenance</h4><ul><li>Registering Additional Databases with the Recovery Catalog</li><li>Cataloging Additional Backups with the Recovery Catalog</li><li>Recovery Catalog Scripts</li></ul><h4>DataPump</h4><ul><li>Configuring Datapump</li><li>DataPump Exports</li><li>DataPump Imports</li></ul><h4>Tuning RMAN</h4><ul><li>RMAN Sessions</li><li>RMAN Channels</li><li>RMAN Job Progress</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle 19c Database Backup and Recovery (TTOR21619) 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 19c Database Backup and Recovery (TTOR21619) 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>

Oracle 19c Database Backup and Recovery (TTOR21619)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Oracle Database Administrator<br />Data Warehouse Administrator<br />Support Engineer<br />Technical Consultant<br />Technical Administrator</p>Overview<p>The student benefits by gaining a deeper understanding of possibly the most important job of a DBA - backup and recovery. The concepts and architecture that support backup and recovery, along with implementation steps in various ways and situations, are presented in detail.<br /><br />Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication.</p><p>The student begins by gaining a deeper understanding of possibly the most important job of a DBA - backup and recovery. The concepts and architecture that support backup and recovery, along with implementation in various ways and situations are covered in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication.</p></div><div id="course-pills-2"><h4>Introduction and Configuration</h4><ul><li>Introduction<br />Getting Started<br />Configuring for Recoverablility<br />Using the RMAN Recovery Catalog</li></ul><h4>Backup</h4><ul><li>Backup Strategies and Terminology<br />Performing Backups<br />Improving Your Backups<br />Using RMAN-Encrypted Backups</li></ul><h4>Recovery</h4><ul><li>Diagnosing Failures<br />Restore and Recovery Concepts<br />Performing Complete Recovery<br />Performing Point-in-Time Recovery<br />Performing Additional Recovery Operations</li></ul><h4> Additional Technologies</h4><ul><li>Using Flashback Technologies<br />Using Flashback Database<br />Transporting Data<br />Duplicating a Database<br />RMAN Troubleshooting and Tuning</li></ul><h4>Hands-On</h4><ul><li>Backup and Recovery Workshop</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle Database: Backup and Recovery Workshop 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 Database: Backup and Recovery Workshop 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>

Oracle Database: Backup and Recovery Workshop

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>Database Administrators<br />Administrator</p>Overview<p>Describe the Oracle Clusterware architecture<br />Describe how Grid Plug and Play affects Clusterware<br />Describe the benefits of Oracle RAC<br />Explain the necessity of global resources<br />Describe global cache coordination<br />Install the Oracle database software<br />Create a cluster database<br />Perform post-database-creation tasks<br />Convert a single-instance Oracle database to RACs<br />Explain the principles and purposes of clusters<br />Define redo log files in a RAC environment<br />Define undo tablespaces in a RAC environment<br />Start and stop RAC databases and instances<br />Modify initialization parameters in a RAC environment<br />Configure the RAC database to use ARCHIVELOG mode and the fast recovery area<br />Configure RMAN for the RAC environment</p><p>This Oracle Database 12c: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion.</p></div><div id="course-pills-2">This Oracle Database 12c: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion.</div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle Database 12c - RAC Administration 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 Database 12c - RAC Administration 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>

Oracle Database 12c - RAC Administration

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Database Administrators<br />Data Warehouse Administrator<br />Support Engineer<br />Technical Consultant<br />Technical Administrator</p>Overview<p>Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure.<br />Describe the Oracle Database architecture components related to backup and recovery operations.<br />Plan effective backup and recovery procedures.<br />Configure the database for recoverability.<br />Use Recovery Manager (RMAN) to create backups and perform recovery operations.<br />Use the Data Recovery Advisor to diagnose and repair failures.<br />Use Oracle Flashback Technologies to recover from human error.<br />Perform an encrypted database backup and restore.<br />Perform tablespace point-in-time recovery.<br />Describe additional high availability features such as Oracle Data Guard.</p><p>This Oracle Database 12c: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You'll develop appropriate strategies for backup, restore and recovery procedures from provided scenarios.</p></div><div id="course-pills-2">This Oracle Database 12c: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You'll develop appropriate strategies for backup, restore and recovery procedures from provided scenarios.</div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle Database 12c - Backup and Recovery Workshop 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 Database 12c - Backup and Recovery Workshop 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>

Oracle Database 12c - Backup and Recovery Workshop

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This intermediate-level hands-on course is geared for experienced Administrators, Analysts, Architects, Data Scientists, Database Administrators and Implementers</p>Overview<p>This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our Oracle Certified expert facilitator, students will learn how to:<br />Administer ODI resources and setup security with ODI<br />Apply ODI Topology concepts for data integration<br />Describe ODI Model concepts<br />Describe architecture of Oracle Data Integrator<br />Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations<br />Explore, audit data, and enforce data quality with ODI<br />Implement Changed Data Capture with ODI</p><p>Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services. Oracle Data Integrator's Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process and transform the data - the approach that optimizes performance, scalability and lowers overall solution costs. Throughout this course participants will explore how to centralize data across databases, performing integration, designing ODI Mappings, and setting up ODI security. In addition, Oracle Data Integrator can interact with the various tools of the Hadoop ecosystem, allowing administrators and data scientists to farm out map-reduce operations from established relational databases to Hadoop. They can also read back into the relational world the results of complex Big Data analysis for further processing. Working in a hands-on learning environment led by our Oracle Certified expert facilitator, students will learn how to:<br />Administer ODI resources and setup security with ODI<br />Apply ODI Topology concepts for data integration<br />Describe ODI Model concepts<br />Describe architecture of Oracle Data Integrator<br />Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations<br />Explore, audit data, and enforce data quality with ODI<br />Implement Changed Data Capture with ODI</p></div><div id="course-pills-2"><h4>Introduction to Integration and Administration</h4><ul><li>Oracle Data Integrator: Introduction</li><li>Oracle Data Integrator Repositories</li></ul><h4>Administering ODI Repositories</h4><ul><li>Create and connect to the Master Repository</li><li>Export and import the Master Repository</li><li>Create, connect, and set a password to the Work Repository</li></ul><h4>ODI Topology Concepts</h4><ul><li>ODI Topology: Overview</li><li>Data Servers and Physical Schemas</li><li>Defining Topology</li><li>Agents in Topology</li><li>Planning a Topology</li></ul><h4>Describing the Physical and Logical Architecture</h4><ul><li>Topology Navigator</li><li>Creating Physical Architecture</li><li>Creating Logical Architecture</li></ul><h4>Setting Up a New ODI Project</h4><ul><li>ODI Projects</li><li>Using Folders</li><li>Understanding Knowledge Modules</li><li>Exporting and Importing Objects</li><li>Using Markers</li></ul><h4>Oracle Data Integrator Model Concepts</h4><ul><li>Understanding the Relational Model</li><li>Understanding Reverse-Engineering</li><li>Creating Models</li></ul><h4>Organizing ODI Models and Creating ODI Datastores</h4><ul><li>Organizing Models</li><li>Creating Datastores</li><li>Constraints in ODI</li><li>Creating Keys and References</li><li>Creating Conditions</li><li>Exploring Your Data</li><li>Constructing Business Rules</li></ul><h4>ODI Mapping Concepts</h4><ul><li>ODI Mappings</li><li>Expressions, Join, Filter, Lookup, Sets, and Others</li><li>Behind the Rules</li><li>Staging Area and Execution Location</li><li>Understanding Knowledge Modules</li><li>Mappings: Overview</li></ul><h4>Designing Mappings</h4><ul><li>Multiple Sources and Joins</li><li>Filtering Data</li><li>Overview of the Flow in ODI Mapping</li><li>Selecting a Staging Area</li><li>Configuring Expressions</li><li>Execution Location</li><li>Selecting a Knowledge Module</li></ul><h4>Mappings: Monitoring and Troubleshooting</h4><ul><li>Monitoring Mappings</li><li>Working with Errors</li></ul><h4>Designing Mappings: Advanced Topics 1</h4><ul><li>Working with Business Rules</li><li>Using Variables</li><li>Datasets and Sets</li><li>Using Sequences</li></ul><h4>Designing Mappings: Advanced Topics 2</h4><ul><li>Partitioning</li><li>Configuring Reusable Mappings</li><li>Using User Functions</li><li>Substitution Methods</li><li>Modifying Knowledge Modules</li></ul><h4>Using ODI Procedures</h4><ul><li>Procedures: Overview</li><li>Creating a Blank Procedure</li><li>Adding Commands</li><li>Adding Options</li><li>Running a Procedure</li></ul><h4>Using ODI Packages</h4><ul><li>Packages: Overview</li><li>Executing a Package</li><li>Review of Package Steps</li><li>Model, Submodel, and Datastore Steps</li><li>Variable Steps</li><li>Controlling the Execution Path</li></ul><h4>Step-by-Step Debugger</h4><ul><li>Starting a Debug Session</li><li>New Functions</li><li>Menu Bar Icons</li></ul><h4>Managing ODI Scenarios</h4><ul><li>Scenarios</li><li>Managing Scenarios</li><li>Preparing for Deployment</li></ul><h4>Using Load Plans</h4><ul><li>What are load plans?</li><li>Load plan editor</li><li>Load plan step sequence</li><li>Defining restart behavior</li></ul><h4>Enforcing Data Quality with ODI</h4><ul><li>Data Quality</li><li>Business Rules for Data Quality</li><li>Enforcing Data Quality with ODI</li></ul><h4>Working with Changed Data Capture</h4><ul><li>CDC with ODI</li><li>CDC implementations with ODI</li><li>CDC implementation techniques</li><li>Journalizing</li><li>Results of CDC</li></ul><h4>Advanced ODI Administration</h4><ul><li>Setting Up ODI Security</li><li>Managing ODI Reports</li><li>ODI Integration with Java</li></ul></div>

Oracle Business Intelligence

IT Manager

Oracle Data Integrator 19c Configuration and Administration (TTOR30319)

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>Oacle Database Administrators<br />System Administrators<br />Developers</p>Overview<p>Understand the concept, benefits, configuration, and usage of the new features and enhancements in database overall area<br />Understand the concept, benefits, configuration, and usage of the new features and enhancements in the security area<br />Understand the concept, benefits, configuration, and usage of the new features and enhancements in the availability area<br />Understand the concept, benefits, configuration, and usage of the new features and enhancements in the performance area<br />Understand the concept, benefits, configuration, and usage of the new features and enhancements in big data and data warehousing area<br />Understand the concept, benefits, configuration, and usage of the new features and enhancements in diagnosability area<br />Understand the concept, benefits, configuration, and usage of the new features and enhancements in sharding area</p><p>The course provides the Oracle Database 19c new features and enhancements related to database overall, security, availability, performance, data warehousing, and diagnosability. In the lessons, you learn the new and enhanced features of Oracle Database 19c amongst different areas such as database overall, security, availability, performance, big data and warehousing, and diagnosability.</p></div><div id="course-pills-2"><h4>Using General Database Overall Enhancements</h4><h4>Using Security Enhancements</h4><h4>Using Availability Enhancements</h4><h4>Using Performance Enhancements</h4><h4>Using Big Data and Data Warehousing Enhancements</h4><h4>Using Diagnosability Enhancements</h4><h4>Sharding Enhancements</h4></div>

Oracle Database 19c: New Features for Administrators

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p></div><div id="course-pills-2"><h4>Exploring Oracle Database Architecture</h4><h4>Oracle Database Management Tools</h4><h4>Managing the Database Instance</h4><h4>Configuring the Oracle Network Environment</h4><h4>Administering User Security</h4><h4>Managing Database Storage Structures</h4><h4>Managing Space</h4><h4>Managing Undo Data</h4><h4>Managing Data Concurrency</h4><h4>Implementing Oracle Database Auditing</h4><h4>Backup and Recovery: Concepts</h4><h4>Backup and Recovery: Configuration</h4><h4>Performing Database Backups</h4><h4>Performing Database Recovery</h4><h4>Moving Data</h4><h4>Database Maintenance</h4><h4>Managing Performance</h4><h4>Managing Performance: SQL Tuning</h4><h4>Using Database Resource Manager</h4><h4>Using Oracle Scheduler to Automate Tasks</h4></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle Database 12c - Administration I Workshop 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 Database 12c - Administration I Workshop 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>

Oracle Database 12c - Administration I Workshop

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is intended for experienced Oracle Database Administrators,<br />System Administrators, and Developers.</p>Overview<p>Upon completion of this course, the student should be able to:<br />Understand the concept, benefits, configuration, and usage of the new features and enhancements in database overall area, security area, availability area, performance area, big data and data warehousing area and enhancements in diagnosability area and in sharding area.</p><p>The course provides the Oracle Database 19c new features and enhancements related to database overall, security, availability, performance, data warehousing, and diagnosability.</p></div><div id="course-pills-2">The course provides the Oracle Database 19c new features and enhancements related to database overall, security, availability, performance, data warehousing, and diagnosability.</div>

Oracle Database 19c - New Features for Administrators

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>Overview<p>Ensure a smooth, rapid implementation of PeopleSoft Time and Labor. Better understand how to facilitate the management, planning, reporting and approving of time, and calendar and schedule creation and usage.<br />Set Up System and Time and Labor Tables<br />Learn about and set up the tables that support your Time and Labor system. Identify how to track employee time by period and define workgroups and task groups to group time reporters into useful segments for processing.<br />Manage Time Reporting<br />Enroll time reporters into Time and Labor, and assign them to work schedules. Report time using different tools. Process reported time using the rules you defined to match your business processes.</p><p>This PeopleSoft Time and Labor - North America Rel. 9.2 training will show you how to implement the PeopleSoft Time and Labor product encompassing features and functionality , and develop a solid foundation of knowledge that allows you to enroll time reporters into Time and Labor, assign them to work schedules, and report and process reported time.</p></div><div id="course-pills-2"><h4>Setting Up PeopleSoft Human Resources, Payroll, and Benefits Tables</h4><ul><li>Indentifying Prerequisite Human Resources, Benefits, and Payroll Tables<br />Defining Prerequisite Tables<br />Defining Holiday Schedules<br />Defining Earnings Codes and Programs<br />Defining Pay Groups and Pay Calendars</li></ul><h4>Setting Up Basic PeopleSoft Time and Labor Tables</h4><ul><li>Setting Up Time Zone Offsets<br />Setting Up the Time and Labor Installation Table<br />Setting Up Manager Time Calendar View Options<br />Selecting the Labor Distriution and Labor Dilution Options</li></ul><h4>Establishing Time Reporting Codes</h4><ul><li>Describing Time Reporting Codes (TRC)<br />Defining Time Reporting Code Categories<br />Establishing Time Reporting Codes<br />Defining TRC Programs<br />Defning Compensatory Time Plans</li></ul><h4>Establishing Time Periods</h4><ul><li>Describing Time Periods<br />Establishing Time Periods</li></ul><h4>Establishing Planned Overtime</h4><ul><li>Describing Planned Overtime Features<br />Establishing Planned Overtime</li></ul><h4>Creating Workgroups</h4><ul><li>Describing Key Workgroup Concepts<br />Creating Workgroups</li></ul><h4>Defining Template Built Rules</h4><ul><li>Identifying Online Rule Definition Tools<br />Identifying Steps to Define Rules<br />Defining Template Built Rules<br />Defining Rule Programs<br />Exporting and Importing Rules<br />Describing Rule Template Creation</li></ul><h4>Creating Task Groups</h4><ul><li>Identifying Task Functinlaity Concepts<br />Creating Task Templates<br />Creating Task Profiles<br />Creating Taskgroups<br />Describing Task Profile Reporting Precedence</li></ul><h4>Building Schedules</h4><ul><li>Identifying Scheduling Concepts<br />Describing Scheduling Integrations<br />Identifying the Steps to Create a Schedule<br />Setting Up Schedules<br />Validating Schedules</li></ul><h4>Setting Up Time Reporters</h4><ul><li>Creating Time Reporter Data<br />Maintaining Time Reporter Data<br />Assigning Time Reporters to a Schedule<br />Assigning and Viewing Compensatory Time Off Plans</li></ul><h4>Setting Up Groups and Security</h4><ul><li>Describing PeopleSoft Time and Labor Groups and Security<br />Setting Up Group Creating Security<br />Setting Up Dynamic Groups<br />Setting Up Static Groups<br />Viewing Time Reporters in Groups<br />Setting Up Group Security</li></ul><h4>Reporting Time Using Rapid Entry</h4><ul><li>Describing Time Reporting<br />Establishing Rapid Time Templates<br />Performing Rapid Entry</li></ul><h4>Running the Time Administration Process</h4><ul><li>Describing the Time Administration Process<br />Describing Time Reporter and Payable Time Status</li></ul><h4>Reporting Time Using Self-Service</h4><ul><li>Identifying Time Reporting<br />Defining Time Reoprting Templates<br />Defining User Preferences<br />Reporting Time Using Timesheets<br />Reporting Time Using the Web Clock<br />Identifying Mass Time Reporting<br />Requesting Overtime<br />Requesting Absence</li></ul><h4>Managing Exceptions</h4><ul><li>Defining Exceptions<br />Managing Exceptions</li></ul><h4>Using Fluid and Workforce Availability</h4><ul><li>Setting Up the Time and Labor Mobile Applications<br />Entering Time Reporting as an Employee<br />Managing Time Administration as a Manager<br />Setting Up Workforce Availability<br />Viewing Workforce Availability for Daily and Weekly Time</li></ul><h4>Integrating with PeopleSoft Payroll for North America</h4><ul><li>Integrating with Absence Management<br />Preparing for a Payrun<br />Running the Time and Labor Load Process</li></ul><h4>Setting Up and Using Auto Enrollment</h4><ul><li>Setting Up Auto Enrollment<br />Defining Auto Enrollment Groups<br />Previewing the Enrollment Data</li></ul><h4>Performing Labor Distribution and Dilution</h4><ul><li>Identifying Labor Distribution and Dilution<br />Sending Costs to Time and Labor<br />Viewing Distributed and Diluted Costs</li></ul><h4>Auditing and Adjusting Payable Time</h4><ul><li>Identifying the Stages of Payable Time<br />Adjusting Paid Time<br />Viewing Unprocessed Reported Time<br />Viewing Unprocessed PayableTime<br />Locking Timesheets</li></ul><h4>Performing Labor Distribution and Dilution</h4><ul><li>Identifying Labor Distribution and Dilution<br />Sending Costs to Time and Labor<br />Viewing Distributed and Diluted Costs</li></ul><h4>Auditing and Adjusting Payable Time</h4><ul><li>Identifying the Stages of Payable Time<br />Adjusting Paid Time<br />Viewing Unprocessed Reported Time<br />Viewing Unprocessed PayableTime<br />Locking Timesheets</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle PeopleSoft Time and Labor - North America Rel. 9.2 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 Time and Labor - North America Rel. 9.2 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>

SAP Human Capital Management

IMS Productivity Analyst

Payroll

Employee Management

Human Resources Management

Oracle PeopleSoft Time and Labor - North America Rel. 9.2

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Implementer</p>Overview<p>Enrolling in this course will help you better understand and leverage PeopleSoft Payroll for North America (USA) payroll requirements and processes. This knowledge will help you create, adjust and troubleshoot your organization's employee payroll.<br />Learn Off-Cycle Payroll Events<br />In addition to typical on-cycle payroll processing, Payroll for North America provides functionality for a variety of off-cycle payroll events and other payroll requirements. This course will illustrate how to reverse a paycheck, record a manual check, produce online checks and final checks and create a gross up check. In addition, you'll also learn the necessary steps to set up and process mid-period job changes and multiple jobs. Finally, you'll set up and processes benefit deductions and garnishments.</p><p>This PeopleSoft Payroll - US Rel 9.2 training teaches you how to set up and maintain employee tax data, additional pay, general deductions and direct deposits. Expert Oracle University instructors will show you how to use this solution to calculate payroll, review calculation results, identify and correct errors, confirm payroll and more.</p></div><div id="course-pills-2"><h4>Setting Up PeopleSoft HRMS Tables for Payroll Processing</h4><ul><li>Identifying HRMS Tables That Impact Payroll Processing<br />Describing Installation Table Setup for PeopleSoft Enterprise Payroll for North America<br />Describing the Role of SetID, Location, and Department in Payroll Processing<br />Describing Company Table Setup<br />Desc</li></ul><h4>Setting Up Payroll Tables</h4><ul><li>Identifying Payroll Setup Tables<br />Setting Up Source Bank Accounts<br />Creating Special Accumulators<br />Setting Up Earnings Codes<br />Setting Up Earnings Programs<br />Describing Shift Pay Setup<br />Creating a Pay Group<br />Creating a Rate Code</li></ul><h4>Setting Up U.S. Payroll Tax Tables</h4><ul><li>Identifying Tax Table Maintenance Responsibility<br />Describing PeopleSoft-Maintained Tax Tables<br />Setting Up Customer-Maintained Tax Tables</li></ul><h4>Setting Up Employee Data</h4><ul><li>Identifying Sources of Employee Data<br />Setting Up an Employee Instance<br />Entering and Viewing Employee Job Data<br />Identifying Employee Pay Data<br />Updating Employee Tax Data<br />Assigning Additional Pay to Employees<br />Assigning General Deductions to Employees<br />Updating P</li></ul><h4>Creating and Updating Paysheets</h4><ul><li>Describing Paysheets in Payroll for North America<br />Describing Balance ID Creation<br />Creating Pay Calendars<br />Setting Up Pay Run IDs<br />Creating Paysheets<br />Viewing and Updating Paysheets and Paylines<br />Describing the Payroll Unsheet Process</li></ul><h4>Calculating Payroll</h4><ul><li>Describing Payroll Calculation<br />Running Preliminary Payroll Calculation<br />Running Final Payroll Calculation</li></ul><h4>Confirming Payroll and Producing Checks and Reports</h4><ul><li>Confirming a Payroll<br />Viewing Confirmed Payroll Results Online<br />Printing Checks and Advices<br />Describing Check Reprinting<br />Describing Direct Deposit Transmittals and Reports<br />Describing Payroll and Tax Reports<br />Identifying Methods of Reversing Payroll Confirmati</li></ul><h4>Processing Off-Cycle Payrolls</h4><ul><li>Identifying Off-Cycle Payroll Processing<br />Reversing a Paycheck<br />Describing Reversal/Adjustment Processing<br />Recording a Manual Check<br />Producing an Online Check<br />Describing Retroactive Processing</li></ul><h4>Setting Up and Processing Additional Payroll Functionality</h4><ul><li>Setting Up a Holiday Schedule<br />Setting Up Advanced Earnings Options<br />Setting Up Multiple Jobs Processing<br />Setting Up and Processing Mid-period Job Changes<br />Processing Gross Ups</li></ul><h4>Setting Up and Processing Benefit Deductions in Payroll</h4><ul><li>Setting Up Deductions and Earnings for Benefits Calculations<br />Updating a Benefit Program and Enrolling Employees<br />Analyzing Benefits-Related Payroll Reports</li></ul><h4>Setting Up and Processing Garnishments</h4><ul><li>Identifying Garnishment Setup Steps<br />Describing PeopleSoft-Maintained Garnishment Tables<br />Setting Up Company-Level Tables for Garnishment Processing<br />Assigning an Employee Garnishment Deduction<br />Setting Up Employee Garnishment Specification Data<br />Reviewing Emp</li></ul><h4>Describing PeopleSoft Enterprise ePay</h4><ul><li>Identifying HRMS Tables That Impact Payroll Processing<br />Describing Installation Table Setup for PeopleSoft Enterprise Payroll for North America<br />Describing the Role of SetID, Location, and Department in Payroll Processing<br />Describing Company Table Setup<br />Desc</li></ul></div>

Certified Payroll Professional (CPP)

Professional payroll & pensions qualifications (CIPP)

Sage Payroll

Oracle PeopleSoft Payroll - US Rel 9.2

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

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 Database 12c R2 - Backup and Recovery Workshop Ed 3

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>Architect<br />Database Administrators</p>Overview<p>Configure and use Policy-Based Cluster Management in conjunction with Policy-Managed Database and Oracle<br />Multitenant Architecture<br />Migrate from a standard cluster to a Flex Cluster and configure highly available application resources on Flex Cluster<br />Leaf Nodes<br />Implement Oracle Database In-Memory on an existing Oracle RAC database<br />Configure an Oracle RAC database to use Application Continuity<br />Configure and use Global Data Services in conjunction with Oracle RAC and Data Guard<br />Upgrade an existing database to use Oracle ASM Filter Driver<br />Migrate from standard ASM to Flex ASM and examine the effect of using Flex ASM<br />Perform a database rolling upgrade, from Oracle Database 11gR2 to Oracle Database 12c, using a transient logical standby database</p><p>Practice configuring, administering and using noteworthy features associated with Oracle Database 12c RAC and Grid Infrastructure.</p></div><div id="course-pills-2">Practice configuring, administering and using noteworthy features associated with Oracle Database 12c RAC and Grid Infrastructure.</div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle Database 12c - RAC and Grid Infra Deployment Workshop 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 Database 12c - RAC and Grid Infra Deployment Workshop 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>

Oracle Database 12c - RAC and Grid Infra Deployment Workshop

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>AdministratorDatabase Administrators</p>Overview<p>Describe the components of ASMExplain and apply Automatic Storage Management (ASM) initialization parametersManage ASM instances and associated processesMonitor ASM using the V$ASM dynamic performance viewsUnderstand Flex ASM architecture and componentsUnderstand ASM Deployment AlternativesInstall and configure Flex ASMManage Flex ASMEmploy ASM space management techniquesCreate and delete Automatic Storage Management (ASM) disk groupsSet the attributes of an existing ASM disk groupPerform ongoing maintenance tasks on ASM disk groupsExplain key performance and scalability considerations for ASM disk groupsDescribe the Automatic Storage Management (ASM) architectureUse different client tools to access ASM filesDescribe the format of a fully qualified ASM file name</p><p>This Oracle Database 12c: ASM Administration training teaches you about Oracle ASM architecture. Expert Oracle University instructors will help you develop a deeper understanding of both standard ASM and Flex ASM applications.</p></div><div id="course-pills-2">This Oracle Database 12c: ASM Administration training teaches you about Oracle ASM architecture. Expert Oracle University instructors will help you develop a deeper understanding of both standard ASM and Flex ASM applications.</div>

Oracle Database 12c - ASM Administration Ed 1

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

Learning & Development

Online Course Creation

Professional Skills Course (PSC)

Oracle Peoplesoft PeopleTools I

<div>
					<div>
								<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
							</div>
				</div>
			<p><span>This </span><b>Oracle 11g PL/SQL Part 2</b><span> course will be very advantageous for you to learn about developing database server-side PL/SQL program units within an Oracle database. This course covers a variety of topics which include understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. In addition to that, you'll take the support of advanced programming techniques such as cursor variables and cursor expressions, which broadly discussed in the course. This course is ideal to prepare yourself for the Oracle certification exams (OCP).</span></p>
<p><span>Upon successful completion of this course, you'll stand out from your competition while you're chasing your dream job!</span></p>
<h3><strong>What Will I Learn?</strong></h3>
<ul>
<li><span>Prepare your environment</span></li>
<li>Introducing Database Program Units</li>
<li>Creating and Maintaining Stored Procedures &amp; Functions</li>
<li><span>Creating and Maintaining Packages</span></li>
<li><span>Advanced Cursor Techniques</span></li>
<li><span>Using System-Supplied Packages</span></li>
<li><span>Creating and Maintaining Database Triggers</span></li>
<li><span>Implementing System Event Triggers</span></li>
</ul>
<h3><strong>Requirements</strong></h3>
<div>
<ul>
<li>Familiarity with database and programming principles</li>
</ul>
<h3><strong>Who is the target audience?</strong></h3>
<ul>
<li>Application designers and developers</li>
<li>Database administrators</li>
<li>Business users and non-technical senior end users</li>
</ul>
</div><table>				<tbody><tr>
					<td colspan="4"> Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Install Oracle XE</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL Developer Installation</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Workstation Setup</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Database Program Units</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introducing the Database Program Unit</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with Stored Procedures and Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Stored Procedures and Functions</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding the Parameter Specification</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Executing Procedures and Functions</td>
					<td> </td>
					<td><span><i></i> 00:26:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Calling Functions from within SQL</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Handling Compilation Errors</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Maintaining Stored Procedures and Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Recompiling and Dropping Programs</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Dictionary Storage</td>
					<td> </td>
					<td><span><i></i> 00:25:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Managing Dependencies</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Tracking Dependencies</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Dependency Tracking Utility</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Creating and Maintaining Packages</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Is a Package?</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating a Package</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Package Definition Information</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Advanced Programming Techniques</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Persistent Global Objects</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Including Initialization Logic</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Object Oriented Support within Packages</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Package Maintenance</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Advanced Cursor Techniques</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Learning to Use Cursor Variables</td>
					<td> </td>
					<td><span><i></i> 00:24:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Advanced Cursor Techniques Weak Cursor Definitions</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>REFCURSOR Cursor Definition</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Cursor Expression</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Using System Supplied Packages</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the DBMS OUTPUT() Package</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the UTL FILE() Package</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Creating Database Triggers</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding the Database Trigger</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Statement-Level Triggers</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Row-Level Triggers</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Row Level Trigger Example 1</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Row Level Trigger Example 2</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Row Level Trigger Example 3</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with the INSTEAD OF Trigger</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Triggers within an Application</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Trigger Maintenance</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the CALL Statement</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Trigger Maintenance Tasks</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Multiple Triggers for a Single Table</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Handling Mutating Table Issues</td>
					<td> </td>
					<td><span><i></i> 00:22:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Compound Trigger</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with System Event Triggers</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Is a System Event Trigger</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Defining Scope</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Identifying Available System Events</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Conclusion</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Conclusion</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Course Certification</td>
				</tr>
				</tbody></table>

iStudy UK

Database Programming

Oracle 11g PL/SQL Part 2

General Admission

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Technical Administrator<br />Java EE Developer<br />System Administrator</p>Overview<p>Configure WebLogic Server's authentication provider<br />Deploy applications to WebLogic Server<br />Backup and restore a WebLogic Server domain<br />Create a WebLogic Server domain<br />Configure and monitor WebLogic Server<br />Configure WebLogic Server database resources<br />Create and configure a WebLogic Server cluster<br />Install WebLogic Server 12c</p><p>This Oracle WebLogic Server 12c: Administration I training teaches administrators to install and configure Oracle WebLogic Server 12c. It gives administrators an overview of the basic concepts and architecture of WebLogic Server.</p></div><div id="course-pills-2">This Oracle WebLogic Server 12c: Administration I training teaches administrators to install and configure Oracle WebLogic Server 12c. It gives administrators an overview of the basic concepts and architecture of WebLogic Server.</div>

24 Oracle Fusion HCM courses delivered Online

Oracle 19c New Features (TTOR20019)

By Nexus Human

Oracle Database 12c - Administration Workshop

By Nexus Human

Oracle 19c Database Backup and Recovery (TTOR21619)

By Nexus Human

Oracle Database: Backup and Recovery Workshop

By Nexus Human

Oracle Database 12c - RAC Administration

By Nexus Human

Oracle Database 12c - Backup and Recovery Workshop

By Nexus Human

Oracle Data Integrator 19c Configuration and Administration (TTOR30319)

By Nexus Human

Oracle Database 19c: New Features for Administrators

By Nexus Human

Oracle Database 12c - Administration I Workshop

By Nexus Human

Oracle Database 19c - New Features for Administrators

By Nexus Human