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

Nexus Human

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

VMware Vsphere

Service Design Courses (SDC)

vSphere

Cloud Architecture

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

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

Oracle Primavera

Programming Fundamentals

Database Programming

Oracle 19c PL/SQL Fundamentals (TTOR12019)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Anyone who plans to work with Kubernetes at any level or tier of involvement<br />Any company or individual who wants to advance their knowledge of the cloud environment<br />Application Developers<br />Operations Developers<br />IT Directors/Managers</p>Overview<p>All topics required by the CKAD exam, including:<br />Deploy applications to a Kubernetes cluster<br />Pods, ReplicaSets, Deployments, DaemonSets<br />Self-healing and observable applications<br />Multi-container Pod Design<br />Application configuration via Configmaps, Secrets<br />Administrate cluster use for your team<br />A systematic understanding of Kubernetes architecture<br />Troubleshooting and debugging tools<br />Kubernetes networking and services</p><p>Kubernetes is a Cloud Orchestration Platform providing reliability, replication, and stability while maximizing resource utilization for applications and services. By the conclusion of this hands-on training, you will go back to work with all necessary commands and practical skills to empower your team to succeed, as well as gain knowledge of important concepts like Kubernetes architecture and container orchestration. We prioritize covering all objectives and concepts necessary for passing the Certified Kubernetes Application Developer (CKAD) exam. You will command and configure a high availability Kubernetes environment (and later, build your own!) capable of demonstrating all ?K8s'' features discussed and demonstrated in this course. Your week of intensive, hands-on training will conclude with a mock CKAD exam that matches the real thing.</p></div><div id="course-pills-2"><h4>Kubernetes Architecture</h4><ul><li>Components</li><li>Understand API deprecations</li><li>Containers</li><li>Define, build and modify container images</li><li>Pods</li><li>Master Services</li><li>Node Services</li><li>K8s Services</li><li>YAML Essentials</li><li>Creating a K8s Cluster</li></ul><h4>kubectl Commands</h4><ul><li>Kubernetes Resources</li><li>Kubernetes Namespace</li><li>Kubernetes Contexts</li></ul><h4>Pods</h4><ul><li>What is a Pod?</li><li>Create, List, Delete Pods</li><li>How to Access Running Pods</li><li>Kubernetes Resources</li><li>Managing Cloud Resource Consumption</li><li>Multi-Container Pod Design</li><li>Security Contexts</li><li>Init Containers</li><li>Understand multi-container Pod design patterns (e.g. sidecar, init and others)</li><li>Pod Wellness Tracking</li></ul><h4>Networking</h4><ul><li>Packet Forwarding</li><li>ClusterIP and NodePort Services</li><li>Provide and troubleshoot access to applications via services</li><li>Ingress Controllers</li><li>Use Ingress rules to expose applications</li><li>NetworkPolicy resource</li><li>Demonstrate basic understanding of NetworkPolicies</li><li>Network Plugins</li><li>Defining the Service Mesh</li><li>Service mesh configuration examples</li></ul><h4>ReplicaSets</h4><ul><li>Services</li><li>ReplicaSet Function</li><li>Deploying ReplicaSets</li></ul><h4>Deployments</h4><ul><li>Deployment Object</li><li>Updating/Rolling Back Deployments</li><li>Understand Deployments and how to perform rolling updates</li><li>Deployment Strategies</li><li>Use Kubernetes primitives to implement common deployment strategies (e.g. blue/green or canary)</li><li>Scaling ReplicaSets</li><li>Autoscaling</li></ul><h4>Labels and Annotations</h4><ul><li>Labels</li><li>Annotations</li><li>Node Taints and Tolerations</li></ul><h4>Jobs</h4><ul><li>The K8s Job and CronJob</li><li>Understand Jobs and CronJobs</li><li>Immediate vs. scheduled internal use</li></ul><h4>Application Configuration</h4><ul><li>Understanding and defining resource requirements, limits and quotas</li><li>Config Maps</li><li>Create &amp; consume Secrets</li><li>Patching</li><li>Custom Resource Definition</li><li>Discover and use resources that extend Kubernetes (CRD)</li><li>Managing ConfigMaps and Secrets as Volumes</li></ul><h4>Storage</h4><ul><li>Static and dynamic persistent volumes via StorageClass</li><li>K8s volume configuration</li><li>Utilize persistent and ephemeral volumes</li><li>Adding persistent storage to containers via persistent volume claims</li></ul><h4>Introduction to Helm</h4><ul><li>Helm Introduction</li><li>Charts</li><li>Use the Helm package manager to deploy existing packages</li></ul><h4>Application Security</h4><ul><li>Understand authentication, authorization and admission control</li><li>Understand ServiceAccounts</li><li>Understand SecurityContexts</li></ul><h4>Application Observability and Maintenance</h4><ul><li>Use provided tools to monitor Kubernetes applications</li><li>How to Troubleshoot Kubernetes</li><li>Basic and Advanced Logging Techniques</li><li>Utilize container logs</li><li>Accessing containers with Port-Forward</li><li>Debugging in Kubernetes</li></ul><h4>Hands on Labs:</h4><ul><li>Define, build and modify container images</li><li>Deploy Kubernetes using Ansible</li><li>Isolating Resources with Kubernetes Namespaces</li><li>Cluster Access with Kubernetes Context</li><li>Listing Resources with kubectl get</li><li>Examining Resources with kubectl describe</li><li>Create and Configure Basic Pods</li><li>Debugging via kubectl port-forward</li><li>Imperative vs. Declarative Resource Creation</li><li>Performing Commands inside a Pod</li><li>Understanding Labels and Selectors</li><li>Insert an Annotation</li><li>Create and Configure a ReplicaSet</li><li>Writing a Deployment Manifest</li><li>Perform rolling updates and rollbacks with Deployments</li><li>Horizontal Scaling with kubectl scale</li><li>Implement probes and health checks</li><li>Understanding and defining resource requirements, limits and quotas</li><li>Understand Jobs and CronJobs</li><li>Best Practices for Container Customization</li><li>Persistent Configuration with ConfigMaps</li><li>Create and Consume Secrets</li><li>Understand the Init container multi-container Pod design pattern</li><li>Using PersistentVolumeClaims for Storage</li><li>Dynamically Provision PersistentVolumes with NFS</li><li>Deploy a NetworkPolicy</li><li>Provide and troubleshoot access to applications via services</li><li>Use Ingress rules to expose applications</li><li>Understand the Sidecar multi-container Pod design pattern</li><li>Setting up a single tier service mesh</li><li>Tainted Nodes and Tolerations</li><li>Use the Helm package manager to deploy existing packages</li><li>A Completed Project</li><li>Install Jenkins Using Helm and Run a Demo Job</li><li>Custom Resource Definitions (CRDs)</li><li>Patching</li><li>Understanding Security Contexts for Cluster Access Control</li><li>Utilize container logs</li><li>Advanced Logging Techniques</li><li>Troubleshooting</li><li>Calicoctl</li><li>Deploy a Kubernetes Cluster using Kubeadm</li><li>Monitoring Applications in Kubernetes</li><li>Resource-Based Autoscaling</li><li>Create ServiceAccounts for use with the Kubernetes Dashboard</li><li>Saving Your Progress With GitHub</li><li>CKAD Practice Drill</li><li>Alta Kubernetes Course Specific Updates</li><li>Sourcing Secrets from HashiCorp Vault</li><li>Example CKAD Test Questions</li></ul></div>

CKAD

AWS Certification

AWS Certified Developer

Kubernetes

AWS Certified Cloud Practitioner

AWS Certified Solutions Architect

Kubernetes Bootcamp (CKAD)

<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 anyone who is new to software development and wants, or needs, to gain an understanding of the fundamentals of coding and basics of C++ and object-oriented programming concepts. This course is for Non-Developers, or anyone who wants to have a basic understanding of and learn how to code C++ applications and syntax</p>Overview<p>Companies are constantly challenged to keep their applications, development projects, products, services (and programmers!) up to speed with the latest industry tools, skills, technologies and practices to stay ahead in the ever-shifting markets that make up today's fiercely competitive business landscape.  The need for application, web and mobile developers and coders is seemingly endless as technologies regularly change and grow to meet the modern needs of demanding industries and clients.</p><p>C++ and Programming Basics for Non-Programmers is a five-day, basic-level training course geared for IT candidates who have little or no prior experience in computer programming. Throughout this gentle introduction to programming and C++, students will learn to create applications and libraries using C++ using best practices and sound OO development techniques for writing object-oriented programs in C++. Special emphasis is placed on object-oriented concepts and best practices throughout the training.</p></div><div id="course-pills-2"><h4>Fundamentals of the Program Development Cycle</h4><ul><li>Computer Architecture</li><li>The Notion of Algorithms</li><li>Source Code vs. Machine Code</li><li>Compile-Time vs. Run-Time</li><li>Software Program Architecture</li><li>Standalone</li><li>Client/Server</li><li>Distributed</li><li>Web-Enabled</li><li>IDE (Interactive Development Environment) Concepts</li><li>Looping Constructs</li><li>Counter-Controlled Repetition</li><li>Sentinel-Controlled Repetition</li><li>Nested Control Constructs</li><li>break and continue Statements</li><li>Structured Programming Best Practices</li><li></li></ul><h4>Writing Methods (Functions)</h4><ul><li>Static vs. Dynamic Allocation</li><li>Declaring Methods</li><li>Declaring Methods with Multiple Parameters</li><li>Method-Call Stack</li><li>Scope of Declarations</li><li>Argument Promotion and Casting</li><li>Designing Methods for Reusability</li><li>Method Overloading</li></ul><h4>Arrays</h4><ul><li>Purpose of Arrays</li><li>Declaring and Instantiating Arrays</li><li>Passing Arrays to Methods</li><li>Multidimensional Arrays</li><li>Variable-Length Argument Lists</li><li>Using Command-Line Arguments</li><li>Using Environment Variables</li></ul><h4>Deeper Into Classes and Objects</h4><ul><li>Controlling Access to Class Members</li><li>Referencing the Current Object Using this</li><li>Overloading Constructors</li><li>Default and No-Argument Constructors</li><li>Composition of Classes</li><li>Garbage Collection and Destructors</li><li>The finalize Method</li><li>Static Class Members</li></ul><h4>Defining Classes Using Inheritance Application Development Fundamentals</h4><ul><li>Structure of a C++ Program</li><li>Memory Concepts</li><li>Fundamental Data Type Declarations</li><li>Fundamental I/O Concepts</li><li>Fundamental Operators</li><li>Arithmetic Operators</li><li>Logical Operators</li><li>Precedence and Associativity</li><li>Building and Deploying a C++ Program</li><li>Superclasses and Subclasses</li><li>Advantages of Using Inheritance</li><li>protected Class Members</li><li>Constructors in Subclasses</li><li></li></ul><h4>Increasing Convenience by Using Polymorphism</h4><ul><li>Purpose of Polymorphic Behavior</li><li>The Concept of a Signature</li><li>Abstract Classes and Methods</li><li>final Methods and Classes</li><li>Purpose of Interfaces</li><li>Using and Creating Interfaces</li><li>Common Interfaces of the C++ API</li></ul><h4>Files and Streams</h4><ul><li>Concept of a Stream</li><li>Class File</li><li>Sequential Access</li><li>Object Serialization to/from Sequential Access Files</li></ul><h4>Fundamental Searching and Sorting</h4><ul><li>Introduction to Searching Algorithms</li><li>Linear Search</li><li>Binary Search</li><li>Introduction to Sorting Algorithms</li><li>Selection Sort</li><li>Insertion Sort</li><li>Merge Sort</li></ul><h4>Fundamental Data Structures</h4><ul><li>Dynamic Memory Allocation</li><li>Linked Lists</li><li>Stacks</li><li>Queues</li><li>Trees</li></ul><h4>Exception Handling</h4><ul><li>Types of Exceptions</li><li>Exception Handling Overview</li></ul><h4>Introduction to Classes and Objects</h4><ul><li>Classes, Objects and Methods</li><li>Object Instances</li><li>Declaring and Instantiating a C++ Object</li><li>Declaring Methods</li><li>set and get Methods</li><li>Initiating Objects with Constructors</li><li>Primitive Types vs. Reference Types</li></ul><h4>Flow Control</h4><ul><li>Conditional Constructs</li><li>Exception Class Hierarchy</li><li>Extending Exception Classes</li><li>When to Throw or Assert Exceptions</li></ul><h4>Formatted Output</h4><ul><li>printf Syntax</li><li>Conversion Characters</li><li>Specifying Field Width and Precision</li><li>Using Flags to Alter Appearance</li><li>Printing Literals and Escape Sequences</li><li>Formatting Output with Class Formatter</li></ul><h4>Strings, Characters and Regular Expressions</h4><ul><li>Fundamentals of Characters and Strings</li><li>String Class</li><li>String Operations</li><li>StringBuilder Class</li><li>Character Class</li><li>StringTokenizer Class</li><li>Regular Expressions</li><li>Regular Expression Syntax</li><li>Pattern Class</li><li>Matcher Class</li></ul><h4>Fundamental GUI Programming Concepts</h4><ul><li>Overview of Swing Components</li><li>Displaying Text and Graphics in a Window</li><li>Event Handling with Nested Classes</li><li>GUI Event Types and Listener Interfaces</li><li>Mouse Event Handling</li><li>Layout Managers</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans C Plus Plus and Programming Basics for Non-Programmers (TTCP2000) 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 C Plus Plus and Programming Basics for Non-Programmers (TTCP2000) 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>

Computing Skills

Computer Programming

C (programming language)

Trainers Course

C Plus Plus and Programming Basics for Non-Programmers (TTCP2000)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>If you are getting ready for a career as an entry-level information technology (IT) professional or personal computer (PC) service technician, the CompTIAÂ© A+Â© Certification course is the first step in your preparation.</p>Overview<p>In this course, you will install, configure, optimize, troubleshoot, repair, upgrade, and perform preventive maintenance on personal computers, digital devices, and operating systems. You will:Identify the hardware components of personal computers and mobile digital devices.Identify the basic components and functions of operating systems.Identify networking and security fundamentals.Identify the operational procedures that should be followed by professional PC technicians.Install, configure, and troubleshoot display devices.Install and configure peripheral components.Manage system components.Manage data storage.Install and configure Microsoft Windows.Optimize and maintain Microsoft Windows.Work with other operating systems.Identify the hardware and software requirements for client environment configurations.Identify network technologies.Install and configure networking capabilities.Support mobile digital devices.Support printers and multifunction devices.Identify security threats, vulnerabilities, and controls.Implement security controls.Troubleshoot system-wide issues.</p><p>In this course, you will acquire the essential skills and information you will need to install, upgrade, repair, configure, troubleshoot, optimize, and perform preventative maintenance of basic personal computer hardware and operating systems.</p></div><div id="course-pills-2"><h4>Hardware Fundamentals</h4><ul><li>Topic A: Personal Computer Components</li><li>Topic B: Storage Devices</li><li>Topic C: Mobile Digital Devices</li><li>Topic D: Connection Interfaces</li></ul><h4>Operating System Fundamentals</h4><ul><li>Topic A: PC and Mobile Operating Systems</li><li>Topic B: PC Operating System Tools and Utilities</li></ul><h4>Networking &amp; Security Fundamentals</h4><ul><li>Topic A: Network Types</li><li>Topic B: Network Components</li><li>Topic C: Common Network Services</li><li>Topic D: Cloud Concepts</li><li>Topic E: Security Fundamentals</li></ul><h4>Safety &amp; Operational Procedures</h4><ul><li>Topic A: Basic Maintenance Tools and Techniques</li><li>Topic B: Personal and Electrical Safety</li><li>Topic C: Environmental Safety and Materials Handling</li><li>Topic D: Professionalism and Communication</li><li>Topic E: Organizational Policies and Procedures</li><li>Topic F: Troubleshooting Theory</li></ul><h4>Supporting Display Devices</h4><ul><li>Topic A: Install Display Devices</li><li>Topic B: Configure Display Devices</li><li>Topic C: Troubleshoot Video and Display Devices</li></ul><h4>Installing &amp; Configuring Peripheral Components</h4><ul><li>Topic A: Install and Configure Input Devices</li><li>Topic B: Install and Configure Output Devices</li><li>Topic C: Install and Configure Input/Output Devices</li><li>Topic D: Install and Configure Expansion Cards</li></ul><h4>Managing System Components</h4><ul><li>Topic A: Identify Motherboard Components and Features</li><li>Topic B: Install and Configure CPUs and Cooling Systems</li><li>Topic C: Install Power Supplies</li><li>Topic D: Troubleshoot System Components</li></ul><h4>Managing Data Storage</h4><ul><li>Topic A: Identify RAM Types and Features</li><li>Topic B: Troubleshoot RAM Issues</li><li>Topic C: Install and Configure Storage Devices</li><li>Topic D: Configure the System Firmware</li><li>Topic E: Troubleshoot Hard Drives and RAID Arrays</li></ul><h4>Installing &amp; Configuring Microsoft Windows</h4><ul><li>Topic A: Implement Client-Side Virtualization</li><li>Topic B: Install Microsoft Windows</li><li>Topic C: Use Microsoft Windows</li><li>Topic D: Configure Microsoft Windows</li><li>Topic E: Upgrade Microsoft Windows</li></ul><h4>Optimizing &amp; Maintaining Microsoft Windows</h4><ul><li>Topic A: Optimize Microsoft Windows</li><li>Topic B: Back Up and Restore System Data</li><li>Topic C: Perform Disk Maintenance</li><li>Topic D: Update Software</li></ul><h4>Working with Other Operating Systems</h4><ul><li>Topic A: The OS X Operating System</li><li>Topic B: The Linux Operating System</li></ul><h4>Customized Client Enviroments</h4><ul><li>Topic A: Types of Common Business Clients</li><li>Topic B: Custom Client Environments</li></ul><h4>Networking Technologies</h4><ul><li>Topic A: TCP/IP Properties and Characteristics</li><li>Topic B: TCP/IP</li><li>Topic C: Internet Connections</li><li>Topic D: Ports and Protocols</li><li>Topic E: Networking Tools</li></ul><h4>Installing &amp; Configuring Networking Capabilities</h4><ul><li>Topic A: Configure Basic Windows Networking</li><li>Topic B: Configure Network Perimeters</li><li>Topic C: Using Windows Networking Features</li><li>Topic D: Install and Configure SOHO Networks</li></ul><h4>Supporting Mobile Digital Devices</h4><ul><li>Topic A: Install and Configure Exterior Laptop Components</li><li>Topic B: Install and Configure Interior Laptop Components</li><li>Topic C: Other Mobile Devices</li><li>Topic D: Mobile Device Accessories and Ports</li><li>Topic E: Mobile Device Connectivity</li><li>Topic F: Mobile Device Synchronization</li><li>Topic G: Troubleshoot Mobile Device Hardware</li></ul><h4>Supporting Printers &amp; Multifunction Devices</h4><ul><li>Topic A: Printer and Multifunction Technologies</li><li>Topic B: Install and Configure Printers</li><li>Topic C: Maintain Printers</li><li>Topic D: Troubleshoot Printers</li></ul><h4>Security Threats, Vulnerabilities, and Controls</h4><ul><li>Topic A: Common Security Threats and Vulnerabilities</li><li>Topic B: General Security Controls</li><li>Topic C: Mobile Security Controls</li><li>Topic D: Data Destruction and Disposal Methods</li></ul><h4>Implementing Security Controls</h4><ul><li>Topic A: Secure Operating Systems</li><li>Topic B: Secure Workstations</li><li>Topic C: Secure SOHO Networks</li><li>Topic D: Secure Mobile Devices</li></ul><h4>Troubleshooting System-Wide Issues</h4><ul><li>Topic A: Troubleshoot PC Operating Systems</li><li>Topic B: Troubleshoot Mobile Device Operating Systems and Applications</li><li>Topic C: Troubleshoot Wired and Wireless Networks</li><li>Topic D: Troubleshoot Common Security Issues</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Managing and Troubleshooting PCs - Part 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 Managing and Troubleshooting PCs - Part 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>

Computer Systems

CompTIA Network+

Computer Maintenance

Computer Skills

CompTIA A+

CompTIA Security+

Managing and Troubleshooting PCs - Part 2

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>Technical professionals with basic system administration skills and operators responsible for managing virtual machines<br />using VMware ESXiâ¢ and VMware vCenter Server</p>Overview<p>By the end of the course, you should be able to meet the following objectives:<br />Describe virtualization and virtual machines<br />Describe vSphere components and the software-defined data center (SDDC)<br />Explain the concepts of server, network, and storage virtualization<br />Monitor network and datastore configurations in VMware vSphere Clientâ¢<br />Deploy, configure, and clone virtual machines<br />Migrate, monitor, and manage virtual machines<br />Monitor tasks and events in VMware vSphere Clientâ¢<br />Recognize how vSphere DRS and VMware vSphere High Availability improve performance and availability of a<br />vSphere cluster</p><p>This three-day, hands-on training course is an introduction to VMware vSphereÂ©.  In this course, you acquire the skills needed to perform Day 2 operational tasks that are typically assigned to the roles of operator or junior administrator in a vSphere environment.</p></div><div id="course-pills-2"><h4>Course Introduction</h4><ul><li>Introductions and course logistics</li><li>Course objectives</li></ul><h4>Virtualization and vSphere Concepts</h4><ul><li>Describe how virtual machines (VMs) work</li><li>Recognize the purpose of a hypervisor</li><li>Describe how VMs share resources in a virtualized</li><li>environment</li><li>Recognize the components of an SDDC</li><li>Describe the relationship between vSphere, the</li><li>SDDC, and cloud computing</li><li>Recognize the functions of the components in a</li><li>vSphere environment</li><li>Access and view vSphere graphical user interfaces</li><li>Identify VMware solutions that integrate with</li><li>vSphere in the SDDC</li></ul><h4>Navigating the vSphere Client</h4><ul><li>View and organize the inventory objects managed</li><li>by vCenter Server</li><li>Add and assign vSphere licenses</li><li>Change the log level of vCenter Server</li><li>Edit the startup policy of ESXi services</li><li>Describe how vCenter Server roles and permissions work</li><li>Add permissions to virtual machines</li></ul><h4>Lifecycle of Virtual Machines</h4><ul><li>Add and remove VM virtual hardware components</li><li>Identify the purpose of different VM files</li><li>Configure VM settings</li><li>Create and delete virtual machines</li><li>Recognize the benefits of installing VMware Tools?</li><li>Install VMware Tools into a guest operating system</li><li>Upgrade VMware Tools and VM hardware</li><li>compatibility</li></ul><h4>vSphere Networking</h4><ul><li>Describe virtual networking</li><li>Recognize ways that virtual switches connect VMs and ESXi hosts to the network</li><li>View components and properties of a vSphere standard switch configuration</li><li>View a vSphere distributed switch configuration in vSphere Client</li><li>Recognize when and how to use the settings for</li><li>the security networking policy</li><li>Recognize when and how to use the settings for</li><li>the traffic shaping networking policy</li><li>Describe how the NIC teaming and failover policy helps maintain network connectivity</li><li>Perform basic checks to diagnose VM connectivity issues</li></ul><h4>vSphere Storage</h4><ul><li>Describe the function of a datastore</li><li>Recognize types of vSphere datastores</li><li>View datastore information in vSphere Client</li><li>Monitor datastore usage in vSphere Client</li></ul><h4> Virtual Machine Management </h4><ul><li>Recognize the benefits of using VM templates</li><li>Create and update a VM template</li><li>Deploy a VM from an existing template</li><li>Clone a virtual machine</li><li>Recognize how to use guest OS customization specifications</li><li>Deploy VMs from a content library</li><li>Deploy a virtual appliance from an OVF template</li><li>Perform a hot and cold migrations of VMs</li><li>Identify requirements for using VMware vSphereÂ© Storage vMotionÂ©</li><li>Perform a vSphere Storage vMotion migration</li><li>Identify use cases for VM snapshots</li><li>Create and manage snapshots of a virtual machine</li></ul><h4>Resource Monitoring</h4><ul><li>Recognize the purpose of each type of VM</li><li>resource control</li><li>Configure the resource allocation settings of a VM</li><li>Observe the behavior of virtual machines with</li><li>different share values</li><li>Manage and acknowledge vSphere alarms</li><li>Use performance charts to monitor VM CPU and</li><li>memory usage</li><li>Monitor tasks and events in vSphere Client</li></ul><h4>vSphere Clusters</h4><ul><li>View information about the services that a vSphere</li><li>cluster offers</li><li>Recognize how vSphere HA responds to different</li><li>types of failures</li><li>Monitor vSphere HA during a host failure</li><li>Describe how vSphere DRS works</li><li>Interpret DRS scores given to VMs</li><li>Recognize how to apply the appropriate vSphere</li><li>DRS automation and migration threshold levels</li><li>Describe how vSphere Fault Tolerance works</li><li>Recognize how Enhanced vMotion Compatibility works</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 Data Center Virtualization: Core Technical Skills 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 Data Center Virtualization: Core Technical Skills 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 Skills

Microsoft Virtual Academy (MVA)

VMware Data Center Virtualization: Core Technical Skills

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This in an intermediate and beyond-level course is geared for experienced Python developers looking to delve into the exciting field of Natural Language Processing. It is ideally suited for roles such as data analysts, data scientists, machine learning engineers, or  anyone working with text data and seeking to extract valuable insights from it. If you're in a role where you're tasked with analyzing customer sentiment, building chatbots, or dealing with large volumes of text data, this course will provide you with practical, hands on skills that you can apply right away.</p>Overview<p>This course combines engaging instructor-led presentations and useful demonstrations with valuable hands-on labs and engaging group activities. Throughout the course you'll:<br />Master the fundamentals of Natural Language Processing (NLP) and understand how it can help in making sense of text data for valuable insights.<br />Develop the ability to transform raw text into a structured format that machines can understand and analyze.<br />Discover how to collect data from the web and navigate through semi-structured data, opening up a wealth of data sources for your projects.<br />Learn how to implement sentiment analysis and topic modeling to extract meaning from text data and identify trends.<br />Gain proficiency in applying machine learning and deep learning techniques to text data for tasks such as classification and prediction.<br />Learn to analyze text sentiment, train emotion detectors, and interpret the results, providing a way to gauge public opinion or understand customer feedback.</p><p>The Hands-on Natural Language Processing (NLP) Boot Camp is an immersive, three-day course that serves as your guide to building machines that can read and interpret human language. NLP is a unique interdisciplinary field, blending computational linguistics with artificial intelligence to help machines understand, interpret, and generate human language. In an increasingly data-driven world, NLP skills provide a competitive edge, enabling the development of sophisticated projects such as voice assistants, text analyzers, chatbots, and so much more. Our comprehensive curriculum covers a broad spectrum of NLP topics. Beginning with an introduction to NLP and feature extraction, the course moves to the hands-on development of text classifiers, exploration of web scraping and APIs, before delving into topic modeling, vector representations, text manipulation, and sentiment analysis. Half of your time is dedicated to hands-on labs, where you'll experience the practical application of your knowledge, from creating pipelines and text classifiers to web scraping and analyzing sentiment. These labs serve as a microcosm of real-world scenarios, equipping you with the skills to efficiently process and analyze text data. Time permitting, you?ll also explore modern tools like Python libraries, the OpenAI GPT-3 API, and TensorFlow, using them in a series of engaging exercises. By the end of the course, you'll have a well-rounded understanding of NLP, and will leave equipped with the practical skills and insights that you can immediately put to use, helping your organization gain valuable insights from text data, streamline business processes, and improve user interactions with automated text-based systems. You?ll be able to process and analyze text data effectively, implement advanced text representations, apply machine learning algorithms for text data, and build simple chatbots.</p></div><div id="course-pills-2"><h4>Launch into the Universe of Natural Language Processing</h4><ul><li>The journey begins: Unravel the layers of NLP </li><li>Navigating through the history of NLP </li><li>Merging paths: Text Analytics and NLP </li><li>Decoding language: Word Sense Disambiguation and Sentence Boundary Detection </li><li>First steps towards an NLP Project</li></ul><h4>Unleashing the Power of Feature Extraction</h4><ul><li>Dive into the vast ocean of Data Types </li><li>Purification process: Cleaning Text Data </li><li>Excavating knowledge: Extracting features from Texts </li><li>Drawing connections: Finding Text Similarity through Feature Extraction </li></ul><h4>Engineer Your Text Classifier</h4><ul><li>The new era of Machine Learning and Supervised Learning </li><li>Architecting a Text Classifier </li><li>Constructing efficient workflows: Building Pipelines for NLP Projects </li><li>Ensuring continuity: Saving and Loading Models</li></ul><h4>Master the Art of Web Scraping and API Usage</h4><ul><li>Stepping into the digital world: Introduction to Web Scraping and APIs </li><li>The great heist: Collecting Data by Scraping Web Pages </li><li>Navigating through the maze of Semi-Structured Data</li></ul><h4>Unearth Hidden Themes with Topic Modeling</h4><ul><li>Embark on the path of Topic Discovery </li><li>Decoding algorithms: Understanding Topic-Modeling Algorithms </li><li>Dialing the right numbers: Key Input Parameters for LSA Topic Modeling </li><li>Tackling complexity with Hierarchical Dirichlet Process (HDP)</li></ul><h4>Delving Deep into Vector Representations</h4><ul><li>The Geometry of Language: Introduction to Vectors in NLP</li></ul><h4>Text Manipulation: Generation and Summarization</h4><ul><li>Playing the creator: Generating Text with Markov Chains </li><li>Distilling knowledge: Understanding Text Summarization and Key Input Parameters for TextRank </li><li>Peering into the future: Recent Developments in Text Generation and Summarization </li><li>Solving real-world problems: Addressing Challenges in Extractive Summarization</li></ul><h4>Riding the Wave of Sentiment Analysis</h4><ul><li>Unveiling emotions: Introduction to Sentiment Analysis Tools </li><li>Demystifying the Textblob library </li><li>Preparing the canvas: Understanding Data for Sentiment Analysis </li><li>Training your own emotion detectors: Building Sentiment Models</li></ul><h4>Optional: Capstone Project</h4><ul><li>Apply the skills learned throughout the course. </li><li>Define the problem and gather the data. </li><li>Conduct exploratory data analysis for text data. </li><li>Carry out preprocessing and feature extraction. </li><li>Select and train a model. ? Evaluate the model and interpret the results.</li></ul><h4>Bonus Chapter: Generative AI and NLP</h4><ul><li>Introduction to Generative AI and its role in NLP. </li><li>Overview of Generative Pretrained Transformer (GPT) models. </li><li>Using GPT models for text generation and completion. </li><li>Applying GPT models for improving autocomplete features. </li><li>Use cases of GPT in question answering systems and chatbots.</li></ul><h4>Bonus Chapter: Advanced Applications of NLP with GPT</h4><ul><li>Fine-tuning GPT models for specific NLP tasks. </li><li>Using GPT for sentiment analysis and text classification. </li><li>Role of GPT in Named Entity Recognition (NER). </li><li>Application of GPT in developing advanced chatbots. </li><li>Ethics and limitations of GPT and generative AI technologies.</li></ul></div>

Learning & Development

Natural Language Processing (NLP)

Neuro-Linguistic Programming (NLP)

NLP Practitioner

Central Law Training (CLT)

NLP Boot Camp / Hands-On Natural Language Processing  (TTAI3030)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is for all Oracle Professionals.  Specifically Database Administrators, Web Server Administrators, System Administrators, CIOs and  other IT Management Professionals.</p>Overview<p>Upon successful completion of this course, students will be able to perform many of the day-to-day administration tasks required of an Oracle database administrator.  This course introduces many of the powerful capabilities of the Oracle database.</p><p>In this course, students will learn about day-to-day administration tasks. It will also address administration sub-specialties.</p></div><div id="course-pills-2"><h4>Introduction: Managing the Database Instance</h4><ul><li>The Database Management Tools</li><li>EM Database Express</li><li>EM Cloud Control</li><li>SQL Developer</li><li>Database Administrator</li></ul><h4>Introduction: Database Architecture Review</h4><ul><li>Database Instance Configurations</li><li>Memory Structures</li><li>Process Structures</li><li>Storage Architecture</li></ul><h4>Introduction: Starting &amp; Stopping Databse Services</h4><ul><li>Start &amp; Stop the Database Listener</li><li>ABOUT DATABASE STARTUP/SHUTDOWN </li><li>SYSOPER </li><li>SYSDBA </li><li>DATABASE STATE &amp; STAGES </li><li>STARTUP WITH EM CLOUD CONTROL </li><li>STARTUP WITH SQL*PLUS </li><li>SHUTDOWN WITH EM CLOUD CONTROL </li><li>SHUTDOWN WITH SQL*PLUS </li><li>USING MS WINDOWS SERVICES</li></ul><h4>Introduction: Oracle Network Environment</h4><ul><li>Oracle Net Services Architecture</li><li>ORACLE NET CONFIGURATION ASSISTANT </li><li>ORACLE NET MANAGER </li><li>USING EM CLOUD CONTROL </li><li>ADVANCED NETWORK COMPRESSION </li><li>TROUBLESHOOTING NETWORK PROBLEMS</li></ul><h4>Introduction: Diagnostics &amp; Oracle Support</h4><ul><li>About Database Diagnostics</li><li>Fault Diagnosability Infrastructure</li><li>DATABASE INSTANCE HEALTH SNAPSHOT </li><li>THE SUPPORT WORKBENCH </li><li>PROACTIVE DATABASE HEALTH CHECKS </li><li>PACKAGE DIAGNOSTIC DATA </li><li>WORKING WITH THE KNOWLEDGE BASE</li></ul><h4>Storage: Tablespace Management</h4><ul><li>Starter Tablespaces</li><li>CREATE TABLESPACE WITH EM CC </li><li>CREATE TABLESPACE WITH SQL </li><li>MANAGE TABLESPACES WITH EM CC </li><li>MANAGE TABLESPACES WITH EM DE </li><li>MANAGE TABLESPACES WITH SQL </li><li>DROP TABLESPACE </li><li>ALTER TABLESPACE</li><li></li></ul><h4>Storage: Advanced Tablespace Management</h4><ul><li>Managing Temporary Tablespaces</li><li>TEMP TABLESPACE GROUPS WITH EM</li><li>TEMP TABLESPACE GROUPS WITH SQL</li><li>DEFAULT PERMANENT TABLESPACES</li><li>BIGFILE TABLESPACES</li><li>MANAGING THE SYSAUX TABLESPACE</li></ul><h4>Storage: Data Files &amp; Temp Files Management</h4><ul><li>Manage Data Files with EM</li><li>ACCESS METADATA WITH SQL</li><li>MANAGE DATA FILES WITH SQL</li><li>MANAGE TEMP FILES</li><li>ORACLE-MANAGED FILES (OMF)</li></ul><h4>Storage: UNDO Data &amp; UNDO Tablespaces</h4><ul><li>About UNDO Space Management</li><li>GUARANTEE UNDO RETENTION </li><li>MONITOR UNDO SPACE WITH SQL </li><li>USE THE EM UNDO ADVISOR</li></ul><h4>Security &amp; Schemas: Security Overview &amp; Database Privileges</h4><ul><li>Database Security Principles</li><li>DATABASE SYSTEM PRIVILEGES</li><li>DATABASE OBJECT PRIVILEGES</li><li>SUPER ADMINISTRATOR ROLES</li><li>PRIVILEGE ANALYSIS</li></ul><h4>Security &amp; Schemas: User Security</h4><ul><li>Create &amp; Manage User Accounts</li><li>MANAGE USERS WITH EM</li><li>MANAGE USERS WITH SQL</li><li>CREATE USER</li><li>ALTER USER</li><li>DROP USER</li><li>GRANT &amp; REVOKE PRIVILEGES</li><li>RESOURCE LIMITS VIA PROFILES</li><li>ALTER PROFILE</li><li>DROP PROFILE</li><li>PASSWORD MANAGEMENT VIA PROFILES</li><li>ROLE-BASED SECURITY MANAGEMENT</li><li>ALTER USER...DEFAULT ROLE</li><li>SET ROLE</li><li>DELEGATING PRIVILEGE AUTHORIZATION</li><li>WITH ADMIN OPTION &amp; System Privileges</li><li>WITH GRANT OPTION &amp; Object Privileges</li><li>PRINCIPLE OF LEAST PRIVILEGE CHECKLIST</li></ul><h4>Security &amp; Schemas: Database Auditing</h4><ul><li>Auditing Database Activity</li><li>Traditional Auditing</li><li>Unified Auditing</li><li>Create Audit Policy</li></ul><h4>Security &amp; Schemas: SQL Loader</h4><ul><li>Loader Concepts</li><li>Loader From the Command Line</li><li>control File Options</li><li>Load Methods</li><li>Loader Express Mode</li><li>Loader From EM</li></ul><h4>Security &amp; Schemas: Export &amp; Import</h4><ul><li>Manage Directory Objects</li><li>The Data Pump Architecture</li><li>Data Pump Export</li><li>Data Pump Import</li><li>Data Pump Dictionary Views</li><li>Using the EM CC Interface</li></ul><h4>Performance &amp; Availability: Managing Performance &amp; SQL Tuning</h4><ul><li>Management Advisory Framework</li><li>Performance Monitoring &amp; AWR</li><li>The SQL Tuning Advisor</li><li>Monitoring Exceptions with Metrics</li></ul><h4>Performance &amp; Availability: Data Concurrency</h4><ul><li>About System &amp; User Locks</li><li>Monitor &amp; Manage User Locks</li><li>Moitor Locks with Data Dictionary</li><li>Manage Locks with EM</li></ul><h4>Performance &amp; Availability: Backup  &amp; Recovery Concepts</h4><ul><li>Backup &amp; Recovery Structures</li><li>Managing REDO Data</li><li>Configuring for Recoverability</li><li>Instance Recovery</li><li>Recoverability Checklist</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle 12c Administration II 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 Administration II course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Oracle Fusion HCM

Oracle 12c Administration II

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

IT Certifications

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>

Design & Technology Courses (DT)

Data Skills

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

Symantec Management Suite 7.6 - Implementation

By Nexus Human

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

By Nexus Human

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

By Nexus Human

Oracle 19c PL/SQL Fundamentals (TTOR12019)

By Nexus Human

Kubernetes Bootcamp (CKAD)

By Nexus Human

C Plus Plus and Programming Basics for Non-Programmers (TTCP2000)

By Nexus Human

Managing and Troubleshooting PCs - Part 2

By Nexus Human

VMware Data Center Virtualization: Core Technical Skills

By Nexus Human

NLP Boot Camp / Hands-On Natural Language Processing (TTAI3030)

By Nexus Human

Oracle 12c Administration II

By Nexus Human

Search By Location