Name: Microsoft Access
Price: 1697 GBP
Availability: InStock

Redhill

<h3><b>Kubernetes for engineers training course description</b></h3>
      <p> This course covers how Kubernetes addresses the
challenges of distributed systems. Hands on sessions
follow all the major theory chapters.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	<li>Explain what Kubernetes is and how it works.</li>
																					<li>Create and run containers on Kubernetes using the
Docker image format and container runtime.</li>
                  </ul>
        <h5>
        <b>Kubernetes for engineers training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working with Docker or Kubernetes.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>Definitive Docker for engineers.</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Kubernetes for engineers training course contents</b></h3>
      <ul>
				<li>Introduction </li><p>
Velocity, Scaling your service and your teams, Abstracting your infrastructure.

</p><li>Creating and running containers </li><p>
Container images, Building application images with Docker, Storing images in a remote registry, The Docker container runtime.

</p><li>Deploying a Kubernetes cluster </li><p>
Installing Kubernetes on a public cloud provider, Installing Kubernetes locally using minikube, Running Kubernetes on Raspberry Pi, The Kubernetes client, Cluster components.

</p><li>Common kubectl Commands </li><p>
Namespaces, Contexts, Viewing Kubernetes API objects, Creating, Updating, and Destroying Kubernetes objects, Labelling and annotating objects, Debugging commands.

</p><li>Pods </li><p>
Pods in Kubernetes, Thinking with pods, The pod manifest, Running pods, Accessing your pod, Health checks, Resource management, Persisting data with volumes, Putting It all together.

</p><li>Labels and Annotations </li><p>
Labels, Annotations.

</p><li>Service Discovery </li><p>
What Is Service discovery? The service object, Looking beyond the cluster, Cloud integration, Advanced details.

</p><li>ReplicaSets </li><p>
Reconciliation loops, Relating pods and ReplicaSets, Designing with ReplicaSets, ReplicaSet Spec, Creating a ReplicaSet, Inspecting a ReplicaSet, Scaling ReplicaSets, Deleting ReplicaSets.

</p><li>DaemonSets </li><p>
DaemonSet scheduler, Creating DaemonSets, Limiting DaemonSets to specific nodes, Updating a DaemonSet, Deleting a DaemonSet.

</p><li>Jobs </li><p>
The job object, Job patterns.

</p><li>ConfigMaps and secrets </li><p>
ConfigMaps, Secrets, Naming constraints, Managing ConfigMaps and secrets.

</p><li>Deployments </li><p>
Your first deployment, Creating deployments, Managing deployments, Updating deployments, Deployment strategies, Deleting a deployment.

</p><li>Integrating storage solutions and Kubernetes </li><p>
Importing external services, Running reliable singletons, Kubernetes-native storage with StatefulSets.

</p><li>Deploying real-world applications </li><p>
Parse, Ghost, Redis.
</p>
      </ul>

Systems & Network Training

Network & Security

Network Engineer

Definitive Kubernetes for engineers

General Admission

<h3><b>Firewalls training course description</b></h3>
        <p>
     A technical hands on training course covering firewall technologies. This focuses on the whys and hows of firewall technology rather than looking at manufacturer specific issues.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
   <li>Design secure firewall protected networks.</li>
					     <li>Test firewalls.</li>
					     <li>Evaluate firewalls</li>
                         <li>Configure firewalls</li>
                  </ul>
        <h5>
        <b>Firewalls training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Technical staff wanting to learn about Filrewalls including: <br />
                    Technical network staff.<br />
                    Technical security staff.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>IP security foundation for engineers</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Firewalls training course contents</b></h3>
				<ul>	<li>Firewall introduction</li><p>
Security review, what is a firewall? What do
firewalls do? Firewall benefits, concepts. <br /><span>Hands on</span>
Configuring the network to be used in later labs,
launching various attacks on a target.
					</p><li>Firewall types</li><p>
Packet filtering, SPI, Proxy, Personal. Software
firewalls, hardware firewalls, blade based firewalls,
personal firewalls, which firewall should you use?
Firewall products. <br /><span>Hands on</span> Configuring a simple
firewall.
</p><li>Packet filtering firewalls</li><p>
Things to filter in the IP header, stateless vs.
stateful filtering. ACLs. Advantages of packet
filtering. <br /><span>Hands on</span> Configuring packet filtering
firewalls.
</p><li>Stateful packet filtering</li><p>
Stateful algorithms, packet-by-packet inspection,
application content filtering, tracks, special
handling (fragments, IP options), sessions with
TCP and UDP. Firewall hacking detection: SYN
attacks, SSL, SSH interception. <br /><span>Hands on</span> Stateful
packet inspection firewalls.
</p><li>Proxy firewalls</li><p>
Circuit level, application level, SOCKS. Proxy
firewall advantages and disadvantages. <br /><span>Hands on</span>
Proxy firewalls.
</p><li>Personal firewalls</li><p>
The role of personal firewalls, Windows XP,
Zonealarm. <br /><span>Hands on</span> Configuring a personal
firewall.
</p><li>Firewall architectures</li><p>
Home based, small office, enterprise, service
provider, what is a DMZ? DMZ architectures,
bastion hosts, multi DMZ. Virtual firewalls,
transparent firewalls. Dual firewall design, high
availability, load balancing, VRRP. <br /><span>Hands on</span>
Resilient firewall architecture.
</p><li>Securing communications</li><p>
VPNs, IPsec. Firewall configuration of VPNs,
integration of dedicated VPN devices and
firewalls. <br /><span>Hands on</span> IPSec VPN configuration.
</p><li>Testing firewalls</li><p>
Configuration checklist, testing procedure,
monitoring firewalls, logging, syslog. <br /><span>Hands on</span>
Testing firewalls. 

</p>
				</ul>

Definitive Firewalls for engineers

London

<h2>Portfolio Management Skills</h2>
<p>The main purpose of this workshop is to equip and enable people in a portfolio management office and PMO to effectively and efficiently support the Executive Leadership and Operational Management to plan, implement, manage, and evolve portfolio management in their organization. There is a deliberate focus on preparing you to become a strong and effective change advocate for meaningful portfolio management that delivers objective measurements of benefit contribution towards the strategic objectives to lead, manage, and continuously improve portfolio management governance, processes, and frameworks with and through the direction of a portfolio practice, principles, and delivery boards.</p><h3>What you Will Learn</h3>
<p>At the end of this program, you will be able to:</p>
<ul>
<li>Articulate the benefits of portfolio management</li>
<li>Link the initiatives in an organization with its strategic objectives</li>
<li>Participate in the introduction of portfolio management in an organization</li>
<li>Create or improve the portfolio governance structure</li>
<li>Lead the inventory of ongoing and new initiatives</li>
<li>Assist the executives in the prioritization of initiatives through the use of Multi-criteria Analysis and other selection tools</li>
<li>Support the executives in balancing the portfolio based on the optimal use of resources and priorities</li>
<li>Create a portfolio delivery plan</li>
<li>Define thresholds and variance reporting criteria</li>
<li>Assist the executives and the financial team in the definition of Stage Gate Funding</li>
<li>Lead the Stage Gate reviews</li>
<li>Analyze the benefits that are being realized by the initiatives</li>
</ul><section>
                    <h3>Foundation Concepts</h3><ul><li>Definitions</li><li>Benefits of Portfolio Management</li><li>Objectives of Portfolio Management</li><li>Portfolio Life Cycles</li></ul><h3>Governing the Portfolio</h3><ul><li>Portfolio Governance structure</li><li>Roles and responsibilities</li><li>Initial activities when starting portfolio management</li></ul><h3>Prioritizing Initiatives</h3><ul><li>Prioritize purpose</li><li>Multi-Criteria Analysis</li><li>Analytical Hierarchy Process (AHP)</li><li>Strategic alignment</li></ul><h3>Balancing the Portfolio</h3><ul><li>Allocating resources and budgets</li><li>Communicating decisions of initiatives status</li></ul><h3>Planning the Portfolio</h3><ul><li>Planning review cycles</li><li>Using Stage Gate Funding</li><li>Setting thresholds and variance reporting</li><li>Tool examples</li></ul><h3>Managing the Portfolio Delivery</h3><ul><li>Project and Program Life Cycles</li><li>Stage Gate Reviews</li><li>Loop back to Prioritize, Balance and Plan</li><li>Interaction with the Portfolio Delivery Board</li><li>Project, Program and Functional Managers' roles and responsibilities</li></ul>


                </section>

IIL Europe Ltd

Portfolio Management Skills

<h3><b>Transmission demystified training course description</b></h3> 
				<p>Transmission is the process of sending information along a medium of, copper, fibre or wireless. This course looks at transmission techniques for both telecommunications and data communications with a particular focus on Microwave, SDH, DWDM transmission. The course aims to demystify these technologies by explaining all the buzzwords used in transmission.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
          <li>Describe various transmission technologies such as multiplexing and demultiplexing.</li>
					<li>Explain how Microwave works.</li>
                    <li>Explain how SDH works.</li>
                    <li>Explain how DWDM works.</li>
                   
                  </ul>
       
        <h5>
        <b>Transmission demystified training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working in telecommunications.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None.</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Transmission demystified training course contents</b></h3>
      <ul>
				<li>Transmission basics</li><p>
Systems, media, signals. Signal degradation, noise, distortion, attenuation. Digital, analogue. Modulation, encoding.

</p><li>RF</li><p>
Frequency, wavelength. Distance / range issues, interference, Antenna, power, dB, RF propagation, testing.

</p><li>Microwave transmission</li><p>
What is microwave transmission, point to point communications, line of sight, parabolic antenna, relays, planning considerations, rain and other issues

</p><li>Wired transmissions</li><p>
Copper, Fibre, optical transmission, fibre characteristics, fibre component parts. Multi Mode Fibre (MMF). Single Mode Fibre (SMF). Fibre connections. Lasers. Attenuations, dispersion, optical signal noise ratios (OSNR) and their effects. Channel Spacing and Signal Direction. Limiting factors to single wavelength.

</p><li>Introduction to SDH</li><p>
Timing and synchronisation of digital signals, the plesiochronous digital hierarchy (PDH), the synchronous digital hierarchy (SDH), service protection with SDH. TDM.

</p><li>SDH6</li><p>
Standards, basic units, frames, STM1 frame, bit rates, STM0, STM1, STM4, STM16, STM64, STM256, SDH architecture, rings, Add drop multiplexors. SDH network topologies, structure of SDH equipment, SDH synchronisation, protection switching in SDH networks, SDH alarm structure, testing of SDH, equipment and systems, Ethernet over SDH.

</p><li>WDM overview</li><p>
Multiplexing, TDM, WDM benefits. WDM standards. CWDM vs. DWDM. Four Wave Mixing (FWM). Impact and countermeasures to FWM on WDM.tructure of SDH equipment, SDH synchronisation, protection switching in SDH networks, SDH alarm structure, testing of SDH, equipment and systems, Ethernet over SDH.

</p><li>DWDM</li><p>
ITU G.694.1, channel and spacing. Optical Terminal Multiplexers (OTM). Optical Add/Drop Multiplexers (OADM). Adding versus dropping. Optical Amplifiers. Erbium Doped Fibre Amplifiers (EDFA). Transponders and Combiners. Optical and Electrical Cross Connects (OXCs/DXCs). Cross Connect types (Transparent/Opaque). Advantages and disadvantages of various Optical cross connects.

	</p><li>IP transmission</li><p>
Telecommunications versus data communications, IP transmission, VoIP, MPLS.
</p>
      </ul>

Transmission demystified

<h3><b>SIP in IMS training course description</b></h3>
      <p>The IP Multimedia Core Network Subsystem (IMS) is defined by 3GPP as a new mobile infrastructure. This advanced course looks at the use of SIP in the IMS.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
				   <li>Describe the role of SIP in the IMS.</li>
					<li>Explain how SIP works in the IMS</li>
					<li>Describe the SIP architecture in the IMS.</li>
                    <li>Explain how SIP and SDP are used in basic IMS procedures.</li>
                  </ul>
        <h5>
        <b>SIP in IMS training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Technical telecommunications staff. </p>
              
							<li><b>Prerequisites:</b></li>
							
              <p> SIP for engineers.</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>SIP in IMS training course contents</b></h3>
      <ul>
				<li>Introduction </li><p>
SIP review, SIP elements, Simple SIP call flow, What is IMS? Why IMS? Why SIP in the IMS? SIP and IMS relationship.

</p><li>Standards </li><p>
3GPP, IETF, 3GPPr5, 3GPPr6, 3GPP SIP extensions.

</p><li>SIP and IMS </li><p>
IMS architecture, SIP interfaces.

</p><li>Server functions </li><p>
Registration, home and away, location and directory services, stateful and stateless servers.

</p><li>SIP servers </li><p>
P-CSCF, I-CSCF, S-CSCF, PSTN gateways

</p><li>SIP registration in the IMS </li><p>
SIP REGISTER, IMS identities, registration process, P-CSCF discovery, S-CSCF assignment, IMS subscriber and IMS registrar signalling flow. IMS routing in the registration process. Re and De-registration.

</p><li>SIP sessions in the IMS </li><p>
SIP INVITE, Establishing IMS SIP sessions, User at home network, user roaming, IMS offer answer architecture, SIP preconditions, QoS, reserving resources, IMS bearer network interactions, IMS subscriber and IMS service signalling flow. Typical call flows.

</p><li>SIP services in the IMS </li><p>
IMS specifications, IMS service procedures, call scenarios, call services. IMS multimedia related procedures. IMS presence, IMS messaging, IMS conferencing, IMS PoC.

</p><li>SIP-T </li><p>
SIP and the PSTN, URIs and ENUM, NAPTR, SRV, ISUP numbers and URI mapping, IAM and INVITE, SIP to PSTN/ISUP mapping, PSTN/ISUP to SIP mapping, PSTN to PSTN over SIP. MIME media types for ISUP, DTMF transmission, CLIP and CLIR in SIP, ring tone, split gateways

</p><li>SIP-I </li><p>
ISO standards, translation versus tunnelling.

</p><li>IMS SIP extensions </li><p>
Security (RFC 3310, 3329), Resource reservation (RFC 3312), Media authorisation (RFC 3313), SigComp (RFC 3320), P Headers (RFC 3325, 3455), Mobile registration (RFC 3327, 3608), Reg event (RFC 3680), Preconditions (RFC 4032)

</p><li>Security </li><p>
IMS security architecture, identities, HTTP digest, TLS. Affect of security on SIP media sessions.
</p>
      </ul>

Definitive SIP in the IMS for engineers

Loughborough

<div>
		

		<div>
			
			<p>Four half-day Leadership modules with mini work placed projects to bring the learning into action in the workplace.</p>
			<div><i></i> 4 x 180 Minutes</div>
			<div><i></i>  £1,995.00 incl. VAT</div>
			
			
		</div>
	</div>

	

	<div id="filters">
		
		
	</div>

	

    <div>

		
		 
		

		<div></div>

		<div>
			<p>Want to run this event in-house?  Enquire about running this event in-house </p>
			
		</div>

		<div>
			<p>Interested in attending? Have a suggestion about running this event near you?<br />Register your interest now</p>
			
		</div>
	</div>
	<div></div>
	
		
        <div>
			
		</div>
				

	
		<h3>Description</h3>
		<p></p><h3>Four half-day Leadership modules with mini work placed projects to bring the learning into action in the workplace.</h3>
<h3>Outcomes:</h3>
<div>
<ul>
<li>Create a personal development strategy that captures the whole of me</li>
<li>Attain the skills to lead teams through change, challenge and uncertainty</li>
<li>How to chose and use the right leadership approach using 'SLll (Situational Leadership)'</li>
<li>How to accelerate team performance using 'The Five Dysfunctions of a Team'</li>
</ul>
<p><strong>Available as private Face to Face and virtual sessions (max 12 delegates) - £4,362.50  Plus VAT</strong></p>
</div>
<p></p>
	
		<h3>Modules/Lessons</h3>
		<p></p><h3>Module 1 - Owning My Future Growth, Ambition and Performance:</h3>
<div>
<ul>
<li>Building my personal 'step-up' plan using the UpAGear Personal Programme</li>
</ul>
<h3>Module 2 - Leading in Times of Change and Challenge:</h3>
<div>
<ul>
<li>Creating the conditions for change to land and stick</li>
<li>Supporting others through change</li>
</ul>
<h3>Module 3 - Situational Leadership:</h3>
<div>
<ul>
<li>SLll introduction to the Accredited programme</li>
<li>Adapting leadership approach to team and individual development </li>
</ul>
<h3>Module 4 - Building Great Teams:</h3>
<div>
<ul>
<li>The 5 core elements of team development</li>
<li>Bringing them to life</li>
</ul>
<h3>Assessment</h3>
<div>
<ul>
<li>Prepare and deliver a 30-minute summary based on the key learning content from the Mastery Programme and how delegates will apply (recorded session)</li>
<li>Assessed by external facilitator against key criteria including feedback for ongoing development</li>
</ul>
</div>
</div>
</div>
</div>
</div>
<p></p>
	
		<h3>Prerequisites</h3>
		<p></p><p>Should have completed the Leadership Professional Intermediate Programme</p>
<p></p>
	
		<h3>Target Student</h3>
		<p></p><p>Managers looking to upskill and prepare for a leadership role.</p>
<p></p>

Mpi Learning - Professional Learning And Development Provider

Four half-day Leadership modules with mini work placed projects to bring the learning into action in the workplace.

Leadership Professional - Mastery Programme

<h2>Portfolio Management Skills: In-House Training</h2>
<p>The main purpose of this workshop is to equip and enable people in a portfolio management office and PMO to effectively and efficiently support the Executive Leadership and Operational Management to plan, implement, manage, and evolve portfolio management in their organization. There is a deliberate focus on preparing you to become a strong and effective change advocate for meaningful portfolio management that delivers objective measurements of benefit contribution towards the strategic objectives to lead, manage, and continuously improve portfolio management governance, processes, and frameworks with and through the direction of a portfolio practice, principles, and delivery boards.</p><h3>What you Will Learn</h3>
<p>At the end of this program, you will be able to:</p>
<ul>
<li>Articulate the benefits of portfolio management</li>
<li>Link the initiatives in an organization with its strategic objectives</li>
<li>Participate in the introduction of portfolio management in an organization</li>
<li>Create or improve the portfolio governance structure</li>
<li>Lead the inventory of ongoing and new initiatives</li>
<li>Assist the executives in the prioritization of initiatives through the use of Multi-criteria Analysis and other selection tools</li>
<li>Support the executives in balancing the portfolio based on the optimal use of resources and priorities</li>
<li>Create a portfolio delivery plan</li>
<li>Define thresholds and variance reporting criteria</li>
<li>Assist the executives and the financial team in the definition of Stage Gate Funding</li>
<li>Lead the Stage Gate reviews</li>
<li>Analyze the benefits that are being realized by the initiatives</li>
</ul><section>
                    <h3>Foundation Concepts</h3><ul><li>Definitions</li><li>Benefits of Portfolio Management</li><li>Objectives of Portfolio Management</li><li>Portfolio Life Cycles</li></ul><h3>Governing the Portfolio</h3><ul><li>Portfolio Governance structure</li><li>Roles and responsibilities</li><li>Initial activities when starting portfolio management</li></ul><h3>Prioritizing Initiatives</h3><ul><li>Prioritize purpose</li><li>Multi-Criteria Analysis</li><li>Analytical Hierarchy Process (AHP)</li><li>Strategic alignment</li></ul><h3>Balancing the Portfolio</h3><ul><li>Allocating resources and budgets</li><li>Communicating decisions of initiatives status</li></ul><h3>Planning the Portfolio</h3><ul><li>Planning review cycles</li><li>Using Stage Gate Funding</li><li>Setting thresholds and variance reporting</li><li>Tool examples</li></ul><h3>Managing the Portfolio Delivery</h3><ul><li>Project and Program Life Cycles</li><li>Stage Gate Reviews</li><li>Loop back to Prioritize, Balance and Plan</li><li>Interaction with the Portfolio Delivery Board</li><li>Project, Program and Functional Managers' roles and responsibilities</li></ul>


                </section>

Portfolio Management Skills: In-House Training

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Overview</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Teaching the theory and practice of suicide intervention skills that can be applied in any professional or personal setting, this programme is delivered over 3.5 hours as a suicide prevention awareness session. We use only the most experienced suicide prevention trainers to deliver this unique learning experience: for anyone who seeks greater understanding and confidence to intervene with people at risk of suicide.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">The Suicide First Aid Lite course gives learners the knowledge and tools to understand that suicide is one of the most preventable deaths and some basic skills can help someone with thoughts of suicide stay safe from their thoughts and stay alive.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">SFA Lite is comprised of 2 parts, each 90 minutes duration. The programme teaches the skills needed to identify someone who may be thinking about suicide and to pass the person onto a suicide first aider.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Part 1:</span></p><ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Introduction to the session; programme, ourselves and suicide prevention&nbsp;</li><li style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Stigma and survivors of bereavement by suicide and the Hidden Toll&nbsp;</li><li style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Suicide thoughts and suicide behaviour&nbsp;</li><li style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Intention of behaviour versus outcome of behaviour&nbsp;</li><li style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Possible causes of suicide thoughts&nbsp;</li><li style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Suicide &ndash; the ripple effect&nbsp;</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Part 2:</span></p><ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">&lsquo;I&rsquo;m really glad you told me&rsquo; audio visual&nbsp;</li><li style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Suicide Safety Guidance&nbsp;</li><li style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Recognising and asking about suicide&nbsp;</li><li style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Referring a person onto suicide first aiders&nbsp;</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Suicide First Aid Lite training offers learning outcomes that are knowledge based and factual. This training can be used as a stand-alone programme or as the first part of a journey to learn suicide prevention skills.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">The one-day programme Suicide First Aid through Understanding Suicide Interventions is a City &amp; Guilds qualification programme and the next step for people wanting a more in-depth practise-based approach to the learning. The information is easy to grasp for people of all skill levels and those with no prior knowledge of the subject. It is designed to meet the needs of virtual groups and could be used as a forerunner to the one-day Suicide First Aid Programme.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Evidence Base</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Two independent evaluations in 2016 and 2017 by Dr Paul Rogers demonstrated significant statistical change in 14 of 19 measures. Increased confidence and reduced anxiety in dealing with suicide, were among the leading outcomes.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Format</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Taught over 3.5 hours using tutor facilitated socratic learning, tutor-led practise sessions, mini lectures, group work and audio-visual presentations. This is a has some interactive elements and is an emotionally engaging learning experience.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Pre-training requirement</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">No previous experience or training is necessary. Participants will be asked to self- reflect and empathise with a person having thoughts of suicide. There is no expectation on participants to share personal experiences.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who should attend?&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Multi-sector managers and practitioners including health, housing, social care, education, criminal justice, call centre operators, private, voluntary and public sector workers and community groups or members.&nbsp;</span></p>

Changing Minds Training

This half-day Suicide First Aid Lite training course gives learners the knowledge and tools to understand that suicide is one of the most preventable deaths and some basic skills can help someone with thoughts of suicide stay safe from their thoughts and stay alive. 

Suicide First Aid Lite

General admission

<pre data-hook="description" style="color: rgb(0, 0, 0); overflow-wrap: break-word; overflow: visible; white-space: pre-wrap; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who should enroll in this course?</strong><br fr-original-style="" style="box-sizing: border-box;">This course in Architecture and Interior Design caters to individuals aspiring to excel in both interior design and architecture. With expert guidance from certified tutors affiliated with Autodesk and Adobe, students will acquire extensive skills in these domains.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://www.realanimationworks.com/product-page/comprehensive-training-for-architects-interior-and-exterior-designers" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Check Our Website</a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Duration:</strong><br fr-original-style="" style="box-sizing: border-box;">40 hours of personalized 1-on-1 training, available in both in-person and live online formats.<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Booking Availability: </strong>Classes can be scheduled between 9 am and 7 pm, allowing students to choose their preferred day and time slot each week. Flexible timing options are available with advance booking.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">What will you learn?</strong><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">In this comprehensive training program, you&#39;ll gain proficiency in a thoughtfully curated selection of software tools.</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Option A:</strong><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">AutoCAD (13 hours)</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">SketchUp (10 hours)</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Vray (6 hours)</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Photoshop (6 hours)</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">InDesign (5 hours)</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Additionally, you&#39;ll receive free online portfolio design assistance, career growth guidance, and mock interviews to enhance your job market readiness.</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Option B:</strong><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">AutoCAD (10 hours)</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">3ds Max (17 hours)</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Vray (4 hours)</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Photoshop (5 hours)</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">InDesign (4 hours)</span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline - Option A:</strong></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">In Option A,</strong> the course covers various design software tools in different modules:</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">AutoCAD (13 hours):</strong> Module 1 introduces the AutoCAD interface, tools, and basic drawing commands. Module 2 explores drawing and editing techniques such as lines, circles, and object modifications. Module 3 delves into precision drawing, covering coordinate systems, dimensioning, and advanced drawing methods. Module 4 focuses on advanced tools like blocks, layers, and project management.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">SketchUp (10 hours):</strong> Module 1 provides an overview of SketchUp, including 3D model creation and basic navigation. Module 2 delves into drawing in 3D, covering shapes, extrusion, and groups. Module 3 explores advanced modeling, including textures, materials, and complex model organization. Module 4 focuses on presenting 3D models through scene generation and animations.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Vray (6 hours): </strong>Module 1 introduces Vray rendering fundamentals and basic techniques. Module 2 covers lighting, materials, and creating realistic scenes. Module 3 explores camera settings, perspectives, and post-processing techniques for polished results.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Photoshop (6 hours): </strong>Module 1 provides an introduction to Photoshop, covering interface navigation and basic editing tools. Module 2 delves into image editing and enhancement techniques, including color adjustments, layers, and retouching. Module 3 explores design and composition principles, including typography, text effects, and graphic creation.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">InDesign (5 hours):</strong> Module 1 introduces the InDesign workspace and document creation. Module 2 covers layout design, including text formatting, frames, and cohesive layouts. Module 3 focuses on finalizing designs, proofing, and exporting files in various formats.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline - Option B:</strong></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Option B</strong> offers a comprehensive course on design software tools:</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">AutoCAD (10 hours): </strong>Module 1 introduces the AutoCAD interface and basic drawing commands. Module 2 covers drawing and editing techniques, including lines, circles, and object modification. Module 3 explores precision drawing with coordinate systems and dimensioning. Module 4 focuses on advanced tools like blocks, layers, and layout creation.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">3ds Max (17 hours):</strong> Module 1 provides an overview of 3ds Max, covering interface navigation and basic modeling techniques. Module 2 explores complex object creation and advanced modeling tools. Module 3 delves into texturing and materials, including UV mapping and realistic surface detailing. Module 4 covers lighting, rendering, and post-production techniques for high-quality visuals.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Vray (4 hours): </strong>Module 1 introduces Vray rendering fundamentals and interface navigation. Module 2 covers advanced lighting techniques and realistic material application.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Photoshop (5 hours):</strong> Module 1 provides an introduction to Photoshop, covering interface navigation and basic editing tools. Module 2 delves into image editing and enhancement techniques, including color corrections and advanced editing methods. Module 3 explores design and composition principles, including typography and advanced graphic creation.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">InDesign (4 hours): </strong>Module 1 introduces the InDesign workspace and document creation. Module 2 covers layout design, text formatting, and polished layouts.</p></pre>

Real Animation Works

1-2-1 face to face training customised and bespoke.

Training Course for Architects & Interior Exterior Designers

<h3><b>Microsoft Access training course description</b></h3>
        <p>   A hands on course providing a solid grounding
in Microsoft Access. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                        <li>Use and customise the Microsoft Access
environment.</li>
<li>Select, use and customise queries.</li>
<li>Define tables.</li>
<li>Design forms and reports.</li>
<li>Recognise the use of macros.</li>

                  </ul>
        <h5>
        <b>Microsoft Access training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone wishing to work with Microsoft Access.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>Database fundamentals</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Microsoft Access training course contents</b></h3>
      <ul>
        <li>Introducing databases </li><p>
Flat file databases, Relational databases, the objects defined in an Access database, planning a simple relational database.

</p><li>Open Access and create a database </li><p>
The database wizards, tables, creating and amending tables, using field properties to improve the quality of data entry and system performance, the primary key.

</p><li>Working in datasheet view </li><p>
View, add, modify and delete records, find records. Advantages and disadvantages of entering data directly into a table.

</p><li>Queries </li><p>
Sort and select records form a single table, advantages and disadvantages of entering data via a query, define simple calculated expressions, use 'Totals' queries.

</p><li>Forms </li><p>
Use the form wizards, basic editing of objects created using the form wizards, Data-entry in form view.

</p><li>Reports </li><p>
Use the report wizard, basic editing of objects created using the report wizard, print reports.

</p><li>The multi table environment </li><p>
Plan and create a related table, define a one-to-many relationship, write multi-table queries and use the 'AutoLookup' feature, use the form wizard to create a subform and carry out data-entry in a main/subform, print and amend reports, use the report wizard to create reports based on multi-table.

</p><li>Relationships </li><p>
Working with one-to-one and one-to-many relationships, recognising and handling many-to-many relationships, referential integrity.

</p><li>Select queries </li><p>
Select queries based on related tables, parameter queries, Crosstab, find unmatched queries and Find Duplicate, the implications of the Join properties in a relational query, conditional expressions, and working with the expression builder.

</p><li>Action queries </li><p>
Make table queries, append queries, update queries, delete queries. Customising forms. Using the Toolbox, calculated controls, Combo and List boxes, query by form, working with form and control properties, domain aggregate functions.

</p><li>Reports </li><p>
Report and control properties, customising sorting and grouping, calculated controls on reports, Sub-reports, editing and altering a report's source.

</p><li>Macros </li><p>
Introduction to macros.</p>
      </ul>

Microsoft Access

Brighton

Southend on Sea

Rotherham

Manchester

Slough

Portsmouth

Bingley

Nottingham

Paisley

Birmingham

Luton

Northampton

Bedford

Liverpool 

Swansea

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 4 (Foundation Degree Level) - Ireland Level 6
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 4 (Ireland Level 6)

 
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:
Covers advanced specialised phlebotomy techniques to give you the leading edge as a phlebotomist. Learn to use a wide range of non-routine equipment.


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)
M00 - Introduction:
Learning outcomes, Assumptions and Overview.
M01 - Basic Phlebotomy - revision:
Recap of basic phlebotomy theory and practice - precursor to
the advanced course.
M02 - Aspirated and Vacuated Systems:
Open systems (Syringe & Needle), closed systems (Vacutainer & Monovette), Alternative closed systems, Using Monovette - aspiration and evacuated techniques, monovette adapter systems.
M03 - Specialised and Advanced Phlebotomy Equipment:
The centrifuge - overview. Safe operation and use. Managing a centrifuge breakage or spillage.
Equipment and practices in unusual situations.
Patients with special needs and requiring specific attention.
Equipment preparation for blood samples that are collected at
0 degrees, 37 degrees C and other non-standard conditions.
A look at advances in technology and how to use the latest devices.
M04 - Point of Care Testing:
What is POC Testing? Advantages, Disadvantages and Clinical
Outcomes. Comparison of POC with lab testing. 10 common POC tests. Roles for phlebotomists performing POC Tests.
M05 - Neonates and Children:
Sample collection from new-born to pre-adult. A detailed overview of legal principles of law including child consent and child protection for phlebotomists. Neonatal and child blood collection equipment.
A comprehensive look at heel and finger-prick procedures including
microtainers, lancets and capillary tube collection. Detailed heel prick procedure. Paediatric finger prick collection. The life-threatening hazard of over-collecting. Communication techniques in differing age bands.
Consent and the law. Basic principles of lawful consent for neonates and paediatric patients. Child protection.
Detailed analysis of neonatal and paediatric blood collection including Guthrie card collection. Neonatal bottles - colours and tests. Paediatric blood gases collection.
Butterfly needles - when to use. Blood tests during pregnancy. Neonatal blood screening - nine conditions covered. Bilirubin in neonates.
M06 - Geriatric Patients:
The challenges of phlebotomy in older people. Understanding skin changes and venepuncture implications. A profile of common
geriatric blood tests. Age related problems. Procedural precautions.
M07 - Special Procedures:
Drawing blood from back of hand. Drawing blood from lower limb veins. Managing the unwilling or difficult patient. Managing the psychiatric patient. Managing the isolated patient. Non-routine blood tests. Managing the latex allergy patient (type 1 and type 4 reactions). Latex indicators. Sample handling - non-routine procedures. Drug trials and research projects.
M08 - Special Tests and Sample Handling Procedures:
A look at sample collection at specific times of day and night,
samples that are protected from light, collected on ice and
collected at body temperature. Procedures for each group - collection notes, analytic time, optimal collection time and notes for each group.
M09 - Advanced Phlebotomy Tasks:
Additional procedures. Maintaining POC equipment. Stock control and stock rotation. Quality control. Data entry. Product evaluation. Training and competency evaluation.
M10 - Alternative Environments:
A step-by-step look at non-clinical phlebotomy environments including private testing, DEFRA, forensic and police, cord blood collection, DNA analysis, veterinary services, overseas and volunteering.

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

PART 2 (CLASSROOM)
MORNING , AFTERNOON OR EVENING SESSION:

1 - Welcome, introductions and overview:
- Classroom - health & safety briefing, schedule overview.
- Virtual Classroom - audio/visual checks and registration. Unpacking and overview of your training kit.
2 - Syringe and Needle (open system): Correct use and applications.
3 - Monovette (open and closed systems):
Using the Monovette system in aspiration mode - correct use and applications.
Using the Monovette system in evacuated mode - correct use and applications.
4 - IR Vein Detector:
Demonstration of the IR vein detector for assisting in detection of difficult veins.
5 - Veins in back of hand:
Detecting suitable veins in the back of the hand.
6 - POC testing:
Point of Care Testing - use of glucose meter to demonstrate a typical POC test procedure. Correct use and overview of other POC test devices.
7 - Using lancets (finger collection)
We look at the correct use of lancets for POC testing and whole blood micro-collection.
8 - Using lancets (heel collection)
We look at the correct use of lancets for neonatal blood spot tests (Guthrie Test).
9 - Capillary collection
Using glass capillary tubes for micro-collection. Correct use and handling.
10 - Microtube collection
Correct use of BD Microtainers (and similar micro-collection bottles) - collection and handling.

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

Allied Health Professions (AHP)

Blood Taking

Healthcare Workers

Venepuncture

Phlebotomist

Phlebotomy

Accredited Phlebotomy

Healthcare

The UK's first and only Level 4 qualification in Phlebotomy (equivalent to Ireland Level 6)

    FDSc (Foundation Degree Level) qualification

    Nationally Recognised certificate

    Dually accredited: Open College Network  and CPD

    Covers both aspirated and evacuated systems

    Covers specialised blood collection systems & methods

    Classroom or Virtual Classroom learning options

    Comprehensive Training Kit is provided when booking our Virtual Classroom option (yours to keep)

    Complete your training from beginner to advanced level

    This course either follows on from our Introduction to Phlebotomy Course  or can be combined with our introductory course as part of a course package (see below)

    Available to candidates who have completed (or are currently enrolled to complete) our Introduction to Phlebotomy Course or have previous phlebotomy practical experience.


Advanced Phlebotomy - Skills & Techniques (GPT005)

Key Facts:


COURSE 1: PERIPHERAL I.V. CANNULATION COURSE (GPT008)



ONLINE STUDY - In your own time (approx. 5-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.

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


COURSE 2: VACCINATION / INJECTION COURSE (GPT601)



ONLINE STUDY - In your own time (approx. 5-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 4 (FDSc Level) - Ireland Level 6
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 4 (Ireland Level 6)



SUITABLE FOR:
- MEDICAL / HEALTHCARE (trainees and professionals)
- AESTHETIC THERAPISTS (all levels)

 
This Vaccination / Injection Course is a nurse or paramedic-led half-day session covering all essential theory and practical skill-sets required to deliver effective Intramuscular, Intradermal and Subcutaneous injections / vaccinations.
 
PART 1 - THEORY (online)
Delegates will fully understand the theory and will be able to demonstrate they can identify the correct patient, gain consent and safely administer a vaccine or injection, conforming to WHO and Skills for Health recommended standards.
 
Itinerary:
M01 Course Overview and brief history
M02 Infection Protection Control
M03 Professionalism and Effective Communication
M04 Understanding injection procedures
M05 Why do we vaccinate?
M06 The immune system and how vaccines work. Vaccine types and composition.
M07 The National Vaccine Policy & Schedule
M08 Vaccine preventable diseases
M08A – Covid-19 Update
M09 Vaccines - understanding the reconstitution process
M10 Storage and Handling – understanding correct procedures and protocols
M11 Equipment – Syringes and Syringe Types, Needles and Needle Types, SDV (Single-Dose Vials), MDV (Multi-Dose Vials), Pre-Filled Syringes, Gloves and PPE.
M12 Vaccination sites, techniques and anatomical site selection
i) Intramuscular (IM) Injection
ii) Subcutaneous (SubCut) Injection
iii) Intradermal (ID) Injection
M13 Legal requirements, Consent and Standard Operating Procedures
M14 Adverse Reactions and Basic Life Support Guidance
M15 Record keeping & Documentation
 
PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED
BEFORE JOINING US FOR YOUR PRACTICAL TRAINING
PART 2 - CLASSROOM (am, pm or evening sessions)
3 - 4 hours skill-set development with practical demonstrations and hands-on experience performing Intramuscular, Intradermal and Subcutaneous Injections.
 


How do I attend?

EITHER -
CLASSROOM OPTION - Complete your theory training online at home or work, then attend one of our scheduled classroom locations, completing your Peripheral IV Cannulation Course and your Injection Course on the same day.
Our Peripheral IV Cannulation Course and Injection Course 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 for you to add at time of booking. Training kits mirror the same equipment and supplies used in the classroom and both include detailed video instructions, 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 your one full day to complete your cannulation and injection course training.

Our Virtual Classroom option includes two very comprehensive training kits - one for your cannulation course and one for your injection course. Kits are included at no charge (normally £79.95 and £39.95 respectively) 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.

Additional Courses suitable for Aesthetic Therapists:
Our popular Introduction to Phlebotomy Course also trains you to perform venepuncture at Advanced Level. We offer both classroom and virtual classroom options for this course and a comprehensive Practise@Home Training Kit is provided for our virtual classroom option. Both options are accredited at Advanced Level.
If you already have phlebotomy skills (or decide to enroll on our phlebotomy training course) then you will be able to offer your clients Platelet-Rich Plasma (PRP) Treatments, also known as Vampire Facials. Our PRP (Vampire Facials) Course trains you in the harvesting, preparation and treatment of PRP for application to your clients as required. We offer both classroom and virtual classroom options for this course and a comprehensive Practise@Home Training Kit is provided for our virtual classroom option. Both options are accredited at Foundation Degree Level.

If you would like to "mix and match" your training dates and/or locations or would like to build your own package of courses 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 dually accredited and are Skills for Health & WHO compliant.

Medical Aesthetics

Platelet-rich plasma (PRP)

Intravenous Cannulation

Aesthetic Practitioner

Facial Aesthetics

THIS COURSE PACKAGE INCLUDES:
1: PERIPHERAL I.V. CANNULATION - IV THERAPIES COURSE (GPT008)
2: VACCINATION / INJECTION COURSE (GPT601)

Learn how to administer injectables and intravenous therapies ...

FAST-TRACK YOUR AESTHETICS TRAINING

WITH OUR

COMPLETE TRAINING PACKAGE

20% Multi-Course Discount

    Cover all stages from Level 1 through to Level 4 (FDSc)

    Cover your theory training online

    Complete your advanced practical training in 1 day

    Practical training in Classroom or Virtual Classroom

    Comprehensive Practise@Home training kits for VC

    Awards 2 accredited qualifications

    Dual Accreditations for all courses

    Covers all steps required to safely perform injectables

    Covers all steps required to safely perform IV therapies

    Practise IV on artificial arm with fake blood

    Practise injection techniques on realistic injection pads

    Learn beginner to advanced skills and techniques

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Aesthetic Therapy Training - Beginner to Advanced PACKAGE

Cardiff

Milton Keynes 

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



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;">A <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Retreat in Daily Life</strong> is a way to find something of what you might experience on a residential retreat, with the difference being that you are at home, and the prayer experience is woven into the rhythm of your ordinary life.&nbsp;</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 fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The&nbsp;Contemplative at Home Retreat in Daily Life</strong> involves two components:</p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Six days per week : Thirty to Forty-five minutes of <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">daily personal prayer</strong>, with suggested meditations and reflection questions.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">One day per week : A&nbsp;two-hour Zoom call, to share with other pilgrims who are on retreat with you. Lissy hosts these sessions in a <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">group spiritual direction</strong> format.&nbsp;</li></ul><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who is this for?</strong></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">This retreat is suitable for anyone who has (or has had) some kind of practice of Christian prayer, and is ready to explore a bit more of their faith, their prayer life or their relationship with God.&nbsp;</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;">This might be for you if you</div><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div id="isPasted" fr-original-style="" style="box-sizing: border-box;">Would like to explore the contemplative prayer traditions of the Christian faith</div></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div id="isPasted" fr-original-style="" style="box-sizing: border-box;">Are ready for something deeper in your relationship with God</div></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><div id="isPasted" fr-original-style="" style="box-sizing: border-box;">Hope to find God in new ways</div></li><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;">Would like some structure and support to help you reinstate a habit of daily prayer</div></li><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;">Would like to go away on retreat, but are unable to at the moment</div></li><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Enjoy&nbsp;</span>Contemplative at Home meditations and want to connect&nbsp;with others who do as well</div></li></ul><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="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;">Prayer Material</strong></span></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Meditations from the Contemplative at Home archives are suggested for five days of the week, with an Examen or review practice on the sixth day of the week. Each week follows a slightly different theme.</span></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><p id="isPasted" style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Week One: Introduction to Contemplative Prayer / Establishing your Routine</span></p><p style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Week Two: Lectio Divina / Listening to Scripture</span></p><p style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Week Three: Imaginative Contemplation / Encoutering Jesus&nbsp;</span></p><p style="margin-left: 20px; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="margin-left: 20px;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Week Four: Praying with the Psalms / My Life in God</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Prompts for reflection are also provided. Most of the meditations are around twenty minutes in length, with a suggested 15 minutes after the audio&nbsp;meditation for journalling or reflecting on your prayer experience.&nbsp;</span></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 fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Further Details and Commitment</strong></p><p 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;">The times listed on the sign up link above reflect the time for the group calls. Please be aware of your local time zone. I work in the UK and times may be listed for GMT.&nbsp;&nbsp;</span></p><p 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;">There will be one call before the retreat begins, and one at the end of each week, for a total of 5 calls.&nbsp;</span></p><p 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;">There will be a maximum of six participants in the group.<br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Please check that you are able to attend all of the group sessions before you apply.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The daily prayer can be done at any time that suits you but, if you don&#39;t already have a 30-45 minute window of time devoted to prayer each day, do take some time to think about when you might fit it in, for example: will you wake up earlier? Will you do it at lunch time? in the evening? How realistic is this? &nbsp;Is there a place in your house where you could sit to pray? Will&nbsp;those you share space with will be able to respect your commitment to the retreat?</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 fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This won&#39;t be for everyone, but for those who are drawn to take part in this prayer experience, I have no doubt that it will be a positive and enriching time. I am really looking forward to sharing this space with you.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</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>

Contemplative at Home

Contemplative at Home Retreat in Daily Life

Reading

Dickson Training Ltd

ILM Level 5 Qualifications in Business Coaching and Mentoring

Diploma (Zoom)

Certificate (Zoom)

Diploma

Certificate

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Sixty minute webinar on rally regularity timing for jogularity and regularity in styles where a full average speed time schedule is provided. The competitive component of on the public highway historic road rallying, focusing on jogularity style timing. Ideal for competitors on events such as HERO Challenge, Rally the Globe events or Three Castles.
</p>

Join our exclusive 60-minute webinar on rally regularity timing, designed to give an introduction to regularities in the jogularity or cumulative speed table styles. Learn how to navigate a full average speed time schedule and master the competitive aspects of historic road rallying on public highways. This session focuses on the processes required to understand and use the supplied time schedules, perfect for those competing in events like the HERO Challenge, Rally the Globe, and Three Castles. Whether you're a seasoned competitor or looking to sharpen your skills, this webinar will equip you with the strategies you need to succeed.


Rally Navigation Training Services

Sports & Fitness

Historic Road Rallying training webinar on Regularity focusing on the Jogularity and Cumulative Speed Table styles.

Rally Navigation - Introduction to Regularity Timing

Chesterfield

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;">FAA Level 1 Award In Awareness Of First Aid For Mental Health (RQF)</h2><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Classroom (4.5 hour course), Virtual (2 x 2 &frac12; hour sessions)&nbsp;</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Gives learners a good awareness of Mental Health First Aid</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Gives learners the skills to start that difficult conversation</strong></li></ul><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h3 id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Contents:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">What is Mental Health?</li><li fr-original-style="" style="box-sizing: border-box;">Why people develop mental health conditions</li><li fr-original-style="" style="box-sizing: border-box;">What the role of a mental health first aider is</li><li fr-original-style="" style="box-sizing: border-box;">Knowing how to provide advice and practical support</li><li fr-original-style="" style="box-sizing: border-box;">Knowing how to recognise and manage stress</li><li fr-original-style="" style="box-sizing: border-box;">Recognising a range of mental health conditions:</li><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Depression</li><li fr-original-style="" style="box-sizing: border-box;">Anxiety</li><li fr-original-style="" style="box-sizing: border-box;">Psychosis</li><li fr-original-style="" style="box-sizing: border-box;">Eating disorders</li><li fr-original-style="" style="box-sizing: border-box;">Suicide</li><li fr-original-style="" style="box-sizing: border-box;">Self-harm</li></ul></ul><h3 fr-original-style="" style="box-sizing: border-box;">Benefits of this course:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">37% of all work-related ill-health is due to mental health problems</li><li fr-original-style="" style="box-sizing: border-box;">Problems with mental health cover 45% of all working days lost</li><li fr-original-style="" style="box-sizing: border-box;">A whopping 12.8 million working days, or 49, 042 years, were lost due to mental health problems in 2018/19</li><li fr-original-style="" style="box-sizing: border-box;">602,000 workers suffered from work-related stress, depression or anxiety in 2018/19</li><li fr-original-style="" style="box-sizing: border-box;">One in four people will have a mental health problem at some point during their lives</li><li fr-original-style="" style="box-sizing: border-box;">Whether work is causing or aggravating mental health problems, employers have a legal responsibility towards their employees</li><li fr-original-style="" style="box-sizing: border-box;">Work-related mental health issues must to be assessed to measure the levels of risk to staff</li><li fr-original-style="" style="box-sizing: border-box;">Where a risk is identified, steps must be taken to remove it or reduce it as far as reasonably practicable</li><li fr-original-style="" style="box-sizing: border-box;">This half day course gives people a good awareness of mental health in the workplace</li><li fr-original-style="" style="box-sizing: border-box;">For a more complete introduction, see our full day First Aid for Mental Health or two day Supervising First Aid for Mental Health courses</li></ul><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h3 fr-original-style="" style="box-sizing: border-box;">Accredited, Ofqual regulated qualification</h3><div fr-original-style="" style="box-sizing: border-box;"><img src="https://images.cademy.co.uk/pochat-training/6c550a94-5c16-4ff3-b27f-7407b1a35e22/original.jpeg" style="width: 300px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left; cursor: pointer; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 300px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left;" fr-original-class="fr-draggable"></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">This Awareness of Mental Health First Aid Course is a nationally recognised, Ofqual regulated qualification accredited by&nbsp;</span><a href="http://www.firstaidawards.com/" style="color: rgb(34, 177, 77); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" target="_blank" fr-original-style=" color: rgb(34, 177, 77);">First Aid Awards</a><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">.</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">This means that you can be rest assured that your Mental Health First Aid Certificates fulfil the upcoming <img src="https://images.cademy.co.uk/pochat-training/93996411-85e2-4821-bf00-5875b510df81/original.png" style="width: 232px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left; cursor: pointer; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 232px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left;" fr-original-class="fr-draggable">legal requirements and are a very good way to make sure you and your employees have a supporting workplace to deal with staff&#39;s mental health conditions.</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">The&nbsp;</span><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Ofqual Register number</strong><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">&nbsp;for this course is&nbsp;</span><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">603/3768/0</strong></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 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 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><img src="https://images.cademy.co.uk/pochat-training/7cbdb7f4-2060-482c-aab7-6d4ad4183309/original.png" style="width: 585px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 585px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto;" fr-original-class="fr-draggable">

Pochat Training

Mental Health Awareness

Mental Health First Aid

Health & Wellbeing

Occupational Health & Wellbeing

Emotional Wellbeing

Psychological Wellbeing

Mental Health

Emotional Resilience

Accredited Mental Health First Aid

Mental Resilience

Mental Health At Work

Resilience

Awareness of First Aid for Mental Health

 This price includes an Ofqual regulated certificate

 With Ofqual regulated certificate 

This price includes a CPD certificate instead of an Ofqual regulated certificate (it's exactly the same course)

 With CPD certificate

<h2 id="isPasted" style="color: rgb(57, 54, 79); box-sizing: border-box;" fr-original-style=" color: rgb(57, 54, 79);">About this event</h2><div style="color: rgb(57, 54, 79); box-sizing: border-box;" fr-original-style=" color: rgb(57, 54, 79);"><h3 style="color: rgb(30, 10, 60); box-sizing: border-box;" fr-original-style=" color: rgb(30, 10, 60);">COURSE INTRODUCTION</h3><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">This course covers Tuberculosis, latent and active, diagnosis, screening and testing, groups offered vaccine, symptoms and treatment; within the current regulatory and legal framework. We discuss Mantoux, BCG techniques, IGRA testing, Scar identification and current issues. The course is hands-on and practical and each participant receives a certificate after successfully completing the course.</p><h3 style="color: rgb(30, 10, 60); box-sizing: border-box;" fr-original-style=" color: rgb(30, 10, 60);">AIMS AND OBJECTIVES</h3><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Be able to provide accurate and up to date information about BCG and TB vaccines</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Update staff on current issues</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Provide a safe, effective and high standard of care</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">COURSE CONTENTS</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; The aims of TB immunisation: national policy and schedules</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; History of TB</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; How common is TB</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Epidemiology and current statistics</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Screening and testing</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Latent TB infection</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Active TB disease</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Signs and symptoms of TB</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Diagnosis</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; IGRA Testing</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Treatment</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Management</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; TB Vaccination</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Practical workshop</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Technique-intradermal</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; BCG Technique</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Mantoux / Technique</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Scar identification</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; The legal aspects of vaccination</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Prescribing vaccines</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Storage and handling of vaccines - cold chain</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Correct administration of vaccines</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Record-keeping and reporting</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Competence Assessment</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Ref: National Minimum Standards for Immunisation Training, PHE and RCN, Immunisation for Infectious Diseases</p><h3 style="color: rgb(30, 10, 60); box-sizing: border-box;" fr-original-style=" color: rgb(30, 10, 60);">WHO SHOULD ATTEND?</h3><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Nurses - Primary Care, Secondary Care</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Occupational Health Staff</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Doctors - Occupational Health</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Military Staff</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Midwives</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; Neonatal Nurses</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&bull; School Nurses</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Includes All course materials and certificate of attendance</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">AB Health Group awards CPD points / certificate of attendance for each course. &nbsp;If you would prefer an accredited certificate by our accrediting body Aim Qualifications we can organise this. &nbsp;The charge for the certificate including postage is &pound;30.00.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Annie Barr AB Health Group</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Organiser Description</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Annie Barr is a leading provider of high quality, accredited healthcare training. With a selection of engaging healthcare training that has been developed by experts to equip you and your workforce with the skills, knowledge and competence needed to provide compassionate and high quality care.</p></div>

About this event
COURSE INTRODUCTION
This course covers Tuberculosis, latent and active, diagnosis, screening and testing, groups offered vaccine, symptoms and treatment; within the current regulatory and legal framework. We discuss Mantoux, BCG techniques, IGRA testing, Scar identification and current issues. The course is hands-on and practical and each participant receives a certificate after successfully completing the course.
AIMS AND OBJECTIVES
• Be able to provide accurate and up to date information about BCG and TB vaccines
• Update staff on current issues
• Provide a safe, effective and high standard of care


COURSE CONTENTS
• The aims of TB immunisation: national policy and schedules
• History of TB
• How common is TB
• Epidemiology and current statistics
• Screening and testing
• Latent TB infection
• Active TB disease
• Signs and symptoms of TB
• Diagnosis
• IGRA Testing
• Treatment
• Management
• TB Vaccination
• Practical workshop
• Technique-intradermal
• BCG Technique
• Mantoux / Technique
• Scar identification
• The legal aspects of vaccination
• Prescribing vaccines
• Storage and handling of vaccines - cold chain
• Correct administration of vaccines
• Record-keeping and reporting
• Competence Assessment
Ref: National Minimum Standards for Immunisation Training, PHE and RCN, Immunisation for Infectious Diseases
WHO SHOULD ATTEND?
• Nurses - Primary Care, Secondary Care
• Occupational Health Staff
• Doctors - Occupational Health
• Military Staff
• Midwives
• Neonatal Nurses
• School Nurses
Includes All course materials and certificate of attendance
AB Health Group awards CPD points / certificate of attendance for each course. If you would prefer an accredited certificate by our accrediting body Aim Qualifications we can organise this. The charge for the certificate including postage is £30.00.


Annie Barr AB Health Group
Organiser Description
Annie Barr is a leading provider of high quality, accredited healthcare training. With a selection of engaging healthcare training that has been developed by experts to equip you and your workforce with the skills, knowledge and competence needed to provide compassionate and high quality care.

AB Health Group

General Health

Medical Training

Professional Development

Public Health

BCG/Mantoux and TB - Webinar

TB / BCG Training WEBINAR

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p><p>Earning your SHRM Certified Professional (SHRM-CP) or SHRM Senior Certified Professional (SHRM-SCP) credential makes you a recognized expert and leader in the HR field and a valuable asset to your organization, keeping  you and your organization more competitive in today's economy. This professional distinction sets you apart from your colleagues, proving your high level of knowledge and skills. Students will be able to identify areas of strength and build on them. They will also see where they will need further concentrated study in preparation for their exam.</p></div><div id="course-pills-2"><h3>1 - INTRODUCTION</h3> <ul> <li>The SHRM Body of Competency and Knowledge? (BoCK)</li> <li>The SHRM-CP and SHRM-SCP Certifications</li> <li>The SHRM Learning SystemÂ© for SHRM-CP/SHRM-SCP</li> </ul> <h3>2 - HR COMPETENCIES</h3> <ul> <li>Behavioral Competencies</li> </ul> <h3>3 - DOMAIN 1: PEOPLE</h3> <ul> <li>Functional Area #1: HR Strategic Planning</li> <li>Functional Area #2: Talent Acquisition </li> <li>Functional Area #3: Employee Engagement and Retention </li> <li>Functional Area #4: Learning and Development</li> <li>Functional Area #5: Total Rewards</li> </ul> <h3>4 - DOMAIN 2: ORGANIZATION</h3> <ul> <li>Functional Area #6: Structure of the HR Function</li> <li>Functional Area #7: Organizational Effectiveness and Development</li> <li>Functional Area #8: Workforce Management</li> <li>Functional Area #9: Employee and Labor Relations</li> <li>Functional Area #10: Technology Management</li> </ul> <h3>5 - DOMAIN 3: WORKPLACE</h3> <ul> <li>Functional Area #11: HR in the Global Context</li> <li>Functional Area #12: Diversity and Inclusion</li> <li>Functional Area #13: Risk Management</li> <li>Functional Area #14: Corporate Social Responsibly</li> <li>Functional Area #15: U.S. Employment Law and Regulations</li> </ul> <h3>6 - FINAL EXAM/REVIEW/DISCUSSION</h3></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans SHRM-CP/SHRM-SCP Certification Preparation 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 SHRM-CP/SHRM-SCP Certification Preparation 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

Clifton Practice Hypnotherapy Training (CPHT)

Chartered Institute of Personnel Development (CIPD)

Certified Payroll Professional (CPP)

Professional Skills Course (PSC)

Certified Supply Chain Professional (CSCP)

Scrum Master Professional Certificate (SMPC)

SHRM-CP/SHRM-SCP Certification Preparation

<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 novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.</p>Overview<p>Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries</p><p>This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.</p>Prerequisites<p></p><ul> <li>Basic understanding of relational databases.</li> <li>Basic Windows knowledge.</li> </ul><p></p></div><div id="course-pills-2"><h3>Module 1: Introduction to Transact-SQL</h3><ul> <li>What is Transact-SQL</li> <li>The SELECT statement</li> <li>The WHERE clause</li> <li>Sorting results</li> <li>Calculations</li> <li>CASE expressions</li> </ul>   <h3>Module 2: Joining tables with Transact-SQL</h3><ul> <li>The JOIN clause</li> <li>Inner joins</li> <li>Outer joins</li> <li>Self joins and cross joins</li> </ul>  <h3>Module 3: Filtering and sorting results</h3><ul> <li>Implement the ORDER BY clause</li> <li>Filter data with the WHERE clause</li> <li>Limit the number of rows returned by a query</li> <li>Implement NULL logic</li> </ul>  <h3>Module 4: SQL Server data types</h3><ul> <li>Understand data types</li> <li>Implement string data types</li> <li>Implement temporal data types</li> </ul>  <h3>Module 5: Inserting, updating and deleting data</h3><ul> <li>Insert new records</li> <li>Update existing records</li> <li>Delete data</li> </ul>   <h3>Module 6: Using SQL Server functions with Transact-SQL</h3><ul> <li>Understand function types in SQL Server</li> <li>Convert data using functions</li> <li>Implement logical functions</li> <li>Work with NULL data using functions</li> </ul>  <h3>Module 7: Aggregating data with Transact-SQL</h3><ul> <li>Implement aggregation in SQL Server</li> <li>Group records in SQL Server</li> <li>Filter aggregated data</li> </ul>   <h3>Module 8: Implement subqueries with Transact-SQL</h3><ul> <li>Implement scalar and multi-valued sub-queries</li> <li>Implement correlated subqueries</li> <li>Implement existence checks with subqueries</li> </ul>   <h3>Module 9: Create queries that use table expressions</h3><ul> <li>Create views</li> <li>Create table-valued functions</li> <li>Implement derived tables</li> <li>Implement common table expressions</li> </ul>  <h3>Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data</h3><ul> <li>Write queries with the UNION operator</li> <li>Write queries with the INTERSECT and EXCEPT operators</li> <li>Write queries with the APPLY operator</li> </ul>    <h3>Module 11: Implement window functions in queries</h3><ul> <li>Understand window functions</li> <li>Impement window functions</li> </ul>    <h3>Module 12: Use PIVOT and grouping sets in queries</h3><ul> <li>Implement PIVOT in queries</li> <li>Implement grouping sets in queries</li> </ul>   <h3>Module 13: Use stored procedures in queries</h3><ul> <li>Query data with stored procedures</li> <li>Interact with stored procedures using input and output parameters</li> <li>Write simple stored procedures</li> <li>Pass dynamic SQL to SQL Server</li> </ul>    <h3>Module 14: Implement programming features in Transact-SQL</h3><ul> <li>Understand T-SQL programming elements</li> <li>Implement loops and conditions in T-SQL queries</li> </ul>   <h3>Module 15: Add error handling to queries</h3><ul> <li>Understand SQL Server error handling</li> <li>Implemet structured exception handling</li> </ul>   <h3>Module 16: Use transactions in queries</h3><ul> <li>Understand database transactions</li> <li>Implement transactions in T-SQL</li> </ul></div>

932 Courses in London

Definitive Kubernetes for engineers

By Systems & Network Training

Definitive Firewalls for engineers

By Systems & Network Training

Portfolio Management Skills

By IIL Europe Ltd

Transmission demystified

By Systems & Network Training

Definitive SIP in the IMS for engineers

By Systems & Network Training

Leadership Professional - Mastery Programme

By Mpi Learning - Professional Learning And Development Provider

Portfolio Management Skills: In-House Training

By IIL Europe Ltd

Suicide First Aid Lite

By Changing Minds Training

Training Course for Architects & Interior Exterior Designers

By Real Animation Works

Microsoft Access

By Systems & Network Training

Search By Location