Name: Solar Thermal Hot Water Systems (BPEC NOS for MCS)
Price: 599 GBP
Availability: InStock

London

<ul id="isPasted" fr-original-style="" style="box-sizing: border-box;"><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Constantly making up and breaking up</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Improve communication</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Self-regulation</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Improve understanding</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Address trust and respect issues</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Healthy relationship course</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Be a better partner training for both parties</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">Emotional intelligence and relationship disciplines training</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">6 sessions</li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;">1-hour x 6</li></ul> <a href="https://relationshipsmdd.com/product/our-relationship-is-an-emotional-rollercoaster/" id="isPasted" fr-original-style="" style="-webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">https://relationshipsmdd.com/product/our-relationship-is-an-emotional-rollercoaster/</a>

Miss Date Doctor Dating Coach London, Couples Therapy

M.D.D OUR RELATIONSHIP IS AN EMOTIONAL ROLLERCOASTER (COUPLES)

General admission

<ul style="color: rgb(230, 230, 230); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(230, 230, 230);"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Do you want to work on yourself?</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Are you questioning your dating skills after multiple failed relationships with different guys?</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">In this package, we explore you with introspective tests</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Assist you in dating apps and networking</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Changing negative behavioural patterns</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">CBT methods to change the behaviours that do not serve you in your dating life</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Support Coach and counselling</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Journalling and tracking progress</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Dating advice</li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">8 weeks of training</li></ul> <a href="https://relationshipsmdd.com/product/dating-advice-for-women-packages/" id="isPasted" fr-original-style="" style="-webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">https://relationshipsmdd.com/product/dating-advice-for-women-packages/</a>

M.D.D DATING ADVICE FOR WOMEN INTROSPECTION PACKAGE (DATING ADVICE FOR WOMEN)

1 Day - 8 CPD HoursClinical supervision is the term used to describe a formal process of professional support and provides an opportunity for staff to:<ul style="color: rgb(68, 68, 68); box-sizing: border-box;" fr-original-style=" color: rgb(68, 68, 68);"><li fr-original-style="" style="box-sizing: border-box;">Reflect on and review their practice.</li><li fr-original-style="" style="box-sizing: border-box;">Develop their analytical skills</li><li fr-original-style="" style="box-sizing: border-box;">Change or modify their practice</li></ul>

M&K Update Ltd

Adult Leadership & Management (ALM)

Clinical Supervision

Allied Health Professions (AHP)

Health Care Management

Clinical Skills

Clinical supervision is the term used to describe a formal process of professional support and provides an opportunity for staff to: reflect on and review their practice, develop their analytical skills and change or modify their practice.

Clinical Supervision - Training for Supervisors

<ul style="color: rgb(230, 230, 230); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(230, 230, 230);"><li style="color: rgb(0, 0, 0); font-weight: bold; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-weight: bold;">Support coaching and guidance</li><li style="color: rgb(0, 0, 0); font-weight: bold; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-weight: bold;">Emotional regulation training</li><li style="color: rgb(0, 0, 0); font-weight: bold; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-weight: bold;">Addressing issues and trauma</li><li style="color: rgb(0, 0, 0); font-weight: bold; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-weight: bold;">2 sessions with parents 5 sessions with the teenager</li><li style="color: rgb(0, 0, 0); font-weight: bold; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-weight: bold;">7 sessions on a weekly basis</li><li style="color: rgb(0, 0, 0); font-weight: bold; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-weight: bold;">Family therapy and individual insight therapy</li><li style="color: rgb(0, 0, 0); font-weight: bold; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-weight: bold;">Introspection test</li><li style="color: rgb(0, 0, 0); font-weight: bold; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-weight: bold;">Tackling embedded anger and upset</li><li style="color: rgb(0, 0, 0); font-weight: bold; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-weight: bold;">Assessment and diagnosis of perspective and mindset</li></ul> <a href="https://relationshipsmdd.com/product/my-teenager-is-out-of-control-package/" id="isPasted" fr-original-style="" style="-webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">https://relationshipsmdd.com/product/my-teenager-is-out-of-control-package/</a>

M.D.D MY TEENAGER IS OUT OF CONTROL PACKAGE (FAMILY RELATIONSHIP ISSUES)

Course ObjectivesAt the end of this course you will be able to:<ul><li>Record and edit a Macro</li><li>Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects.</li><li>Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures</li><li>Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope</li><li>Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks</li><li>Create an error handling routine in case things go wrong with VBA code</li></ul>' 1 year email support serviceTake a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co ukCustomer Feedback<ul><li>Best Training Ever!</li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li>The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience..</li><li>Simon Harper - Lloyd's of London</li></ul><ul><li>My learning experience was awesome.</li><li>Perdinand Reagan - Subsea7</li></ul><ul><li>Very nice and relaxed approach to teaching. Was definitely a good learning experience.</li><li>Jerome Pupe - S5 Agency World</li></ul><ul><li>The Trainer – Very positive + patient + helpful + thorough</li><li>Agnes Souza - Direct Wines</li></ul>'With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.<ul><li>Our competitive rates start from £550.00 per day of training</li></ul>Tailored training courses:You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.Introduction to Macros and VBA<ul><li>Introducing Visual Basic for Applications</li><li>Recording a Macro</li><li>Naming conventions for Macro Procedures</li><li>Running a Macro</li><li>Absolute or Relative Cell Referencing</li><li>Saving and Opening Files with Macros</li><li>Making macros always available</li><li>Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes</li><li>Editing a Macro in the Visual Basic Editor</li><li>Understanding the Development Environment</li><li>Customising the Editor</li><li>Tips for General Typing in VBA</li><li>Using Visual Basic Help</li></ul>Working with Procedures<ul><li>Program Design</li><li>Understanding Modules</li><li>Naming Rules</li><li>Creating a Module</li><li>Understanding Procedures</li><li>Programming Macro Concepts</li><li>Creating a Subroutine</li><li>Creating a Function</li><li>Understanding Arguments</li><li>Exiting Procedures</li><li>Calling Procedures</li></ul>Objects, Properties, Methods and Events<ul><li>Understanding Objects Properties, Methods, and Events</li><li>Navigating the Object Hierarchy</li><li>Understanding Collections</li><li>Accessing a Member of a Collection</li><li>Understanding Hierarchy</li><li>Using the Object Browser</li><li>Using the With Statement</li><li>Working with Properties</li><li>Working with Methods</li><li>Creating an Event Procedure</li><li>Reserved Macro Names</li></ul>Using Expressions, Variables and Intrinsic Functions<ul><li>Understanding Expressions and Statements</li><li>Declaring Variables</li><li>Understanding Data Types</li><li>Determining the Value of Variables</li><li>Working with Variable Scope</li><li>Using Built-in VBA Functions</li><li>Understanding Constants</li><li>Using Message Boxes</li><li>Controlling the Answer to a Message Box</li><li>Using Input Boxes</li><li>Declaring and Using Object Variables</li></ul>Controlling Program Execution<ul><li>Understanding Control-of-Flow Structures</li><li>Using the If...End If Decision Structures</li><li>Nested If Statements</li><li>Using the Select Case ... End Select Structure</li><li>Using the Do ... Loop Structure</li><li>Using the For ... Next Structure</li><li>Using the For Each ... Next Structure</li><li>Guidelines for Use of Control-of-Flow Structures</li></ul>Debugging and Handling Errors<ul><li>Understanding Errors</li><li>Using Debugging Tools</li><li>Setting Breakpoints and Using Break Mode</li><li>Stepping Through Code</li><li>Trapping Errors with the On Error Statement</li><li>Understanding the Err Object</li><li>Working with Inline Error Handling</li><li>Writing an Error-Handling Routine</li></ul>Working with Forms and Controls<ul><li>Understanding UserForms</li><li>Creating a Form</li><li>Displaying and Removing a Form</li><li>Aligning and Sizing Controls</li><li>Using the Toolbox</li><li>Working with a Form's Properties, Methods, and Events</li><li>Working with Form and Control Properties, Methods and Event</li><li>Setting the Tab Order</li><li>Populating a Control</li></ul><h2>
 
 Who is this course for?
 
 <div>Who is this course for?</div>
 </h2>

 <div id="who_is_this_course_for">
 This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools.
 </div><h2>
 
 Requirements
 
 <div>Requirements</div>
 </h2>

 <div id="requirements">
 Preferably, delegates should have attended the Excel Advanced course.
 </div><h2>
 
 Certificates
 
 <div>Certificates</div>
 </h2>

 <div id="optional_extras">
 <h4>Certificate of completion</h4>
 
 Digital certificate -
 Included
 

 </div>

Microsoft Office Training

Microsoft Excel Macros & VBA - In-company

General Admission

Course Overview:The "An Understanding of Seizure First Aid and the Administration of Rectal Paraldehyde" course is designed to provide participants with comprehensive knowledge and practical skills related to assisting individuals during seizures and administering rectal paraldehyde as a rescue medication in the event of prolonged or severe seizures. This course is suitable for caregivers, healthcare professionals, educators, and individuals who may need to respond effectively to seizures and administer rectal paraldehyde. Course Duration:1/2 day (3 hours) Course Content:By the end of the course, participants will be able to:1. Explain the features of an Emergency Seizure Management Plan2. List the steps to take when supporting someone who is having a seizure3. Demonstrate in simulation how to administer Rectal ParaldehydeThe learner should have previously completed Epilepsy Awareness training.  Course Objectives:1. Recognise different types of seizures: Understand the classification of seizures, including focal, generalised, and status epilepticus, to tailor interventions accordingly.2. Learn about seizure first aid: Familiarise yourself with appropriate seizure first aid measures, including ensuring patient safety, positioning, and protecting the airway.3. Acquire skills in rectal paraldehyde administration: Develop hands-on skills in safely and accurately administering rectal paraldehyde, including proper dosing, preparation, and technique.4. Understand indications and contraindications: Learn about situations where rectal paraldehyde is indicated, such as prolonged seizures, and cases where it might be contraindicated.5. Address potential complications and side effects: Gain knowledge about possible complications and adverse effects associated with rectal paraldehyde administration and strategies for managing them.6. Recognise the importance of monitoring: Understand the significance of monitoring patients after rectal paraldehyde administration, including assessing response, vital signs, and potential adverse events.7. Develop communication skills: Learn effective communication techniques to educate patients, caregivers, and family members about seizure management, rectal paraldehyde administration, and emergency responses.8. Ethical considerations and patient-centered care: Explore ethical issues related to patient autonomy, informed consent, and delivering emergency care with empathy, respect, and dignity. Assessment and Certification:Participants will undergo practical skills assessments, written assessments, and potentially scenario-based evaluations to evaluate their understanding and competence in seizure first aid and rectal paraldehyde administration. Successful completion will lead to a certification of achievement in "An Understanding of Seizure First Aid and Rectal Paraldehyde Administration."Note: This course overview is a general guideline and can be customised to suit specific local requirements and preferences, therefore, we recommend that you contact us to discuss your requirements prior to making a booking.

Guardian Angels Training

Gain comprehensive knowledge and practical skills in seizure first aid and rectal paraldehyde administration with our course. Ideal for caregivers, healthcare professionals, educators, and individuals.

An Understanding of Seizure First Aid and the Administration of Rectal Paraldehyde

Leyland

This course is for Pet Gun dogs aged 5 months upwards, that have had no prior training. This 5 week course &pound;85.On this course we show you how to connect with your Pet Gun Dog, Walk nicely on the lead, Sit &amp; Stay, Leave items, Introduction to Impulse Control, Recall to a whistle and much more.. Then if you wish to further your Pet Gun Dogs training we run a Level 2 course where you further the commands that you learnt on Level 1 and much more.. Further details can be found on the "Courses" page of our web site www.fourpawsdogtraining.co.uk

Four Paws Dog Training (Leyland)

Pet Gun Dog Foundation Course Level 1 For Pet Gun Dogs aged 5 months upwards.

Pet Gun Dog Foundation Level 1- £85

Loughborough

<div>
		

		<div>
			
			In today's fast-changing competitive environment, people in all roles need to have more commercial awareness and responsibility. 
			<div> 4 Hour Session</div>
			<div> £378.00 incl. VAT</div>
			
			
		</div>
	</div>

	

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

	

 <div>

		
		 
		

		<div></div>

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

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

	
		<h3>Description</h3>
		In today's fast-changing competitive environment, people in all roles need to have more commercial awareness and responsibility. This workshop will provide an opportunity to understand and apply a range of commercial analysis tools. We will examine what we mean by commercial awareness and the key analysis techniques, in order to increase your confidence and competence when dealing with commercial issues.
Available as private Face to Face and virtual sessions (max 12 delegates) - £1,305 Plus VAT

	
		<h3>Modules/Lessons</h3>
		Objectives
<ul>
<li>Improve your ability to identify business opportunities</li>
<li>Describe how the external environment impacts your organisation</li>
<li>Analyse the internal business strengths and weaknesses</li>
<li>Identify the external threats facing your organisation</li>
<li>Apply a systematic process to fully understand opportunities and issues</li>
</ul>
Topics
<ul>
<li>What is commercial awareness</li>
<li>Adopting a strategic approach</li>
<li>Key commercial analysis tools</li>
</ul>

Mpi Learning - Professional Learning And Development Provider

Online Course Marketing

Business Analysis

Commercial Manager

Business Leadership

Lean Awareness

ACT Awareness

In today's fast-changing competitive environment, people in all roles need to have more commercial awareness and responsibility.

Commercial Awareness - Tools and Analysis

This package is ideal for those who select the wrong partners repeatedly choosing emotionally unavailable people, bad characters and people that treat them badly.<ul style="color: rgb(230, 230, 230); box-sizing: border-box;" fr-original-style=" color: rgb(230, 230, 230);"><li style="color: rgb(0, 0, 0); font-weight: bold; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-weight: bold;">Dating Coach support for 6 weeks sessions twice a week</li><li style="color: rgb(0, 0, 0); font-weight: bold; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-weight: bold;">30 mins Dating Coach correctional dating training programme</li><li style="color: rgb(0, 0, 0); font-weight: bold; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-weight: bold;">Gift Package sent to home with Dating literature and guidance pamphlet Support and Advice</li><li style="color: rgb(0, 0, 0); font-weight: bold; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-weight: bold;">Dating advice for singles</li></ul><a href="https://relationshipsmdd.com/product/i-always-choose-the-wrong-people-to-date-package/" id="isPasted" fr-original-style="" style="-webkit-user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">https://relationshipsmdd.com/product/i-always-choose-the-wrong-people-to-date-package/</a>

Couples Counselling

M.D.D I ALWAYS CHOOSE THE WRONG PEOPLE TO DATE PACKAGE (SINGLES)

Cardiff

Become a Certified Solar Thermal Installer: 3-Day MCS-Approved CourseThis comprehensive 3-day course, fully aligned with National Occupational Standards (NOS), equips you with the knowledge and skills to design, install, maintain, and commission solar thermal hot water systems. Earning this MCS-recognized certificate fulfils the minimum technical competency (MTC) requirement for solar installers.Who Should Attend?Qualified plumbers, heating and ventilation (HV) technicians, or oil-fired/gas installation specialists seeking to expand their skillset into the growing solar thermal hot water market.Course Benefits:<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">&nbsp;Industry-Recognized Expertise: Master solar thermal systems in accordance with National Occupational Standards.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">&nbsp;MCS Certification: Earn a certificate recognized by Microgeneration Certification Scheme (MCS) operators, a valuable credential for solar&nbsp;installers.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">&nbsp;Comprehensive Training: Gain a thorough understanding of all aspects of solar thermal systems, from client needs assessment to system&nbsp;commissioning.</li></ul>What You&#39;ll Learn:<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"> Introduction to solar heating principles</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"> Selecting the most appropriate solar thermal system for a building</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"> Solar collector types and functionalities</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"> Hot water storage considerations and installation best practices</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"> Plumbing layout and design for solar water heating systems</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"> Control system requirements and operation</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"> Safe and efficient installation procedures</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"> System commissioning, handover to client, and maintenance</li></ul>Prerequisites:<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">&nbsp;Hold a relevant N/SVQ Level 2/3 qualification in Plumbing, Heating &amp; Ventilation (Domestic or Industrial/Commercial), Oil-Fired Technical Services,&nbsp;or Gas Installation &amp; Maintenance.</li></ul><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">&nbsp;Possess knowledge of Water Regulations/Byelaws and Unvented Hot&nbsp;Water Systems. We offer these courses on our website!</li></ul>Invest in your future as a solar thermal specialist. Enrol today!

City Training Group

Compliance & Safety

Solar Installation

Solar Thermal Hot Water Systems (BPEC NOS for MCS)

This live virtual Agility in HR (ICP-AHR) Training &amp; Certification Program enables the participants to learn:<ol fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">How to adopt and apply agile principles, values, and methodologies within the HR department itself &ndash; &ldquo;Agile for HR.&rdquo; &ndash; and</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">The role of HR in facilitating and supporting the adoption of Agile practices and principles across the organization &ndash; &ldquo;HR for Agile.&rdquo;</li></ol>During this&nbsp;live-immersive interactive workshop, participants will learn&nbsp;essential concepts&nbsp;related to&nbsp;&ldquo;Agile for HR&rdquo;&nbsp;through&nbsp;practical, easy-to-follow, hands-on exercises. By actively participating, attendees will develop a comprehensive understanding of:<ol fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR processes:&nbsp;adopting iterative and incremental approaches to HR processes like performance management, recruitment, and onboarding.</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile HR project management:&nbsp;This involves using Agile project management frameworks (e.g., Scrum or Kanban) to manage HR initiatives.</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Cross-functional collaboration:&nbsp;Promoting collaboration between HR and other departments using Agile principles, such as self-organizing teams and regular feedback loops.</li></ol>Throughout the course, participants will&nbsp;acquire knowledge&nbsp;on&nbsp;&ldquo;HR for Agile&rdquo;&nbsp;and&nbsp;gain the ability to facilitate and support agile transformation within their organization. The training program includes&nbsp;relevant case studies, useful tools, and effective techniques related to:<ol fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile talent acquisition:&nbsp;Implementing recruitment strategies prioritizing individuals with an Agile mindset and values.</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile performance management:&nbsp;shifting to Agile-friendly approaches such as continuous feedback and frequent check-ins.</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile Learning and Development:&nbsp;Providing training programs that equip employees with Agile skills and mindsets.</li><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">Agile organizational design:&nbsp;collaborating on restructuring the organization to support Agile practices like cross-functional teams and autonomy.</li></ol>Bonus Module: Enhancing HR Agility with AI &amp; Analytics:&nbsp;This module explores the integration of AI and analytics to revolutionize HR practices, aligning them with agile principles. Participants will learn how these technologies can automate tasks, enhance decision-making, and support agile transformations across the organization. Through focused examples, the session highlights the impact on recruitment, performance management, and overall HR efficiency, offering a forward-looking approach to agile HR management.This course will be delivered through live virtual sessions via Zoom.&nbsp;There are the following dates on which you can opt for this course:<ol fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">Agile HR | 8-10 Apr | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">Agile HR | 13-15 May | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">Agile HR | 12-14 Jun | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">Agile HR | 22-24 Jul | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">Agile HR | 14-16 Aug | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">Agile HR | 16-18 Sep | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">Agile HR | 9-11 Oct | 9 am - 2 pm BST | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">Agile HR | 18-20 Nov | 9 am - 2 pm GMT | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</li><li style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">Agile HR | 18-20 Dec | 9 am - 2 pm GMT | Weekday | 3 days - 5 hrs/day | Best for UK / Europe</li></ol><div fr-original-style="" style="box-sizing: border-box;">The following are the links to the essential documents that will help you make an informed decision: </div><ol fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><div fr-original-style="" style="box-sizing: border-box;">Detailed course brochure: <a href="https://drive.google.com/file/d/1PARAqO_uN8WLtXb8e6OKoawB60afNwJ_/view?usp=drive_link" 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;">Click Here</a>&nbsp;or download via the link below:&nbsp;</div></li></ol><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><a href="https://drive.google.com/file/d/1PARAqO_uN8WLtXb8e6OKoawB60afNwJ_/view?usp=drive_link" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">https://drive.google.com/file/d/1PARAqO_uN8WLtXb8e6OKoawB60afNwJ_/view?usp=drive_link</a>&nbsp;</div></li></ul><ol fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;"><div fr-original-style="" style="box-sizing: border-box;">Testimonials from global HR professionals: <a href="https://drive.google.com/file/d/1wYNCJAMiNQeeihcluQEY5JdBkjgYtW6S/view?usp=drive_link" 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;">Click Here</a>&nbsp;or download via the link below:&nbsp;</div></li></ol><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;"><a href="https://drive.google.com/file/d/1wYNCJAMiNQeeihcluQEY5JdBkjgYtW6S/view?usp=drive_link" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">https://drive.google.com/file/d/1wYNCJAMiNQeeihcluQEY5JdBkjgYtW6S/view?usp=drive_link</a>&nbsp;</div></li></ul>

ValueX2

https://www.valuex2.com/agile-hr-certification/
https://www.linkedin.com/company/80563537/

ICAgile's Agility in HR (ICP-AHR) Training & Certification Program by ValueX2 | 3 days - 5 hrs/day | 9 am - 2 pm UK Time

<div id="course-pills-1">Duration2 Days12 CPD hoursThis course is intended forThe audience for this course is anyone who wants to acquire foundation level knowledge on data centre infrastructure. This course is ideally suited for data centre new hires, internal data centre support staff, IT support staff who work in the data centre, helpdesk staff, vendors/suppliers who install/maintain data centre equipment, building maintenance staff including data centre cleaners and other supporting functions, and fresh graduates. This course is also well suited for individuals working in data centre business support functions such as sales/pre-sales, HR, Finance and business administration.OverviewThe DCFC course will prepare participants for entry into the exciting and high-growth data centre industry. It will ensure that participants acquire the required basic knowledge to take on a wide variety of jobs in the data centre industry. It will also provide the required knowledge and skill to further their training into specialised areas on data centre design/build, operations/governance or standards/compliance.The Data Centre Foundation Certificate (DCFCÂ©) is a 2-day course designed to deliver foundation knowledge about data centre facilities infrastructure. It provides participants with global overview and knowledge on data centres which will be of advantage to the participants who are looking at joining the ranks of professionals working in the data centre, ICT, infrastructure or the mechanical and electrical (M&amp;E) design industries. It will also form a solid foundation for participants who wish to pursue his/her studies either academically or to further his/her industry specialisation with professional certification courses on data centre design/build, operations/governance and/or standards/compliance. With the tremendous growth of data and the data centres to support it, the demand for data centre professionals will grow in tandem.</div><div id="course-pills-2"><h4>Introduction to Data Centres</h4><ul><li>History of data centres</li><li>Definition of different type data centres</li></ul><h4>Data Centre Standards</h4><ul><li>List of standards</li><li>Rating definitions</li></ul><h4>Data Centre Facilities Areas</h4><ul><li>Listing of all areas and their functions</li></ul><h4>Topology Designs</h4><ul><li>Definition of Ratings</li></ul><h4>Components of the Power Infrastructure</h4><ul><li>Utility power</li><li>Transformers</li><li>Generators</li><li>Fuel systems</li><li>ATS</li><li>UPS systems</li><li>Batteries</li><li>Electric panels</li><li>Cabling/busbar systems</li><li>Power rails/strips</li></ul><h4>Lights</h4><ul><li>Lights</li><li>Emergency lights</li></ul><h4>Cooling Infrastructure</h4><ul><li>Chillers</li><li>DX Systems</li><li>Evaporators</li><li>CRAC/CRAU/HVAC</li><li>Raised floor</li><li>Non-raised floor</li><li>Containment</li></ul><h4>ICT/Network Infrastructure</h4><ul><li>Equipment racks</li><li>Network cabling (fibre, copper)</li><li>Cable trays and pathways</li><li>TIA-606 labelling</li></ul><h4>Data Centre Security</h4><ul><li>Perimeter security</li><li>Physical protection</li><li>CCTV</li><li>Access control</li><li>Security management</li></ul><h4>Fire Suppression</h4><ul><li>Detection systems</li><li>Suppression systems</li><li>Prevention systems</li><li>Fire extinguishers</li><li>Fire Safety</li></ul><h4>Monitoring and reporting</h4><ul><li>DCIM</li><li>EMS/BMS</li></ul></div>

Nexus Human

Design & Technology Courses (DT)

Service Design Courses (SDC)

IT Certifications

Cyber Security Foundation

Certified in Data Protection (CDP)

ICDL (International Certification of Digital Literacy)

Data Centre Foundation Certificate (DCFC)

Southend on Sea

Droitwich Spa

Portsmouth

Rotherham

Manchester

Leeds

Slough

Bingley

Newport

Peterborough

Milton Keynes 

Nottingham

Paisley

Birmingham

Luton

Hull

Northampton

Bedford

Liverpool 

Swansea

BASIC to ADVANCED COURSE PACKAGE

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

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

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

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

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






Key Facts & Summary:


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

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

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

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

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

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

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

DOWNLOAD A COURSE ITINERARY HERE



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

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

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

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

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

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

DOWNLOAD A COURSE ITINERARY HERE



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

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

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

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

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

DOWNLOAD A COURSE ITINERARY HERE




How do I attend?

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

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

OR -

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

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

How do I book?

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

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

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

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

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

Geopace Training

Allied Health

Blood Taking

Healthcare Workers

Venepuncture

Phlebotomist

Phlebotomy

Accredited Phlebotomy

Healthcare

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

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

FAST-TRACK YOUR PHLEBOTOMY TRAINING

WITH OUR

COMPLETE TRAINING PACKAGE

20% off -  Multi-Course Discount

    Cover all stages from beginner through to Level 4

    Available as Classroom or Virtual Classroom

    Complete your beginner to advanced training in 2 days

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

    Both courses are dually accredited (OCN & CPD)

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

    Covers all steps up to live blood draw

    Learn advanced skills and techniques

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

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


Phlebotomy Training - Beginner to Advanced PACKAGE

<h1 id="isPasted" style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Online MHFA England Adult Mental Health First Aid Course.&nbsp;</h1><div fr-original-style="" style="box-sizing: border-box;"><a href="https://www.mindmapswellbeing.com/brochure-request/" 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;">Download brochure for course details here.</a><a href="https://www.mindmapswellbeing.com/_webedit/uploaded-files/All%20Files/Online%20Mental%20Health%20First%20Aid.pdf" rel="noopener noreferrer" target="_blank" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">&nbsp;</a>&nbsp;</div><div fr-original-style="" style="box-sizing: border-box;"> </div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">This online version of the mental health first aid course will offer the same learning outcomes as the face to face training, and every person who completes the course will be certified as a Mental Health First Aider. &nbsp;The Online Mental Health First Aid course is a blended approach of individual learning and four instructor-led live sessions, hosted on a new Online Learning Hub. &nbsp;As a training course, Mental Health First Aid teaches people how to identify, understand and help someone who may be experiencing a mental health issue. The organisation&#39;s courses and resources also promote self-care as a vital way for people to help protect their mental health and prevent issues from getting worse. &nbsp;As with all our courses at Mindmaps Wellbeing, your course will be delivered by a Registered Mental Health Nurse, MHFA England Instructor and Open University Associate Lecturer and Practice Tutor experienced in remote teaching. Our live online learning will also include an assistant who is a MHFAider. &nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"> </div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Our fee is &pound;300pp Groups of 5+ contact <a href="mailto:info@mindmapswellbeing.com" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">info@mindmapswellbeing.com</a>&nbsp;for reduced group fees.&nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);"> </div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Live instructor led sessions;&nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">10:00 &ndash; 12:30 &amp; 14:30 &ndash; 17:00 both days&nbsp;</div><div style="color: rgb(62, 62, 62); box-sizing: border-box;" fr-original-style=" color: rgb(62, 62, 62);">Individual learning modules around these times. You will gain access to this on the Friday before your course start date.</div>Why choosing Mindmaps Wellbeing is a good choice for your training.The MHFA England RRP is &pound;325pp, our rate is &pound;300pp and our fee includes:✅ Instructor led training sessions over two days✅ Course Manual✅ Workbook✅ Handy Cue Card✅ MHFAider Certificate upon completionPlus, exclusively when you choose Mindmaps Wellbeing, it also includes:✅ Your instructors are Registered Mental Health Nurses and Healthcare Educators (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).✅ Access to our online MHFAider peer support groups moderated by the instructor team.✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.✅ Advanced Delegate Plan &ndash; This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.&nbsp;For a little extra:&nbsp;✅ Quarterly Facilitated MHFAider Forum &ndash; to provide ongoing expert support and guidance.&nbsp;✅ Organisational MINDWELL Companion tailored for your workplace / organisation.

Online MHFA England Adult Mental Health First Aid Course. 
Download brochure for course details here.  This online version of the mental health first aid course will offer the same learning outcomes as the face to face training, and every person who completes the course will be certified as a Mental Health First Aider. The Online Mental Health First Aid course is a blended approach of individual learning and four instructor-led live sessions, hosted on a new Online Learning Hub. As a training course, Mental Health First Aid teaches people how to identify, understand and help someone who may be experiencing a mental health issue. The organisation's courses and resources also promote self-care as a vital way for people to help protect their mental health and prevent issues from getting worse. As with all our courses at Mindmaps Wellbeing, your course will be delivered by a Registered Mental Health Nurse, MHFA England Instructor and Open University Associate Lecturer and Practice Tutor experienced in remote teaching. Our live online learning will also include an assistant who is a MHFAider. Our fee is £300pp Groups of 5+ contact info@mindmapswellbeing.com for reduced group fees. Live instructor led sessions; 10:00 – 12:30 & 14:30 – 17:00 both days Individual learning modules around these times. You will gain access to this on the Friday before your course start date.
Why choosing Mindmaps Wellbeing is a good choice for your training.
The MHFA England RRP is £325pp, our rate is £300pp and our fee includes:
✅ Instructor led training sessions over two days
✅ Course Manual
✅ Workbook
✅ Handy Cue Card
✅ MHFAider Certificate upon completion
Plus, exclusively when you choose Mindmaps Wellbeing, it also includes:
✅ Your instructors are Registered Mental Health Nurses and Healthcare Educators (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).
✅ Access to our online MHFAider peer support groups moderated by the instructor team.
✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.
✅ Advanced Delegate Plan – This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.
 
For a little extra: 
✅ Quarterly Facilitated MHFAider Forum – to provide ongoing expert support and guidance. 
✅ Organisational MINDWELL Companion tailored for your workplace / organisation.

Mindmaps Wellbeing

Health & Wellbeing

Occupational Health & Wellbeing

Mental Health

Accredited Mental Health First Aid

Mental Health At Work

Mental Health Nurse

Online MHFA England mental health first aid course delivered by Registered Mental Health Nurses from Mindmaps Wellbeing. 

Why choosing Mindmaps Wellbeing is a good choice for your mental health training.
The MHFA England RRP is £325pp, our rate is £300pp and our fee includes:
✅ Instructor led training sessions over two days 
✅ Course Manual
✅ Workbook
✅ Handy Cue Card
✅ MHFAider Certificate upon completion
Plus, exclusively when you choose Mindmaps Wellbeing, it also includes:

✅ Your instructors are Registered Mental Health Nurses and Healthcare Educators (They of course have their own lived experiences too, which they bring to the course, ensuring the content is brought to life).

✅ Access to our online MHFAider peer support groups moderated by the instructor team.

✅ Access to MINDWELL companion for resources, self-care, and ongoing guidance to support you in the role as a MHFAider.

✅ Advanced Delegate Plan – This allows delegates to book onto our open courses on dates that suit, with the best value on course fees available.

For a little extra: 

✅ Quarterly Facilitated MHFAider Forum – to provide ongoing expert support and guidance. 

✅ Organisational MINDWELL Companion tailored for your workplace / organisation.


MHFA England Mental Health First Aid

This engaging and dynamic advanced CPD-certified course is an extension to the Born at the Right Time Essentials in Communication and Co-production with Parents/Carers. We recommend that you have completed the &#39;Essentials&#39; course before booking this course (please see our booking page or contact admin@bornattherighttime.com to find out more).&nbsp;Founded on lived experience, this course looks at the key factors which lead to a break down in relationships between parents/carers and practitioners, how this understanding can inform next steps and what meaningful connections between professionals and families might look like. Practitioners should come ready to be interactive and reflective as well as learning from psychology, sociology and research into trauma informed care. Content<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Using lived experience to understand what can lead to conflict and relationship breakdown&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 16px;">Relationship building and avoiding conflict and the factors underpinning challenging situations and difficult conversations&nbsp;&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">System structures which negatively affect effective communication and collaboration&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The impact of trauma and use of trauma informed practice&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">BRAVING inventory (Brene Brown) and creating healthy boundaries&nbsp;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Ways to create professional, meaningful connection with parents/carers in the current context. </li></ul>Delivery<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">2 x 3.5 hours virtual live event (7 hour CPD) on 10th and 17th October 2024</li></ul>

This engaging and dynamic advanced CPD-certified course is an extension to the Born at the Right Time Essentials in Communication and Co-production with Parents/Carers. We recommend that you have completed the 'Essentials' course before booking this course (please see our booking page or contact admin@bornattherighttime.com to find out more). 
Founded on lived experience, this course looks at the key factors which lead to a break down in relationships between parents/carers and practitioners, how this understanding can inform next steps and what meaningful connections between professionals and families might look like. Practitioners should come ready to be interactive and reflective as well as learning from psychology, sociology and research into trauma informed care.

Content
Using lived experience to understand what can lead to conflict and relationship breakdown
Relationship building and avoiding conflict and the factors underpinning challenging situations and difficult conversations
System structures which negatively affect effective communication and collaboration
The impact of trauma and use of trauma informed practice
BRAVING inventory (Brene Brown) and creating healthy boundaries
Ways to create professional, meaningful connection with parents/carers in the current context.
Delivery
2 x 3.5 hours virtual live event (7 hour CPD) on 10th and 17th October 2024

Born at the Right Time

Learning Disability Nurse

SENCO

Midwifery

Sen Teaching Assistant

Speech & Language Therapist

Social Worker

Occupational Therapist

Disability Awareness

Speech & Language Therapy (SLT)

Social Care

Learning Disability

Physiotherapist

Inspiring, interactive and unique 4-hour CPD certified Communication and Co-production training. 

Difficult Conversations, Conflict and Relationship Building with Parents/Carers (Oct 24)

There are a number of reasons why it is important to actively promote equality and diversity within your business and the wider community, not only to ensure compliance with anti-discrimination legislation and professional regulations, including the SRA Standards &amp; Regulations. &nbsp;There will also be business benefits to the organisation including attracting and retaining talented staff, improving staff morale, potentially accessing a wider client base and enhancing service levels and client satisfaction.Join us for this useful overview session on Equality, Diversity &amp; Inclusion which will cover the following points;<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The Meaning of Equality</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discrimination</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Harassment &amp; Victimisation</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unconscious Bias</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The Equality Act &amp; the Protected Characteristics</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Reasonable Adjustments</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Complying with E&amp;D requirements</li></ul><h2 data-key="21" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Target Audience</h2><p data-key="23" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMlRhcmdldCUyMEF1ZGllbmNlJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyVGhlJTIwb25saW5lJTIwY291cnNlJTIwaXMlMjBzdWl0YWJsZSUyMGZvciUyMHN0YWZmJTIwb2YlMjBhbGwlMjBsZXZlbHMlMkMlMjBmcm9tJTIwc3VwcG9ydCUyMHN0YWZmJTIwdG8lMjBzZW5pb3IlMjBwYXJ0bmVycy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">The online course is suitable for staff of all levels, from support staff to senior partners.<h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Resources</h2>Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.<p data-key="30" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMkNvdXJzZSUyME5vdGVzJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQ29tcHJlaGVuc2l2ZSUyMGFuZCUyMHVwJTIwdG8lMjBkYXRlJTIwY291cnNlJTIwbm90ZXMlMjB3aWxsJTIwYmUlMjBwcm92aWRlZCUyMHRvJTIwYWxsJTIwZGVsZWdhdGVzJTIwd2hpY2glMjBtYXklMjBiZSUyMHVzZWZ1bCUyMGZvciUyMG9uZ29pbmclMjByZWZlcmVuY2UlMjBvciUyMGNhc2NhZGUlMjB0cmFpbmluZy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJQbGVhc2UlMjBub3RlJTIwYSUyMHJlY29yZGluZyUyMG9mJTIwdGhlJTIwY291cnNlJTIwd2lsbCUyMCUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTJDJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJub3QlMjAlMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMm1hcmslMjIlMkMlMjJ0eXBlJTIyJTNBJTIyYm9sZCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlN0QlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMmJlJTIwbWFkZSUyMGF2YWlsYWJsZS4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please note a recording of the course will&nbsp;not&nbsp;be made available.<h2 data-key="35" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Speaker</h2><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><a fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Amie Higgins, Consultant, DG Legal</a></h3>Amie is a Senior Solicitor, qualified under the Law Society&rsquo;s Immigration &amp; Asylum Accreditation Scheme (IAAS) as an Advanced Caseworker and Supervisor. Amie specialises in all aspects of Immigration, Asylum and Human Rights work, with a specialism in human trafficking/modern slavery cases and working with vulnerable clients.<p data-key="41" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMlNwZWFrZXIlMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJBbWllJTIwSGlnZ2lucyUyQyUyMENvbnN1bHRhbnQlMkMlMjBERyUyMExlZ2FsJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJtYXJrJTIyJTJDJTIydHlwZSUyMiUzQSUyMmJvbGQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTdEJTVEJTdEJTVEJTdEJTVEJTdEJTJDJTdCJTIyb2JqZWN0JTIyJTNBJTIyYmxvY2slMjIlMkMlMjJ0eXBlJTIyJTNBJTIycGFyYWdyYXBoJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMkFtaWUlMjBpcyUyMGElMjBTZW5pb3IlMjBTb2xpY2l0b3IlMkMlMjBxdWFsaWZpZWQlMjB1bmRlciUyMHRoZSUyMExhdyUyMFNvY2lldHklRTIlODAlOTlzJTIwSW1taWdyYXRpb24lMjAlMjYlMjBBc3lsdW0lMjBBY2NyZWRpdGF0aW9uJTIwU2NoZW1lJTIwKElBQVMpJTIwYXMlMjBhbiUyMEFkdmFuY2VkJTIwQ2FzZXdvcmtlciUyMGFuZCUyMFN1cGVydmlzb3IuJTIwQW1pZSUyMHNwZWNpYWxpc2VzJTIwaW4lMjBhbGwlMjBhc3BlY3RzJTIwb2YlMjBJbW1pZ3JhdGlvbiUyQyUyMEFzeWx1bSUyMGFuZCUyMEh1bWFuJTIwUmlnaHRzJTIwd29yayUyQyUyMHdpdGglMjBhJTIwc3BlY2lhbGlzbSUyMGluJTIwaHVtYW4lMjB0cmFmZmlja2luZyUyRm1vZGVybiUyMHNsYXZlcnklMjBjYXNlcyUyMGFuZCUyMHdvcmtpbmclMjB3aXRoJTIwdnVsbmVyYWJsZSUyMGNsaWVudHMuJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQW1pZSUyMGlzJTIwYW4lMjBleHBlcmllbmNlZCUyMHRyYWluZXIlMkMlMjBkZWxpdmVyaW5nJTIwYSUyMHJhbmdlJTIwb2YlMjB0cmFpbmluZyUyMG9uJTIwYm90aCUyMGxlZ2FsJTIwYW5kJTIwcHJhY3RpY2UlMjBtYW5hZ2VtZW50JTIwdG9waWNzLiUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTVEJTdEJTVEJTdEJTVEJTdE" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Amie is an experienced trainer, delivering a range of training on both legal and practice management topics.

There are a number of reasons why it is important to actively promote equality and diversity within your business and the wider community, not only to ensure compliance with anti-discrimination legislation and professional regulations, including the SRA Standards & Regulations. There will also be business benefits to the organisation including attracting and retaining talented staff, improving staff morale, potentially accessing a wider client base and enhancing service levels and client satisfaction.
Join us for this useful overview session on Equality, Diversity & Inclusion which will cover the following points;
The Meaning of Equality
Discrimination
Harassment & Victimisation
Unconscious Bias
The Equality Act & the Protected Characteristics
Reasonable Adjustments
Complying with E&D requirements
Target Audience
The online course is suitable for staff of all levels, from support staff to senior partners.
Resources
Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training.
Please note a recording of the course will not be made available.
Speaker
Amie Higgins, Consultant, DG Legal
Amie is a Senior Solicitor, qualified under the Law Society’s Immigration & Asylum Accreditation Scheme (IAAS) as an Advanced Caseworker and Supervisor. Amie specialises in all aspects of Immigration, Asylum and Human Rights work, with a specialism in human trafficking/modern slavery cases and working with vulnerable clients.
Amie is an experienced trainer, delivering a range of training on both legal and practice management topics.

DG Legal

Equality, Diversity & Inclusion for Lawyers Course

General Delegate

A discount is available for delegates attending from firms with a current retainer contract with DG Legal (please contact us by email to admin@dglegal.co.uk for confirmation of eligibility).   If you choose this option and are not eligible, you are still bound to pay the full rate and will be invoiced accordingly.

Retainer Delegate

This live on-line training seminar provides an introduction for anyone who wants to learn more about the complex nature of domestic abuse. From spotting the early warning signs to the impact.  Sadly domestic abuse can be perpetrated by anyone and anyone can be a victim of domestic abuse.  It is a global societal issue and far more prevalent than many of us realise.
Latest statistics state that over £2.3 million people (aged 16 years and over) experience domestic abuse per year.
This equates to 1 in 4 women and 1 in 6 men
By attending this event you will gain an
• Increased understanding of domestic abuse
• Increased ability to recognise the early signs of domestic abuse 
• A PDF on next steps to support 
This on-line training workshop will introduce you to the types of domestic abuse and the tactics employed by the perpetrator.  By the end of the session attendees will feel confident in identifying domestic abuse and steps to support.  
This training workshop will provide the first step towards understanding a many layered and complex subject.  This will provide a good overview prior to delving deeper into specific forms of domestic abuse.
This training seminar will provide a good introduction for general public, frontline workers, volunteers, employers, managers, teachers, volunteers.
CPD credits are awarded with this workshop.
Attendees will receive handouts and an attendance certificate (if required).
This event is hosted by Julie Johns MBE. 
The workshop will be delivered as a 1 hour live Zoom event and is being offered at £30 per person. 

Safe Space Consultancy

Domestic Abuse

Family Assault

Child Protection

Independent Domestic Violence Advisor (IDVA)

Domestic Violence

Identifying Domestic Abuse (CPD).  A good introductory seminar for anyone who wants to learn about the complex nature of domestic abuse.  You will have increased knowledge of domestic abuse in general, an increased ability to identify the early signs of domestic abuse and knowledge of next steps to support.

Identifying Domestic Abuse

Early Bird

Facilitated by: Teresa Nightingale, HIGN trustee and Income Generation &amp; Marketing Director, Wirral Hospice St John&rsquo;sSharing and networking session to introduce any newcomers to the hospice sector to each other. To also discuss topics that will be suitable for HIGN to set up as training or networking sessions for you to join. THIS SESSION WILL NOT BE RECORDED. Session aimed at those relatively new (joined within the last 12mths) to the hospice sector: various roles

Facilitated by: Teresa Nightingale, HIGN trustee and Income Generation & Marketing Director, Wirral Hospice St John’s
Sharing and networking session to introduce any newcomers to the hospice sector to each other.
To also discuss topics that will be suitable for HIGN to set up as training or networking sessions for you to join.

THIS SESSION WILL NOT BE RECORDED.
Session aimed at those relatively new (joined within the last 12mths) to the hospice sector: various roles

Hospice Income Generation Network

Thu 10 Oct 2024: Newcomers Networking

<div id="course-pills-1">Duration2 Days12 CPD hoursThis course is intended forThis course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4> Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. 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.</div>

Learning & Development

Data Skills

Trainers Course

Microsoft AZ-303

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

Join us for an exclusive webinar where we will showcase our brand-new Custom Certificates feature, designed to help you streamline the way you create, issue, and manage certificates. Whether you’re issuing course completions, attendance acknowledgements, or professional qualifications, our new feature provides flexibility and efficiency to elevate your course offerings.

What You’ll Learn:
How to design and build custom certificate templates using the new Certificate Builder.
Best practices for automating certificate issuing and expiration management.
How to use new features like auto-issuing, certificate expiration tracking, and more.
Tips for managing certificates at scale, including viewing, revoking, and filtering contacts by certificate expiry dates.


Interactive Q&A & Feedback Session
We want to hear from you! This is your opportunity to ask questions, share feedback, and request new features or improvements. We’re dedicated to making Cademy work better for you, so your input is invaluable in shaping future updates.

Who Should Attend?
This webinar is perfect for course creators, administrators, and training managers who want to enhance their certificate management process and make their courses stand out.
Custom Certificates are only available to customers on the Pro plan or above. If you’re not on the Pro plan yet, this is the perfect opportunity to learn more about this feature and explore upgrading to unlock its full potential.
Don’t miss this chance to see our latest features in action and contribute to the future of Cademy!

1474 Courses in Cardiff

M.D.D OUR RELATIONSHIP IS AN EMOTIONAL ROLLERCOASTER (COUPLES)

By Miss Date Doctor Dating Coach London, Couples Therapy

M.D.D DATING ADVICE FOR WOMEN INTROSPECTION PACKAGE (DATING ADVICE FOR WOMEN)

By Miss Date Doctor Dating Coach London, Couples Therapy

Clinical Supervision - Training for Supervisors

By M&K Update Ltd

M.D.D MY TEENAGER IS OUT OF CONTROL PACKAGE (FAMILY RELATIONSHIP ISSUES)

By Miss Date Doctor Dating Coach London, Couples Therapy

Microsoft Excel Macros & VBA - In-company

By Microsoft Office Training

An Understanding of Seizure First Aid and the Administration of Rectal Paraldehyde

By Guardian Angels Training

Pet Gun Dog Foundation Level 1- £85

By Four Paws Dog Training (Leyland)

Commercial Awareness - Tools and Analysis

By Mpi Learning - Professional Learning And Development Provider

M.D.D I ALWAYS CHOOSE THE WRONG PEOPLE TO DATE PACKAGE (SINGLES)

By Miss Date Doctor Dating Coach London, Couples Therapy

Solar Thermal Hot Water Systems (BPEC NOS for MCS)

By City Training Group

Search By Location