Nottinghamshire

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge and practical skills to operate 360 excavator for lifting operations.</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);">The NPORS Excavator 360 qualification is required to gain the bolt on unit.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Candidates will be able to:</p><ul style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><li fr-original-style="" style="box-sizing: border-box;">Understand the industry, the dangers of working in the industry and their responsibilities as an operator</li><li fr-original-style="" style="box-sizing: border-box;">Conform to manufacturers requirements as per technical data, conform to relevant regulations and legislation</li><li fr-original-style="" style="box-sizing: border-box;">Locate, identify and explain safe working loads, lifting capacity charts and explain different lifting configurations and working ranges</li><li fr-original-style="" style="box-sizing: border-box;">Identify and explain different lifting procedures and explain what task could fall into each category</li><li fr-original-style="" style="box-sizing: border-box;">Identify and explain centres of gravity and calculate estimated weights of loads</li><li fr-original-style="" style="box-sizing: border-box;">Identify any overhead/proximity hazards</li><li fr-original-style="" style="box-sizing: border-box;">Agree the signal codes/hand signals, direction of movement, safe working and safe landing and placement zone with the slinger/signaller</li><li fr-original-style="" style="box-sizing: border-box;">Ensure the excavator is in a safe condition for attachments to be fitted</li><li fr-original-style="" style="box-sizing: border-box;">Check load integrity and security by carrying out trial lifts</li><li fr-original-style="" style="box-sizing: border-box;">Lift and move a load to a designated position in a safe and controlled manner ensuring minimum uncontrolled movement</li><li fr-original-style="" style="box-sizing: border-box;">Understand environmental considerations</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all out of service and securing procedures</li></ul><div style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements</strong></h2></div><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; Candidates must have achieved the relevant CITB Health, Safety &amp; Environment (HS&amp;E) touch-screen-test within 2 years.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Good understanding of spoken and written English.</p><div style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration</strong></h2></div><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course- 5 days depending on experience</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests- 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Location</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Customer Site (Training &amp; Testing) &ndash; Site must adhere to NPORS specifications</p>

Overview
This course is aimed at candidates that require the knowledge and practical skills to operate 360 excavator for lifting operations.
The NPORS Excavator 360 qualification is required to gain the bolt on unit.
Course Content
Candidates will be able to:
Understand the industry, the dangers of working in the industry and their responsibilities as an operator
Conform to manufacturers requirements as per technical data, conform to relevant regulations and legislation
Locate, identify and explain safe working loads, lifting capacity charts and explain different lifting configurations and working ranges
Identify and explain different lifting procedures and explain what task could fall into each category
Identify and explain centres of gravity and calculate estimated weights of loads
Identify any overhead/proximity hazards
Agree the signal codes/hand signals, direction of movement, safe working and safe landing and placement zone with the slinger/signaller
Ensure the excavator is in a safe condition for attachments to be fitted
Check load integrity and security by carrying out trial lifts
Lift and move a load to a designated position in a safe and controlled manner ensuring minimum uncontrolled movement
Understand environmental considerations
Carry out all out of service and securing procedures
Entry Requirements
NPORS CSCS – Candidates must have achieved the relevant CITB Health, Safety & Environment (HS&E) touch-screen-test within 2 years.
Good understanding of spoken and written English.
Duration
Novice course- 5 days depending on experience
Experienced worker tests- 1 day theory and practical assessment
Location
Customer Site (Training & Testing) – Site must adhere to NPORS specifications

Dynamic Training and Assessments Ltd

Construction

CSCS (Construction Skills Certification Scheme)

NPORS

NPORS Excavator as a Crane (N100)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is for candidates who are required to operate 360 re handlers to lift, move and transport materials. This course will give the candidate the required knowledge and skills to carry this task out safely and efficiently.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Candidates will be able to:</p><ul style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><li fr-original-style="" style="box-sizing: border-box;">Understand the industry, the dangers of working in the industry and their responsibilities as a plant operator</li><li fr-original-style="" style="box-sizing: border-box;">Understand the manufacturer&rsquo;s handbook for the particular machine to be used</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify steering, driving and braking controls and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Safely mount and dismount the machine</li><li fr-original-style="" style="box-sizing: border-box;">Start and stop the engine and safely move the machine off and stop it safely</li><li 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</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area</li><li fr-original-style="" style="box-sizing: border-box;">Manoeuvre the machine to the work area and correctly configure in readiness to carry out processing tasks</li><li fr-original-style="" style="box-sizing: border-box;">Carry out processing task</li><li fr-original-style="" style="box-sizing: border-box;">Load material onto transporting vehicles, containers or processing plant</li><li fr-original-style="" style="box-sizing: border-box;">Fit and remove attachments</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down procedures</li></ul><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; Candidates must have achieved the relevant CITB Health, Safety &amp; Environment (HS&amp;E) touch-screen-test within 2 years.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Good understanding of spoken and written English.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course &ndash; 5 days</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests &ndash; 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Location</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Customer Site (Training &amp; Testing) &ndash; Site must adhere to NPORS specifications</p>

Overview
This course is for candidates who are required to operate 360 re handlers to lift, move and transport materials. This course will give the candidate the required knowledge and skills to carry this task out safely and efficiently.
Course Content
Candidates will be able to:
Understand the industry, the dangers of working in the industry and their responsibilities as a plant operator
Understand the manufacturer’s handbook for the particular machine to be used
Locate and identify the major components of the machine and explain their functions
Locate and identify steering, driving and braking controls and explain their functions
Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
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 processing tasks
Carry out processing task
Load material onto transporting vehicles, containers or processing plant
Fit and remove attachments
Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation
Carry out all end of shift and shut down procedures
Entry Requirements
NPORS CSCS – Candidates must have achieved the relevant CITB Health, Safety & Environment (HS&E) touch-screen-test within 2 years.
Good understanding of spoken and written English.
Duration
Novice course – 5 days
Experienced worker tests – 1 day theory and practical assessment
Location
Customer Site (Training & Testing) – Site must adhere to NPORS specifications

NPORS Material Re - Handler (N722)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge and practical skills to operate 360&deg; excavators to excavate and load materials.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Candidates will be able to:</p><ul style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><li fr-original-style="" style="box-sizing: border-box;">Understand the industry, the dangers of working in the industry and their responsibilities as a plant operator</li><li fr-original-style="" style="box-sizing: border-box;">Understand the manufacturer&rsquo;s handbook for the particular machine to be used</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify steering, driving and braking controls and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for excavator use</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Safely mount and dismount the machine</li><li fr-original-style="" style="box-sizing: border-box;">Start and stop the engine and safely move the machine off and stop it safely</li><li 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</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area</li><li fr-original-style="" style="box-sizing: border-box;">Manoeuvre the machine to the work area and correctly configure in readiness to carry out excavating tasks</li><li fr-original-style="" style="box-sizing: border-box;">Carry out excavating tasks</li><li fr-original-style="" style="box-sizing: border-box;">Load material onto transporting vehicles or into containers</li><li fr-original-style="" style="box-sizing: border-box;">Reinstate excavation, grade and level ground</li><li fr-original-style="" style="box-sizing: border-box;">Fit and remove attachments</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down procedures</li></ul><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; Candidates must have achieved the relevant CITB Health, Safety &amp; Environment (HS&amp;E) touch-screen-test within 2 years.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Good understanding of spoken and written English.</p><div style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration</strong></h2></div><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course &ndash; 10 Days depending upon experience</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests &ndash; 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Location</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Customer Site (Training &amp; Testing) &ndash; Site must adhere to NPORS specifications</p>

Overview
This course is aimed at candidates that require the knowledge and practical skills to operate 360° excavators to excavate and load materials.
Course Content
Candidates will be able to:
Understand the industry, the dangers of working in the industry and their responsibilities as a plant operator
Understand the manufacturer’s handbook for the particular machine to be used
Locate and identify the major components of the machine and explain their functions
Locate and identify steering, driving and braking controls and explain their functions
Identify and maintain PPE appropriate for 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
Entry Requirements
NPORS CSCS – Candidates must have achieved the relevant CITB Health, Safety & Environment (HS&E) touch-screen-test within 2 years.
Good understanding of spoken and written English.
Duration
Novice course – 10 Days depending upon experience
Experienced worker tests – 1 day theory and practical assessment
Location
Customer Site (Training & Testing) – Site must adhere to NPORS specifications

NPORS Excavator 360 (N202)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge and practical skills to operate a industrial counterbalance lift truck.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Candidates will be able to:</p><ul style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><li fr-original-style="" style="box-sizing: border-box;">Understand the industry, the dangers of working in the industry and their responsibilities as a plant operator</li><li fr-original-style="" style="box-sizing: border-box;">Understand the manufacturer&rsquo;s handbook for the particular machine to be used</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify steering, driving and braking controls and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Safely mount and dismount the machine</li><li fr-original-style="" style="box-sizing: border-box;">Start and stop the engine and safely move the machine off and stop it safely</li><li fr-original-style="" style="box-sizing: border-box;">Configure the machine for travel and manoeuvre it safely laden and unladen, in open and confined areas</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area</li><li fr-original-style="" style="box-sizing: border-box;">Manoeuvre the machine to the work area and correctly configure in readiness to carry out lifting and load handling tasks</li><li fr-original-style="" style="box-sizing: border-box;">Carry out lifting and load handling tasks</li><li fr-original-style="" style="box-sizing: border-box;">Lift and transfer loads accurately and safely at different locations</li><li fr-original-style="" style="box-sizing: border-box;">Load and unload external transport safely</li><li fr-original-style="" style="box-sizing: border-box;">Fit, adjust and or remove attachments</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down procedures</li></ul><div style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements</strong></h2></div><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; Candidates must have achieved the relevant CITB Health, Safety &amp; Environment (HS&amp;E) touch-screen-test within 2 years.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Good understanding of spoken and written English.</p><div style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration</strong></h2></div><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course- 5 days depending on experience</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests- 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Location</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Customer Site (Training &amp; Testing) &ndash; Site must adhere to NPORS specifications</p>

Overview
This course is aimed at candidates that require the knowledge and practical skills to operate a industrial counterbalance lift truck.
Course Content
Candidates will be able to:
Understand the industry, the dangers of working in the industry and their responsibilities as a plant operator
Understand the manufacturer’s handbook for the particular machine to be used
Locate and identify the major components of the machine and explain their functions
Locate and identify steering, driving and braking controls and explain their functions
Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
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 laden and unladen, 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 lifting and load handling tasks
Carry out lifting and load handling tasks
Lift and transfer loads accurately and safely at different locations
Load and unload external transport safely
Fit, adjust and or remove attachments
Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation
Carry out all end of shift and shut down procedures
Entry Requirements
NPORS CSCS – Candidates must have achieved the relevant CITB Health, Safety & Environment (HS&E) touch-screen-test within 2 years.
Good understanding of spoken and written English.
Duration
Novice course- 5 days depending on experience
Experienced worker tests- 1 day theory and practical assessment
Location
Customer Site (Training & Testing) – Site must adhere to NPORS specifications

Lifting Operations & Lifting Equipment Regulations (LOLER)

Site Management Safety Training Scheme (SMSTS)

NEBOSH

Overhead Crane Operator

FLT (Fork Lift Truck Driving License)

Lifting Operations

NPORS Industrial Counterbalance Lift Truck (N001)

<h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">This course is aimed at candidates that require the knowledge and practical skills to operate a Telescopic Handler to move and transport loads at various heights safely and efficiently.</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Content</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Candidates will be able to:</p><ul style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><li fr-original-style="" style="box-sizing: border-box;">Understanding the industry, the dangers of working in the industry and their responsibilities as a plant operator</li><li fr-original-style="" style="box-sizing: border-box;">Understand the manufacturer&rsquo;s handbook for the particular machine to be used and other relevant sources of information</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Locate and identify steering, driving and braking controls and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Safely mount and dismount the machine</li><li fr-original-style="" style="box-sizing: border-box;">Start and stop the engine and safely move the machine off and stop it safely</li><li fr-original-style="" style="box-sizing: border-box;">Configure the machine for travel and manoeuvre it safely laden and unladen, over varying terrain, rough ground, inclines, in open and confined areas</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area</li><li fr-original-style="" style="box-sizing: border-box;">Manoeuvre the machine to the work area and correctly configure in readiness to carry out lifting and load handling tasks</li><li fr-original-style="" style="box-sizing: border-box;">Carry out lifting and load handling tasks</li><li fr-original-style="" style="box-sizing: border-box;">Lift and transfer loads accurately and safely at different locations</li><li fr-original-style="" style="box-sizing: border-box;">Load and unload external transport safely</li><li fr-original-style="" style="box-sizing: border-box;">Fit, adjust and or remove attachments</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down procedures</li></ul><div style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements</strong></h2></div><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; Candidates must have achieved the relevant CITB Health, Safety &amp; Environment (HS&amp;E) touch-screen-test within 2 years.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Good understanding of spoken and written English.</p><div style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration</strong></h2></div><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Novice course- 5 days depending on experience</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced worker tests- 1 day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Location</strong></h2><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Customer Site (Training &amp; Testing) &ndash; Site must adhere to NPORS specifications</p>

Overview
This course is aimed at candidates that require the knowledge and practical skills to operate a Telescopic Handler to move and transport loads at various heights safely and efficiently.
Course Content
Candidates will be able to:
Understanding the industry, the dangers of working in the industry and their responsibilities as a plant operator
Understand the manufacturer’s handbook for the particular machine to be used and other relevant sources of information
Locate and identify the major components of the machine and explain their functions
Locate and identify steering, driving and braking controls and explain their functions
Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
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 laden and unladen, over varying terrain, rough ground, inclines, 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 lifting and load handling tasks
Carry out lifting and load handling tasks
Lift and transfer loads accurately and safely at different locations
Load and unload external transport safely
Fit, adjust and or remove attachments
Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation
Carry out all end of shift and shut down procedures
Entry Requirements
NPORS CSCS – Candidates must have achieved the relevant CITB Health, Safety & Environment (HS&E) touch-screen-test within 2 years.
Good understanding of spoken and written English.
Duration
Novice course- 5 days depending on experience
Experienced worker tests- 1 day theory and practical assessment
Location
Customer Site (Training & Testing) – Site must adhere to NPORS specifications

NPORS Telescopic Handler (N010)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Strategic thinking is one of the key capabilities required in an organisation for it to be able to develop and manage strategy effectively - yet in all the busyness and day-to-day operational priorities it can often be difficult to find the time and space to allow strategic thinking skills to develop and flourish.&nbsp;<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">There is also the challenge of engaging strategically as a leadership team, to develop the ability and trust (and create the space) to be able to have open conversations about strategy.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">This&nbsp;<em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Strategy Challenge&nbsp;</strong>w</em>orkshop is designed to provide an opportunity for senior management teams to practice and develop their strategic thinking skills - individually and collectively. It gives a &#39;safe space&#39; and uses examples designed to &#39;stretch the strategic thinking muscles&#39; - a step away from the specifics of the organisation and its current issues, but helping to develop the strategic thinking and strategy conversation skills that the team can apply in its own organisation.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">The workshop can be tailored (through discussion) to meet specific organisational requirements including using content that mirrors particular aspects of the organisation&#39;s strategic situation.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">[<em fr-original-style="" style="box-sizing: border-box;">This Strategy Challenge workshop has been run previously with specific groups, and given the feedback from participants is now being made available for open booking</em>.] &nbsp;</p>

Strategic thinking is one of the key capabilities required in an organisation for it to be able to develop and manage strategy effectively - yet in all the busyness and day-to-day operational priorities it can often be difficult to find the time and space to allow strategic thinking skills to develop and flourish. 

There is also the challenge of engaging strategically as a leadership team, to develop the ability and trust (and create the space) to be able to have open conversations about strategy.

This Strategy Challenge workshop is designed to provide an opportunity for senior management teams to practice and develop their strategic thinking skills - individually and collectively. It gives a 'safe space' and uses examples designed to 'stretch the strategic thinking muscles' - a step away from the specifics of the organisation and its current issues, but helping to develop the strategic thinking and strategy conversation skills that the team can apply in its own organisation.

The workshop can be tailored (through discussion) to meet specific organisational requirements including using content that mirrors particular aspects of the organisation's strategic situation.
[This Strategy Challenge workshop has been run previously with specific groups, and given the feedback from participants is now being made available for open booking.] 

Strategy Insights

Strategic Management

Business Strategy

Strategic Thinking

This Strategy Challenge workshop is designed to provide an opportunity for senior management teams to practice and develop their strategic thinking skills - individually and collectively. It gives a 'safe space' and uses examples designed to 'stretch the strategic thinking muscles'

A Strategy Challenge (workshop to develop strategic thinking)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who should attend</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;Our NPORS Abrasive Wheels course is intended for those who operate, supervise or manage the use of  abrasive wheels.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course information</strong>&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The aim of this course is to provide staff with sufficient knowledge to use and maintain abrasive  wheel equipment safely, covering:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;&bull; Health and safety legislation overview</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;&bull; Hazards and risk control measures associated with Abrasive Wheels</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;&bull; PPE&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull; Types of abrasive wheel machines and their safe use&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull; Resin &amp; vitrified bonded abrasive wheel selection, marking, identification and inspection&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull; Correct use, setting, adjustment and inspection of flanges, guards and accessories&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull; Pre-use machine safety checks&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&bull; How to mount of abrasive wheels on various equipment including hand angle grinder, saws  and bench grinders</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;&bull; Set up and safe working of applying an Abrasive Wheel to a grinder</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;&bull; Practical safe set up (no live cutting or grinding)</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements</strong>&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For learners that require the &#39;HS&amp;E TESTED Logo&#39; displayed on their card they must have passed  the CITB Operatives Health, Safety and Environment Test within the last 2 years. Good understanding of spoken and written English.</p>

Who should attend
 Our NPORS Abrasive Wheels course is intended for those who operate, supervise or manage the use of abrasive wheels. 


Course information 
The aim of this course is to provide staff with sufficient knowledge to use and maintain abrasive wheel equipment safely, covering:
 • Health and safety legislation overview
 • Hazards and risk control measures associated with Abrasive Wheels
 • PPE 
• Types of abrasive wheel machines and their safe use 
• Resin & vitrified bonded abrasive wheel selection, marking, identification and inspection 
• Correct use, setting, adjustment and inspection of flanges, guards and accessories 
• Pre-use machine safety checks 
• How to mount of abrasive wheels on various equipment including hand angle grinder, saws and bench grinders
 • Set up and safe working of applying an Abrasive Wheel to a grinder
 • Practical safe set up (no live cutting or grinding)
 Entry Requirements 
For learners that require the 'HS&E TESTED Logo' displayed on their card they must have passed the CITB Operatives Health, Safety and Environment Test within the last 2 years. Good understanding of spoken and written English.

NPORS Abrasive Wheels Awareness (N301A)

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">COURSE INFORMATION</strong></span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">To provide knowledge and understanding in the following areas:</p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">Name and explain the purpose of principle components, the basic construction, controls and terminology</li><li fr-original-style="" style="box-sizing: border-box;">Conform with manufacturers requirements as per the operators handbook, and relevant regulations and legislation</li><li fr-original-style="" style="box-sizing: border-box;">Undertake all pre-use checks</li><li fr-original-style="" style="box-sizing: border-box;">Configure and ready for travel</li><li fr-original-style="" style="box-sizing: border-box;">Travel the crane to an area of work</li><li fr-original-style="" style="box-sizing: border-box;">Manoeuvre in confined spaces</li><li fr-original-style="" style="box-sizing: border-box;">Configure the crane for lifting duties</li><li fr-original-style="" style="box-sizing: border-box;">Explain rigging and de-rigging procedures when fitting a lattice-type extension</li><li fr-original-style="" style="box-sizing: border-box;">Explain actions required for hazards, underground and overhead services</li><li fr-original-style="" style="box-sizing: border-box;">Programme/set-up rated capacity indicators for lifting duties</li><li fr-original-style="" style="box-sizing: border-box;">Lift various loads using the full radius and slewing capabilities of a crane</li><li fr-original-style="" style="box-sizing: border-box;">Accurately place loads, Minimise the swinging of loads</li><li fr-original-style="" style="box-sizing: border-box;">Change falls of rope on a hook block</li><li fr-original-style="" style="box-sizing: border-box;">Move loads through machine travel and comply with signals and instructions</li><li fr-original-style="" style="box-sizing: border-box;">Maintain safe working situations</li><li fr-original-style="" style="box-sizing: border-box;">Prepare the crane in preparation of movement from lifting duties</li><li fr-original-style="" style="box-sizing: border-box;">Carry out shut down and securing procedures</li><li fr-original-style="" style="box-sizing: border-box;">Explain loading and unloading procedures for machine transporting</li></ul><h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Entry Requirements</h2><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please note, that in all cases, operators are required to supply proof to support&nbsp;their application. They have to have passed the CITB health, safety &amp; environmental touch screen test within two years prior to their application.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Good understanding of spoken and written English.</p>

COURSE INFORMATION
To provide knowledge and understanding in the following areas:
Name and explain the purpose of principle components, the basic construction, controls and terminology
Conform with manufacturers requirements as per the operators handbook, and relevant regulations and legislation
Undertake all pre-use checks
Configure and ready for travel
Travel the crane to an area of work
Manoeuvre in confined spaces
Configure the crane for lifting duties
Explain rigging and de-rigging procedures when fitting a lattice-type extension
Explain actions required for hazards, underground and overhead services
Programme/set-up rated capacity indicators for lifting duties
Lift various loads using the full radius and slewing capabilities of a crane
Accurately place loads, Minimise the swinging of loads
Change falls of rope on a hook block
Move loads through machine travel and comply with signals and instructions
Maintain safe working situations
Prepare the crane in preparation of movement from lifting duties
Carry out shut down and securing procedures
Explain loading and unloading procedures for machine transporting
Entry Requirements
Please note, that in all cases, operators are required to supply proof to support their application. They have to have passed the CITB health, safety & environmental touch screen test within two years prior to their application.
Good understanding of spoken and written English.

NPORS Crawler Crane (N103)

<h1 id="isPasted" fr-original-style="" style="box-sizing: border-box;">Overview&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</h1><table border="0" cellspacing="0" cellpadding="0" width="671" fr-original-style="" style="border: none; border-collapse: collapse; empty-cells: show; max-width: 100%; box-sizing: border-box;"><tbody fr-original-style="" style="box-sizing: border-box;"><tr fr-original-style="" style="box-sizing: border-box;"><td width="4.470938897168406%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p></td><td width="95.52906110283159%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course is aimed at candidates that require the knowledge and practical skills to&nbsp;ensure a safe system of work in accordance with the method statement.&nbsp;It will enable the candidate to carry out their duties while complying&nbsp;with the relevant legislation and standards, including LOLER 1998 and BS 7121.</p></td></tr></tbody></table><h1 fr-original-style="" style="box-sizing: border-box;">Who Should Attend?</h1><table border="0" cellspacing="0" cellpadding="0" width="671" fr-original-style="" style="border: none; border-collapse: collapse; empty-cells: show; max-width: 100%; box-sizing: border-box;"><tbody fr-original-style="" style="box-sizing: border-box;"><tr fr-original-style="" style="box-sizing: border-box;"><td width="4.470938897168406%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p></td><td width="95.52906110283159%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course is designed for&nbsp;personnel who supervise the lift and follow lift plans for routine and non-routine lifts.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Requirements:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Experienced operators should have&nbsp;sufficient experience of cranes to meet the requirements specified in British standard 7121 Safe Use of Cranes.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Good understanding of spoken and written English.</p></td></tr></tbody></table><h1 fr-original-style="" style="box-sizing: border-box;">Agenda</h1><table border="0" cellspacing="0" cellpadding="0" width="671" fr-original-style="" style="border: none; border-collapse: collapse; empty-cells: show; max-width: 100%; box-sizing: border-box;"><tbody fr-original-style="" style="box-sizing: border-box;"><tr fr-original-style="" style="box-sizing: border-box;"><td width="4.470938897168406%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p></td><td width="95.52906110283159%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p><ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a crane / lift supervisor</li><li fr-original-style="" style="box-sizing: border-box;">Explain the importance of locating and identifying different types of lifting equipment and lifting accessories.&nbsp;Explain their basic construction, uses, applications and functions</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate how to interpret and extract information on all relevant documentation</li><li fr-original-style="" style="box-sizing: border-box;">Explain and demonstrate diverse types of communication methods used for lifting purposes</li><li fr-original-style="" style="box-sizing: border-box;">Explain procedures for placing non-serviceable items out-of-service</li><li fr-original-style="" style="box-sizing: border-box;">Explain the function and use of the RCIs and anti-collision systems and use the information provided</li><li fr-original-style="" style="box-sizing: border-box;">Explain setting up, erection, levelling and dismantling requirements for diverse types of lifting equipment and lifts</li><li fr-original-style="" style="box-sizing: border-box;">Set up exclusion zone explaining actions required for emergency actions and identify overhead hazards</li><li fr-original-style="" style="box-sizing: border-box;">Identify potential hazards and unsafe lifting practices using different lifting scenarios</li><li fr-original-style="" style="box-sizing: border-box;">Explain the importance of checking the security of various types of loads and lifting accessories, explain the procedures ensuring load balance and integrity</li><li fr-original-style="" style="box-sizing: border-box;">Supervise the movement of loads to different types of locations using different methods of communication</li><li fr-original-style="" style="box-sizing: border-box;">Explain all Environmental considerations and explain how factors such as the external area to the lift zone can affect the planning of the lifting operation</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all out-of-service and securing procedures</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p></td></tr></tbody></table><h1 fr-original-style="" style="box-sizing: border-box;">Assessment</h1><table border="0" cellspacing="0" cellpadding="0" width="671" fr-original-style="" style="border: none; border-collapse: collapse; empty-cells: show; max-width: 100%; box-sizing: border-box;"><tbody fr-original-style="" style="box-sizing: border-box;"><tr fr-original-style="" style="box-sizing: border-box;"><td width="4.470938897168406%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p></td><td width="95.52906110283159%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Novice course &ndash; 3 Days</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Experienced Worker Tests- 1 Day&nbsp;</p></td></tr></tbody></table><h1 fr-original-style="" style="box-sizing: border-box;">Certification</h1><table border="0" cellspacing="0" cellpadding="0" width="671" fr-original-style="" style="border: none; border-collapse: collapse; empty-cells: show; max-width: 100%; box-sizing: border-box;"><tbody fr-original-style="" style="box-sizing: border-box;"><tr fr-original-style="" style="box-sizing: border-box;"><td width="4.470938897168406%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p></td><td width="95.52906110283159%" valign="top" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 0px solid rgb(221, 221, 221);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Traditional NPORS Card &ndash; Refresher training is advised every 3 years</p></td></tr></tbody></table>

Overview 
 	This course is aimed at candidates that require the knowledge and practical skills to ensure a safe system of work in accordance with the method statement. It will enable the candidate to carry out their duties while complying with the relevant legislation and standards, including LOLER 1998 and BS 7121.
Who Should Attend?
 	This course is designed for personnel who supervise the lift and follow lift plans for routine and non-routine lifts.
Requirements:
Experienced operators should have sufficient experience of cranes to meet the requirements specified in British standard 7121 Safe Use of Cranes. 
Good understanding of spoken and written English.
Agenda
 	 
Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a crane / lift supervisorExplain the importance of locating and identifying different types of lifting equipment and lifting accessories. Explain their basic construction, uses, applications and functionsDemonstrate how to interpret and extract information on all relevant documentationExplain and demonstrate diverse types of communication methods used for lifting purposesExplain procedures for placing non-serviceable items out-of-serviceExplain the function and use of the RCIs and anti-collision systems and use the information providedExplain setting up, erection, levelling and dismantling requirements for diverse types of lifting equipment and liftsSet up exclusion zone explaining actions required for emergency actions and identify overhead hazardsIdentify potential hazards and unsafe lifting practices using different lifting scenariosExplain the importance of checking the security of various types of loads and lifting accessories, explain the procedures ensuring load balance and integritySupervise the movement of loads to different types of locations using different methods of communicationExplain all Environmental considerations and explain how factors such as the external area to the lift zone can affect the planning of the lifting operationCarry out all out-of-service and securing procedures
 
Assessment
 	Novice course – 3 Days
Experienced Worker Tests- 1 Day 
Certification
 	Traditional NPORS Card – Refresher training is advised every 3 years

NPORS Crane / Lift Supervisor (N405)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Objectives:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><div style="color: rgb(64, 64, 64); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(64, 64, 64);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">A basic understanding of the industry, the dangers of working in the industry and responsibilities as plant operator.</strong></div></li></ul><div style="color: rgb(64, 64, 64); box-sizing: border-box;" fr-original-style=" color: rgb(64, 64, 64);"><ul fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><div style="color: rgb(127, 139, 147); box-sizing: border-box;" fr-original-style=" color: rgb(127, 139, 147);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">A working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used.</strong></div></li></ul></div><div style="color: rgb(64, 64, 64); box-sizing: border-box;" fr-original-style=" color: rgb(64, 64, 64);"><ul fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><div style="color: rgb(127, 139, 147); box-sizing: border-box;" fr-original-style=" color: rgb(127, 139, 147);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Be able to locate and identify the major components of the machine and explain their functions.</strong></div></li></ul></div><div style="color: rgb(64, 64, 64); box-sizing: border-box;" fr-original-style=" color: rgb(64, 64, 64);"><ul fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><div style="color: rgb(127, 139, 147); box-sizing: border-box;" fr-original-style=" color: rgb(127, 139, 147);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Be able to locate and identify steering, driving and braking controls and explain their functions.</strong></div></li></ul></div><div style="color: rgb(64, 64, 64); box-sizing: border-box;" fr-original-style=" color: rgb(64, 64, 64);"><ul fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><div style="color: rgb(127, 139, 147); box-sizing: border-box;" fr-original-style=" color: rgb(127, 139, 147);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Conduct all pre-operational checks in accordance with manufactures and legislative requirements.</strong></div></li></ul></div><div style="color: rgb(64, 64, 64); box-sizing: border-box;" fr-original-style=" color: rgb(64, 64, 64);"><ul fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><div style="color: rgb(127, 139, 147); box-sizing: border-box;" fr-original-style=" color: rgb(127, 139, 147);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Safely mount and dismount the machine.</strong></div></li></ul></div><div style="color: rgb(64, 64, 64); box-sizing: border-box;" fr-original-style=" color: rgb(64, 64, 64);"><ul fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><div style="color: rgb(127, 139, 147); box-sizing: border-box;" fr-original-style=" color: rgb(127, 139, 147);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Start and stop the engine and safely move the machine off and stop safely.</strong></div></li></ul></div><div style="color: rgb(64, 64, 64); box-sizing: border-box;" fr-original-style=" color: rgb(64, 64, 64);"><ul fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><div style="color: rgb(127, 139, 147); box-sizing: border-box;" fr-original-style=" color: rgb(127, 139, 147);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Configure the machine for travel and manoeuvre it safely laden and unladen, in open and confined areas.</strong></div></li></ul></div><div style="color: rgb(64, 64, 64); box-sizing: border-box;" fr-original-style=" color: rgb(64, 64, 64);"><ul fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><div style="color: rgb(127, 139, 147); box-sizing: border-box;" fr-original-style=" color: rgb(127, 139, 147);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Conduct all necessary safety checks at the work area.</strong></div></li></ul></div><div style="color: rgb(64, 64, 64); box-sizing: border-box;" fr-original-style=" color: rgb(64, 64, 64);"><ul fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><div style="color: rgb(127, 139, 147); box-sizing: border-box;" fr-original-style=" color: rgb(127, 139, 147);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Maneuver the machine to the work area and correctly configure in readiness to carry out lifting and load handling tasks.</strong></div></li></ul></div><div style="color: rgb(64, 64, 64); box-sizing: border-box;" fr-original-style=" color: rgb(64, 64, 64);"><ul fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><div style="color: rgb(127, 139, 147); box-sizing: border-box;" fr-original-style=" color: rgb(127, 139, 147);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Carry out lifting and load handling tasks.</strong></div></li></ul></div><div style="color: rgb(64, 64, 64); box-sizing: border-box;" fr-original-style=" color: rgb(64, 64, 64);"><ul fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><div style="color: rgb(127, 139, 147); box-sizing: border-box;" fr-original-style=" color: rgb(127, 139, 147);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Lift and transfer loads accurately and safety at different locations.</strong></div></li></ul></div><div style="color: rgb(64, 64, 64); box-sizing: border-box;" fr-original-style=" color: rgb(64, 64, 64);"><ul fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><div style="color: rgb(127, 139, 147); box-sizing: border-box;" fr-original-style=" color: rgb(127, 139, 147);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Load and unload external transport safely.</strong></div></li></ul></div><div style="color: rgb(64, 64, 64); box-sizing: border-box;" fr-original-style=" color: rgb(64, 64, 64);"><ul fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><div style="color: rgb(127, 139, 147); box-sizing: border-box;" fr-original-style=" color: rgb(127, 139, 147);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Fit, adjust and or remove attachments.</strong></div></li></ul></div><div style="color: rgb(64, 64, 64); box-sizing: border-box;" fr-original-style=" color: rgb(64, 64, 64);"><ul fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><div style="color: rgb(127, 139, 147); box-sizing: border-box;" fr-original-style=" color: rgb(127, 139, 147);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation.</strong></div></li></ul></div><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><div style="color: rgb(64, 64, 64); box-sizing: border-box;" fr-original-style=" color: rgb(64, 64, 64);"><div style="color: rgb(127, 139, 147); box-sizing: border-box;" fr-original-style=" color: rgb(127, 139, 147);"></div>Carry out all end of shift shut down procedures.</div></li></ul>

Course Objectives:
A basic understanding of the industry, the dangers of working in the industry and responsibilities as plant operator.
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.
Conduct all pre-operational checks in accordance with manufactures and legislative requirements.
Safely mount and dismount the machine.
Start and stop the engine and safely move the machine off and stop safely.
Configure the machine for travel and manoeuvre it safely laden and unladen, in open and confined areas.
Conduct all necessary safety checks at the work area.
Maneuver the machine to the work area and correctly configure in readiness to carry out lifting and load handling tasks.
Carry out lifting and load handling tasks.
Lift and transfer loads accurately and safety at different locations.
Load and unload external transport safely.
Fit, adjust and or remove attachments.
Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation.
Carry out all end of shift shut down procedures.

NPORS Reach Lift Truck (N003)

London

<article>
					<div>
						<h5>C++ Bootcamp  Course, 2-Months.</h5>
					</div>
					<div></div>
					<p>
						<span> </span>
						<br /> C++ Bootcamp is for coding beginners:
						<br />You want all the basic stuff, all the advanced stuff and practical experience and get a fantastic job in C++
					
						<br /><br /><b>Location: </b>Instructor-led, Online.
						<br /><b>Our Style: </b>Hands-on, Practical Course.
						<br /><b>Group Size: </b>Max 4 people per group.  
						<br /><b>Qualification: </b>PCWorkshops C++ Bootcamp Certification
						<br /><b>Hours: </b>2-Months, 1 day per week, 10am-5pm 
						<br /><b>Practical: </b>Exercises to be completed between sessions 
						<br /><b>1-1 Mentoring: </b>1-1 sessions to be scheduled individally between sessions
						<br /><b>Project: </b>Showcase your work online
						
						
				  	</p>
	    		</article> 
				
				<article>
					<div>
						<h5>C++ Bootcamp  Course, Course Outline.</h5>
					</div>
					<div></div>
					<p> 
						 		<b> WEEK 1: BASICS</b> 
								<br />C++ Language Introduction
								<br />Benefits of C++ over other languages
								<br />Compilation of C++ program
								<br />Hello World Program in C++

								<br /><br />Variables and Keywords in C++
								<br />Scope rules in C++
								<br />Data Types in C++
								<br />Operators &amp; Its Types
								<br />Typecasting in C++

								<br /><br />Decision Making Statements

								<br /><br />Loops in C++
								<br />Switch Statement in C++
								<br />Continue Statement | Break Statement
								<br />C++ Loops &amp; Control Structure Practice Questions

								<br /><br /><b>WEEK 2: STRINGS, MATH AND RANDOM</b>
								<br />Arrays in C++
								<br />Strings in C++
								<br />Multidimensional Arrays in C++
								<br />String functions in C++
								<br />Single-quoted &amp; Double-quoted declaration of the char array
								<br />Math in C++
								<br />Random Numbers in C++

								<br /><br /><b>WEEK 3: OOP</b>
								<br />Functions in C++
								<br />Function Prototype
								<br />Parameter Passing Techniques in C++
								<br />Function Overloading, 
								<br /><br />Storage Classes in C++, Classes/Objects, Class Methods, Constructors, Access Specifiers, Encapsulation, Inheritance, Polymorphism
								<br />Recursion Concept

								<br /><br /><b>WEEK 4: DATA STRUCTURES</b>
								<br />Multidimensional Arrays in C++
								<br />Pointers in C++, Double Pointer
								<br />Structures, Union, Enumeration (or enum) in C++
								<br />Declare a pointer to a function
								<br />Pointer vs Array in C++
								<br />Operations on struct variables in C++
								<br />Dynamic Memory Allocation in C++
								<br />Linked List Data Structure
								<br />Memory Leak
								<br />Stack 
								<br />Queue
								<br />Difference between malloc and calloc

								<br /><br /><b>WEEK 5: FILES</b>
								<br />Files and Streams
								<br />Exception Handling
								<br />File Handling, Read Write, Append to Files in C
								<br />Txt and Binary Files
								<br />Multiline macros in C++
								<br />Merge the content of two files into a third one
								<br />Preprocessor in C++
								<br />Preprocessor directives

								<br /><br /><b>WEEK 6 AND 7: C++ ADVANCED</b>
								<br />Dynamic Memory
								<br />Namespaces
								<br />Templates
								<br />Preprocessor
								<br />Signal Handling
								<br />Multithreading

								<br /><br /><b>WEEK 8: DATABASE PROGRAMMING WITH C++</b>
								Connecting to a database, Retrieve data, display a result set,  insert, update, delete records, create a database and table

								<br /><br /><b>WEEK 9: PRACTICAL </b>



							</p>
							<br />					

							<h4>Alternative Bootcamp Courses</h4>
							 
							<br /><br />
				  	<p></p>
	    		</article> 

			    <div>  
				     
	     
	               <div id="cincluded">
	                  <div>
	                     <h5>Included with the C++ Bootcamp  Course</h5>
	                  </div>

	                  <article>
	                  <div>
	                     <ul>
	                        <li>PCWorkshops C++ Bootcamp  Certificate on completion  </li>
							                  
						    <li>C++ Bootcamp  Notes</li>
							<li>C++ Code Examples</li>
	                        <li>Practical C++ Bootcamp  exercises</li>
							 <li>Practical C++ Project Online</li>
							
	                        <li>Personal attention in small groups of max 4 delegates, and 1-1 mentoring</li>
	                        
	                     </ul>
	                  </div>
						   
	                  </article>
	               </div>
			
				    
					
					
					
				   <div id="booking">
	                  <div>
	                     <h5>Book the C++ Bootcamp  Course</h5>
	                  </div>
							 
 							 
								<div id="eventbrite-widget-container-608486368107"></div>

									

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

C++ Bootcamp Course, 2-Months.
   
 C++ Bootcamp is for coding beginners: 
You want all the basic stuff, all the advanced stuff and practical experience and get a fantastic job in C++ 

Location: Instructor-led, Online. 
Our Style: Hands-on, Practical Course. 
Group Size: Max 4 people per group. 
Qualification: PCWorkshops C++ Bootcamp Certification 
Hours: 2-Months, 1 day per week, 10am-5pm 
Practical: Exercises to be completed between sessions 
1-1 Mentoring: 1-1 sessions to be scheduled individally between sessions 
Project: Showcase your work online 
C++ Bootcamp Course, Course Outline.
  WEEK 1: BASICS 
C++ Language Introduction 
Benefits of C++ over other languages 
Compilation of C++ program 
Hello World Program in C++ 

Variables and Keywords in C++ 
Scope rules in C++ 
Data Types in C++ 
Operators & Its Types 
Typecasting in C++ 

Decision Making Statements 

Loops in C++ 
Switch Statement in C++ 
Continue Statement | Break Statement 
C++ Loops & Control Structure Practice Questions 

WEEK 2: STRINGS, MATH AND RANDOM 
Arrays in C++ 
Strings in C++ 
Multidimensional Arrays in C++ 
String functions in C++ 
Single-quoted & Double-quoted declaration of the char array 
Math in C++ 
Random Numbers in C++ 

WEEK 3: OOP 
Functions in C++ 
Function Prototype 
Parameter Passing Techniques in C++ 
Function Overloading, 

Storage Classes in C++, Classes/Objects, Class Methods, Constructors, Access Specifiers, Encapsulation, Inheritance, Polymorphism 
Recursion Concept 

WEEK 4: DATA STRUCTURES 
Multidimensional Arrays in C++ 
Pointers in C++, Double Pointer 
Structures, Union, Enumeration (or enum) in C++ 
Declare a pointer to a function 
Pointer vs Array in C++ 
Operations on struct variables in C++ 
Dynamic Memory Allocation in C++ 
Linked List Data Structure 
Memory Leak 
Stack 
Queue 
Difference between malloc and calloc 

WEEK 5: FILES 
Files and Streams 
Exception Handling 
File Handling, Read Write, Append to Files in C 
Txt and Binary Files 
Multiline macros in C++ 
Merge the content of two files into a third one 
Preprocessor in C++ 
Preprocessor directives 

WEEK 6 AND 7: C++ ADVANCED 
Dynamic Memory 
Namespaces 
Templates 
Preprocessor 
Signal Handling 
Multithreading 

WEEK 8: DATABASE PROGRAMMING WITH C++ Connecting to a database, Retrieve data, display a result set, insert, update, delete records, create a database and table 

WEEK 9: PRACTICAL  
Alternative Bootcamp Courses

Included with the C++ Bootcamp Course
PCWorkshops C++ Bootcamp Certificate on completion
C++ Bootcamp Notes
C++ Code Examples
Practical C++ Bootcamp exercises
Practical C++ Project Online
Personal attention in small groups of max 4 delegates, and 1-1 mentoring
Book the C++ Bootcamp Course
About us
Our experienced trainers are award winners.
More about us
FAQ's
Client Comments

PCWorkshops

Online Course Creation

Programming Fundamentals

Computer Programming

Bootcamp

 C++ Bootcamp is for coding beginners:  You want all the basic stuff, all the advanced stuff and practical experience and get a fantastic job in C++ 

C++ Bootcamp Course, 2-Months

General admission

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

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

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

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

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

		<div> 
						 

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




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



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

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

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

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

Oracle SQL

Azure SQL Database

Microsoft SQL Server

Microsoft SQL

Database Programming

Computer Skills

SQL Server

MySQL

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

SQL Intermediate Course, 3 Days

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Candidates for this course design, develop, secure, and troubleshoot Power Platform solutions. Candidates implement components of a solution that include application enhancements, custom user experience, system integrations, data conversions, custom process automation, and custom visualizations. Candidates will gain applied knowledge of Power Platform services, including in-depth understanding of capabilities, boundaries, and constraints.</p>Overview<p>After completing this course, students will be able to:<br />Create a technical design<br />Configure Common Data Service<br />Create and configure Power Apps<br />Configure business process automation<br />Extend the user experience<br />Extend the platform<br />Develop Integrations</p><p>The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes. In this course, students will learn how to build Power Apps, Automate Flows and extend the platform to complete business requirements and solve complex business problems.</p></div><div id="course-pills-2"><h4>Create a model-driven application in Power Apps</h4><ul><li>This module introduces you to creating a model-driven app in Power Apps that uses Common Data Service.</li></ul><h4>Get started using Common Data Service</h4><ul><li>This module will explain the concepts behind and benefits of Common Data Service. Creating an environment, entities, fields and options sets are also discussed.</li></ul><h4>Create a canvas app in Power Apps</h4><ul><li>This module introduces you to Power Apps, helps you create and customize an app, and then manage and distribute it. It will also show you how to provide the best app navigation, and build the best UI using themes, icons, images, personalization, different form factors, and controls.</li></ul><h4>Automate a business process using Power Automate</h4><ul><li>This module introduces you to Power Automate, teaches you how to build workflows, and how to administer flows.</li></ul><h4>Create a business process flow in Power Automate</h4><ul><li>This module introduces you to creating business process flows in Power Automate</li></ul><h4>Introduction to developing with Power Platform</h4><ul><li>This module is the first step in learning about platform, tools, and the ecosystem of the Power Platform</li></ul><h4>Extending the Power Platform user experience Model Driven apps</h4><ul><li>This module describes how to create client scripting, perform common actions with client script, and automate business process flow with client scrip. Learn about what client script can do, rules, and maintaining scripts. Discover when to use client script as well as when not to use client script.</li></ul><h4>Create components with Power Apps Component Framework</h4><ul><li>This module describes how to get started with Power Apps Component Framework with an introductory module on the core concepts and components. Then it shows you how to build a component and work with advanced Power Apps Component Framework features.</li></ul><h4>Extending the Power Platform Common Data Service</h4><ul><li>This module looks at the tools and resources needed for extending the Power Platform. We'll start with looking at the SDKs, the extensibility model, and event framework. This learning path also covers when to use plug-ins. Configuration of plug-ins as well as registering and deploying plug-ins.</li></ul><h4>Integrate with Power Platform and Common Data Service</h4><ul><li>This module describes how to integrate with Common Data Service using code by learning about Common Data Service API. Get an in-depth overview of options available with Common Data Service to integrate data and events to Azure.</li></ul><h4>Extend Power Apps portals</h4><ul><li>This module describes how to transform a content portal into a full web app interacting with Common Data Service. We will also cover the options available to customizers and developers to extend the portal functionality and integrate with Office 365, Power Platform, and Azure components.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-400T00 Microsoft Power Platform Developer 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 PL-400T00 Microsoft Power Platform Developer 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
5 Days
30 CPD hours
This course is intended for
Candidates for this course design, develop, secure, and troubleshoot Power Platform solutions. Candidates implement components of a solution that include application enhancements, custom user experience, system integrations, data conversions, custom process automation, and custom visualizations. Candidates will gain applied knowledge of Power Platform services, including in-depth understanding of capabilities, boundaries, and constraints.
Overview
After completing this course, students will be able to:
Create a technical design
Configure Common Data Service
Create and configure Power Apps
Configure business process automation
Extend the user experience
Extend the platform
Develop Integrations
The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes. In this course, students will learn how to build Power Apps, Automate Flows and extend the platform to complete business requirements and solve complex business problems.
Create a model-driven application in Power Apps
This module introduces you to creating a model-driven app in Power Apps that uses Common Data Service.
Get started using Common Data Service
This module will explain the concepts behind and benefits of Common Data Service. Creating an environment, entities, fields and options sets are also discussed.
Create a canvas app in Power Apps
This module introduces you to Power Apps, helps you create and customize an app, and then manage and distribute it. It will also show you how to provide the best app navigation, and build the best UI using themes, icons, images, personalization, different form factors, and controls.
Automate a business process using Power Automate
This module introduces you to Power Automate, teaches you how to build workflows, and how to administer flows.
Create a business process flow in Power Automate
This module introduces you to creating business process flows in Power Automate
Introduction to developing with Power Platform
This module is the first step in learning about platform, tools, and the ecosystem of the Power Platform
Extending the Power Platform user experience Model Driven apps
This module describes how to create client scripting, perform common actions with client script, and automate business process flow with client scrip. Learn about what client script can do, rules, and maintaining scripts. Discover when to use client script as well as when not to use client script.
Create components with Power Apps Component Framework
This module describes how to get started with Power Apps Component Framework with an introductory module on the core concepts and components. Then it shows you how to build a component and work with advanced Power Apps Component Framework features.
Extending the Power Platform Common Data Service
This module looks at the tools and resources needed for extending the Power Platform. We'll start with looking at the SDKs, the extensibility model, and event framework. This learning path also covers when to use plug-ins. Configuration of plug-ins as well as registering and deploying plug-ins.
Integrate with Power Platform and Common Data Service
This module describes how to integrate with Common Data Service using code by learning about Common Data Service API. Get an in-depth overview of options available with Common Data Service to integrate data and events to Azure.
Extend Power Apps portals
This module describes how to transform a content portal into a full web app interacting with Common Data Service. We will also cover the options available to customizers and developers to extend the portal functionality and integrate with Office 365, Power Platform, and Azure components.
Additional course details:
Nexus Humans PL-400T00 Microsoft Power Platform Developer 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 PL-400T00 Microsoft Power Platform Developer 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

Microsoft PL-900

Microsoft Power Apps

Power Apps

Microsoft Power Platform

Microsoft AZ-303

Microsoft Power Automate

PL-400T00 Microsoft Power Platform Developer

General Admission

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>This course is designed for data scientists with existing knowledge of Python and machine learning frameworks like Scikit-Learn, PyTorch, and Tensorflow, who want to build and operate machine learning solutions in the cloud.</p><p></p>Overview<p>Learn how to operate machine learning solutions at cloud scale using Azure Machine Learning. This course teaches you to leverage your existing knowledge of Python and machine learning to manage data ingestion and preparation, model training and deployment, and machine learning solution monitoring in Microsoft Azure.</p><p></p><p>Learn how to operate machine learning solutions at cloud scale using Azure Machine Learning. This course teaches you to leverage your existing knowledge of Python and machine learning to manage data ingestion and preparation, model training and deployment, and machine learning solution monitoring with Azure Machine Learning and MLflow.</p><p></p>Prerequisites<p></p><li>Creating cloud resources in Microsoft Azure.</li>  <li>Using Python to explore and visualize data.</li>  <li>Training and validating machine learning models using common frameworks like Scikit-Learn, PyTorch, and TensorFlow.</li>  <li>Working with containers</li>  <li>AI-900T00: Microsoft Azure AI Fundamentals is recommended, or the equivalent experience.</li><p></p></div><div id="course-pills-2"><h3>1 - Design a data ingestion strategy for machine learning projects</h3> <ul> <li>Identify your data source and format</li> <li>Choose how to serve data to machine learning workflows</li> <li>Design a data ingestion solution</li> </ul> <h3>2 - Design a machine learning model training solution</h3> <ul> <li>Identify machine learning tasks</li> <li>Choose a service to train a machine learning model</li> <li>Decide between compute options</li> </ul> <h3>3 - Design a model deployment solution</h3> <ul> <li>Understand how model will be consumed</li> <li>Decide on real-time or batch deployment</li> </ul> <h3>4 - Design a machine learning operations solution</h3> <ul> <li>Explore an MLOps architecture</li> <li>Design for monitoring</li> <li>Design for retraining</li> </ul> <h3>5 - Explore Azure Machine Learning workspace resources and assets</h3> <ul> <li>Create an Azure Machine Learning workspace</li> <li>Identify Azure Machine Learning resources</li> <li>Identify Azure Machine Learning assets</li> <li>Train models in the workspace</li> </ul> <h3>6 - Explore developer tools for workspace interaction</h3> <ul> <li>Explore the studio</li> <li>Explore the Python SDK</li> <li>Explore the CLI</li> </ul> <h3>7 - Make data available in Azure Machine Learning</h3> <ul> <li>Understand URIs</li> <li>Create a datastore</li> <li>Create a data asset</li> </ul> <h3>8 - Work with compute targets in Azure Machine Learning</h3> <ul> <li>Choose the appropriate compute target</li> <li>Create and use a compute instance</li> <li>Create and use a compute cluster</li> </ul> <h3>9 - Work with environments in Azure Machine Learning</h3> <ul> <li>Understand environments</li> <li>Explore and use curated environments</li> <li>Create and use custom environments</li> </ul> <h3>10 - Find the best classification model with Automated Machine Learning</h3> <ul> <li>Preprocess data and configure featurization</li> <li>Run an Automated Machine Learning experiment</li> <li>Evaluate and compare models</li> </ul> <h3>11 - Track model training in Jupyter notebooks with MLflow</h3> <ul> <li>Configure MLflow for model tracking in notebooks</li> <li>Train and track models in notebooks</li> </ul> <h3>12 - Run a training script as a command job in Azure Machine Learning</h3> <ul> <li>Convert a notebook to a script</li> <li>Run a script as a command job</li> <li>Use parameters in a command job</li> </ul> <h3>13 - Track model training with MLflow in jobs</h3> <ul> <li>Track metrics with MLflow</li> <li>View metrics and evaluate models</li> </ul> <h3>14 - Perform hyperparameter tuning with Azure Machine Learning</h3> <ul> <li>Define a search space</li> <li>Configure a sampling method</li> <li>Configure early termination</li> <li>Use a sweep job for hyperparameter tuning</li> </ul> <h3>15 - Run pipelines in Azure Machine Learning</h3> <ul> <li>Create components</li> <li>Create a pipeline</li> <li>Run a pipeline job</li> </ul> <h3>16 - Register an MLflow model in Azure Machine Learning</h3> <ul> <li>Log models with MLflow</li> <li>Understand the MLflow model format</li> <li>Register an MLflow model</li> </ul> <h3>17 - Create and explore the Responsible AI dashboard for a model in Azure Machine Learning</h3> <ul> <li>Understand Responsible AI</li> <li>Create the Responsible AI dashboard</li> <li>Evaluate the Responsible AI dashboard</li> </ul> <h3>18 - Deploy a model to a managed online endpoint</h3> <ul> <li>Explore managed online endpoints</li> <li>Deploy your MLflow model to a managed online endpoint</li> <li>Deploy a model to a managed online endpoint</li> <li>Test managed online endpoints</li> </ul> <h3>19 - Deploy a model to a batch endpoint</h3> <ul> <li>Understand and create batch endpoints</li> <li>Deploy your MLflow model to a batch endpoint</li> <li>Deploy a custom model to a batch endpoint</li> <li>Invoke and troubleshoot batch endpoints</li> </ul></div>

Duration
4 Days
24 CPD hours
This course is intended for

This course is designed for data scientists with existing knowledge of Python and machine learning frameworks like Scikit-Learn, PyTorch, and Tensorflow, who want to build and operate machine learning solutions in the cloud.

Overview
Learn how to operate machine learning solutions at cloud scale using Azure Machine Learning. This course teaches you to leverage your existing knowledge of Python and machine learning to manage data ingestion and preparation, model training and deployment, and machine learning solution monitoring in Microsoft Azure.

Learn how to operate machine learning solutions at cloud scale using Azure Machine Learning. This course teaches you to leverage your existing knowledge of Python and machine learning to manage data ingestion and preparation, model training and deployment, and machine learning solution monitoring with Azure Machine Learning and MLflow.

Prerequisites

Creating cloud resources in Microsoft Azure.
Using Python to explore and visualize data.
Training and validating machine learning models using common frameworks like Scikit-Learn, PyTorch, and TensorFlow.
Working with containers
AI-900T00: Microsoft Azure AI Fundamentals is recommended, or the equivalent experience.

1 - Design a data ingestion strategy for machine learning projects
Identify your data source and format
Choose how to serve data to machine learning workflows
Design a data ingestion solution
2 - Design a machine learning model training solution
Identify machine learning tasks
Choose a service to train a machine learning model
Decide between compute options
3 - Design a model deployment solution
Understand how model will be consumed
Decide on real-time or batch deployment
4 - Design a machine learning operations solution
Explore an MLOps architecture
Design for monitoring
Design for retraining
5 - Explore Azure Machine Learning workspace resources and assets
Create an Azure Machine Learning workspace
Identify Azure Machine Learning resources
Identify Azure Machine Learning assets
Train models in the workspace
6 - Explore developer tools for workspace interaction
Explore the studio
Explore the Python SDK
Explore the CLI
7 - Make data available in Azure Machine Learning
Understand URIs
Create a datastore
Create a data asset
8 - Work with compute targets in Azure Machine Learning
Choose the appropriate compute target
Create and use a compute instance
Create and use a compute cluster
9 - Work with environments in Azure Machine Learning
Understand environments
Explore and use curated environments
Create and use custom environments
10 - Find the best classification model with Automated Machine Learning
Preprocess data and configure featurization
Run an Automated Machine Learning experiment
Evaluate and compare models
11 - Track model training in Jupyter notebooks with MLflow
Configure MLflow for model tracking in notebooks
Train and track models in notebooks
12 - Run a training script as a command job in Azure Machine Learning
Convert a notebook to a script
Run a script as a command job
Use parameters in a command job
13 - Track model training with MLflow in jobs
Track metrics with MLflow
View metrics and evaluate models
14 - Perform hyperparameter tuning with Azure Machine Learning
Define a search space
Configure a sampling method
Configure early termination
Use a sweep job for hyperparameter tuning
15 - Run pipelines in Azure Machine Learning
Create components
Create a pipeline
Run a pipeline job
16 - Register an MLflow model in Azure Machine Learning
Log models with MLflow
Understand the MLflow model format
Register an MLflow model
17 - Create and explore the Responsible AI dashboard for a model in Azure Machine Learning
Understand Responsible AI
Create the Responsible AI dashboard
Evaluate the Responsible AI dashboard
18 - Deploy a model to a managed online endpoint
Explore managed online endpoints
Deploy your MLflow model to a managed online endpoint
Deploy a model to a managed online endpoint
Test managed online endpoints
19 - Deploy a model to a batch endpoint
Understand and create batch endpoints
Deploy your MLflow model to a batch endpoint
Deploy a custom model to a batch endpoint
Invoke and troubleshoot batch endpoints

Data Engineering

Microsoft AZ-900

Microsoft Azure

Microsoft AZ-700

Azure Machine Learning

DP-100T01 Designing and Implementing a Data Science Solution on Azure

<article>
					<div>
						<h5>Python Beginners Course, 1-Day.</h5>
					</div>
					<div></div>
					<p>
						<span> </span>
						<br />This course covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom.
						<br />	This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language.
							<br />These concepts are daily used by programmers and is your first step to working as a programmer.
							<br />By the end, you'll be comfortable in programming Python code.
							<br />You will have done small projects.
							<br />This will serve for you as examples and samples that you can use to build larger projects.
						 
						<br /><b>Location: </b>Instructor-led, Online.
						<br /><b>Our Style: </b>Hands-on, Practical Course.
						<br /><b>Group Size: </b>Max 4 people per group.  
						<br /><b>Qualification: </b>PCWorkshops Beginners Certification
						<br /><b>Hours: </b>1 Day, 10am-5pm
						<br /><b>Download: </b>anaconda.com
						
				  	</p>
	    		</article> 
				
				<article>
					<div>
						<h5>Python Beginners Course, Course Outline.</h5>
					</div>
					<div></div>
					<p>
						<span> </span>
						<br />
						<b>Session 1: Basics</b>
 
						<br />Python Data Types and Variables:
						Working with variables and its scope; Conversion and casting types in Python.
						<br />Operators and Expressions.
						 

						<br />Decision Making: If statement; If - else statement; If- elif - else statement; Nested if - else. 
						
						<br />Using Loops: The while, while-else. For loop; Jump statements: break, continue; Nesting loops.
<br />
						<br /><b>Session 2: Data Structures</b>
						 
						<br />Lists.
						<br />Tuples.
						<br />Sets.
						<br />Dictionary. Nested Dictionary.
						<br />Json Files.
<br />
						<br /><b>Session 3: Python Built-in functions</b> 
						<br />Strings Functions. 
						<br />Maths Functions.
						<br />Random Functions.
						<br />Python Date functions.
<br />
						<br /><b>Session 4: OOP: Using Modules, functions, classes</b>
						 
						<br />Creating and using custom Functions.
						
						<br />Using parameters and return values.

						<br />Introduction to Classes and Objects:
						<br />Creating a Class. Creating and using Objects. 
						<br />Class Constructors.
						<br />Inheritance. Overload.
<br />
						<br /><b>Session 5: Access SQL Database Via Python</b>
						 
						<br /><b>Connection details:</b> Connect to a database using access codes.
						<br /><b>Select Queries:</b> Retrieving records and iterating results sets, using variables and parameters in queries.
						<br /><b>Working with DDL comands: </b>Create a database, drop a database. Create a table, alter tables, drop a table.
						<br /><b>Working with DML Commands: </b>Insert, delete, update records.

						<br /><br /><br /><b>Session 6: Pandas Dataframe Basics</b>
						 
						<br />Getting data into a dataframe:
						<br />Dict to Dataframe, Dataframe to Dict.
						<br />Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets.
						<br />Dataframe basics:
						<br />Slicing Dataframes, Querying, filter and sort a dataframe,
						
						<br />Working with duplicates and null-values, Sampling, Group by, Join.
						
						
						
				  	</p>
	    		</article> 

			    <div>  
				     
	     
	               <div id="cincluded">
	                  <div>
	                     <h5>Python Beginners Course Materials</h5>
	                  </div>

	                  <article>
	                  <div>
	                     <ul>
	                        <li>Python Beginners Certificate on completion  </li>
							                  
						    <li>Python Beginners Notes</li>
							<li>Python Code Examples</li>
	                        <li>Practical Python Beginners exercises</li>
	                        
	                     </ul>
	                  </div>
						   
	                  </article>
	               </div>
			
				    <article>
					<div>
						<h5>More about Python</h5>
					</div>
					<div></div>
					<p>
							Python is the Easiest Programming Language to Learn 
				 				Anybody can learn how to use it and  entry-level coders get access to the industry in a 
									fast-tacked manner and can from there migrate to other languages.
								 <br />
								 Learning to code  is now more important than ever, since a growing number of application and <br />
								  digital products require programmers. <br />

								 Additionally, as an interpreted coding language, Python allows you to run each line of code <br />
								 after writing it, rather 
								 than other compiled languages, such as C++. <br />
								 This is particularly useful for beginners, as they can test their work and 
								  gain instant feedback, <br />
								  to make amendments where required and continuously improve. A Python Course will
								explain to you how to do this<br />
								  <br />
								 Python is a Versatile Coding Language <br />
								 Use it for : <br /> 
								 Data mining ,  Data analytics , Data visualisation ,  AI and machine learning,  Building apps ,
								 Web development and web application development ,  Developing games,  Quantitative and qualitative analysis,
								 Data Engineering,  A Python Course is the start of all of the above.
								 <br /><br />
								 Learning Python will Improve Your Job Prospects <br />
								 As the fastest-growing computer programming language in the world, 
								 Python is also one of the most in-demand jobs. According to 2022 LinkedIn data,   
								Python is the second most in-demand programming language, after Java.  
								All of this makes a Python Course essential. 
				  	</p>
	    		</article> 
					  
				    
					
					
					
				   <div id="booking">
	                  <div>
	                     <h5>Book the Python Beginners Course</h5>
	                  </div>
							 
 							<div id="eventbrite-widget-container-48024956939"></div>

							

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

Python Beginners Course, 1-Day.
   
This course covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom. 
	This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language. 
These concepts are daily used by programmers and is your first step to working as a programmer. 
By the end, you'll be comfortable in programming Python code. 
You will have done small projects. 
This will serve for you as examples and samples that you can use to build larger projects. 

Location: Instructor-led, Online. 
Our Style: Hands-on, Practical Course. 
Group Size: Max 4 people per group. 
Qualification: PCWorkshops Beginners Certification 
Hours: 1 Day, 10am-5pm 
Download: anaconda.com 
Python Beginners Course, Course Outline.
  Session 1: Basics 
Python Data Types and Variables: Working with variables and its scope; Conversion and casting types in Python. 
Operators and Expressions. 
Decision Making: If statement; If - else statement; If- elif - else statement; Nested if - else. 
Using Loops: The while, while-else. For loop; Jump statements: break, continue; Nesting loops.

 
Session 2: Data Structures 
Lists. 
Tuples. 
Sets. 
Dictionary. Nested Dictionary. 
Json Files.

 
Session 3: Python Built-in functions 
Strings Functions. 
Maths Functions. 
Random Functions. 
Python Date functions.

 
Session 4: OOP: Using Modules, functions, classes 
Creating and using custom Functions. 
Using parameters and return values. 
Introduction to Classes and Objects: 
Creating a Class. Creating and using Objects. 
Class Constructors. 
Inheritance. Overload.

 
Session 5: Access SQL Database Via Python 
Connection details: Connect to a database using access codes. 
Select Queries: Retrieving records and iterating results sets, using variables and parameters in queries. 
Working with DDL comands: Create a database, drop a database. Create a table, alter tables, drop a table. 
Working with DML Commands: Insert, delete, update records. 


Session 6: Pandas Dataframe Basics 
Getting data into a dataframe: 
Dict to Dataframe, Dataframe to Dict. 
Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets. 
Dataframe basics: 
Slicing Dataframes, Querying, filter and sort a dataframe, 
Working with duplicates and null-values, Sampling, Group by, Join. 
Python Beginners Course Materials
Python Beginners Certificate on completion
Python Beginners Notes
Python Code Examples
Practical Python Beginners exercises
More about Python
 Python is the Easiest Programming Language to Learn Anybody can learn how to use it and entry-level coders get access to the industry in a fast-tacked manner and can from there migrate to other languages. 
 Learning to code is now more important than ever, since a growing number of application and 
 digital products require programmers. 
 Additionally, as an interpreted coding language, Python allows you to run each line of code 
 after writing it, rather than other compiled languages, such as C++. 
 This is particularly useful for beginners, as they can test their work and gain instant feedback, 
 to make amendments where required and continuously improve. A Python Course will explain to you how to do this
 
 Python is a Versatile Coding Language 
 Use it for : 
 Data mining , Data analytics , Data visualisation , AI and machine learning, Building apps , Web development and web application development , Developing games, Quantitative and qualitative analysis, Data Engineering, A Python Course is the start of all of the above. 

 Learning Python will Improve Your Job Prospects 
 As the fastest-growing computer programming language in the world, Python is also one of the most in-demand jobs. According to 2022 LinkedIn data, Python is the second most in-demand programming language, after Java. All of this makes a Python Course essential. 
 

Programming Languages

Python

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

Python Beginners Course, 1-Day

Bournemouth

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



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

Travel the world and be paid for it

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

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


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

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

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

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

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

Receive constant updates on recruitment and news from Aviation the world

We will enhance your CV

Full support on your job application process

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

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

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








London Waterloo Academy

Flight Attendant

Stewardess

FLIGHT ATTENDANT VIRTUAL VIA ZOOM COURSE, EVENINGS

Registration Fee

Course Fee

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p></p><p>Senior Consultants (both functional and technical) that aspire to be Solution Architects, or current Solution Architects that are new to the role.</p><p></p><p>The Solution Architect is responsible for the successful design, implementation, deployment and adoption of an overall solution. The Solution Architect ensures that the solution meets the customer?s needs now and in the future. In this course, students will learn about decisions a Solution Architect makes during an implementation, covering security, integrations, Power Apps architecture, Power Automate architecture, and more. This course is designed to give you an introduction to the Solution Architect role.<br /></p></div><div id="course-pills-2"><h4>Becoming a Solution Architect/Getting to know your customer</h4><ul><li>Define a Solution Architect</li><li>Role of a Solution Architect on projects</li><li>Project Methodology</li><li>Getting to know your customer</li><li>Group exercise - Getting to know your customer</li></ul><h4>Conceptualizing the design from requirements</h4><ul><li>How to lead the requirement collection effort</li><li>Using fit gap analysis</li><li>Pillars of good architecture</li><li>Blueprinting the solution architecture</li><li>Group exercise - Design from requirements</li><li></li></ul><h4>Project governance and working as a team</h4><ul><li>Solution Architect's role in project governance</li><li>Techniques for keeping a project on track</li><li>Scenarios that could cause a project to fail</li><li>Group exercise - Project governance and working as a team</li><li></li></ul><h4>Power Platform Architecture</h4><ul><li>Key Power Platform architecture components</li><li>Understand how platform design and limits influence solution architectures</li><li>Updates and feature releases</li><li>Understand how to communicate how the platform meets customer needs</li><li></li></ul><h4>Data Modeling</h4><ul><li>Data model influences</li><li>Data model strategy</li><li>Data types</li><li>Data relationships</li><li>Group exercise - Data modeling</li><li></li></ul><h4>Analytics and artificial intelligence</h4><ul><li>Planning and evaluating requirements</li><li>Operational reporting</li><li>Power BI</li><li>Enterprise BI</li><li>Pre-built insights and custom AI</li><li></li></ul><h4>Power Apps Architecture</h4><ul><li>Discuss options for apps and how to choose where to start</li><li>Discuss app composition options</li><li>Using components as part of your app architecture</li><li>Considerations for including Portals as an app in your architecture</li><li>Group exercise - Power Apps Architecture topics</li><li></li></ul><h4>Application Lifecycle Management (ALM)</h4><ul><li>Microsoft vision and Solution Architect's role in ALM</li><li>Environment strategies</li><li>Defning a solution structure for your deliverable</li><li></li></ul><h4>Power Automate Architecture</h4><ul><li>Discuss options for automation and custom logic</li><li>Review considerations for using triggers and common actions</li><li>Explore using Business Process Flows (BPF) to guide users through business processes</li><li>Group Exercise - Evaluate scenarios for Power Automate usage</li><li></li></ul><h4>Security Modeling</h4><ul><li>Solution Architect's role in security modeling</li><li>Discovery and learning your client's environment</li><li>Controlling access to environments and resources</li><li>Controlling access to CDS Data</li><li>Group Exercise - Security Modeling</li><li></li></ul><h4>Integration</h4><ul><li>Solution Architects role in Integrations</li><li>What is an integration and why do we need it</li><li>Platform features that enable integration</li><li>CDS Event Publishing</li><li>Scenarios for group discussion</li><li></li></ul><h4>Dynamics 365 Applications Architecture</h4><ul><li>Solution Architect's role when deploying Dynamics 365 apps</li><li>Architecture Considerations for primary apps</li><li>Group Exercise - App specific working groups evaluate requirements</li><li></li></ul><h4>Power Virtual Agents architecture</h4><ul><li>Introduction</li><li>Chatbot options</li><li>Chatbot concepts</li><li>Best practices</li><li>Integrate chatbots</li><li>Power Virtual Agents in Microsoft Teams</li><li></li></ul><h4>Robotic Process Automation</h4><ul><li>Introduction</li><li>Power Automate Desktop</li><li>Recording and editing tasks</li><li>Running desktop flows</li><li>Process advisor</li><li></li></ul><h4>Testing and Go Live</h4><ul><li>Solution Architect's role with testing and go live</li><li>Planning for testing</li><li>Planning for go live</li><li></li></ul></div>

Duration
3 Days
18 CPD hours
This course is intended for

Senior Consultants (both functional and technical) that aspire to be Solution Architects, or current Solution Architects that are new to the role.

The Solution Architect is responsible for the successful design, implementation, deployment and adoption of an overall solution. The Solution Architect ensures that the solution meets the customer?s needs now and in the future. In this course, students will learn about decisions a Solution Architect makes during an implementation, covering security, integrations, Power Apps architecture, Power Automate architecture, and more. This course is designed to give you an introduction to the Solution Architect role.

Becoming a Solution Architect/Getting to know your customer
Define a Solution Architect
Role of a Solution Architect on projects
Project Methodology
Getting to know your customer
Group exercise - Getting to know your customer
Conceptualizing the design from requirements
How to lead the requirement collection effort
Using fit gap analysis
Pillars of good architecture
Blueprinting the solution architecture
Group exercise - Design from requirements

Project governance and working as a team
Solution Architect's role in project governance
Techniques for keeping a project on track
Scenarios that could cause a project to fail
Group exercise - Project governance and working as a team

Power Platform Architecture
Key Power Platform architecture components
Understand how platform design and limits influence solution architectures
Updates and feature releases
Understand how to communicate how the platform meets customer needs

Data Modeling
Data model influences
Data model strategy
Data types
Data relationships
Group exercise - Data modeling

Analytics and artificial intelligence
Planning and evaluating requirements
Operational reporting
Power BI
Enterprise BI
Pre-built insights and custom AI

Power Apps Architecture
Discuss options for apps and how to choose where to start
Discuss app composition options
Using components as part of your app architecture
Considerations for including Portals as an app in your architecture
Group exercise - Power Apps Architecture topics

Application Lifecycle Management (ALM)
Microsoft vision and Solution Architect's role in ALM
Environment strategies
Defning a solution structure for your deliverable

Power Automate Architecture
Discuss options for automation and custom logic
Review considerations for using triggers and common actions
Explore using Business Process Flows (BPF) to guide users through business processes
Group Exercise - Evaluate scenarios for Power Automate usage

Security Modeling
Solution Architect's role in security modeling
Discovery and learning your client's environment
Controlling access to environments and resources
Controlling access to CDS Data
Group Exercise - Security Modeling

Integration
Solution Architects role in Integrations
What is an integration and why do we need it
Platform features that enable integration
CDS Event Publishing
Scenarios for group discussion

Dynamics 365 Applications Architecture
Solution Architect's role when deploying Dynamics 365 apps
Architecture Considerations for primary apps
Group Exercise - App specific working groups evaluate requirements

Power Virtual Agents architecture
Introduction
Chatbot options
Chatbot concepts
Best practices
Integrate chatbots
Power Virtual Agents in Microsoft Teams

Robotic Process Automation
Introduction
Power Automate Desktop
Recording and editing tasks
Running desktop flows
Process advisor

Testing and Go Live
Solution Architect's role with testing and go live
Planning for testing
Planning for go live


AWS Certified Solutions Architect

PL-600T00 Power Platform Solution Architect

<div>
	                  <h5>Oracle SQL Fundamentals Course Summary</h5>
	               </div>
	               <div></div>
	               <p> 
				   
				  At this Oracle SQL Fundamentals couse, we cover SQL  queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom funtions, table variables.		  
					<br />Course level is beginners to intermediate.
				   
					 
					 
					 
				  </p>
				   
				   
	               <div>
	                  <div>
	                     <h5>Oracle SQL Fundamentals Course Outline</h5>
	                  </div>
	                  <div></div>
	                   
	    <div>
			<strong>Session 1: Database Concepts Revision: </strong> 
			 <p>  What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,
	 
			</p>
		</div>
		<div>
			<strong>Session 2: </strong>  
			<p> 	
			</p><ul>
			<li>
			  The SQL SELECT statement:WHERE clause, Boolean operators (AND and OR) and SQL conditional operators (=,!=,smaller and bigger than ,IN, and BETWEEN).The ORDER BY clause, Column aliases, LIMIT  TOP, Distinct 
			</li>
			</ul> 
			<p></p>
		</div>	 
		<div>
			<strong>Session 3:</strong>  
			<p> 
			</p><li> Expression queries: Arithmetic expressions, Null functions ('IS NULL,' 'IS NOT NULL,' , 'Coalesce')

			</li>
			<p></p>
		</div>	
	 
		<div>
			<strong>Session 4: </strong>  
			<p></p><ul>
				<li>SQL AGGERGATE Functions: Sum, Average, Maximum, Minimum, Count, Group By, Having.
				</li> 
				</ul>
			<p></p>
		</div>	
	 
		<div>
			<strong>Session 5:</strong>  
			<p></p><ul> <li> Joins: SQL Cartesian products, 
			 </li><li>SQL Joins (Inner join, Left join, Right join, Full join
			 </li><li>Table aliases, Natural joins, Multi-table joins. 
			 </li><li>Union, Union All, Except, Intersect
			 </li></ul>
			<p></p>
		</div>	
		<div>
			<strong>Session 6:</strong>  
			<p></p><ul> <li>
			Sub-queries: SQL Subqueries, Nested Subqueries, 
			</li><li>'WITH AS',
			</li><li>			Correlated and uncorrelated subqueries.  
			 </li></ul>
			<p></p>
		</div>

		<div>
			<strong>Session 7:</strong>  
			<p></p><ul> <li>
			 Numeric Functions, 
			 </li><li>String Functions, 
			</li><li>			 Date Functions
			Date, time and timezone support,  
			</li><li>Conversion and 
			</li><li>Formatting
			 </li></ul>
			<p></p>
		</div>
		<div>
			<strong>Session 8:</strong>  
			<p></p><ul> <li>
			SQL Views: Create, alter and drop Views 
			 </li></ul>
			<p></p>
		</div>
		<div>
			<strong>Session 9:</strong>  
			<p></p><ul> <li>
			Inserting rows, 
			</li><li>Replacing rows, 
			</li><li>Updating rows, 
			</li><li>Deleting rows
			 </li></ul>
			<p></p>
		</div>
		<div>
			<strong>Session 10:</strong>  
			<p></p><ul> <li>
			Session 10: Managing indexes 
			 </li></ul>
			<p></p>
		</div>
		<div>
			<strong>Session 11:</strong>  
			<p></p><ul> <li>
			 Creating Databases and 
			 </li><li>Creating Tables (Create, alter and drop); </li><li>Constraints (Add, alter and drop)  
			 </li><li>Temp tables
			</li><li>Managing sequences and synonyms 
			 </li></ul>
			<p></p>
		</div>
		<div>
					<strong>Session 12:</strong>  
					<p></p><ul> <li>
					 Import data into SQL and Export from SQL
					
					 </li></ul>
					<p></p>
		</div>		
		 
		 
		 
 
 
 
 
	               </div>
	               <div id="cincluded">
	                  <div>
	                     <h5>What is included in the SQL Advanced Course:</h5>
	                  </div>
	                  <div>
	                     <ul>
	                        <li>SQL Advanced Course Certificate on completion  </li>
	                        <li>SQL Advanced Course notes</li>
	                        <li>Practical SQL Course exercises, SQL Code Sample</li>
	                         
	                        <li>After the course, 1 free session for questions online SQL Course via Gotomeeting.com.</li>
	                        <li>Max group size, online and in classroom, on this SQL Course is 4. </li>
	                     </ul>
	                  </div>
	               </div>

Oracle SQL Fundamentals Course 
 At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. 
Course level is beginners to intermediate. 
Oracle SQL Fundamentals Course Outline
Session 1: Database Concepts Revision:
 What is a database? Tables, rows and columns, Indexes, primary keys, foreign keys, 
Session 2:
 The SQL SELECT statement: WHERE clause, Boolean operators (AND and OR), and SQL conditional operators (=,!=, smaller and bigger than, IN, and BETWEEN).The ORDER BY clause, Column aliases, LIMIT TOP, Distinct

Session 3:
Expression queries: Arithmetic expressions, Null functions ('IS NULL,' 'IS NOT NULL,' , 'Coalesce')

Session 4:
SQL AGGERGATE Functions: Sum, Average, Maximum, Minimum, Count, Group By, Having.

Session 5:
Joins: SQL Cartesian products,
SQL Joins (Inner join, Left join, Right join, Full join)
Table aliases, Natural joins, Multi-table joins.
Union, Union All, Except, Intersect

Session 6:

Sub-queries: SQL Subqueries, Nested Subqueries,
'WITH AS',
Correlated and uncorrelated subqueries.

Session 7:

Numeric Functions,
String Functions,
Date Functions Date, time and timezone support,
Conversion and
Formatting

Session 8:

SQL Views: Create, alter and drop Views

Session 9:

Inserting rows,
Replacing rows,
Updating rows,
Deleting rows

Session 10:

Session 10: Managing indexes

Session 11:

Creating Databases and
Creating Tables (Create, alter and drop);
Constraints (Add, alter and drop)
Temp tables
Managing sequences and synonyms

Session 12:

Import data into SQL and Export from SQL

What is included in the Oracle SQL Course:
Oracle SQL Course Certificate on completion
Oracle SQL Course notes
Practical Oracle SQL Course exercises, Oracle SQL Code Sample
After the course, 1 free session for questions online Oracle SQL Course 
Max group size, online and in classroom, on this Oracle SQL Course is 4.

Database Design & Development

Database Administration

 At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. 
Course level is beginners to intermediate. 

Oracle SQL Fundamentals, 3 Days

Registration starts at 7:30 AM. The training will begin promptly at 8:00 AM. Please plan your arrival accordingly to ensure you don't miss any important information.
Reduce Emissions, Save Costs, Earn a CPC Hours, and Ensure Full Compliance
Topics Covered:
FORS Lo-CITY Driver Training (3.5 hours):
	•	Relationship between driving style, fuel consumption, and environmental impact
	•	Benefits of regular vehicle maintenance and checks
	•	Fuel-efficient driving techniques
	•	Utilising in-vehicle technology for fuel economy
	•	Benefits of journey planning
	•	Alternative fuels for commercial vehicles
Highway Code Training Content:
Course introduction, objectives, and expectations.
Introduction to the Highway Code and its relevance.
Types of road users and training for various groups.
Respecting and understanding the risks to different road user categories.
Confirmation of knowledge quizzes covering all aspects of the Highway Code and traffic regulations.
Course Details:
Format: Remote Session (7 hours)
CPC Hours: Yes
Cost: £89.50 - Includes course fee, Driver CPC Upload fee, VAT
This award-winning program (awarded the prestigious Education in Transport award at the 2017 National Courier Awards) is perfect for any fleet operator looking to:
Meet FORS Gold accreditation requirements.
Improve driver performance and fuel efficiency.
Reduce their environmental footprint.
Enhance corporate social responsibility.
Please note that this course is delivered online and provides 7 hours of Driver CPC training.
Ready to get started?
Book online or feel free to contact our training department at training@totalcompliance.co.uk or call 0345 9001312 to register for this valuable course.
Please review our Terms and Conditions for more information.


Total Compliance 

FORS Lo-City Driving & Highway Code - Periodic 7 Hour CPC Course

<p dir="ltr" id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About the Course</strong></span></p><p dir="ltr" id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Learn &amp; master coaching tools and skills that help teams and systems, address intangible hurdles which lead to a lack of trust, conflict, unskillful communication and tribalism, towards teams/systems which are more collaborative &amp; aligned whilst at work and at home.&nbsp;</span></p><br fr-original-style="" style="box-sizing: border-box;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">The Fundamentals of Organisation and Relationship Systems Coaching is a two-day course&nbsp;</span><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">for coaching teams, as well as partnerships, families, and wider organisations, at the heart of which is&nbsp;</span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Relationship Systems Intelligence (RSI&trade;).&nbsp;</span></p><br fr-original-style="" style="box-sizing: border-box;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">During this course, you will gain insights into how to utilise RSI to address some of the common challenges that often afflict professional and personal relationships. You&rsquo;ll learn to:</span></p><br fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Increase your power and influence by tapping into the inherent wisdom of the team or relationship.</span></p></li><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Build</span><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">&nbsp;co-responsibility for both process and outcomes.</span></p></li><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Establish</span><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">&nbsp;boundaries and limitations, while focusing on common interests.</span></p></li><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Reveal</span><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">&nbsp;roles and garner deeper insights.</span></p></li><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Craft a narrative that resonates deeply and plots a course for change.</span></p></li></ul><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><br fr-original-style="" style="box-sizing: border-box;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Relationship Systems Intelligence</strong></span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Beyond Emotional Intelligence (which is the relationship with self) and Social Intelligence (which is the interaction with others) lies Relationship Systems Intelligence (RSI&trade;), where the primary focus shifts to encompass the entire group, team, or system.</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">RSI acknowledges the system or team as a distinct entity, facilitating the emergence of change through collaborative efforts and shared leadership. Each system or team possesses a unique identity, complete with its own personality, intelligence, and information that go beyond the individual components within it.</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Relationship Systems Intelligence (RSI) operates across three distinctive tiers: the individual system (where we navigate our inner voices), the dyadic or pair system, and expansive large group systems. Each of these tiers forms a crucial leg of the relationship systems coaching framework. Proficiency in all three is imperative for effectively coaching complex systems.</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">In the Fundamentals (or ORS@Work) course, we introduce the art of fostering conscious and intentional relationships with self and others.</span></p><br fr-original-style="" style="box-sizing: border-box;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outcomes:</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Develop a deeper understanding of team dynamics.</span></p></li><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Design intentional and accountable conversations.</span></p></li><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Align differences to impact the collective whole.</span></p></li><li dir="ltr" style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(44, 44, 44); box-sizing: border-box;" fr-original-style="color:#2c2c2c;">Feel confident engaging and supporting your clients through&nbsp;change and development initiatives.</span></p></li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Orientation Call</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Alongside the date for the course, you&#39;ll be sent an additional dates for an Orientation call and a Mentoring call. These are <span style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">additional learning opportunities we provide for free on top of your training dates. These are optional and not compulsory, but we do recommend you attend if you are able.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">The Orientation call provides context and an introduction to the course, we will explain what happens over the training dates, talk you through requirements and a space for you to ask any questions. It&#39;s also a chance for you to connect with your learning system ahead of the course.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(33, 33, 33); box-sizing: border-box;" fr-original-style=" color: rgb(33, 33, 33);">The Mentoring call is a 90-minute session to reconnect with your learning system and your leaders to embed everything you&#39;ve learned in the course. It&#39;s a space to share your experiences of using the tools and skills and to ask the leaders for input on any experiences you&#39;ve had whilst coaching relationships. It&#39;s a fantastic opportunity to deepen your experience of the tools and skills you&#39;ve learnt and fine-tune your practice.&nbsp;</span></p>

About the Course
Learn & master coaching tools and skills that help teams and systems, address intangible hurdles which lead to a lack of trust, conflict, unskillful communication and tribalism, towards teams/systems which are more collaborative & aligned whilst at work and at home. 
The Fundamentals of Organisation and Relationship Systems Coaching is a two-day course for coaching teams, as well as partnerships, families, and wider organisations, at the heart of which is Relationship Systems Intelligence (RSI™). 
During this course, you will gain insights into how to utilise RSI to address some of the common challenges that often afflict professional and personal relationships. You’ll learn to:
Increase your power and influence by tapping into the inherent wisdom of the team or relationship.
Build co-responsibility for both process and outcomes.
Establish boundaries and limitations, while focusing on common interests.
Reveal roles and garner deeper insights.
Craft a narrative that resonates deeply and plots a course for change.
Relationship Systems Intelligence
Beyond Emotional Intelligence (which is the relationship with self) and Social Intelligence (which is the interaction with others) lies Relationship Systems Intelligence (RSI™), where the primary focus shifts to encompass the entire group, team, or system.
RSI acknowledges the system or team as a distinct entity, facilitating the emergence of change through collaborative efforts and shared leadership. Each system or team possesses a unique identity, complete with its own personality, intelligence, and information that go beyond the individual components within it.
Relationship Systems Intelligence (RSI) operates across three distinctive tiers: the individual system (where we navigate our inner voices), the dyadic or pair system, and expansive large group systems. Each of these tiers forms a crucial leg of the relationship systems coaching framework. Proficiency in all three is imperative for effectively coaching complex systems.
In the Fundamentals (or ORS@Work) course, we introduce the art of fostering conscious and intentional relationships with self and others.
Course Outcomes:
Develop a deeper understanding of team dynamics.
Design intentional and accountable conversations.
Align differences to impact the collective whole.
Feel confident engaging and supporting your clients through change and development initiatives.


Orientation Call
Alongside the date for the course, you'll be sent an additional dates for an Orientation call and a Mentoring call. These are additional learning opportunities we provide for free on top of your training dates. These are optional and not compulsory, but we do recommend you attend if you are able. 
The Orientation call provides context and an introduction to the course, we will explain what happens over the training dates, talk you through requirements and a space for you to ask any questions. It's also a chance for you to connect with your learning system ahead of the course.
The Mentoring call is a 90-minute session to reconnect with your learning system and your leaders to embed everything you've learned in the course. It's a space to share your experiences of using the tools and skills and to ask the leaders for input on any experiences you've had whilst coaching relationships. It's a fantastic opportunity to deepen your experience of the tools and skills you've learnt and fine-tune your practice. 

CRR UK

Business Relationship Management (BRM)

CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.

512 Opera courses in Dewsbury

NPORS Excavator as a Crane (N100)

By Dynamic Training and Assessments Ltd

NPORS Material Re - Handler (N722)

By Dynamic Training and Assessments Ltd

NPORS Excavator 360 (N202)

By Dynamic Training and Assessments Ltd

NPORS Industrial Counterbalance Lift Truck (N001)

By Dynamic Training and Assessments Ltd

NPORS Telescopic Handler (N010)

By Dynamic Training and Assessments Ltd

A Strategy Challenge (workshop to develop strategic thinking)

By Strategy Insights

NPORS Abrasive Wheels Awareness (N301A)

By Dynamic Training and Assessments Ltd

NPORS Crawler Crane (N103)

By Dynamic Training and Assessments Ltd

NPORS Crane / Lift Supervisor (N405)

By Dynamic Training and Assessments Ltd

NPORS Reach Lift Truck (N003)

By Dynamic Training and Assessments Ltd

Search By Location