Nottinghamshire

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

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

Dynamic Training and Assessments Ltd

Construction

CSCS (Construction Skills Certification Scheme)

NPORS

NPORS Forward Tipping Dumper (N204)

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

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

NPORS Road Roller (N214)

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

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

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

NPORS Rear Tipping Dumper (N205)

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

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

NPORS Forward Tipping Mini Dumper (N139)

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

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

NPORS Skidsteer Loader (N212)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);">Who Should Attend</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge and practical skills to work around piling rigs, using ancillary equipment and placing positioning piling rigs to from piles. This course can be completed by both novice and experienced candidates. We also offer refresher tests.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course- 5 days</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests- 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Course information</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Category N022 Piling Rig Attendant</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:<br fr-original-style="" style="box-sizing: border-box;">➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a piling rig attendant<br fr-original-style="" style="box-sizing: border-box;">➢ Have a working knowledge of the piling rig to be attended<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify the major components of the piling rig and explain their<br fr-original-style="" style="box-sizing: border-box;">functions<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify ancillary equipment and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Assist in conducting pre-operational checks in accordance with manufacturer&rsquo;s and legislative requirements<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct safety checks of the work area and agree hand signals and verbal commands<br fr-original-style="" style="box-sizing: border-box;">➢ Identify and maintain PPE appropriate for piling rig attendant<br fr-original-style="" style="box-sizing: border-box;">➢ Assist in rigging-up and prepare ancillary equipment for piling operations<br fr-original-style="" style="box-sizing: border-box;">➢ Guide and position rig on to the piling position and start piling process.<br fr-original-style="" style="box-sizing: border-box;">➢ Environmental considerations<br fr-original-style="" style="box-sizing: border-box;">➢ Assist in de-rigging and end of shift and shut down procedures<br fr-original-style="" style="box-sizing: border-box;">➢ Demonstrate knowledge and understanding of assisting in the loading and unloading procedures for piling rig transportation</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment will be to NPORS standards consisting of a theory test and practical test.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Certification</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS Traditional card &ndash; With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.</p>

Who Should Attend
This course is aimed at candidates that require the knowledge and practical skills to work around piling rigs, using ancillary equipment and placing positioning piling rigs to from piles. This course can be completed by both novice and experienced candidates. We also offer refresher tests.
Novice course- 5 days
Experienced worker tests- 1 day theory and practical assessment
Course information
Category N022 Piling Rig Attendant
It is envisaged that by the end of this course of training the learner will be able to answer questions on and perform the following:
➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a piling rig attendant
➢ Have a working knowledge of the piling rig to be attended
➢ Be able to locate and identify the major components of the piling rig and explain their
functions
➢ Be able to locate and identify ancillary equipment and explain their functions
➢ Assist in conducting pre-operational checks in accordance with manufacturer’s and legislative requirements
➢ Conduct safety checks of the work area and agree hand signals and verbal commands
➢ Identify and maintain PPE appropriate for piling rig attendant
➢ Assist in rigging-up and prepare ancillary equipment for piling operations
➢ Guide and position rig on to the piling position and start piling process.
➢ Environmental considerations
➢ Assist in de-rigging and end of shift and shut down procedures
➢ Demonstrate knowledge and understanding of assisting in the loading and unloading procedures for piling rig transportation
Assessment
Assessment will be to NPORS standards consisting of a theory test and practical test.
Certification
NPORS Traditional card – With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.
NPORS CSCS – To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.

NPORS Piling Rig Attendant (N022)

<section data-id="759599e" data-element_type="section" style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);"><div data-id="7c99983" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="68be7ec" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(16, 16, 16); box-sizing: border-box;" fr-original-style=" color: rgb(16, 16, 16);"><u fr-original-style="" style="box-sizing: border-box;">Course Summary</u></h3></div><div data-id="f4ce741" data-element_type="widget" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This NPORS course is designed for delegates with existing MEWP knowledge. It will enable them to understand the role and responsibilities of a MEWP Supervisor.</p></div></div></section><section data-id="02af24e" data-element_type="section" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><div data-id="4ac5a39" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="ed5d6d4" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(16, 16, 16); box-sizing: border-box;" fr-original-style=" color: rgb(16, 16, 16);"><u fr-original-style="" style="box-sizing: border-box;">Course Objectives</u></h3></div><div data-id="c13d14c" data-element_type="widget" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By the end of this course delegates should be able to answer and perform the following:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of working at height equipment, the dangers of working at height, selection of work equipment, procedures to work safely within the environment</li><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of a supervisor&rsquo;s responsibilities and relevant legislation, policies and procedures including, relevant risk assessments, method statements and traffic management systems</li><li fr-original-style="" style="box-sizing: border-box;">Be able to supervise the work safely and identify various hazards including dangers of working from a height and emergency rescue procedures</li><li fr-original-style="" style="box-sizing: border-box;">Have an underpinning knowledge of the manufacturer&rsquo;s manual/handbook for the equipment</li><li fr-original-style="" style="box-sizing: border-box;">Be able to check certification for equipment and accessories including PPE</li><li fr-original-style="" style="box-sizing: border-box;">Correctly risk assess the task and implement a safe system of work, prepare a step-by-step method statement including selection of equipment to be used</li><li fr-original-style="" style="box-sizing: border-box;">Allocate team roles and responsibilities through a toolbox talk/safety briefing</li><li fr-original-style="" style="box-sizing: border-box;">Oversee task ensuring the team safely follows the step-by-step system of work</li><li fr-original-style="" style="box-sizing: border-box;">Liaise with management and operators</li><li fr-original-style="" style="box-sizing: border-box;">Deliver a debrief meeting with the team and discuss any lessons learned during specific task</li></ul></div></div></section><section data-id="95da9fc" data-element_type="section" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><div data-id="74087ea" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="0c1e79d" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(16, 16, 16); box-sizing: border-box;" fr-original-style=" color: rgb(16, 16, 16);"><u fr-original-style="" style="box-sizing: border-box;">Maximum number of learners</u></h3></div><div data-id="36ef989" data-element_type="widget" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">6</p></div></div></section><section data-id="215d7e9" data-element_type="section" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><div data-id="d20cfef" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="c4a6726" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(16, 16, 16); box-sizing: border-box;" fr-original-style=" color: rgb(16, 16, 16);"><u fr-original-style="" style="box-sizing: border-box;">Duration</u></h3></div><div data-id="aff4957" data-element_type="widget" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1 day</p></div></div></section><section data-id="79d6b9a" data-element_type="section" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><div data-id="804bcdf" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="83732ef" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(16, 16, 16); box-sizing: border-box;" fr-original-style=" color: rgb(16, 16, 16);"><u fr-original-style="" style="box-sizing: border-box;">Assessment</u></h3></div><div data-id="e44539c" data-element_type="widget" data-widget_type="text-editor.default" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Theory question paper.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Practical assessment.</p></div></div></section>

Course Summary
This NPORS course is designed for delegates with existing MEWP knowledge. It will enable them to understand the role and responsibilities of a MEWP Supervisor.
Course Objectives
By the end of this course delegates should be able to answer and perform the following:
Have a basic understanding of working at height equipment, the dangers of working at height, selection of work equipment, procedures to work safely within the environment
Have a basic understanding of a supervisor’s responsibilities and relevant legislation, policies and procedures including, relevant risk assessments, method statements and traffic management systems
Be able to supervise the work safely and identify various hazards including dangers of working from a height and emergency rescue procedures
Have an underpinning knowledge of the manufacturer’s manual/handbook for the equipment
Be able to check certification for equipment and accessories including PPE
Correctly risk assess the task and implement a safe system of work, prepare a step-by-step method statement including selection of equipment to be used
Allocate team roles and responsibilities through a toolbox talk/safety briefing
Oversee task ensuring the team safely follows the step-by-step system of work
Liaise with management and operators
Deliver a debrief meeting with the team and discuss any lessons learned during specific task
Maximum number of learners
6
Duration
1 day
Assessment
Theory question paper.
Practical assessment.

NPORS MEWP Supervisor Awareness (N035)

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

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

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

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);">Who Should Attend</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge and practical skills to use suction excavators to excavate ground where utilities services are located. This course can be completed by both novice and experienced candidates. We also offer refresher tests.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course- 5 days</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests- 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Course information</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Category N021 Suction Excavator</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">It is envisaged that by the end of this course of training the trainee operator will be able to answer questions on and perform the following:<br fr-original-style="" style="box-sizing: border-box;">➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a suction excavator operator<br fr-original-style="" style="box-sizing: border-box;">➢ Have a working knowledge of the manufacturer&rsquo;s handbook for the particular suction excavator to be used<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to locate and identify the major components of the machine and explain their functions<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative requirements<br fr-original-style="" style="box-sizing: border-box;">➢ Identify and maintain PPE appropriate for suction excavator use<br fr-original-style="" style="box-sizing: border-box;">➢ Explain the different types of suction excavators their advantages and disadvantages when excavating material<br fr-original-style="" style="box-sizing: border-box;">➢ Safely mount and dismount the machine<br fr-original-style="" style="box-sizing: border-box;">➢ Start and stop the engine, compressor and suction hoses safely and efficiently<br fr-original-style="" style="box-sizing: border-box;">➢ Be able to demonstrate how to safely and efficiently use the remote control<br fr-original-style="" style="box-sizing: border-box;">➢ Configure the machine for travel and manoeuvre it safely to the work position in open and confined areas<br fr-original-style="" style="box-sizing: border-box;">➢ Conduct all necessary safety checks at the work area<br fr-original-style="" style="box-sizing: border-box;">➢ Manoeuvre the machine to the work area and correctly configure in readiness to carry out<br fr-original-style="" style="box-sizing: border-box;">excavating tasks<br fr-original-style="" style="box-sizing: border-box;">➢ Demonstrate an emergency stop explaining all relevant safety precautions<br fr-original-style="" style="box-sizing: border-box;">➢ Carry out excavating tasks<br fr-original-style="" style="box-sizing: border-box;">➢ Fit and remove different attachments<br fr-original-style="" style="box-sizing: border-box;">➢ Explain and demonstrate how to deposit material from the suction excavator safely and efficiently<br fr-original-style="" style="box-sizing: border-box;">➢ Environmental considerations<br fr-original-style="" style="box-sizing: border-box;">➢ Carry out all end of shift and shut down procedures</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Assessment will be to NPORS standards consisting of a theory test and practical test.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Certification</h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS Traditional card &ndash; With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.</p>

Who Should Attend
This course is aimed at candidates that require the knowledge and practical skills to use suction excavators to excavate ground where utilities services are located. This course can be completed by both novice and experienced candidates. We also offer refresher tests.
Novice course- 5 days
Experienced worker tests- 1 day theory and practical assessment
Course information
Category N021 Suction Excavator
It is envisaged that by the end of this course of training the trainee operator will be able to answer questions on and perform the following:
➢ Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a suction excavator operator
➢ Have a working knowledge of the manufacturer’s handbook for the particular suction excavator to be used
➢ Be able to locate and identify the major components of the machine and explain their functions
➢ Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
➢ Identify and maintain PPE appropriate for suction excavator use
➢ Explain the different types of suction excavators their advantages and disadvantages when excavating material
➢ Safely mount and dismount the machine
➢ Start and stop the engine, compressor and suction hoses safely and efficiently
➢ Be able to demonstrate how to safely and efficiently use the remote control
➢ Configure the machine for travel and manoeuvre it safely to the work position in open and confined areas
➢ Conduct all necessary safety checks at the work area
➢ Manoeuvre the machine to the work area and correctly configure in readiness to carry out
excavating tasks
➢ Demonstrate an emergency stop explaining all relevant safety precautions
➢ Carry out excavating tasks
➢ Fit and remove different attachments
➢ Explain and demonstrate how to deposit material from the suction excavator safely and efficiently
➢ Environmental considerations
➢ Carry out all end of shift and shut down procedures
Assessment
Assessment will be to NPORS standards consisting of a theory test and practical test.
Certification
NPORS Traditional card – With the traditional card there is no requirements to complete an NVQ, a five year card is issued and after five years reassessment is required.
NPORS CSCS – To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card the candidate will be required to complete an NVQ in the specific item of plant.

NPORS Suction Excavator (N021)

<div style="color: rgb(0, 48, 87); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 48, 87);"><h2 style="color: rgb(0, 48, 87); box-sizing: border-box;" fr-original-style=" color: rgb(0, 48, 87);">Overview</h2></div><div style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">This course will give you foundation training and assessment in operating and maintaining Marine Knuckle Boom Cranes and is suitable if you have received no formal instruction or, if you wish to refresh your skills, we offer a short duration course.<br fr-original-style="" style="box-sizing: border-box;">&nbsp;</p></div><div style="color: rgb(0, 48, 87); box-sizing: border-box;" fr-original-style=" color: rgb(0, 48, 87);"><h2 style="color: rgb(0, 48, 87); box-sizing: border-box;" fr-original-style=" color: rgb(0, 48, 87);">Learning outcomes</h2></div><div style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">By the end of this training course, the learner will be able to answer questions on and perform the following:</p><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Have a basic understanding of offshore crane lifting operations, the dangers of working in the industry and their responsibilities as an operator&nbsp;</li></ul><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used&nbsp;</li></ul><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Be able to interpret the requirements of the lift plan and risk assessment&nbsp;</li></ul><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Be able to locate and identify the major components of the machine and explain their functions&nbsp;</li></ul><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Be able to locate and identify key controls and explain their functions&nbsp;</li></ul><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Set up exclusion zone explaining actions required for emergency actions and identify any hazards&nbsp;</li></ul><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Identify and maintain PPE appropriate for knuckle boom crane use&nbsp;</li></ul><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Conduct all pre-operational and running checks in accordance with manufacturer&rsquo;s and legislative requirements&nbsp;</li></ul><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Identify and inspect suitability of landing area&nbsp;</li></ul><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Prepare the knuckle boom crane for lifting duties as well as over side lifts.&nbsp;</li><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Operate machinery safely and efficiently taking into consideration sea uplift and moving vessel decks&nbsp;</li></ul><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Environmental considerations&nbsp;</li></ul><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Carry out all end of work and shut down procedures.&nbsp;</li></ul><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">&nbsp;</p></div><div style="color: rgb(0, 48, 87); box-sizing: border-box;" fr-original-style=" color: rgb(0, 48, 87);"><h2 style="color: rgb(0, 48, 87); box-sizing: border-box;" fr-original-style=" color: rgb(0, 48, 87);">Assessment</h2></div><div style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">The course is delivered through a combination of practical&#39;s and classroom-based tutorials. You will be assessed through theory and practical tests.</p><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">&nbsp;</p></div><div style="color: rgb(0, 48, 87); box-sizing: border-box;" fr-original-style=" color: rgb(0, 48, 87);"><h2 style="color: rgb(0, 48, 87); box-sizing: border-box;" fr-original-style=" color: rgb(0, 48, 87);">Entry requirements</h2></div><div style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">You must have a good understanding of spoken and written English. Please contact us if you have any concerns in this area.</p><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">If you require your NPORS Operator Card to include the CSCS logo, you must have passed a CITB Health, Safety and Environment (HS&amp;E) test no more than two years before attending this course.</p></div>

Overview
This course will give you foundation training and assessment in operating and maintaining Marine Knuckle Boom Cranes and is suitable if you have received no formal instruction or, if you wish to refresh your skills, we offer a short duration course.
 
Learning outcomes
By the end of this training course, the learner will be able to answer questions on and perform the following:
Have a basic understanding of offshore crane lifting operations, 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 interpret the requirements of the lift plan and risk assessment
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 explaining actions required for emergency actions and identify any hazards
Identify and maintain PPE appropriate for knuckle boom crane use
Conduct all pre-operational and running checks in accordance with manufacturer’s and legislative requirements
Identify and inspect suitability of landing area
Prepare the knuckle boom crane for lifting duties as well as over side lifts.
Operate machinery safely and efficiently taking into consideration sea uplift and moving vessel decks
Environmental considerations
Carry out all end of work and shut down procedures.
 
Assessment
The course is delivered through a combination of practical's and classroom-based tutorials. You will be assessed through theory and practical tests.
 
Entry requirements
You must have a good understanding of spoken and written English. Please contact us if you have any concerns in this area.
If you require your NPORS Operator Card to include the CSCS logo, you must have passed a CITB Health, Safety and Environment (HS&E) test no more than two years before attending this course.

NPORS Marine Knuckle Boom Crane (N014)

This 1-day Driver CPC Periodic Training course focuses on critical areas of Emergency Aid and Security for professional drivers. Designed to meet Driver CPC requirements, this course equips drivers with essential skills for handling emergency situations and enhancing security awareness on the road.
Who Should Attend:
This course is ideal for all professional drivers required to complete Driver CPC Periodic Training to maintain their Driver CPC Licence. It’s tailored to both experienced drivers and those new to the field, providing relevant, up-to-date skills and knowledge.
Learning Objectives:
The aim of this course is to confirm and expand on each driver’s current knowledge and skills, ensuring they are informed about the latest legislation, best practices, and critical safety procedures. This training is designed to enhance drivers’ confidence and preparedness in managing emergencies and maintaining security awareness, helping them navigate the responsibilities of their role effectively.

Course Format: Online 

Join us to reinforce your skills, stay compliant, and improve your on-road safety practices!

Total Compliance 

Driver CPC - 1 Day Periodic 7 Hour Course - Security Training & Emergency Aid

General Admission

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is intended for people who use PowerPoint for their business communication needs.</p>Overview<p>To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to open and close applications, navigate basic file structures, and manage files and folders.</p><p>This course is intended for those who wish to take advantage of the application for high quality business presentations and reports.</p></div><div id="course-pills-2"><h4>Presentations</h4><ul><li>Create Attractive Presentations from Existing PowerPoint Templates</li><li>Creating Presentations Quickly using Outline to build a Structure</li><li>Incorporating and reusing slides from other presentations into your own</li></ul><h4>Templates and Customization</h4><ul><li>Using Slide Layouts</li><li>Using the Slide Master</li><li>Creating Custom Slide Layout</li></ul><h4>Working with Charts and Tables</h4><ul><li>Create and Modify Tables</li><li>Create Charts and Graphs</li><li>Copying Charts into PowerPoint</li><li>Link Vs Embed</li></ul><h4>Add Visual Elements to a Presentation</h4><ul><li>Create and Modify Shapes </li><li>Add Images </li><li>Create SmartArt to Make Easily Modifiable graphics </li><li>Use SmartArt to Give Dull Text a More Visual Appeal</li></ul><h4>Working with Media and Animation</h4><ul><li>Add Audio to A Presentation</li><li>Add Video to A Presentation</li><li>Add and Customize Animations</li><li>Add and Customize Transitions</li></ul><h4>Preparing to Present</h4><ul><li>Add Notes to A Presentation</li><li>Presenter View And Slide Show Controls</li><li>Create A Custom Slide Show </li><li>Saving and Sharing the Presentation </li><li>Printing Options and Handouts</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Microsoft PowerPoint for the Business User training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Microsoft PowerPoint for the Business User course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Duration
1 Days
6 CPD hours
This course is intended for
This course is intended for people who use PowerPoint for their business communication needs.
Overview
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to open and close applications, navigate basic file structures, and manage files and folders.
This course is intended for those who wish to take advantage of the application for high quality business presentations and reports.
Presentations
Create Attractive Presentations from Existing PowerPoint Templates
Creating Presentations Quickly using Outline to build a Structure
Incorporating and reusing slides from other presentations into your own
Templates and Customization
Using Slide Layouts
Using the Slide Master
Creating Custom Slide Layout
Working with Charts and Tables
Create and Modify Tables
Create Charts and Graphs
Copying Charts into PowerPoint
Link Vs Embed
Add Visual Elements to a Presentation
Create and Modify Shapes
Add Images
Create SmartArt to Make Easily Modifiable graphics
Use SmartArt to Give Dull Text a More Visual Appeal
Working with Media and Animation
Add Audio to A Presentation
Add Video to A Presentation
Add and Customize Animations
Add and Customize Transitions
Preparing to Present
Add Notes to A Presentation
Presenter View And Slide Show Controls
Create A Custom Slide Show
Saving and Sharing the Presentation
Printing Options and Handouts
Additional course details:
Nexus Humans Microsoft PowerPoint for the Business User training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. 

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

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

While we feel this is the best course for the Microsoft PowerPoint for the Business User course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

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


Nexus Human

Executive Presentation

Office Skills & Productivity

Microsoft Power Platform

Professional Skills Course (PSC)

Microsoft Powerpoint

Presentation Skills

Microsoft PowerPoint for the Business User

London

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

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

<div>
	  <div>
		 <h5>Learn SQL Course, 1-Day</h5>
	  </div>
	  <div></div>
	  <p> With SQL Queries, you could learn SQL in a day, and master the basics of SQL, get interesting, insightful and essential business intelligence from data by using SQL queries on this SQL Course London, UK. 
	  <br />Queries are made easy and simple, saving hours of online training.
 
		<br />This 1 Day course is packed with power query techniques.

<br /><br />This SQL Introduction Course is hands-on, practical with many excellent query examples.
<br /><br />This course is Platform Independent.
<br /><br />This SQL course is hands-on and practical, to give you in-depth, practical experience of the topics covered.
<br /><br />Ask your SQL questions in small, friendly classroom SQL Course. 
<br /><br />Online, Instructor-led, Interactive, full screen sharing.

	  </p>
	<div>
	<h5> Learn SQL Relational Database Concepts:</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Database:</strong>  
					<br />What is a Relational Database?
<br />Tables, Rows and Columns
<br />Indexes, Primary Keys and Foreign Keys
<br />Data Types  
					</p> 
			 
				 
			</div>
	<div>
	<h5>Learn SQL Essentials:</h5>
	</div> <div></div>
	<div> 
				<p> <strong>Basics.</strong>
					<br />SQL Language Essentials:
<br />The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values
<br />SQL Arithmetic Operations, Expression Queries
<br />SQL Column Aliases
<br />Limit/Top, Distinct

				 
				</p>
			</div>
	<div>
	<h5>Summarizing and Grouping Data:</h5>
	</div> <div></div>
	<div> 
				<p>  <strong>Group by</strong>
				<br />
Aggregate Functions (Sum, Avg, Count, Max, Min)
<br />The Group By Clause
<br />The Having Clause
				 
				</p>
			</div>
	<div>
	<h5>Querying Multiple Tables:</h5>
	</div> <div></div>
	<div>
				<p>   <strong>Joins</strong>
					<br />
Joining Tables
<br />Inner Joins, Outer Joins, Self Joins, Full Joins, 
<br />Cross Joins
<br />Alternative Join Syntax
				</p>
			</div>

	 
	
	 
	<div>
	<h5>Basic Subqueries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Sub-queries</strong>
			<br />Basics of CTE tables
			<br />SQL subqueries 
			<br />Using subqueries in the from clause
			<br />Using subqueries in the where clause
			<br />Using subqueries in the select clause
			<br />Using subqueries in the having clause 
			
		</p>
	</div>
	<div>
	<h5>Combine Queries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Combine Queries</strong>
			<br />The Union Operator
			<br /> Intersect and Minus Operators
			<br /> Simulating combine Intersect and Minus queries by using sub-queries
					   

			 

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

<div>   

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

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




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

Learn SQL Course, 1-Day
This SQL course is platform independent.
SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
Join us on your booked dates on https://meet.goto.com/910697125
Learn SQL Course, 1-Day Online Instructor-led
With SQL Queries, you could learn SQL in a day, and master the basics of SQL, and get interesting, insightful, and essential business intelligence from data by using SQL queries on this SQL Course in London, UK. 
Queries are made easy and simple, saving hours of online training. 
This 1 Day course is packed with power query techniques. 

This SQL Introduction Course is hands-on, practical with many excellent query examples.
This SQL course is hands-on and practical to give you in-depth, practical experience of the topics covered.
Ask your SQL questions in a small, friendly classroom SQL course. 

Learn SQL. Relational Database Concepts:
 Database: 
What is a Relational Database?

Tables, Rows and Columns

Indexes, Primary Keys and Foreign Keys

Data Types 
Learn SQL Essentials:
 Basics. 
SQL Language Essentials:

The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values

SQL Arithmetic Operations, Expression Queries

SQL Column Aliases

Limit/Top, Distinct 
Summarizing and Grouping Data:
 Group by 

Aggregate Functions (Sum, Avg, Count, Max, Min)

The Group By Clause

The Having Clause 
Querying Multiple Tables:
 Joins 

Joining Tables

Inner Joins, Outer Joins, Self Joins, Full Joins, 
Cross Joins

Alternative Join Syntax 
Basic Subqueries
 Sub-queries 
Basics of CTE tables 
SQL subqueries 
Using subqueries in the from clause 
Using subqueries in the where clause 
Using subqueries in the select clause 
Using subqueries in the having clause 
 
 Combine Queries 
The Union Operator 
 Intersect and Minus Operators 
 Simulating combined Intersect and Minus queries by using sub-queries 

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



PCWorkshops

Online Course Creation

Database Programming

IT Skills

Data Skills

SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 

Learn SQL Basics, 1-day Course, Online Instructor-Led

General admission

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The colour energies are the essential building blocks of team and personal effectiveness, they develop the vital self awareness that makes flexibility possible.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Being flexible is the key to building effective and productive relationships.&nbsp; Adapting your style to connect with the style of your customer will lead to greater rapport.&nbsp; With rapport you can begin to influence your customer.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This virtual workshop has been designed for any group of people who want to learn how to build rapport quickly with lots of customers and other key stakeholders.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our Building Influence &amp; Selling Skills Workshop is an interactive, informative and fun way to begin this journey. We focus on behaviours rather than personality and provide a common language that helps individuals identify how to flex their style and create stronger connections.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">How will your team benefit from this workshop? They will:</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✔ &nbsp; &nbsp;Understand individual strengths and potential development needs in this area</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✔ &nbsp; &nbsp;Explore effective sales and influencing techniques for different audiences</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✔ &nbsp; &nbsp;Optimise communication with stakeholders</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✔ &nbsp; &nbsp;Consider how body language as well as written and verbal communication styles can influence this area</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✔ &nbsp; &nbsp;Understand different clients&#39; drivers and blockers</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✔ &nbsp; &nbsp;Learn ways to practically apply these concepts to current situations and clients</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We have worked with thousands of teams and individuals, which statement best describes your team:</p><ul style="list-style-type: disc; box-sizing: border-box;" fr-original-style="list-style-type: disc;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Inexperienced</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Want to develop pitching &amp; presenting skills</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Not hitting targets</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Looking to improve results</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Would benefit from sales skills development</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Influencing others regularly</li></ul><p id="isPasted" style="text-align: left; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: left;">Take advantage of our add-on offers at the checkout and enhance your experience on this workshop.&nbsp; Buy a set of <a href="https://colour-energies.com/colour-energies-building-blocks/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Colour Energies Building Blocks</a> and/or a <a href="https://colour-energies.com/colour-energies-card-game/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Colour Energies Card Game</a> and see how easily you can embed the colour energies in your team.</p><p id="isPasted" style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Act Now! Contact us to bring the world of the colour energies to your team and experience the benefit of a common language that will drive your performance to a higher level.</strong></p><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><a href="https://colour-energies.com/" 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;">Get in touch</a></p>

The colour energies are the essential building blocks of team and personal effectiveness, they develop the vital self awareness that makes flexibility possible.
Being flexible is the key to building effective and productive relationships. Adapting your style to connect with the style of your customer will lead to greater rapport. With rapport you can begin to influence your customer.
This virtual workshop has been designed for any group of people who want to learn how to build rapport quickly with lots of customers and other key stakeholders.
Our Building Influence & Selling Skills Workshop is an interactive, informative and fun way to begin this journey. We focus on behaviours rather than personality and provide a common language that helps individuals identify how to flex their style and create stronger connections.
How will your team benefit from this workshop? They will:
✔ Understand individual strengths and potential development needs in this area
✔ Explore effective sales and influencing techniques for different audiences
✔ Optimise communication with stakeholders
✔ Consider how body language as well as written and verbal communication styles can influence this area
✔ Understand different clients' drivers and blockers
✔ Learn ways to practically apply these concepts to current situations and clients
We have worked with thousands of teams and individuals, which statement best describes your team:
Inexperienced
Want to develop pitching & presenting skills
Not hitting targets
Looking to improve results
Would benefit from sales skills development
Influencing others regularly
Take advantage of our add-on offers at the checkout and enhance your experience on this workshop. Buy a set of Colour Energies Building Blocks and/or a Colour Energies Card Game and see how easily you can embed the colour energies in your team.
Act Now! Contact us to bring the world of the colour energies to your team and experience the benefit of a common language that will drive your performance to a higher level.
Get in touch

colour-energies.com

Disc

Team Building

Professional Selling Skills (PSS)

Business Leadership

Relationship Building

Insights

Influence Skills

Insights Discovery

Communication Skills

The four colour energies will give you the insights to transform your teams ability to influence customers and tailor their approach to different customers preferences.  By building deep rapport and creating trust your customers will strengthen their bond with your organisation.  Watch as your sales and profits exceed your expectations.

The 4 Colour Energies - Building Influence & Selling Skills

Book by the 10th October for 20% discount

Early Bird Offer

Buy a place and get a second place for 50% discount

Buy One place get a second half price

<div style="color: rgb(36, 39, 41); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(36, 39, 41);">The theory assessment provides delegates with the essential knowledge to select, monitor, manage and plan the correct use of Harnesses and lanyards for use in a MEWP.</div><div style="color: rgb(36, 39, 41); box-sizing: border-box;" fr-original-style=" color: rgb(36, 39, 41);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(36, 39, 41); box-sizing: border-box;" fr-original-style=" color: rgb(36, 39, 41);">Delegates successfully completing the e-learning will:<br fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Have an awareness of how to correctly identify and select the appropriate form of personal<br fr-original-style="" style="box-sizing: border-box;">protection against falls from MEWPs.</li><li fr-original-style="" style="box-sizing: border-box;">Have a theoretical awareness only of how to check, use, maintain and store a harness and<br fr-original-style="" style="box-sizing: border-box;">lanyard with manufacturer&rsquo;s instructions.</li><li fr-original-style="" style="box-sizing: border-box;">Have a theoretical awareness of how harnesses and lanyards should be fitted and adjusted.</li></ul></div>

The theory assessment provides delegates with the essential knowledge to select, monitor, manage and plan the correct use of Harnesses and lanyards for use in a MEWP.
Delegates successfully completing the e-learning will:
Have an awareness of how to correctly identify and select the appropriate form of personal
protection against falls from MEWPs.
Have a theoretical awareness only of how to check, use, maintain and store a harness and
lanyard with manufacturer’s instructions.
Have a theoretical awareness of how harnesses and lanyards should be fitted and adjusted.

Kingfisher Access

The theory assessment provides delegates with the essential knowledge to select, monitor, manage and plan the correct use of Harnesses and lanyards for use in a MEWP.

Delegates successfully completing the e-learning will:
Have an awareness of how to correctly identify and select the appropriate form of personal
protection against falls from MEWPs.
Have a theoretical awareness only of how to check, use, maintain and store a harness and
lanyard with manufacturer’s instructions.
Have a theoretical awareness of how harnesses and lanyards should be fitted and adjusted.

IPAF - Harness Awareness 

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This 4 week online Course is suitable for complete beginners and improvers who would like to learn to paint in Watercolour.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">Each session is 40 minutes live on Tuesday evening and start at 7.00-7.40pm Via Zoom<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">On this Course you will:<br fr-original-style="" style="box-sizing: border-box;">* learn to prepare your water colour paints and mix colours.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* learn a variety of watercolour techniques including, washes, wet in wet, graded, dry brush Flat Wash, Loose watercolour see photos, we will cover a variety of subjects.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* will be taught live by your tutor online via zoom with step- by -step demonstrations and clear explanations of the various stages.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* Learners will then carry the various tasks alongside the tutor who will be at hand for any questions that you may have.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">This is a 4 week course offered live online via zoom this course rolls on and new dates will be added.</p>
<h2 fr-original-style="" style="box-sizing: border-box;">What&#39;s included in the price?</h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Online Tuition<br fr-original-style="" style="box-sizing: border-box;">Step by step Demonstrations via Zoom in the live class<br fr-original-style="" style="box-sizing: border-box;">Clear explanation from your Tutor<br fr-original-style="" style="box-sizing: border-box;">reference handouts sent via email</p>
<h2 fr-original-style="" style="box-sizing: border-box;">What you will need</h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Starter Kit Available from Tutor - Please email for details<br fr-original-style="" style="box-sizing: border-box;">Watercolour paints - tubes or pans<br fr-original-style="" style="box-sizing: border-box;">Watercolour paper ( Cold Pressed 300 gsm 140lb)<br fr-original-style="" style="box-sizing: border-box;">Round watercolour brushes- size 4 and 6 ( or similar)<br fr-original-style="" style="box-sizing: border-box;">HB graphite pencil to draw image<br fr-original-style="" style="box-sizing: border-box;">Eraser<br fr-original-style="" style="box-sizing: border-box;">Mixing Palette<br fr-original-style="" style="box-sizing: border-box;">2 x jars of clean water<br fr-original-style="" style="box-sizing: border-box;">Kitchen paper<br fr-original-style="" style="box-sizing: border-box;">Hairdryer<br fr-original-style="" style="box-sizing: border-box;">Sketchbook<br fr-original-style="" style="box-sizing: border-box;">Tracing paper</p>
<h2 fr-original-style="" style="box-sizing: border-box;">Suitable for</h2>
<ul fr-original-style="" fr-original-class="fa-ul course-checklists" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Adults</li>
<li fr-original-style="" style="box-sizing: border-box;">Engagement, birthdays &amp; anniversaries</li>
<li fr-original-style="" style="box-sizing: border-box;">Intermediate level</li>
<li fr-original-style="" style="box-sizing: border-box;">Seniors</li>
<li fr-original-style="" style="box-sizing: border-box;">Suitable for beginners</li>
<li fr-original-style="" style="box-sizing: border-box;">Teenagers</li>
<li fr-original-style="" style="box-sizing: border-box;">Wheelchair users</li>
</ul>

This 4 week online Course is suitable for complete beginners and improvers who would like to learn to paint in Watercolour.

Each session is 40 minutes live on Tuesday evening and start at 7.00-7.40pm Via Zoom

On this Course you will:
* learn to prepare your water colour paints and mix colours.

* learn a variety of watercolour techniques including, washes, wet in wet, graded, dry brush Flat Wash, Loose watercolour see photos, we will cover a variety of subjects.

* will be taught live by your tutor online via zoom with step- by -step demonstrations and clear explanations of the various stages.

* Learners will then carry the various tasks alongside the tutor who will be at hand for any questions that you may have.

This is a 4 week course offered live online via zoom this course rolls on and new dates will be added.
What's included in the price?
Online Tuition
Step by step Demonstrations via Zoom in the live class
Clear explanation from your Tutor
reference handouts sent via email
What you will need
Starter Kit Available from Tutor - Please email for details
Watercolour paints - tubes or pans
Watercolour paper ( Cold Pressed 300 gsm 140lb)
Round watercolour brushes- size 4 and 6 ( or similar)
HB graphite pencil to draw image
Eraser
Mixing Palette
2 x jars of clean water
Kitchen paper
Hairdryer
Sketchbook
Tracing paper
Suitable for
Adults
Engagement, birthdays & anniversaries
Intermediate level
Seniors
Suitable for beginners
Teenagers
Wheelchair users

Art By Purnima

Watercolour Painting

Watercolour Techniques for All - 4 week Online Course Tuesday Evenings Via Zoom

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyT25lJTIwaG91ciUyMHdlYmluYXIlMjBmb3IlMjBjby1kcml2ZXJzJTIwbG9va2luZyUyMHRvJTIwdGFrZSUyMHRoZSUyMHN0ZXAlMjB1cCUyMGZyb20lMjBzaW5nbGUlMjB2ZW51ZSUyMHN0YWdlJTIwcmFsbGllcyUyMG9yJTIwcm9hZCUyMHJhbGx5aW5nJTIwdG8lMjBtdWx0aS12ZW51ZSUyMHN0YWdlJTIwcmFsbGllcy4lMjBMZWFybiUyMGFib3V0JTIwcm9hZGJvb2tzJTJDJTIwdGltZWNhcmRzJTJDJTIwdGltaW5nJTIwYW5kJTIwcGVuYWx0aWVzJTJDJTIwcGx1cyUyMHJvdXRlJTIwbm90ZXMlMjBhbmQlMjBwYWNlJTIwbm90ZXMlMjBhbmQlMjBtYW55JTIwbW9yZSUyMGhpbnRzJTIwYW5kJTIwdGlwcyUyMHRvJTIwYmVjb21lJTIwYSUyMHN1Y2Nlc3NmdWwlMjBzdGFnZSUyMGNvLWRyaXZlci4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" id="isPasted" fr-original-style="" style="box-sizing: border-box;">One hour webinar for co-drivers looking to take the step up from single venue stage rallies or road rallying to multi-venue stage rallies. Learn about roadbooks, timecards, timing and penalties, plus route notes and pace notes and many more hints and tips to become a successful stage co-driver.</span>


</p>

One hour webinar for co-drivers looking to take the step up from single venue stage rallies or road rallying to multi-venue stage rallies. Learn about roadbooks, timecards, timing and penalties, plus route notes and pace notes and many more hints and tips to become a successful stage co-driver. 

Rally Navigation Training Services

Sports & Fitness

Rally training webinar for co-drivers looking to take the step up from single venue stage rallies or road rallying to multi-venue stage rallies.

Multi Venue Stage Rally Co-Driving

<article id="cincluded">
					<div>
						<h5>SQL Advanced Course Summary.</h5>
					</div>
					<div></div>
					<p>
						
						<br />Practical SQL Advanced Intensive Course
						, exploring the advanced and less commonly used SQL Statements and techniques.
						<br />We also learn Data Definition Language and Data Manipulation Language statements, 
						<br />as well as course automation of queries using T-SQL.
						<br />Hands-on, Practical SQL Advanced Course. 
						<br />PCWorkshops SQL Advanced Course Certificate.
						<br />Max 4 people per course, we keep it personalised. 
						
				  	</p>
	    		</article>

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

			   	<div id="cdetails">
					<div>
						<h5>SQL Course Advanced Topics</h5>
					</div>
					<article>
						<div>
							<h5>SQL ADVANCED COURSE TOPICS</h5>
						</div>
						<div></div>
						<div>
					 	<ul>
					    	<li>Database Concepts Revision:
								<br />What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,

								</li><li>SQL Sub-queries:

								<br />·Sub-queries in the WHERE, SELECT, From or Having clauses
								<br />·Using SOME, ALL, ANY and IN clauses in the Where Clause <br />·Self-contained sub-queries
								<br />·Correlated sub-queries
								<br />·Sub-queries with the EXISTS predicate

								</li><li>Derived Tables and CTEs:
								<br />·Using SQL derived tables
								<br />·SQL Common Table Expressions (CTEs)
								<br />·Recursive CTEs

								</li><li>Views:
								<br />Create, alter and drop Views, Indexes

								</li><li>SQL Stored Procedure Basics:
								<br />·Stored Procedure Principles
								<br />·Creating stored procedures
								<br />·Executing stored procedures
								<br />·System stored procedures

								</li><li>Variables:
								<br />·Declaring variables
								<br />·SET versus SELECT
								<br />Parameters and Return Values
								<br />·Passing parameters
								<br />·Default values and WHERE clauses
								<br />·Output parameters
								<br />·Using RETURN
								<br />·Testing Conditions
								<br />·The IF/ELSE statement
								<br />·CASE
								<br />·CHOOSE

								</li><li>Looping:
								<br />·Syntax of SQL WHILE
								<br />·Breaking out of a loop
								<br />·Basic transactions
								<br />·Beginning a transaction
								<br />·Committing/rolling back
								<br />·Deleting and updating
								<br />·Using DELETE and UPDATE
								<br />·Sys.Objects
								<br />·Dropping objects

								</li><li>User defined Functions:
								<br />Table Valued Functions
								<br />·In-line table-valued functions
								<br />·Multi- Statement table-valued functions
								<br />·Limitations of user-defined functions
								<br />Scalar Functions
								<br />·What are scalar functions?
								<br />·Some examples
								<br />·Disadvantages of scalar functions
								<br />·Three advantages

								</li><li>Cursors:
								<br />·Syntax of fetching rows
								<br />·When to use (and when not to)

								</li><li>Triggers:
								<br />·Create or replace triggers

								</li><li>Creating Tables in SQL:

								<br />·Create, alter and drop Tables
								<br />·Inserting values, single rows and multiple rows using queries
								</li><li>Constraints:
								<br />·Not Null, Unique,Default,Check,Primary Key,Foreign Key,Identity / Auto-increments

								</li><li>Sequencing
								</li><li>Indexes

								</li><li>SQL Temporary Tables and Table Variables:
								<br />·Create and use SQL temporary tables
								<br />·Create and use SQL table variables
								<br />·SQL Tables vs. Table Variables

								</li><li>Error-Handling:
								<br />·SQL TRY/CATCH
								<br />·SQL System error functions
								<br />·Customizing SQL error messages
								<br />·@@ error function

								</li><li>Debugging:
								<br />·The SQL Server debugger, Debugging (breakpoints, etc.)
							
							 
							
							</li>
						</ul>
						</div>
					</article>
				</div>

		<div> 
						 

						
				     
	                  <div></div>
 		</div>
	                
				     
				   <div id="booking">
	                  <div>
	                     <h5>BOOK THE SQL Course Advanced COURSE</h5> 
	                  </div>
							 
							 <div id="eventbrite-widget-container-48063008753"></div>




					 
	               </div>
				   <div id="#">
	                  <div>
	                     <h5>About SQL Course Advanced</h5>
	                  </div>



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

SQL Advanced Course 
 
Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. 
We also learn Data Definition Language and Data Manipulation Language statements, 
as well as course automation of queries using T-SQL. 
Hands-on, Practical SQL Advanced Course. 
PCWorkshops SQL Advanced Course Certificate. 
Max 4 people per course; we keep it personalised. 
Where is the SQL Advanced Course?
Online: Instructor-led.
Classroom: Request per email.
SQL Advanced Course Materials
SQL Coding Examples
Manuals and Notes: In-depth reference materials
Exercises: Practical exercises
 
Included with SQL Advanced Course:
SQL Advanced Course Certificate on completion.
SQL Advanced Course Manual.
Practical SQL Advanced Course exercises
SQL Code Samples.
After the course, 1 free session for questions.
Max group size, online and in classroom, on this SQL Advanced Course is 4.
SQL Course Advanced Topics
SQL ADVANCED COURSE TOPICS
Database Concepts Revision: 
What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,
SQL Sub-queries: 
·Sub-queries in the WHERE, SELECT, From or Having clauses 
·Using SOME, ALL, ANY and IN clauses in the Where Clause 
·Self-contained sub-queries 
·Correlated sub-queries 
·Sub-queries with the EXISTS predicate
Derived Tables and CTEs: 
·Using SQL derived tables 
·SQL Common Table Expressions (CTEs) 
·Recursive CTEs
Views: 
Create, alter and drop Views, Indexes
SQL Stored Procedure Basics: 
·Stored Procedure Principles 
·Creating stored procedures 
·Executing stored procedures 
·System stored procedures
Variables: 
·Declaring variables 
·SET versus SELECT 
Parameters and Return Values 
·Passing parameters 
·Default values and WHERE clauses 
·Output parameters 
·Using RETURN 
·Testing Conditions 
·The IF/ELSE statement 
·CASE 
·CHOOSE
Looping: 
·Syntax of SQL WHILE 
·Breaking out of a loop 
·Basic transactions 
·Beginning a transaction 
·Committing/rolling back 
·Deleting and updating 
·Using DELETE and UPDATE 
·Sys.Objects 
·Dropping objects
User defined Functions: 
Table Valued Functions 
·In-line table-valued functions 
·Multi- Statement table-valued functions 
·Limitations of user-defined functions 
Scalar Functions 
·What are scalar functions? 
·Some examples 
·Disadvantages of scalar functions 
·Three advantages
Cursors: 
·Syntax of fetching rows 
·When to use (and when not to)
Triggers: 
·Create or replace triggers
Creating tables in SQL: 
·Create, alter and drop Tables 
·Inserting values, single rows and multiple rows using queries
Constraints: 
·Not Null, Unique,Default, Check,Primary Key,Foreign Key,Identity / Auto-increments
Sequencing
Indexes
SQL Temporary Tables and Table Variables 
·Create and use SQL temporary tables 
·Create and use SQL table variables 
·SQL Tables vs. Table Variables
Error-Handling: 
·SQL TRY/CATCH 
·SQL System error functions 
·Customizing SQL error messages 
·@@ error function
Debugging: 
·The SQL Server debugger, Debugging (breakpoints, etc.)

About SQL Course Advanced
Our experienced trainers are award winners.
More about us
FAQ's
Client Comments

Microsoft SQL Server

SQL Server

Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. 
We also learn Data Definition Language and Data Manipulation Language statements. 
as well as course automation of queries using T-SQL. 
Hands-on, Practical SQL Advanced Course. 
PCWorkshops SQL Advanced Course Certificate. 
Max 4 people per course; we keep it personalised. 

SQL Course Advanced, 2 Days

Thornton

Staines

Lincoln

Newark


The candidate journey is the process job applicants go through when interacting with Noble Foods. It encompasses every interaction in person and online, from the moment a candidate first becomes aware of us to the final hiring decision – and even beyond.

You play a key role in the successful recruitment of new starters. It’s important that you have the skills to navigate all stages of the recruitment process to give the candidates the best experience, hire top talent and ensure we remain legally compliant.

What does the course cover?
What is the candidate journey and why is it important?
The role of the line manager
Legal Compliance
The Noble Foods Candidate Journey
How to fill out a Requisition
How to post a job
Selection Process
Interviews
Flexible Working Requests


Noble Foods

The Candidate Journey

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">These short-courses are designed to provide a snapshot into the key areas of the language for a variety of levels. &nbsp;Designed to be self-contained; you will not be required to purchase textbooks or extra materials; everything you need will be provided, including access to my online learning materials. &nbsp;You will also receive the PowerPoint slides, the agenda for the following week &amp; any homework set after each class. &nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">I have designed all the slides myself for thee 10-week courses, as I wanted to use my 10+ years of experience to develop something different from the traditional &ldquo;here&rsquo;s a textbook&rdquo; approach that lots of evening classes use. &nbsp;This class is designed to get you speaking in a way that will propel you forward with your language skills in practical settings.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Each learner is entitled to a <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">free 15-minute introduction session</strong> on Zoom so that we can get to know each other and assess your current level. &nbsp;I will also talk you through the controls on Zoom if you are not familiar with how to use it. &nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Each course is comprised of 10 x 1 hour sessions. &nbsp;The groups will contain approximately 3-4 students (with an absolute maximum of 6 students) and are designed to encourage learners to strengthen their speaking skills in a relaxed, friendly atmosphere &amp; learn language skills in a social environment. &nbsp;If you miss a session, it may be possible to join another class running the same session at another time that week, or you can request receiving the learning materials via email. &nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The courses are designed to have practical application for travel &amp; learning for personal interest. &nbsp;I firmly believe having a grammar component is key for long-term success with learning a language, but I promise to break it down so that it isn&rsquo;t overwhelming!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">When a 10-week course finishes, it will be followed by three weeks of optional revision classes. &nbsp;After this, you can simply choose to join the next level course, until you reach a level where you can join our conversation classes.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You may also like to consider a blended learning approach; group classes are friendlier for your budget than private one-to-one tuition, but top up any time with one of my <a href="http://www.pronouncelanguages.co.uk/online-lessons" target="" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">private lessons</a> to consolidate your learning, ask further questions, revisiting themes or investigate a topic of particular interest to you that may not be covered in the short course.  </p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This specific course is for those with little or no knowledge of the Spanish language.</p>

These short-courses are designed to provide a snapshot into the key areas of the language for a variety of levels. Designed to be self-contained; you will not be required to purchase textbooks or extra materials; everything you need will be provided, including access to my online learning materials. You will also receive the PowerPoint slides, the agenda for the following week & any homework set after each class. 
I have designed all the slides myself for thee 10-week courses, as I wanted to use my 10+ years of experience to develop something different from the traditional “here’s a textbook” approach that lots of evening classes use. This class is designed to get you speaking in a way that will propel you forward with your language skills in practical settings. 
Each learner is entitled to a free 15-minute introduction session on Zoom so that we can get to know each other and assess your current level. I will also talk you through the controls on Zoom if you are not familiar with how to use it. 
Each course is comprised of 10 x 1 hour sessions. The groups will contain approximately 3-4 students (with an absolute maximum of 6 students) and are designed to encourage learners to strengthen their speaking skills in a relaxed, friendly atmosphere & learn language skills in a social environment. If you miss a session, it may be possible to join another class running the same session at another time that week, or you can request receiving the learning materials via email. 
The courses are designed to have practical application for travel & learning for personal interest. I firmly believe having a grammar component is key for long-term success with learning a language, but I promise to break it down so that it isn’t overwhelming!
When a 10-week course finishes, it will be followed by three weeks of optional revision classes. After this, you can simply choose to join the next level course, until you reach a level where you can join our conversation classes.
You may also like to consider a blended learning approach; group classes are friendlier for your budget than private one-to-one tuition, but top up any time with one of my private lessons to consolidate your learning, ask further questions, revisiting themes or investigate a topic of particular interest to you that may not be covered in the short course. 
This specific course is for those with little or no knowledge of the Spanish language.

Pronounce Languages

Spanish

Language Teaching

Teaching Online

Online Education

An exciting 10-week course to build your Spanish skills from scratch.  Practical applications for travel & conversation.  Enlarge your vocabulary, improve your grammar in a pain-free, step-by-step way, working with a tutor with 10+ years' experience & a small group of learners.

1491 PE courses in Leicester

NPORS Forward Tipping Dumper (N204)

By Dynamic Training and Assessments Ltd

NPORS Road Roller (N214)

By Dynamic Training and Assessments Ltd

NPORS Rear Tipping Dumper (N205)

By Dynamic Training and Assessments Ltd

NPORS Forward Tipping Mini Dumper (N139)

By Dynamic Training and Assessments Ltd

NPORS Skidsteer Loader (N212)

By Dynamic Training and Assessments Ltd

NPORS Piling Rig Attendant (N022)

By Dynamic Training and Assessments Ltd

NPORS MEWP Supervisor Awareness (N035)

By Dynamic Training and Assessments Ltd

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

By Dynamic Training and Assessments Ltd

NPORS Suction Excavator (N021)

By Dynamic Training and Assessments Ltd

NPORS Marine Knuckle Boom Crane (N014)

By Dynamic Training and Assessments Ltd

Search By Location