<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Experienced system administrators and system integrators responsible for using the advanced features of vRealize Automation in enterprise deployments.</p>Overview<p>By the end of the course, you should be able to meet the following objectives<br />Describe and configure the vRealize Automation in a clustered enterprise deployment using VMware vRealize Suite Lifecycle Managerâ¢<br />Scale VMware Identity Managerâ¢ to support High Availability.<br />Configure security certificates in vRealize Automation from external Certificate Authorities.<br />Describe the clustered deployment architecture, including Kubernetes pods and services.<br />Create and configure advanced blueprints with complex YAML and cloudConfig.<br />Use vRealize Automation advanced blueprints to deploy an actual 2-tier DB-Server using MySQL and phpMyAdmin.<br />Practice troubleshooting techniques with advanced YAML blueprints in vRealize Automation.<br />Use advanced VMware NSX-TTM Data Center networking features including NAT, routed networks, load balancers, security groups, and tags.<br />Use VMware Code Streamâ¢ to integrate vRealize Automation with Kubernetes.<br />Create Code Stream pipelines.<br />Create and use Ansible playbooks that integrate with vRealize Automation.<br />Configure vRealize Automation to integrate with Puppet.<br />Configure and use ABX actions to create day-2 actions and interface with PowerShell scripts.<br />Use vracli commands, log files, and VMware vRealize Log Insightâ¢ to troubleshoot vRealize Automation and vRealize Automation deployments.</p><p>This five-day course is a follow-on to the VMware vRealizeÂ© Automation? Install, Configure, Manage course. In this course you go deeper into the advanced features of vRealize Automation to deploy user systems and interface vRealize Automation with other platforms and you learn how to deploy an enterprise-level cluster environment using LCM. This course relies heavily on hands-on labs.</p></div><div id="course-pills-2"><h4>Course Introduction</h4><ul><li>Introductions and course logistics</li><li>Course objectives</li></ul><h4>vRealize Automation Clustered Deployment</h4><ul><li>Use LCM in a clustered deployment</li><li>Configure External Certificates</li><li>Configure NSX-T Data Center load balancer</li><li>Install vRealize Automation using Clustered Deployment</li><li>Scale VMware Identity Manager to support High Availability</li></ul><h4>vRealize Automation Clustered Deployment Architecture</h4><ul><li>List of Kubernetes Pods</li><li>The vRealize Automation Kubernetes Architecture</li><li>Relationship of Kubernetes Pods to Services</li><li>Logs and their locations</li><li>Blueprint deployment workflow with Kubernetes Service interaction</li><li>Backup strategies and potential problems</li></ul><h4>Advanced Blueprints</h4><ul><li>Use advanced YAML and cloudConfig to deploy a functioning 2-tier application with a phpMyAdmin front-end server and a MySQL database server</li><li>Use troubleshooting techniques to debug problems in advanced YAML blueprints</li><li>List the log files that can aid in troubleshooting blueprint deployment</li></ul><h4>Advanced Networking</h4><ul><li>Use VMware NSX-T Data Center advanced features in blueprints</li><li>Interfacing to IPAMs</li><li>Use NSX-T Data Center NAT in blueprints</li><li>Use NSX-T Data Center routed networks</li><li>Use NSX-T Data Center load balancers</li><li>Use NSX-T Data Center security groups</li><li>Use tags with NSX-T Data Center network profiles</li></ul><h4>Using vRealize Orchestrator</h4><ul><li>Create Day-2 Actions with vRealize Orchestrator workflows</li><li>Troubleshoot vRealize Orchestrator cluster issues</li><li>Use vRealize Orchestrator to add computer objects to Active Directory when vRealize Automation deploys blueprints</li><li>Use a tagging approach to vRealize Orchestrator workflows</li><li>Use dynamic forms with vRealize Orchestrator</li></ul><h4>Using ABX Actions</h4><ul><li>Determine when to use ABX and when to use vRealize Orchestrator</li><li>Use ABX to create day-2 Actions</li><li>Call PowerShell from ABX</li></ul><h4>Kubernetes Integration</h4><ul><li>Create a Kubernetes namespace from vRealize Automation</li><li>Connect to an existing Kubernetes cluster</li><li>Automate the deployment of an application to a Kubernetes cluster with Code Stream</li><li>Use Kubernetes in Extensibility</li></ul><h4>Code Stream</h4><ul><li>Create and use CI/CD pipelines</li><li>Use the Code Stream user interface</li><li>Add states and tasks to a Code Stream pipeline</li><li>Integrate code from Code Stream with Git</li></ul><h4>Using GitLab Integration</h4><ul><li>Configure the GitLab Integration</li><li>Use Gitlab with blueprints</li></ul><h4>Configuration Management</h4><ul><li>Describe the use case of Ansible and Ansible Tower</li><li>Connect to Ansible Tower</li><li>Use Ansible playbooks</li><li>Use Puppet in configuration management</li></ul><h4>Troubleshooting</h4><ul><li>vracli commands and when to use them</li><li>Check the status of Kubernetes pods and services</li><li>Correct the state of pods and services</li><li>Diagnose and solve vRealize Automation infrastructure problems</li><li>Diagnose and solve vRealize Automation failures to deploy blueprints and services</li><li>Use vRealize Log Insight for troubleshooting</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br />Notes<p>Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC)</p><p>Nexus Humans VMware vRealize Automation: Advanced Features and Troubleshooting [v8.x] 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 VMware vRealize Automation: Advanced Features and Troubleshooting [v8.x] 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

VMware Vsphere

AWS Certification

vSphere

AWS Certified Cloud Practitioner

Microsoft Virtual Academy (MVA)

AWS Certified Solutions Architect

VMware vRealize Automation: Advanced Features and Troubleshooting [v8.x]

<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

Oracle Fusion HCM

Payroll

Employee Management

Human Resources Management

Oracle PeopleSoft Time and Labor - North America Rel. 9.2

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>Experienced system administrators or network administrators, software and DevOps engineers</p>Overview<p>By the end of the course, you should be able to meet the following objectives:<br />Describe VMware NSX Advanced Load Balancer architecture<br />Describe VMware NSX Advanced Load Balancer components and main functions<br />Explain VMware NSX Advanced Load Balancer key features and benefits<br />Describe and leverage VMware NSX Advanced Load Balancer REST API<br />Describe and leverage VMware NSX Advanced Load Balancer SDKs with extended focus on Python SDK<br />Leverage REST API and SDK features and functions to provision application delivery components<br />Describe and leverage VMware NSX Advanced Load Balancer Ansible and Terraform integrations<br />Describe and leverage VMware NSX Advanced Load Balancer Github, Docker (avinetworks/avitools), Ansible Galaxy and other open source resources to accelerate the automation planning and implementation<br />Leverage VMware NSX Advanced Load Balancer Ansible and Terraform integrations to provision infrastructure components<br />Leverage VMware NSX Advanced Load Balancer Ansible and Terraform integrations to automate and streamline application delivery services provisioning</p><p>This three-day, fast-paced course provides comprehensive training on how to automate infrastructure and application components of VMware NSX Advanced Load Balancer (Avi Networks) solution. This course covers key application delivery features of NSX Advanced Load Balancer (Avi Networks) features and functionality offered in VMware NSX Advanced Load Balancer 18.2 release and focuses on how to plan and implement automation of infrastructure and application components leveraging REST API, SDK or automation solutions such as Ansible, Terraform or similar. Access to a software-defined data center environment is provided through hands-on labs to reinforce the skills and concepts presented in the course.</p></div><div id="course-pills-2"><h4>Course Introduction</h4><ul><li>Introductions and course logistics</li><li>Course objectives</li></ul><h4>Introduction to NSX Advanced Load Balancer</h4><ul><li>Introduce NSX Advanced Load Balancer</li><li>Discuss NSX Advanced Load Balancer use cases, and benefits</li><li>Explain NSX Advanced Load Balancer architecture and components</li><li>Explain the management, control, data, and consumption planes and functions</li></ul><h4>Virtual Services Configuration Concepts</h4><ul><li>Explain Virtual Service components</li><li>Explain Virtual Service types</li><li>Explain and configure basic virtual services components such as Application Profiles, Network Profiles,Pools and Health Monitors</li></ul><h4>Pools Configuration Concepts</h4><ul><li>Explain and deep dive on Pool configuration options</li><li>Describe multiple load balancing algorithms</li><li>Explain multiple Health Monitor types</li><li>Explain multiple Persistent profiles</li><li>Explain and configure Pool Groups</li></ul><h4>Leveraging NSX Advanced Load Balancer REST API</h4><ul><li>Explain NSX Advanced Load Balancer automation vision</li><li>Explain and introduce NSX Advanced Load Balancer REST API</li><li>Describe NSX Advanced Load Balancer REST API methods and capabilities</li><li>Describe NSX Advanced Load Balancer REST API session handling properties such authentication, API versioning and tenancy model</li><li>Deep dive on NSX Advanced Load Balancer REST API Object Model</li><li>Explain and investigate NSX Advanced Load Balancer REST API leveraging browser and command line utilities</li><li>Explain and interact with NSX Advanced Load Balancer REST API leveraging browser, Postman and Curl</li><li>Explain Swagger-based API Documentation</li><li>Explain and leverage NSX Advanced Load Balancer Inventory API</li><li>Explain and leverage NSX Advanced Load Balancer methods such as GET, PUT, POST and PATCH and associated queries, filters and parameters</li><li>Deep dive on NSX Advanced Load Balancer PATCH method</li><li>Explain and leverage NSX Advanced Load Balancer Analytics API</li><li>Explain and leverage NSX Advanced Load Balancer MACRO API</li></ul><h4>NSX Advanced Load Balancer Software-Defined Kits (SDKs) and ControlScripts</h4><ul><li>Introduce NSX Advanced Load Balancer SDKs</li><li>Describe, install and leverage NSX Advanced Load Balancer Python SDK</li><li>Deep dive on NSX Advanced Load Balancer Python SDK</li><li>Describe and leverage Golang SDK</li><li>Leverage NSX Advanced Load Balancer open source resources such as Github, etc to accelerate SDKs adoption</li><li>Describe NSX Advanced Load Balancer Events and Alerts framework</li><li>Introduce ControlScripts foundations</li><li>Leverage ControlScripts to automate configuration changes and alerts remediation</li></ul><h4>Automating NSX Advanced Load Balancer Application Delivery Services with Ansible and Terraform</h4><ul><li>Introduce NSX Advanced Load Balancer Configuration Orchestration and Management vision</li><li>Introduce and explain Ansible foundations</li><li>Describe Ansible and NSX Advanced Load Balancer Ansible capabilities</li><li>Deep dive and implement NSX Advanced Load Balancer Ansible Core configuration modules (avinetworks/avisdk)</li><li>Deep dive and implement Ansible NSX Advanced</li><li>Load Balancer Declarative configuration role (avinetworks/aviconfig)</li><li>Leverage Swagger NSX Advanced Load Balancer REST API models to develop and implement Ansible playbooks</li><li>Explain application delivery configuration automation</li><li>approach and models</li><li>Apply configuration automation models with Ansible</li><li>Introduce and explain Terraform foundations</li><li>Describe Terraform and NSX Advanced Load Balancer Terraform capabilities</li><li>Deep dive and implement NSX Advanced Load Balancer Terraform Provider</li><li>Leverage Swagger NSX Advanced Load Balancer REST API models to develop and implement Terraform plans</li><li>Apply configuration automation models with Terraform</li></ul><h4>Automating NSX Advanced Load Balancer Infrastructure with Ansible and Terraform</h4><ul><li>Introduce NSX Advanced Load Balancer infrastructure Automation vision</li><li>Describe infrastructure deployment approach and capabilities</li><li>Describe Ansible and NSX Advanced Load Balancer Ansible Infrastructure deployment approach and capabilities</li><li>Describe Terraform and NSX Advanced Load Balancer Terraform deployment approach and capabilities</li><li>Leverage Terraform to deploy Controllers and perform system configuration, including control plane cluster setup</li><li>Leverage Terraform to provision Cloud, Service Engine Groups and Service Engine components</li><li>Describe and leverage Ansible roles to deploy Controllers and perform initial system configuration, including control plane cluster setup</li><li>Leverage Ansible declarative and core roles to provision Cloud, Service Engine Groups and Service Engine components</li><li>Describe and implement combined Terraform + Ansible model to streamline NSX Advanced Load Balancer solution deployment</li></ul></div>

Service Design Courses (SDC)

VMware NSX Advanced Load Balancer: Infrastructure and Application Automation

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Typical candidates for this course are IT Professionals who will deploy and manage networks based on HPE's ArubaOS-CX switches.</p>Overview<p>After you successfully complete this course, expect to be able to:<br />Use NetEdit to manage switch configurations<br />Use the Network Analytics Engine (NAE) to implement scripting solutions to provide for proactive network management and monitoring<br />Compare and contrast VSX, VSF, and backplane stacking<br />Explain how VSX handles a split-brain scenario<br />Implement and manage a VSX fabric<br />Define ACLs and identify the criteria by which ACLs select traffic<br />Configure ACLs on AOS-CX switches to select given traffic<br />Apply static ACLs to interfaces to meet the needs of a particular scenario<br />Examine an ACL configuration and determine the action taken on specific packets<br />Deploy AOS-Switches in single-area and multi-area OSPF systems<br />Use area definitions and summaries to create efficient and scalable multiple area designs<br />Advertise routes to external networks in a variety of OSPF environments<br />Promote fast, effective convergence during a variety of failover situations<br />Use virtual links as required to establish non-direct connections to the backbone<br />Implement OSFP authentication<br />Establish and monitor BGP sessions between your routers and ISP routers<br />Advertise an IP block to multiple ISP routers<br />Configure a BGP router to advertise a default route in OSPF<br />Use Internet Group Management Protocol (IGMP) to optimize forwarding of multicast traffic within VLANs<br />Describe the differences between IGMP and IGMP snooping<br />Distinguish between PIM-DM and PIM-SM<br />Implement PIM-DM and PIM-SM to route multicast traffic<br />Implement Virtual Routing Forwarding (VRF) policies to contain and segregate routing information<br />Create route maps to control routing policies<br />Understand the use of user roles to control user access on AOS-CX switches<br />Implement local user roles on AOS-CX switches and downloadable user roles using a ClearPass solution<br />Implement 802.1X on AOS-CX switch ports<br />Integrate AOS-CX switches with an Aruba ClearPass solution, which might apply dynamic role settings<br />Implement RADIUS-based MAC Authentication (MAC-Auth) on AOS-CX switch ports<br />Configure captive portal authentication on AOS-CX switches to integrate them with an Aruba ClearPass solution<br />Combine multiple forms of authentication on a switch port that supports one or more simultaneous users<br />Configure dynamic segmentation on AOS-CX switches</p><p>This course teaches you the advanced skills necessary to implement and operate enterprise level Aruba campus switching solutions. You will build on the skills you learned at the Associate level to configure and manage modern, open standards-based networking solutions using Aruba's OS-CX routing and switching technologies. In this course, participants learn about ArubaOS-CX switch technologies including: securing port access with Aruba's dynamic segmentation, redundancy technologies such as Multiple Spanning Tree Protocol (MSTP), link aggregation techniques including Link Aggregation Protocol (LACP) and switch virtualization with Aruba?s Virtual Switching Extension (VSX) and Aruba's Virtual Switching Framework (VSF). This course is approximately 50% lecture and 50% hands-on lab exercises.</p></div><div id="course-pills-2"><h4>Introduction to Aruba Switching</h4><ul><li>Switches overview</li><li>Architectures</li></ul><h4>NetEdit</h4><ul><li>Overview</li><li>Centralized configuration</li><li>Switch groups/templates</li><li>AOS-CX mobile App</li></ul><h4>Network Analytics Engine (NAE)</h4><ul><li>Overview</li><li>Configuration</li><li>Core NAE feature lab</li><li>sflow, local mirror, remote mirror</li></ul><h4>VSX</h4><ul><li>VSF vs. VSX: access and Agg/core design</li><li>Stacking review</li><li>VSF and uni/multi packet forwarding</li><li>Stack fragments / split brain</li><li>VSX Overview: roles, control, data, management planes</li><li>VSX components (ISL, Keepalive, VSX LAG, Active Gateway, Active-Forwarding, Link Delay)</li><li>Split Brain scenario</li><li>Upstream Connectively Options (ROP single VRF, SVIs with multiple VRF, VSX Lag SVIs with multiple VRFs)</li><li>Upstream/Downstream unicast traffic flow (South-North and North-South)</li><li>VSX Configuration: VSX and Active Gateway</li><li>VSX firmware updates</li></ul><h4>ACLs</h4><ul><li>Overview: types, components</li><li>MAC ACL, Standard ACL, Extended ACL,</li><li>Classifier-based Policies</li><li>Configuration: wildcard bits, logging, pacl, vacl, racl</li></ul><h4>Advanced OSPF</h4><ul><li>Review basic OSPF</li><li>Multi area: setup and aggregation</li><li>Area-Types Stub, Totally Stub, NSSA, Totally NSSA</li><li>External routes</li><li>OSPF tuning: costs, bfd, gr, auth, vrrp, virt link</li></ul><h4>BGP</h4><ul><li>Overview: i/e bgp, as numbers</li><li>Best path selection</li><li>Configuration: route announcement</li><li>Route filtering to prevent transit as</li></ul><h4>IGMP</h4><ul><li>Overview</li><li>Querier</li><li>Snooping</li><li>Unknown multicasts</li></ul><h4>Multicast Routing: PIM</h4><ul><li>Overview</li><li>PIM DM</li></ul><h4>802.1X Authentication</h4><ul><li>Overview: roles, requirements, coa, accounting</li><li>Dynamic port configuration: avp, acl, qos, VLAN</li><li>Port-based vs. user-based: examples</li><li>Radius service tracking, critical VLAN</li></ul><h4>MAC Authentication</h4><ul><li>Overview: Use cases</li><li>Radius-based MAC Auth</li></ul><h4>Dynamic Segmentation</h4><ul><li>Leverage dynamic segmentation features</li><li>Configure tunneled-node on AOS-CX switches</li><li>Describe when and how to configure PAPI enhanced security, high availability, and fallback switching for tunneled-node</li></ul><h4>Quality of Service</h4><ul><li>Overview</li><li>VoQ (Virtual Output Queue)</li><li>QOS: queueing, QOS marks, dot1p, dscp</li><li>Trust levels</li><li>QOS configuration: port, VLAN, policies</li><li>Interaction with user roles</li><li>Queue configuration</li><li>Rate limiters</li><li>LLDP-MED</li></ul><h4>Additional Routing Technologies</h4><ul><li>VRF - Management VRF</li><li>PBR</li><li>MDNS</li><li>PIM SM</li></ul><h4>Capitve Portal Authentication</h4><ul><li>Overview of guest solutions</li><li>Built-in web auth</li><li>ClearPass redirect with CPPM</li></ul></div>

Cisco Certified Network Associate (CCNA)

Cisco Certified Network Professional certification (CCNP)

Cisco Certified Entry Networking Technician (CCENT)

Cisco Certified Internetwork Expert (CCIE)

IT Networking Fundamentals

Computer Networking

Implementing Aruba OS-CX Switching, Rev. 20.21

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is intended for:<br />Those who will provide container orchestration management in the AWS Cloud including:<br />DevOps engineers<br />Systems administrators</p>Overview<p>In this course, you will learn to:<br />Review and examine containers, Kubernetes and Amazon EKS fundamentals and the impact of containers on workflows.<br />Build an Amazon EKS cluster by selecting the correct compute resources to support worker nodes.<br />Secure your environment with AWS Identity and Access Management (IAM) authentication by creating an Amazon EKS service role for your cluster<br />Deploy an application on the cluster. Publish container images to ECR and secure access via IAM policy.<br />Automate and deploy applications, examine automation tools and pipelines. Create a GitOps pipeline using WeaveFlux.<br />Collect monitoring data through metrics, logs, tracing with AWS X-Ray and identify metrics for performance tuning. Review scenarios where bottlenecks require the best scaling approach using horizontal or vertical scaling.<br />Assess the tradeoffs between efficiency, resiliency, and cost and impact for tuning one over the other. Describe and outline a holistic, iterative approach to optimizing your environment. Design for cost, efficiency, and resiliency.<br />Configure the AWS networking services to support the cluster. Describe how EKS/Amazon Virtual Private Cloud (VPC) functions and simplifies inter-node communications. Describe the function of VPC Container Network Interface (CNI). Review the benefits of a service mesh.<br />Upgrade your Kubernetes, Amazon EKS, and third party tools</p><p>Amazon EKS makes it easy for you to run Kubernetes on AWS without needing to install, operate, and maintain your own Kubernetes control plane. In this course, you will learn container management and orchestration for Kubernetes using Amazon EKS.<br />You will build an Amazon EKS cluster, configure the environment, deploy the cluster, and then add applications to your cluster. You will manage container images using Amazon Elastic Container Registry (ECR) and learn how to automate application deployment. You will deploy applications using CI/CD tools. You will learn how to monitor and scale your environment by using metrics, logging, tracing, and horizontal/vertical scaling. You will learn how to design and manage a large container environment by designing for efficiency, cost, and resiliency. You will configure AWS networking services to support the cluster and learn how to secure your Amazon EKS environment.</p></div><div id="course-pills-2"><h4>Module 0: Course Introduction</h4><ul><li>Course preparation activities and agenda</li></ul><h4>Module 1: Container Fundamentals</h4><ul><li>Best practices for building applications<br />Container fundamentals<br />Components of a container</li></ul><h4>Module 2: Kubernetes Fundamentals</h4><ul><li>Container orchestration<br />Kubernetes objects<br />Kubernetes internals<br />Preparing for Lab 1: Deploying Kubernetes Pods</li></ul><h4>Module 3: Amazon EKS Fundamentals</h4><ul><li>Introduction to Amazon EKS<br />Amazon EKS control plane<br />Amazon EKS data plane<br />Fundamentals of Amazon EKS security<br />Amazon EKS API</li></ul><h4>Module 4: Building an Amazon EKS Cluster</h4><ul><li>Configuring your environment<br />Creating an Amazon EKS cluster<br />Demo: Configuring and deploying clusters in the AWS Management Console<br />Working with eksctl<br />Preparing for Lab 2: Building an Amazon EKS Cluster</li></ul><h4>Module 5: Deploying Applications to Your Amazon EKS Cluster</h4><ul><li>Configuring Amazon Elastic Container Registry (Amazon ECR)<br />Demo: Configuring Amazon ECR<br />Deploying applications with Helm<br />Demo: Deploying applications with Helm<br />Continuous deployment in Amazon EKS<br />GitOps and Amazon EKS<br />Preparing for Lab 3: Deploying App</li></ul><h4>Module 6: Configuring Observability in Amazon EKS</h4><ul><li>Configuring observability in an Amazon EKS cluster<br />Collecting metrics<br />Using metrics for automatic scaling<br />Managing logs<br />Application tracing in Amazon EKS<br />Gaining and applying insight from observability<br />Preparing for Lab 4: Monitoring Amazon EKS</li></ul><h4>Module 7: Balancing Efficiency, Resilience, and Cost Optimization in Amazon EKS</h4><ul><li>The high level overview<br />Designing for resilience<br />Designing for cost optimization<br />Designing for efficiency</li></ul><h4>Module 8: Managing Networking in Amazon EKS</h4><ul><li>Review: Networking in AWS<br />Communicating in Amazon EKS<br />Managing your IP space<br />Deploying a service mesh<br />Preparing for Lab 5: Exploring Amazon EKS Communication</li></ul><h4>Module 9: Managing Authentication and Authorization in Amazon EKS</h4><ul><li>Understanding the AWS shared responsibility model<br />Authentication and authorization<br />Managing IAM and RBAC<br />Demo: Customizing RBAC roles<br />Managing pod permissions using RBAC service accounts</li></ul><h4>Module 10: Implementing Secure Workflows</h4><ul><li>Securing cluster endpoint access<br />Improving the security of your workflows<br />Improving host and network security<br />Managing secrets<br />Preparing for Lab 6: Securing Amazon EKS</li></ul><h4>Module 11: Managing Upgrades in Amazon EKS</h4><ul><li>Planning for an upgrade<br />Upgrading your Kubernetes version<br />Amazon EKS platform versions</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Running Containers on Amazon Elastic Kubernetes Service (Amazon EKS) 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 Running Containers on Amazon Elastic Kubernetes Service (Amazon EKS) 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>

Kubernetes

Software Containerization

Running Containers on Amazon Elastic Kubernetes Service (Amazon EKS)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This hands-on course is geared for experienced DBAs new to Oracle 19c, who can work in Linux and have basic experience with SQL scripting.</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 Oracle Certified expert facilitator, students will learn how to:<br />How to use tools to access an Oracle Database<br />Generate database creation scripts by using DBCA<br />How to create a container database (CDB) by using the CREATE DATABASE command<br />Learn about Startup and shut down Oracle databases<br />Initialization parameter files and initialization parameters<br />Tools that are used to administer Oracle Net Services<br />How to use the Oracle Connection Manager Control utility to administer Oracle Connection Manager<br />How to create a new PDB from the PDB seed.<br />Logical and physical storage structures in an Oracle database<br />Usage of Oracle Database features that save space<br />Explanation of DML and undo data generation<br />Learn about general architecture of Oracle Data Pump and SQL*Loader<br />How to use SQL*Loader to load data from a non-Oracle database (or user files)<br />Bonus Content / Time Permitting: Explanation of maintenance windows<br />Bonus Content / Time Permitting: Employ basic monitoring procedures and manage performance</p><p>Oracle 19C Database Administration I (Oracle DBA I) is a comprehensive, hands-on course provides concrete information on the design of an Oracle Database instance and database, allowing you to manage your database investment. In this class, you will learn how to create database storage structures that align with your requirements and business models. You will also learn how to create users and administer databases as well as harden the databases to meet your business requirements. This is the foundational course for learning about Oracle Database and it does not assume prior knowledge or Oracle technologies, however you should have incoming experience working with SQL, and be comfortable with Linux and working from the command line. This training is NOT Official Oracle University training. This is independent, adjustable content that aligns with current topics, skills and tools that participants need to excel in these areas.</p></div><div id="course-pills-2"><h4>Introduction to Oracle Database</h4><ul><li>Oracle Multitenant Container Database</li><li>Oracle Database Instance Configurations</li><li>Database Sharding</li><li>Oracle Database Server</li></ul><h4>Accessing an Oracle Database</h4><ul><li>Oracle Database Tools</li><li>Database Tool Choices</li><li>SQL Developer</li><li>Enterprise Manager Database Express</li></ul><h4>Creating an Oracle Database by Using DBCA</h4><ul><li>Planning the Database</li><li>Choosing a Database Template</li><li>Configuration Assistant</li></ul><h4>Creating an Oracle Database by Using a SQL Command</h4><ul><li>Creating a Container Database</li><li>Enable Pluggable Database</li></ul><h4>Starting Up and Shutting Down a Database Instance</h4><ul><li>Starting the Oracle Database Instance</li><li>Shutting Down an Oracle Database Instance</li><li>Opening and Closing PDBs</li></ul><h4>Managing Database Instances</h4><ul><li>Investigating Initialization Parameter Files</li><li>Viewing Initialization Parameters by Using SQL*Plus</li><li>Modifying Initialization Parameters by Using SQL*Plus</li><li>Viewing Diagnostic Information</li></ul><h4>Oracle Net Services Overview</h4><ul><li>Oracle Net Services Components</li><li>Oracle Net Listener</li></ul><h4>Configuring Naming Methods</h4><ul><li>Configuring the Oracle Network to Access a Database</li><li>Creating a Net Service Name for a PDB</li></ul><h4>Configuring and Administering the Listener</h4><ul><li>Exploring the Default Listener</li><li>Creating a Second Listener</li><li>Connecting to a Database Service Using the New Listener</li></ul><h4>Configuring a Shared Server Architecture</h4><ul><li>Configuring Shared Server Mode<br />Configuring Clients to Use a Shared Server</li></ul><h4>Configuring Oracle Connection Manager for Multiplexing and Access Control</h4><ul><li>Oracle Connection Manager Processes</li><li>Filtering Rules</li><li>Session Multiplexing</li></ul><h4>Creating PDBs</h4><ul><li>Creating a New PDB from the PDB Seed</li><li>Cloning Remote PDBs in Hot Mode</li><li>Relocating PDBs</li></ul><h4>Managing PDBs</h4><ul><li>Renaming a PDB</li><li>Setting Parameter Values for PDBs</li></ul><h4>Database Storage Overview</h4><ul><li>Logical and Physical Database Structures</li><li>Tablespaces and Data Files</li><li>Types of Segments</li><li>Monitoring Tablespace Space Usage</li></ul><h4>Creating and Managing Tablespaces</h4><ul><li>Viewing Tablespace Information</li><li>Creating a Tablespace</li><li>Managing Temporary and Permanent Tablespaces</li></ul><h4>Improving Space Usage</h4><ul><li>Managing Space in Tablespaces</li><li>Using Compression</li><li>Enabling the Resumable Space Allocation Feature</li></ul><h4>Creating and Managing User Accounts</h4><ul><li>Creating Common and Local Users</li><li>Creating a Local User for an Application</li><li>Exploring OS and Password File Authentication</li></ul><h4>Configuring Privilege and Role Authorization</h4><ul><li>Granting a Local Role (DBA) to PDBADMIN</li><li>Using SQL*Developer to Create Local Roles</li></ul><h4>Configuring User Resource Limits</h4><ul><li>Using SQL*Developer to Create a Local Profile &amp; Users</li><li>Configuring a Default Role for a User</li></ul><h4>Implementing Oracle Database Auditing</h4><ul><li>Enabling Unified Auditing</li><li>Creating Audit Users</li><li>Creating an Audit Policy</li></ul><h4>Introduction to Loading and Transporting Data</h4><ul><li>General Architecture</li><li>Oracle Data Pump</li><li>SQL Loader</li><li>Loading Data into a PDB from an External File</li><li>Moving Data from One PDB to Another PDB</li><li>Transporting a Tablespace</li></ul><h4>Using External Tables to Load and Transport Data</h4><ul><li>Querying External Tables</li><li>Unloading External Tables</li></ul><h4>Automated Maintenance Tasks Overview</h4><ul><li>Automated Maintenance Tasks</li><li>Maintenance Windows</li><li>Predefined Maintenance Windows</li></ul><h4>Bonus: Managing Tasks and Windows</h4><ul><li>Enabling and Disabling Automated Maintenance Tasks</li><li>Modifying the Duration of a Maintenance Window</li></ul><h4>Bonus: Database Monitoring and Performance Tuning Overview</h4><ul><li>Performance Planning Considerations</li><li>Automatic Workload Repository (AWR)</li><li>Advisory Framework</li></ul><h4>Bonus: Monitoring Database Performance &amp; Processes</h4><ul><li>Server-Generated Alerts</li><li>Setting Metric Thresholds</li><li>Performance Monitoring</li><li>Examining the Database Background Processes</li></ul><h4>Bonus: Tuning Database Memory</h4><ul><li>Viewing Memory Configurations</li></ul><h4>Bonus: Analyzing SQL and Optimizing Access Paths</h4><ul><li>Using the Optimizer Statistics Advisor</li></ul></div>

Oracle SQL

AWS Certified Database

Oracle

Oracle 1Z0-819

Database Administration

Oracle Database

Oracle 19c Database Administration I (DBA I) (TTOR20519)

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

Programming Fundamentals

Database Programming

Oracle 12c PL/SQL Fundamentals

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is designed for the professional tasked with implementing, designing, architecting, installing, and configuring Symantec Client Management Suite (CMS) to manage the software and hardware in their company.</p>Overview<p>At the completion of the course, you will be able to: Identify the types of information you need to collect to help determine what type of CMS configuration to implement. Install Client Management Suite. Discover and import computer and user resources that you want to manage. Deploy the Symantec Management Agent and plug-ins. Create Organizational Views and Groups and assign resources to them. Create and configure policies, tasks, and jobs and assign them to targets. Troubleshoot common problems with installation and managing of Client Management Suite. Creating reports and installing and configuring IT Analytics.</p><p>This course teaches students theory and concepts, and provides technical know-how on implementing Client Management Suite.</p></div><div id="course-pills-2"><h4>Course Introduction</h4><ul><li>Course objectives<br />Course overview<br />Lab environment introduction</li></ul><h4>Understanding the Symantec Management Platform</h4><ul><li>Introducing the Symantec Management Platform<br />Symantec management Platform components used by Client Management Suite<br />Symantec Management Platform concepts<br />How Client Management Suite works</li></ul><h4>Architecture of Client Management Suite</h4><ul><li>Understanding Architecture<br />Hardware Recommendations</li></ul><h4>Installing and configuring Client Management Suite</h4><ul><li>Installing and using the Symantec Installation Manager<br />Installing the Notification Server, suite and solution software</li></ul><h4>The Symantec Management Console</h4><ul><li>Accessing the Symantec Management Console<br />Getting to know the Symantec Management Console<br />Configuring the Notification Server after installation<br />Getting to know the ITMS Management views</li></ul><h4>Discovering resources</h4><ul><li>Introducing resource discovery methods<br />Importing resources from Microsoft Active Directory<br />Discovering computers using domain resource discovery<br />Discovering network resources using Network Discovery</li></ul><h4>Creating and Managing Organizational Views and Groups</h4><ul><li>Learning about organizational views and groups<br />Creating custom organizational views and groups<br />Managing organizational views and groups</li></ul><h4>Installing and Configuring the Agents and Plug-ins</h4><ul><li>Managing computers with the Symantec Management Agent<br />Installing the Symantec Management Agent<br />Verifying the Symantec Management Agent installation<br />Configuring the Symantec Management Agent settings<br />Introducing solution plug-ins for the Symantec Management Agent<br />Upgrading Client Management Suite<br />Introducing agent, Notification Server and site server communications<br />Introducing Notification Server event queues</li></ul><h4>Resource Filters</h4><ul><li>Introducing resource filters<br />Managing and working with existing filters<br />Creating and modifying filters</li></ul><h4>Filters and Targets</h4><ul><li>Introducing targets<br />Working with targets in the computer management view</li></ul><h4>Policies</h4><ul><li>Getting to know policies<br />Understanding user-based policies<br />Understanding how the Symantec Management Agent receives policies<br />Configuring automation policies<br />Managing shared schedules</li></ul><h4>Creating and Managing Tasks and Jobs</h4><ul><li>Overview of task management<br />Creating and scheduling tasks and jobs<br />Task management communication and processing</li></ul><h4>Security</h4><ul><li>Learning about security<br />Managing user accounts, security roles, and privileges<br />Managing permissions</li></ul><h4>Reporting</h4><ul><li>Introducing reports<br />Using and creating classic reports<br />Configuring and using IT Analytics</li></ul><h4>Site Management</h4><ul><li>Introducing site management<br />Managing sites, subnets and site servers<br />Reviewing site server plug-ins to the Symantec Management Agent<br />Configuring site services</li></ul><h4>Cloud-enabled Management (CeM)</h4><ul><li>Introducing Cloud-enabled Management (CeM)<br />Understanding the cloud-enabled agent<br />Preparing the Notification Server and agents for CeM<br />Configuring site management for CeM<br />Installing and Configuring the SMP Internet Gateway and configuring a CeM Settings policy<br />Configuring the SMP Internet Gateway with the SMP IG Manager<br />Configuring the CeM Settings policy<br />Creating a cloud-enabled agent installation package<br />Installing a cloud-enabled agent from a package</li></ul><h4>Replication</h4><ul><li>Understanding replication<br />Setting up and configuring replication<br />Running replication</li></ul><h4>Hierarchy</h4><ul><li>Understanding hierarchy<br />Setting up a Notification Server hierarchy<br />Configuring hierarchy replication<br />Changing the hierarchy topology</li></ul><h4>Migration</h4><ul><li>Migrating Symantec Management Platform<br />Agent registration (trust)Post installation checklist<br />Readiness checklist for CMS Migration<br />Post migration checklist for a CMS Migration<br />Migrating from 6.x to 7.6<br />Migrating from 7.x to 7.6</li></ul><h4>Troubleshooting</h4><ul><li>Learning about Symantec Management Platform troubleshooting tools<br />Using NSConfigurator<br />Using Remote Altiris Agent Diagnostics<br />Introducing Notification Server event queues<br />Troubleshooting Cloud-enabled Management (CeM)</li></ul><h4>Backing up the server and database</h4><ul><li>Symantec Management Platform components needed for recovery<br />Backing up the IIS default web site virtual directories<br />Backing up the Configuration Management Database</li></ul><h4>Customizing the Console</h4><ul><li>Customizing the Symantec Management Console<br />Personalizing the Symantec Management Console</li></ul><h4>SQL Basics</h4><ul><li>Learning SQL basics</li></ul><h4>Obtaining Technical Support from Symantec</h4><ul><li>Using self-help resources<br />Obtaining customer support</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Symantec Management Suite 7.6 - Implementation 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 Symantec Management Suite 7.6 - Implementation 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>

IT Service Management

Sccm

Certificate in Information Security Management Principles (CISMP)

Commercial & Contract Management Certification Program (CCM)

Security Management

Management System

Symantec Management Suite 7.6 - Implementation

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The primary audience for this course is as follows:<br />Server Administrators<br />Systems Engineers<br />Storage Administrators<br />Technical Solutions Architects<br />Integrators and Partners<br />Consulting Systems Engineers<br />Network Administrators<br />Network Engineers<br />Network Managers<br />Architects</p>Overview<p>Upon completion of this course, the student will be able to meet these overall objectives:<br />Understand, describe, and configure Cisco Intersight (on prem and SaaS models)<br />Understand, describe, and configure Intersight Advanced features (IST, ICO, IWOM)<br />Understand, describe, and configure IMM and UMM mode for UCS<br />Understand, describe, and configure Cisco X-Series (FI, IFM, X210c Server, Adv Fabric Module)<br />Create Intersight Pools, Policies, and Management for X-Series<br />Design and operate Cisco UCS with Intersight Managed Mode Solutions</p><p>This deep-dive training covers Cisco UCS X-Series server family and how Intersight can be the enablement platform for all UCS servers. We will cover Intersight features such as IWOM, IST, ICO, and programmability either On-Prem or in the Cloud. Attendees will learn the breadth of the physical X-Series (pools, policies, firmware, so much more) platform as well as maintaining existing infrastructure with Intersight Infrastructures Services. Also covered is how to manage physical, virtual, cloud platforms and deploy to any or all.</p></div><div id="course-pills-2"><h4>Section 1: Intersight Foundations</h4><ul><li>Intersight Architecture</li><li>Flexible Deployment Models</li><li>Cisco Intersight Infrastructure Service Licensing</li><li>Intersight Essentials License Tier</li><li>Intersight Advantage License Tier</li><li>Intersight Premier License Tier</li></ul><h4>Section 2: Monitoring and Maintaining UCS Infrastructure with Intersight</h4><ul><li>Device Health and Monitoring</li><li>Standalone Management for UCS C-Series Servers</li><li>Server Compatibility (HCL), Advisories (CVEs), and Contract Status</li><li>Firmware Upgrades</li></ul><h4>Section 3: Designing &amp; Operationalizing Cisco UCS Solutions with Intersight</h4><ul><li>Implementing Cisco Hyperflex with Intersight</li><li>Managing Cisco HyperFlex in vSphere Environment</li></ul><h4>Section 4: Cisco UCS M5, M6, X Overview and Configuration</h4><ul><li>Cisco UCS X-Series with Intersight Deployment</li><li>Architecture</li><li>X-Series Fabric Interconnects</li><li>Compute X-Series</li><li>Power/Cooling Efficiency</li><li>Cooling Capacity</li><li>Airflow</li><li>Thermal Policies</li><li>Future-Proof Cooling</li><li>Power Policies</li><li>Compute Series</li><li>Architecture ? C220 M6</li><li>Architecture ? C240 M6</li><li>Cisco VIC Offerings for M6</li><li>GPU Offerings for X-Series</li><li>Management Options for C220 / C240 M6 Rack Servers</li><li>UCS 7th Generation Intel Rack Servers</li><li>Architecture ? C220 M7</li><li>Architecture ? C240 M7</li><li>Intel 4th Gen IntelÂ© XeonÂ© SP Sapphire Rapids High Level Features</li><li>M7 Memory DIMMs</li><li>Architecture ? C225 M6</li><li>Architecture ? C245 M6</li></ul><h4>Section 5: Designing Cisco UCS LAN and SAN Connectivity</h4><ul><li>LAN Connectivity Overview Gen 4</li><li>End Host Mode</li><li>Requirements for Configuring VLANs in Cisco UCS Manager</li><li>Role of the vNIC in Abstracting MAC Addresses</li><li>Configuring Compute Node SAN Connectivity</li><li>Fibre Channel Switching</li><li>Fibre Channel Operating Modes</li><li>EHM and N-Port Virtualization</li><li>Configuring VSANs in Cisco UCS Manager</li><li>Creating VSANs and FCoE VLANs in Cisco UCS</li><li>Role of vHBAs when Abstracting WWNNs and WWPNs into a Service Profile</li><li>Configuring Manual Uplink Pinning and Recovery from Failure</li></ul><h4>Section 6: Configuring Cisco UCS-X in IMM Mode</h4><ul><li>IMM and Domain Profiles</li><li>Domain Policy Concepts and Usage</li><li>Cisco Intersight Server Profiles</li><li>Creating and Deploying a UCS C-Series Server Profile ? Process Overview</li><li>Importing a Server Profile ? Process Overview</li><li>Upgrading Firmware</li><li>Cisco IMM Transition Tool</li><li>Thermal Policies</li><li>Power Policies</li></ul><h4>Section 7: Implementing Cisco UCS-X Firmware Updates</h4><ul><li>Intersight Platform Firmware Operations Overview</li><li>Intersight Firmware Bundles</li><li>Cisco Stand-Alone Firmware Management</li><li>Cisco HX Firmware Management</li><li>UCS Managed Infrastructure Firmware Management</li><li>UCS Intersight Managed Mode Firmware Management</li><li>Hardware Compatibility List</li></ul><h4>Section 8: Intersight Workload Optimizer (IWO)</h4><ul><li>Intersight Workload Optimizer Overview</li><li>IWO Delivery and Tiers</li><li>Workload Optimizer ? What?s New?</li><li>IWO Value Proposition</li><li>Application Resource Management</li><li>IWO Market</li></ul><h4>Section 9: Intersight Cloud Orchestrator (ICO)</h4><ul><li>Sample Scenario</li><li>Workflow Designer</li><li>Validate and Execute a Workflow</li><li>ICO ? Intersight Cloud Orchestrator</li><li>Infrastructure Orchestration</li><li>Infrastructure as Code with ICO</li><li>Immutability with Intersight Cloud Orchestrator</li><li>Workflow Versions</li><li>Rollback Tasks (Task Designer)</li></ul><h4>Section 10: Intersight API Overview</h4><ul><li>Intersight API Resources</li><li>SDKs / Ansible Modules</li><li>Use Case</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Administering Cisco UCS X-Series Solutions with Intersight (INTUCSX) 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 Administering Cisco UCS X-Series Solutions with Intersight (INTUCSX) 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>

IT Support

IT Certifications

Administering Cisco UCS X-Series Solutions with Intersight (INTUCSX)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>Overview<p>By the end of the course, you should be able to meet the following objectives:<br />List the operational challenges for rolling out and operating telco services including 5G.<br />Identify the role of VMware Telco Cloud products in supporting telco services.<br />Discuss the role of VMware technologies such as vSphere, NSX, and Tanzu etc. in implementing telco services.<br />Outline the role of native tools and other VMware monitoring tools such as vRealize Operations and vRealize Log Insight in maintaining network services.<br />Choose the VMware Telco Cloud products that meet your application requirements.<br />Deploy a solution architecture that meet VMware best practices for delivering services using VMware Telco Cloud products.<br />Implement and maintain VMware Telco Cloud products in a secure manner.<br />Identify the tools and remediation pathways for maintaining the availability and performance of your applications and infrastructure using VMware Telco Cloud and vRealize Suite products.<br />Follow specific steps to resolve application performance and availability problems<br />Scale your VMware Telco Cloud products to meet operational requirements in line with VMware best practices.<br />Optimize the operation of VMware Telco Cloud products to ensure SLAs are met.</p><p>This five-day, hands-on training course provides the knowledge to operate and scale VMware Telco Cloud version 2.x products in a Telco cloud provider environment. In this course, you are exposed to the entire VMware Telco Cloud portfolio, and the tools and methodologies available to ensure they operate effectively. In addition, you are presented with various scenarios where you will be guided through the process of identifying, analyzing, and formulating solutions to performance and other problems.</p></div><div id="course-pills-2"><h4>Course Introduction</h4><ul><li>Introductions and course logistics</li><li>Course objectives</li></ul><h4>Overview of Network Transformation</h4><ul><li>Reviews the technologies that enable modern networks</li><li>Lists the components of modern service provider networks</li><li>Outlines characteristics of modern service provider networks in meeting customer application needs</li></ul><h4>Service Delivery with VMware Telco Cloud</h4><ul><li>Outlines the components of the VMware Telco Cloud portfolio</li><li>Reviews the role each VMware Telco Cloud product plays in delivering telco services</li><li>Specifies the dependencies each product has on underlying technologies</li></ul><h4>Supporting VMware Telco Cloud Service Delivery</h4><ul><li>Reviews the products that implements the virtualization, management, platform, and orchestration layers</li><li>Outlines the role played by other VMware products such as NSX in delivering cloud services</li><li>Outline opensource integration options with VMware Telco Cloud products</li></ul><h4>Securing VMware Telco Cloud</h4><ul><li>Reviews security threats that affect telco services</li><li>Identifies the critical telco assets that are prone to attack</li><li>Outlines best practice for securing VMware Telco Cloud products and underlying technology</li><li>Provides overview of appropriate security controls for VMware Telco Cloud products</li></ul><h4>Assessing Service Provision</h4><ul><li>Reviews tools and methodologies used to gather requirements</li><li>Outlines how to assess cloud-native capabilities</li><li>Documenting findings</li><li>Identifying security vulnerabilities with Helm.</li><li>Reviews VMware?s Customer Engagement process</li><li>Capturing infrastructure requirements from TCA</li></ul><h4>Designing a VMware Telco Cloud Solution</h4><ul><li>Selecting appropriate deployment topology</li><li>Pros and cons of design choices</li><li>How a design choice might be affected by other factors such as NSX and TKG deployment, or data center architecture</li><li>Outlines typical scenarios where specific products align with identified requirements</li><li>Documenting a design</li><li>Designing for availability</li><li>Ensuring a design aligns with best practice</li><li>Specifying monitoring options</li></ul><h4>Implementing VMware Telco Cloud Products</h4><ul><li>Review deployment options for VMware products</li><li>Integrating new products with existing ones</li><li>Outline post-installation tasks</li><li>Adding the new products as data sources in monitoring tools such as vRealize Operations and vRealize Operations Network Insight</li><li>Ensuring products meet security requirements</li><li>Configuring monitoring software</li><li>Outlines the xNF onboarding process in TCA</li></ul><h4>Maintaining Telco Services</h4><ul><li>Outlines typical administrative tasks in ensuring services are maintained</li><li>Use of native and other VMware performance monitoring tools</li><li>Reviewing performance data</li><li>Role of SLAs in service maintenance</li><li>Reviews scenarios where known behaviors indicate problems</li></ul><h4>Troubleshooting Deployed Telco Services</h4><ul><li>Reviews the troubleshooting tools available</li><li>Using tools to gather useful data</li><li>Outlines how event correlation can be used to isolate problems</li><li>Using a methodology to determine the root cause of a problem</li><li>Steps to identify and resolve a problem</li><li>Reviews scenarios where known problems are isolated and resolution steps identified</li></ul><h4>Scaling VMware Telco Cloud Products</h4><ul><li>Assessing if operations are impacted by lack of resources now or will be in the future</li><li>Reviews performance optimization options</li><li>Identifies implications for other products if you scale VMware Telco Cloud products</li><li>Reviews VMware sizing guidelines</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br />Notes<p>Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC)</p><p>Nexus Humans VMware Telco Cloud: Day 2 Operate and Scale [V2.x] 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 VMware Telco Cloud: Day 2 Operate and Scale [V2.x] 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>

Cloud Architecture

VMware Telco Cloud: Day 2 Operate and Scale [V2.x]

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>The primary audiences for this course are quality directors and quality assurance managers, managers responsible for the governance of an enterprise and management of its risks, technical experts, project managers and consultants, internal auditors, compliance officers and virtually anybody involved in ANSI/TIA-942 compliance certification related projects either from an end-user or vendor perspective. Participants must hold a valid CTDC certificate in order to be able to register for the CTIA class.</p>Overview<p>After completion of the course the participant will be able to: <br />1. Prepare the organisation for an audit according to ANSI/TIA-942 including preparation of the required documents, resource planning and management of the audit process itself<br />2. Conduct an internal audit according to ANSI/TIA-942 following ISO-19011 guidelines<br />3. Facilitate and support the external audit to ANSI/TIA-942<br />4. Manage the post-audit process with respect to CAR (Corrective Action Reports), gap closing and _nal certification<br />5. Facilitate surveillance and recertification audits</p><p>This intensive course builds further on the technical understanding of the standard acquired in the CTDCÂ© (Certified TIA-942 Design Consultant) course.</p></div><div id="course-pills-2"><h4>Fundamental concepts and process of an internal audit</h4><ul><li>Terms and de_nitions</li><li>Difference between an internal and external auditor</li><li>Audit principles</li><li>Auditor competency requirements</li></ul><h4>Managing an audit programme</h4><ul><li>Establishing the audit objectives</li><li>Establishing the audit programme</li></ul><h4>Planning the audit</h4><ul><li>Planning the schedule</li><li>Resource planning</li><li>Tools/equipment required</li><li>Document requirements</li><li>- Design documents</li><li>- Process documents</li><li>- Declarations</li></ul><h4>Conducting the audit</h4><ul><li>Conducting an opening meeting</li><li>Conducting the audit</li><li>Interviews</li><li>Document review</li><li>Facility review</li><li>Typical non-conformities</li><li>- Architectura</li><li>- Electrica</li><li>- Mechanical</li><li>- Telecommunications</li><li>Preparing the audit conclusions</li><li>Conducting the closing meeting</li></ul><h4>Preparing and distributing the audit report</h4><ul><li>Audit report requirements</li><li>Classification of non-conformities</li><li>Typical format of an audit report</li></ul><h4>Following up on the audit</h4><ul><li>The CAR ? Corrective Action Report</li><li>Evaluation of the Corrective Action Report</li></ul><h4>Requesting a formal external audit</h4><h4>Issuing a conformity certificate</h4><ul><li>Requirements of the certificate</li><li>Registration of the certificate</li></ul><h4>Surveillance audits</h4><h4>Recertification audits</h4><h4>Exam: Certified TIA-942 Internal Auditor)</h4><ul><li>Actual course outline may vary depending on offering center. Contact your sales representative for more information.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Certified TIA-942 Internal Auditor (CTIA) 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 Certified TIA-942 Internal Auditor (CTIA) 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>

Certified Technology Specialist (CTS)

Certified Cryptocurrency Investigator Course (CCI)

Certificate of Completion of Training (CCT)

CompTIA Network+

SIA Training

Certified TIA-942 Internal Auditor (CTIA)

General Admission

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.</p><p></p><p></p><p>This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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

Design & Technology Courses (DT)

Data Skills

Trainers Course

Microsoft AZ-303

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This class has something for everything, from beginners who wish to customise their data entry forms in SharePoint right up to advanced users who need to use advanced formulas to deliver more bespoke actions to their apps.</p>Overview<p>After taking this course, students will be able to: - Understand when to use PowerApp. - Describe the components of PowerApps and their correct use. - Create PowerApps from existing data sources. - Brand PowerApps. - Customize PowerApps beyond just using the automated wizards. - Connect to a range of data sources from Excel to Azure SQL. - Understand the difference between canvas apps and model-driven apps. - Integrate PowerApps with other Office 365 systems ? including Teams and SharePoint Online. - Administer and Maintain PowerApps</p><p>Students will be taught how to design, test and publish new apps that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their business.</p></div><div id="course-pills-2"><h3>1 - AN INTRODUCTION TO POWERAPPS</h3> <ul> <li>What is PowerApps?</li> <li>The benefits of apps</li> <li>How to get PowerApps</li> <li>Canvas Apps and Model-Driven Apps</li> <li>License Options and Costs</li> <li>Discover PowerApps with Templates</li> <li>Lab 1: Introduction to PowerApps</li> </ul> <h3>2 - GETTING STARTED WITH POWERAPPS</h3> <ul> <li>Building a new app from a data source</li> <li>Add, edit and remove controls</li> <li>Intro to Formulas</li> <li>Testing an app</li> <li>App Settings</li> <li>Publish and Share Apps</li> <li>Version History and Restore</li> <li>PowerApps Mobile App</li> <li>Lab 1: Getting Started</li> </ul> <h3>3 - BRANDING AND MEDIA</h3> <ul> <li>Less is more</li> <li>Duplicate Screens</li> <li>Fonts</li> <li>Screen Colours and Matching Colours</li> <li>Screen Backgrounds</li> <li>Buttons and Icons</li> <li>Hide on Timer</li> <li>Size and Alignment by reference</li> <li>Show and Hide on Timer</li> <li>Lab 1: Branding and Media</li> </ul> <h3>4 - POWERAPPS CONTROLS</h3> <ul> <li>Text Controls for Data Entry and Display</li> <li>Controls ? Drop downs, combo box, date picker, radio button and more</li> <li>Forms ? Add and edit data in underlying data sources quickly</li> <li>Charts ? present information in pie, line and bar charts</li> <li>Lab 1: Build Apps from Blank</li> </ul> <h3>5 - DATA SOURCES AND LOGIC</h3> <ul> <li>Data Storage and Services</li> <li>How do I decide which database to use?</li> <li>Connect to on-premises data - Gateway</li> <li>What is Delegation?</li> <li>Specific Data Examples</li> <li>Displaying Data</li> <li>Lab 1: Data Source and Logic</li> </ul> <h3>6 - MODEL-DRIVEN APPS</h3> <ul> <li>What is a model-driven app?</li> <li>Where will my data be stored?</li> <li>How do create a model-driven app</li> <li>Canvas vs model-driven summary</li> <li>Lab 1: Model-Driven App</li> </ul> <h3>7 - POWERAPP INTEGRATION</h3> <ul> <li>Embed PowerApps in Teams</li> <li>Embed PowerApps in SharePoint Online</li> <li>Start a Flow from a PowerApp</li> <li>Lab 1: PowerApp Integration</li> </ul> <h3>8 - ADMINISTRATION AND MAINTENANCE OF POWERAPPS</h3> <ul> <li>Identify which users have been using PowerApps</li> <li>Reuse an app in another location (move from testing or development to production)</li> <li>Review app usage</li> <li>Prevent a user from using PowerApps</li> <li>Manage environments</li> <li>Lab 1: Administration and Maintenance</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55265 Microsoft PowerApps 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 55265 Microsoft PowerApps 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>

Microsoft Power Apps

Power Apps

Microsoft AZ-900

Microsoft Power Platform

Microsoft AZ-700

Microsoft Power Automate

55265 MicrosoftÂ© PowerApps

Manchester

Slough

Portsmouth

Bingley

Cardiff

Milton Keynes 

Nottingham

Birmingham

Bedford

Liverpool 

<div data-testid="richTextElement" style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">ONLINE STUDY - In your own time (approx. 6 hours study time) +</span></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></strong></span></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Awarding Body:</strong>&nbsp;Open College Network (OCN) Credit for Learning</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Award Level:</strong>&nbsp;Level 3 (Advanced Level) - Ireland Level 5</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">CPD Certified:</strong>&nbsp;Yes (CPD Accreditation)</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Minimum Age:&nbsp;</strong>18 (16 with parental consent)</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry requirements:&nbsp;</strong>None. (English Level 2 desirable)</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Training Locations:</strong>&nbsp;Study online + Classroom</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">&nbsp;</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(255, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(255, 0, 0);">OCN Accredited at UK Level 3 (Ireland Level 5)</span><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">&nbsp;</p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PART 1 - Theory:</strong>&nbsp;Complete this part of your course online at home or work in your own time (stop and start learning when it suits you). Can be completed on multiple devices - smart phones, kindle, laptop, tablet etc.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PART 2 - Skills and Practical Development:</strong><br fr-original-style="" style="box-sizing: border-box;">Safely and competently set up and maintain a Peripheral IV Infusion.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Attend a classroom location to complete your practical training.<br fr-original-style="" style="box-sizing: border-box;"></strong></p><div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></span></p></div><div style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Itinerary:</strong></div><div style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></div><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PART 1 - THEORY (ONLINE)</strong><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M1 - Peripheral IV Cannulation - Introduction:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Definitions - understanding terminology relating to PIVC.<br fr-original-style="" style="box-sizing: border-box;">IV Therapy and NMC guidelines.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M2 - Legal &amp; Professional Responsibilities:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Legal Obligations and Accountability. Criminal, Civil and<br fr-original-style="" style="box-sizing: border-box;">Contractual law in Healthcare. Vicarious Liability and your<br fr-original-style="" style="box-sizing: border-box;">Duty of Care.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M3 - Anatomy &amp; Physiology:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Sites appropriate to IV cannulation. Hand vs. arm.<br fr-original-style="" style="box-sizing: border-box;">Advantages and disadvantages of relevant veins.<br fr-original-style="" style="box-sizing: border-box;">An overview of Homeostasis and Fluid Balance.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M4 - Hygiene and Infection Prevention &amp; Control (IPC):</strong></span><br fr-original-style="" style="box-sizing: border-box;">Reducing healthcare-associated infections. Keeping Safe.<br fr-original-style="" style="box-sizing: border-box;">Bloodborne Pathogens and Work Practice Controls.<br fr-original-style="" style="box-sizing: border-box;">Standard Precautions. Waste Disposal. Needle-stick injuries.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M5 - Indications and Advantages:</strong></span><br fr-original-style="" style="box-sizing: border-box;">When to cannulate, infusion types and benefits over<br fr-original-style="" style="box-sizing: border-box;">alternative infusion routes. Continuous and intermittent infusion.<br fr-original-style="" style="box-sizing: border-box;">Prophylactic use before procedures and in unstable patients.<br fr-original-style="" style="box-sizing: border-box;">Contraindications.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M6 - Equipment:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Cannula types, sizes and colour coding. How to select<br fr-original-style="" style="box-sizing: border-box;">appropriate size. Equipment overview for total procedure.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M7 - Vein Choice for Cannulation:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Correct vein selection. Which veins to avoid.<br fr-original-style="" style="box-sizing: border-box;">How to manage an unsuccessful cannulation.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M8 - Procedures:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Full procedure for cannulation including correct documentation.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M8: Guide to Cannulation - revision</strong></span><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M8: Video - Recap with full procedure</strong></span><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M9 - Contraindications:</strong></span><br fr-original-style="" style="box-sizing: border-box;">When inappropriate to cannulate including patients with specific health conditions.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 128, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 128, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">M10 - Complications:</strong></span><br fr-original-style="" style="box-sizing: border-box;">A detailed look at potential complications during and after<br fr-original-style="" style="box-sizing: border-box;">cannulation, including phlebitis, infections, petechiae and haematomas. Clinical signs and corrective actions.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED</strong><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">BEFORE JOINING US FOR YOUR PRACTICAL TRAINING</strong><br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">PART 2 (CLASSROOM:</span><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong></strong><br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">1 - Welcome, introductions and overview:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Classroom - registration and introductions.<br fr-original-style="" style="box-sizing: border-box;">Virtual Classroom - audio/visual checks and registration.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">2 - Legal &amp; Professional Responsibilities:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Overview and discussion.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">3 - Anatomy - key points (appropriate to PIVC):</strong></span><br fr-original-style="" style="box-sizing: border-box;">Arteries and veins. Selecting an approprate site. Sites to avoid and &ldquo;first choice&rdquo; sites.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">4 - Cannulae - selection and types:</strong></span><br fr-original-style="" style="box-sizing: border-box;">A detailed look at different types of cannulas, respective benefits and attributes. Selectinng an appropriate pVAD.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">5 - Complications:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Complications of pVAD insertion including examples of<br fr-original-style="" style="box-sizing: border-box;">infiltration, haematoma, extravasation and transfixation.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">6 - VIP Score:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Understanding and using the Visual Infusion Phlebitis score.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">7 - Equipment - overview:</strong></span><br fr-original-style="" style="box-sizing: border-box;">We take a look at all essential equipment required for PIVC.<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">8 - PRACTICAL SESSIONS:</strong><br fr-original-style="" style="box-sizing: border-box;">Multiple practical sessions throughout the session.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">9 - Fluids:</strong></span><br fr-original-style="" style="box-sizing: border-box;">The importance of understanding fluids. Includes detailed overview of: maintenance fluids, Hartmann&rsquo;s solution, Colloids (and risks), blood products.<br fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(128, 0, 128); box-sizing: border-box;" fr-original-style=" color: rgb(128, 0, 128);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">10 - Infusion Rates:</strong></span><br fr-original-style="" style="box-sizing: border-box;">Calculating infusion rates and drops per minute.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">This course is supported with downloadable resources and may include extra video segments to reinforce your practical training.</em></strong></p><p style="color: rgb(85, 85, 85); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);">&nbsp;</p><div style="color: rgb(85, 85, 85); box-sizing: border-box;" fr-original-style=" color: rgb(85, 85, 85);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">(THE COURSE DELIVERY AWARDS SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR VIRTUAL CLASSROOM COURSE VERSION)</strong></em></p></div></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>

ONLINE STUDY - In your own time (approx. 6 hours study time) +
CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)



Awarding Body: Open College Network (OCN) Credit for Learning
Award Level: Level 3 (Advanced Level) - Ireland Level 5
CPD Certified: Yes (CPD Accreditation)
Minimum Age: 18 (16 with parental consent)
Entry requirements: None. (English Level 2 desirable)
Training Locations: Study online + Classroom
 
OCN Accredited at UK Level 3 (Ireland Level 5)

 
PART 1 - Theory: Complete this part of your course online at home or work in your own time (stop and start learning when it suits you). Can be completed on multiple devices - smart phones, kindle, laptop, tablet etc.

PART 2 - Skills and Practical Development:
Safely and competently set up and maintain a Peripheral IV Infusion.


Attend a classroom location to complete your practical training.


Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.


Course Itinerary:
PART 1 - THEORY (ONLINE)
M1 - Peripheral IV Cannulation - Introduction:
Definitions - understanding terminology relating to PIVC.
IV Therapy and NMC guidelines.
M2 - Legal & Professional Responsibilities:
Legal Obligations and Accountability. Criminal, Civil and
Contractual law in Healthcare. Vicarious Liability and your
Duty of Care.
M3 - Anatomy & Physiology:
Sites appropriate to IV cannulation. Hand vs. arm.
Advantages and disadvantages of relevant veins.
An overview of Homeostasis and Fluid Balance.
M4 - Hygiene and Infection Prevention & Control (IPC):
Reducing healthcare-associated infections. Keeping Safe.
Bloodborne Pathogens and Work Practice Controls.
Standard Precautions. Waste Disposal. Needle-stick injuries.
M5 - Indications and Advantages:
When to cannulate, infusion types and benefits over
alternative infusion routes. Continuous and intermittent infusion.
Prophylactic use before procedures and in unstable patients.
Contraindications.
M6 - Equipment:
Cannula types, sizes and colour coding. How to select
appropriate size. Equipment overview for total procedure.
M7 - Vein Choice for Cannulation:
Correct vein selection. Which veins to avoid.
How to manage an unsuccessful cannulation.
M8 - Procedures:
Full procedure for cannulation including correct documentation.
M8: Guide to Cannulation - revision
M8: Video - Recap with full procedure
M9 - Contraindications:
When inappropriate to cannulate including patients with specific health conditions.
M10 - Complications:
A detailed look at potential complications during and after
cannulation, including phlebitis, infections, petechiae and haematomas. Clinical signs and corrective actions.

PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED
BEFORE JOINING US FOR YOUR PRACTICAL TRAINING

PART 2 (CLASSROOM:
1 - Welcome, introductions and overview:
Classroom - registration and introductions.
Virtual Classroom - audio/visual checks and registration.
2 - Legal & Professional Responsibilities:
Overview and discussion.
3 - Anatomy - key points (appropriate to PIVC):
Arteries and veins. Selecting an approprate site. Sites to avoid and “first choice” sites.
4 - Cannulae - selection and types:
A detailed look at different types of cannulas, respective benefits and attributes. Selectinng an appropriate pVAD.
5 - Complications:
Complications of pVAD insertion including examples of
infiltration, haematoma, extravasation and transfixation.
6 - VIP Score:
Understanding and using the Visual Infusion Phlebitis score.
7 - Equipment - overview:
We take a look at all essential equipment required for PIVC.
8 - PRACTICAL SESSIONS:
Multiple practical sessions throughout the session.
9 - Fluids:
The importance of understanding fluids. Includes detailed overview of: maintenance fluids, Hartmann’s solution, Colloids (and risks), blood products.
10 - Infusion Rates:
Calculating infusion rates and drops per minute.

This course is supported with downloadable resources and may include extra video segments to reinforce your practical training.
 
(THE COURSE DELIVERY AWARDS SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR VIRTUAL CLASSROOM COURSE VERSION)



Geopace Training

Allied Health Professions (AHP)

Intravenous Cannulation

Aesthetics

Medicine & Nursing

Venepuncture & Cannulation

Learn how to cannulate ...

    Nationally Recognised Qualification

    OCN Accredited - Level 3 (advanced) - Ireland Level 5

    CPD Accredited - The CPD Certification Service

    Classroom or Virtual Classroom options

    Covers all steps for cannulating in arm or hand

    Practise on artificial arms and fake blood!

    Essential qualification for all IV therapies

    Phlebotomy training desirable but not essential

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Peripheral I.V. Cannulation Course (GPT008)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is another One-Day course that is intended for the most ambitious modellers in the property industry, with a focus on constructing a flexible Real Estate Debt Model. This Real Estate Finance course follows on perfectly from our Real Estate Analyst and Real Estate Developer training courses.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course delegates will...</strong></strong><br fr-original-style="" style="box-sizing: border-box;">&bull; Learn how to build senior debt models with geared net cash flow.<br fr-original-style="" style="box-sizing: border-box;">&bull; Explore and assess the influence of complex debt structures on returns.<br fr-original-style="" style="box-sizing: border-box;">&bull; Develop advanced mezzanine debt models affecting project cash flows.<br fr-original-style="" style="box-sizing: border-box;">&bull; Model joint venture structures for optimised partnerships.<br fr-original-style="" style="box-sizing: border-box;">&bull; Calculate promote and profit share structures in Real Estate transactions.<br fr-original-style="" style="box-sizing: border-box;">&bull; Construct sophisticated project cash flow models with mezzanine debts.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong><br fr-original-style="" style="box-sizing: border-box;">&bull; Real Estate Professionals who have had exposure to Real Estate financial models<br fr-original-style="" style="box-sizing: border-box;">&bull; Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis<br fr-original-style="" style="box-sizing: border-box;">&bull; Real Estate Developers<br fr-original-style="" style="box-sizing: border-box;">&bull; Financial Analysts<br fr-original-style="" style="box-sizing: border-box;">&bull; Investment Managers<br fr-original-style="" style="box-sizing: border-box;">&bull; Banking and Finance Professionals in Real Estate</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></strong><br fr-original-style="" style="box-sizing: border-box;">&bull; Mathematics of amortisation and debt finance.<br fr-original-style="" style="box-sizing: border-box;">&bull; Basic senior debt models and geared net cash flow.<br fr-original-style="" style="box-sizing: border-box;">&bull; Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics.<br fr-original-style="" style="box-sizing: border-box;">&bull; Mezzanine debt modelling.<br fr-original-style="" style="box-sizing: border-box;">&bull; Joint Venture structures between developers and lender/equity partners.<br fr-original-style="" style="box-sizing: border-box;">&bull; Promote and profit share structure calculations.<br fr-original-style="" style="box-sizing: border-box;">&bull; Advanced project cash flows with mezzanine debt.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">A Bayfield Training Certificate</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Files</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Finance such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.
This is another One-Day course that is intended for the most ambitious modellers in the property industry, with a focus on constructing a flexible Real Estate Debt Model. This Real Estate Finance course follows on perfectly from our Real Estate Analyst and Real Estate Developer training courses.

On this course delegates will...
• Learn how to build senior debt models with geared net cash flow.
• Explore and assess the influence of complex debt structures on returns.
• Develop advanced mezzanine debt models affecting project cash flows.
• Model joint venture structures for optimised partnerships.
• Calculate promote and profit share structures in Real Estate transactions.
• Construct sophisticated project cash flow models with mezzanine debts.

Who will benefit from this course?
• Real Estate Professionals who have had exposure to Real Estate financial models
• Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis
• Real Estate Developers
• Financial Analysts
• Investment Managers
• Banking and Finance Professionals in Real Estate

Course Outline
• Mathematics of amortisation and debt finance.
• Basic senior debt models and geared net cash flow.
• Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics.
• Mezzanine debt modelling.
• Joint Venture structures between developers and lender/equity partners.
• Promote and profit share structure calculations.
• Advanced project cash flows with mezzanine debt.


Included in the Course
A Bayfield Training Certificate
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Finance such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Bayfield Training

Financial Modelling & Analysis

Real Estate Finance

Financial Modelling

Financial Analysis

Professional Development

Continuous Professional Development (CPD)

This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.

Real Estate Finance (Debt Financing)

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This accredited seminar provides an introduction for employers, HR managers and supervisors to learn how domestic abuse can impact in the workplace.</p><div style="color: rgb(119, 119, 119); box-sizing: border-box;" fr-original-style=" color: rgb(119, 119, 119);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Did you know&hellip;. Domestic Abuse costs UK businesses &pound;14 billion per year. (Home Office &ndash; July 2021)</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This training seminar provides an opportunity for employers, HR managers, supervisors, and team leaders to learn how domestic abuse can impact in the business as well as the next steps to support your staff and protect your business.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By attending this event you will gain an</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull; Increased understanding of domestic abuse</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull; Increased understanding of the legal and safety implications for employers</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull; Next steps on how your workplace can become accredited as a &lsquo;Safe Space to Work&rsquo;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This on-line training workshop will introduce the social, health and legal context, employers&rsquo; responsibilities and awareness of the economic impact of domestic abuse. By the end of the session attendees will feel confident in taking the next steps to ensure their workplace is a Safe Space.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This training workshop will provide the first step towards understanding a many layered and complex subject.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">CPD credits are awarded with this workshop.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Attendees will receive handouts and a certificate (if required).</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This event is hosted by Julie Johns MBE. </p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The workshop will be delivered as a 1 hour live Zoom event and is being offered at &pound;30 per person. </p></div>

Safe Space Consultancy

Safeguarding

Domestic Violence

This 1 hour on-line training seminar provides an opportunity for employers, HR managers, supervisors, and team leaders to learn how domestic abuse can impact on an employee and the business as well as the next steps to support your staff and protect your business.

An Introduction to Workplace Domestic Abuse Training (CPD Accredited)

Early Bird

<p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(var(--color_25));">This CPD accredited Threat Management TACCP course is typically completed as a bolt-on to the BRCGS Vulnerability Assessment for Food Fraud (VAFF) course, though it can be attended as a stand alone course. It looks at the various methodologies for risk assessing and managing threats which could be malicious or fraudulent in nature.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">While the BRCGS VAFF course specifically covers fraud, TACCP is not included and so this course is complimentary and gives attendees of both courses a comprehensive qualification.&nbsp;</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Attendees will receive an STC certificate of achievement for TACCP on successful completion of the course assignment (which is typically combined with the BRCGS VAFF assignment if attended as a bolt-on course, but can also be completed alone).</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">A number of tools, tips and templates are provided so that attendees can confidently produce meaningful risk assessments and implement sensible and effective control measures.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">This course has been accredited by the CPD Accreditation Office for delivery, structure and content.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">By the end of this course you will:</p><ul style="color: rgb(var(--color_25)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));"><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Understand TACCP &ndash; threat assessment and threat management</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Know and be able to apply the risk assessment methodologies</p></li></ul>

Ask Sonia Limited

Food Safety

HACCP

CPD accredited Threat Management TACCP course. 
Delivered online (Zoom) by a live tutor.
Exam and Certificate fee included in the price.

CPD Accredited Threat Management TACCP (2-3 hours)

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>The Power BI in a Day course is designed for beginners and intermediate users of Power BI.</p>Overview<p>#NAME?</p><p>Students will discover the full capabilities of Power BI in a one-day, hands-on workshop. Please Note: This workshop is primarily self-directed and students will work at their own pace while having access to an instructor for questions.</p></div><div id="course-pills-2"><h3>1 - Accessing &amp; Preparing data</h3> <ul> <li>Data Set</li> <li>Power BI Desktop</li> <li>Power BI Desktop ? Accessing Data</li> <li>Power BI Desktop ? Data Preparation</li> </ul> <h3>2 - Data Modeling and Exploration</h3> <ul> <li>Power BI Desktop ? Data Modeling and Exploration</li> <li>Power BI Desktop ? Data Exploration Continued</li> <li>References</li> </ul> <h3>3 - Data Visualization</h3> <ul> <li>Power BI Desktop</li> <li>Power BI Desktop ? Data Visualization</li> <li>References</li> </ul> <h3>4 - Publishing &amp; Accessing Reports</h3> <ul> <li>Power BI Desktop ? Creating Mobile View</li> <li>Power BI Service</li> <li>Power BI Service ? Publishing Report</li> <li>Power BI Mobile ? Accessing Report on Mobile Device</li> <li>Power BI Service ? Collaboration and Distribution</li> <li>References</li> </ul> <h3>5 - Dashboard and Collaboration</h3> <ul> <li>Power BI Service</li> <li>Building Dashboard</li> <li>References</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Power BI: Dashboard in a Day 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 Power BI: Dashboard in a Day 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>

Powerbi

Tableau Desktop Specialist

Business Analytics & Intelligence

Microsoft Power BI

Microsoft BI

Power BI: Dashboard in a Day

Southend on Sea

Rotherham

Paisley

Luton

Northampton

Swansea

BASIC to ADVANCED COURSE PACKAGE

Complete 3 courses over 2 full days and receive three qualifications:

Introduction to Phlebotomy Certificate (Nationally Recognised Level 3, Ireland Level 5)
Days 1 and 2: 9.30am – 5.00pm

Advanced Phlebotomy Certificate (Nationally Recognised Level 4, Ireland Level 6)
Day 1: 5.30pm - 8.30pm

Geopace Certificate of Competency (Nationally Recognised Accredited, CPD Practical Skills)
Day 2: 5.30pm - 8.30pm

Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.






Key Facts & Summary:


COURSE 1: INTRODUCTION TO PHLEBOTOMY COURSE - NATIONALLY RECOGNISED AND ACCREDITED VENEPUCTURE COURSE
UK Level Three (Ireland Level Five)
DUALLY ACCREDITED - Open College Network (OCN) and The CPD Certification Service (21 CPD Points)

PART 1 (DAY 1) - 9.30am to 5.00pm
PART 2 (DAY 2) - 9.30am to 5.00pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

A TWO DAY venepuncture course at Level 3. Trains up to the point of live blood draws.

On completion awards a Nationally Recognised and Accredited Certificate in Phlebotomy.

DAY ONE (PART 1) - THEORY
Attend the course location of your choice – starts at 9.30am and finishes approx. 5.00pm

DAY TWO (PART 2) - CLASSROOM
Your classroom tutor will recap on the theory element (above) after which you will begin your practical sessions learning and developing the skills required up to the point of Live Blood Draws.

DOWNLOAD A COURSE ITINERARY HERE



COURSE 2: ADVANCED PHLEBOTOMY COURSE - NATIONALLY RECOGNISED AND ACCREDITED VENEPUCTURE COURSE
UK Level Four (Ireland Level 6)
DUALLY ACCREDITED - Open College Network (OCN) and The CPD Certification Service (14 CPD Points)

PART 1 - THEORY
Complete your theory training online in the comfort of your own home or at work.

PART 2 - CLASSROOM
Follow on from your Day One Theory training, in the evening, from 5.30pm - 8.30pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

Skills and Practical Development:
Covers advanced specialised phlebotomy techniques to give you the leading edge as a phlebotomist. Learn to use a wide range of non-routine equipment.

On completion awards a Nationally Recognised and Accredited Certificate in Advanced Phlebotomy.

DOWNLOAD A COURSE ITINERARY HERE



COURSE 3: ROUTE TO COMPETENCY MASTERCLASS
CPD ACCREDITED - The CPD Certification Service

CLASSROOM
Follow on from your Day Two practical training, in the evening, from 5.30pm - 8.30pm

Adheres to World Health Organisation guidelines (meets or exceeds all guidelines) and Skills for Health Directive HSC376

GEOPACE LIVE BLOOD SESSIONS enabling you to draw human blood under 1-to-1 supervision of your tutor. You will follow a Competency Checklist, signed off by your tutor on completion.

On completion awards a Geopace Certificate of Competency - Nationally Recognised and Accredited Route to Competency - Live Blood Draws Certificate

DOWNLOAD A COURSE ITINERARY HERE




How do I attend?

EITHER -
CLASSROOM OPTION - Attend one of our scheduled classroom locations, completing your Introduction to Phlebotomy Course over 2 days. You will also complete your Advanced Training at the end of the first day and your Competency Training at the end of the second day.

Our Introduction to Phlebotomy and Advanced Phlebotomy Training Kits are supplied at no charge when booking our virtual classroom training option.
If you would like to add one or both of these kits to your classroom training option then these are available to add at time of booking. Our comprehensive training kits each mirror the same equipment and supplies used in the classroom and both include detailed video tutorials, allowing you to continue to practice and "hone" your skills after you have completed your practical training.

OR -

VIRTUAL CLASSROOM OPTION- Complete your theory training online at home or work, then join us for a one day Zoom session to complete your Introduction to Phlebotomy virtual classroom training, followed by your Advanced Training in the evening of the same day. You have the option to add a classroom-based competency session, awarding a CPD Accredited Geopace Certificate of Competency, at time of booking.

Our Virtual Classroom option includes two very comprehensive training kits - one for your introductory course and one for your advanced course. Kits are included at no charge (normally £79.95 each) and are yours to keep and to continue to practice with after you have finished your courses. The equipment and supplies included in your kits are the same as those used if you choose the classroom option.

How do I book?

Choose whether you would like to attend in a classroom or if you would like to complete your training by virtual classroom.
Click on the Classroom - Booking Options or Virtual Classroom - Booking Options buttons below to see all upcoming dates and locations.

Please note - Competency Training
Our Route to Competency Masterclass - Live Blood Sessions can only be completed in a classroom environment. This is included when you book a classroom option. When booking the virtual classroom option you can choose to add this at time of booking. You will receive a voucher code to enable you to book onto any upcoming dates or locations. For most of our two day course we run our competency training at the end of the second day and therefore you should be able to complete your full training programme with us over two days.

If you are completing your training by virtual classroom please see our list of competency training locations here.

If you would like to "mix and match" your training dates and/or locations then please call our admin team on 01525 713377 who will be more than happy to put a training package together for you on dates and / or locations that suit you.

All courses are accredited and are Skills for Health & WHO compliant.

Allied Health

Blood Taking

Healthcare Workers

Venepuncture

Phlebotomist

Phlebotomy

Accredited Phlebotomy

Healthcare

THIS COURSE PACKAGE INCLUDES:
1: INTRODUCTION TO PHLEBOTOMY COURSE (GPT003) - Level 3 (Ireland Level 5)
2: ADVANCED PHLEBOTOMY COURSE (GPT005) - Level 4 (Ireland Level 6)
3: GEOPACE COMPETENCY CERTIFICATE - CPD Certified (optional with Virtual Classroom)

Learn how to take blood ... train as a Phlebotomist

FAST-TRACK YOUR PHLEBOTOMY TRAINING

WITH OUR

COMPLETE TRAINING PACKAGE

20% off -  Multi-Course Discount

    Cover all stages from beginner through to Level 4

    Available as Classroom or Virtual Classroom

    Complete your beginner to advanced training in 2 days

    Awards 2 accredited qualifications - Introduction to Phlebotomy and Advanced Phlebotomy qualifications

    Both courses are dually accredited (OCN & CPD)

    Geopace Certificate of Competency included with classroom attendance or available as an option when booking virtual classroom

    Covers all steps up to live blood draw

    Learn advanced skills and techniques

    Virtual Classroom options include comprehensive Practise@Home Training Kits (yours to keep)

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Phlebotomy Training - Beginner to Advanced PACKAGE

ONLINE STUDY + ONE DAY ZOOM SESSION
NO CLASSROOM ATTENDANCE REQUIRED


Awarding Body: Dual Accreditation - Open College Network (OCN Credit4Learning) & The CPD Certification Service (21 CPD Points)
 
Award Level: UK - Level Three (Advanced) + 21 CPD Points
Ireland Level Five (Advanced) + 21 CPD Points
 
Minimum Age: 18 (16 with parental consent)
 
Entry requirements: None. English Level 2 desirable
 
Training Locations: Study online + virtual classroom.
 
Practical Training: Includes FREE Practise@Home Phlebotomy Training Kit worth £79.99
This comprehensive 76 piece practical training kit includes mini-arm trainer, sharps container and all medical grade supplies needed as well as a step-by-step 30 minute training video.



PART 1 (THEORY) - STUDY AT HOME ONLINE :
Complete your theory training online in the comfort of your own home or at work. Stop/start when it suits you and complete the online modules at your own pace. Can be completed on multiple devices such as laptop, smart-phone, desktop computer, kindle, tablet etc.
 
PART 2 (PRACTICAL SESSIONS) - JOIN US FOR A COMPREHENSIVE ONE DAY ZOOM SESSION:
Full instructions will be provided. We will send you a completely free Practise@Home Phlebotomy Training Kit, including a mini-arm trainer, for you to keep. You will follow your tutor's on-screen instructions during your Zoom virtual classroom sessions as you learn and develop your phlebotomy skills. The procedures and practices taught online are exactly the same as you would learn in the classroom. At any time before or after your course you can watch our 30 minute step-by-step video to refresh your knowledge and continue to use your training kit to practice your skills.
 
(THIS COURSE AWARDS THE SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR CLASSROOM AND HYBRID COURSE VERSIONS)


Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.


COURSE ITINERARY

 
A dually-accredited hybrid modular venepuncture course awarding an
OCN Accredited Level Three Certificate (3 credits) & 21 CPD Points


Nationally Recognised Qualification


Part 1 - online (eLearning) Part 2 - Virtual Classroom (1 Day Zoom)


PRE-COURSE
Home study pack - download and complete before the virtual classroom sessions

PART 1 - ONLINE
M01: Course Overview
M02: History, Definitions and Roles
M03: Work-flow cycles
M04: Professionalism
M05: Health & Safety
M06: Blood Collection Systems
M07: Anatomy & Physiology
M08: Blood Composition
M09: Using the equipment
M10: Performing the venepuncture - see Classroom Part 2
M11: Lab Tests and Bottle Types
M12: Analytical Errors
M13: Informal Quiz – answers
M14: Award – accredited certificates, value, application and overview. Job Opportunities.


PART 2 - VIRTUAL CLASSROOM (ONE DAY ZOOM SESSION)
M01: Introduction: Welcome, Introductions and Overview.
M10: Performing the venepuncture (theory overview)
P01: Practical Session 1 – Equipment familiarisation - "Tools of the Trade"
P02A: Practical Session 2A – Unpacking your training kit
P02B: Practical Session 2B - A look at the mini-arm trainer and associated equipment
P03: Practical Session 3 – Using the tourniquet and identifying a vein
P04: Practical Session 4 – Handling and assembling the equipment. Familiarisation and procedures including initial skill-set development
P05: Practical Session 5 - Further skill-set development and consolidation. Discussing needle types including winged infusion sets (butterfly needles)
P06A: Practical Session 6A – Performing the venepuncture on the mini-arm trainer. Palpating the vein, performing the venepuncture. Sample handling and labelling.
P06B: Practical Session 6B – Consolidating pre- and post-venepuncture procedures.
 
Additional support material can be downloaded as you progress through the course online.





ZOOM SESSION

VIRTUAL CLASSROOM (ZOOM) SESSIONS 
Our Virtual Classroom training course consists of online study (Part 1 - theory) and Virtual Classroom Zoom sessions (Part 2 - practical skill-set development)
You must complete your Part 1 online study before joining us for your Zoom session(s).
Once you have enrolled on this course you will be sent a free Practise@Home Training Kit, This is yours to keep and can be reused any many time as you wish after you have completed the course.
Your Booking Confirmation will include your Zoom log-in details.



Learn how to take blood ... train as a Phlebotomist

    Nationally Recognised Qualification

    No previous experience or qualifications needed

    OCN Accredited - Level 3 (advanced)

    CPD Accredited (The CPD Certification Service)

    Covers all steps up to live blood draw

    Practise on artificial arm and fake blood!

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Introduction to Phlebotomy Course (GPT003VC) - 1 DAY Virtual Classroom

39294 Courses

VMware vRealize Automation: Advanced Features and Troubleshooting [v8.x]

By Nexus Human

Oracle PeopleSoft Time and Labor - North America Rel. 9.2

By Nexus Human

VMware NSX Advanced Load Balancer: Infrastructure and Application Automation

By Nexus Human

Implementing Aruba OS-CX Switching, Rev. 20.21

By Nexus Human

Running Containers on Amazon Elastic Kubernetes Service (Amazon EKS)

By Nexus Human

Oracle 19c Database Administration I (DBA I) (TTOR20519)

By Nexus Human

Oracle 12c PL/SQL Fundamentals

By Nexus Human

Symantec Management Suite 7.6 - Implementation

By Nexus Human

Administering Cisco UCS X-Series Solutions with Intersight (INTUCSX)

By Nexus Human

VMware Telco Cloud: Day 2 Operate and Scale [V2.x]

By Nexus Human

Search By Location