Nottinghamshire

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">COURSE INFORMATION</strong></span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">To provide knowledge and understanding in the following areas:</p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">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.

Dynamic Training and Assessments Ltd

Construction

NPORS

NPORS Crawler Crane (N103)

<h3 style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);">COURSE OBJECTIVES</h3><p style="color: rgb(102, 102, 102); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);">&bull;&nbsp;Have a managerial understanding of the industry, the dangers of working in the industry and their roles and responsibilities for performing rigging and fleeting loads tasks<br fr-original-style="" style="box-sizing: border-box;">&bull;&nbsp;Have an underpinning knowledge of the manufacturers handbooks or guidelines for the equipment to be used and have an understanding of P.U.W.E.R, L.O.L.E.R, Working at<br fr-original-style="" style="box-sizing: border-box;">&bull;&nbsp;Height, Manual Handling, Risk Assessments with a good awareness of British and International standards<br fr-original-style="" style="box-sizing: border-box;">&bull;&nbsp;Be able to calculate weights and measures ensuring that the load weight is accurate and all<br fr-original-style="" style="box-sizing: border-box;">&bull;&nbsp;CoG&rsquo;s, angles, tensions are within the manufacturers guidelines for the safe rigging and fleeting of loads<br fr-original-style="" style="box-sizing: border-box;">&bull;&nbsp;Prepare risk assessments for rigging and fleeting loads that covers basic, intermediate and complex categories<br fr-original-style="" style="box-sizing: border-box;">&bull;&nbsp;Be able to correctly check the certification for lifting equipment appliances and accessories and understand the commonly used tools, access egress items and PPE only used definitions of the industry<br fr-original-style="" style="box-sizing: border-box;">&bull;&nbsp;Correctly determine lifting equipment for the lift plan rigging and material lists including specific hand tools. Prepare a step by step method statement detailing a safe systematic approach including the pickup point, route to be travelled and laydown area<br fr-original-style="" style="box-sizing: border-box;">&bull;&nbsp;Allocate team roles and responsibilities for riggers, supervisors and fixed appliance operators that can be utilized for scenarios covering basic, intermediate and complex categories<br fr-original-style="" style="box-sizing: border-box;">&bull;&nbsp;Prepare a sketch, scaled drawing or have the understanding how to add pictures to lift plans ensuring the lift team understands the location and system of the operation in addition to text information<br fr-original-style="" style="box-sizing: border-box;">&bull;&nbsp;Oversee tasks for complex rigging and fleeting operations ensuring the team safely follow the step by step method statement in the lift plan pack<br fr-original-style="" style="box-sizing: border-box;">&bull;&nbsp;Liaise with the management, supervisors and workforce levels of lifting operations by attending meetings, TBT&rsquo;s, PTW meetings, site visits in a responsible competent manner<br fr-original-style="" style="box-sizing: border-box;">&bull;&nbsp;Participation in debrief meeting with lift team and discuss lessons learned during specific task</p><h3 style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);">WHO SHOULD ATTEND?</h3><p style="color: rgb(102, 102, 102); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);">This Rigging and Fleeting Loads &ndash; Lift Planner course is designed for Plant Operators who require practical and theory training and / or assessment on a Rigging and Fleeting Loads &ndash; Lift Planner</p>

COURSE OBJECTIVES
• Have a managerial understanding of the industry, the dangers of working in the industry and their roles and responsibilities for performing rigging and fleeting loads tasks
• Have an underpinning knowledge of the manufacturers handbooks or guidelines for the equipment to be used and have an understanding of P.U.W.E.R, L.O.L.E.R, Working at
• Height, Manual Handling, Risk Assessments with a good awareness of British and International standards
• Be able to calculate weights and measures ensuring that the load weight is accurate and all
• CoG’s, angles, tensions are within the manufacturers guidelines for the safe rigging and fleeting of loads
• Prepare risk assessments for rigging and fleeting loads that covers basic, intermediate and complex categories
• Be able to correctly check the certification for lifting equipment appliances and accessories and understand the commonly used tools, access egress items and PPE only used definitions of the industry
• Correctly determine lifting equipment for the lift plan rigging and material lists including specific hand tools. Prepare a step by step method statement detailing a safe systematic approach including the pickup point, route to be travelled and laydown area
• Allocate team roles and responsibilities for riggers, supervisors and fixed appliance operators that can be utilized for scenarios covering basic, intermediate and complex categories
• Prepare a sketch, scaled drawing or have the understanding how to add pictures to lift plans ensuring the lift team understands the location and system of the operation in addition to text information
• Oversee tasks for complex rigging and fleeting operations ensuring the team safely follow the step by step method statement in the lift plan pack
• Liaise with the management, supervisors and workforce levels of lifting operations by attending meetings, TBT’s, PTW meetings, site visits in a responsible competent manner
• Participation in debrief meeting with lift team and discuss lessons learned during specific task
WHO SHOULD ATTEND?
This Rigging and Fleeting Loads – Lift Planner course is designed for Plant Operators who require practical and theory training and / or assessment on a Rigging and Fleeting Loads – Lift Planner

CSCS (Construction Skills Certification Scheme)

NPORS Rigging and Fleeting Loads Lift Planner (N046)

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course information&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">It is envisaged that by the end of this course of training, the learner will be able to answer questions on and perform the following:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator.</li><li fr-original-style="" style="box-sizing: border-box;">Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used.</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify the major components of the machine and explain their functions.</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify key controls and explain their functions.</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational checks in accordance with manufacturers and legislative requirements.</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for plant mover use.</li><li fr-original-style="" style="box-sizing: border-box;">Prepare machinery for use and operate machinery safely and efficiently.</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;">Environmental considerations.</li><li fr-original-style="" style="box-sizing: border-box;">Storage and transport of machinery 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><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry requirements&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In order to be eligible to undertake NPORS testing.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Good understanding of spoken and written English.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">__________________________________________________________________________________</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Assessment&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Assessment will be to NPORS standards consisting of a theory test and practical test.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">__________________________________________________________________________________</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Certification</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">NPORS Traditional card &ndash; With the traditional card, there is no requirements to complete an NVQ, a five-year card is issued and after five years reassessment is required.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">NPORS CSCS &ndash; To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card, the candidate will be required to complete an NVQ in the specific item of plant.&nbsp;</p>

Course information 
It is envisaged that by the end of this course of training, the learner will be able to answer questions on and perform the following:
Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator.
Have a working knowledge of the manufacturer’s handbook for the particular machine to be used.
Be able to locate and identify the major components of the machine and explain their functions.
Be able to locate and identify key controls and explain their functions.
Conduct all pre-operational checks in accordance with manufacturers and legislative requirements.
Identify and maintain PPE appropriate for plant mover use.
Prepare machinery for use and operate machinery safely and efficiently.
Conduct all necessary safety checks at the work area.
Environmental considerations.
Storage and transport of machinery 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 
In order to be eligible to undertake NPORS testing.
Good understanding of spoken and written English.
__________________________________________________________________________________
Assessment 
Assessment will be to NPORS standards consisting of a theory test and practical test.
__________________________________________________________________________________
Certification
NPORS Traditional card – With the traditional card, there is no requirements to complete an NVQ, a five-year card is issued and after five years reassessment is required. 
NPORS CSCS – To ensure that the operator is able to receive the NPORS CSCS logo card, candidates must have completed the relevant health and safety test within the last 2 years of the test date. This will issue a trained operator card. To gain a competent operator card, the candidate will be required to complete an NVQ in the specific item of plant. 

NPORS Plant Mover - Non Operational Duties (N132)

<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

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 aimed at candidates that require the knowledge and practical skills to prepare, attach, guide and move suspended loads using a range of lifting accessories. It will enable the candidate to carry out their duties while complying with LOLER regulations.</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 Slinger Signaller</li><li fr-original-style="" style="box-sizing: border-box;">Conform to relevant regulations, legislation and manufacturers requirements as per technical data</li><li fr-original-style="" style="box-sizing: border-box;">Locate, identify and explain different types of lifting equipment and lifting accessories.</li><li fr-original-style="" style="box-sizing: border-box;">Explain their basic construction, uses, applications and their functions</li><li fr-original-style="" style="box-sizing: border-box;">Interpret and extract information on all relevant documentation</li><li fr-original-style="" style="box-sizing: border-box;">Undertake all pre-use checks on non-specialist lifting accessories and identify non-serviceable items</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;">Identify and explain centres of gravity and calculate estimated weights of loads</li><li fr-original-style="" style="box-sizing: border-box;">Set up exclusion zones explaining actions required for emergency actions and identifying any overhead hazards</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for Slinger Signaller use</li><li fr-original-style="" style="box-sizing: border-box;">Secure various types of loads to a hook using the relevant lifting accessories and procedures ensuring load balance, security and integrity</li><li fr-original-style="" style="box-sizing: border-box;">Direct and guide the movement of loads to different types of location using different methods of communication</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><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; 2 Days</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Experienced Worker Tests- 1 Day theory and practical assessment</p><h2 style="color: rgb(38, 49, 62); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);"><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 prepare, attach, guide and move suspended loads using a range of lifting accessories. It will enable the candidate to carry out their duties while complying with LOLER regulations.
Course Content
Candidates will be able to:
Understand the industry, the dangers of working in the industry and their responsibilities as a Slinger Signaller
Conform to relevant regulations, legislation and manufacturers requirements as per technical data
Locate, identify and explain different types of lifting equipment and lifting accessories.
Explain their basic construction, uses, applications and their functions
Interpret and extract information on all relevant documentation
Undertake all pre-use checks on non-specialist lifting accessories and identify non-serviceable items
Explain procedures for placing non-serviceable items out-of-service
Identify and explain centres of gravity and calculate estimated weights of loads
Set up exclusion zones explaining actions required for emergency actions and identifying any overhead hazards
Identify and maintain PPE appropriate for Slinger Signaller use
Secure various types of loads to a hook using the relevant lifting accessories and procedures ensuring load balance, security and integrity
Direct and guide the movement of loads to different types of location using different methods of communication
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 – 2 Days
Experienced Worker Tests- 1 Day theory and practical assessment
Location
Customer Site (Training & Testing) – Site must adhere to NPORS specifications

NPORS Slinger / Signaller (N402)

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

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

NPORS MEWP Boom (N108)

<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;This course is aimed at people who require the knowledge and practical skills needed to enable them to safely  operate and maintain a Multi Directional Lift Truck. We will conduct a learner analysis to identify the duration of training required for those with limited or no  experience, whereas experienced operators can attend a one day Experienced Worker Assessment (Test  Only).</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;Course information Overview</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;To provide knowledge and understanding in the following areas:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">&nbsp;Have a basic understanding of the industry, the dangers of working in the industry and their &nbsp;responsibilities as a plant operator</li><li fr-original-style="" style="box-sizing: border-box;">&nbsp;Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be &nbsp;used&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;"> Be able to locate and identify driving, steering and braking controls in each travel mode and &nbsp;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 &nbsp;requirements&nbsp;</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;">&nbsp;Start and stop the engine and safely move the machine off and stop it safely in each travel mode</li><li fr-original-style="" style="box-sizing: border-box;"> Configure the machine for travel and maneuver it safely laden and unladen, in open and &nbsp;confined areas in each travel mode</li><li fr-original-style="" style="box-sizing: border-box;"> Conduct all necessary safety checks at the work area&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Maneuver the machine to the work area and correctly configure in readiness to carry out &nbsp;lifting and load handling tasks using each travel mode as appropriate</li><li fr-original-style="" style="box-sizing: border-box;">&nbsp;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&nbsp;</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 &nbsp;transportation&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down procedures&nbsp;</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For learners applying for the NPORS CSCS Card, or for those requiring 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. Assessment NPORS Theory assessment made up of open questions and multiple choice. NPORS Practical assessment.</p>

Who should attend
 This course is aimed at people who require the knowledge and practical skills needed to enable them to safely operate and maintain a Multi Directional Lift Truck. We will conduct a learner analysis to identify the duration of training required for those with limited or no experience, whereas experienced operators can attend a one day Experienced Worker Assessment (Test Only).
 Course information Overview
 To provide knowledge and understanding in the following areas:
Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as a plant operator
Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
Be able to locate and identify the major components of the machine and explain their functions
Be able to locate and identify driving, steering and braking controls in each travel mode 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 in each travel mode
Configure the machine for travel and maneuver it safely laden and unladen, in open and confined areas in each travel mode
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 using each travel mode as appropriate
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 
For learners applying for the NPORS CSCS Card, or for those requiring 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. Assessment NPORS Theory assessment made up of open questions and multiple choice. NPORS Practical assessment.

NPORS Multi Directional Lift Truck (N135)

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

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

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

NPORS Rear Tipping Dumper (N205)

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

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

NPORS Forward Tipping Dumper (N204)

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

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

NPORS Road Roller (N214)

London

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

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

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

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

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

		<div> 
						 

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




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



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

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

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

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

PCWorkshops

Oracle SQL

Azure SQL Database

Microsoft SQL Server

Microsoft SQL

Database Programming

Computer Skills

SQL Server

MySQL

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

SQL Intermediate Course, 3 Days

General admission

<p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(37, 46, 57);">When it comes to designing our dream future, there are a few &nbsp;aspects to be considered...</p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);">Firstly, amongst the chaos, how often do we actually create space to think about what we genuinely want for ourselves?</p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);">And then when we do, are they our own desires, or someone else&#39;s?</p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Vision boards help you to gain clarity</strong>&nbsp;on what you truly want from life</p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);">I will teach you to&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">connect&nbsp;</strong>back in with your&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">core values,&nbsp;</strong>an overview behind&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">manifestation</strong>&nbsp;and how our early life experiences may have impacted us now (positively and negatively).</p><ul style="color: rgb(37, 46, 57); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><li fr-original-style="" style="box-sizing: border-box;">Experience a short meditation to clear and open the mind</li><li fr-original-style="" style="box-sizing: border-box;">Identify your big dreams and goals, your values and how this aligns with your identity and purpose.</li><li fr-original-style="" style="box-sizing: border-box;">Create your unique vision board from scratch.</li></ul><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);">The Workshop will be a hybrid of meditation, fun and networking helping you to connect back in with who you truly are, your centre of creativity, and visualise your dream life.</p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);">This is for you if you say yes to one or more of the following:</p><ul style="color: rgb(37, 46, 57); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><li fr-original-style="" style="box-sizing: border-box;">you are ready to explore what you want from life</li><li fr-original-style="" style="box-sizing: border-box;">you feel stuck and uninspired</li><li fr-original-style="" style="box-sizing: border-box;">you have a vision, but you want to have a daily reminder of your dreams and goals</li><li fr-original-style="" style="box-sizing: border-box;">you want to manifest your vision or dream life quicker</li><li fr-original-style="" style="box-sizing: border-box;">you would like to passionately connect with your goals and dreams</li><li fr-original-style="" style="box-sizing: border-box;">you would like to connect with your sacral chakra and instil some creativity into your energy</li></ul><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Are you ready to create the life that lights you up?</strong></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Resources required:</strong></em><em fr-original-style="" style="box-sizing: border-box;">&nbsp;</em></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">Everyone: Notepad + pen, quiet space for reflection.&nbsp;</em></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">If you know you definitely want to create your Vision Board on your Computer, then please come ready with access to Microsoft word or Canva. &nbsp;</em></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">Otherwise (and this is my favourite way to start a vision board experience), you will also need;</em></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">Access to images that you can cut out. &nbsp;Here are some ideas on building your portfolio of images:</em></p><ul style="color: rgb(37, 46, 57); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">buy your favourite magazine/ ask around your friends/ family if you can have it rather than being thrown away</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">local supermarkets that offer their free magazine</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">travel agents&nbsp;</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">keep hold of local magazines/ newspapers/ flyers dropped through the door</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">photos that you don&#39;t mind cutting up</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">celebratory cards</em></li></ul><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">Please also have access to A3 card (you can buy these from craft stores) ; scissors, glue.</em></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"></p><p style="color: rgb(37, 46, 57); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(37, 46, 57);"><em fr-original-style="" style="box-sizing: border-box;">You can go super creative here as much as you would like; feathers, sparkle. you could even connect with the outdoors if you know how to preseve your items.&nbsp;</em></p>

When it comes to designing our dream future, there are a few aspects to be considered...
Firstly, amongst the chaos, how often do we actually create space to think about what we genuinely want for ourselves?
And then when we do, are they our own desires, or someone else's?
Vision boards help you to gain clarity on what you truly want from life
I will teach you to connect back in with your core values, an overview behind manifestation and how our early life experiences may have impacted us now (positively and negatively).
Experience a short meditation to clear and open the mind
Identify your big dreams and goals, your values and how this aligns with your identity and purpose.
Create your unique vision board from scratch.
The Workshop will be a hybrid of meditation, fun and networking helping you to connect back in with who you truly are, your centre of creativity, and visualise your dream life.
This is for you if you say yes to one or more of the following:
you are ready to explore what you want from life
you feel stuck and uninspired
you have a vision, but you want to have a daily reminder of your dreams and goals
you want to manifest your vision or dream life quicker
you would like to passionately connect with your goals and dreams
you would like to connect with your sacral chakra and instil some creativity into your energy
Are you ready to create the life that lights you up?


Resources required: 
Everyone: Notepad + pen, quiet space for reflection. 

If you know you definitely want to create your Vision Board on your Computer, then please come ready with access to Microsoft word or Canva. 

Otherwise (and this is my favourite way to start a vision board experience), you will also need;

Access to images that you can cut out. Here are some ideas on building your portfolio of images:
buy your favourite magazine/ ask around your friends/ family if you can have it rather than being thrown away
local supermarkets that offer their free magazine
travel agents
keep hold of local magazines/ newspapers/ flyers dropped through the door
photos that you don't mind cutting up
celebratory cards

Please also have access to A3 card (you can buy these from craft stores) ; scissors, glue.

You can go super creative here as much as you would like; feathers, sparkle. you could even connect with the outdoors if you know how to preseve your items. 

Sinéad Robertson

Personal Development

Mindfulness

Life Coaching

Manifestation & Law of Attraction

Meditation

Creative Therapy

𝐃𝐢𝐝 𝐘𝐨𝐮 𝐤𝐧𝐨𝐰?
😍Vision Boards improves your chance of success! 
Here's just a few benefits from the process of vision boarding ⤵️
🔸 Helps you to connect with what you truly want from life;
🔸 Shift your mindset;
🔸 Provides a tool to align and focus your goals
And are a great opportunity to meet new and like minded people!
I'm looking forward to hosting this vision board workshop with you.  
🙏🏻Give me a shout if you have any questions.

Design your Dream Life Vision Board

General Admission

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

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

I Am In Print

Fiction Writing

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

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is designed for software developers, testers, and architects who design and develop software in various programming languages and platforms, including desktop, web, cloud, and mobile, and who want to improve their ability to deliver software that is of high quality, particularly regarding security and privacy.<br />This course is also designed for students who are seeking the CertNexus Cyber Secure Coder (CSC) Exam CSC-210 certification</p>Overview<p>In this course, you will employ best practices in software development to develop secure software.You will:<br />Identify the need for security in your software projects.<br />Eliminate vulnerabilities within software.<br />Use a Security by Design approach to design a secure architecture for your software.<br />Implement common protections to protect users and data.<br />Apply various testing methods to find and correct security defects in your software.<br />Maintain deployed software to ensure ongoing security...</p><p>The stakes for software security are very high, and yet many development teams deal with software security only after the code has been developed and the software is being prepared for delivery. As with any aspect of software quality, to ensure successful implementation, security and privacy issues should be managed throughout the entire software development lifecycle. <br />This course presents an approach for dealing with security and privacy throughout the entire software development lifecycle. You will learn about vulnerabilities that undermine security, and how to identify and remediate them in your own projects. You will learn general strategies for dealing with security defects and misconfiguration, how to design software to deal with the human element in security, and how to incorporate security into all phases of development.<br /></p></div><div id="course-pills-2"><h4>Identifying the Need for Security in Your Software Projects</h4><ul><li>Identify Security Requirements and Expectations</li><li>Identify Factors That Undermine Software Security</li><li>Find Vulnerabilities in Your Software</li><li>Gather Intelligence on Vulnerabilities and Exploits</li></ul><h4>Handling Vulnerabilities</h4><ul><li>Handle Vulnerabilities Due to Software Defects and Misconfiguration</li><li>Handle Vulnerabilities Due to Human Factors</li><li>Handle Vulnerabilities Due to Process Shortcomings</li></ul><h4>Designing for Security</h4><ul><li>Apply General Principles for Secure Design</li><li>Design Software to Counter Specific Threats</li></ul><h4>Developing Secure Code</h4><ul><li>Follow Best Practices for Secure Coding</li><li>Prevent Platform Vulnerabilities</li><li>Prevent Privacy Vulnerabilities</li></ul><h4>Implementing Common Protections</h4><ul><li>Limit Access Using Login and User Roles</li><li>Protect Data in Transit and At Rest</li><li>Implement Error Handling and Logging</li><li>Protect Sensitive Data and Functions</li><li>Protect Database Access</li></ul><h4>Testing Software Security</h4><ul><li>Perform Security Testing</li><li>Analyze Code to find Security Problems</li><li>Use Automated Testing Tools to Find Security Problems</li></ul><h4>Maintaining Security in Deployed Software</h4><ul><li>Monitor and Log Applications to Support Security</li><li>Maintain Security after Deployment</li></ul></div>

Duration
3 Days
18 CPD hours
This course is intended for
This course is designed for software developers, testers, and architects who design and develop software in various programming languages and platforms, including desktop, web, cloud, and mobile, and who want to improve their ability to deliver software that is of high quality, particularly regarding security and privacy.
This course is also designed for students who are seeking the CertNexus Cyber Secure Coder (CSC) Exam CSC-210 certification
Overview
In this course, you will employ best practices in software development to develop secure software.You will:
Identify the need for security in your software projects.
Eliminate vulnerabilities within software.
Use a Security by Design approach to design a secure architecture for your software.
Implement common protections to protect users and data.
Apply various testing methods to find and correct security defects in your software.
Maintain deployed software to ensure ongoing security...
The stakes for software security are very high, and yet many development teams deal with software security only after the code has been developed and the software is being prepared for delivery. As with any aspect of software quality, to ensure successful implementation, security and privacy issues should be managed throughout the entire software development lifecycle. 
This course presents an approach for dealing with security and privacy throughout the entire software development lifecycle. You will learn about vulnerabilities that undermine security, and how to identify and remediate them in your own projects. You will learn general strategies for dealing with security defects and misconfiguration, how to design software to deal with the human element in security, and how to incorporate security into all phases of development.

Identifying the Need for Security in Your Software Projects
Identify Security Requirements and Expectations
Identify Factors That Undermine Software Security
Find Vulnerabilities in Your Software
Gather Intelligence on Vulnerabilities and Exploits
Handling Vulnerabilities
Handle Vulnerabilities Due to Software Defects and Misconfiguration
Handle Vulnerabilities Due to Human Factors
Handle Vulnerabilities Due to Process Shortcomings
Designing for Security
Apply General Principles for Secure Design
Design Software to Counter Specific Threats
Developing Secure Code
Follow Best Practices for Secure Coding
Prevent Platform Vulnerabilities
Prevent Privacy Vulnerabilities
Implementing Common Protections
Limit Access Using Login and User Roles
Protect Data in Transit and At Rest
Implement Error Handling and Logging
Protect Sensitive Data and Functions
Protect Database Access
Testing Software Security
Perform Security Testing
Analyze Code to find Security Problems
Use Automated Testing Tools to Find Security Problems
Maintaining Security in Deployed Software
Monitor and Log Applications to Support Security
Maintain Security after Deployment

Nexus Human

Certified in Cybersecurity (CC)

Certificate in Information Security Management Principles (CISMP)

Cyber Security

Cyber Security Foundation

Certified Cyber Professional (CCP)

CompTIA Security+

CertNexus Certified Cyber Secure Coder (CSC-210)

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p></p><p>The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.</p><p></p><p></p><p>This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.</p><p></p>Prerequisites<p></p><li>Understanding core data concepts.</li>  <li>Knowledge of working with relational data in the cloud.</li>  <li>Knowledge of working with non-relational data in the cloud.</li>   <li>Knowledge of data analysis and visualization concepts.</li>   <li>DP-900T00 Microsoft Azure Data Fundamentals is recommended<p></p></li></div><div id="course-pills-2"><h3>1 - Discover data analysis</h3> <ul> <li>Overview of data analysis</li> <li>Roles in data</li> <li>Tasks of a data analyst</li> </ul> <h3>2 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>3 - Get data in Power BI</h3> <ul> <li>Get data from files</li> <li>Get data from relational data sources</li> <li>Create dynamic reports with parameters</li> <li>Get data from a NoSQL database</li> <li>Get data from online services</li> <li>Select a storage mode</li> <li>Get data from Azure Analysis Services</li> <li>Fix performance issues</li> <li>Resolve data import errors</li> </ul> <h3>4 - Clean, transform, and load data in Power BI</h3> <ul> <li>Shape the initial data</li> <li>Simplify the data structure</li> <li>Evaluate and change column data types</li> <li>Combine multiple tables into a single table</li> <li>Profile data in Power BI</li> <li>Use Advanced Editor to modify M code</li> </ul> <h3>5 - Design a semantic model in Power BI</h3> <ul> <li>Work with tables</li> <li>Create a date table</li> <li>Work with dimensions</li> <li>Define data granularity</li> <li>Work with relationships and cardinality</li> <li>Resolve modeling challenges</li> </ul> <h3>6 - Add measures to Power BI Desktop models</h3> <ul> <li>Create simple measures</li> <li>Create compound measures</li> <li>Create quick measures</li> <li>Compare calculated columns with measures</li> </ul> <h3>7 - Add calculated tables and columns to Power BI Desktop models</h3> <ul> <li>Create calculated columns</li> <li>Learn about row context</li> <li>Choose a technique to add a column</li> </ul> <h3>8 - Use DAX time intelligence functions in Power BI Desktop models</h3> <ul> <li>Use DAX time intelligence functions</li> <li>Additional time intelligence calculations</li> </ul> <h3>9 - Optimize a model for performance in Power BI</h3> <ul> <li>Review performance of measures, relationships, and visuals</li> <li>Use variables to improve performance and troubleshooting</li> <li>Reduce cardinality</li> <li>Optimize DirectQuery models with table level storage</li> <li>Create and manage aggregations</li> </ul> <h3>10 - Design Power BI reports</h3> <ul> <li>Design the analytical report layout</li> <li>Design visually appealing reports</li> <li>Report objects</li> <li>Select report visuals</li> <li>Select report visuals to suit the report layout</li> <li>Format and configure visualizations</li> <li>Work with key performance indicators</li> </ul> <h3>11 - Configure Power BI report filters</h3> <ul> <li>Apply filters to the report structure</li> <li>Apply filters with slicers</li> <li>Design reports with advanced filtering techniques</li> <li>Consumption-time filtering</li> <li>Select report filter techniques</li> <li>Case study - Configure report filters based on feedback</li> </ul> <h3>12 - Enhance Power BI report designs for the user experience</h3> <ul> <li>Design reports to show details</li> <li>Design reports to highlight values</li> <li>Design reports that behave like apps</li> <li>Work with bookmarks</li> <li>Design reports for navigation</li> <li>Work with visual headers</li> <li>Design reports with built-in assistance</li> <li>Tune report performance</li> <li>Optimize reports for mobile use</li> </ul> <h3>13 - Perform analytics in Power BI</h3> <ul> <li>Explore statistical summary</li> <li>Identify outliers with Power BI visuals</li> <li>Group and bin data for analysis</li> <li>Apply clustering techniques</li> <li>Conduct time series analysis</li> <li>Use the Analyze feature</li> <li>Create what-if parameters</li> <li>Use specialized visuals</li> </ul> <h3>14 - Create and manage workspaces in Power BI</h3> <ul> <li>Distribute a report or dashboard</li> <li>Monitor usage and performance</li> <li>Recommend a development life cycle strategy</li> <li>Troubleshoot data by viewing its lineage</li> <li>Configure data protection</li> </ul> <h3>15 - Manage semantic models in Power BI</h3> <ul> <li>Use a Power BI gateway to connect to on-premises data sources</li> <li>Configure a semantic model scheduled refresh</li> <li>Configure incremental refresh settings</li> <li>Manage and promote semantic models</li> <li>Troubleshoot service connectivity</li> <li>Boost performance with query caching (Premium)</li> </ul> <h3>16 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>17 - Implement row-level security</h3> <ul> <li>Configure row-level security with the static method</li> <li>Configure row-level security with the dynamic method</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-300T00: Microsoft Power BI Data Analyst 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-300T00: Microsoft Power BI Data Analyst course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Duration
3 Days
18 CPD hours
This course is intended for

The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.


This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

Prerequisites

Understanding core data concepts.
Knowledge of working with relational data in the cloud.
Knowledge of working with non-relational data in the cloud.
Knowledge of data analysis and visualization concepts.
DP-900T00 Microsoft Azure Data Fundamentals is recommended
1 - Discover data analysis
Overview of data analysis
Roles in data
Tasks of a data analyst
2 - Get started building with Power BI
Use Power BI
Building blocks of Power BI
Tour and use the Power BI service
3 - Get data in Power BI
Get data from files
Get data from relational data sources
Create dynamic reports with parameters
Get data from a NoSQL database
Get data from online services
Select a storage mode
Get data from Azure Analysis Services
Fix performance issues
Resolve data import errors
4 - Clean, transform, and load data in Power BI
Shape the initial data
Simplify the data structure
Evaluate and change column data types
Combine multiple tables into a single table
Profile data in Power BI
Use Advanced Editor to modify M code
5 - Design a semantic model in Power BI
Work with tables
Create a date table
Work with dimensions
Define data granularity
Work with relationships and cardinality
Resolve modeling challenges
6 - Add measures to Power BI Desktop models
Create simple measures
Create compound measures
Create quick measures
Compare calculated columns with measures
7 - Add calculated tables and columns to Power BI Desktop models
Create calculated columns
Learn about row context
Choose a technique to add a column
8 - Use DAX time intelligence functions in Power BI Desktop models
Use DAX time intelligence functions
Additional time intelligence calculations
9 - Optimize a model for performance in Power BI
Review performance of measures, relationships, and visuals
Use variables to improve performance and troubleshooting
Reduce cardinality
Optimize DirectQuery models with table level storage
Create and manage aggregations
10 - Design Power BI reports
Design the analytical report layout
Design visually appealing reports
Report objects
Select report visuals
Select report visuals to suit the report layout
Format and configure visualizations
Work with key performance indicators
11 - Configure Power BI report filters
Apply filters to the report structure
Apply filters with slicers
Design reports with advanced filtering techniques
Consumption-time filtering
Select report filter techniques
Case study - Configure report filters based on feedback
12 - Enhance Power BI report designs for the user experience
Design reports to show details
Design reports to highlight values
Design reports that behave like apps
Work with bookmarks
Design reports for navigation
Work with visual headers
Design reports with built-in assistance
Tune report performance
Optimize reports for mobile use
13 - Perform analytics in Power BI
Explore statistical summary
Identify outliers with Power BI visuals
Group and bin data for analysis
Apply clustering techniques
Conduct time series analysis
Use the Analyze feature
Create what-if parameters
Use specialized visuals
14 - Create and manage workspaces in Power BI
Distribute a report or dashboard
Monitor usage and performance
Recommend a development life cycle strategy
Troubleshoot data by viewing its lineage
Configure data protection
15 - Manage semantic models in Power BI
Use a Power BI gateway to connect to on-premises data sources
Configure a semantic model scheduled refresh
Configure incremental refresh settings
Manage and promote semantic models
Troubleshoot service connectivity
Boost performance with query caching (Premium)
16 - Create dashboards in Power BI
Configure data alerts
Explore data by asking questions
Review Quick insights
Add a dashboard theme
Pin a live report page to a dashboard
Configure a real-time dashboard
Set mobile view
17 - Implement row-level security
Configure row-level security with the static method
Configure row-level security with the dynamic method
Additional course details:
Nexus Humans PL-300T00: Microsoft Power BI Data Analyst 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-300T00: Microsoft Power BI Data Analyst 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.


Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Microsoft Power Platform

Microsoft BI

Data Analyst

PL-300T00 Microsoft Power BI Data Analyst

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

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

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

Microsoft Certification

Sccm

Microsoft Certified Technology Specialist (MCTS)

Microsoft SC-100

Commercial & Contract Management Certification Program (CCM)

Microsoft SC-200

55133 PowerShell for System Center Configuration Manager Administrators

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is designed for Administrators who need to setup, configure and manage SharePoint Online as part of their Office 365 Administration.</p>Overview<p>After completing this course, students will gain the skills to:  - Understand the architecture of SharePoint Online  - Have knowledge of all the components in SharePoint Online  - Have on hands on experience configuring the components of SharePoint Online  - Have hands on experience configuring the options  - Work with Site Collections and storage options  - Manage user profiles and social profiling  - Understand and configure data connectivity in SharePoint Online  - Build a taxonomy structure   - Understand and configure Search in SharePoint Online  - Configure and deploy apps  - Understand and define Enterprise content management and data loss prevention.  - Configure additional options and features in SharePoint Online such as Information Rights Management</p><p>This course will introduce the audience to SharePoint Online Administration in Office 365 and explain and demonstrate the configuration options for SharePoint Online. The course is appropriate for existing SharePoint on-premises administrators and new administrators to Office 365 who need to understand how to correctly setup SharePoint Online for their company. The course will also help SharePoint on-premise administrators understand the differences between SharePoint on-premises and SharePoint Online.</p></div><div id="course-pills-2"><h3>1 - INTRODUCTION TO OFFICE 365 AND SHAREPOINT ONLINE</h3> <ul> <li>Introduction to the Office 365 Administration Center</li> <li>Configure Reporting</li> <li>Accessing SharePoint management tools</li> <li>Accessing security and compliancy</li> <li>Managing Office 365 and SharePoint Online with PowerShell</li> <li>Comparing On Premises SharePoint with SharePoint Online</li> <li>User identity in Office 365 and SharePoint Online</li> <li>Manging user domains</li> <li>Building Hybrid scenarios</li> <li>OneDrive and Sites redirection</li> <li>Yammer redirection</li> <li>Understand hybrid search</li> <li>Hybrid business data connectivity</li> <li>Hybrid taxonomy</li> </ul> <h3>2 - WORKING WITH SITE COLLECTIONS</h3> <ul> <li>Introduction to classic and modern admin centers</li> <li>Creating Site Collections</li> <li>Defining ownership and security for site collections</li> <li>Configuring Storage</li> <li>Configure External Access to site collections</li> <li>Recovering site collections</li> <li>Configure external sharing</li> <li>Managing site collections with PowerShell</li> </ul> <h3>3 - MANAGING USER PROFILES</h3> <ul> <li>Overview of the profile service</li> <li>Defining profile properties</li> <li>Map profile properties to a term store</li> <li>Creating custom profile properties</li> <li>Managing audiences</li> <li>Creating audiences</li> <li>Managing user profile policies</li> <li>Configure trusted my site host locations</li> <li>Configure preferred search center locations</li> <li>Defining read access permission levels</li> <li>Configuring newsfeed options</li> <li>Setup email notifications</li> <li>Configure my site cleanup</li> </ul> <h3>4 - WORKING WITH DATA CONNECTIONS</h3> <ul> <li>Introduction to Data Connections</li> <li>Overview of PowerApps, Flow and PowerBi</li> <li>Overview of the business connectivity service</li> <li>Introduction to BDC definition files</li> <li>Creating BDC definition files</li> <li>Introduction to the secure store service</li> <li>Configuring the secure store service</li> <li>Creating secure store target application settings</li> <li>Configure connections to cloud services</li> <li>Configure connections to on-premises services</li> <li>Tools to build data connections</li> <li>Creating external content types</li> <li>Building external lists using external data</li> </ul> <h3>5 - MANAGING THE TERM STORE</h3> <ul> <li>Overview of the term store</li> <li>Understanding terms and life cycle management</li> <li>Creating term groups</li> <li>Creating the term store</li> <li>Creating Term Sets in the UI</li> <li>Creating Term Sets via importing via a CSV</li> <li>Creating terms in the UI</li> <li>Creating terms via PowerShell and CSOM</li> <li>Manage terms with synonyms and pinning</li> <li>Configure delegated administration</li> </ul> <h3>6 - CONFIGURING SEARCH</h3> <ul> <li>An Introduction to the search service</li> <li>Classic versus Modern search experience</li> <li>Understanding Managed Properties</li> <li>Create Managed Properties</li> <li>Manage Authoritative pages</li> <li>Understand Result sources</li> <li>Create and configure result sources</li> <li>Understand Query rules</li> <li>Promoting results through query rules</li> <li>Remove search results from the index</li> <li>Exporting search configurations</li> <li>Importing search configurations</li> </ul> <h3>7 - CONFIGURING APPS</h3> <ul> <li>An Introduction to Apps</li> <li>Understanding the App Catalog</li> <li>Building the App catalog</li> <li>Adding Apps to the catalog</li> <li>Add Apps to your SharePoint sites</li> <li>Adding Apps via the marketplace store</li> <li>Manage App licensing</li> <li>Configure store access settings</li> <li>Monitoring app usage</li> </ul> <h3>8 - ENTERPRISE CONTENT MANAGEMENT IN SHAREPOINT ONLINE</h3> <ul> <li>An Introduction to ECM in SharePoint Online</li> <li>Components of ECM</li> <li>Office 365 versus classic compliancy</li> <li>Understanding In-Place records management</li> <li>Configure In-Place records management</li> <li>Understanding the records center</li> <li>Build and configure a records center</li> <li>Understanding the compliancy policy center</li> <li>Build a compliancy policy center and configure policies</li> <li>Discover the security and compliancy center</li> <li>Configure an eDiscovery center</li> <li>Build an eDiscovery case</li> <li>Understand data loss prevention</li> <li>Build a data loss prevention policy and query</li> <li>Working with classification and data governance</li> </ul> <h3>9 - MANAGE OPTIONS FOR SHAREPOINT ONLINE</h3> <ul> <li>Configure OneDrive features</li> <li>Configure use of Yammer or Newsfeeds</li> <li>Understand Information Rights Management</li> <li>Configure Information Rights Management</li> <li>Define site classification options</li> <li>Understand early release options for Office 365</li> <li>Configure Early release options for your Office 365 tenant</li> <li>Manage Access Control</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55238 SharePoint Online for Administrators 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 55238 SharePoint Online for Administrators course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Duration
3 Days
18 CPD hours
This course is intended for
This course is designed for Administrators who need to setup, configure and manage SharePoint Online as part of their Office 365 Administration.
Overview
After completing this course, students will gain the skills to: - Understand the architecture of SharePoint Online - Have knowledge of all the components in SharePoint Online - Have on hands on experience configuring the components of SharePoint Online - Have hands on experience configuring the options - Work with Site Collections and storage options - Manage user profiles and social profiling - Understand and configure data connectivity in SharePoint Online - Build a taxonomy structure - Understand and configure Search in SharePoint Online - Configure and deploy apps - Understand and define Enterprise content management and data loss prevention. - Configure additional options and features in SharePoint Online such as Information Rights Management
This course will introduce the audience to SharePoint Online Administration in Office 365 and explain and demonstrate the configuration options for SharePoint Online. The course is appropriate for existing SharePoint on-premises administrators and new administrators to Office 365 who need to understand how to correctly setup SharePoint Online for their company. The course will also help SharePoint on-premise administrators understand the differences between SharePoint on-premises and SharePoint Online.
1 - INTRODUCTION TO OFFICE 365 AND SHAREPOINT ONLINE
Introduction to the Office 365 Administration Center
Configure Reporting
Accessing SharePoint management tools
Accessing security and compliancy
Managing Office 365 and SharePoint Online with PowerShell
Comparing On Premises SharePoint with SharePoint Online
User identity in Office 365 and SharePoint Online
Manging user domains
Building Hybrid scenarios
OneDrive and Sites redirection
Yammer redirection
Understand hybrid search
Hybrid business data connectivity
Hybrid taxonomy
2 - WORKING WITH SITE COLLECTIONS
Introduction to classic and modern admin centers
Creating Site Collections
Defining ownership and security for site collections
Configuring Storage
Configure External Access to site collections
Recovering site collections
Configure external sharing
Managing site collections with PowerShell
3 - MANAGING USER PROFILES
Overview of the profile service
Defining profile properties
Map profile properties to a term store
Creating custom profile properties
Managing audiences
Creating audiences
Managing user profile policies
Configure trusted my site host locations
Configure preferred search center locations
Defining read access permission levels
Configuring newsfeed options
Setup email notifications
Configure my site cleanup
4 - WORKING WITH DATA CONNECTIONS
Introduction to Data Connections
Overview of PowerApps, Flow and PowerBi
Overview of the business connectivity service
Introduction to BDC definition files
Creating BDC definition files
Introduction to the secure store service
Configuring the secure store service
Creating secure store target application settings
Configure connections to cloud services
Configure connections to on-premises services
Tools to build data connections
Creating external content types
Building external lists using external data
5 - MANAGING THE TERM STORE
Overview of the term store
Understanding terms and life cycle management
Creating term groups
Creating the term store
Creating Term Sets in the UI
Creating Term Sets via importing via a CSV
Creating terms in the UI
Creating terms via PowerShell and CSOM
Manage terms with synonyms and pinning
Configure delegated administration
6 - CONFIGURING SEARCH
An Introduction to the search service
Classic versus Modern search experience
Understanding Managed Properties
Create Managed Properties
Manage Authoritative pages
Understand Result sources
Create and configure result sources
Understand Query rules
Promoting results through query rules
Remove search results from the index
Exporting search configurations
Importing search configurations
7 - CONFIGURING APPS
An Introduction to Apps
Understanding the App Catalog
Building the App catalog
Adding Apps to the catalog
Add Apps to your SharePoint sites
Adding Apps via the marketplace store
Manage App licensing
Configure store access settings
Monitoring app usage
8 - ENTERPRISE CONTENT MANAGEMENT IN SHAREPOINT ONLINE
An Introduction to ECM in SharePoint Online
Components of ECM
Office 365 versus classic compliancy
Understanding In-Place records management
Configure In-Place records management
Understanding the records center
Build and configure a records center
Understanding the compliancy policy center
Build a compliancy policy center and configure policies
Discover the security and compliancy center
Configure an eDiscovery center
Build an eDiscovery case
Understand data loss prevention
Build a data loss prevention policy and query
Working with classification and data governance
9 - MANAGE OPTIONS FOR SHAREPOINT ONLINE
Configure OneDrive features
Configure use of Yammer or Newsfeeds
Understand Information Rights Management
Configure Information Rights Management
Define site classification options
Understand early release options for Office 365
Configure Early release options for your Office 365 tenant
Manage Access Control
Additional course details:
Nexus Humans 55238 SharePoint Online for Administrators 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 55238 SharePoint Online for Administrators 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.


Microsoft Sharepoint

Microsoft 365

Microsoft AZ-104

SharePoint

Microsoft AZ-303

55238 SharePoint Online for Administrators

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.</p><p></p><p></p><p>This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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
2 Days
12 CPD hours
This course is intended for

This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.


This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

1 - Introduction to Transact-SQL
Work with schemas
Explore the structure of SQL statements
Examine the SELECT statement
Work with data types
Handle NULLs
2 - Sort and filter results in T-SQL
Sort your results
Limit the sorted results
Page results
Remove duplicates
Filter data with predicates
3 - Combine multiple tables with JOINs in T-SQL
Understand joins concepts and syntax
Use inner joins
Use outer joins
Use cross joins
Use self joins
4 - Write Subqueries in T-SQL
Understand subqueries
Use scalar or multi-valued subqueries
Use self-contained or correlated subqueries
5 - Use built-in functions and GROUP BY in Transact-SQL
Categorize built-in functions
Use scalar functions
Use ranking and rowset functions
Use aggregate functions
Summarize data with GROUP BY
Filter groups with HAVING
6 - Modify data with T-SQL
Insert data
Generate automatic values
Update data
Delete data
Merge data based on multiple tables
Additional course details:
Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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.


Learning & Development

Design & Technology Courses (DT)

Data Skills

Trainers Course

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

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

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

Excel Analytics

Data Analysis Expressions

Introduction to DAX for Power BI

<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);">In this half day online course Gabriella Bettiga, an examiner of the Law Society Immigration and Asylum Accreditation Scheme, will assist candidates in preparing for the forthcoming initial <span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Casework Assistant exam. &nbsp;This course will cover:</span></p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The exam format and content, including the pass mark, advance materials and exam techniques</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The syllabus topics, including professional conduct, drafting and English and legal practice</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">An overview of syllabus topics, including Legal Aid, Specialist Immigration Practice, Appeal and Administrative Review, Detention, Deportation and Removal, Judicial Review, Human Rights and Asylum support</li></ul><h2 data-key="21" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="22" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="22:0" fr-original-style="" style="box-sizing: border-box;">Target Audience</span></span></h2><p data-key="23" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMlRhcmdldCUyMEF1ZGllbmNlJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyVGhlJTIwb25saW5lJTIwY291cnNlJTIwaXMlMjBzdWl0YWJsZSUyMGZvciUyMHN0YWZmJTIwb2YlMjBhbGwlMjBsZXZlbHMlMkMlMjBmcm9tJTIwc3VwcG9ydCUyMHN0YWZmJTIwdG8lMjBzZW5pb3IlMjBwYXJ0bmVycy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">The course is suitable for candidates preparing for the Law Society&#39;s initial <span style="font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 16px;">Casework Assistant </span><span style="font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 16px;"><a href="https://www.lawsociety.org.uk/career-advice/individual-accreditations/immigration-and-asylum-law-accreditation/how-to-apply" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">exam</a></span>.</p><h2 data-key="26" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Resources</h2><p data-key="28" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" 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);">A copy of the course slides will be provided to all delegates after the event which may be useful for ongoing reference.</span></p><p data-key="30" data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJoZWFkaW5nLXRocmVlJTIyJTJDJTIyZGF0YSUyMiUzQSU3QiUyMmNsYXNzTmFtZSUyMiUzQW51bGwlN0QlMkMlMjJub2RlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMnRleHQlMjIlMkMlMjJsZWF2ZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMkNvdXJzZSUyME5vdGVzJTIyJTJDJTIybWFya3MlMjIlM0ElNUIlNUQlN0QlNUQlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQ29tcHJlaGVuc2l2ZSUyMGFuZCUyMHVwJTIwdG8lMjBkYXRlJTIwY291cnNlJTIwbm90ZXMlMjB3aWxsJTIwYmUlMjBwcm92aWRlZCUyMHRvJTIwYWxsJTIwZGVsZWdhdGVzJTIwd2hpY2glMjBtYXklMjBiZSUyMHVzZWZ1bCUyMGZvciUyMG9uZ29pbmclMjByZWZlcmVuY2UlMjBvciUyMGNhc2NhZGUlMjB0cmFpbmluZy4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCUyQyU3QiUyMm9iamVjdCUyMiUzQSUyMmJsb2NrJTIyJTJDJTIydHlwZSUyMiUzQSUyMnBhcmFncmFwaCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlMjJjbGFzc05hbWUlMjIlM0FudWxsJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJ0ZXh0JTIyJTJDJTIybGVhdmVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJQbGVhc2UlMjBub3RlJTIwYSUyMHJlY29yZGluZyUyMG9mJTIwdGhlJTIwY291cnNlJTIwd2lsbCUyMCUyMiUyQyUyMm1hcmtzJTIyJTNBJTVCJTVEJTdEJTJDJTdCJTIyb2JqZWN0JTIyJTNBJTIybGVhZiUyMiUyQyUyMnRleHQlMjIlM0ElMjJub3QlMjAlMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMm1hcmslMjIlMkMlMjJ0eXBlJTIyJTNBJTIyYm9sZCUyMiUyQyUyMmRhdGElMjIlM0ElN0IlN0QlN0QlNUQlN0QlMkMlN0IlMjJvYmplY3QlMjIlM0ElMjJsZWFmJTIyJTJDJTIydGV4dCUyMiUzQSUyMmJlJTIwbWFkZSUyMGF2YWlsYWJsZS4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="31" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="31:0" fr-original-style="" style="box-sizing: border-box;">Please note a recording of the course will&nbsp;</span><span data-offset-key="31:1" fr-original-style="" style="box-sizing: border-box;"><strong data-slate-leaf="true" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">not&nbsp;</strong></span><span data-offset-key="31:2" fr-original-style="" style="box-sizing: border-box;">be made available.</span></span></p><h2 data-key="35" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span data-key="36" fr-original-style="" style="box-sizing: border-box;"><span data-offset-key="36:0" fr-original-style="" style="box-sizing: border-box;">Speaker</span></span></h2><h3 data-key="37" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><a href="https://dglegal.co.uk/the-team/gabriella-bettiga/" style="color: rgb(0, 171, 201); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(0, 171, 201);">Gabriella Bettiga, Lecturer, DG Legal</a></strong></h3><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);">Gabriella is a solicitor and qualified Italian lawyer. &nbsp; She is accredited as an Advanced Caseworker with the Law Society IASS Scheme and as a Level 3 OISC advisor.</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);">Gabriella is the founding Director of MGBe Legal, a firm dealing with personal and business migration, and a member of the Tribunal Procedure Committee.</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);">She has been Chair of the Independent Cost and Funding Adjudicators at the Legal Aid Agency for many years, and is an ILPA trustee and a supervisor at Rainbow Migration. She regularly delivers training and writes articles on immigration for national and international publications.</p>

In this half day online course Gabriella Bettiga, an examiner of the Law Society Immigration and Asylum Accreditation Scheme, will assist candidates in preparing for the forthcoming initial Casework Assistant exam. This course will cover:
The exam format and content, including the pass mark, advance materials and exam techniques
The syllabus topics, including professional conduct, drafting and English and legal practice
An overview of syllabus topics, including Legal Aid, Specialist Immigration Practice, Appeal and Administrative Review, Detention, Deportation and Removal, Judicial Review, Human Rights and Asylum support
Target Audience
The course is suitable for candidates preparing for the Law Society's initial Casework Assistant exam.
Resources
A copy of the course slides will be provided to all delegates after the event which may be useful for ongoing reference.
Please note a recording of the course will not be made available.
Speaker
Gabriella Bettiga, Lecturer, DG Legal
Gabriella is a solicitor and qualified Italian lawyer. She is accredited as an Advanced Caseworker with the Law Society IASS Scheme and as a Level 3 OISC advisor.
Gabriella is the founding Director of MGBe Legal, a firm dealing with personal and business migration, and a member of the Tribunal Procedure Committee.
She has been Chair of the Independent Cost and Funding Adjudicators at the Legal Aid Agency for many years, and is an ILPA trustee and a supervisor at Rainbow Migration. She regularly delivers training and writes articles on immigration for national and international publications.

DG Legal

Immigration Law

This half day online course will assist candidates in preparing for the forthcoming initial Casework Assistant exam. 

IAAS: Casework Assistant Exam Preparation Course

General Delegate

A discount is available for delegates attending from firms with a current retainer contract with DG Legal (please contact us by email to admin@dglegal.co.uk for confirmation of eligibility).   If you choose this option and are not eligible, you are still bound to pay the full rate and will be invoiced accordingly.

1604 PE courses in Manchester

NPORS Crawler Crane (N103)

By Dynamic Training and Assessments Ltd

NPORS Rigging and Fleeting Loads Lift Planner (N046)

By Dynamic Training and Assessments Ltd

NPORS Plant Mover - Non Operational Duties (N132)

By Dynamic Training and Assessments Ltd

NPORS Excavator as a Crane (N100)

By Dynamic Training and Assessments Ltd

NPORS Slinger / Signaller (N402)

By Dynamic Training and Assessments Ltd

NPORS MEWP Boom (N108)

By Dynamic Training and Assessments Ltd

NPORS Multi Directional Lift Truck (N135)

By Dynamic Training and Assessments Ltd

NPORS Rear Tipping Dumper (N205)

By Dynamic Training and Assessments Ltd

NPORS Forward Tipping Dumper (N204)

By Dynamic Training and Assessments Ltd

NPORS Road Roller (N214)

By Dynamic Training and Assessments Ltd

Search By Location