402 Maintenance courses in Cardiff delivered Live Online

Duration 5 Days 30 CPD hours Overview SDWAN Overview Cisco SDWAN Hardware Deploying the Overlay Configuring vManage Deploying using Templates Creating Policies Monitoring vManage vAnalytics Troubleshooting Tools for VManage In this Implementation and Configuration SDWAN Course, students will deploy and configure SD-WAN Controllers, vEdge Devices, and Cisco IOS-XE Devices. Students will create Multiple Device and CLI Templates that will allow Hundreds of devices to be deployed using only a few Centralized Templates. Students will create Security Policies to enable the Enterprise Firewall, IDS/IPS, URL Filtering, and Web Layer Security to protect and allow Enterprises to deploy Cloud applications as well as Direct Internet Access (DIA). Students will also create Local and Central Policies that enable a Centralized Policy control of WAN Routing and device QOS configuration and enforcement. Students will also learn how Cisco SD-WAN allows Enterprises to deploy an effective Cloud Solutions such as Amazon AWS, Microsoft Azure, and Google Cloud. Students will also learn how to Monitor and Troubleshoot the SD-WAN Solution. SDWAN Overview Describe what a Software-Defined Wide Area Network (SD-WAN) is Describe the secure extensible network Describe the function of the virtual IP fabric created in the SD-WAN solution What is SDWAN Cisco Cloud vs On-premises vs private cloud management Cisco IWAN vs Viptela SDWAN IWAN Migration to SDWAN SDWAN Integration with Cisco Cisco SDWAN Licensing Deploying Cisco SDWAN Controllers On-Prem vs Cloud deployment vManage NMS vBond Orchestrator Deploy the vSmart Controller Controller High Availability Cluster Management Cisco SDWAN Certificates and Whitelists On-Prem vs Cloud Certificate deployment Controller Certificates Hardware Device Certificates Software Device Certificates Certificates Device Whitelists Controller Whitelists Cisco SDWAN Edge Devices vEdge Appliances vEdge Cloud Cisco IOS-XE Platforms Cisco CSR 1000V Router Cisco 54xx Enterprise Network Compute System (ENCS) Cisco SDWAN Fabric and Overview Virtual Fabric Overview Overlay Management Protocol Transport Locators (TLOCs) Multicast TCP Optimization Opening Firewall Ports Software Installation and Upgrade vEdge Routers Deploying vEdge Routers Migrating IOS-XE Devices to Cisco SD-WAN Zero Touch Provisioning Deploy AWS Gateway using the AWS Wizard Cisco SD-WAN Security Solution Security SDWAN IOS-XE Security SDWAN vEdge Security Firewall Ports Control Plane Security Data Plane Security Traffic Segmentation Service Chaining Cloud Security Enterprise Firewall Quality of Service Application Visibility and Recognition Differentiated Services-Quality of Service Critical Applications SLA Path MTU Discovery TCP Performance Optimization Bidirectional Forwarding Detection (BFD) vEdge Router Queuing Configuring vManage Using the vManage Interface Using the vManage Dashboard Administration Configuration SD-WAN Templates Templates Wide Area Application Server (WAAS) Maintenance Configure Cisco Umbrella Quality of Service (QoS) SD-WAN Policies Local Policies vs Central Policies Policies Smart policies (Control, Data, AppRoute, cflowd) SD-WAN Cloud OnRamp SAAS Cloud OnRamp IAAS vAnalytics Applications Network Availability Network Health vAnalytics Dashboard Monitoring vManage Network ACL Log Alarms Audit Log Events Geography View Device Information View Link Information Configure Geographic Coordinates for a Device Troubleshooting Tools for vManage Using vManage to Troubleshoot the environment Operational Commands Rediscover Network CLI Command to troubleshoot the environment. SSH Terminal Additional course details: Nexus Humans ICSDWAN-CT-Implementing, Configuring, Monitoring, and Troubleshooting Cisco (Viptela)SDWAN training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the ICSDWAN-CT-Implementing, Configuring, Monitoring, and Troubleshooting Cisco (Viptela)SDWAN 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. 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.

Duration 4 Days 24 CPD hours This course is intended for Experienced system administrators, system engineers, and system integrators Overview By the end of the course, you should be able to meet the following objectives:Describe the architecture of VMware Cloud on AWS, Deploy a VMware Cloud on AWS SDDC and virtual machines (VMs),Configure internal, external, and inter-SDDC networking, Describe and configure storage integrations and solutions for VMware Cloud on AWS,Configure a connection between an on-premises vSphere SDDC and a VMware Cloud on AWS SDDC,Configure the scale-up and scale-down of a VMware Cloud on AWS SDDC,Migrate virtual machines between on-premises vSphere and VMware Cloud on AWS SDDCs,Describe and configure disaster recovery solutions,Describe additional services that add value to a VMware Cloud on AWS SDDC,Describe lifecycle, troubleshooting scenarios, and support resources for a VMware Cloud on AWS SDDC This four-day, hands-on training course provides you with the knowledge, skills, and tools for deploying and managing a VMware Cloud? on AWS infrastructure. You explore the common use cases of the VMware Cloud on AWS infrastructure that allows you to modernize, protect, and scale applications based on VMware vSphere© that leverage AWS.In this course, you are introduced to various rapid and easy migration options for workloads based on vSphere to VMware Cloud on AWS. In addition, you are presented with VMware Cloud Disaster Recovery?, which is a Disaster Recovery as-a-service (DRaaS) solution, with fast recovery capabilities, that can be used to cost-effectively protect a broad set of your virtualized applications. Course Introduction Introductions and course logistics Course objectives Introduction to VMware Cloud on AWS Why choose VMware Cloud on AWS Management and operational structure VMware Cloud on AWS Platform and SDDC Deployment Preparation Getting started with VMware Cloud on AWS Preparing AWS infrastructure for a VMware Cloud on AWS deployment Setting up a VMware on Cloud AWS account Billing and pricing on VMware Cloud services Deploying and Scaling and SDDC Deploying and examining SDDC configurations Sizing the SDDC SDDC cluster management SDDC host management Optimizing and maintaining an SDDC cluster using Elastic DRS for VMware Cloud? on AWS Accessing and Analyzing vCenter Configurations Accessing vCenter Server in the Cloud SDDC from the public internet Creating virtual machines in the Cloud SDDC Analyzing HA, DRS, and resource pools settings in the SDDC Analyzing vSphere permissions Networking in VMware Cloud on AWS Internal SDDC network Networking and security options Inter-SDDC networking Storage on VMware Cloud on AWS vSAN storage in VMware Cloud on AWS Attaching external storage to a VM running on an SDDC Working with On-Premises vSphere Hybrid linked mode VMware Cloud on AWS migration solutions Virtual machine migration with VMware Hybrid Cloud Extension Maintaining and Troubleshooting VMware Cloud on AWS Accessing API with VMware Cloud on AWS Maintenance and support Common troubleshooting steps Disaster Recovery Solution Site Recovery add-on service VMware Cloud Disaster Recovery Using Other VMware Products with the SDDC VMware vRealize© Log Insight Cloud? VMware Horizon© with VMware Cloud on AWS VMware vRealize© Automation Cloud? add-on Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware Cloud on AWS: Deploy, Configure, Manage 2021 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the VMware Cloud on AWS: Deploy, Configure, Manage 2021 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. 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.

Duration 5 Days 30 CPD hours This course is intended for Operators, administrators, and architects for VMware Horizon should enroll in this course. These individuals are responsible for the creation, maintenance, and or delivery of remote and virtual desktop services. Additional duties can include the implementation, support, and administration of an organization's end-user computing infrastructure. Overview By the end of the course, you should be able to meet the following objectives: Assess the business and application requirements of an environment Analyze design choices and design an EUC infrastructure architecture that addresses the needs of the environment Design an EUC architecture that addresses the needs of the organization and follows VMware best practices Document a design that can be implemented Design a comprehensive VMware EUC solution This five-day course presents a methodology for designing a VMware end-user computing (EUC) solution. The design methodology includes recommendations for the types of information and data that must be gathered and analyzed to make sound design decisions for the client systems, the desktop options, the VMware vSphere© infrastructure, VMware Horizon©, VMware Horizon© Cloud ServiceTM, VMware Workspace ONE© UEM, VMware Workspace ONE© AccessTM, VMware NSX-TTM, and VMware Unified Access GatewayTM. VMware best practices are presented for each phase of the design process. In this course, you apply your new knowledge by working with other participants to design a VMware EUC solution for a real-world project. Course Introduction Introductions and course logistics Course objectives VMWare EUC Design Methodology Recognize the characteristics of a good design. Identify the phases of VMware EUC Design Methodology Presenting Solutions to Executive Management Identify behaviors that can affect team performance negatively List common mistakes when working in a team Describe how to tailor a presentation to the company?s values, and stakeholders? backgrounds and roles List questions you should ask to identify how to address a problem a client is trying to solve Infrastructure Assessment and Services Definition Define customer business objective Define a use case for your virtual desktop and application infrastructure Convert customer requirements to use-case attributes Horizon Architecture and Components Determine the components required for a Horizon on-premises or Horizon Cloud deployment Implement the design considerations and recommendations for various Horizon components Analyze the use-case scenarios for various the Horizon deployment options Component Design: Horizon Pods Design a single-site Horizon desktop block and pod configuration for a given use case Design Cloud Pod Architecture for multisite pool access Design Control Plane Services Architecture for multisite pool access Component Design: App Volumes and Dynamic Environment Manager Identify the functionalities of the components in App Volumes Logical Architecture Implement the recommended practices when designing an application delivery mechanism using App Volumes Component Design: Workspace ONE Map the Horizon desktop building block and the Horizon management building block to VMware vSphere. Identify factors and design decisions that determine the sizing for ESXi hosts Workspace ONE & Horizon Infrastructure Design Design the environment resources required to support a Workspace ONE and Horizon deployment Identify factors and design decisions that determine the sizing for ESXi host Discuss the factors that determine the sizing for shared storage Identify the design decisions related to bandwidth utilization Discuss the implications of using load balancing and traffic management Identify factors and design decisions that determine the sizing of the Azure pods Design Integration and Delivery List the platform components that needs to be integrated along with their dependent services. Integrate Workspace ONE and Horizon platform components. Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware End User Computing: Design training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the VMware End User Computing: Design 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. 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.

Working at Height Course Overview This course on Working at Height provides essential knowledge and skills required to work safely at elevated locations. It covers key regulations, risk assessments, and safety procedures to prevent accidents and injuries. Learners will gain a comprehensive understanding of the hazards involved in working at height, the appropriate equipment, and the essential safety measures to ensure a safe working environment. This course is ideal for individuals looking to enhance their awareness of safety protocols and improve their competency in height-related tasks. By completing this course, learners will be better equipped to identify and manage risks associated with working at height, ensuring safety and compliance in the workplace. Course Description The Working at Height course delves into essential topics such as the legal requirements for working at height, risk assessment procedures, and the use of personal protective equipment (PPE). Learners will explore the principles of fall protection, the importance of safe equipment usage, and the necessary precautions to mitigate risks when working at elevated locations. Throughout the course, learners will be encouraged to develop a solid understanding of how to assess risks and implement safety strategies effectively. By the end of the course, learners will have gained the skills needed to create a safer working environment, ensuring compliance with regulations and enhancing safety standards within their workplace. Working at Height Curriculum Module 01: Working at Height (See full curriculum) Who is this course for? Individuals seeking to understand the risks of working at height Professionals aiming to improve their safety knowledge Beginners with an interest in construction, maintenance, or related industries Employees working in environments where working at height is a common requirement Career Path Site Supervisor Construction Worker Maintenance Technician Scaffold Installer Health and Safety Officer

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is Enterprise Desktop Support Technicians (EDSTs). These technicians provide Tier 2 support to users with domain-joined computers running the Windows 11 OS, typically in medium to large enterprise organizations. Overview Important Windows 11 features How these features are used in an Active Directory How to troubleshoot these features This is a 5-day ILT course that is designed to provide you with the knowledge and skills required to support and troubleshoot Windows 11 PCs and devices in an on-premises Windows Server Active Directory domain environment. 1: Introducing Windows 11 Overview of Windows 11 Recommendations for typical troubleshooting procedures Troubleshooting installation and deployment Introduction to management and troubleshooting tools 2: Administering Windows 11 remotely Using Windows Admin Center Using Windows PowerShell Implementing Remote Management 3: Troubleshooting startup and performing system recovery Recovering Windows 11 Configuring the Registry Troubleshooting Windows 11 startup Implementing and troubleshooting BitLocker Troubleshooting OS service Issues 4: Troubleshooting devices and device drivers Overview of hardware troubleshooting Troubleshooting device drivers 5: Configuring and troubleshooting network connectivity Configuring network connectivity Troubleshooting network connectivity Implementing and troubleshooting name resolution Implementing and troubleshooting remote access 6: Troubleshooting Group Policy Overview of Group Policy Resolve GPO application issues on client devices 7: Configuring and Troubleshooting Security Settings Implementing network security Implementing Windows 11 security features Configuring and troubleshooting user accounts 8: Configuring and Troubleshooting User State Implementing and troubleshooting user state Implementing and troubleshooting Folder Redirection 9: Configuring and Troubleshooting Resource Access Configuring and troubleshooting file access. Configuring and troubleshooting shared folders. Implementing and troubleshooting Work Folders. Managing and troubleshooting printers. Recovering files. 10: Troubleshooting apps Troubleshooting desktop apps Troubleshooting app compatibility Managing UWP apps 11: Monitoring and Maintaining Windows 11 Monitoring Windows 11 Optimizing Windows 11 performance Managing Windows 11 updates

Duration 4 Days 24 CPD hours This course is intended for Experienced system administrators, system engineers, and system integrators Overview By the end of the course, you should be able to meet the following objectives: Describe the architecture of VMware Cloud on AWS Prepare and deploy VMware Cloud on AWS SDDC Configure the scale-up and scale-down of a VMware Cloud on AWS SDDC Access a VMware vCenter configuration in VMware Cloud on AWS Configure internal, external, and inter-SDDC networking Configure storage integrations and solutions for VMware Cloud on AWS Configure a connection between an on-premises vSphere SDDC and a VMware Cloud on AWS SDDC Migrate VMs between on-premises vSphere and VMware Cloud on AWS SDDCs Describe lifecycle management, troubleshooting scenarios, and disaster recovery solutions for a VMware Cloud on AWS SDDC Describe how VMware add-on solutions support a VMware Cloud on AWS SDDC This four-day, hands-on training course provides you with the knowledge, skills, and tools for deploying and managing a VMware Cloud? on AWS infrastructure. You will explore the common use cases of the VMware Cloud on AWS infrastructure that allows you to modernize, protect, and scale applications based on VMware vSphere© that leverage AWS.In this course, you are introduced to various rapid and easy migration options for workloads based on vSphere to VMware Cloud on AWS. In addition, you are presented with VMware Cloud Disaster Recovery?, which is a Disaster Recovery as-a-service (DRaaS) solution, with fast recovery capabilities, that can be used to cost-effectively protect a broad set of your virtualized applications. Course Introduction Introductions and course logistics Course objectives Introduction to VMware Cloud on AWS Choosing VMware Cloud on AWS Management and operational structure VMware Cloud on AWS Platform and SDDC Deployment Preparation Getting started with VMware Cloud on AWS Preparing AWS infrastructure for a VMware Cloud on AWS deployment Setting up a VMware on Cloud AWS account Billing and pricing on VMware Cloud services Deploying and Scaling and SDDC Deploying and examining SDDC configurations Sizing the SDDC SDDC cluster management SDDC host management Optimizing and maintaining SDDC Cluster using Elastic DRS for VMware Cloud on AWS Accessing and Analyzing vCenter Configurations Accessing vCenter Server in the Cloud SDDC Analyzing resource management settings in the SDDC Exploring vSphere permissions on VMware Cloud on AWS VMware Tanzu? for VMC on AWS Networking in VMware Cloud on AWS Internal SDDC network Networking and security options SDDC Network Administration with NSX Manager Creating virtual machines in the Cloud SDDC Inter-SDDC networking Storage on VMware Cloud on AWS vSAN storage in VMware Cloud on AWS Attaching external storage to a VM running on an SDDC Working with On-Premises vSphere Hybrid-linked mode Migration solutions for VMware Cloud on AWS VM migration with VMware HCX© Maintaining and Troubleshooting VMware Cloud on AWS Accessing API with VMware Cloud on AWS Maintenance and support Common troubleshooting steps Disaster Recovery Solution Site Recovery add-on service VMware Cloud Disaster Recovery? Using Other VMware Products with the SDDC VMware Aria? Operations for Logs (formerly vRealize Log Insight) VMware Horizon© with VMware Cloud on AWS VMware Aria Automation add-on (formerly vRealize Automation) Using VMware Aria Operations with VMware Cloud on AWS Using VMware Aria Operations for Networks (formerly vRealize Network Insight) with VMware Cloud on AWS Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware Cloud on AWS: Design, Configure, Manage 2023 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the VMware Cloud on AWS: Design, Configure, Manage 2023 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. 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.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for individuals who are Application designers and database developers, database administrators and web server administrators. Overview Upon successful completion of this course, students will be able to work with Oracle database programming using the PL/SQL programming language. They will learn the syntax, structure and features of the language. In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c. Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Choosing a Database Programming Language What is Database Programming? PL?SQL Performance Advantages Integration wth Other Languages PL/SQL Language Fundamentals PL/SQL Program Structure LANGUAGE SYNTAX RULES EMBEDDING SQL WRITING READABLE CODE GENERATING DATABASE OUTPUT SQL*PLUS INPUT OF A PROGRAM BLOCK Declare Section About the Declare Section DECLARE PRIMITIVE TYPES DECLARATION OPTIONS NOT NULL CONSTANT DATA DICTIONARY INTEGRATION %TYPE DECLARE SIMPLE USER---DEFINED TYPES TYPE... TABLE TYPE... RECORD EXTENDED USER---DEFINED TYPES Begin Section About the Begin Section Manipulating Program Data Logic Control & Branching GOTO LOOP IF-THEN-ELSE CASE Exception Section ABOUT THE EXCEPTION SECTION ISOLATING THE SPECIFIC EXCEPTION PRAGMA EXCEPTION_INIT SQLCODE &SQLERRM Example SQL%ROWCOUNT &SELECT...INTO Beyond the Basics: Explicit Cursors ABOUT EXPLICIT CURSORS EXTENDED CURSOR TECHNIQUES FOR UPDATE OF Clause WHERE CURRENT OF Clause Using FOR?LOOP Cursors Beyond the Basics: Nested BlocksBeyond the Basics: Declared Subprograms USING DECLARED SUBPROGRAMS DECLARED PROCEDURE DECLARED FUNCTION Introducing Databse-Resident Program Units ABOUT DATABASE---RESIDENT PROGRAMS PHYSICAL STORAGE & EXECUTION TYPES OF STORED PROGRAM UNITS STORED PROGRAM UNIT ADVANTAGES MODULAR DESIGN PRINCIPLES Creating Stored Procedures & Functions STORED PROCEDURES & FUNCTIONS CREATE PROCEDURE / CREATE FUNCTION CREATING PROCEDURES & FUNCTIONS RAISE_SALARY() Procedure SALARY_VALID() Function THE PARAMETER SPECIFICATION DEFAULT Clause SYSTEM & OBJECT PRIVILEGES USING THE DEVELOPMENT TOOLS Executing Stored Procedures & Functions CALLING PROCEDURES & FUNCTIONS UNIT TESTING WITH EXECUTE ANONYMOUS BLOCK UNIT TESTING SPECIFYING A PARAMETER NOTATION SQL WORKSHEET UNIT TESTING CALLING FUNCTIONS FROM SQL Maintaining Stored Program Units RECOMPILING PROGRAMS Mass Recompilation Using UTL_RECOMP() DROPPING PROCEDURES & FUNCTIONS DROP PROCEDURE / FUNCTION DATA DICTIONARY METADATA Using USER_OBJECTS Using USER_SOURCE Using USER_ERRORS Using USER_OBJECT_SIZE Using USER_DEPENDENCIES Managing Dependencies DEPENDENCY INTERNALS TRACKING DEPENDENCIES THE DEPENDENCY TRACKING UTILITY SQL DEVELOPER DEPENDENCY INFO DEPENDENCY STRATEGY CHECKLISTS Creating & Maintaining Packages ABOUT PACKAGES CREATING PACKAGES MAINTAINING PACKAGES PERFORMANCE CONSIDERATIONS Advanced Package Capabilities DEFINER & INVOKER RIGHTS WHITE LITS & ACCESSIBLE BY PERSISTENT GLOBAL OBJECTS DEFINING INITIALIZATION LOGIC OBJECT ORIENTATION SUPPORT Advanced Cursor Techniques USING CUSROS VARIABLES USING SYS_REFCURSOR USING CURSOR EXPRESSIONS Using System-Supplied Package DBMS_OUTPUT() UTL_FILE() FOPEN() EXAMPLE Database Trigger Concepts ABOUT DATABASE TRIGGERS DML EVENT TRIGGER SUB---TYPES DATABASE TRIGGER SCENARIO TRIGGER EXECUTION MECHANISMS TRIGGERS WITHIN SQL WORKSHEET Creating Database Triggers STATEMENT-LEVEL TRIGGERS Using RAISE_APPLICATION_ERROR() ROW---LEVEL TRIGGERS EXAMPLES OF TRIGGERS EMPLOYEE_SALARY_CHECK Example EMPLOYEE_JOURNAL Example BUDGET_EVENT Example INSTEAD OF TRIGGERS TRIGGERS WITHIN AN APPLICATION Maintaining Database Triggers CALL SYNTAX TRIGGER MAINTENANCE TASKS SHOW ERRORS TRIGGER DROP TRIGGER ALTER TRIGGER MULTIPLE TRIGGERS FOR A TABLE HANDLING MUTATING TABLE ISSUES Implementing System Event Triggers WHAT ARE SYSTEM EVENT TRIGGERS? DEFININGTHE SCOPE AVAILABLE SYSTEM EVENTS SYSTEM EVENT ATTRIBUTES Additional course details: Nexus Humans Oracle 12c PL/SQL Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the Oracle 12c PL/SQL Fundamentals 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. 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.

Hotel Cleaner Course Overview: This Hotel Cleaner course is designed to equip learners with the knowledge and skills needed to excel in the hospitality cleaning industry. Covering a broad range of topics, it includes essential cleaning techniques, health and safety practices, and customer service skills tailored for hotel environments. Learners will gain an understanding of the importance of cleanliness and organisation in guest satisfaction. Upon completing the course, learners will be able to confidently perform cleaning duties in various hotel areas, ensuring a safe and welcoming environment for guests. Course Description: The Hotel Cleaner course delves into a variety of topics crucial to maintaining cleanliness and hygiene in hotels. Learners will explore techniques for cleaning guest rooms, public spaces, and facilities while adhering to industry standards. Topics include understanding cleaning equipment, handling chemicals safely, time management, and effective communication with hotel staff and guests. Learners will gain knowledge of the importance of attention to detail, a strong work ethic, and maintaining high cleanliness standards to enhance the guest experience. The course offers a comprehensive overview of the expectations and requirements within the hotel cleaning industry, preparing learners for roles in this sector. Hotel Cleaner Curriculum: Module 01: Introduction to Hotel Cleaning Module 02: Cleaning Techniques for Guest Rooms Module 03: Cleaning Public Spaces and Facilities Module 04: Health and Safety in Hotel Cleaning Module 05: Chemical Handling and Equipment Use Module 06: Time Management and Efficiency Module 07: Customer Service and Communication in Hotel Cleaning Module 08: Maintaining Cleanliness Standards and Best Practices (See full curriculum) Who is this course for? Individuals seeking to work in the hotel cleaning industry. Professionals aiming to improve cleaning and organisational skills. Beginners with an interest in hospitality services. Those looking to develop a career in hotel management or facilities maintenance. Career Path: Hotel Cleaner Housekeeping Assistant Facilities Maintenance Worker Hotel Housekeeping Supervisor Hospitality Industry Cleaner

Driver Safety Awareness Certificate Course Overview The Driver Safety Awareness Certificate is designed to equip learners with the knowledge and skills required to understand and promote safe driving practices. This CPD-certified course covers a wide range of essential topics, including hazard perception, road safety regulations, and vehicle maintenance. It provides learners with the ability to recognise common driving risks and how to mitigate them effectively, fostering better decision-making on the road. Upon completion, learners will be equipped to drive with greater awareness, contributing to safer driving environments in both professional and personal contexts. Course Description This course delves into key areas of driver safety, focusing on topics such as defensive driving techniques, the impact of alcohol and drugs on driving, and the role of technology in modern vehicles. Learners will explore the various factors influencing driver behaviour, from fatigue to weather conditions, and how these affect overall road safety. The course is structured to build both theoretical knowledge and a greater understanding of safety regulations, helping learners become more responsible drivers. On completion, learners will have the ability to apply safety principles to reduce the likelihood of accidents and improve their driving competence. Driver Safety Awareness Certificate Curriculum Module 01: Introduction to Driver Safety Module 02: Road Safety Regulations and Laws Module 03: Hazard Perception and Risk Management Module 04: The Effects of Alcohol, Drugs, and Fatigue Module 05: Defensive Driving Techniques Module 06: Vehicle Maintenance and Safety Checks Module 07: Using Technology to Enhance Road Safety Module 08: Impact of Weather Conditions on Driving Module 09: Safe Driving in Challenging Environments Module 10: Road Safety for Professional Drivers (See full curriculum) Who is this course for? Individuals seeking to improve their driving skills Professionals aiming to enhance their road safety knowledge Beginners with an interest in road safety or vehicle management Drivers looking to reduce accident risks and increase awareness Organisations requiring staff to complete driver safety training Career Path Road Safety Officer Professional Driver Transport Safety Manager Fleet Manager Driver Safety Trainer Logistics and Distribution Roles

PAT Testing - Portable Appliance Testing Training Course Overview The "PAT Testing - Portable Appliance Testing Training" course is designed to equip learners with the essential knowledge and skills required to safely conduct portable appliance testing in line with current UK regulations. Participants will gain a clear understanding of the legal requirements, risk assessment techniques, and best practices for maintaining workplace safety. This course is ideal for individuals involved in electrical safety, ensuring they can carry out PAT testing confidently and competently. Upon completion, learners will be prepared to enhance workplace safety through proper appliance inspection and compliance with relevant legislation. Course Description This comprehensive course covers all key areas of portable appliance testing, including the legal provisions that guide PAT testing, risk assessment methodologies, and the appropriate tools for conducting inspections. Learners will explore different types of electrical appliances, their classification, and how to perform initial visual examinations. Additionally, the course delves into the electrical installation testing process and safety precautions necessary to mitigate risks. Participants will also learn the essential practices for recording and reporting test results. By the end of the course, learners will be equipped with the skills needed to perform thorough PAT testing and ensure compliance with industry standards. PAT Testing - Portable Appliance Testing Training Curriculum Module 01: Introduction to PAT Module 02: Relevant Statutory Provisions for PAT Module 03: Risk Assessment Module 04: Reducing and Controlling Risks Module 05: Electrical Units and Appliance Classification Module 06: Initial Visual Examination Module 07: Instruments for Testing and Equipment Inspection Module 08: Electrical Installation Testing Module 09: Safety Precautions in Electrical Testing Module 10: Reporting and Record-keeping (See full curriculum) Who is this course for? Individuals seeking to enhance their knowledge of electrical safety. Professionals aiming to ensure compliance with PAT testing regulations. Beginners with an interest in electrical safety or maintenance. Safety officers or facilities managers responsible for ensuring workplace compliance. Career Path PAT Tester Health and Safety Officer Facilities Manager Electrical Compliance Officer Maintenance Technician Workplace Safety Consultant