Nottinghamshire

COURSE INFORMATION<div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">To provide knowledge and understanding in the following areas:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry and the relevant legislation, the dangers of working in the industry and their responsibilities as a vehicle marshal</li><li fr-original-style="" style="box-sizing: border-box;">Have knowledge of the manufacturer&rsquo;s handbook for the particular vehicle / machine to be guided</li><li fr-original-style="" style="box-sizing: border-box;">Have a good understanding of signs and signals, approved hand signals and different forms of communication</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for vehicle marshal duties</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area including stop blocks and tipping areas</li><li fr-original-style="" style="box-sizing: border-box;">Set up exclusion zone for unloading</li><li fr-original-style="" style="box-sizing: border-box;">Guide machinery in a forward and reverse direction including confined spaces and &ldquo;blind areas&rdquo; 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 shift and shut down and parking procedures</li></ul><h2 fr-original-style="" style="box-sizing: border-box;">Entry Requirements</h2>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.Good understanding of spoken and written English.</div>

COURSE INFORMATION
To provide knowledge and understanding in the following areas:
Have a basic understanding of the industry and the relevant legislation, the dangers of working in the industry and their responsibilities as a vehicle marshal
Have knowledge of the manufacturer’s handbook for the particular vehicle / machine to be guided
Have a good understanding of signs and signals, approved hand signals and different forms of communication
Identify and maintain PPE appropriate for vehicle marshal duties
Conduct all necessary safety checks at the work area including stop blocks and tipping areas
Set up exclusion zone for unloading
Guide machinery in a forward and reverse direction including confined spaces and “blind areas” safely and efficiently
Environmental considerations
Carry out all end of shift and shut down and parking 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 Vehicle Marshal (N403)

COURSE INFORMATIONTo provide knowledge and understanding in the following areas:<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 operative</li><li fr-original-style="" style="box-sizing: border-box;">State the definition of manual handling, the main causes of manual handling injuries and the reasons for manual handling training</li><li fr-original-style="" style="box-sizing: border-box;">Describe the function and shape of the human spine</li><li fr-original-style="" style="box-sizing: border-box;">Describe the function of the intervertebral discs</li><li fr-original-style="" style="box-sizing: border-box;">Understand the effects of static loading and the risks involved in team lifting</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate an understanding of formal and dynamic risk assessment</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for manual handling operations</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;">Describe and demonstrate safe handling techniques</li></ul><h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Entry Requirements</h2>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.Good understanding of spoken and written English.

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 operative
State the definition of manual handling, the main causes of manual handling injuries and the reasons for manual handling training
Describe the function and shape of the human spine
Describe the function of the intervertebral discs
Understand the effects of static loading and the risks involved in team lifting
Demonstrate an understanding of formal and dynamic risk assessment
Identify and maintain PPE appropriate for manual handling operations
Conduct all necessary safety checks at the work area
Describe and demonstrate safe handling techniques
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 Manual Handling (N704)

COURSE INFORMATIONTo provide knowledge and understanding in the following areas:<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>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.Good understanding of spoken and written English.

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.

NPORS Remote Control Tower Crane (N115)

COURSE INFORMATIONTo provide knowledge and understanding in the following areas:<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>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.Good understanding of spoken and written English.

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)

COURSE INFORMATIONTo provide knowledge and understanding in the following areas:<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 and the relevant legislation, the dangers of working in the industry and their responsibilities as a vehicle / plant machinery marshal</li><li fr-original-style="" style="box-sizing: border-box;">Have knowledge of the manufacturer&rsquo;s handbook for the particular vehicle / machine to be guided</li><li fr-original-style="" style="box-sizing: border-box;">Have a good understanding of signs and signals, approved hand signals and different forms of communication</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for vehicle / plant machinery marshal</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area including stop blocks and tipping areas</li><li fr-original-style="" style="box-sizing: border-box;">Set up exclusion zone for loading / unloading</li><li fr-original-style="" style="box-sizing: border-box;">Guide machinery in a forward and reverse direction including confined spaces and &ldquo;blind areas&rdquo; safely and efficiently&nbsp;</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 shift and shut down and parking 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>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.Good understanding of spoken and written English.

COURSE INFORMATION
To provide knowledge and understanding in the following areas:
Have a basic understanding of the industry and the relevant legislation, the dangers of working in the industry and their responsibilities as a vehicle / plant machinery marshal
Have knowledge of the manufacturer’s handbook for the particular vehicle / machine to be guided
Have a good understanding of signs and signals, approved hand signals and different
forms of communication
Identify and maintain PPE appropriate for vehicle / plant machinery marshal
Conduct all necessary safety checks at the work area including stop blocks and tipping areas
Set up exclusion zone for loading / unloading
Guide machinery in a forward and reverse direction including confined spaces and “blind areas” safely and efficiently
Environmental considerations
Carry out all end of shift and shut down and parking 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 Plant Machinery Marshal (N133)

COURSE INFORMATIONTo provide knowledge and understanding in the following areas:<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>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.Good understanding of spoken and written English.

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)

COURSE INFORMATIONTo provide knowledge and understanding in the following areas:<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>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.Good understanding of spoken and written English.

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)

Course OverviewTo provide knowledge and understanding in the following areas:<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>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.Good understanding of spoken and written English.

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)

COURSE INFORMATIONTo provide knowledge and understanding in the following areas:<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 Excavation Marshall - Banksperson</li><li fr-original-style="" style="box-sizing: border-box;">Have knowledge of the equipment to be used and be conversant with Method Statements, Risk Assessments and Permits to Work</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for use</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-excavating checks</li><li fr-original-style="" style="box-sizing: border-box;">Agree communication signals and emergency procedures</li><li fr-original-style="" style="box-sizing: border-box;">Safe positioning of Excavation Marshall - Banksperson</li><li fr-original-style="" style="box-sizing: border-box;">Define and identify the different types of underground services</li><li fr-original-style="" style="box-sizing: border-box;">Identify risks that excavations can present and how people may be affected</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;">Carry out exploratory tasks</li><li fr-original-style="" style="box-sizing: border-box;">Identify the risks of excavating near to underground services, and the safe digging practices that should be adopted</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and safe storage 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>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.Good understanding of spoken and written English.

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 Excavation Marshall - Banksperson
Have knowledge of the equipment to be used and be conversant with Method Statements, Risk Assessments and Permits to Work
Identify and maintain PPE appropriate for use
Conduct all pre-excavating checks
Agree communication signals and emergency procedures
Safe positioning of Excavation Marshall - Banksperson
Define and identify the different types of underground services
Identify risks that excavations can present and how people may be affected
Conduct all necessary safety checks at the work area
Carry out exploratory tasks
Identify the risks of excavating near to underground services, and the safe digging practices that should be adopted
Carry out all end of shift and safe storage 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 Excavation Marshall - Banksperson (N027)

COURSE INFORMATION<div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This course teaches you how to operate a mini / compact crane safely and productively.We will conduct a learner analysis to identify the duration of training required for those with limited or no experience, whereas experienced operators can attend a one day Experienced Worker Assessment (Test Only).To provide knowledge and understanding in the following areas:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator</li><li fr-original-style="" style="box-sizing: border-box;">Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify key controls and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Set up exclusion zone</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for mini compact crane use</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational and running checks in accordance with manufacturer&rsquo;s and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Prepare the mini compact crane for use and operate machine safely and efficiently</li><li fr-original-style="" style="box-sizing: border-box;">Environmental considerations</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of work and shut down procedures</li></ul><h2 fr-original-style="" style="box-sizing: border-box;">Entry Requirements</h2>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.Good understanding of spoken and written English.</div>

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

NPORS Compact Crane (N140)

MJ Electrical Training has the largest centre network in the UK, with City &amp; Guilds exams available every week.Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, ECS Health &amp; Safety Courses&nbsp;and CSCS Green Labourers Health &amp; Safety in a Construction Environment are available weekly in Dover.<a href="https://mjelectricaltraining.co.uk/exam-venue/safety-passport/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Learn More @ MJ Electrical Training &gt;&gt;</a>Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health &amp; Safety Core DayAre you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health &amp; Safety Core Day, offered by MJ Electrical Training.Why is the ECS Labourer Card Important?The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.Pathways to the ECS Labourer CardMJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:1.&nbsp;Route One: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.2.&nbsp;Route Two: If you do not hold these qualifications, you will need to complete an ECS-approved Health &amp; Safety Course. The SPA Health &amp; Safety Core Day is one of the most accessible and comprehensive options available.SPA Health &amp; Safety Core Day: Your Gateway to ECS Health &amp; Safety ExemptionThe SPA Health &amp; Safety Core Day, offered by MJ Electrical Training for just &pound;174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health &amp; Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.Who Should Take This Course?The SPA Health &amp; Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health &amp; Safety Exemption:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Practising electricians looking to formalise their safety training.</li><li fr-original-style="" style="box-sizing: border-box;">Trainees and apprentices in the electrical industry.</li><li fr-original-style="" style="box-sizing: border-box;">Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.</li></ul>Benefits of the SPA Health &amp; Safety Core Day<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Comprehensive Training: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.</li><li fr-original-style="" style="box-sizing: border-box;">Flexible Learning: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.</li><li fr-original-style="" style="box-sizing: border-box;">Certification: Upon completion, you will receive a certificate that can be used to evidence you meet the H&amp;S requirements for the ECS Labourer Card.</li></ul>Further Opportunities with the ECS Labourer CardObtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Initial Verification (2391-50)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in the Periodic Inspection (2391-51)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Inspection and Testing (2391-52)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)</li></ul>To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&amp;S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">An application by your employer via the ECS Employer Portal.</li><li fr-original-style="" style="box-sizing: border-box;">A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.</li><li fr-original-style="" style="box-sizing: border-box;">Confirmation of your contract duration from an agency if you are working through one.</li><li fr-original-style="" style="box-sizing: border-box;">Documented proof of enrolment in a related electrical course from your educational institution.</li></ul>Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.Verify and Stay UpdatedWhile every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the <a href="https://www.ecscard.org.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">ECS Website</a>. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.ConclusionTaking the SPA Health &amp; Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.Enrol in the SPA Health &amp; Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!&nbsp;

MJ Electrical Training has the largest centre network in the UK, with City & Guilds exams available every week.
Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, ECS Health & Safety Courses and CSCS Green Labourers Health & Safety in a Construction Environment are available weekly in Dover.
Learn More @ MJ Electrical Training >>
Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health & Safety Core Day
Are you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health & Safety Core Day, offered by MJ Electrical Training.
Why is the ECS Labourer Card Important?
The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.
Pathways to the ECS Labourer Card
MJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:
1. Route One: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.
2. Route Two: If you do not hold these qualifications, you will need to complete an ECS-approved Health & Safety Course. The SPA Health & Safety Core Day is one of the most accessible and comprehensive options available.
SPA Health & Safety Core Day: Your Gateway to ECS Health & Safety Exemption
The SPA Health & Safety Core Day, offered by MJ Electrical Training for just £174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health & Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.
Who Should Take This Course?
The SPA Health & Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health & Safety Exemption:
Practising electricians looking to formalise their safety training.
Trainees and apprentices in the electrical industry.
Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.
Benefits of the SPA Health & Safety Core Day
Comprehensive Training: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.
Flexible Learning: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.
Certification: Upon completion, you will receive a certificate that can be used to evidence you meet the H&S requirements for the ECS Labourer Card.
Further Opportunities with the ECS Labourer Card
Obtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:
City & Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)
City & Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)
City & Guilds Level 3 Award in Initial Verification (2391-50)
City & Guilds Level 3 Award in the Periodic Inspection (2391-51)
City & Guilds Level 3 Award in Inspection and Testing (2391-52)
City & Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)
To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:
An application by your employer via the ECS Employer Portal.
A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.
Confirmation of your contract duration from an agency if you are working through one.
Documented proof of enrolment in a related electrical course from your educational institution.
Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.
Verify and Stay Updated
While every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the ECS Website. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.
Conclusion
Taking the SPA Health & Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.
Enrol in the SPA Health & Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!
 

MJ Electrical Training 

Construction Industry Scheme (CIS)

City & Guilds

Health & Safety

Electrical Testing

Wiring Regulations

Electrical Installation

Electrical Inspection & Testing

ECS Health & Safety Course with MJ Electrical Training. Available every week, use this course to complete the application process when applying for an ECS Labourers Card. 

ECS Card Health & Safety Course Liverpool

General Admission

MJ Electrical Training has the largest centre network in the UK, with City &amp; Guilds exams available every week.Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, ECS Health &amp; Safety Courses&nbsp;and CSCS Green Labourers Health &amp; Safety in a Construction Environment are available weekly.<a href="https://mjelectricaltraining.co.uk/exam-venue/safety-passport/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Learn More @ MJ Electrical Training &gt;&gt;</a>Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health &amp; Safety Core DayAre you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health &amp; Safety Core Day, offered by MJ Electrical Training.Why is the ECS Labourer Card Important?The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.Pathways to the ECS Labourer CardMJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:1.&nbsp;Route One: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.2.&nbsp;Route Two: If you do not hold these qualifications, you will need to complete an ECS-approved Health &amp; Safety Course. The SPA Health &amp; Safety Core Day is one of the most accessible and comprehensive options available.SPA Health &amp; Safety Core Day: Your Gateway to ECS Health &amp; Safety ExemptionThe SPA Health &amp; Safety Core Day, offered by MJ Electrical Training for just &pound;174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health &amp; Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.Who Should Take This Course?The SPA Health &amp; Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health &amp; Safety Exemption:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Practising electricians looking to formalise their safety training.</li><li fr-original-style="" style="box-sizing: border-box;">Trainees and apprentices in the electrical industry.</li><li fr-original-style="" style="box-sizing: border-box;">Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.</li></ul>Benefits of the SPA Health &amp; Safety Core Day<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Comprehensive Training: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.</li><li fr-original-style="" style="box-sizing: border-box;">Flexible Learning: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.</li><li fr-original-style="" style="box-sizing: border-box;">Certification: Upon completion, you will receive a certificate that can be used to evidence you meet the H&amp;S requirements for the ECS Labourer Card.</li></ul>Further Opportunities with the ECS Labourer CardObtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Initial Verification (2391-50)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in the Periodic Inspection (2391-51)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Inspection and Testing (2391-52)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)</li></ul>To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&amp;S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">An application by your employer via the ECS Employer Portal.</li><li fr-original-style="" style="box-sizing: border-box;">A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.</li><li fr-original-style="" style="box-sizing: border-box;">Confirmation of your contract duration from an agency if you are working through one.</li><li fr-original-style="" style="box-sizing: border-box;">Documented proof of enrolment in a related electrical course from your educational institution.</li></ul>Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.Verify and Stay UpdatedWhile every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the <a href="https://www.ecscard.org.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">ECS Website</a>. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.ConclusionTaking the SPA Health &amp; Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.Enrol in the SPA Health &amp; Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!&nbsp;

MJ Electrical Training has the largest centre network in the UK, with City & Guilds exams available every week.
Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, ECS Health & Safety Courses and CSCS Green Labourers Health & Safety in a Construction Environment are available weekly.
Learn More @ MJ Electrical Training >>
Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health & Safety Core Day
Are you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health & Safety Core Day, offered by MJ Electrical Training.
Why is the ECS Labourer Card Important?
The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.
Pathways to the ECS Labourer Card
MJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:
1. Route One: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.
2. Route Two: If you do not hold these qualifications, you will need to complete an ECS-approved Health & Safety Course. The SPA Health & Safety Core Day is one of the most accessible and comprehensive options available.
SPA Health & Safety Core Day: Your Gateway to ECS Health & Safety Exemption
The SPA Health & Safety Core Day, offered by MJ Electrical Training for just £174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health & Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.
Who Should Take This Course?
The SPA Health & Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health & Safety Exemption:
Practising electricians looking to formalise their safety training.
Trainees and apprentices in the electrical industry.
Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.
Benefits of the SPA Health & Safety Core Day
Comprehensive Training: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.
Flexible Learning: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.
Certification: Upon completion, you will receive a certificate that can be used to evidence you meet the H&S requirements for the ECS Labourer Card.
Further Opportunities with the ECS Labourer Card
Obtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:
City & Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)
City & Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)
City & Guilds Level 3 Award in Initial Verification (2391-50)
City & Guilds Level 3 Award in the Periodic Inspection (2391-51)
City & Guilds Level 3 Award in Inspection and Testing (2391-52)
City & Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)
To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:
An application by your employer via the ECS Employer Portal.
A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.
Confirmation of your contract duration from an agency if you are working through one.
Documented proof of enrolment in a related electrical course from your educational institution.
Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.
Verify and Stay Updated
While every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the ECS Website. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.
Conclusion
Taking the SPA Health & Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.
Enrol in the SPA Health & Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!
 

ECS Card Health & Safety Course Bromley

ECS Card Health & Safety Course Dover

Bromley

MJ Electrical Training has the largest centre network in the UK, with City &amp; Guilds exams available every week.Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, ECS Health &amp; Safety Courses&nbsp;and CSCS Green Labourers Health &amp; Safety in a Construction Environment are available weekly in Kent.<a href="https://mjelectricaltraining.co.uk/exam-venue/safety-passport/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Learn More @ MJ Electrical Training &gt;&gt;</a>Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health &amp; Safety Core DayAre you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health &amp; Safety Core Day, offered by MJ Electrical Training.Why is the ECS Labourer Card Important?The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.Pathways to the ECS Labourer CardMJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:1.&nbsp;Route One: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.2.&nbsp;Route Two: If you do not hold these qualifications, you will need to complete an ECS-approved Health &amp; Safety Course. The SPA Health &amp; Safety Core Day is one of the most accessible and comprehensive options available.SPA Health &amp; Safety Core Day: Your Gateway to ECS Health &amp; Safety ExemptionThe SPA Health &amp; Safety Core Day, offered by MJ Electrical Training for just &pound;174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health &amp; Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.Who Should Take This Course?The SPA Health &amp; Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health &amp; Safety Exemption:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Practising electricians looking to formalise their safety training.</li><li fr-original-style="" style="box-sizing: border-box;">Trainees and apprentices in the electrical industry.</li><li fr-original-style="" style="box-sizing: border-box;">Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.</li></ul>Benefits of the SPA Health &amp; Safety Core Day<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Comprehensive Training: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.</li><li fr-original-style="" style="box-sizing: border-box;">Flexible Learning: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.</li><li fr-original-style="" style="box-sizing: border-box;">Certification: Upon completion, you will receive a certificate that can be used to evidence you meet the H&amp;S requirements for the ECS Labourer Card.</li></ul>Further Opportunities with the ECS Labourer CardObtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Initial Verification (2391-50)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in the Periodic Inspection (2391-51)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Inspection and Testing (2391-52)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)</li></ul>To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&amp;S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">An application by your employer via the ECS Employer Portal.</li><li fr-original-style="" style="box-sizing: border-box;">A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.</li><li fr-original-style="" style="box-sizing: border-box;">Confirmation of your contract duration from an agency if you are working through one.</li><li fr-original-style="" style="box-sizing: border-box;">Documented proof of enrolment in a related electrical course from your educational institution.</li></ul>Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.Verify and Stay UpdatedWhile every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the <a href="https://www.ecscard.org.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">ECS Website</a>. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.ConclusionTaking the SPA Health &amp; Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.Enrol in the SPA Health &amp; Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!&nbsp;

MJ Electrical Training has the largest centre network in the UK, with City & Guilds exams available every week.
Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, ECS Health & Safety Courses and CSCS Green Labourers Health & Safety in a Construction Environment are available weekly in Kent.
Learn More @ MJ Electrical Training >>
Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health & Safety Core Day
Are you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health & Safety Core Day, offered by MJ Electrical Training.
Why is the ECS Labourer Card Important?
The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.
Pathways to the ECS Labourer Card
MJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:
1. Route One: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.
2. Route Two: If you do not hold these qualifications, you will need to complete an ECS-approved Health & Safety Course. The SPA Health & Safety Core Day is one of the most accessible and comprehensive options available.
SPA Health & Safety Core Day: Your Gateway to ECS Health & Safety Exemption
The SPA Health & Safety Core Day, offered by MJ Electrical Training for just £174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health & Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.
Who Should Take This Course?
The SPA Health & Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health & Safety Exemption:
Practising electricians looking to formalise their safety training.
Trainees and apprentices in the electrical industry.
Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.
Benefits of the SPA Health & Safety Core Day
Comprehensive Training: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.
Flexible Learning: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.
Certification: Upon completion, you will receive a certificate that can be used to evidence you meet the H&S requirements for the ECS Labourer Card.
Further Opportunities with the ECS Labourer Card
Obtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:
City & Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)
City & Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)
City & Guilds Level 3 Award in Initial Verification (2391-50)
City & Guilds Level 3 Award in the Periodic Inspection (2391-51)
City & Guilds Level 3 Award in Inspection and Testing (2391-52)
City & Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)
To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:
An application by your employer via the ECS Employer Portal.
A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.
Confirmation of your contract duration from an agency if you are working through one.
Documented proof of enrolment in a related electrical course from your educational institution.
Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.
Verify and Stay Updated
While every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the ECS Website. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.
Conclusion
Taking the SPA Health & Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.
Enrol in the SPA Health & Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!
 

ECS Card Health & Safety Course Kent

ECS Card Health & Safety Course Newcastle

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 &amp; Risk.The school combines three of our courses:<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> All of the courses are interlinked to give you a full understanding of the subject using Excel. On this course you will&hellip;<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> Who will benefit from this school?<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> Course OutlineDay OneReal Estate Analyst IKnow how to build a property asset cash flow, analyse geared, and un-geared IRRs.<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> Day TwoReal Estate Analyst IIKnow how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.<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> Day ThreeReal Estate Investor I<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> Day FourReal Estate Investor II<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> Day FiveReal Estate Modelling Masterclass<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> Included in the Course<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> 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.comT - 01223 517851W - <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>



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

Real Estate AnalystThe Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results. On this course, you will&hellip;<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Learn how to structure an investment cash flow from first principles and how to value and appraise property investments</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Build annual and quarterly discounted cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Build OPEX and CAPEX into your cash flow</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analyse risk using sensitivity tables and charts</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Employ best practice and find solutions to common modelling problems</li></ul> Who will benefit from this course?<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Surveyors</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Portfolio Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Investment Managers</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Asset Managers</li><li value="6" 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="7" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior 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="8" 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="9" fr-original-style="" style="box-sizing: border-box;">APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.</li></ul> Day OneKnow how to build a property asset cash flow, analyse geared, and un-geared IRRs.<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> Day TwoKnow how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.<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> Included in the Course<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> For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <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>



Real Estate Analyst
The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.
Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results.


On this course, you will…
Learn how to structure an investment cash flow from first principles and how to value and appraise property investments
Build annual and quarterly discounted cash flows
Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry
Build OPEX and CAPEX into your cash flow
Analyse risk using sensitivity tables and charts
Employ best practice and find solutions to common modelling problems


Who will benefit from this course?
Real Estate Investors
Surveyors
Portfolio Analysts
Investment Managers
Asset Managers
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Mid-level to senior 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
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
APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.


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


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

Financial Modelling & Analysis

Financial Modelling

Property & Real Estate Photography

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

Who should attend? DSLs, DDSLs, Headteachers, Pastoral Leads, Safeguarding Governors. Overview Join us for an insightful masterclass that delves into the profound effects of neglect on a child&#39;s life. This session is meticulously designed for professionals working closely with children in various educational settings, providing essential knowledge and practical tools to identify, manage, and seek support for neglected children. Learning Objectives This Masterclass will enable you to:<ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Understand the Lifelong Impact: Gain insights into the long-term consequences of neglect on a child&#39;s development.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Spot the Signs: Learn to recognise the subtle signs and symptoms, including the often overlooked affluent neglect.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Explore Affluent Neglect: Uncover the impactful nature of affluent neglect and its effects on a child&#39;s life.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Combat Disguised Compliance: Grasp the harmful nature of disguised compliance and its implications for a child&#39;s wellbeing.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Apply Knowledge: Equip yourself with practical skills through realistic scenarios and learn how to respond effectively.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Access Support Systems: Discover the use of neglect toolkits to inform your practice and decision-making.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Seek Support for the Child: Learn where and how to access support when dealing with neglect cases.</li></ul><a href="https://www.brightcoreconsultancy.com/brightcore-testimonials" target="_blank" style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); font-weight: bold; text-decoration: none; border-radius: 5px; background-color: rgb(61, 86, 224); border-width: 12px 18px; border-style: solid; border-color: rgb(61, 86, 224); display: inline-block; user-select: auto; box-sizing: border-box; cursor: pointer;" rel="noopener noreferrer" fr-original-style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: #ffffff; font-weight: bold; text-decoration: none; border-radius: 5px; background-color: #3D56E0; border-top: 12px solid #3D56E0; border-bottom: 12px solid #3D56E0; border-right: 18px solid #3D56E0; border-left: 18px solid #3D56E0; display: inline-block;">View all testimonials </a>

Who should attend?
DSLs, DDSLs, Headteachers, Pastoral Leads, Safeguarding Governors.

Overview

Join us for an insightful masterclass that delves into the profound effects of neglect on a child's life. This session is meticulously designed for professionals working closely with children in various educational settings, providing essential knowledge and practical tools to identify, manage, and seek support for neglected children.

Learning Objectives

This Masterclass will enable you to:
Understand the Lifelong Impact: Gain insights into the long-term consequences of neglect on a child's development.
Spot the Signs: Learn to recognise the subtle signs and symptoms, including the often overlooked affluent neglect.
Explore Affluent Neglect: Uncover the impactful nature of affluent neglect and its effects on a child's life.
Combat Disguised Compliance: Grasp the harmful nature of disguised compliance and its implications for a child's wellbeing.
Apply Knowledge: Equip yourself with practical skills through realistic scenarios and learn how to respond effectively.
Access Support Systems: Discover the use of neglect toolkits to inform your practice and decision-making.
Seek Support for the Child: Learn where and how to access support when dealing with neglect cases.
View all testimonials

Brightcore Consultancy

Child Safeguarding

Safeguarding

Join us for an insightful masterclass that delves into the profound effects of neglect on a child's life. This session is meticulously designed for professionals working closely with children in various educational settings, providing essential knowledge and practical tools to identify, manage, and seek support for neglected children.

Neglect: Recognising and Responding to the Impact on Children

Nottingham

London

This masterclass is designed to provide a practical application of the content that is covered within The DEI Playbook including:<ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">A deep dive into the six steps of the DEI framework&nbsp;<ol style="color: initial; box-sizing: border-box;" fr-original-style="color: initial;"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">DEI Strategy</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">Leadership commitment</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">Recruitment and hiring of diverse talent</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">inclusive performance management</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">equitable and inclusive organisational culture</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">marketplace and community impact</li></ol></li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">Measuring DEI using a scorecard</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">ISO audit - how to prepare for and conduct it</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">The success factors of inclusive culture change&nbsp;</li><li id="isPasted" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">Project management techniques and best practice</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">A change communications toolkit</li></ul>Who is this learning for?<ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Diversity and inclusion leads and practitioners</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">HR professionals tasked with diversity and inclusion within their remit</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Managers and leaders looking to develop an inclusive culture</li></ul>What type of learning is this?<ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Small group learning allows lots of time to focus on the &#39;doing&#39; as well as on learning</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Global cohorts so there is a greater opportunity to learn in a cross-cultural context</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Action learning so you can ask questions, engage with others and get feedback in the moment</li><li id="isPasted" style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Facilitated as an in-person event but also available as a virtual offer</li></ul>What will this do for you?You won&rsquo;t have to continue to rely on hope and luck as a strategy to achieve success. We will work on all the aspects that are introduced in The DEI Playbook to:<ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Give you the tools to help you make the most effective decisions</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Show how you can implement changes that are long-lasting</li><li style="color: rgb(80, 168, 188); box-sizing: border-box;" fr-original-style="color: rgb(80, 168, 188);">Provide practical guidance and support x1 individual support and implementation session (more sessions can be added for a bonus fee after the main event)</li></ul>This solution&nbsp;is developed by licensed and accredited practitioners with practical business experience.

On completion, a certificate of attendance will be issued to all participants towards CPD (Continuous Professional Development).

This masterclass is designed to provide a practical application of the content that is covered within The DEI Playbook including:
A deep dive into the six steps of the DEI framework 
DEI Strategy
Leadership commitment
Recruitment and hiring of diverse talent
Inclusive performance management
Equitable and inclusive organisational culture
Marketplace and community impact
Measuring DEI using a scorecard
ISO audit - how to prepare for and conduct it
The success factors of inclusive culture change
A change communications toolkit
Project management techniques and best practice
Who is this learning for?
Diversity and inclusion leads and practitioners
HR professionals tasked with diversity and inclusion within their remit
Managers and leaders looking to develop an inclusive culture
What type of learning is this?
Small group learning allows lots of time to focus on the 'doing' as well as on learning
Global cohorts so there is a greater opportunity to learn in a cross-cultural context
Action learning so you can ask questions, engage with others and get feedback in the moment
Facilitated as an in-person event but also available as a virtual offer
What will this do for you?
You won’t have to continue to rely on hope and luck as a strategy to achieve success. We will work on all the aspects that are introduced in The DEI Playbook to:
Give you the tools to help you make the most effective decisions
Show how you can implement long-lasting changes
Provide practical guidance and support x1 individual support and implementation session (more sessions can be added for a bonus fee after the main event)
This solution is developed by licensed and accredited practitioners with practical business experience.
On completion, a certificate of attendance will be issued to all participants towards CPD (Continuous Professional Development).

Starling

Equity & Diversity

Leadership

Leadership Development

Organizational Development

Diversity & Inclusion

This one day masterclass is designed to provide a practical application of the content that is covered within The DEI Playbook and is aimed at anyone tasked with launching and implementing diversity and inclusion within their organisation. 

DEI Masterclass - Bringing The DEI Playbook To Life!

DEI Masterclass ticket

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

<div id="#">
							<div>
								<h5>Where is the SQL Course?</h5>
							</div>
							<article>
								<div>
								<ul> 
									 <li>Online: Instructor-led.</li>
									 <li>Classroom: Request per email.</li> 
								</ul>
								</div>
							</article>
						</div>
						
					 	<div id="#">
							<div>
								<h5>SQL Course Materials</h5>
							</div>
							<article>
								<div>
								<ul> 
									 <li>SQL Coding Examples </li>
									 <li>SQL Course Manuals and Notes: In-depth reference materials </li>
									 <li>Exercises: 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>
					 	 <li>DAY 1:</li>
						 <li>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

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

							</li><li>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.
							
							
							</li><li>Session 4: 
							 LIMIT / TOP and Distinct Queries 
							 SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count),
							 Group By, 
							 Rollup with Group By, 
							 Having.
							</li>
							<li>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.
							</li>
							 <li>DAY 2:</li>
							<li>Session 6:
							 SQL Subqueries, Nested Subqueries, 
							 Correlated and uncorrelated subqueries. 
							 Global and Local Temp Tables.
							</li>
							<li>Session 7:
							SQL Built-in Functions: Numeric Functions (ABS, SIGN, MOD, etc.)
							 and String Functions (Locate, Left, Right, Concat, etc),
							 DATE and TIME functions.
							</li>
							<li>Session 8:
							SQL Views (Create, alter and drop), 
							 Stored Procedures (Create, alter and drop, Input and Output parameters);
							 Custom Functions (Create, alter and drop).
							</li>
							 <li>DAY 3:</li>
							<li>
							Session 9: Managing Data
							 Inserting rows, Replacing rows, Updating rows, Deleting rows,
 							The truncate statement, 
 The COMMIT and ROLLBACK commands, Savepoints, Implicit commits.
							</li>
							<li>
							Session 10:
							SQL Indexes (Create, alter and drop).
							</li>
							<li>
							Session 11:
							 Creating Databases and Tables (Create, alter and drop); Constraints (Add, alter and drop).
							</li>
							<li>
							Session 12:
							 Import data into SQL and Export from SQL.
							 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. 

1002 Sup courses in Leicester

NPORS Vehicle Marshal (N403)

By Dynamic Training and Assessments Ltd

NPORS Manual Handling (N704)

By Dynamic Training and Assessments Ltd

NPORS Remote Control Tower Crane (N115)

By Dynamic Training and Assessments Ltd

NPORS Overhead Crane (N104)

By Dynamic Training and Assessments Ltd

NPORS Plant Machinery Marshal (N133)

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 Excavation Marshall - Banksperson (N027)

By Dynamic Training and Assessments Ltd

NPORS Compact Crane (N140)

By Dynamic Training and Assessments Ltd

Search By Location