Nottinghamshire

<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);"><span style="color: rgb(0, 0, 0); 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></span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">To provide knowledge and understanding in the following areas:</p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">Gaining a basic understanding of the industry, the dangers of working in the industry and responsibilities as an operator.</li><li fr-original-style="" style="box-sizing: border-box;">Learning 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;">Being 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;">Being able to locate and identify key controls and explain their functions.</li><li fr-original-style="" style="box-sizing: border-box;">Setting up exclusion zone</li><li fr-original-style="" style="box-sizing: border-box;">Identifying and maintaining PPE appropriate for remote control tower crane use.</li><li fr-original-style="" style="box-sizing: border-box;">Conducting all pre-operational and running checks in accordance with manufacturer&#39;s and legislative requirements.</li><li fr-original-style="" style="box-sizing: border-box;">Preparing the remote control tower crane for use and operating 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;">Carrying out all end of work and shut down procedures.</li></ul><h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Entry Requirements</h2><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please note, 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 style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Good understanding of spoken and written English.</p>

COURSE INFORMATION
To provide knowledge and understanding in the following areas:
Gaining a basic understanding of the industry, the dangers of working in the industry and responsibilities as an operator.
Learning a working knowledge of the manufacturer’s handbook for the particular machine to be used.
Being able to locate and identify the major components of the machine and explain their functions.
Being able to locate and identify key controls and explain their functions.
Setting up exclusion zone
Identifying and maintaining PPE appropriate for remote control tower crane use.
Conducting all pre-operational and running checks in accordance with manufacturer's and legislative requirements.
Preparing the remote control tower crane for use and operating machine safely and efficiently
Environmental considerations
Carrying 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.

Dynamic Training and Assessments Ltd

Construction

CSCS (Construction Skills Certification Scheme)

NPORS

NPORS Remote Control Tower Crane (N115)

<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);"><span style="color: rgb(0, 0, 0); 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></span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">To provide knowledge and understanding in the following areas:</p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><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 overhead 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 overhead 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 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Entry Requirements</h2><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please note, 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 style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Good understanding of spoken and written English.</p>

COURSE INFORMATION
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 overhead crane use
Conduct all pre-operational and running checks in accordance with manufacturer’s and legislative requirements
Prepare the overhead 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 Overhead Crane (N104)

<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);"><span style="color: rgb(0, 0, 0); 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></span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">To provide knowledge and understanding in the following areas:</p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><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 mobile 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 mobile 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 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Entry Requirements</h2><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please note, 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 style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Good understanding of spoken and written English.</p>

COURSE INFORMATION
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 mobile crane use
Conduct all pre-operational and running checks in accordance with manufacturer’s and legislative requirements
Prepare the mobile 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 Mobile Crane (N101)

<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);"><span style="color: rgb(0, 0, 0); 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></span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">To provide knowledge and understanding in the following areas:</p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><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;">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 loading shovel 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 loading shovel for use, operate machinery 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;">Storage and transport of implements and attachments</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><h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Entry Requirements</h2><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please note, 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 style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Good understanding of spoken and written English.</p>

COURSE INFORMATION
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
Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
Identify and maintain PPE appropriate for loading shovel use
Conduct all necessary safety checks at the work area
Prepare the loading shovel 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
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 Loading Shovel (N209)

<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 Overview</strong></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">To provide knowledge and understanding in the following areas:</p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">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;">A working knowledge of the manufacturers handbook and be familiar with other sources of information available including relevant legislation</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;">Conduct all pre-operational checks in accordance with manufacturers and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for petrol driven cut off saw</li><li fr-original-style="" style="box-sizing: border-box;">Select suitable type of blade relative to the work being undertaken</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area and set up safety zone</li><li fr-original-style="" style="box-sizing: border-box;">Prepare the machine for use and operate machinery 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;">Storage and transport of petrol driven cut off saw</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down procedures</li></ul><h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Entry Requirements</h2><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Operators are required to supply proof to support 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 style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Good understanding of spoken and written English.</p>

Course Overview
To provide knowledge and understanding in the following areas:
A basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator
A working knowledge of the manufacturers handbook and be familiar with other sources of information available including relevant legislation
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 manufacturers and legislative requirements
Identify and maintain PPE appropriate for petrol driven cut off saw
Select suitable type of blade relative to the work being undertaken
Conduct all necessary safety checks at the work area and set up safety zone
Prepare the machine for use and operate machinery safely and efficiently
Environmental considerations
Storage and transport of petrol driven cut off saw
Carry out all end of shift and shut down procedures
Entry Requirements
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.

Abrasive Wheels - Handheld Cut off Saw (N017)

NPORS Abrasive Wheels - Handheld Cut off Saw (N017)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></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 to operate dozers safely and efficiently.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content</strong></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);">Candidates will be able to:</p><ul style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><li fr-original-style="" style="box-sizing: border-box;">Understand 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;">Understand the manufacturer&rsquo;s handbook for the particular machine to be used</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify key controls 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 dozer 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 dozer for use, operate machinery safely and efficiently</li><li fr-original-style="" style="box-sizing: border-box;">Attach and set trailed, mounted attachments ready for work</li><li fr-original-style="" style="box-sizing: border-box;">Understand environmental considerations</li><li fr-original-style="" style="box-sizing: border-box;">Storage and transport of implements and attachments</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><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements</strong></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 CSCS &ndash; Candidates must have achieved the relevant CITB Health, Safety &amp; Environment (HS&amp;E) touch-screen-test within 2 years.</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);">Good understanding of spoken and written English.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration</strong></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);">Novice course &ndash; 10 Days depending upon experience</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 &ndash; 1 day theory and practical assessment</p><div style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Location</strong></h2></div><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Customer Site (Training &amp; Testing) &ndash; Site must adhere to NPORS specifications</p>

Overview
This course is aimed at candidates that require the knowledge and practical skills to operate dozers safely and efficiently.
Course Content
Candidates will be able to:
Understand the industry, the dangers of working in the industry and their responsibilities as an operator
Understand the manufacturer’s handbook for the particular machine to be used
Locate and identify the major components of the machine and explain their functions
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 dozer use
Conduct all necessary safety checks at the work area
Prepare the dozer for use, operate machinery safely and efficiently
Attach and set trailed, mounted attachments ready for work
Understand 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
Entry Requirements
NPORS CSCS – Candidates must have achieved the relevant CITB Health, Safety & Environment (HS&E) touch-screen-test within 2 years.
Good understanding of spoken and written English.
Duration
Novice course – 10 Days depending upon experience
Experienced worker tests – 1 day theory and practical assessment
Location
Customer Site (Training & Testing) – Site must adhere to NPORS specifications

NPORS Dozer (N215)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></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 to operator Piling rigs to form and construct piles.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content</strong></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);">Candidates will be able to:</p><ul style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><li fr-original-style="" style="box-sizing: border-box;">Understand 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;">Understand the manufacturer&rsquo;s handbook for the particular machine to be used</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify key controls 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;">Select suitable type of piling rig relative to the work being undertaken</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for piling rig use</li><li fr-original-style="" style="box-sizing: border-box;">Prepare the piling rig for 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;">Operate machinery safely and efficiently</li><li fr-original-style="" style="box-sizing: border-box;">Understand environmental considerations</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><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements</strong></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 CSCS &ndash; Candidates must have achieved the relevant CITB Health, Safety &amp; Environment (HS&amp;E) touch-screen-test within 2 years.</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);">Good understanding of spoken and written English.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration</strong></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);">Novice course &ndash; 10 Days depending on experience</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 &ndash; 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);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Location</strong></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);">Customer Site (Training &amp; Testing) &ndash; Site must adhere to NPORS specifications</p>

Overview
This course is aimed at candidates that require the knowledge and practical skills to operator Piling rigs to form and construct piles.
Course Content
Candidates will be able to:
Understand the industry, the dangers of working in the industry and their responsibilities as an operator
Understand the manufacturer’s handbook for the particular machine to be used
Locate and identify the major components of the machine and explain their functions
Locate and identify key controls and explain their functions
Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
Select suitable type of piling rig relative to the work being undertaken
Identify and maintain PPE appropriate for piling rig use
Prepare the piling rig for use
Conduct all necessary safety checks at the work area
Operate machinery safely and efficiently
Understand environmental considerations
Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation
Carry out all end of shift and shut down procedures
Entry Requirements
NPORS CSCS – Candidates must have achieved the relevant CITB Health, Safety & Environment (HS&E) touch-screen-test within 2 years.
Good understanding of spoken and written English.
Duration
Novice course – 10 Days depending on experience
Experienced worker tests – 1 day theory and practical assessment
Location
Customer Site (Training & Testing) – Site must adhere to NPORS specifications

NPORS Piling Rig (N221)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></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 to operate horizontal directional drilling rigs in the workplace safely and efficiently.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content</strong></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);">Candidates will be able to:</p><ul style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><li fr-original-style="" style="box-sizing: border-box;">Understand 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;">Understand the manufacturer&rsquo;s handbook for the particular machine to be used</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify key controls 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;">Select suitable type of horizontal directional drilling rig relative to the work being undertaken</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for horizontal directional drilling rig use</li><li fr-original-style="" style="box-sizing: border-box;">Prepare the horizontal directional drilling rig for 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;">Operate machinery safely and efficiently</li><li fr-original-style="" style="box-sizing: border-box;">Understand environmental considerations</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><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements</strong></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 CSCS &ndash; Candidates must have achieved the relevant CITB Health, Safety &amp; Environment (HS&amp;E) touch-screen-test within 2 years.</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);">Good understanding of spoken and written English.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration</strong></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);">Novice course &ndash; 5 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 &ndash; 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);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Location</strong></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);">Customer Site (Training &amp; Testing) &ndash; Site must adhere to NPORS specifications</p>

Overview
This course is aimed at candidates that require the knowledge and practical skills to operate horizontal directional drilling rigs in the workplace safely and efficiently.
Course Content
Candidates will be able to:
Understand the industry, the dangers of working in the industry and their responsibilities as an operator
Understand the manufacturer’s handbook for the particular machine to be used
Locate and identify the major components of the machine and explain their functions
Locate and identify key controls and explain their functions
Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
Select suitable type of horizontal directional drilling rig relative to the work being undertaken
Identify and maintain PPE appropriate for horizontal directional drilling rig use
Prepare the horizontal directional drilling rig for use
Conduct all necessary safety checks at the work area
Operate machinery safely and efficiently
Understand environmental considerations
Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation
Carry out all end of shift and shut down procedures
Entry Requirements
NPORS CSCS – Candidates must have achieved the relevant CITB Health, Safety & Environment (HS&E) touch-screen-test within 2 years.
Good understanding of spoken and written English.
Duration
Novice course – 5 Days
Experienced Worker Tests – 1 day theory and practical assessment
Location
Customer Site (Training & Testing) – Site must adhere to NPORS specifications

NPORS Horizontal Directional Drilling Rig (N130)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></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 to operate 180&deg; excavators to excavate and load materials.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content</strong></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);">Candidates will be able to:</p><ul style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><li fr-original-style="" style="box-sizing: border-box;">&nbsp;Understand 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;">Understand the manufacturer&rsquo;s handbook for the particular machine to be used</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify key controls 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 excavator 180&deg; use</li><li fr-original-style="" style="box-sizing: border-box;">Prepare excavator 180&deg; for 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;">Operate machinery safely and efficiently</li><li fr-original-style="" style="box-sizing: border-box;">Understand environmental considerations</li><li fr-original-style="" style="box-sizing: border-box;">Store and transport excavator 180&deg; attachments</li><li fr-original-style="" style="box-sizing: border-box;">Explain loading/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><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements</strong></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 CSCS &ndash; Candidates must have achieved the relevant CITB Health, Safety &amp; Environment (HS&amp;E) touch-screen-test within 2 years.</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);">Good understanding of spoken and written English.</p><div style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration</strong></h2></div><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 &ndash; 10 Days depending upon experience</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><div style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Location</strong></h2></div><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Customer Site (Training &amp; Testing) &ndash; Site must adhere to NPORS specifications</p>

Overview
This course is aimed at candidates that require the knowledge and practical skills to operate 180° excavators to excavate and load materials.
Course Content
Candidates will be able to:
Understand the industry, the dangers of working in the industry and their responsibilities as an operator
Understand the manufacturer’s handbook for the particular machine to be used
Locate and identify the major components of the machine and explain their functions
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 excavator 180° use
Prepare excavator 180° for use
Conduct all necessary safety checks at the work area
Operate machinery safely and efficiently
Understand environmental considerations
Store and transport excavator 180° attachments
Explain loading/unloading procedures for machine transportation
Carry out all end of shift and shut down procedures
Entry Requirements
NPORS CSCS – Candidates must have achieved the relevant CITB Health, Safety & Environment (HS&E) touch-screen-test within 2 years.
Good understanding of spoken and written English.
Duration
Novice course – 10 Days depending upon experience
Experienced worker tests- 1 day theory and practical assessment
Location
Customer Site (Training & Testing) – Site must adhere to NPORS specifications

NPORS Excavator 180 (N201)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></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 to operate mobile elevating work platforms (scissor lifts) safely and efficiently while carrying out work at heights.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content</strong></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);">Candidates will be able to:</p><ul style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><li fr-original-style="" style="box-sizing: border-box;">Understanding 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;">Understand the manufacturer&rsquo;s handbook for the particular 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;">Locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify steering, driving and braking controls 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;">Check all emergency lowering functions</li><li fr-original-style="" style="box-sizing: border-box;">Safely mount and dismount the machine</li><li fr-original-style="" style="box-sizing: border-box;">Configure the machine for travel</li><li fr-original-style="" style="box-sizing: border-box;">Configure the machine for travel and manoeuvre it safely on level 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</li><li fr-original-style="" style="box-sizing: border-box;">Manoeuvre the machine to the work area and correctly configure in readiness to carry out accessing tasks</li><li fr-original-style="" style="box-sizing: border-box;">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;">Use platform extension section</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><div style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements</strong></h2></div><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; Candidates must have achieved the relevant CITB Health, Safety &amp; Environment (HS&amp;E) touch-screen-test within 2 years.</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);">Good understanding of spoken and written English.</p><div style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration</strong></h2></div><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- 5 days depending on experience</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);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Location</strong></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);">Customer Site (Training &amp; Testing) &ndash; Site must adhere to NPORS specifications</p>

Overview
This course is aimed at candidates that require the knowledge and practical skills to operate mobile elevating work platforms (scissor lifts) safely and efficiently while carrying out work at heights.
Course Content
Candidates will be able to:
Understanding the industry, the dangers of working in the industry and their responsibilities as a plant operator
Understand the manufacturer’s handbook for the particular machine to be used, and be familiar with other types of information sources and relevant legislation
Locate and identify the major components of the machine and explain their functions
Locate and identify steering, driving and braking controls and explain their functions
Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
Check all emergency lowering functions
Safely mount and dismount the machine
Configure the machine for travel
Configure the machine for travel and manoeuvre it safely on level ground and inclines in open and confined areas
Conduct all necessary safety checks at the work area, including overhead and underground hazards
Manoeuvre the machine to the work area and correctly configure in readiness to carry out accessing tasks
Carry out accessing tasks, at various points up to full operating height
Travel with platform raised (where applicable)
Use platform extension section
Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation
Carry out all end of shift and shut down procedures
Entry Requirements
NPORS CSCS – Candidates must have achieved the relevant CITB Health, Safety & Environment (HS&E) touch-screen-test within 2 years.
Good understanding of spoken and written English.
Duration
Novice course- 5 days depending on experience
Experienced worker tests- 1 day theory and practical assessment
Location
Customer Site (Training & Testing) – Site must adhere to NPORS specifications

NPORS MEWP Scissor Lift (N109)

Slough

Newport

Milton Keynes 

Birmingham

Bedford

Liverpool 

NATIONALLY RECOGNISED AND ACCREDITED
LEVEL FOUR CERTIFICATE



This course comprises two parts:
 
Part 1 - online (eLearning)

AND

Part 2 - classroom

Part 2 consolidates on Parts 1 and delivers one full day of practical sessions (skill-set development) - PRP Harvesting and Treatment


Award:
Open College Network (OCN Credit4Learning) - Collegen Induction Therapy - PRP Treatment
LEVEL 4 (FDSc)



A modular "hybrid" course - eLearning (online) theory and one full day classroom based course.
 
PART 1 - THEORY ONLINE

Complete this part of your course online (eLearning Course) in the comfort of your own home or workplace.
Please allow 1-2 full days (approx. 12-16 hours in total) to complete this part of your course.
You do not need to complete this part of the course in one "sitting". Do as little or as much as you wish. Each time you log again exactly where you can start where you left off!
 
You must complete Part 1 before attending Part 2 below.
 
PART 2 - CLASSROOM
Attend in the classroom at the training location that you have selected.
Your classroom tutor will recap on the essential parts of your online course after which you will begin your practical sessions learning and developing the skills required to harvest and use Platelet-Rich Plasma in your treatment plan.
Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.


Course Itinerary


A hybrid modular course awarding:
OCN Accredited Level Three Certificate (Advanced Level) 3 credits AND

GEOPACE Certificate (Collagen Induction Therapy - PRP Treatment)



Parts 1 (A & B) - online (eLearning) +

Part 2 - PRP Harvesting, Preparation & Treatment (one day)


Theory Sessions:


M01 – Course Overview
Learning outcomes, Understanding recommended guidelines (CPSA, HEE, NICE & WHO), Core Competencies (Domains 1, 2 & 3). National Occupational Standards


M02 – Qualifications – Levels & Thresholds
Understanding the range and applications of treatments at Levels 1 to 8. Equivalencies. Looking at each level and specific treatment types. Competencies at Level 4.


M03 – Culture & Diversity
Understanding culture and diversity within the context of a salon, including opportunities and challenges for aesthetic therapists. Diversity and inclusion. Principles of diversity.


M04 – History, Definitions and Roles
The origins of microneedling and development of PRP, evolution of treatments, types of equipment and range of applications. Historical perspective and modern day examples of PRP therapies.


M05 – Health & Safety & IPC
H&S legislation, Standard Precautions (for blood borne pathogens), Pathogen types, Personal Protective Equipment (PPE), Handwashing and Hygiene, Hazardous Waste Disposal (non-specific), Preventing Needlestick Injuries. A detailed look at viruses, bacteria and fungi. Handling clients with infectious conditions and infestations. Transmission modes. Sterilisation processes in the workplace, including autoclaves.


M06 – Regulatory Obligations
Pathways – employed, contracted and self-employed, Management of H&S at work, Local and national government laws and bylaws, DBS types, Record Keeping, Hazardous Waste Disposal (specific), Insurance and insurance types, Accident reporting, The Keogh Review, HEE guidelines, Professional bodies.


M07 – Professionalism & Effective Communication
Presenting a professional image, guidelines and recommendations. How to effectively communicate with your clients and colleagues, communication methods, communicating efficiently in consultation.


M08 – Consent
Understanding consent types and your client’s capacity to consent. The importance of valid consent. Consent frequency. Risk assessment. Storing consent documentation – looking at paper and digital/cloud. Consent and the law. Determining if consent is robust.


M09 – Environmental and Sustainable Work Practices
Sustainability in the workplace. Running an efficient salon (water efficiency, waste reduction, interior fittings). Advancements including digital options (clients and suppliers).


M10 – Anatomy & Physiology
A&P for collagen induction therapy. Veins, arteries and capillaries (phlebotomy overview). The integumentary system – structure and function. Microneedling – depths and penetration. The lymphatic system. The circulatory system. Skin as a defence barrier. Skin – functions and layers. Merkel cells, Langerhans Cells, Keratinocytes and Melanocytes. The epidermal-melanin unit. Fibroblasts and connective tissue. The effects of ageing. Skin changes over time. Skin rejuvenation including optimising cell function and increasing natural collagen. Inducing regenerative healing. The Fitzpatrick Scale. A detailed look at cell function, specifically melanocytes, keratinocytes and fibroblasts. Microneedling the skin, effects and collagen response. Wound healing – stages (haemostasis, inflammatory, proliferative and maturation). Collagen Induction Therapy (CIT). Topical applications to improve keratinocyte function. Topical applications to improve collagen synthesis.


M11 – Patient Management – Consultation & Examination
Pre-treatment and treatment consultations. Client Motives. Educating your client. Developing a consultation plan. Medical Records. Contraindications & Precautions – Relative and Absolute Contraindications in microneedling. Microneedling and anticoagulants. Side effects and treatment failure. Photo-documentation. Looking at and recording a detailed medical history. Client reviews. Health risks. Legalities.


M12 – Record Keeping
Key points and importance. Understanding how to retain records. Claims - Date of Discovery and Date of Knowledge.


M13 – Platelet Rich Plasma (PRP) – Understanding the basics
Whole blood – composition. Platelets and growth factors (types and functions). What are platelets? Understanding platelet modes of action. Platelet Rich Plasma – preparation. PPP and PRP. PRP Activation and collagen response in vivo. Fibrin network formation. Dermal needle puncture - repair pathway. Examples of microneedling applications. Needle depths and facial skin thickness. Types of treatments – a case by case examination.


M14 – Platelet Rich Plasma (PRP) – Harvesting and Preparation
Phlebotomy. Using correct needle size and anticoagulant. Understanding autologous treatment types with PRP. The treatment agent pathway. Whole blood processing. Harvesting good quality PRP - step by step procedure. Using a centrifuge. Centrifuge operation and management. Steps to minimise platelet trauma. First and second centrifuge processes. Understanding how a centrifuge works? Managing breakage and spillage.


M15 – PRP Treatment – putting it all together!
Client arrival, management, documentation, photography, examination, consultation, consent, treatment plan. Patient ID, where necessary. Referrals and when to refer. Seeking expert advice. Employment types – employed (PAYE), contracted, self-employed (freelance) - detailed look at each. Managing equipment and consumables. Compliancy. Pre-treatment guidance. Medications and drug conflicts. Preparing a treatment area. Preparing your client. Disinfecting the face. Applying numbing cream. Phlebotomy procedures.
Blood handling. Dermapen types and accessories. Treatment modes and actions. Selecting the correct needle depth. Applying PRP and microneedling. Managing pen depth and skin areas. Working within facial zones. Post treatment management. Waste management and correct waste disposal. Post treatment client management. Aftercare. Managing adverse effects. Managing post treatment client expectations. Treatment intervals. Post treatment checklists and patient aftercare guidelines.


Classroom Practical Sessions:
Practical Session 1: Equipment familiarisation - hands-on approach
Practical Session 2: Completing medical forms and consent forms
Practical Session 3: Preparing a treatment area
Practical Session 4: Using a centrifuge
Practical Session 5: Performing a microneedling facial treatment with PRP - model 1
Practical Session 6: Performing a microneedling facial treatment with PRP - model 2


Classroom Support Material:
Support material to complement Modules 1 – 15


Online Support Material:
Downloadable pdf files - support material to complement Modules 1 - 15
Demonstration Video



Geopace Training

Medical Aesthetics

Allied Health

Platelet-rich plasma (PRP)

Aesthetics

Aesthetic Practitioner

Facial Aesthetics

Platelet-rich Plasma (PRP) treatments

    Nationally Recognised Qualification

    No previous experience or qualifications needed

    Open College Network Accreditation

    Level 4 (as required for minimally invasive procedures)

    Covers standards set by HEE

    Employed (salon) or Self-Employed opportunities

    Basic understanding of English language required

    OPEN TO ALL APPLICANTS


PRP - Collagen Induction Therapy Course (GPT701)

General Admission

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

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

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 

508 Opera courses in Leeds

NPORS Remote Control Tower Crane (N115)

By Dynamic Training and Assessments Ltd

NPORS Overhead Crane (N104)

By Dynamic Training and Assessments Ltd

NPORS Mobile Crane (N101)

By Dynamic Training and Assessments Ltd

NPORS Loading Shovel (N209)

By Dynamic Training and Assessments Ltd

NPORS Abrasive Wheels - Handheld Cut off Saw (N017)

By Dynamic Training and Assessments Ltd

NPORS Dozer (N215)

By Dynamic Training and Assessments Ltd

NPORS Piling Rig (N221)

By Dynamic Training and Assessments Ltd

NPORS Horizontal Directional Drilling Rig (N130)

By Dynamic Training and Assessments Ltd

NPORS Excavator 180 (N201)

By Dynamic Training and Assessments Ltd

NPORS MEWP Scissor Lift (N109)

By Dynamic Training and Assessments Ltd

Search By Location