Loughborough

<div>
		

		<div>
			
			<p>Resilience is the ability to take the challenges and changes of life in your stride and say yes to the opportunities that excite you.
</p>
			<div><i></i> 2 x 180mins</div>
			<div><i></i>  £445.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><h4>Today's workforce demands a lot from leaders: to be purpose-driven, authentic, inclusive, visionary yet humble; to create a space of psychological safety for their people and to show up without the armour of hierarchy. These demands can create a significant emotional load on leaders who are facing into a tide of consumer and shareholder activism, disruptive change to business practices and endless cost focus. Now is the time to understand that working on our personal resilience is not a sign of weakness, but of strength.</h4>
<h4>Join this course to engage with other leaders in learning resilience habits that make a difference now and can serve you for a lifetime.</h4>
<p> </p>
<p><strong>Available as private Face to Face and virtual sessions (max 12 delegates) - £1,745 Plus VAT</strong></p>
<p></p>
	
		<h3>Modules/Lessons</h3>
		<p></p><h3>Module 1: Your Personal Resilience Baseline, Strengths and Challenges</h3>
<ul>
<li>Self-awareness of your resilience level across seven categories &amp; baseline</li>
<li>Knowledge: The link between resilience and sustainable high performance</li>
<li>Knowledge: Inconvenient truths and empowering beliefs about resilience</li>
<li>Q&amp;A and signposts: to 30 small habits to build your resilience</li>
<li>Action planning: one behaviour you will implement, starting today.</li>
</ul>
<h3>Module 2: Turning Knowing into Doing</h3>
<ul>
<li>Self-awareness: The road to burnout is paved with good intentions</li>
<li>Skills: Aligning your actions with your core values</li>
<li>The courage, conviction and commitment to 'doing differently'</li>
<li>Q&amp;A and signposts: to a range of specific tools to build your confidence</li>
<li>Action planning: one behaviour you will implement, starting today.</li>
</ul>
<h3>Why now?</h3>
<div>
<ul>
<li>The pandemic has amplified existing resource pressure and accelerated change and uncertainty</li>
<li>The consequences of taking our health for granted, mentally, physically or emotionally are severe</li>
<li>Workplace stress has reached epidemic proportions in many regions across the globe</li>
<li>The cost of presenteeism is double the cost of absenteeism</li>
<li>Over two years of heightened pressure means many people are operating with lower personal capacity</li>
</ul>
<h3>Benefits?</h3>
<p>Increase your capacity to take on new challenges, reduce existing stress and prepare yourself for unexpected adversity.</p>
<h3>How?</h3>
<div>
<ul>
<li>Suitable for all leaders, everywhere</li>
<li>Resilience can be learned the easy way (taught) or the hard way (personal experience of adversity)</li>
<li>There are 7 categories of resilience, most people score very low on at least 2-3 categories</li>
<li>Having at least some resilience habits in every category means you have a tool for every situation</li>
<li>The resilience habits in the FREEDOM model are simple, powerful, fast, free and readily implemented</li>
<li>Tried-and-tested workshops, 3 to 4 hours tailored for Leaders and Executives</li>
<li>Stand-alone workshops or integrate into wider development programmes</li>
</ul>
</div>
</div>
<p></p>

Resilience is the ability to take the challenges and changes of life in your stride and say yes to the opportunities that excite you.

2 x 180mins £445.00 incl. VAT
Want to run this event in-house? Enquire about running this event in-house 
Interested in attending? Have a suggestion about running this event near you?
Register your interest now
Description

Today's workforce demands a lot from leaders: to be purpose-driven, authentic, inclusive, visionary yet humble; to create a space of psychological safety for their people and to show up without the armour of hierarchy. These demands can create a significant emotional load on leaders who are facing into a tide of consumer and shareholder activism, disruptive change to business practices and endless cost focus. Now is the time to understand that working on our personal resilience is not a sign of weakness, but of strength.Join this course to engage with other leaders in learning resilience habits that make a difference now and can serve you for a lifetime.
 
Available as private Face to Face and virtual sessions (max 12 delegates) - £1,745 Plus VAT

Modules/Lessons

Module 1: Your Personal Resilience Baseline, Strengths and Challenges
Self-awareness of your resilience level across seven categories & baseline
Knowledge: The link between resilience and sustainable high performance
Knowledge: Inconvenient truths and empowering beliefs about resilience
Q&A and signposts: to 30 small habits to build your resilience
Action planning: one behaviour you will implement, starting today.
Module 2: Turning Knowing into Doing
Self-awareness: The road to burnout is paved with good intentions
Skills: Aligning your actions with your core values
The courage, conviction and commitment to 'doing differently'
Q&A and signposts: to a range of specific tools to build your confidence
Action planning: one behaviour you will implement, starting today.
Why now?
The pandemic has amplified existing resource pressure and accelerated change and uncertainty
The consequences of taking our health for granted, mentally, physically or emotionally are severe
Workplace stress has reached epidemic proportions in many regions across the globe
The cost of presenteeism is double the cost of absenteeism
Over two years of heightened pressure means many people are operating with lower personal capacity
Benefits?
Increase your capacity to take on new challenges, reduce existing stress and prepare yourself for unexpected adversity.
How?
Suitable for all leaders, everywhere
Resilience can be learned the easy way (taught) or the hard way (personal experience of adversity)
There are 7 categories of resilience, most people score very low on at least 2-3 categories
Having at least some resilience habits in every category means you have a tool for every situation
The resilience habits in the FREEDOM model are simple, powerful, fast, free and readily implemented
Tried-and-tested workshops, 3 to 4 hours tailored for Leaders and Executives
Stand-alone workshops or integrate into wider development programmes


Mpi Learning - Professional Learning And Development Provider

Resilience is the ability to take the challenges and changes of life in your stride and say yes to the opportunities that excite you.

Developing Personal Resilience as a Leader

General Admission

Nottinghamshire

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);">Who Should Attend</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge and practical skills operate Forward Tipping Dumpers to transport and discharge loads. This course can be completed by both novice and experienced candidates. We also offer refresher tests.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course- 3 Days</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests- 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Course information</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Category N204 Forward Tipping Dumper</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:<br fr-original-style="" style="box-sizing: border-box;">➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator<br fr-original-style="" style="box-sizing: border-box;">➢ Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify the major components of the machine and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify key controls and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative<br fr-original-style="" style="box-sizing: border-box;">requirements<br fr-original-style="" style="box-sizing: border-box;">➢ Identify and maintain PPE appropriate for forward tipping dumper use<br fr-original-style="" style="box-sizing: border-box;">➢ Prepare the forward tipping dumper for use and operate safely and efficiently<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all necessary safety checks at the work area<br fr-original-style="" style="box-sizing: border-box;">➢ Attach and set trailers, ready for operation<br fr-original-style="" style="box-sizing: border-box;">➢ Environmental considerations<br fr-original-style="" style="box-sizing: border-box;">➢ Storage and transport of implements and attachments<br fr-original-style="" style="box-sizing: border-box;">➢ Carry out all end of shift and shut down procedures</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment will be to NPORS standards consisting of a theory test and practical test.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Certification</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS Traditional card &ndash; With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.</p>

Who Should Attend
This course is aimed at candidates that require the knowledge and practical skills operate Forward Tipping Dumpers to transport and discharge loads. This course can be completed by both novice and experienced candidates. We also offer refresher tests.
Novice course- 3 Days
Experienced worker tests- 1 day theory and practical assessment
Course information
Category N204 Forward Tipping Dumper
It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:
➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator
➢ Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
➢ Be able to locate and identify the major components of the machine and explain their functions
➢ Be able to locate and identify key controls and explain their functions
➢ Conduct all pre-operational checks in accordance with manufacturer’s and legislative
requirements
➢ Identify and maintain PPE appropriate for forward tipping dumper use
➢ Prepare the forward tipping dumper for use and operate safely and efficiently
➢ Conduct all necessary safety checks at the work area
➢ Attach and set trailers, ready for operation
➢ Environmental considerations
➢ Storage and transport of implements and attachments
➢ Carry out all end of shift and shut down procedures
Assessment
Assessment will be to NPORS standards consisting of a theory test and practical test.
Certification
NPORS Traditional card – With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.
NPORS CSCS – To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.

Dynamic Training and Assessments Ltd

Construction

CSCS (Construction Skills Certification Scheme)

NPORS

NPORS Forward Tipping Dumper (N204)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);">Who Should Attend</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge and practical skills operate Road Rollers to compact a variety of ground. This course can be completed by both novice and experienced candidates. We also offer refresher tests.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course- 3 Days</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests- 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Course information</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Category 214 Road Roller</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:<br fr-original-style="" style="box-sizing: border-box;">➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator<br fr-original-style="" style="box-sizing: border-box;">➢ Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify the major components of the machine and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify key controls and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative<br fr-original-style="" style="box-sizing: border-box;">requirements<br fr-original-style="" style="box-sizing: border-box;">➢ Identify and maintain PPE appropriate for roller use<br fr-original-style="" style="box-sizing: border-box;">➢ Prepare the roller for use and operate machinery safely and efficiently<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all necessary safety checks at the work area<br fr-original-style="" style="box-sizing: border-box;">➢ Operate machinery safely and efficiently<br fr-original-style="" style="box-sizing: border-box;">➢ Environmental considerations<br fr-original-style="" style="box-sizing: border-box;">➢ Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation<br fr-original-style="" style="box-sizing: border-box;">➢ Carry out all end of shift and shut down procedures</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment will be to NPORS standards consisting of a theory test and practical test.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Certification</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS Traditional card &ndash; With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.</p>

Who Should Attend
This course is aimed at candidates that require the knowledge and practical skills operate Road Rollers to compact a variety of ground. This course can be completed by both novice and experienced candidates. We also offer refresher tests.
Novice course- 3 Days
Experienced worker tests- 1 day theory and practical assessment
Course information
Category 214 Road Roller
It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:
➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator
➢ Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
➢ Be able to locate and identify the major components of the machine and explain their functions
➢ Be able to locate and identify key controls and explain their functions
➢ Conduct all pre-operational checks in accordance with manufacturer’s and legislative
requirements
➢ Identify and maintain PPE appropriate for roller use
➢ Prepare the roller for use and operate machinery safely and efficiently
➢ Conduct all necessary safety checks at the work area
➢ Operate machinery safely and efficiently
➢ Environmental considerations
➢ Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation
➢ Carry out all end of shift and shut down procedures
Assessment
Assessment will be to NPORS standards consisting of a theory test and practical test.
Certification
NPORS Traditional card – With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.
NPORS CSCS – To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.

NPORS Road Roller (N214)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);">Who Should Attend</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge and practical skills operate Forward Tipping Dumpers (mini) to transport and discharge loads. This course can be completed by both novice and experienced candidates. We also offer refresher tests.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course- 3 Days</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests- 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Course information</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Category N139 Forward tipping mini dumper</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:<br fr-original-style="" style="box-sizing: border-box;">➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator<br fr-original-style="" style="box-sizing: border-box;">➢ Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify the major components of the machine and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify key controls and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative<br fr-original-style="" style="box-sizing: border-box;">requirements<br fr-original-style="" style="box-sizing: border-box;">➢ Identify and maintain PPE appropriate for forward tipping mini dumper use<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all necessary safety checks at the work area<br fr-original-style="" style="box-sizing: border-box;">➢ Prepare the forward tipping mini dumper for use and operate safely and efficiently<br fr-original-style="" style="box-sizing: border-box;">➢ Attachments set correctly ready for operation<br fr-original-style="" style="box-sizing: border-box;">➢ Environmental considerations<br fr-original-style="" style="box-sizing: border-box;">➢ Storage and transport of forward tipping mini dumper / implements / attachments<br fr-original-style="" style="box-sizing: border-box;">➢ Carry out all end of shift and shut down procedures</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment will be to NPORS standards consisting of a theory test and practical test.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Certification</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS Traditional card &ndash; With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.</p>

Who Should Attend
This course is aimed at candidates that require the knowledge and practical skills operate Forward Tipping Dumpers (mini) to transport and discharge loads. This course can be completed by both novice and experienced candidates. We also offer refresher tests.
Novice course- 3 Days
Experienced worker tests- 1 day theory and practical assessment
Course information
Category N139 Forward tipping mini dumper
It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:
➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator
➢ Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
➢ Be able to locate and identify the major components of the machine and explain their functions
➢ Be able to locate and identify key controls and explain their functions
➢ Conduct all pre-operational checks in accordance with manufacturer’s and legislative
requirements
➢ Identify and maintain PPE appropriate for forward tipping mini dumper use
➢ Conduct all necessary safety checks at the work area
➢ Prepare the forward tipping mini dumper for use and operate safely and efficiently
➢ Attachments set correctly ready for operation
➢ Environmental considerations
➢ Storage and transport of forward tipping mini dumper / implements / attachments
➢ Carry out all end of shift and shut down procedures
Assessment
Assessment will be to NPORS standards consisting of a theory test and practical test.
Certification
NPORS Traditional card – With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.
NPORS CSCS – To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.

NPORS Forward Tipping Mini Dumper (N139)

<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;">Course information&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">It is envisaged that by the end of this course of training the trainee operator will be able to answer questions on and perform the following:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a plant operator.</li><li fr-original-style="" style="box-sizing: border-box;">Have a working knowledge of the manufacturer&rsquo;s handbook for the machine to be used and be familiar with other types of information sources and relevant legislation.</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify steering, driving and braking controls and explain their functions conduct all pre-operational checks in accordance with manufacturers and legislative requirements and check all emergency lowering functions.</li><li fr-original-style="" style="box-sizing: border-box;">Safely mount and dismount the machine configure the machine for travel.</li><li fr-original-style="" style="box-sizing: border-box;">Configure the machine for travel and maneuver it safely on level/rough ground and inclines in open and confined areas.</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area, including overhead and underground hazards maneuver the machine to work the area and correctly configure in readiness to carry out accessing tasks at various points up to full operating height.</li><li fr-original-style="" style="box-sizing: border-box;">Travel with platform raised (where applicable)</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation.</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down procedures.</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;">Entry requirements&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In order to be eligible to undertake NPORS testing.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Good understanding of spoken and written English.</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;">__________________________________________________________________________________</strong></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;">Assessment&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Assessment will be to NPORS standards consisting of a theory test and practical test. &nbsp;</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Certification</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;">NPORS Traditional card &ndash;&nbsp;</strong>With the traditional card there is no requirements to complete an NVQ, a five-year card is issued and after five years reassessment is required.&nbsp;</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;">NPORS CSCS &ndash;&nbsp;</strong>To ensure that the operator can receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.&nbsp;</p>

Course information 
It is envisaged that by the end of this course of training the trainee operator will be able to answer questions on and perform the following:
Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a plant operator.
Have a working knowledge of the manufacturer’s handbook for the machine to be used and be familiar with other types of information sources and relevant legislation.
Be able to locate and identify steering, driving and braking controls and explain their functions conduct all pre-operational checks in accordance with manufacturers and legislative requirements and check all emergency lowering functions.
Safely mount and dismount the machine configure the machine for travel.
Configure the machine for travel and maneuver it safely on level/rough ground and inclines in open and confined areas.
Conduct all necessary safety checks at the work area, including overhead and underground hazards maneuver the machine to work the area and correctly configure in readiness to carry out accessing tasks at various points up to full operating height.
Travel with platform raised (where applicable)
Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation.
Carry out all end of shift and shut down procedures.
Entry requirements 
In order to be eligible to undertake NPORS testing.
Good understanding of spoken and written English.
__________________________________________________________________________________
Assessment 
Assessment will be to NPORS standards consisting of a theory test and practical test. 
Certification
NPORS Traditional card – With the traditional card there is no requirements to complete an NVQ, a five-year card is issued and after five years reassessment is required. 
NPORS CSCS – To ensure that the operator can receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant. 

NPORS MEWP Boom (N108)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);">Who Should Attend</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge and practical skills operate Rear Tipping Dumpers to transport and discharge loads. This course can be completed by both novice and experienced candidates. We also offer refresher tests.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course- 4 Days</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests- 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Course information</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Category N205</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"></p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:<br fr-original-style="" style="box-sizing: border-box;">➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator<br fr-original-style="" style="box-sizing: border-box;">➢ Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify the major components of the machine and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify key controls and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative<br fr-original-style="" style="box-sizing: border-box;">requirements<br fr-original-style="" style="box-sizing: border-box;">➢ Identify and maintain PPE appropriate for rear tipping dumper use<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all necessary safety checks at the work area<br fr-original-style="" style="box-sizing: border-box;">➢ Prepare the rear tipping dumper for use &amp; operate machinery safely and efficiently<br fr-original-style="" style="box-sizing: border-box;">➢ Environmental considerations<br fr-original-style="" style="box-sizing: border-box;">➢ Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation<br fr-original-style="" style="box-sizing: border-box;">➢ Carry out all end of shift and shut down procedures</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment will be to NPORS standards consisting of a theory test and practical test.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Certification</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS Traditional card &ndash; With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.</p>

Who Should Attend
This course is aimed at candidates that require the knowledge and practical skills operate Rear Tipping Dumpers to transport and discharge loads. This course can be completed by both novice and experienced candidates. We also offer refresher tests.
Novice course- 4 Days
Experienced worker tests- 1 day theory and practical assessment
Course information
Category N205

It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:
➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator
➢ Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
➢ Be able to locate and identify the major components of the machine and explain their functions
➢ Be able to locate and identify key controls and explain their functions
➢ Conduct all pre-operational checks in accordance with manufacturer’s and legislative
requirements
➢ Identify and maintain PPE appropriate for rear tipping dumper use
➢ Conduct all necessary safety checks at the work area
➢ Prepare the rear tipping dumper for use & operate machinery safely and efficiently
➢ Environmental considerations
➢ Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation
➢ Carry out all end of shift and shut down procedures
Assessment
Assessment will be to NPORS standards consisting of a theory test and practical test.
Certification
NPORS Traditional card – With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.
NPORS CSCS – To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.

NPORS Rear Tipping Dumper (N205)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);">Who Should Attend</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge and practical skills operate skid steer loads for various tasks. This course will give in depth knowledge around regulations and safe working practices and it will enable the candidate to carry out all works safely and efficiently. This course can be completed by both novice and experienced candidates. We also offer refresher tests.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course- 3 Days</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests- 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Course information</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Category N212 Skid-steer Loader</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:<br fr-original-style="" style="box-sizing: border-box;">➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator<br fr-original-style="" style="box-sizing: border-box;">➢ Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify the major components of the machine and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify key controls and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative<br fr-original-style="" style="box-sizing: border-box;">requirements<br fr-original-style="" style="box-sizing: border-box;">➢ Identify and maintain PPE appropriate for skid steer loader use<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all necessary safety checks at the work area<br fr-original-style="" style="box-sizing: border-box;">➢ Prepare the skid steer loader for use, operate machinery safely and efficiently<br fr-original-style="" style="box-sizing: border-box;">➢ Environmental considerations<br fr-original-style="" style="box-sizing: border-box;">➢ Storage and transport of implements and attachments<br fr-original-style="" style="box-sizing: border-box;">➢ Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation<br fr-original-style="" style="box-sizing: border-box;">➢ Carry out all end of shift and shut down procedures</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment will be to NPORS standards consisting of a theory test and practical test.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Certification</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS Traditional card &ndash; With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.</p>

Who Should Attend
This course is aimed at candidates that require the knowledge and practical skills operate skid steer loads for various tasks. This course will give in depth knowledge around regulations and safe working practices and it will enable the candidate to carry out all works safely and efficiently. This course can be completed by both novice and experienced candidates. We also offer refresher tests.
Novice course- 3 Days
Experienced worker tests- 1 day theory and practical assessment
Course information
Category N212 Skid-steer Loader
It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:
➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator
➢ Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
➢ Be able to locate and identify the major components of the machine and explain their functions
➢ Be able to locate and identify key controls and explain their functions
➢ Conduct all pre-operational checks in accordance with manufacturer’s and legislative
requirements
➢ Identify and maintain PPE appropriate for skid steer loader use
➢ Conduct all necessary safety checks at the work area
➢ Prepare the skid steer loader for use, operate machinery safely and efficiently
➢ Environmental considerations
➢ Storage and transport of implements and attachments
➢ Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation
➢ Carry out all end of shift and shut down procedures
Assessment
Assessment will be to NPORS standards consisting of a theory test and practical test.
Certification
NPORS Traditional card – With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.
NPORS CSCS – To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.

NPORS Skidsteer Loader (N212)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);">Who Should Attend</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge and practical skills operate micro 360 excavator to excavate and load materials. This course can be completed by both novice and experienced candidates. We also offer refresher tests.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course- 10 Days</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests- 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Course information</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Category Excavator Micro (Up to 1 Tonne)</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">It is envisaged that by the end of this course of training the trainee operator will be able to answer questions on and perform the following:<br fr-original-style="" style="box-sizing: border-box;">➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a plant operator<br fr-original-style="" style="box-sizing: border-box;">➢ Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify the major components of the machine and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify steering, driving and braking controls and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Identify and maintain PPE appropriate for micro excavator use<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative requirements<br fr-original-style="" style="box-sizing: border-box;">➢ Safely mount and dismount the machine<br fr-original-style="" style="box-sizing: border-box;">➢ Start and stop the engine and safely move the machine off and stop it safely<br fr-original-style="" style="box-sizing: border-box;">➢ Configure the machine for travel and manoeuvre it safely across varying terrain in open and confined areas<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all necessary safety checks at the work area<br fr-original-style="" style="box-sizing: border-box;">➢ Manoeuvre the machine to the work area and correctly configure in readiness to carry out<br fr-original-style="" style="box-sizing: border-box;">excavating tasks<br fr-original-style="" style="box-sizing: border-box;">➢ Carry out excavating tasks<br fr-original-style="" style="box-sizing: border-box;">➢ Load material onto transporting vehicles or into containers<br fr-original-style="" style="box-sizing: border-box;">➢ Reinstate excavation, grade and level ground<br fr-original-style="" style="box-sizing: border-box;">➢ Fit and remove attachments<br fr-original-style="" style="box-sizing: border-box;">➢ Carry out all end of shift and shut down procedures</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment will be to NPORS standards consisting of a theory test and practical test.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Certification</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS Traditional card &ndash; With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.</p>

Who Should Attend
This course is aimed at candidates that require the knowledge and practical skills operate micro 360 excavator to excavate and load materials. This course can be completed by both novice and experienced candidates. We also offer refresher tests.
Novice course- 10 Days
Experienced worker tests- 1 day theory and practical assessment
Course information
Category Excavator Micro (Up to 1 Tonne)
It is envisaged that by the end of this course of training the trainee operator will be able to answer questions on and perform the following:
➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a plant operator
➢ Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
➢ Be able to locate and identify the major components of the machine and explain their functions
➢ Be able to locate and identify steering, driving and braking controls and explain their functions
➢ Identify and maintain PPE appropriate for micro excavator use
➢ Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
➢ Safely mount and dismount the machine
➢ Start and stop the engine and safely move the machine off and stop it safely
➢ Configure the machine for travel and manoeuvre it safely across varying terrain in open and confined areas
➢ Conduct all necessary safety checks at the work area
➢ Manoeuvre the machine to the work area and correctly configure in readiness to carry out
excavating tasks
➢ Carry out excavating tasks
➢ Load material onto transporting vehicles or into containers
➢ Reinstate excavation, grade and level ground
➢ Fit and remove attachments
➢ Carry out all end of shift and shut down procedures
Assessment
Assessment will be to NPORS standards consisting of a theory test and practical test.
Certification
NPORS Traditional card – With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.
NPORS CSCS – To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.

NPORS Excavator Micro (up to 1 Tonne) (N016)

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">COURSE INFORMATION</strong></p><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course teaches you how to operate a mini / compact crane safely and productively.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We will conduct a learner analysis to identify the duration of training required for those with limited or no experience, whereas experienced operators can attend a one day Experienced Worker Assessment (Test Only).</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To provide knowledge and understanding in the following areas:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator</li><li fr-original-style="" style="box-sizing: border-box;">Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify key controls and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Set up exclusion zone</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for mini compact crane use</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational and running checks in accordance with manufacturer&rsquo;s and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Prepare the mini compact crane for use and operate machine safely and efficiently</li><li fr-original-style="" style="box-sizing: border-box;">Environmental considerations</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of work and shut down procedures</li></ul><h2 fr-original-style="" style="box-sizing: border-box;">Entry Requirements</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Please note, that in all cases, operators are required to supply proof to support&nbsp;their application. They have to have passed the CITB health, safety &amp; environmental touch screen test within two years prior to their application.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Good understanding of spoken and written English.</p></div>

COURSE INFORMATION
This course teaches you how to operate a mini / compact crane safely and productively.
We will conduct a learner analysis to identify the duration of training required for those with limited or no experience, whereas experienced operators can attend a one day Experienced Worker Assessment (Test Only).
To provide knowledge and understanding in the following areas:
Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator
Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
Be able to locate and identify the major components of the machine and explain their functions
Be able to locate and identify key controls and explain their functions
Set up exclusion zone
Identify and maintain PPE appropriate for mini compact crane use
Conduct all pre-operational and running checks in accordance with manufacturer’s and legislative requirements
Prepare the mini compact crane for use and operate machine safely and efficiently
Environmental considerations
Carry out all end of work and shut down procedures
Entry Requirements
Please note, that in all cases, operators are required to supply proof to support their application. They have to have passed the CITB health, safety & environmental touch screen test within two years prior to their application.
Good understanding of spoken and written English.

NPORS Compact Crane (N140)

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">COURSE INFORMATION</strong></p><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The NPORS&nbsp;Shunter Vehicle&nbsp;course is for drivers who do not hold an HGV licence but are required to &#39;shunt&#39; vehicles etc. around on company premises. Shunter training allows these drivers to drive maximum weight articulated and rigged vehicles on-site only around the business premises.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We will conduct a learner analysis to identify the duration of training required for those with limited or no experience, whereas experienced operators can attend a one day Experienced Worker Assessment (Test Only).</p><h2 fr-original-style="" style="box-sizing: border-box;">NPORS Shunter Vehicle (N243) Course Content</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To provide knowledge and understanding in the following areas:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator</li><li fr-original-style="" style="box-sizing: border-box;">Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for Shunter Vehicle use</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area</li><li fr-original-style="" style="box-sizing: border-box;">Prepare the Shunter Vehicle for use and operate machinery safely and efficiently</li><li fr-original-style="" style="box-sizing: border-box;">Attach and set trailers ready for operation</li><li fr-original-style="" style="box-sizing: border-box;">Environmental considerations</li><li fr-original-style="" style="box-sizing: border-box;">Transport and uncouple Shunter Vehicle attachments</li></ul><h2 fr-original-style="" style="box-sizing: border-box;">Entry Requirements</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Please note, that in all cases, operators are required to supply proof to support&nbsp;their application. They have to have passed the CITB health, safety &amp; environmental touch screen test within two years prior to their application.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Good understanding of spoken and written English.</p></div>

COURSE INFORMATION
The NPORS Shunter Vehicle course is for drivers who do not hold an HGV licence but are required to 'shunt' vehicles etc. around on company premises. Shunter training allows these drivers to drive maximum weight articulated and rigged vehicles on-site only around the business premises.
We will conduct a learner analysis to identify the duration of training required for those with limited or no experience, whereas experienced operators can attend a one day Experienced Worker Assessment (Test Only).
NPORS Shunter Vehicle (N243) Course Content
To provide knowledge and understanding in the following areas:
Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator
Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
Be able to locate and identify the major components of the machine and explain their functions
Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
Identify and maintain PPE appropriate for Shunter Vehicle use
Conduct all necessary safety checks at the work area
Prepare the Shunter Vehicle for use and operate machinery safely and efficiently
Attach and set trailers ready for operation
Environmental considerations
Transport and uncouple Shunter Vehicle attachments
Entry Requirements
Please note, that in all cases, operators are required to supply proof to support their application. They have to have passed the CITB health, safety & environmental touch screen test within two years prior to their application. 
Good understanding of spoken and written English.

NPORS Shunter Vehicle (N243)

<p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" id="isPasted" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">LOOKING FOR: PICTURE BOOKS, MG, YA</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Clare Wallace joined the Darley Anderson Agency in January 2011 and is building both the Darley Anderson Children&rsquo;s Agency and the Darley Anderson Illustration Agency lists. As chief talent-spotter, Clare loves to discover memorable new characters, bold and unique voices, strong concepts and gripping storytelling. She represents picture books, middle-grade, teenage and YA. Clare is particularly looking for funny chapter books for younger readers at the moment, as well as contemporary MG, YA fantasy, romance, and rom coms, especially with underrepresented protagonists. Whatever the age range, Clare loves a big hook, a lot of heart, and a standout voice. For picture books she has the widest taste, from daft to lyrical, rhyming to prose. If your submission doesn&rsquo;t fit a description here, it doesn&rsquo;t mean Clare doesn&rsquo;t want to receive it. She often doesn&rsquo;t know what she&rsquo;s looking for until she finds it (although she is not the person for steampunk or space opera). Her list gives a good indication of her taste.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The clients Clare represents include Perdita &amp; Honor Cargill, Caroline Crowe, Tom Ellen, Martyn Ford, Stewart Foster, Olivia Hope, A M Howell, Polly Ho-Yen, Rachel Ip, Beth Reekles, J.P. Rose, Lindsay Galvin, Dave Rudden, Deirdre Sullivan and Efua Traor&eacute;.</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;">Clare would like you to send a covering letter, a one page synopsis and the first three chapters (Max 5000 words) of your manuscript. For picture books, please submit a covering letter and up to three completed texts.</strong></p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">(<em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">In addition to the paid sessions, Clare is kindly offering one free session for low income/underrepresented writers. Please email <a href="mailto:agent121@iaminprint.co.uk" style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto; font-size: var(--font-size);" fr-original-style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto;">agent121@iaminprint.co.uk</a> to apply, outlining your case for this option which is offered at the&nbsp;</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">discretion of&nbsp;</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print)</em>.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By booking you understand you need to conduct an internet connection test with<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Pr</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">int</em> prior to the event. You also agree to email your material in one document to reach <em fr-original-style="" style="box-sizing: border-box;">I Am In Print</em> by the stated submission deadline and note that <em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print</em> take no responsibility for the advice received during your agent meeting.</p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">The submission deadline is: Monday 7 October 2024</strong></p>

LOOKING FOR: PICTURE BOOKS, MG, YA
Clare Wallace joined the Darley Anderson Agency in January 2011 and is building both the Darley Anderson Children’s Agency and the Darley Anderson Illustration Agency lists. As chief talent-spotter, Clare loves to discover memorable new characters, bold and unique voices, strong concepts and gripping storytelling. She represents picture books, middle-grade, teenage and YA. Clare is particularly looking for funny chapter books for younger readers at the moment, as well as contemporary MG, YA fantasy, romance, and rom coms, especially with underrepresented protagonists. Whatever the age range, Clare loves a big hook, a lot of heart, and a standout voice. For picture books she has the widest taste, from daft to lyrical, rhyming to prose. If your submission doesn’t fit a description here, it doesn’t mean Clare doesn’t want to receive it. She often doesn’t know what she’s looking for until she finds it (although she is not the person for steampunk or space opera). Her list gives a good indication of her taste.
The clients Clare represents include Perdita & Honor Cargill, Caroline Crowe, Tom Ellen, Martyn Ford, Stewart Foster, Olivia Hope, A M Howell, Polly Ho-Yen, Rachel Ip, Beth Reekles, J.P. Rose, Lindsay Galvin, Dave Rudden, Deirdre Sullivan and Efua Traoré.
Clare would like you to send a covering letter, a one page synopsis and the first three chapters (Max 5000 words) of your manuscript. For picture books, please submit a covering letter and up to three completed texts.
Please send EITHER picture books OR another genre, not both in one submission.
(In addition to the paid sessions, Clare is kindly offering one free session for low income/underrepresented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print). 
By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting.
The submission deadline is: Monday 11 November 2024

I Am In Print

Fiction Writing

SOLD OUT! 25th November Clare Wallace #Agent121. Looking for: PICTURE BOOKS, MG, YA

<p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(var(--color_25));"><span style="color: rgb(0, 0, 0); background-color: rgb(84, 172, 210); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); background-color: rgb(84, 172, 210);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ATTENTION: all public dates from Nov 2024 onwards are Issue 7, not Issue 6 anymore.</strong></span></p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(var(--color_25));"><span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);">Attention: This course is delivered over 2 <span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);">full days.</span> If you&#39;re interested in the same course but delivered over 4 half-days <span style="color: rgb(184, 49, 47); box-sizing: border-box;" fr-original-style="color: rgb(184, 49, 47);">(3pm to 6:30pm London time, consecutive half-days excluding weekend)</span>, please click&nbsp;<a href="https://www.ask-sonia.com/training?layout=grid&cadpath=ask-sonia-limited%2Fofficial-brcgs-packaging-sites-issue-6-4-half-days" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; color: inherit; cursor: pointer; text-decoration: inherit;"><u fr-original-style="" style="box-sizing: border-box;">here</u></a>. Thank you.</span></p><p style="color: rgb(77, 77, 79); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(77, 77, 79);">This official BRCGS course has been designed to enable delegates to gain a full understanding of the requirements of the Packaging Materials Standard, including the objectives of fundamental clauses and statements of intent.</p><p style="color: rgb(77, 77, 79); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Delegates will learn how audits against the Standard operate including preparation, the audit, non-conformities, corrective actions and certificate issue.</p><p style="color: rgb(77, 77, 79); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">A good technical knowledge of the packaging industry is essential. Before attending the course, Delegates must download and read a copy of the Standard, which is available as a free download from the <a href="https://www.brcgs.com/store/global-standard-packaging-materials-issue-6/p-723/" target="_blank" style="color: rgb(234, 118, 0); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(234, 118, 0);">BRCGS Store</a>.</p><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">At the end of the course, you will:&nbsp;</h3><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Understand the background and benefits of the Standard</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Be able to outline the details of the audit and certification programme</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Determine audit scope and plan the audit</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Understand what it is to have an audit, non-conformities and corrective actions</li><li style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">Know how to report issues and use BRCGS resources</li></ul><p style="color: rgb(77, 77, 79); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(77, 77, 79);"><span style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">This course is part of the</span><a href="http://demo-brcgs.wearesigma.com/training/brcgs-professional/about-the-programme/" style="color: rgb(234, 118, 0); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(234, 118, 0);">&nbsp;BRCGS Professional recognition programme</a><span style="color: rgb(77, 77, 79); box-sizing: border-box;" fr-original-style=" color: rgb(77, 77, 79);">.</span></p>

ATTENTION: All training dates scheduled from January 2025 are for Issue 7.
This official BRCGS course has been designed to enable delegates to gain a full understanding of the requirements of the Packaging Materials Standard Issue 7, including the objectives of fundamental clauses and statements of intent.
Delegates will learn how audits against the Standard operate including preparation, the audit, non-conformities, corrective actions and certificate issue.
A good technical knowledge of the packaging industry is essential. Before attending the course, Delegates must download and read a copy of the Standard, which is available as a free download from the BRCGS Store.
At the end of the course, you will: 
Understand the background and benefits of the Standard
Be able to outline the details of the audit and certification programme
Determine audit scope and plan the audit
Understand what it is to have an audit, non-conformities and corrective actions
Know how to report issues and use BRCGS resources
This course is part of the BRCGS Professional recognition programme.

Ask Sonia Limited

Food Safety

HACCP

Official BRCGS Packaging Sites Issue 6 course.
Delivered online (Zoom) by a live BRCGS Approved Training Partner.
Exam and Certificate fee included in the price.

BRCGS Packaging Materials Issue 6 & Issue 7: Sites Training (2 Days)

<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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></strong></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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Real Estate Financial Modelling School (5 days)</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Real Estate Financial Modelling School is an intensive week meticulously designed to teach the best practices to create flexible and robust cash flows in Excel.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance &amp; Risk.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The school combines three of our courses:</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Analyst</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Investor</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Modelling Masterclass</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">All of the courses are interlinked to give you a full understanding of the subject using Excel.</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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will&hellip;</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Implement cash flows in excel throughout the whole week.</li><li value="2" fr-original-style="" style="box-sizing: border-box;">In the first two days you will learn how to develop rent functions and net operating income. We will show you how to value and appraise property investments and analyse the results.</li><li value="3" fr-original-style="" style="box-sizing: border-box;">On the third and fourth day you will learn how to model and analyse development projects using both residuals and cash flow methods. It will show you how to interrogate and compare alternative return metrics such as profit-equity multiples, profit and cost, net present value, worth and internal rate of return. Additionally you will cover how to model cash flow from different sector office, retail and leisure.</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Finally on the fifth day debt structures will be covered as well as joint ventures and partnership financing. You will also learn how to implement the full spectrum of the risk analysis from sensitivity to Monte Carlo.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p 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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this school?</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Property industry modellers who would like to be fully proficient in building complex financial models</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p 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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></strong></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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One</strong></strong></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;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Analyst I</em></em></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;"><em fr-original-style="" style="box-sizing: border-box;">Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.</em></em></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion and Layer Method Valuation (Intro to Excel)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield (Solver, Scenario and Goal Seek functions)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Single-Let Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analysis and use of date series</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Internal Rate of Return (IRR) and Net Present Value (NPV)</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Comparing Value, Price and Worth</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Adding borrowing and analysing geared returns</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Introducing Rent Reviews and other &lsquo;events&rsquo; into cash flows</li><li value="10" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; concept and Logic functions (IF,OR,AND)</li><li value="11" fr-original-style="" style="box-sizing: border-box;">Sensitivity analysis</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p 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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Two</strong></strong></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;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Analyst II</em></em></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;"><em fr-original-style="" style="box-sizing: border-box;">Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.</em></em></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; and Multi-let cash flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;">The &lsquo;date problem&rsquo; and assumptions in property asset cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Reducing the rent function, intermediate calculations and modelling theory</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling lease expiries, break clauses, voids, and upward only covenants</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Incorporating time-varying rental growth rates</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Analysing multi-let cash flows to see if the leases are sufficiently diversified</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Further IRR analysis (XIRR, MIRR)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p 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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Three</strong></strong></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;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Investor I</em></em></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts / premiums to indexation, rent free periods, as well as how to deal with costs during vacancy</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Modelling sector variations in real estate income streams i.e. Office versus industrial, retail &amp; leisure</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Further senior debt covenants</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advance Rent Function techniques to manage feature rich lease structures</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p 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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Four</strong></strong></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;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Investor II</em></em></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Introduction to development appraisals</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Residual models, site and profit calculations</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Development cash flows versus Investment cash flows</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Introduction to straight line versus S-curve costing</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Phased asset sales in development appraisals</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Discounting development cash flows</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Complimentary return metrics for development appraisals</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Introduction to development finance</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p 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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Five</strong></strong></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;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Modelling Masterclass</em></em></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Mezzanine debt modelling</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Joint Venture structures between developers and lender/equity partners</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Promote and profit share structure calculations</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advance project cash flows with mezzanine debts</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Key Real Estate and investment risks, risk adjustment of exit yields</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Sensitivity and Scenario Analysis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Monte Carlo Analysis</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p 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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Financial Modelling School such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



Real Estate Financial Modelling School (5 days)
The Real Estate Financial Modelling School is an intensive week meticulously designed to teach the best practices to create flexible and robust cash flows in Excel.
This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.
The school combines three of our courses:
Real Estate Analyst
Real Estate Investor
Real Estate Modelling Masterclass


All of the courses are interlinked to give you a full understanding of the subject using Excel.


On this course you will…
Implement cash flows in excel throughout the whole week.
In the first two days you will learn how to develop rent functions and net operating income. We will show you how to value and appraise property investments and analyse the results.
On the third and fourth day you will learn how to model and analyse development projects using both residuals and cash flow methods. It will show you how to interrogate and compare alternative return metrics such as profit-equity multiples, profit and cost, net present value, worth and internal rate of return. Additionally you will cover how to model cash flow from different sector office, retail and leisure.
Finally on the fifth day debt structures will be covered as well as joint ventures and partnership financing. You will also learn how to implement the full spectrum of the risk analysis from sensitivity to Monte Carlo.


Who will benefit from this school?
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Mid-level to senior Real Estate Analysts
Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail
Property industry modellers who would like to be fully proficient in building complex financial models


Course Outline
Day One
Real Estate Analyst I
Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.
Term & Reversion and Layer Method Valuation (Intro to Excel)
Equivalent Yield (Solver, Scenario and Goal Seek functions)
Single-Let Discounted Cash Flow
Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)
Analysis and use of date series
Internal Rate of Return (IRR) and Net Present Value (NPV)
Comparing Value, Price and Worth
Adding borrowing and analysing geared returns
Introducing Rent Reviews and other ‘events’ into cash flows
The ‘Rent Function’ concept and Logic functions (IF,OR,AND)
Sensitivity analysis


Day Two
Real Estate Analyst II
Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.
The ‘Rent Function’ and Multi-let cash flows
The ‘date problem’ and assumptions in property asset cash flows
Reducing the rent function, intermediate calculations and modelling theory
Modelling lease expiries, break clauses, voids, and upward only covenants
Incorporating time-varying rental growth rates
Analysing multi-let cash flows to see if the leases are sufficiently diversified
Further IRR analysis (XIRR, MIRR)


Day Three
Real Estate Investor I
Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts / premiums to indexation, rent free periods, as well as how to deal with costs during vacancy
Modelling sector variations in real estate income streams i.e. Office versus industrial, retail & leisure
Further senior debt covenants
Advance Rent Function techniques to manage feature rich lease structures


Day Four
Real Estate Investor II
Introduction to development appraisals
Residual models, site and profit calculations
Development cash flows versus Investment cash flows
Introduction to straight line versus S-curve costing
Phased asset sales in development appraisals
Discounting development cash flows
Complimentary return metrics for development appraisals
Introduction to development finance


Day Five
Real Estate Modelling Masterclass
Mezzanine debt modelling
Joint Venture structures between developers and lender/equity partners
Promote and profit share structure calculations
Advance project cash flows with mezzanine debts
Key Real Estate and investment risks, risk adjustment of exit yields
Sensitivity and Scenario Analysis
Monte Carlo Analysis


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


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

Bayfield Training

Real Estate Finance

Microsoft Excel

Professional Development

Continuous Professional Development (CPD)

This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.

Real Estate Financial Modelling School

London

<article id="cincluded">
					<div>
						<h5>SQL Course Summary.</h5>
					</div>
					<div></div>
					<p>
						
						<br />Practical SQL course, to leavy you full conversant with queries, DML and DDL statements.
						<br />Hands-on, Practical SQL course. 
						<br />PCWorkshops SQL Course Certificate.
						<br />Max 4 people per course, we keep it personalised. 
						
				  	</p>
	    		</article>

<div id="#">
							<div>
								<h5>Where is the SQL Course?</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>Online: </b>Instructor-led.</li>
									 <li><b>Classroom: </b>Request per email.</li> 
								</ul>
								</div>
							</article>
						</div>
						
					   	<div id="#">
							<div>
								<h5>SQL Course Materials</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>SQL Coding Examples </b>   </li>
									 <li><b>SQL Course Manuals and Notes: </b>In-depth reference materials </li>
									 <li><b>Exercises:</b> Practical exercises  </li> 
								</ul>
								</div>
							</article>
						</div>
						 
						
						<div id="#">
							<div>
								<h5>Payment Options</h5>
							</div>
							<article>
								<div>
								<ul>
									<li>→  £750, Follow the booking link </li>	 
									<li>Arrange for installments</li>
								</ul>
								</div>
							</article>
						</div>
						
						<div id="#">
							<div>
								<h5>Included with SQL Course:</h5>
							</div>
							<article>
								<div>
								<ul>
									<li>SQL Course Certificate on completion.
									</li><li>SQL Course Manual.
									</li><li>Practical SQL Course exercises, SQL Code Samples/ SQL Course Revision work.
									</li><li>After the course, 1 free session for questions.
									</li><li>Max group size, online and in classroom, on this SQL Course is 4.</li>
								</ul>
								</div>
							</article>
						</div>
						

			   	<div id="cdetails">
					<div>
						<h5>Course Details</h5>
					</div>
					<article>
						<div>
							<h5>SQL Intermediate Course summary</h5>
						</div>
						<div></div>
						<div>
					 	<ul>
					    	 <br /><br /><b><li>DAY 1:</li></b>
						    <li><b>Session 1: </b>Database Concepts
							 
							<br />What is a database? 
							<br />Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys, Client-Server architecture, Supported data types, table types,. The Information_Schema

							</li>	<li><b>Session 2: </b>Using the SQL client
							SQL Getting started and Logging in, Selecting a database, 
							Client commands, Entering and executing SQL statements, 
							Retrieving previous commands, Creating, editing and executing SQL files, Redirecting output into a file, 
							Command line execution of SQL Scripts

							</li><li><b>Session 3: </b>Basic SQL SELECT statement
							<br />The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions.  
							<br />Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators.
							<br />Column aliases.
							<br />Arithmetic expressions.
							<br />Null functions ('IS NULL,' 'IS NOT NULL,' , "Isnull",'Coalesce').
							<br />The ORDER BY clause.
							
							
							</li><li><b>Session 4:</b> 
							<br />LIMIT / TOP  and Distinct Queries 
							<br />SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count),
							<br />Group By, 
							<br />Rollup with Group By, 
							<br />Having.
							</li>
							<li><b>Session 5:</b> Joins
							<br />SQL Cartesian products.
							<br />SQL Joins (Inner join, Left join, Right join, Full join).
							<br />Table aliases.
							<br />Natural joins, Multi-table joins.
							<br />Union, Union All queries.
							<br />Except/Minus, Simulating join with Intersect.
							</li>
							<br /><br /><b><li>DAY 2:</li></b>
							<li><b>Session 6:</b>
							<br />SQL Subqueries, Nested Subqueries, 
							<br />Correlated and uncorrelated subqueries. 
							<br />Global and Local Temp Tables.
							</li>
							<li><b>Session 7:</b>
							SQL Built-in Functions: <br />Numeric Functions (ABS, SIGN, MOD, etc.)
							<br />and String Functions (Locate, Left, Right, Concat, etc),
							<br />DATE and TIME functions.
							</li>
							<li><b>Session 8:</b>
							SQL Views (Create, alter and drop), 
							<br />Stored Procedures (Create, alter and drop, Input and Output parameters);
							<br /> Custom Functions (Create, alter and drop).
							</li>
							<br /><br /><b><li>DAY 3:</li></b>
							<li><b>
							Session 9: </b>Managing Data
							<br />Inserting rows, Replacing rows, Updating rows, Deleting rows,
<br />							The truncate statement, 
<br />The COMMIT and ROLLBACK commands, Savepoints, Implicit commits.
							</li>
							<li><b>
							Session 10:</b>
							SQL Indexes (Create, alter and drop).
							</li>
							<li><b>
							Session 11:</b>
							<br />Creating Databases and Tables (Create, alter and drop); <br />Constraints (Add, alter and drop).
							</li>
							<li><b>
							Session 12:</b>
							<br />Import data into SQL and Export from SQL.
							<br />Exporting using SQL, Importing using SQL.
														</li> 
							
							
						</ul>
						</div>
					</article>
				</div>

		<div> 
						 

						
				     
	                  <div></div>
 		</div>
	                
				     
				   <div id="booking">
	                  <div>
	                     <h5>Book the SQL Course</h5>
	                  </div>
							 
							 
<div id="eventbrite-widget-container-12009778571"></div>




					 
							 
							 
	               </div>
				   <div id="#">
	                  <div>
	                     <h5>About us</h5>
	                  </div>



	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
										<li>
										<div id="LTF_ST_7KBtchhl8SMxqQ8TquAE3BxAGh2waJl4jxQdXEubLKJcmvn6ak"></div>
										</li>	
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>

SQL Course Intermediate 
 
This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements.  Hands-on, Practical SQL course.  
You will get the PCWorkshops SQL Course Certificate. 
Max 4 people per course, to keep it personalised. 
Where is the SQL Course?
Online: Instructor-led.
Classroom: Request per email.
SQL Course Materials
SQL Coding Examples
SQL Course Manuals and Notes: In-depth reference materials
Exercises: Practical exercises
Included with SQL Intermediate Course:
SQL Course Certificate on completion.
SQL Course Manual.
Practical SQL Course exercises, SQL Code Samples/ SQL Course Revision work.
After the course, 1 free session for questions.
Max group size, online and in classroom, on this SQL Course is 4.
SQL Intermediate Course summary
DAY 1:
Session 1: Database Concepts 
What is a database? 
Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys, Client-Server architecture, Supported data types, table types,. The Information_Schema
Session 2: Using the SQL client SQL Getting started and Logging in, Selecting a database, Client commands, Entering and executing SQL statements, Retrieving previous commands, Creating, editing and executing SQL files, Redirecting output into a file, Command line execution of SQL Scripts
Session 3: Basic SQL SELECT statement 
The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions. 
Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators. 
Column aliases. 
Arithmetic expressions. 
Null functions ('IS NULL,' 'IS NOT NULL,' , "Isnull",'Coalesce'). 
The ORDER BY clause.
Session 4: 
LIMIT / TOP and Distinct Queries 
SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count), 
Group By, 
Rollup with Group By, 
Having.
Session 5: Joins 
SQL Cartesian products. 
SQL Joins (Inner join, Left join, Right join, Full join). 
Table aliases. 
Natural joins, Multi-table joins. 
Union, Union All queries. 
Except/Minus, Simulating join with Intersect.
DAY 2:
Session 6: 
SQL Subqueries, Nested Subqueries, 
Correlated and uncorrelated subqueries. 
Global and Local Temp Tables.
Session 7: SQL Built-in Functions: 
Numeric Functions (ABS, SIGN, MOD, etc.) 
and String Functions (Locate, Left, Right, Concat, etc), 
DATE and TIME functions.
Session 8: SQL Views (Create, alter and drop), 
Stored Procedures (Create, alter and drop, Input and Output parameters); 
 Custom Functions (Create, alter and drop).
DAY 3:
Session 9: Managing Data 
Inserting rows, Replacing rows, Updating rows, Deleting rows,

 The truncate statement, 
The COMMIT and ROLLBACK commands, Savepoints, Implicit commits.
Session 10: SQL Indexes (Create, alter and drop).
Session 11: 
Creating Databases and Tables (Create, alter and drop); 
Constraints (Add, alter and drop).
Session 12: 
Import data into SQL and Export from SQL. 
Exporting using SQL, Importing using SQL.
 
About us

Our SQL Intermediate trainers are experienced award winners.
13 years in business
We keep it practical and customised

PCWorkshops

Oracle SQL

Azure SQL Database

Microsoft SQL Server

Microsoft SQL

Database Programming

Computer Skills

SQL Server

MySQL

This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements.  Hands-on, Practical SQL course.  
You will get the PCWorkshops SQL Course Certificate. 
Max 4 people per course, to keep it personalised. 

SQL Intermediate Course, 3 Days

General admission

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is intended for IT professionals who need to manage the day-to-day environment of an SCCM 2012 SP1 or newer environment. Knowledge of the workings of a standalone primary SCCM site and basic PowerShell experience is recommended.</p>Overview<p>Create additional site system roles on existing or new servers. Modify high level site settings. Create and modify Discovery Methods, Boundaries and Boundary Groups. Create Collections using any of the membership rules available. Delegate authority through Roles and Scopes. Install the Configuration Manager client, modify client settings and restrict access to site systems. Deploy software to clients. Deploy software updates to clients. Configure compliance settings targeted against collections. Modify settings that govern monitoring functions such as Alerts and Status Settings. Work with Task Sequences for Operating System Deployment. Write basic PowerShell scripts using cmdlets learned and scripting constructs to accomplish configuration tasks.</p><p>This course provides students with the knowledge and skills needed to use PowerShell for System Center Configuration Manager (SCCM) administration. In this course, students learn how to access the PowerShell cmdlets included with SCCM 2012 R2 and use them to perform configuration tasks for a primary site. Individual cmdlets will be used in working with objects such as Boundaries, Boundary Groups, Collections, Software Deployment, Patching, Compliance Settings, OSD Task Sequences, and many others. Basic scripting will also be covered so that students can learn how to put PowerShell to use when working with large sets of objects.</p>Prerequisites<p></p><li>Basic Windows and Active Directory knowledge.  </li><li>Conceptual knowledge of Configuration Manager objects and how they interact.  </li><li>Basic experience performing configuration tasks in ECM using the graphical console.  </li><li>Experience working from a command prompt.  </li><li>Basic knowledge of the fundamentals of Windows PowerShell.<p></p></li></div><div id="course-pills-2"><h3>1 - REVIEW OF SYSTEM CENTER CONFIGURATION MANAGER CONCEPTS</h3> <ul> <li>Architecture of an System Center 2012 Configuration Manager Installation</li> <li>Managing Assets</li> <li>Content Delivery and Management</li> <li>Security, Monitoring, and Remote Management</li> </ul> <h3>2 - MANAGING RESOURCES</h3> <ul> <li>Implementing Discovery</li> <li>Organizing Resources with Collections</li> <li>Working with Boundaries</li> </ul> <h3>3 - WORKING WITH CLIENTS</h3> <ul> <li>Installing the Configuration Manager Client</li> <li>Managing Client Settings</li> <li>Managing Client Operations</li> <li>Monitoring Client Status</li> </ul> <h3>4 - DISTRIBUTING SOFTWARE</h3> <ul> <li>Configure the Software Distribution Components</li> <li>Working with Distribution Points</li> <li>Creating Content for Distribution</li> <li>Deploying Software Applications</li> </ul> <h3>5 - UPDATING SYSTEMS WITH WSUS AND SCCM</h3> <ul> <li>Integrating Configuration Manager and WSUS</li> <li>Managing Updates through Software Update Groups</li> <li>Creating and Deploying Update Packages</li> <li>Working with Automatic Deployment Rules</li> </ul> <h3>6 - HOW POWERSHELL CAN MANAGE COMPLIANCE SETTINGS</h3> <ul> <li>Creating Compliance Settings Objects</li> <li>Deploying and Monitor the Baseline</li> </ul> <h3>7 - CONFIGURING OPERATING SYSTEM DEPLOYMENT OBJECTS</h3> <ul> <li>Preparing the OSD Environment</li> <li>Working with Task Sequences</li> </ul> <h3>8 - WORKING AT THE SITE LEVEL</h3> <ul> <li>Modify the Site</li> <li>Adding Site System Roles</li> <li>Adding a Secondary Site</li> </ul> <h3>9 - SECURITY AND MONITORING</h3> <ul> <li>Configuring Role Based Administration</li> <li>Implementing Endpoint Protection</li> <li>Configuring Monitoring Options</li> </ul> <h3>10 - USING POWERSHELL SCRIPTING TO AUTOMATE SCCM TASKS</h3> <ul> <li>Review of Scripting Constructs</li> <li>Introduction to the Configuration Manager WMI Classes</li> </ul></div>

Duration
3 Days
18 CPD hours
This course is intended for
This course is intended for IT professionals who need to manage the day-to-day environment of an SCCM 2012 SP1 or newer environment. Knowledge of the workings of a standalone primary SCCM site and basic PowerShell experience is recommended.
Overview
Create additional site system roles on existing or new servers. Modify high level site settings. Create and modify Discovery Methods, Boundaries and Boundary Groups. Create Collections using any of the membership rules available. Delegate authority through Roles and Scopes. Install the Configuration Manager client, modify client settings and restrict access to site systems. Deploy software to clients. Deploy software updates to clients. Configure compliance settings targeted against collections. Modify settings that govern monitoring functions such as Alerts and Status Settings. Work with Task Sequences for Operating System Deployment. Write basic PowerShell scripts using cmdlets learned and scripting constructs to accomplish configuration tasks.
This course provides students with the knowledge and skills needed to use PowerShell for System Center Configuration Manager (SCCM) administration. In this course, students learn how to access the PowerShell cmdlets included with SCCM 2012 R2 and use them to perform configuration tasks for a primary site. Individual cmdlets will be used in working with objects such as Boundaries, Boundary Groups, Collections, Software Deployment, Patching, Compliance Settings, OSD Task Sequences, and many others. Basic scripting will also be covered so that students can learn how to put PowerShell to use when working with large sets of objects.
Prerequisites

Basic Windows and Active Directory knowledge.
Conceptual knowledge of Configuration Manager objects and how they interact.
Basic experience performing configuration tasks in ECM using the graphical console.
Experience working from a command prompt.
Basic knowledge of the fundamentals of Windows PowerShell.
1 - REVIEW OF SYSTEM CENTER CONFIGURATION MANAGER CONCEPTS
Architecture of an System Center 2012 Configuration Manager Installation
Managing Assets
Content Delivery and Management
Security, Monitoring, and Remote Management
2 - MANAGING RESOURCES
Implementing Discovery
Organizing Resources with Collections
Working with Boundaries
3 - WORKING WITH CLIENTS
Installing the Configuration Manager Client
Managing Client Settings
Managing Client Operations
Monitoring Client Status
4 - DISTRIBUTING SOFTWARE
Configure the Software Distribution Components
Working with Distribution Points
Creating Content for Distribution
Deploying Software Applications
5 - UPDATING SYSTEMS WITH WSUS AND SCCM
Integrating Configuration Manager and WSUS
Managing Updates through Software Update Groups
Creating and Deploying Update Packages
Working with Automatic Deployment Rules
6 - HOW POWERSHELL CAN MANAGE COMPLIANCE SETTINGS
Creating Compliance Settings Objects
Deploying and Monitor the Baseline
7 - CONFIGURING OPERATING SYSTEM DEPLOYMENT OBJECTS
Preparing the OSD Environment
Working with Task Sequences
8 - WORKING AT THE SITE LEVEL
Modify the Site
Adding Site System Roles
Adding a Secondary Site
9 - SECURITY AND MONITORING
Configuring Role Based Administration
Implementing Endpoint Protection
Configuring Monitoring Options
10 - USING POWERSHELL SCRIPTING TO AUTOMATE SCCM TASKS
Review of Scripting Constructs
Introduction to the Configuration Manager WMI Classes

Nexus Human

Microsoft Certification

Sccm

Microsoft Certified Technology Specialist (MCTS)

Microsoft SC-100

Commercial & Contract Management Certification Program (CCM)

Microsoft SC-200

55133 PowerShell for System Center Configuration Manager Administrators

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The CompTIA Cloud Essentials+ Specialty certification is relevant to IT specialists, IT technical services specialists, IT relationship managers, IT architects, consultants, business and IT management, business process owners, and analysts.</p>Overview<p>Upon successful completion of this course, students will be able to:  Learn the fundamental concepts of cloud computing.  Learn the business aspects and impact of cloud computing.  Differentiate the types of cloud solutions and the adoption measures needed for each.  Identify the technical challenges and the mitigation measures involved in cloud computing.  Identify the steps to successfully adopt cloud services.  Identify the basic concepts of ITIL and describe how the ITIL framework is useful in the implementation of cloud computing in an organization.  Identify the possible risks involved in cloud computing and the risk mitigation measures, and you will also identify the potential cost considerations for the implementation of cloud and its strategic benefits.</p><p>Students will weigh the pros and cons of cloud computing to make effective decisions and meet IT challenges.</p></div><div id="course-pills-2"><h3>1 - Understanding Cloud Computing Concepts</h3> <ul> <li>Topic A: Understand Basic Cloud Concepts and Terms</li> <li>Topic B: Identify Cloud Network and Cloud Storage Technologies</li> <li>Topic C: Recognize Cloud Design Aspects</li> </ul> <h3>2 - Applying Cloud Business Principles</h3> <ul> <li>Topic A: Relate Cloud Concepts to Business Principles</li> <li>Topic B: Establish Cloud Vendor Relations</li> <li>Topic C: Distinguish the Financial Aspects of Engaging a Cloud Service Provider</li> <li>Topic D: Report Financial Expenditures</li> </ul> <h3>3 - Advising a Cloud Design and Migration</h3> <ul> <li>Topic A: Relate Cloud Concepts to Cloud Design and Migration</li> <li>Topic B: Use Cloud Assessments</li> <li>Topic C: Manage Cloud Design</li> <li>Topic D: Compare Cloud Migration Approaches</li> <li>Topic E: Identify Benefits and Solutions of Cloud Services</li> </ul> <h3>4 - Operating in the Cloud</h3> <ul> <li>Topic A: Relate Cloud Concepts to Technical Operations</li> <li>Topic B: Identify the Technical Aspects of Cloud Operations</li> <li>Topic C: Understand DevOps in the Cloud</li> <li>Topic D: Explain Cloud Security Concerns, Measures, and Concepts</li> </ul> <h3>5 - Managing Cloud Governance</h3> <ul> <li>Topic A: Relate Cloud Concepts to Governance</li> <li>Topic B: Apply Risk Management Concepts</li> <li>Topic C: Understand Compliance and the Cloud</li> <li>Topic D: Manage Policies and Procedures for Cloud Services</li> </ul> <h3>6 - Appendix A: Mapping Course Content to the CompTIA Cloud Essentials+ (Exam CLO-002)</h3> <h3>7 - Appendix B: CompTIA Cloud Essentials+ (Exam CLO-002) Acronyms</h3> <h3>8 - Glossary</h3> <h3>9 - Index</h3></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CompTIA Cloud Essentials Plus Certification (Exam CLO-002) 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 CompTIA Cloud Essentials Plus Certification (Exam CLO-002) 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>

Duration
3 Days
18 CPD hours
This course is intended for
The CompTIA Cloud Essentials+ Specialty certification is relevant to IT specialists, IT technical services specialists, IT relationship managers, IT architects, consultants, business and IT management, business process owners, and analysts.
Overview
Upon successful completion of this course, students will be able to: Learn the fundamental concepts of cloud computing. Learn the business aspects and impact of cloud computing. Differentiate the types of cloud solutions and the adoption measures needed for each. Identify the technical challenges and the mitigation measures involved in cloud computing. Identify the steps to successfully adopt cloud services. Identify the basic concepts of ITIL and describe how the ITIL framework is useful in the implementation of cloud computing in an organization. Identify the possible risks involved in cloud computing and the risk mitigation measures, and you will also identify the potential cost considerations for the implementation of cloud and its strategic benefits.
Students will weigh the pros and cons of cloud computing to make effective decisions and meet IT challenges.
1 - Understanding Cloud Computing Concepts
Topic A: Understand Basic Cloud Concepts and Terms
Topic B: Identify Cloud Network and Cloud Storage Technologies
Topic C: Recognize Cloud Design Aspects
2 - Applying Cloud Business Principles
Topic A: Relate Cloud Concepts to Business Principles
Topic B: Establish Cloud Vendor Relations
Topic C: Distinguish the Financial Aspects of Engaging a Cloud Service Provider
Topic D: Report Financial Expenditures
3 - Advising a Cloud Design and Migration
Topic A: Relate Cloud Concepts to Cloud Design and Migration
Topic B: Use Cloud Assessments
Topic C: Manage Cloud Design
Topic D: Compare Cloud Migration Approaches
Topic E: Identify Benefits and Solutions of Cloud Services
4 - Operating in the Cloud
Topic A: Relate Cloud Concepts to Technical Operations
Topic B: Identify the Technical Aspects of Cloud Operations
Topic C: Understand DevOps in the Cloud
Topic D: Explain Cloud Security Concerns, Measures, and Concepts
5 - Managing Cloud Governance
Topic A: Relate Cloud Concepts to Governance
Topic B: Apply Risk Management Concepts
Topic C: Understand Compliance and the Cloud
Topic D: Manage Policies and Procedures for Cloud Services
6 - Appendix A: Mapping Course Content to the CompTIA Cloud Essentials+ (Exam CLO-002)
7 - Appendix B: CompTIA Cloud Essentials+ (Exam CLO-002) Acronyms
8 - Glossary
9 - Index
Additional course details:
Nexus Humans CompTIA Cloud Essentials Plus Certification (Exam CLO-002) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. 

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the CompTIA Cloud Essentials Plus Certification (Exam CLO-002) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.


CompTIA Network+

IT Certifications

AWS Certified Cloud Practitioner

Cisco Certified Entry Networking Technician (CCENT)

CompTIA A+

CompTIA Security+

CompTIA Cloud Essentials+

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users.</p>Overview<p>At course completion, you should be able to<br />describe DAX syntax, data types, and errors<br />use DAX to create calculated columns, measures, and tables<br />explain how DAX calculations are evaluated, along with the differences between row context and filter context<br />configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc.<br />create calculated columns and measures that use data from multiple tables in the data model<br />write measures that handle error conditions gracefully<br />use DAX to enhance the Power BI user experience<br />use DAX Studio to connect to a Power BI data model and execute simple queries</p><p>Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code.</p></div><div id="course-pills-2"><h4>MODULE 1: GETTING STARTED WITH DAX </h4><ul><li>INTRODUCTION TODAX </li><li>CREATING OBJECTS WITHDAX </li><li>CONTEXT AND RULES OF EVALUATION</li><li>VARIABLES,COMMENTS,AND TESTING</li></ul><h4>MODULE 2: PERFORMING BASIC CALCULATIONS</h4><ul><li>GETTING STARTED</li><li>IMPLICIT MEASURES </li><li>ADDING QUICK MEASURES </li><li>WORKING WITH DAX DATA TYPES .</li><li>DOING BASIC MATH </li><li>USING LOGIC IN YOUR CALCULATIONS </li><li>USING THE IF() FUNCTION </li><li>NESTED IF()</li><li>USING THE SWITCH() FUNCTION </li><li>ADVANCED SWITCH()</li><li>LOGICAL OPERATORS &amp; FUNCTIONS: ||, OR(), &amp;&amp;, AND(), NOT()</li><li>AGGREGATING AND SUMMARIZING DATA </li><li>THE SUM() FUNCTION</li></ul><h4>MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL </h4><ul><li>CONTEXT DEFINED </li><li>DATA MODELING BASICS </li><li>INTRODUCTION TO DIMENSIONAL MODELING </li><li>RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT </li><li>GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE</li><li>LOOKING UP DATA WITHOUT USING RELATIONSHIPS </li><li>MODIFYING THE CONTEXT USING CALCULATE()</li></ul><h4>MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS </h4><ul><li>THE DAX ITERATOR FUNCTIONS </li><li>USING TABLE MANIPULATION FUNCTIONS</li></ul><h4>MODULE 5: WORKING WITH TIME</h4><ul><li>PERFORMING DATE CALCULATIONS </li><li>WORKING WITH DATE TABLES </li><li>GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION </li><li>DEFINING CUSTOM OPERATING PERIODS </li><li>YTD, QTD, AND MTD CALCULATIONS </li><li>CUSTOM TO-DATE CALCULATIONS </li><li>FINDING YEAR-OVER-YEAR CHANGE </li><li>FINDING MOVING AVERAGES </li></ul><h4>MODULE 6: ENHANCING THE USER EXPERIENCE</h4><ul><li>CONTROLLING VISIBILITYOF YOUR MEASURES</li><li>USING WHAT-IF PARAMETERS </li><li>ADDING BANDING </li><li>USING DAX TO PROVIDE ROW-LEVEL SECURITY </li></ul></div>

Duration
2 Days
12 CPD hours
This course is intended for
This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users.
Overview
At course completion, you should be able to
describe DAX syntax, data types, and errors
use DAX to create calculated columns, measures, and tables
explain how DAX calculations are evaluated, along with the differences between row context and filter context
configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc.
create calculated columns and measures that use data from multiple tables in the data model
write measures that handle error conditions gracefully
use DAX to enhance the Power BI user experience
use DAX Studio to connect to a Power BI data model and execute simple queries
Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code.
MODULE 1: GETTING STARTED WITH DAX
INTRODUCTION TODAX
CREATING OBJECTS WITHDAX
CONTEXT AND RULES OF EVALUATION
VARIABLES,COMMENTS,AND TESTING
MODULE 2: PERFORMING BASIC CALCULATIONS
GETTING STARTED
IMPLICIT MEASURES
ADDING QUICK MEASURES
WORKING WITH DAX DATA TYPES .
DOING BASIC MATH
USING LOGIC IN YOUR CALCULATIONS
USING THE IF() FUNCTION
NESTED IF()
USING THE SWITCH() FUNCTION
ADVANCED SWITCH()
LOGICAL OPERATORS & FUNCTIONS: ||, OR(), &&, AND(), NOT()
AGGREGATING AND SUMMARIZING DATA
THE SUM() FUNCTION
MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL
CONTEXT DEFINED
DATA MODELING BASICS
INTRODUCTION TO DIMENSIONAL MODELING
RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT
GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE
LOOKING UP DATA WITHOUT USING RELATIONSHIPS
MODIFYING THE CONTEXT USING CALCULATE()
MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS
THE DAX ITERATOR FUNCTIONS
USING TABLE MANIPULATION FUNCTIONS
MODULE 5: WORKING WITH TIME
PERFORMING DATE CALCULATIONS
WORKING WITH DATE TABLES
GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION
DEFINING CUSTOM OPERATING PERIODS
YTD, QTD, AND MTD CALCULATIONS
CUSTOM TO-DATE CALCULATIONS
FINDING YEAR-OVER-YEAR CHANGE
FINDING MOVING AVERAGES
MODULE 6: ENHANCING THE USER EXPERIENCE
CONTROLLING VISIBILITYOF YOUR MEASURES
USING WHAT-IF PARAMETERS
ADDING BANDING
USING DAX TO PROVIDE ROW-LEVEL SECURITY

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Excel Analytics

Data Analysis Expressions

Data Skills

Introduction to DAX for Power BI

Bournemouth

This 18 weeks Virtual Airline Cabin Crew course delivered via Zoom. Lessons scheduled for once a week, evenings from 6:30pm to 9pm. 98% Employment rate after completion of the course.



Virtual Airline Cabin Crew which is also known as Air Hostess, Flight Attendant and Stewardess course – Join your lesson from wherever you are. 
This intensive 18 weeks Virtual Airline Cabin Crew course designed for candidates who wish to:

Travel the world and be paid for it

Work in a friendly, collaborative atmosphere, 5000 metres above the sea level

Build a global network
This glamourous and exciting job requires lots of training and energy. Behind the beautiful smile of each flight attendant, stands a highly trained and skilled person who can deal with unforeseen situations on board. 
98% Employment rate after completion of the course.


How will you learn?
Apart of our traditional class-based tuition, we also offer Virtual Learning courses.
On our Virtual (live stream via Zoom) lessons, we provide the same quality of tuition as in the classroom. You only need a laptop, PC or tablet with either built in (or external) camera and microphone. The virtual platform is very interactive with a sense of real classroom at the Academy. You will study from the comfort of your own home and communicate with your tutor and classmates via video chat (by using your phone or computer camera) and you will receive outstanding tuition, qualification, and certification.
We provide A-Z guidance starting from before and after the course. Your tutor will guide you through the online course to graduation which you will be welcome to attend. What a joy it would be to meet your tutor and classmates in real life!!
You will have:

According to the timetable- 1 lesson per week for 18 consecutive weeks.

Exams and final exam based on which the certificate will be issued.

On successful completion you will hold: Airline Cabin Crew certificate in Current Airline Training Standards and Equipment.

Individual support on the journey from the course to a job placement

Receive constant updates on recruitment and news from Aviation the world

We will enhance your CV

Full support on your job application process

Gain an insight into the airline selection process and final one-to-one interview
What is Flight Attendant?
Flight attendant/Airline Cabin Crew/Stewardess/Air Hostess are the most visible, glamorous jobs of all airline employees. A Flight Attendant is someone whose primary duty is to ensure the safety and comfort of passengers during a flight. They are members of an aircrew team , who operate a commercial, business or even military aircraft while travelling domestically or internationally. 
Flight Attendant benefits:
Getting paid for travelling the world
Lifestyle
Flexible Work Schedules
Meeting Interesting People
Free Food & Accommodation
Excellent Compensation
The uniforms
Working Environment
How to become successful Flight Attendant job candidate?Our Aviation Team understands each candidate who wish to become Airline Cabin Crew or start a career in Aviation.
Airline companies look for individuals who share their values and can act as ambassadors for the company’s brand. Cabin Crew are the face of the airline company which means they deliver a fantastic service that makes airline world famous.
Airline companies prefer candidates with knowledge of Cabin Crew role. Airline companies have selection day or online tests as a first stage of recruitment, after which, they will take a closer look at applicants CV, skills and experience. If you completed Airline Cabin Crew course, your application will stand out and you can get an offer from the first round. 
Student – Cabin Crew Flying Support Group
As a market leading Airline Cabin Crew Training Company with a wealth of experience in Aviation and recruitment, we constantly upgrading our course and going extra nautical mile to guide and support all our students to ensure they can reach their goals. Graduates who are already flying, offer their full support to us and new students. They share an insight of the airline they already fly with, and help new students through the process of joining them at that airline. It gives a flying start to a career to new learners. 

Why London Waterloo Academy?
Top Airline Cabin Crew course provider in London
98% Employment rate after completion of the course
With years of experience in Airline Cabin Crew industry, London Waterloo Academy has been recognised by major TV, radio channels who have invited our Aviation Team for expert advice or interview.
We are recognised by major airline companies in Europe and overseas who have approached London Waterloo Academy to deliver internal cabin crew training, corporate training and to recruit our graduates as a result of their high qualification standards and knowledge.
Our graduates are now flying with Etihad, Saudi Air, Hainan Airlines, Small Planet, British Airways, Qatar, EasyJet, Thomas Cook, Ryanair, Cubana de Aviación, Air France,Titan, Norwegian B737 Short Haul and many more.
The vast global experience of our instructors
This course has been developed in accordance with EASA PART-CC

Working together – Starting a new career isn’t easy and often it can seem like a lonely and impossible process. Our Aviation Department stays behind each learner, supporting every step of the way, we give you all the tools, skills and assistance you need to succeed. Our success, built on the success of our students and a long list of graduates with successful stories.
Course Entry Requirements:
English Language at B2 (CEFR) level or above.
There are no other special requirements for this Airline Cabin Crew course. We will teach you from scratch and support after the course when applying for the job. This course has been developed for all candidates, independent of their background, wishing to start a new career. 
Dates (choose one for your course):
14 March 2024 – 11 July 2024, Thursday classes
10 June 2024 – 7 October 2024, Monday classes
17 September 2024 – 14 January 2025, Tuesday classes
18 November 2024 – 17 March 2025, Monday classes
Course duration – 18 weeks
Classes – once a week 
Lesson Time – 6:30pm to 9pm – GMT (London time)
Course fee – £529 (we offer flexible payment plan and accept weekly instalments)
Registration fee – £300 (includes: examination, Airline Cabin Crew certificate in Current Airline Training Standards and Equipment)








London Waterloo Academy

Flight Attendant

Stewardess

FLIGHT ATTENDANT VIRTUAL VIA ZOOM COURSE, EVENINGS

Registration Fee

Course Fee

<article>
<div>
<h5>Java EVENINGS Course</h5>
</div>
<div></div>
<p>  						 
	</p><div>
	<ul>
		<p>
		<b>Python EVENINGS Course. </b>Basic Python syntax and principles of Object Orientated Programming. 
		<br />Most attendees are in-work IT Professional.
		<br />Private individuals are also very welcome. 
		<br />Evening courses also running.
		<br /><b>Our Style: </b>Hands-on, Practical  
		<br /><b>Location:  </b>Online, Instructor-led  
		<br /><b>Download:  </b>anaconda.com
		<br /><b>Duration:  </b>6 weeks, 1 evening per week, 6pm - 8pm
		<br /><b>Times: </b>arrange a time for your time zone
	    </p>
	</ul>	

<p></p>
</div></article>

<div>
	  <div>
		 <h5>Python Basics EVENINGS Course </h5>
	  </div>
	  <div></div>
	  <p> 
 
				This Python course London Evening covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom.
				This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language.
				These concepts are daily used by programmers and is your first step to working as a programmer.
				By the end, you'll be comfortable in programming Python code.
				You will have done small projects.
				This will serve for you as examples and samples that you can use to build larger projects.
				You can publish your code online to keep as a portfolio.

<br />
This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered.

	  </p>
	<div>
	<h5>Week 1: Basics</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Python Data Types and Variables:</strong>  
					<br />  Primitive types; Characters &amp; Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python.	 
					<br /> <strong>Operators and Expressions: </strong>   
					<br />  Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators.
					</p> 
			 
				<p><strong> Decision Making:</strong>
				<br />If statement; If - else statement; If- elif - else statement; Nested if - else.
				</p><p><strong>Using Loops:</strong>
				<br />The while, while-else.
				<br />For loop;
				<br />Jump statements: break, continue;
				<br />Nesting loops.				
				</p>
			</div>
	<div>
	<h5>Week 2: Data Structures</h5>
	</div> <div></div>
	<div> 
				<p> Lists.
					<br />Tuples.
					<br />Sets.
					<br />Dictionary. Nested Dictionary.
					<br />Json Files.
				</p>
			</div>
	<div>
	<h5>Week 3: Python built-in functions</h5>
	</div> <div></div>
	<div> 
				<p>  
				<br />Using Built-in modules and functions:
				<br />Strings Functions.
				<br />Pattern matching with Regex.
				<br />Maths Functions.
				<br />Random Functions.
				<br />Python Date functions.
				</p>
			</div>
	<div>
	<h5>Week 4: OOP: Using Modules, functions, classes</h5>
	</div> <div></div>
	<div>
				<p>  Creating and using custom Functions.
					<br />Creating functions;
					<br />Using parameters and return values;
					<br />
					<br />Introduction to Classes and Objects:
					<br />Creating a Class; 
					<br />Creating an Object; Using an Object; 
					<br />Adding Instance variables; Controlling accessibility; Naming conventions for class members. 
					<br /> Class Constructors; Parameterized Constructors.
					<br />Inheritance. Overload.
				</p>
			</div>

	<div>
	<h5>Week 5: Pandas DataBase Basics</h5>
	</div> <div></div>
	<div>	 
		<p> <b>Connection details:</b>
				Connect to a database using access codes. 
				<br /><b>Select Queries:</b>
				Retrieving records and iterating results sets, using variables and parameters in queries. 
				<br />Working with DDL comands:
				Create a database, drop a database.
				Create a table, alter tables, drop a table. 
				<br />Working with DML Commands:
				Insert, delete, update records.
		</p>
	</div>
	
	 
	<div>
	<h5>Week 6: Pandas Dataframe Basics</h5>
	</div> <div></div>
	<div>	 
		<p> Getting data into a dataframe:
			<br />Dict to Dataframe, Dataframe to Dict.
			<br />Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets.

			<br />Dataframe basics:
			<br />Slicing Dataframes,
			<br />Getting information about the dataframe,
			<br />Filter, sort and query a Dataframes,
			<br />Duplicate values,
			<br />Working with null-values,
			<br />Sampling,
			<br />Group by,
			<br />Join.

		</p>
	</div>
	  
</div>
 

<div>   

	   <div id="cincluded">
		  <div>
			 <h5>What is included</h5>
		  </div>

		  <article>
		  <div>
			 <ul>
				<li>PCWorkshops Course Certificate on completion  </li>
									   
				<li>Python Course Notes</li>
				<li>Python Code Examples</li>
				<li>Practical Python Course exercises and Code Samples</li>
				<li>After the course: 1-Hour personalised online revision session</li>
			 </ul>
		  </div>
		  </article>
	   </div>
				    
<div>
	                  <div>
	                     <h5 id="cincluded2">Book the Python  Course</h5>
	                  </div>
 
<div id="eventbrite-widget-container-60636103217"></div>




							 
</div>
				   <div id="caboutus">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	        </div>

Python EVENINGS Course
Basic Python syntax and principles of object-oriented programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details:
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 4 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
How to attend:  
Connection Link For the course: https://meet.goto.com/910697125
Once you have made the payment, use the above link on the date booked, to connect with the trainer. 
Python Basics EVENINGS Course
 This Python course London Evening covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom. This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language. These concepts are daily used by programmers and is your first step to working as a programmer. By the end, you'll be comfortable in programming Python code. You will have done small projects. This will serve for you as examples and samples that you can use to build larger projects. You can publish your code online to keep as a portfolio. 

This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered. 
Week 1: Basics
 Python Data Types and Variables: 
Primitive Data types; Working with variables and its scope; Conversion and casting types in Python. 
 Operators and Expressions:  
 Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators. 
 Decision Making: 
If statement; If - else statement; If- elif - else statement; Nested if - else. 
Using Loops: 
The while, while-else. 
For loop; 
Jump statements: break, continue; 
Nesting loops. 
Week 2: Data Structures & Database
Lists.  
Tuples. 
Sets. 
Dictionary. Nested Dictionary. 
Json Files. 
Reading csv and text files
Connecting with a database and run SQL Queries. 
Week 3: Python built-in functions &  Pandas Dataframe Basics
 
Using built-in modules and functions: 
Strings Functions. 
Maths Functions. 
Random Functions. 
Data Frames; 
Getting data into a dataframe: 
Dict to Dataframe, Dataframe to Dict.  
Dataframe basics: 
Slicing Dataframes, 
Getting information about the dataframe, 
Filter and query a Dataframes, 
Working with null-values.
Week 4: OOP: Using Modules, functions, classes
 Creating and using custom Functions. 
Creating functions; 
Using parameters and return values; 
 
Introduction to Classes and Objects: 
Creating a Class; 
Creating an Object; Using an Object; 
Adding instance variables; controlling accessibility; and naming conventions for class members. 
 Class Constructors; Parameterized Constructors. 
Inheritance. Overload. 

What is included
PCWorkshops Course Certificate on completion
Python Course Notes
Python Code Examples
Practical Python Course exercises and Code Samples
After the course: 1-Hour personalised online revision session
  

Online Course Creation

Programming Fundamentals

Computer Programming

Professional Skills Course (PSC)

Instructor

Python

Basic Python syntax and principles of Object Orientated Programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 

Python EVENINGS Course, Online Instructor-led

Broxburn

<p id="isPasted" style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">C20M03 - Access Control Principles</strong></p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course content<br fr-original-style="" style="box-sizing: border-box;"></strong></p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);">Learners will be introduced to the design, installation, commissioning, and maintenance of Access Control systems. This CPD provides a foundation knowledge of Access Control in relation to the requirements of NCP 109 (NSI) and SS2002 (SSAIB) Third Party Certification Bodies codes of practice, associated standards, and the various legal frameworks within the UK.</p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who should attend?</strong></p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);">All those involved in the specifying, design, installation, commissioning, and maintenance of Access Control Systems including specifiers, property managers, consultants, FM providers, security consultants, security installers.</p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course content</strong></p><ul style="color: rgb(63, 77, 90); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Enquiry</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Risk Assessment<ul style="font-size: initial; box-sizing: border-box;" fr-original-style="font-size: initial;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Operational Requirements</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Initial Design</li></ul></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Quote</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Order</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">System Design Specification</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Installation</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Commissioning</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Handover</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Maintenance</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Assessment</li></ul><p id="isPasted" style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><img src="https://images.cademy.co.uk/88d338d8-7dc4-4054-bf9e-401495774eee/5293624b-3258-4be0-b61f-1d0469f76c49/original.png" style="width: 300px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 300px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto;" fr-original-class="fr-draggable"></p>

C20M03 - Access Control Principles
Course content

Learners will be introduced to the design, installation, commissioning, and maintenance of Access Control systems. This CPD provides a foundation knowledge of Access Control in relation to the requirements of NCP 109 (NSI) and SS2002 (SSAIB) Third-Party Certification Bodies codes of practice, associated standards, and the various legal frameworks within the UK.
Who should attend?
All those involved in the specifying, design, installation, commissioning, and maintenance of Access Control Systems including specifiers, property managers, consultants, FM providers, security consultants, and security installers.
Course content
Enquiry
Risk Assessment
Operational Requirements
Initial Design
Quote
Order
System Design Specification
Installation
Commissioning
Handover
Maintenance
Assessment



Ember Compliance

Engineer

Learners will be introduced to the design, installation, commissioning, and maintenance of Access Control systems. 

516 Opera courses in Sheffield

Developing Personal Resilience as a Leader

By Mpi Learning - Professional Learning And Development Provider

NPORS Forward Tipping Dumper (N204)

By Dynamic Training and Assessments Ltd

NPORS Road Roller (N214)

By Dynamic Training and Assessments Ltd

NPORS Forward Tipping Mini Dumper (N139)

By Dynamic Training and Assessments Ltd

NPORS MEWP Boom (N108)

By Dynamic Training and Assessments Ltd

NPORS Rear Tipping Dumper (N205)

By Dynamic Training and Assessments Ltd

NPORS Skidsteer Loader (N212)

By Dynamic Training and Assessments Ltd

NPORS Excavator Micro (up to 1 Tonne) (N016)

By Dynamic Training and Assessments Ltd

NPORS Compact Crane (N140)

By Dynamic Training and Assessments Ltd

NPORS Shunter Vehicle (N243)

By Dynamic Training and Assessments Ltd

Search By Location