Wakefield

<section data-element_type="section" data-id="141278d" fr-original-style=" color: rgb(102, 102, 102);" id="isPasted" style="color: rgb(102, 102, 102); box-sizing: border-box;"><div data-element_type="column" data-id="e6dbe55" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="2d2bccd" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><section data-element_type="section" data-id="2aa0345" fr-original-style=" color: rgb(102, 102, 102);" id="isPasted" style="color: rgb(102, 102, 102); box-sizing: border-box;"><div data-element_type="column" data-id="1938d5f" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="f368761" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><section data-element_type="section" data-id="a40907e" fr-original-style="" id="isPasted" style="box-sizing: border-box;"><div data-element_type="column" data-id="80d9f93" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="d499d73" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style=" color: var( --e-global-color-primary );" style="color: var( --e-global-color-primary ); box-sizing: border-box;">Overview</h2></div></div></section><section data-element_type="section" data-id="699d259" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="4cfd84c" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="32c6b5e" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">This one day&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Building Better Work Habits</strong> training course has been developed for everyone in your organisation who may struggle with their own personal effectiveness. They may not have control of their own workload or blame others as to why they&rsquo;re not achieving certain tasks and projects. Alternatively, it might be that high performers want to understand how they can organise themselves in a new way to give themselves more stretch in their roles.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">The training course will help the learners build self-awareness and will highlight the important parts of working smarter to achieve end goals.</p></div></div></section><section data-element_type="section" data-id="cf3e46f" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="9f8bc76" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="5a51812" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style=" color: var( --e-global-color-primary );" style="color: var( --e-global-color-primary ); box-sizing: border-box;">Description</h2></div></div></section><section data-element_type="section" data-id="649d69e" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="941a4e4" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="fd58605" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">We are all busy, and sometimes it seems we do not have enough hours in the day to complete deadlines and projects. It can then eat into our home life, meaning we often end up stressed, or in worst-case scenarios, unwell (both physically and mentally). The reason behind this is often how we work day to day, as opposed to others giving us work at the last minute.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">These training course materials have been designed to help your participants work more effectively for the long term. This isn&rsquo;t about how to manage a diary or emails, but rather look closely to see what are the blockers which get in the way of success. These small changes in day to day work will have a dramatic impact in both productivity and personal effectiveness.</p><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Topics covered:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Productivity: the science bit&nbsp;</strong>&ndash; A chance to explore what we mean by being productive and how that helps us build better work habits, as well as the opportunity to look at some of the science behind myths and bad habits we&rsquo;ve probably already formed. Includes a link to a YouTube video.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Procrastination, why put off to tomorrow what we can do today!&nbsp;</strong>&ndash; Participants will explore what we procrastinate about, how we procrastinate in our own lives, and what we can do about it!</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Eat That Frog&nbsp;</strong>&ndash; An introduction to Brian Tracy&rsquo;s book &ldquo;Eat that frog&rdquo; and how it can help us improve our working habits. Includes a link to a YouTube video.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Eat That Frog: Thinking on Paper&nbsp;</strong>&ndash; A chance to put into practice some of Brian Tracy&rsquo;s methods and how to use them in our real lives</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Eat That Frog: Rocks, Pebbles and Sand</strong> &ndash; Taking our goal setting further, we explore Covey&rsquo;s methodology around prioritising our tasks.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Eat That Frog: The Pareto Principle</strong>&nbsp;&ndash; The final part of the &ldquo;Eat that Frog&rdquo; section looks at how effective we in terms of how we spend our day</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Prioritising: how do we spend our day?</strong>&nbsp;&ndash; Participants explore how proactive they are, and what the danger might be in letting a situation rule their time</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Prioritising: The Priority Matrix</strong>&nbsp;&ndash; Taking the Rock, Pebbles and Sand methodology further, participants explore what truly is urgent and what is important in our day to day</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Prioritising: Company Performance Tensions</strong>&nbsp;&ndash; We may know what our own personal objectives are, however, our business objectives have certain tensions that could impact these. How can we balance these two different objectives to ensure we&rsquo;re successful day to day?</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What&rsquo;s my mindset?</strong>&nbsp;&ndash; Sometimes we can get in the way of our own successes and plans due to our mindset; utilising Carol Dweck&rsquo;s work, it is a chance to reflect on our own mindsets when we&rsquo;re building new work habits. Includes a link to a YouTube video.</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What&rsquo;s my mindset? Energy Cycles</strong>&nbsp;&ndash; Our energy can impact our mindset and how productive we are. A chance to look at what gives us energy, and how we can work more effectively depending on where our energy levels might be</li></ul></div></div></section><section data-element_type="section" data-id="8b42a41" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="6be2803" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="f08ab9c" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style=" color: var( --e-global-color-primary );" style="color: var( --e-global-color-primary ); box-sizing: border-box;">Who should attend</h2></div></div></section><section data-element_type="section" data-id="b209fea" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="ce601c1" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="e88578c" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">Anyone interested in understanding in being more effective at work.</p></div></div></section><section data-element_type="section" data-id="c7c52a5" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="68fd8e5" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="cae9269" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 fr-original-style=" color: var( --e-global-color-primary );" style="color: var( --e-global-color-primary ); box-sizing: border-box;">Requirements for Attendees</h2></div></div></section><section data-element_type="section" data-id="ac22cd1" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="column" data-id="28a3b4e" fr-original-style="" style="box-sizing: border-box;"><div data-element_type="widget" data-id="02734e3" data-widget_type="text-editor.default" fr-original-style=" color: rgb(102, 102, 102);" style="color: rgb(102, 102, 102); box-sizing: border-box;"><p fr-original-style="" style="font-size: 16px; color: var(--text); box-sizing: border-box;">None.</p></div><div data-element_type="widget" data-id="0b11949" data-widget_type="button.default" fr-original-style=" color: rgb(102, 102, 102);" style="color: rgb(102, 102, 102); box-sizing: border-box;"><a fr-original-style=" color: rgb(255, 255, 255);" href="mailto:sales@18.132.1.174?subject=%27Building%20Better%20Work%20Habits%27%20Training%20Course" style="color: rgb(255, 255, 255); user-select: auto; box-sizing: border-box; text-decoration: inherit; cursor: pointer;"><br fr-original-style="" style="box-sizing: border-box;">
</a></div></div></section></div></div></section></div></div></section><section data-element_type="section" data-id="f9cb5f1" fr-original-style=" color: rgb(102, 102, 102);" style="color: rgb(102, 102, 102); box-sizing: border-box;"><div data-element_type="column" data-id="bda27b8" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div></section>

Inovra Group

Business Development

Professional Development

Building Better Work Habits

Session for up to ten delegates in a single session

Group Session

London

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Work with advanced lookup and reference functions</li><li>Create macros to automate common tasks</li><li>Use advanced techniques to analyse data</li><li>Create PivotTables and PivotCharts</li><li>Work with data validation tools</li><li>Import and export data</li></ul><p>'</p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Best Training Ever!</strong></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><p><strong>The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic.</strong></p></li><li>Marving Lopez - AM Best Europe</li></ul><ul><li><strong>Pedro was excellent. Very knowledgeable, clear and great rapport with class.</strong></li><li>Darren Barkey - Direct Wines</li></ul><ul><li><strong>Great content and learnt a lot. Really enjoyable :)</strong></li><li>Kristie-Lee Ryan - Stirling Ackroyd</li></ul><p>1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>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.</p><p>Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.</p><p><strong>Advanced Functions</strong></p><ul><li>COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL</li><li>IF, OR, AND, IFERROR</li><li>VLOOKUP to lookup Exact Values and Approximate values</li><li>MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET</li></ul><p><strong>Analysing Data</strong></p><ul><li>PMT function to calculate a monthly payment of a loan</li><li>What If Analysis using Goal Seek</li><li>Use scenarios to consider many different variables</li><li>Using Solver Add-in to optimize variables</li></ul><p><strong>PivotTables</strong></p><ul><li>Create a PivotTable to analyse worksheet data</li><li>Add or remove fields in a PivotTable</li><li>Change the data source for a PivotTable</li><li>Working with external data sources</li><li>Using different Statistical Functions</li><li>Calculate a Running Total, % of Grant Total, Difference From…</li><li>Using the Slicer and Timeline to filter the PivotTable</li><li>Using Filters in a PivotTable</li><li>Group by Date, Auto Group by ranges of values, Custom Group</li><li>Create a PivotChart</li><li>The GETPIVOTDATA function</li></ul><p><strong>Formula auditing</strong></p><ul><li>Precedents and dependents</li><li>Error checking</li><li>Watch a formula and its result by using the Watch Window</li><li>Evaluate a nested formula one step at a time</li></ul><p><strong>Data Validation</strong></p><ul><li>Number Validation</li><li>Data List Validation</li><li>Message Prompts and Alerts</li><li>Conditional Data Validation</li><li>Data Validation Errors</li></ul><p><strong>Consolidation</strong></p><ul><li>Consolidate data by position</li><li>Consolidate data by category</li><li>Use a formula to consolidate data</li></ul><p><strong>Outline (group) data in a worksheet</strong></p><ul><li>Create an outline of rows</li><li>Create an outline of columns</li><li>Copy outlined data</li><li>Hide or remove an outline</li></ul><p><strong>Connect external data to your workbook</strong></p><ul><li>Using the Power Query Editor to import data</li><li>From Text and CSV, From Access, From Web, From another Workbook</li><li>Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more.</li><li>Deleting Applied Steps</li><li>Refreshing your data</li></ul><p><strong>Working with Form Controls; Buttons, Option Buttons and Scroll Bars</strong></p><p><strong>Introduction to Macros</strong></p><ul><li>Change Macro Security settings</li><li>How to Record a macro</li><li>Some Macro Examples</li><li>Delete a macro</li><li>Edit the macro to view the VBA code</li><li>Copy part of a macro to create another macro</li><li>Assign a macro to a button</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates should have attended the Excel Intermediate course.</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Excel know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

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

                        </div>

Microsoft Office Training

Microsoft Excel Advanced - In-company

General Admission

Edinburgh

<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;"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Join us for this lovely introduction to needle felting with local artist and maker, Susan Mitchell.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This two and a half hour workshop will introduce you to the basic fundamentals of needle felting. Along with a special needle, a little bit of wool roving and a vintage teacup, magical things can happen!&nbsp;You will have the option to choose between creating a needle felted pincushion in a vintage teacup or a botanical felted piece in an embroidery hoop.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">So come along, learn a new skill and sip a cup of Shibui tea while making your own sweet little pin cushion in a teacup, or a botanical felted piece in an embroidery hoop.</p><p id="isPasted" 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;">Festive option</strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For her December workshop, Susan will be showing you how to create felted, festive decorations.</p><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;"><p id="isPasted" 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;">More information&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Arienas Collective workshops, courses and events are run from a supportive and welcoming home-based environment within a Georgian mews home in Edinburgh&rsquo;s City Centre New Town. We invite you to join us, leave any day-to-day worries behind, and immerse yourself in being creative.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Spaces on our workshops and courses are limited so that our creative team of artists and makers can offer you the hands-on help and support you need to make the most of your time with us.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">All the equipment and materials you will need are included in the price, unless stated otherwise, plus light refreshments (a selection of Shibui teas, coffee, hot chocolate, and sweet or savoury snacks).&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">On full day workshops you are welcome to bring your own lunch to eat inside or out; or there are a wide range of independent sit-in or takeaway delis, caf&eacute;s, and restaurants, plus supermarkets, within a 5-10 minute walk.</p><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;">PLEASE NOTE:&nbsp;</em></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Our workshop space is on the first-floor of a Georgian mews building and unfortunately we do not have lift access.&nbsp;</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">The workshop space is in our home which is&nbsp;</em><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">not</em></strong><em fr-original-style="" style="box-sizing: border-box;">&nbsp;nut free. Please let us know of any skin or food allergies before booking.&nbsp;</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">We require a minimum number of bookings to ensure we can pay our creatives a fair fee, and for this reason bookings are non-refundable. Should we have to cancel, we will offer you the option to swap to an alternative date or workshop, or to request a refund.</em></li></ul><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;">Private workshop bookings</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Most of our workshops are also available to book for small private get-togethers; themed wedding and birthday celebrations; corporate team building and well-being purposes; and as in-store retail events. For larger groups, many of our workshops can be brought to a location of your choice. <a href="mailto:lynn@thearienascollective.com" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Email Lynn</a> for more information.</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;">Age restrictions</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our workshops are planned with adults in mind. Many are suitable for teenagers, but some may require under 16s to be accompanied for insurance purposes. Please check with us before booking.</p>




Join us for this lovely introduction to needle felting with local artist and maker, Susan Mitchell.
This two and a half hour workshop will introduce you to the basic fundamentals of needle felting. Along with a special needle, a little bit of wool roving and a vintage teacup, magical things can happen! You will have the option to choose between creating a needle felted pincushion in a vintage teacup or a botanical felted piece in an embroidery hoop.
So come along, learn a new skill and sip a cup of Shibui tea while making your own sweet little pin cushion in a teacup, or a botanical felted piece in an embroidery hoop.
Festive option
For her December workshop, Susan will be showing you how to create felted, festive decorations.



More information 
The Arienas Collective workshops, courses and events are run from a supportive and welcoming home-based environment within a Georgian mews home in Edinburgh’s City Centre New Town. We invite you to join us, leave any day-to-day worries behind, and immerse yourself in being creative.
Spaces on our workshops and courses are limited so that our creative team of artists and makers can offer you the hands-on help and support you need to make the most of your time with us. 
All the equipment and materials you will need are included in the price, unless stated otherwise, plus light refreshments (a selection of Shibui teas, coffee, hot chocolate, and sweet or savoury snacks). 
On full day workshops you are welcome to bring your own lunch to eat inside or out; or there are a wide range of independent sit-in or takeaway delis, cafés, and restaurants, plus supermarkets, within a 5-10 minute walk.
PLEASE NOTE: 
Our workshop space is on the first-floor of a Georgian mews building and unfortunately we do not have lift access.
The workshop space is in our home which is not nut free. Please let us know of any skin or food allergies before booking.
We require a minimum number of bookings to ensure we can pay our creatives a fair fee, and for this reason bookings are non-refundable. Should we have to cancel, we will offer you the option to swap to an alternative date or workshop, or to request a refund.
Private workshop bookings
Most of our workshops are also available to book for small private get-togethers; themed wedding and birthday celebrations; corporate team building and well-being purposes; and as in-store retail events. For larger groups, many of our workshops can be brought to a location of your choice. Email Lynn for more information.
Age restrictions
Our workshops are planned with adults in mind. Many are suitable for teenagers, but some may require under 16s to be accompanied for insurance purposes. Please check with us before booking.

The Arienas Collective

Beginners Needle Felting Class with local artist Susan Mitchell hosted by The Arienas Collective in Edinburgh City Centre

Needle felting with Susan Mitchell

<h2>Project Contract Management Skills: In-House Training</h2>
 <p>Contracts are a critical part of most large or strategic projects/programs. As such, it is imperative that Project and Program Managers be well versed on basic implications of a contract as well as best practices in contract management. While not as critical a need, anyone involved in projects that involve external relationships should have a healthy appreciation for the power of good contract management.</p>
 <p>The overall goal of the course is to provide knowledge to manage complex contracts in a global environment.</p><h3>What You Will Learn</h3>
 <p>After this program, you will be able to:</p>
 <ul>
 <li>Explain overall project procurement process from a buyer and seller perspective</li>
 <li>Recognize the importance of key contractual terms and how they affect projects</li>
 <li>Evaluate and contribute to the pre-contract documents and processes</li>
 <li>Identify and mitigate common pitfalls throughout the procurement process</li>
 <li>Utilize techniques to administer contracts</li>
 </ul><section>
                    <h3>Getting Started</h3> <ul> <li>Introductions</li> <li>Course structure</li> <li>Course goals and objectives</li> </ul> <h3>Foundation Concepts</h3> <ul> <li>The Importance of Contract Management</li> <li>Terms and Definitions</li> <li>Contract Management Process</li> <li>Legal Systems</li> <li>Codes of Conduct</li> </ul> <h3>Planning</h3> <ul> <li>Business Analysis</li> <li>Procurement Management Plan</li> <li>Procurement Statement of Work (SOW)</li> <li>Common Pitfalls</li> </ul> <h3>Solicit Contract</h3> <ul> <li>Market Analysis</li> <li>Bid documents</li> <li>Sellers' Proposals</li> <li>Pitfalls</li> </ul> <h3>Execute Contract</h3> <ul> <li>Evaluate and Award Contract</li> <li>Negotiate Contract</li> <li>Execute Contract</li> <li>Common Pitfalls</li> </ul> <h3>Deliver the Contract</h3> <ul> <li>Preparing to Deliver</li> <li>Project Plan</li> <li>Risk Management</li> <li>Common Pitfalls</li> </ul> <h3>Administer Contract</h3> <ul> <li>Enabling Contract Management</li> <li>Contract Performance Monitoring and Control</li> <li>Change Management</li> <li>Financial Management / Payment</li> <li>Dispute Management &amp; Resolution</li> <li>Contract Completion and Closure</li> </ul>


                </section>

IIL Europe Ltd

Project Contract Management Skills: In-House Training

<h2>Program Management Skills: In-House Training</h2>
 <p>Program managers coordinate and give oversight to the efforts of marketing groups, project teams, product delivery, maintenance and support, operations and staff from various functional groups, including suppliers, business partners, and other external bodies. The goal is to ensure that proposed business transformation, through the delivery of complex products and processes, is implemented to realize the organization's strategic benefits and objectives, for which the program was selected.</p>
 <p>The goals of this course are twofold: To provide participants with key program management principles and techniques, recognized as best practices, to enable more effective program management; and to leverage core elements of the program management life cycle, processes, tools and techniques, to enable program management effectiveness.</p>
 <p>The participant will learn and apply the principles of program management through discussions, activities, and case study exercises.</p><h3>What You Will Learn</h3>
 <p>At the end of this workshop, you will be able to:</p>
 <ul>
 <li>Maximize the transformational impact of a program according to the business needs</li>
 <li>Explain management principles and techniques and apply them within a program context</li>
 <li>Implement program governance and organization that will produce expected benefits</li>
 <li>Plan for and manage benefit realization, risks, issues, and quality</li>
 <li>Manage component projects' interdependencies that are linked to both program and strategic objectives</li>
 <li>Engage program stakeholders effectively.</li>
 <li>Improve communication and action planning effectiveness for programs in organizations</li>
 </ul><section>
                    <h3>Getting Started</h3> <ul> <li>Introductions</li> <li>Course structure</li> <li>Course goals and objectives</li> </ul> <h3>Foundation Concepts</h3> <ul> <li>Fundamental definitions and concepts</li> <li>Program challenges and benefits</li> <li>Program best practices and success criterion</li> <li>Stakeholder management</li> <li>Governance: program management office and program boards</li> <li>Standard for Program Management overview</li> </ul> <h3>Vision, Leadership, and the Business Case</h3> <ul> <li>What is vision, why, and how?</li> <li>Leadership vs. Management</li> <li>Program business case</li> </ul> <h3>Program Organization and Governance</h3> <ul> <li>Program organization</li> <li>Program governance</li> <li>Program board roles and responsibilities</li> </ul> <h3>Benefits Management</h3> <ul> <li>Benefits explored</li> <li>Benefits management</li> <li>Benefits realization</li> </ul> <h3>Program Management Planning</h3> <ul> <li>Program management plan</li> <li>Program blueprint and roadmap</li> <li>Program component dossier</li> <li>Program tranches</li> <li>Program estimating</li> <li>Program scheduling</li> </ul> <h3>Program Monitoring and Controlling</h3> <ul> <li>Program Control - An Overview</li> <li>Program Monitoring and Controlling</li> <li>Monitoring and Controlling Transition</li> </ul> <h3>Program Risk and Issue Management</h3> <ul> <li>Risk and issue management overview</li> <li>Program risk management</li> <li>Program issue management</li> </ul> <h3>Program Quality Management</h3> <ul> <li>Program quality management overview</li> <li>Program quality management principles</li> </ul> <h3>Program Stakeholder Management</h3> <ul> <li>Stakeholder engagement overview</li> <li>Stakeholder engagement planning</li> <li>EI, trust, communication and stakeholder engagement</li> </ul> <h3>Program Closure and Benefits Sustainment</h3> <ul> <li>Program closure overview</li> <li>Closing the program</li> <li>Program benefits sustainment</li> </ul> <h3>Summary</h3> <ul> <li>What did we learn, and how can we implement this in our work environments?</li> </ul>


                </section>

Program Management Skills: In-House Training

<h2>Microsoft Project Orange Belt® 2016: In-House Training</h2>
 <p>This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2016, allowing you to estimate, coordinate, budget, staff, and control projects and support other users.</p>
 <p>This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2016, allowing you to estimate, coordinate, budget, staff, and control projects and support other users. This workshop provides the eBook Dynamic Scheduling with Microsoft® Project 2013, and is kept up to date with the framework of knowledge outlined by the Project Management Institute's PMBOK® Guide and the Practice Standard for Scheduling.</p><h3>What you Will Learn</h3> 
 <p>You'll learn how to:</p> 
 <ul> 
 <li>Understand what's new in Project 2016</li> 
 <li>Explain where Project 2016 fits in the Microsoft® EPM solution</li> 
 <li>Initialize Project 2016 to start project planning</li> 
 <li>Create a well-formed project schedule</li> 
 <li>Understand task types and the schedule formula</li> 
 <li>Assign resources and costs to tasks</li> 
 <li>Analyze resource utilization and optimize the schedule</li> 
 <li>Set a baseline and track progress</li> 
 <li>Create and manage project reports</li> 
 <li>Customize views and fields</li> 
 <li>Apply Earned Value Management</li> 
 <li>Understand the basics of managing multiple projects</li> 
 </ul><section>
                    <h3>Getting Started</h3> <ul>  <li>Introductions</li>  <li>Course structure</li>  <li>Course goals and objectives</li>  </ul>  <h3>Concepts of Project Management</h3> <h3>Getting Started with Project 2016</h3> <ul>  <li>Project 2016: What's New and General Overview</li>  <li>Setting Up a New Project Schedule (templates, options, save, etc.)</li>  <li>Setting the Project Calendar</li>  </ul>  <h3>Entering Tasks</h3> <ul>  <li>The planning processes</li>  <li>Importing tasks (Word, Excel, SharePoint)</li>  <li>Synchronizing with SharePoint Tasks List</li>  <li>Creating and managing the WBS (include tasks, manually scheduled tasks, summary tasks, milestones, and custom WBS coding)</li>  </ul>  <h3>Entering Estimates</h3> <ul>  <li>Tendencies in estimating</li>  <li>The rolling wave approach</li>  <li>Entering duration and work estimates</li>  <li>Types of tasks</li>  </ul>  <h3>Entering Dependencies</h3> <ul>  <li>The principle of dynamic scheduling</li>  <li>Choosing the right Type of dependency</li>  <li>Entering dependencies in Project 2016</li>  <li>Different applications of dependencies</li>  </ul>  <h3>Entering Deadlines, Constraints, and Task Calendars</h3> <ul>  <li>Use of deadlines and constraints</li>  <li>Entering deadlines and constraints in Project 2016</li>  </ul>  <h3>Entering Resources and Costs</h3> <ul>  <li>Types of resources</li>  <li>Entering resources in Project 2016</li>  <li>Calendars and resources</li>  <li>Entering costs in Project 2016</li>  </ul>  <h3>Entering Assignments</h3> <ul>  <li>Assignments in a schedule</li>  <li>Assignments and task types</li>  <li>Entering assignments in Project 2016</li>  <li>Assignments, budgets, and costs</li>  </ul>  <h3>Optimizing the Schedule</h3> <ul>  <li>The critical path method (CPM) and the resource critical path (RCP)</li>  <li>Resource leveling</li>  <li>Optimizing time, cost, and resources in Project 2016</li>  </ul>  <h3>Updating the Schedule</h3> <ul>  <li>The baseline</li>  <li>Updating strategies and situations</li>  <li>Prepare the status and forecast report in Project 2016</li>  </ul>  <h3>Reporting</h3> <ul>  <li>Using reports</li>  <li>Using Visual Reports</li>  <li>Formatting and printing in Project 2016</li>  <li>Customizing fields in Project 2016</li>  </ul>  <h3>Earned Value Management (EVM)</h3> <ul>  <li>Overview of EVM</li>  <li>Applying EVM with Project 2016</li>  </ul>  <h3>Evaluating the Project</h3> <ul>  <li>Evaluating the project performance</li>  <li>Project benefits and results</li>  <li>Templates for future projects</li>  </ul>  <h3>Summary and Next steps</h3> <ul>  <li>Tools and checklist</li>  <li>Best practices checklist</li>  <li>Certification options</li>  </ul>


                </section>

Microsoft Project Orange Belt 2016: In-House Training

<h2>Microsoft Project Orange Belt® 2013: In-House Training</h2>
 <p>This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2013, allowing you to estimate, coordinate, budget, staff, and control projects and support other users.</p>
 <p>This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2013, allowing you to estimate, coordinate, budget, staff, and control projects and support other users. This workshop provides the eBook Dynamic Scheduling with Microsoft® Project 2013, and is kept up to date with the framework of knowledge outlined by the Project Management Institute's PMBOK® Guide and the Practice Standard for Scheduling.</p><h3>What you Will Learn</h3> 
 <p>You'll learn how to:</p> 
 <ul> 
 <li>Understand what's new in Project 2013</li> 
 <li>Explain where Project 2013 fits in the Microsoft® EPM solution</li> 
 <li>Initialize Project 2013 to start project planning</li> 
 <li>Create a well-formed project schedule</li> 
 <li>Understand task types and the schedule formula</li> 
 <li>Assign resources and costs to tasks</li> 
 <li>Analyze resource utilization and optimize the schedule</li> 
 <li>Set a baseline and track progress</li> 
 <li>Create and manage project reports</li> 
 <li>Customize views and fields</li> 
 <li>Apply Earned Value Management</li> 
 <li>Understand the basics of managing multiple projects</li> 
 </ul><section>
                    <h3>Getting Started</h3> <ul>  <li>Introductions</li>  <li>Course structure</li>  <li>Course goals and objectives</li>  </ul>  <h3>Enterprise Project Management Concepts and Framework</h3> <h3>Getting Started with Project 2013</h3> <ul>  <li>Project 2013: What's New and General Overview</li>  <li>Setting Up a New Project Schedule (templates, options, save, etc.)</li>  <li>Setting the Project Calendar</li>  </ul>  <h3>Entering Tasks</h3> <ul>  <li>The Planning Processes</li>  <li>Importing Tasks (Word, Excel, SharePoint)</li>  <li>Synchronizing with SharePoint Tasks List</li>  <li>Creating and managing the WBS (include tasks, manually scheduled tasks, summary tasks and milestones, as well as custom WBS coding)</li>  </ul>  <h3>Entering Estimates</h3> <ul>  <li>Tendencies in Estimating</li>  <li>The Rolling Wave Approach</li>  <li>Entering Duration and Work Estimates</li>  <li>Types of Tasks</li>  </ul>  <h3>Entering Dependencies</h3> <ul>  <li>The Principle of Dynamic Scheduling</li>  <li>Choosing the Right Type of Dependency</li>  <li>Entering Dependencies in Project 2013</li>  <li>Different Applications of Dependencies</li>  </ul>  <h3>Entering Deadlines, Constraints, and Task Calendars</h3> <ul>  <li>Use of Deadlines and Constraints</li>  <li>Entering Deadlines and Constraints in Project 2013</li>  </ul>  <h3>Entering Resources and Costs</h3> <ul>  <li>Types of Resources</li>  <li>Entering Resources in Project 2013</li>  <li>Calendars and Resources</li>  <li>Entering Costs in Project 2013</li>  </ul>  <h3>Entering Assignments</h3> <ul>  <li>Assignments in a Schedule</li>  <li>Assignments and Task Types</li>  <li>Entering Assignments in Project 2013</li>  <li>Assignments, Budgets, and Costs</li>  </ul>  <h3>Optimizing the Schedule</h3> <ul>  <li>The Critical Path Method and the Resource Critical Path</li>  <li>Resource Leveling</li>  <li>Optimizing Time, Cost, and Resources in Project 2013</li>  </ul>  <h3>Updating the Schedule</h3> <ul>  <li>The Baseline</li>  <li>Updating Strategies and Situations</li>  <li>Prepare the Status and Forecast Report in Project 2013</li>  </ul>  <h3>Reporting</h3> <ul>  <li>Using Reports</li>  <li>Using Visual Reports</li>  <li>Formatting and Printing in Project 2013</li>  <li>Customizing Fields in Project 2013</li>  </ul>  <h3>Earned Value Management (EVM)</h3> <ul>  <li>Overview of EVM</li>  <li>Applying EVM with Project 2013</li>  </ul>  <h3>Evaluating the Project</h3> <ul>  <li>Evaluating the Project Performance</li>  <li>Project Benefits and Results</li>  <li>Templates for Future Projects</li>  </ul>  <h3>Summary</h3> <ul>  <li>Tools and Checklist</li>  <li>Best Practices Checklist</li>  </ul>  <h3>Consolidated Schedules</h3> <ul>  <li>Creating Consolidated Schedules</li>  <li>Using a Resource Pool</li>  <li>Links across Projects</li>  <li>Solving common problems</li>  <li>Analyzing the Critical Path across Projects</li>  </ul>


                </section>

Microsoft Project Orange Belt 2013: In-House Training

Harpenden

<p>This very practical one-day IACCM-approved programme enables participants to manage the process of commercial contracting and contract management effectively and efficiently to ensure value for money, improved service, and appropriate relationships. It covers a wide range of contract types in terms of risk and value. The programme empowers participants with the tools and techniques needed to collaborate with all key stakeholders.</p>By the end of the programme participants will be able to:<ul><li>Understand the total process of managing contracts</li><li>Exploit opportunities to extract even more added value</li><li>Develop appropriate relationships with contractors</li><li>Understand and use a range of contracting strategies and options</li><li>Measure and improve contract performance</li><li>Understand the impact of legislation on contract performance</li></ul><section>
                    <h3>1 Welcome</h3><ul><li>Introductions</li><li>Aims and objectives</li><li>Plan for the day</li></ul> <h3>2 Contract management</h3><ul><li>An overview of the contracting process, mapping the 'territory'</li></ul> <h3>3 Contract managers</h3><ul><li>Skills</li><li>Knowledge</li><li>Attributes</li><li>Responsibilities</li></ul> <h3>4 Critical success factors</h3><ul><li>Defining successful outcomes</li><li>Effective stakeholder engagement</li><li>Creating a shared vision of the outcomes</li></ul> <h3>5 Placing contracts</h3><ul><li>How to develop an effective specification and scope of work documents</li><li>How to develop a robust contracting strategy</li><li>Appropriate types of contract</li></ul> <h3>6 Customers and stakeholders</h3><ul><li>Customer and stakeholder analysis</li><li>Managing expectations and the 'shared vision' concept to ensure customer co-operation, satisfaction, and delight</li></ul> <h3>7 Working with suppliers</h3><ul><li>Creating and developing commercial relationships</li><li>Types of relationship</li><li>How to manage difficult relationships</li><li>Contractor motivational issues</li><li>How to use incentives</li></ul> <h3>8 Negotiation and related skills</h3><ul><li>Introduction to key negotiation skills</li><li>Persuading and influencing skills to work with stakeholders to improve outcomes for all</li></ul> <h3>9 Dealing with change</h3><ul><li>Claims and variations</li><li>How to challenge contractor claims and requests for variations by making use of contractual terms</li><li>Specifications to prevent false claims</li></ul> <h3>10 Performance improvement</h3><ul><li>How to measure and improve contractor performance</li><li>Developing KPI systems</li><li>Using contractual terms and conditions and basic legal principles</li></ul> <h3>11 Contract close</h3><ul><li>The importance of effective contract close processes</li></ul> <h3>12 Close</h3><ul><li>Review of key learning points</li><li>Personal action planning</li></ul> 


                </section>

The In House Training Company

Introduction To Construction

Construction Management

Construction Design & Management (CDM)

Contract Management

Commercial & Contract Management Certification Program (CCM)

Institute of Leadership & Management (ILM)

Introduction to contract management (In-House)

Loughborough

<div>
		

		<div>
			
			<p>Remote working is on the increase. However, managing a remote team is not always the same as managing a traditional, single-site office-based team. </p>
			<div><i></i> 2 Hours</div>
			<div><i></i>  £378.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><p>Remote working is on the increase. However, managing a remote team is not always the same as managing a traditional, single-site office-based team and it poses a variety of operational and logistical challenges for both managers and remote workers themselves. There are also potential problems related to trust, time management, motivation and feelings of isolation and lack of connectedness from both manager and employee sides.</p>
<p><strong>Available as private Face to Face and virtual sessions (max 12 delegates) - £1,305  Plus VAT</strong></p>
<p></p>
	
		<h3>Modules/Lessons</h3>
		<p></p><p><strong>Outcomes: </strong></p>
<ul>
<li>Establish a framework within which to lead and manage Remote Workers and Teams</li>
<li>Discuss the challenges of Remote Working and the needs of individuals</li>
<li>List the effective behaviours required for leading and managing Remote Teams</li>
<li>Describe a number of techniques to manage and communicate with Remote Team members</li>
</ul>
<p><strong>Content:</strong></p>
<ul>
<li>Collaboration in the Office</li>
<li>Understanding the need for Leadership rather than Management</li>
<li>'Remote Requires a Different Skillset'</li>
<li>Additional Considerations</li>
<li>Communicating Remotely</li>
<li>The Importance of Trust</li>
<li>Seven Competencies of an Effective (Remote) Leader</li>
</ul>
<p><strong>Modules:</strong></p>
<p><strong>Introduction to Remote Management</strong></p>
<ul>
<li>Trends in working practice</li>
<li>Collaboration in the office</li>
<li>Communication and distance</li>
</ul>
<p><strong>Remote requires a different skillset</strong></p>
<ul>
<li>You have to Lead rather than Manage</li>
<li>Communicating Remotely</li>
<li>The Importance of Trust - Blanchard's ABCD Model of Trust</li>
<li>The Seven Competencies of an Effective (Remote) Leader</li>
</ul>
<p></p>

Mpi Learning - Professional Learning And Development Provider

Remote working is on the increase. However, managing a remote team is not always the same as managing a traditional, single-site office-based team.

Managing Remote Teams

<p>Agility has become a prized business attribute. Although Agile methods were once most associated with software development, they are now applied in a host of different areas. Agile continues to find new applications because it is primarily an attitude.</p><p>This programme delivers a solid grounding in both the Agile mindset and Agile methods. It covers three methods, illustrates the benefits of each and shows how they can be integrated. It includes practical techniques as well as background knowledge.</p><p>By the end of the session, participants will be able to:</p><ul><li>Apply Agile concepts to self-manage their work</li><li>Understand the roles people take on in Agile teams</li><li>Use a variety of techniques to help deliver customer satisfaction</li><li>Focus on delivering against priorities</li><li>Employ a range of estimating techniques</li></ul><section>
                    <h3>1 Introduction</h3><ul><li>Overview of the programme</li><li>Review of participants' needs and objectives</li></ul> <h3>2 The basics of Agile</h3><ul><li>What makes Agile different</li><li>Agile Manifesto and Principles</li><li>Using feedback to deliver what is needed</li></ul> <h3>3 Agile teams</h3><ul><li>Multi-disciplinary teams</li><li>Team size and empowerment</li><li>Agile values</li></ul> <h3>4 Agile at the team level - Scrum</h3><ul><li>Scrum roles</li><li>Scrum 'events'</li><li>Scrum 'artifacts'</li></ul> <h3>5 Agile for teams juggling multiple demands - Kanban</h3><ul><li>Taking control of the work</li><li>Improving throughput</li><li>Dealing with bottlenecks</li></ul> <h3>6 Agile in projects - AgilePM</h3><ul><li>The phases of an Agile project</li><li>Managing change requests</li><li>Delivering on time</li></ul> <h3>7 Estimating</h3><ul><li>T-shirt / Pebble sizing</li><li>Yesterday's weather</li><li>Planning poker</li></ul> <h3>8 Pick 'n' mix - some useful techniques</h3><ul><li>The daily stand-up</li><li>User stories</li><li>Retrospectives</li><li>Work-in-process limits</li><li>Burndown charts</li><li>Minimum viable product</li><li>A / B testing</li></ul> <h3>9 Review and action planning</h3><ul><li>Identify actions to be implemented individually</li><li>Conclusion</li></ul> 


                </section>

Agility

Agile Business Analyst

Certified SAFe Agilist

ICP-ACC (ICAgile Certified Agile Coaching)

Agile

ACP (Agile Certified Practitioner)

Agile: an introduction (In-House)

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

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>

526 Courses in Edinburgh

Building Better Work Habits

By Inovra Group

Microsoft Excel Advanced - In-company

By Microsoft Office Training

Needle felting with Susan Mitchell

By The Arienas Collective

Project Contract Management Skills: In-House Training

By IIL Europe Ltd

Program Management Skills: In-House Training

By IIL Europe Ltd

Microsoft Project Orange Belt 2016: In-House Training

By IIL Europe Ltd

Microsoft Project Orange Belt 2013: In-House Training

By IIL Europe Ltd

Introduction to contract management (In-House)

By The In House Training Company

Managing Remote Teams

By Mpi Learning - Professional Learning And Development Provider

Agile: an introduction (In-House)

By The In House Training Company

Search By Location