London

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Why Learn Rhino Introduction to Intermediate</strong><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Learn Rhino, a leading commercial 3D design software, with our expert-led courses. Perfect for aspiring professionals in architecture, industrial, product, and graphic design. Gain practical skills and create high-quality designs under expert guidance.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://www.realanimationworks.com/product-page/Rhino-Introduction-to-Intermediate-course" 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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><u fr-original-style="" style="box-sizing: border-box;">Check our Website</u></strong></a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Duration:&nbsp;</strong><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">10 hrs.</span><br 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;" fr-original-style=" color: rgb(0, 0, 0);">How:</strong><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">&nbsp;Personalized 1-on-1 hands-on training.</span><br 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;" fr-original-style=" color: rgb(0, 0, 0);">When:&nbsp;</strong><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Choose seny day and anytime&nbsp;</span><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Mon-Sat, 9 am-7 pm</strong>
        </p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Who Should Enroll?<br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"></strong><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Rhino 3D Introduction to Intermediate Course is designed for individuals aiming to enhance their 2D and 3D modeling abilities within a creative setting. Whether you&#39;re aspiring to advance your creative career or secure opportunities in product, furniture design, architectural, or jewelry design, this course provides valuable skills.</span><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"></strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Duration:</strong><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;10 Hrs.</strong></span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">When:&nbsp;<span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Choose anyday and anytime Monday to Saturday 9 am to 7 pm.</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Method:<span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">&nbsp;1 on 1 in-person or Live online.</span><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Introduction to Rhino&nbsp;</strong></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;">Rhino&rsquo;s commands</li><li fr-original-style="" style="box-sizing: border-box;">Exploring toolbars and buttons</li><li fr-original-style="" style="box-sizing: border-box;">Geometry menus</li><li fr-original-style="" style="box-sizing: border-box;">Command line and status bar</li><li fr-original-style="" style="box-sizing: border-box;">Managing files:</li><li fr-original-style="" style="box-sizing: border-box;">Curves, surfaces, and solids</li><li fr-original-style="" style="box-sizing: border-box;">NURBS, isocurves, and meshes</li><li fr-original-style="" style="box-sizing: border-box;">Measurement units</li></ul><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Navigation&nbsp;</strong></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;">Viewports and construction planes</li><li fr-original-style="" style="box-sizing: border-box;">Shading modes</li><li fr-original-style="" style="box-sizing: border-box;">Pan, zoom, rotate, and reset</li><li fr-original-style="" style="box-sizing: border-box;">Basic objects: curves, surfaces, and solids</li><li fr-original-style="" style="box-sizing: border-box;">Organizing projects with layers</li><li fr-original-style="" style="box-sizing: border-box;">2D geometry: lines, polylines, rectangles, polygons, arcs, circles, ellipses, and freeform curves</li></ul><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">3D Surfaces and Solid 3D Modeling</strong></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;">3D surface&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Extruding surfaces, creating lofts, and using Revolve and Rail Revolve</li><li fr-original-style="" style="box-sizing: border-box;">Crafting complex surfaces&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">3D solids, creating primitives, and extruding curves</li><li fr-original-style="" style="box-sizing: border-box;">Boolean operators union, difference and&nbsp;intersection</li><li fr-original-style="" style="box-sizing: border-box;">Editing solids with the solid edit tool, transforming, and adding holes</li><li fr-original-style="" style="box-sizing: border-box;">Grid Snap, Ortho, Planar, Snap and cursor constraints</li></ul><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Editing and Transforming&nbsp;</strong></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;">Fillet and Chamfer</li><li fr-original-style="" style="box-sizing: border-box;">Trimming, moving, rotating, copying, pasting, grouping, and scaling objects</li><li fr-original-style="" style="box-sizing: border-box;">Duplicating objects with the Mirror command</li></ul><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Rendering, and 3D Printing Preparation</strong></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;">Defining degrees&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Screen captures and 2D views</li><li fr-original-style="" style="box-sizing: border-box;">Rendering and visualization</li><li fr-original-style="" style="box-sizing: border-box;">Preparing 3D printing</li></ul><div id="optional_extras" fr-original-style="" style="box-sizing: border-box;">

                        </div>

Why Learn Rhino Introduction to Intermediate
Learn Rhino, a leading commercial 3D design software, with our expert-led courses. Perfect for aspiring professionals in architecture, industrial, product, and graphic design. Gain practical skills and create high-quality designs under expert guidance.
Check our Website

Duration: 10 hrs.
How: Personalized 1-on-1 hands-on training.
When: Choose seny day and anytime Mon-Sat, 9 am-7 pm 
Who Should Enroll?
Rhino 3D Introduction to Intermediate Course is designed for individuals aiming to enhance their 2D and 3D modeling abilities within a creative setting. Whether you're aspiring to advance your creative career or secure opportunities in product, furniture design, architectural, or jewelry design, this course provides valuable skills.

Duration: 10 Hrs.
When: Choose anyday and anytime Monday to Saturday 9 am to 7 pm.
Method: 1 on 1 in-person or Live online.

Introduction to Rhino 
Rhino’s commands
Exploring toolbars and buttons
Geometry menus
Command line and status bar
Managing files:
Curves, surfaces, and solids
NURBS, isocurves, and meshes
Measurement units
Navigation 
Viewports and construction planes
Shading modes
Pan, zoom, rotate, and reset
Basic objects: curves, surfaces, and solids
Organizing projects with layers
2D geometry: lines, polylines, rectangles, polygons, arcs, circles, ellipses, and freeform curves
3D Surfaces and Solid 3D Modeling
3D surface
Extruding surfaces, creating lofts, and using Revolve and Rail Revolve
Crafting complex surfaces
3D solids, creating primitives, and extruding curves
Boolean operators union, difference and intersection
Editing solids with the solid edit tool, transforming, and adding holes
Grid Snap, Ortho, Planar, Snap and cursor constraints
Editing and Transforming 
Fillet and Chamfer
Trimming, moving, rotating, copying, pasting, grouping, and scaling objects
Duplicating objects with the Mirror command
Rendering, and 3D Printing Preparation
Defining degrees
Screen captures and 2D views
Rendering and visualization
Preparing 3D printing

Real Animation Works

Rhino

Rhino 3d face to face training customised and bespoke Online or Face to Face

Rhino 3d training course 1-2-1

General Admission

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)

<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);">The novice course is split into 4 days of training and one day of testing.&nbsp;</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);">By the end of the course delegates will have the knowledge to be able to design safe lifting plans that are compliant with the law, and take into account all health and safety requirements on site.</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);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Days 1-4:</strong></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;">Introduction</li><li fr-original-style="" style="box-sizing: border-box;">Explanation of qualifications</li><li fr-original-style="" style="box-sizing: border-box;">Legislation controlling crane operations</li><li fr-original-style="" style="box-sizing: border-box;">BS 7121 Explanation</li><li fr-original-style="" style="box-sizing: border-box;">LOLER regulations in detail</li><li fr-original-style="" style="box-sizing: border-box;">Crane appreciation</li><li fr-original-style="" style="box-sizing: border-box;">Crane stability</li><li fr-original-style="" style="box-sizing: border-box;">Accessories</li><li fr-original-style="" style="box-sizing: border-box;">Safe slinging</li><li fr-original-style="" style="box-sizing: border-box;">Mobile crane selection</li><li fr-original-style="" style="box-sizing: border-box;">Risk assessment and method statement</li><li fr-original-style="" style="box-sizing: border-box;">Supervise a lift scenario</li><li fr-original-style="" style="box-sizing: border-box;">Practical induction</li><li fr-original-style="" style="box-sizing: border-box;">Case studies lift plan exercise</li><li fr-original-style="" style="box-sizing: border-box;">Procedures for planning lifts</li></ul><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day 5:</strong></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;">NPORS Theory Test</li><li fr-original-style="" style="box-sizing: border-box;">NPORS Practical Assessment</li><li fr-original-style="" style="box-sizing: border-box;">RAMS and Lift Plan Exercise</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);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">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.</strong></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);">Experienced operators should have sufficient experience of cranes to meet the requirements specified in British standard 7121 Safe Use of Cranes.</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
The novice course is split into 4 days of training and one day of testing. 
By the end of the course delegates will have the knowledge to be able to design safe lifting plans that are compliant with the law, and take into account all health and safety requirements on site.
Days 1-4:
Introduction
Explanation of qualifications
Legislation controlling crane operations
BS 7121 Explanation
LOLER regulations in detail
Crane appreciation
Crane stability
Accessories
Safe slinging
Mobile crane selection
Risk assessment and method statement
Supervise a lift scenario
Practical induction
Case studies lift plan exercise
Procedures for planning lifts
Day 5:
NPORS Theory Test
NPORS Practical Assessment
RAMS and Lift Plan Exercise
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.
Experienced operators should have sufficient experience of cranes to meet the requirements specified in British standard 7121 Safe Use of Cranes.
Good understanding of spoken and written English.

NPORS Appointed Person (N401)

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

COURSE INFORMATION
To provide knowledge and understanding in the following areas:
Have a basic understanding of the industry and the relevant legislation, the dangers of working in the industry and their responsibilities as a vehicle marshal
Have knowledge of the manufacturer’s handbook for the particular vehicle / machine to be guided
Have a good understanding of signs and signals, approved hand signals and different forms of communication
Identify and maintain PPE appropriate for vehicle marshal duties
Conduct all necessary safety checks at the work area including stop blocks and tipping areas
Set up exclusion zone for unloading
Guide machinery in a forward and reverse direction including confined spaces and “blind areas” safely and efficiently
Environmental considerations
Carry out all end of shift and shut down and parking procedures
Entry Requirements
Please note, that in all cases, operators are required to supply proof to support their application. They have to have passed the CITB health, safety & environmental touch screen test within two years prior to their application.
Good understanding of spoken and written English.

NPORS Vehicle Marshal (N403)

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">COURSE INFORMATION</strong></span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">To provide knowledge and understanding in the following areas:</p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operative</li><li fr-original-style="" style="box-sizing: border-box;">State the definition of manual handling, the main causes of manual handling injuries and the reasons for manual handling training</li><li fr-original-style="" style="box-sizing: border-box;">Describe the function and shape of the human spine</li><li fr-original-style="" style="box-sizing: border-box;">Describe the function of the intervertebral discs</li><li fr-original-style="" style="box-sizing: border-box;">Understand the effects of static loading and the risks involved in team lifting</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate an understanding of formal and dynamic risk assessment</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for manual handling operations</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area</li><li fr-original-style="" style="box-sizing: border-box;">Describe and demonstrate safe handling techniques</li></ul><h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Entry Requirements</h2><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please note, that in all cases, operators are required to supply proof to support&nbsp;their application. They have to have passed the CITB health, safety &amp; environmental touch screen test within two years prior to their application.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Good understanding of spoken and written English.</p>

COURSE INFORMATION
To provide knowledge and understanding in the following areas:
Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operative
State the definition of manual handling, the main causes of manual handling injuries and the reasons for manual handling training
Describe the function and shape of the human spine
Describe the function of the intervertebral discs
Understand the effects of static loading and the risks involved in team lifting
Demonstrate an understanding of formal and dynamic risk assessment
Identify and maintain PPE appropriate for manual handling operations
Conduct all necessary safety checks at the work area
Describe and demonstrate safe handling techniques
Entry Requirements
Please note, that in all cases, operators are required to supply proof to support their application. They have to have passed the CITB health, safety & environmental touch screen test within two years prior to their application.
Good understanding of spoken and written English.

NPORS Manual Handling (N704)

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">COURSE INFORMATION</strong></span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">To provide knowledge and understanding in the following areas:</p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry and the relevant legislation, the dangers of working in the industry and their responsibilities as a vehicle / plant machinery marshal</li><li fr-original-style="" style="box-sizing: border-box;">Have knowledge of the manufacturer&rsquo;s handbook for the particular vehicle / machine to be guided</li><li fr-original-style="" style="box-sizing: border-box;">Have a good understanding of signs and signals, approved hand signals and different<br fr-original-style="" style="box-sizing: border-box;">forms of communication</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for vehicle / plant machinery marshal</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area including stop blocks and tipping areas</li><li fr-original-style="" style="box-sizing: border-box;">Set up exclusion zone for loading / unloading</li><li fr-original-style="" style="box-sizing: border-box;">Guide machinery in a forward and reverse direction including confined spaces and &ldquo;blind areas&rdquo; safely and efficiently&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Environmental considerations</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down and parking procedures</li></ul><h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Entry Requirements</h2><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please note, that in all cases, operators are required to supply proof to support&nbsp;their application. They have to have passed the CITB health, safety &amp; environmental touch screen test within two years prior to their application.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Good understanding of spoken and written English.</p>

COURSE INFORMATION
To provide knowledge and understanding in the following areas:
Have a basic understanding of the industry and the relevant legislation, the dangers of working in the industry and their responsibilities as a vehicle / plant machinery marshal
Have knowledge of the manufacturer’s handbook for the particular vehicle / machine to be guided
Have a good understanding of signs and signals, approved hand signals and different
forms of communication
Identify and maintain PPE appropriate for vehicle / plant machinery marshal
Conduct all necessary safety checks at the work area including stop blocks and tipping areas
Set up exclusion zone for loading / unloading
Guide machinery in a forward and reverse direction including confined spaces and “blind areas” safely and efficiently
Environmental considerations
Carry out all end of shift and shut down and parking procedures
Entry Requirements
Please note, that in all cases, operators are required to supply proof to support their application. They have to have passed the CITB health, safety & environmental touch screen test within two years prior to their application.
Good understanding of spoken and written English.

NPORS Plant Machinery Marshal (N133)

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">COURSE INFORMATION</strong></span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">To provide knowledge and understanding in the following areas:</p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an Excavation Marshall - Banksperson</li><li fr-original-style="" style="box-sizing: border-box;">Have knowledge of the equipment to be used and be conversant with Method Statements, Risk Assessments and Permits to Work</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for use</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-excavating checks</li><li fr-original-style="" style="box-sizing: border-box;">Agree communication signals and emergency procedures</li><li fr-original-style="" style="box-sizing: border-box;">Safe positioning of Excavation Marshall - Banksperson</li><li fr-original-style="" style="box-sizing: border-box;">Define and identify the different types of underground services</li><li fr-original-style="" style="box-sizing: border-box;">Identify risks that excavations can present and how people may be affected</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area</li><li fr-original-style="" style="box-sizing: border-box;">Carry out exploratory tasks</li><li fr-original-style="" style="box-sizing: border-box;">Identify the risks of excavating near to underground services, and the safe digging practices that should be adopted</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and safe storage procedures</li></ul><h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Entry Requirements</h2><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please note, that in all cases, operators are required to supply proof to support&nbsp;their application. They have to have passed the CITB health, safety &amp; environmental touch screen test within two years prior to their application.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Good understanding of spoken and written English.</p>

COURSE INFORMATION
To provide knowledge and understanding in the following areas:
Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an Excavation Marshall - Banksperson
Have knowledge of the equipment to be used and be conversant with Method Statements, Risk Assessments and Permits to Work
Identify and maintain PPE appropriate for use
Conduct all pre-excavating checks
Agree communication signals and emergency procedures
Safe positioning of Excavation Marshall - Banksperson
Define and identify the different types of underground services
Identify risks that excavations can present and how people may be affected
Conduct all necessary safety checks at the work area
Carry out exploratory tasks
Identify the risks of excavating near to underground services, and the safe digging practices that should be adopted
Carry out all end of shift and safe storage procedures
Entry Requirements
Please note, that in all cases, operators are required to supply proof to support their application. They have to have passed the CITB health, safety & environmental touch screen test within two years prior to their application.
Good understanding of spoken and written English.

NPORS Excavation Marshall - Banksperson (N027)

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">COURSE INFORMATION</strong></span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">To provide knowledge and understanding in the following areas:</p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operative in the industry</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 and relevant legislation</li><li fr-original-style="" style="box-sizing: border-box;">Be able to identify different types of transport, explain their purpose, the major components, basic construction, controls and terminology</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the loading / unloading area</li><li fr-original-style="" style="box-sizing: border-box;">Ensure that the transporter is correctly configured in readiness for loading and unloading</li><li fr-original-style="" style="box-sizing: border-box;">Explain hazards that may exist in the work area and how to avoid them, e.g. underground services, overhead power lines etc</li><li fr-original-style="" style="box-sizing: border-box;">Agree a method of communication and use it</li><li fr-original-style="" style="box-sizing: border-box;">Load or direct items of plant onto and off transporting vehicle</li><li fr-original-style="" style="box-sizing: border-box;">Arrange and secure items of plant on transport vehicle ready for transport on the public highway</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down procedures</li></ul><h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Entry Requirements</h2><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please note, that in all cases, operators are required to supply proof to support&nbsp;their application. They have to have passed the CITB health, safety &amp; environmental touch screen test within two years prior to their application.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Good understanding of spoken and written English.</p>

COURSE INFORMATION
To provide knowledge and understanding in the following areas:
Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operative in the industry
Have a working knowledge of the manufacturer’s handbook for the particular machine to be used and relevant legislation
Be able to identify different types of transport, explain their purpose, the major components, basic construction, controls and terminology
Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
Conduct all necessary safety checks at the loading / unloading area
Ensure that the transporter is correctly configured in readiness for loading and unloading
Explain hazards that may exist in the work area and how to avoid them, e.g. underground services, overhead power lines etc
Agree a method of communication and use it
Load or direct items of plant onto and off transporting vehicle
Arrange and secure items of plant on transport vehicle ready for transport on the public highway
Carry out all end of shift and shut down procedures
Entry Requirements
Please note, that in all cases, operators are required to supply proof to support their application. They have to have passed the CITB health, safety & environmental touch screen test within two years prior to their application.
Good understanding of spoken and written English.

NPORS Plant Loader and Securer (N120)

<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 to enable them to know correct use of harness and fall arrest equipment, ACOP, regulations and risks associated with not wearing fall arrest equipment.</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);">&nbsp;This course can be completed by both novice and experienced candidates.</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- 1/2 Day</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/2 day theory assessment.</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);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">COURSE INFORMATION</strong></span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">To provide knowledge and understanding in the following areas:</p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities</li><li fr-original-style="" style="box-sizing: border-box;">Have a working knowledge of the manufacturer&#39;s handbook for the particular harness / fall arrest to be used</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify major components of the harness / fall arrest and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all safety checks in accordance with the manufacturer&#39;s and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Select suitable type of harness / fall arrest relative to the work being undertaken</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for using harness / fall arrest and demonstrate correct use</li><li fr-original-style="" style="box-sizing: border-box;">Correctly fit and remove the safety harness / fall arrest</li><li fr-original-style="" style="box-sizing: border-box;">Carry out end of work inspections</li><li fr-original-style="" style="box-sizing: border-box;">Environmental considerations</li><li fr-original-style="" style="box-sizing: border-box;">Storage of harness / fall arrest</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>

Who Should Attend
This course is aimed at candidates that require the knowledge to enable them to know correct use of harness and fall arrest equipment, ACOP, regulations and risks associated with not wearing fall arrest equipment.
 This course can be completed by both novice and experienced candidates.
Novice course- 1/2 Day
Experienced worker tests- 1/2 day theory assessment.
COURSE INFORMATION
To provide knowledge and understanding in the following areas:
Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities
Have a working knowledge of the manufacturer's handbook for the particular harness / fall arrest to be used
Be able to locate and identify major components of the harness / fall arrest and explain their functions
Conduct all safety checks in accordance with the manufacturer's and legislative requirements
Select suitable type of harness / fall arrest relative to the work being undertaken
Identify and maintain PPE appropriate for using harness / fall arrest and demonstrate correct use
Correctly fit and remove the safety harness / fall arrest
Carry out end of work inspections
Environmental considerations
Storage of harness / fall arrest
Entry Requirements
Please note, that in all cases, operators are required to supply proof to support their application. They have to have passed the CITB health, safety & environmental touch screen test within two years prior to their application.
Good understanding of spoken and written English.

NPORS Harness and Fall Arrest (N723)

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

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

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

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

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

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

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

			 

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

<div>   

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

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




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

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

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

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

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

Tables, Rows and Columns

Indexes, Primary Keys and Foreign Keys

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

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

SQL Arithmetic Operations, Expression Queries

SQL Column Aliases

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

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

The Group By Clause

The Having Clause 
Querying Multiple Tables:
 Joins 

Joining Tables

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

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

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



PCWorkshops

Online Course Creation

Database Programming

IT Skills

Data Skills

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

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

General admission

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

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

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

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

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

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

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

Session 6:

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

Session 7:

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

Session 8:

SQL Views: Create, alter and drop Views

Session 9:

Inserting rows,
Replacing rows,
Updating rows,
Deleting rows

Session 10:

Session 10: Managing indexes

Session 11:

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

Session 12:

Import data into SQL and Export from SQL

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

Database Design & Development

Oracle SQL

Database Administration

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

Oracle SQL Fundamentals, 3 Days

<p style="color: rgb(35, 31, 32); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 31, 32);">IPAF&#39;s eLearning provides a flexible and enhanced online learning experience for the&nbsp;<a href="https://www.ipaf.org/courses" style="color: rgb(35, 31, 32); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(35, 31, 32);">mobile elevating work platform (MEWP) operator</a> and <a href="https://www.ipaf.org/en/management-training" style="color: rgb(35, 31, 32); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(35, 31, 32);">MEWPs for Managers</a> training programmes. It provides the same high-quality theory training as in the classroom and can be completed on a range of devices anytime, anywhere, at your own pace.</p><h2 style="color: rgb(35, 31, 32); box-sizing: border-box;" fr-original-style=" color: rgb(35, 31, 32);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">MEWP OPERATOR ELEARNING</strong></h2><p style="color: rgb(35, 31, 32); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(35, 31, 32);">IPAF&rsquo;s eLearning for MEWP operators is available for all&nbsp;<a data-entity-substitution="canonical" data-entity-type="node" data-entity-uuid="894a4fb8-3aad-49a4-b73c-db4b348bafb3" href="https://www.ipaf.org/en-gb/resource-library/ipaf-categories" target="_blank" style="color: rgb(35, 31, 32); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(35, 31, 32);">MEWP categories</a>&nbsp;(1a, 1b, 3a, 3b) and takes around three hours to complete. The eLearning is broken down into manageable sections that you can complete at your own pace and can save and resume your training at any time.</p><p style="color: rgb(35, 31, 32); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(35, 31, 32);">IPAF MEWP Operator eLearning training course is available in English, Dutch, French, German, Italian, Portuguese and Spanish.</p><p style="color: rgb(35, 31, 32); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(35, 31, 32);">How to start your eLearning training course:</p><ol style="color: rgb(35, 31, 32); box-sizing: border-box;" fr-original-style=" color: rgb(35, 31, 32);"><li fr-original-style="" style="box-sizing: border-box;">Choose this module&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;"> register for&nbsp;<em fr-original-style="" style="box-sizing: border-box;">IPAF MEWP Operator</em>&nbsp;eLearning training;</li><li fr-original-style="" style="box-sizing: border-box;">You will be sent an email to begin your eLearning training;</li><li fr-original-style="" style="box-sizing: border-box;">At the end of your training you will need to complete a pre-theory test;</li><li fr-original-style="" style="box-sizing: border-box;">Once you have passed your pre-theory test, contact Kingfisher Access 0333 666 1881 to schedule your , practical training and assessment.</li></ol><p style="color: rgb(35, 31, 32); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(35, 31, 32);">MEWP operator eLearning does not replace practical training. Trainees who complete the online training course must still pass a supervised practical&nbsp; test within 90&nbsp;days, at an&nbsp;<a data-entity-substitution="canonical" data-entity-type="node" data-entity-uuid="8512c9a1-cc6d-41f8-a98a-3ee7fc081e79" href="https://www.ipaf.org/en-gb/training-centres" target="_blank" style="color: rgb(35, 31, 32); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(35, 31, 32);">IPAF-approved training centre</a>&nbsp;and must successfully complete a minimum half-day of practical training and testing before qualifying for and being issued with a&nbsp;<a data-entity-substitution="canonical" data-entity-type="node" data-entity-uuid="4bbd8bcd-468d-43c3-8b41-c65a62204683" href="https://www.ipaf.org/en-gb/pal-card" style="color: rgb(35, 31, 32); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(35, 31, 32);">PAL Card</a>&nbsp;as proof of success operator training.</p><p style="color: rgb(35, 31, 32); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(35, 31, 32);">When booking the practical training we will credit the payment you have made for your eLearning&nbsp;</p>

IPAF's eLearning provides a flexible and enhanced online learning experience for the mobile elevating work platform (MEWP) operator and MEWPs for Managers training programmes. It provides the same high-quality theory training as in the classroom and can be completed on a range of devices anytime, anywhere, at your own pace.
MEWP OPERATOR ELEARNING
IPAF’s eLearning for MEWP operators is available for all MEWP categories (1a, 1b, 3a, 3b) and takes around three hours to complete. The eLearning is broken down into manageable sections that you can complete at your own pace and can save and resume your training at any time.
IPAF MEWP Operator eLearning training course is available in English, Dutch, French, German, Italian, Portuguese and Spanish.
How to start your eLearning training course:
Choose this module
register for IPAF MEWP Operator eLearning training;
You will be sent an email to begin your eLearning training;
At the end of your training you will need to complete a pre-theory test;
Once you have passed your pre-theory test, contact Kingfisher Access 0333 666 1881 to schedule your , practical training and assessment.
MEWP operator eLearning does not replace practical training. Trainees who complete the online training course must still pass a supervised practical test within 90 days, at an IPAF-approved training centre and must successfully complete a minimum half-day of practical training and testing before qualifying for and being issued with a PAL Card as proof of success operator training.
When booking the practical training we will credit the payment you have made for your eLearning 

Kingfisher Access

MEWP

IPAF

Lifting Operations

MEWP OPERATOR ELEARNING
IPAF’s eLearning for MEWP operators is available for all MEWP categories (1a, 1b, 3a, 3b) and takes around three hours to complete. The eLearning is broken down into manageable sections that you can complete at your own pace and can save and resume your training at any time.

IPAF MEWP Operator eLearning training course is available in English, Dutch, French, German, Italian, Portuguese and Spanish.

IPAF Operator - eLearning theory module 

Oldham

<p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(50, 74, 109);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 14</strong></p><p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);">This module aims to develop knowledge and understanding of the status of an authorised economic operator in the export and in import of goods. This includes the advantages of the status, trusted trader, and the process of securing the authorised economic operator status.</p><p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Agenda</strong></p><ul style="color: rgb(50, 74, 109); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);"><li fr-original-style="" style="box-sizing: border-box;">Supply chain security</li><li fr-original-style="" style="box-sizing: border-box;">History of AEO</li><li fr-original-style="" style="box-sizing: border-box;">AEO in the UK</li><li fr-original-style="" style="box-sizing: border-box;">AEO requirements</li><li fr-original-style="" style="box-sizing: border-box;">AEO-C</li><li fr-original-style="" style="box-sizing: border-box;">AEO-S</li><li fr-original-style="" style="box-sizing: border-box;">Application &amp; approval process</li><li fr-original-style="" style="box-sizing: border-box;">Preparation tips</li></ul><p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Examination:</strong><br fr-original-style="" style="box-sizing: border-box;">Certificate on completion and Pass on Multiple Choice<br fr-original-style="" style="box-sizing: border-box;">Multiple choice questionnaire<br fr-original-style="" style="box-sizing: border-box;">Credits: 1</p>

Module 14
This module aims to develop knowledge and understanding of the status of an authorised economic operator in the export and in import of goods. This includes the advantages of the status, trusted trader, and the process of securing the authorised economic operator status.
Agenda
Supply chain security
History of AEO
AEO in the UK
AEO requirements
AEO-C
AEO-S
Application & approval process
Preparation tips
Examination:
Certificate on completion and Pass on Multiple Choice
Multiple choice questionnaire
Credits: 1

Export Unlocked Limited

Trade & Commerce

Approved Training Organisation (ATO)

Accredited Trading

International Trade

Export Management

This module aims to develop knowledge and understanding of the status of an authorised economic operator in the export and in import of goods. This includes the advantages of the status, trusted trader, and the process securing the authorised economic operator status.



AUTHORISED ECONOMIC OPERATOR (AEO)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.</p>Overview<p>Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries</p><p>This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.</p>Prerequisites<p></p><ul> <li>Basic understanding of relational databases.</li> <li>Basic Windows knowledge.</li> </ul><p></p></div><div id="course-pills-2"><h3>Module 1: Introduction to Transact-SQL</h3><ul> <li>What is Transact-SQL</li> <li>The SELECT statement</li> <li>The WHERE clause</li> <li>Sorting results</li> <li>Calculations</li> <li>CASE expressions</li> </ul>   <h3>Module 2: Joining tables with Transact-SQL</h3><ul> <li>The JOIN clause</li> <li>Inner joins</li> <li>Outer joins</li> <li>Self joins and cross joins</li> </ul>  <h3>Module 3: Filtering and sorting results</h3><ul> <li>Implement the ORDER BY clause</li> <li>Filter data with the WHERE clause</li> <li>Limit the number of rows returned by a query</li> <li>Implement NULL logic</li> </ul>  <h3>Module 4: SQL Server data types</h3><ul> <li>Understand data types</li> <li>Implement string data types</li> <li>Implement temporal data types</li> </ul>  <h3>Module 5: Inserting, updating and deleting data</h3><ul> <li>Insert new records</li> <li>Update existing records</li> <li>Delete data</li> </ul>   <h3>Module 6: Using SQL Server functions with Transact-SQL</h3><ul> <li>Understand function types in SQL Server</li> <li>Convert data using functions</li> <li>Implement logical functions</li> <li>Work with NULL data using functions</li> </ul>  <h3>Module 7: Aggregating data with Transact-SQL</h3><ul> <li>Implement aggregation in SQL Server</li> <li>Group records in SQL Server</li> <li>Filter aggregated data</li> </ul>   <h3>Module 8: Implement subqueries with Transact-SQL</h3><ul> <li>Implement scalar and multi-valued sub-queries</li> <li>Implement correlated subqueries</li> <li>Implement existence checks with subqueries</li> </ul>   <h3>Module 9: Create queries that use table expressions</h3><ul> <li>Create views</li> <li>Create table-valued functions</li> <li>Implement derived tables</li> <li>Implement common table expressions</li> </ul>  <h3>Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data</h3><ul> <li>Write queries with the UNION operator</li> <li>Write queries with the INTERSECT and EXCEPT operators</li> <li>Write queries with the APPLY operator</li> </ul>    <h3>Module 11: Implement window functions in queries</h3><ul> <li>Understand window functions</li> <li>Impement window functions</li> </ul>    <h3>Module 12: Use PIVOT and grouping sets in queries</h3><ul> <li>Implement PIVOT in queries</li> <li>Implement grouping sets in queries</li> </ul>   <h3>Module 13: Use stored procedures in queries</h3><ul> <li>Query data with stored procedures</li> <li>Interact with stored procedures using input and output parameters</li> <li>Write simple stored procedures</li> <li>Pass dynamic SQL to SQL Server</li> </ul>    <h3>Module 14: Implement programming features in Transact-SQL</h3><ul> <li>Understand T-SQL programming elements</li> <li>Implement loops and conditions in T-SQL queries</li> </ul>   <h3>Module 15: Add error handling to queries</h3><ul> <li>Understand SQL Server error handling</li> <li>Implemet structured exception handling</li> </ul>   <h3>Module 16: Use transactions in queries</h3><ul> <li>Understand database transactions</li> <li>Implement transactions in T-SQL</li> </ul></div>

Duration
5 Days
30 CPD hours
This course is intended for
This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.
Overview
Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries
This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.
Prerequisites

Basic understanding of relational databases.
Basic Windows knowledge.

Module 1: Introduction to Transact-SQL
What is Transact-SQL
The SELECT statement
The WHERE clause
Sorting results
Calculations
CASE expressions
Module 2: Joining tables with Transact-SQL
The JOIN clause
Inner joins
Outer joins
Self joins and cross joins
Module 3: Filtering and sorting results
Implement the ORDER BY clause
Filter data with the WHERE clause
Limit the number of rows returned by a query
Implement NULL logic
Module 4: SQL Server data types
Understand data types
Implement string data types
Implement temporal data types
Module 5: Inserting, updating and deleting data
Insert new records
Update existing records
Delete data
Module 6: Using SQL Server functions with Transact-SQL
Understand function types in SQL Server
Convert data using functions
Implement logical functions
Work with NULL data using functions
Module 7: Aggregating data with Transact-SQL
Implement aggregation in SQL Server
Group records in SQL Server
Filter aggregated data
Module 8: Implement subqueries with Transact-SQL
Implement scalar and multi-valued sub-queries
Implement correlated subqueries
Implement existence checks with subqueries
Module 9: Create queries that use table expressions
Create views
Create table-valued functions
Implement derived tables
Implement common table expressions
Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data
Write queries with the UNION operator
Write queries with the INTERSECT and EXCEPT operators
Write queries with the APPLY operator
Module 11: Implement window functions in queries
Understand window functions
Impement window functions
Module 12: Use PIVOT and grouping sets in queries
Implement PIVOT in queries
Implement grouping sets in queries
Module 13: Use stored procedures in queries
Query data with stored procedures
Interact with stored procedures using input and output parameters
Write simple stored procedures
Pass dynamic SQL to SQL Server
Module 14: Implement programming features in Transact-SQL
Understand T-SQL programming elements
Implement loops and conditions in T-SQL queries
Module 15: Add error handling to queries
Understand SQL Server error handling
Implemet structured exception handling
Module 16: Use transactions in queries
Understand database transactions
Implement transactions in T-SQL

Nexus Human

Computing Skills

Microsoft SQL

SQL Server

Trainers Course

55366 Querying Data with Transact-SQL

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

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

								<br /><br />Decision Making Statements

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

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

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

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

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

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

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

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



							</p>
							<br />					

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

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

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

									

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

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

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

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

Decision Making Statements 

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

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

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

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

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

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

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

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

WEEK 9: PRACTICAL  
Alternative Bootcamp Courses

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

Programming Fundamentals

Computer Programming

Bootcamp

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

C++ Bootcamp Course, 2-Months

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>This course is intended for IT Professionals who are already experienced in general Windows Server, Windows client, Azure, and Microsoft 365 administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of PowerShell or any scripting language is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Microsoft Exchange Server, Microsoft SharePoint Server, and Microsoft SQL Server.</p><p></p><p></p><p>This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches.</p><p></p>Prerequisites<p>Before attending this course, students must have: </p><ul><li>-Experience with Windows networking technologies and implementation.</li> <li>- Experience with Windows Server administration, maintenance, and troubleshooting.</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Review Windows PowerShell</h3> <ul> <li>Learn about Windows PowerShell</li> <li>Get familiar with Windows PowerShell applications</li> <li>Identify factors to install and use Windows PowerShell</li> <li>Configure the Windows PowerShell console</li> <li>Configure the Windows PowerShell Integrated Scripting Environment (ISE)</li> <li>Use Visual Studio Code with PowerShell</li> </ul> <h3>2 - Understand the command syntax in Windows PowerShell</h3> <ul> <li>Discover the structure of PowerShell cmdlets</li> <li>Discover the parameters for using PowerShell cmdlets</li> <li>Review the tab completion feature in PowerShell</li> <li>Display the About files content in PowerShell</li> </ul> <h3>3 - Find commands and Get-Help in Windows PowerShell</h3> <ul> <li>Define modules in PowerShell</li> <li>Find cmdlets in PowerShell</li> <li>Use command aliases in PowerShell</li> <li>Use Show-Command and Get-Help in PowerShell</li> <li>Interpret the help file contents and update the local help content in PowerShell</li> </ul> <h3>4 - Manage Active Directory Domain Services using PowerShell cmdlets</h3> <ul> <li>Manage user accounts in PowerShell</li> <li>Manage groups and group memberships in PowerShell</li> <li>Manage computer accounts in PowerShell</li> <li>Manage organizational units and Active Directory objects in PowerShell</li> </ul> <h3>5 - Manage network service settings for Windows devices using PowerShell cmdlets</h3> <ul> <li>Manage IP addresses in PowerShell</li> <li>Manage IP routing in PowerShell</li> <li>Manage DNS clients in PowerShell</li> <li>Manage Windows Firewall settings in PowerShell</li> </ul> <h3>6 - Manage Windows Server settings using PowerShell cmdlets</h3> <ul> <li>Automate management tasks using the Group Policy management cmdlets</li> <li>Manage server roles and services using PowerShell cmdlets</li> <li>Manage Hyper-V Virtual Machines using PowerShell cmdlets</li> <li>Manage Internet Information Services using PowerShell cmdlets</li> </ul> <h3>7 - Manage settings for a local Windows machine using PowerShell cmdlets</h3> <ul> <li>Manage Windows 10 using PowerShell</li> <li>Manage permissions with PowerShell</li> </ul> <h3>8 - Understand the Windows PowerShell pipeline</h3> <ul> <li>Review Windows PowerShell pipeline and its output</li> <li>Discover object members in PowerShell</li> <li>Control the formatting of pipeline output</li> </ul> <h3>9 - Select, sort, and measure objects using the pipeline</h3> <ul> <li>Sort and group objects by property in the pipeline</li> <li>Measure objects in the pipeline</li> <li>Select a set of objects in the pipeline</li> <li>Select object properties in the pipeline</li> <li>Create and format calculated properties in the pipeline</li> </ul> <h3>10 - Filter objects out of the pipeline</h3> <ul> <li>Learn about the comparison operators in PowerShell</li> <li>Review basic filter syntax in the pipeline</li> <li>Review advanced filter syntax in the pipeline</li> <li>Optimize the filter performance in the pipeline</li> </ul> <h3>11 - Enumerate objects in the pipeline</h3> <ul> <li>Learn about enumerations in the pipeline</li> <li>Review basic syntax to enumerate objects in the pipeline</li> <li>Review advanced syntax to enumerate objects in the pipeline</li> </ul> <h3>12 - Send and pass data as output from the pipeline</h3> <ul> <li>Write pipeline data to a file</li> <li>Convert pipeline objects to other forms of data representation in PowerShell</li> <li>Control additional output options in PowerShell</li> </ul> <h3>13 - Pass pipeline objects</h3> <ul> <li>Pipeline parameter binding</li> <li>Identify ByValue parameters</li> <li>Pass data by using ByValue</li> <li>Pass data by using ByPropertyName</li> <li>Identify ByPropertyName parameters</li> <li>Use manual parameters to override the pipeline</li> <li>Use parenthetical commands</li> <li>Expand property values</li> </ul> <h3>14 - Connect with data stores using PowerShell providers</h3> <ul> <li>Define Windows PowerShell providers</li> <li>Review the built-in providers in PowerShell</li> <li>Access provider help in PowerShell</li> </ul> <h3>15 - Use PowerShell drives in PowerShell</h3> <ul> <li>Explain PowerShell drives in PowerShell</li> <li>Use PowerShell drive cmdlets in PowerShell</li> <li>Manage the file system in PowerShell</li> <li>Manage the registry in PowerShell</li> <li>Work with certificates in PowerShell</li> <li>Work with other PowerShell drives in PowerShell</li> </ul> <h3>16 - Review CIM and WMI</h3> <ul> <li>Review architecture of CIM and WMI</li> <li>Review repositories in CIM and WMI</li> <li>Locate online class documentation by using CIM and WMI cmdlets</li> </ul> <h3>17 - Query configuration information by using CIM and WMI</h3> <ul> <li>List local repository namespaces and classes by using CIM and WMI</li> <li>Query instances by using commands and WMI Query Language</li> <li>Connect to remote computers by using CIM and WMI cmdlets</li> <li>Query repository classes from remote computers by using CIMSession objects</li> </ul> <h3>18 - Query and manipulate repository objects by using CIM and WMI methods</h3> <ul> <li>Discover methods of repository objects by using CIM and WMI</li> <li>Locate class methods and documentation by using CIM and WMI</li> <li>Invoke methods of repository objects by using CIM and WMI</li> </ul> <h3>19 - Manage variables in Windows PowerShell scripts</h3> <ul> <li>Define variables in Windows PowerShell scripts</li> <li>Create variable names in Windows PowerShell scripts</li> <li>Assign values and types to variables in Windows PowerShell scripts</li> <li>Identify the methods and properties of variables in Windows PowerShell scripts</li> <li>Use string variables and methods in Windows PowerShell scripts</li> <li>Use date variables and methods in Windows PowerShell scripts</li> </ul> <h3>20 - Work with arrays and hash tables in Windows PowerShell scripts</h3> <ul> <li>Define an array in Windows PowerShell scripts</li> <li>Work with array lists in Windows PowerShell scripts</li> <li>Define hash tables in Windows PowerShell Scripts</li> <li>Work with hash tables in Windows PowerShell scripts</li> </ul> <h3>21 - Create and run scripts by using Windows PowerShell</h3> <ul> <li>Review Windows PowerShell scripts</li> <li>Modify scripts in the PowerShell Gallery</li> <li>Create scripts using Windows PowerShell</li> <li>Review the PowerShellGet module in Windows PowerShell</li> <li>Run scripts and set the execution policy in Windows PowerShell</li> <li>Review Windows PowerShell and AppLocker</li> <li>Sign the scripts digitally in Windows PowerShell</li> </ul> <h3>22 - Work with scripting constructs in Windows PowerShell</h3> <ul> <li>Review and use the ForEach loop in Windows PowerShell scripts</li> <li>Review and use the If construct in Windows PowerShell scripts</li> <li>Review and use the Switch construct in Windows PowerShell scripts</li> <li>Review the For construct in Windows PowerShell scripts</li> <li>Review other loop constructs in Windows PowerShell scripts</li> <li>Review Break and Continue in Windows PowerShell scripts</li> </ul> <h3>23 - Import data in different formats for use in scripts by using Windows PowerShell cmdlets</h3> <ul> <li>Use the Get-Content command in Windows PowerShell scripts</li> <li>Use the Import-Csv cmdlet in Windows PowerShell scripts</li> <li>Use the Import-Clixml cmdlet in Windows PowerShell scripts</li> <li>Use the ConvertFrom-Json cmdlet in Windows PowerShell scripts</li> </ul> <h3>24 - Use methods to accept user inputs in Windows PowerShell scripts</h3> <ul> <li>Identify values that might change in Windows PowerShell scripts</li> <li>Use the Read-Host cmdlet in Windows PowerShell scripts</li> <li>Use the Get-Credential cmdlet in Windows PowerShell scripts</li> <li>Use the Out-GridView cmdlet in Windows PowerShell scripts</li> <li>Pass parameters to a Windows PowerShell script</li> </ul> <h3>25 - Troubleshoot scripts and handle errors in Windows PowerShell</h3> <ul> <li>Interpret error messages generated for Windows PowerShell commands</li> <li>Add output to Windows PowerShell scripts</li> <li>Use breakpoints in Windows PowerShell scripts</li> <li>Interpret error actions for Windows PowerShell commands</li> </ul> <h3>26 - Use functions and modules in Windows PowerShell scripts</h3> <ul> <li>Review functions in Windows PowerShell scripts</li> <li>Use variable scope in Windows PowerShell scripts</li> <li>Create modules in Windows PowerShell scripts</li> <li>Use the dot sourcing feature in Windows PowerShell</li> </ul> <h3>27 - Manage single and multiple computers by using Windows PowerShell remoting</h3> <ul> <li>Review the remoting feature of Windows PowerShell</li> <li>Compare remoting with remote connectivity</li> <li>Review the remoting security feature of Windows PowerShell</li> <li>Enable remoting by using Windows PowerShell</li> <li>Use one-to-one remoting by using Windows PowerShell</li> <li>Use one-to-many remoting by using Windows PowerShell</li> <li>Compare remoting output with local output</li> </ul> <h3>28 - Use advanced Windows PowerShell remoting techniques</h3> <ul> <li>Review common remoting techniques of Windows PowerShell</li> <li>Send parameters to remote computers in Windows PowerShell</li> <li>Set access protection to variables, aliases, and functions by using the scope modifier</li> <li>Enable multi-hop remoting in Windows PowerShell</li> </ul> <h3>29 - Manage persistent connections to remote computers by using Windows PowerShell sessions</h3> <ul> <li>Review persistent connections in Windows PowerShell</li> <li>Create and manage persistent PSSessions by using Windows PowerShell</li> <li>Disconnect PSSessions by using Windows PowerShell</li> <li>Review the feature of implicit remoting in Windows PowerShell</li> </ul> <h3>30 - Review Azure PowerShell module</h3> <ul> <li>Review Azure PowerShell</li> <li>Review the benefits of the Azure PowerShell module</li> <li>Install the Azure PowerShell module</li> <li>Migrate Azure PowerShell from AzureRM to Azure</li> <li>Review Microsoft Azure Active Directory module for Windows PowerShell and Azure Active Directory PowerShell for Graph modules</li> </ul> <h3>31 - Review the features and tools for Azure Cloud Shell</h3> <ul> <li>Review the characteristics of Azure Cloud Shell</li> <li>Review the features and tools of Azure Cloud Shell</li> <li>Configure and experiment with Azure Cloud Shell</li> </ul> <h3>32 - Manage Azure resources with Windows PowerShell</h3> <ul> <li>Create a new Azure virtual machine by using Windows PowerShell commands</li> <li>Manage Azure virtual machines by using Windows PowerShell commands</li> <li>Manage Azure related storage by using Azure PowerShell</li> <li>Manage Azure subscriptions by using Azure PowerShell</li> </ul> <h3>33 - Manage users, groups, and licenses in Microsoft Entra ID by using Windows PowerShell</h3> <ul> <li>Review benefits to manage Microsoft 365 services by using Windows PowerShell</li> <li>Connect to the Microsoft 365 tenant by using Windows PowerShell</li> <li>Manage users in Microsoft 365 by using Windows PowerShell</li> <li>Manage groups in Microsoft 365 by using Windows PowerShell</li> <li>Manage roles in Microsoft 365 by using Windows PowerShell</li> <li>Manage licenses in Microsoft 365 by using Windows PowerShell</li> </ul> <h3>34 - Manage Exchange Online by using Windows PowerShell</h3> <ul> <li>Connect to Exchange Online by using Windows PowerShell</li> <li>Manage mailboxes in Exchange Online by using Windows PowerShell</li> <li>Manage resources in Exchange Online by using Windows PowerShell</li> <li>Manage admin roles in Exchange Online by using Windows PowerShell</li> </ul> <h3>35 - Manage SharePoint Online by using Windows PowerShell</h3> <ul> <li>Install and connect to SharePoint Online Management Shell by using Windows PowerShell</li> <li>Manage SharePoint Online users and groups by using Windows PowerShell</li> <li>Manage SharePoint sites by using Windows PowerShell</li> <li>Manage SharePoint Online external user sharing by using Windows PowerShell</li> </ul> <h3>36 - Manage Microsoft Teams by using Windows PowerShell</h3> <ul> <li>Review Microsoft Teams PowerShell module</li> <li>Install the Microsoft Teams PowerShell module</li> <li>Manage teams with Microsoft Teams PowerShell module</li> </ul> <h3>37 - Create and manage background jobs using Windows PowerShell</h3> <ul> <li>Define the types of background jobs in Windows PowerShell</li> <li>Start remote jobs and CIM/WMI jobs in Windows PowerShell</li> <li>Monitor jobs in Windows PowerShell</li> <li>Retrieve results for running jobs in Windows PowerShell</li> </ul> <h3>38 - Create and manage scheduled jobs using Windows PowerShell</h3> <ul> <li>Create and run Windows PowerShell scripts as scheduled tasks</li> <li>Define scheduled jobs in Windows PowerShell</li> <li>Create job option and job trigger objects in Windows PowerShell</li> <li>Create and register a scheduled job in Windows PowerShell</li> <li>Retrieve the results from a scheduled job in Windows PowerShell</li> </ul></div>

Duration
5 Days
30 CPD hours
This course is intended for

This course is intended for IT Professionals who are already experienced in general Windows Server, Windows client, Azure, and Microsoft 365 administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of PowerShell or any scripting language is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Microsoft Exchange Server, Microsoft SharePoint Server, and Microsoft SQL Server.


This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches.

Prerequisites
Before attending this course, students must have: 
-Experience with Windows networking technologies and implementation.
- Experience with Windows Server administration, maintenance, and troubleshooting.

1 - Review Windows PowerShell
Learn about Windows PowerShell
Get familiar with Windows PowerShell applications
Identify factors to install and use Windows PowerShell
Configure the Windows PowerShell console
Configure the Windows PowerShell Integrated Scripting Environment (ISE)
Use Visual Studio Code with PowerShell
2 - Understand the command syntax in Windows PowerShell
Discover the structure of PowerShell cmdlets
Discover the parameters for using PowerShell cmdlets
Review the tab completion feature in PowerShell
Display the About files content in PowerShell
3 - Find commands and Get-Help in Windows PowerShell
Define modules in PowerShell
Find cmdlets in PowerShell
Use command aliases in PowerShell
Use Show-Command and Get-Help in PowerShell
Interpret the help file contents and update the local help content in PowerShell
4 - Manage Active Directory Domain Services using PowerShell cmdlets
Manage user accounts in PowerShell
Manage groups and group memberships in PowerShell
Manage computer accounts in PowerShell
Manage organizational units and Active Directory objects in PowerShell
5 - Manage network service settings for Windows devices using PowerShell cmdlets
Manage IP addresses in PowerShell
Manage IP routing in PowerShell
Manage DNS clients in PowerShell
Manage Windows Firewall settings in PowerShell
6 - Manage Windows Server settings using PowerShell cmdlets
Automate management tasks using the Group Policy management cmdlets
Manage server roles and services using PowerShell cmdlets
Manage Hyper-V Virtual Machines using PowerShell cmdlets
Manage Internet Information Services using PowerShell cmdlets
7 - Manage settings for a local Windows machine using PowerShell cmdlets
Manage Windows 10 using PowerShell
Manage permissions with PowerShell
8 - Understand the Windows PowerShell pipeline
Review Windows PowerShell pipeline and its output
Discover object members in PowerShell
Control the formatting of pipeline output
9 - Select, sort, and measure objects using the pipeline
Sort and group objects by property in the pipeline
Measure objects in the pipeline
Select a set of objects in the pipeline
Select object properties in the pipeline
Create and format calculated properties in the pipeline
10 - Filter objects out of the pipeline
Learn about the comparison operators in PowerShell
Review basic filter syntax in the pipeline
Review advanced filter syntax in the pipeline
Optimize the filter performance in the pipeline
11 - Enumerate objects in the pipeline
Learn about enumerations in the pipeline
Review basic syntax to enumerate objects in the pipeline
Review advanced syntax to enumerate objects in the pipeline
12 - Send and pass data as output from the pipeline
Write pipeline data to a file
Convert pipeline objects to other forms of data representation in PowerShell
Control additional output options in PowerShell
13 - Pass pipeline objects
Pipeline parameter binding
Identify ByValue parameters
Pass data by using ByValue
Pass data by using ByPropertyName
Identify ByPropertyName parameters
Use manual parameters to override the pipeline
Use parenthetical commands
Expand property values
14 - Connect with data stores using PowerShell providers
Define Windows PowerShell providers
Review the built-in providers in PowerShell
Access provider help in PowerShell
15 - Use PowerShell drives in PowerShell
Explain PowerShell drives in PowerShell
Use PowerShell drive cmdlets in PowerShell
Manage the file system in PowerShell
Manage the registry in PowerShell
Work with certificates in PowerShell
Work with other PowerShell drives in PowerShell
16 - Review CIM and WMI
Review architecture of CIM and WMI
Review repositories in CIM and WMI
Locate online class documentation by using CIM and WMI cmdlets
17 - Query configuration information by using CIM and WMI
List local repository namespaces and classes by using CIM and WMI
Query instances by using commands and WMI Query Language
Connect to remote computers by using CIM and WMI cmdlets
Query repository classes from remote computers by using CIMSession objects
18 - Query and manipulate repository objects by using CIM and WMI methods
Discover methods of repository objects by using CIM and WMI
Locate class methods and documentation by using CIM and WMI
Invoke methods of repository objects by using CIM and WMI
19 - Manage variables in Windows PowerShell scripts
Define variables in Windows PowerShell scripts
Create variable names in Windows PowerShell scripts
Assign values and types to variables in Windows PowerShell scripts
Identify the methods and properties of variables in Windows PowerShell scripts
Use string variables and methods in Windows PowerShell scripts
Use date variables and methods in Windows PowerShell scripts
20 - Work with arrays and hash tables in Windows PowerShell scripts
Define an array in Windows PowerShell scripts
Work with array lists in Windows PowerShell scripts
Define hash tables in Windows PowerShell Scripts
Work with hash tables in Windows PowerShell scripts
21 - Create and run scripts by using Windows PowerShell
Review Windows PowerShell scripts
Modify scripts in the PowerShell Gallery
Create scripts using Windows PowerShell
Review the PowerShellGet module in Windows PowerShell
Run scripts and set the execution policy in Windows PowerShell
Review Windows PowerShell and AppLocker
Sign the scripts digitally in Windows PowerShell
22 - Work with scripting constructs in Windows PowerShell
Review and use the ForEach loop in Windows PowerShell scripts
Review and use the If construct in Windows PowerShell scripts
Review and use the Switch construct in Windows PowerShell scripts
Review the For construct in Windows PowerShell scripts
Review other loop constructs in Windows PowerShell scripts
Review Break and Continue in Windows PowerShell scripts
23 - Import data in different formats for use in scripts by using Windows PowerShell cmdlets
Use the Get-Content command in Windows PowerShell scripts
Use the Import-Csv cmdlet in Windows PowerShell scripts
Use the Import-Clixml cmdlet in Windows PowerShell scripts
Use the ConvertFrom-Json cmdlet in Windows PowerShell scripts
24 - Use methods to accept user inputs in Windows PowerShell scripts
Identify values that might change in Windows PowerShell scripts
Use the Read-Host cmdlet in Windows PowerShell scripts
Use the Get-Credential cmdlet in Windows PowerShell scripts
Use the Out-GridView cmdlet in Windows PowerShell scripts
Pass parameters to a Windows PowerShell script
25 - Troubleshoot scripts and handle errors in Windows PowerShell
Interpret error messages generated for Windows PowerShell commands
Add output to Windows PowerShell scripts
Use breakpoints in Windows PowerShell scripts
Interpret error actions for Windows PowerShell commands
26 - Use functions and modules in Windows PowerShell scripts
Review functions in Windows PowerShell scripts
Use variable scope in Windows PowerShell scripts
Create modules in Windows PowerShell scripts
Use the dot sourcing feature in Windows PowerShell
27 - Manage single and multiple computers by using Windows PowerShell remoting
Review the remoting feature of Windows PowerShell
Compare remoting with remote connectivity
Review the remoting security feature of Windows PowerShell
Enable remoting by using Windows PowerShell
Use one-to-one remoting by using Windows PowerShell
Use one-to-many remoting by using Windows PowerShell
Compare remoting output with local output
28 - Use advanced Windows PowerShell remoting techniques
Review common remoting techniques of Windows PowerShell
Send parameters to remote computers in Windows PowerShell
Set access protection to variables, aliases, and functions by using the scope modifier
Enable multi-hop remoting in Windows PowerShell
29 - Manage persistent connections to remote computers by using Windows PowerShell sessions
Review persistent connections in Windows PowerShell
Create and manage persistent PSSessions by using Windows PowerShell
Disconnect PSSessions by using Windows PowerShell
Review the feature of implicit remoting in Windows PowerShell
30 - Review Azure PowerShell module
Review Azure PowerShell
Review the benefits of the Azure PowerShell module
Install the Azure PowerShell module
Migrate Azure PowerShell from AzureRM to Azure
Review Microsoft Azure Active Directory module for Windows PowerShell and Azure Active Directory PowerShell for Graph modules
31 - Review the features and tools for Azure Cloud Shell
Review the characteristics of Azure Cloud Shell
Review the features and tools of Azure Cloud Shell
Configure and experiment with Azure Cloud Shell
32 - Manage Azure resources with Windows PowerShell
Create a new Azure virtual machine by using Windows PowerShell commands
Manage Azure virtual machines by using Windows PowerShell commands
Manage Azure related storage by using Azure PowerShell
Manage Azure subscriptions by using Azure PowerShell
33 - Manage users, groups, and licenses in Microsoft Entra ID by using Windows PowerShell
Review benefits to manage Microsoft 365 services by using Windows PowerShell
Connect to the Microsoft 365 tenant by using Windows PowerShell
Manage users in Microsoft 365 by using Windows PowerShell
Manage groups in Microsoft 365 by using Windows PowerShell
Manage roles in Microsoft 365 by using Windows PowerShell
Manage licenses in Microsoft 365 by using Windows PowerShell
34 - Manage Exchange Online by using Windows PowerShell
Connect to Exchange Online by using Windows PowerShell
Manage mailboxes in Exchange Online by using Windows PowerShell
Manage resources in Exchange Online by using Windows PowerShell
Manage admin roles in Exchange Online by using Windows PowerShell
35 - Manage SharePoint Online by using Windows PowerShell
Install and connect to SharePoint Online Management Shell by using Windows PowerShell
Manage SharePoint Online users and groups by using Windows PowerShell
Manage SharePoint sites by using Windows PowerShell
Manage SharePoint Online external user sharing by using Windows PowerShell
36 - Manage Microsoft Teams by using Windows PowerShell
Review Microsoft Teams PowerShell module
Install the Microsoft Teams PowerShell module
Manage teams with Microsoft Teams PowerShell module
37 - Create and manage background jobs using Windows PowerShell
Define the types of background jobs in Windows PowerShell
Start remote jobs and CIM/WMI jobs in Windows PowerShell
Monitor jobs in Windows PowerShell
Retrieve results for running jobs in Windows PowerShell
38 - Create and manage scheduled jobs using Windows PowerShell
Create and run Windows PowerShell scripts as scheduled tasks
Define scheduled jobs in Windows PowerShell
Create job option and job trigger objects in Windows PowerShell
Create and register a scheduled job in Windows PowerShell
Retrieve the results from a scheduled job in Windows PowerShell

Azure PowerShell

Powershell

Microsoft AZ-104

Power Automate

Microsoft AZ-303

Microsoft Power Automate

AZ-040T00 Automating Administration with Powershell

<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

Azure SQL Database

Microsoft SQL Server

Computer Skills

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

<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
			<div></div>
		</div>
				</div>
				</div>
				<div>
				<div>
			
				</div>
				<div>
				<div>
					<div><p>Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This CCTV Operator Course has been specially designed to help learners gain a good command of CCTV Operator Course, providing them with a solid foundation of knowledge to become a qualified professional.</p><p>Through this CCTV Operator Course, you will gain both practical and theoretical understanding of CCTV Operator Course that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.</p><p>Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals. </p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</div></section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2><b> Learning outcome</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Familiar yourself with the recent development and updates of the relevant industry</span>
									</li>
								<li>
											<span>
													</span>
										<span>Know how to use your theoretical knowledge to adapt in any working environment</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get help from our expert tutors anytime you need</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to course contents that are designed and prepared by industry professionals</span>
									</li>
								<li>
											<span>
													</span>
										<span>Study at your convenient time and from wherever you want</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					
			</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Why should I take this course?</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Affordable premium-quality E-learning content, you can learn at your own pace.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will receive a completion certificate upon completing the course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Internationally recognized Accredited Qualification will boost up your resume.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will learn the researched and proven approach adopted by successful people to transform their careers.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will be able to incorporate various techniques successfully and understand your customers better.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Requirements</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>No formal qualifications required, anyone from any academic background can take this course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to a computer or digital device with internet connectivity.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section><div>
                            <div>
                                <h2>Course Curriculum</h2>
                            </div>
                            			<div>
				

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"><strong>Module 01: Operational Requirement</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Operational Requirement</td><td><span>🕐 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Module 02: CCTV Operator Skills and Ability</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>CCTV Operator Skills and Ability</td><td><span>🕐 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Module 03: Basics of CCTV</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Basics of CCTV</td><td><span>🕐 00:10:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Module 04: Technical Guidance</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Technical Guidance</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Module 05: Monitoring CCTV Cameras</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Monitoring CCTV Cameras</td><td><span>🕐 00:10:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Module 06: Watch Surveillance</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Watch Surveillance</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Module 07: Data Protection Regulations</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Data Protection Regulations</td><td><span>🕐 00:10:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Module 08: Job Requirements of a CCTV Operator</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Job Requirements of a CCTV Operator</td><td><span>🕐 00:10:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Assignment</strong></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Assignment - CCTV Operator Course</td><td><span>🕐 05:01:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
		                        </div>

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This CCTV Operator Course has been specially designed to help learners gain a good command of CCTV Operator Course, providing them with a solid foundation of knowledge to become a qualified professional.
Through this CCTV Operator Course, you will gain both practical and theoretical understanding of CCTV Operator Course that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.
Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals. 
 Learning outcome
Familiar yourself with the recent development and updates of the relevant industry
Know how to use your theoretical knowledge to adapt in any working environment
Get help from our expert tutors anytime you need
Access to course contents that are designed and prepared by industry professionals
Study at your convenient time and from wherever you want
 Why should I take this course?
Affordable premium-quality E-learning content, you can learn at your own pace.
You will receive a completion certificate upon completing the course.
Internationally recognized Accredited Qualification will boost up your resume.
You will learn the researched and proven approach adopted by successful people to transform their careers.
You will be able to incorporate various techniques successfully and understand your customers better.
 Requirements
No formal qualifications required, anyone from any academic background can take this course.
Access to a computer or digital device with internet connectivity.
Course Curriculum
Module 01: Operational Requirement			
▶	Operational Requirement	🕐 00:12:00
Module 02: CCTV Operator Skills and Ability			
▶	CCTV Operator Skills and Ability	🕐 00:11:00
Module 03: Basics of CCTV			
▶	Basics of CCTV	🕐 00:10:00
Module 04: Technical Guidance			
▶	Technical Guidance	🕐 00:09:00
Module 05: Monitoring CCTV Cameras			
▶	Monitoring CCTV Cameras	🕐 00:10:00
Module 06: Watch Surveillance			
▶	Watch Surveillance	🕐 00:09:00
Module 07: Data Protection Regulations			
▶	Data Protection Regulations	🕐 00:10:00
Module 08: Job Requirements of a CCTV Operator			
▶	Job Requirements of a CCTV Operator	🕐 00:10:00
Assignment			
	Assignment - CCTV Operator Course	🕐 05:01:00

Skill Up

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

CCTV Operator Course

<p>Embark on a journey into the world of surveillance with our comprehensive '<strong>CCTV Operator Course</strong>.' In Module 01, delve into the operational requirements that lay the foundation for effective surveillance, setting the stage for an in-depth exploration. As you progress to Module 02, hone your skills and abilities as a CCTV operator, mastering the art of vigilant observation. Modules 03 and 04 unravel the intricacies of CCTV technology, providing a solid technical foundation to navigate the surveillance landscape. Module 05 and Module 06 transform you into a watchful guardian, teaching the nuances of monitoring cameras and conducting surveillance with precision. Data protection takes the spotlight in Module 07, ensuring you understand the regulations that govern your crucial role. Finally, Module 08 unveils the job requirements of a CCTV operator, equipping you for a fulfilling career in surveillance.</p>
<p><strong>Learning Outcomes</strong></p>
<ul>
<li>Understand the operational requirements that form the backbone of effective surveillance.</li>
<li>Hone essential skills and abilities crucial for success as a vigilant CCTV operator.</li>
<li>Acquire a solid understanding of the basics of CCTV technology.</li>
<li>Receive technical guidance to navigate and troubleshoot CCTV systems.</li>
<li>Master the art of monitoring CCTV cameras, conducting watchful surveillance with precision.</li>
</ul>
<h3><b>Why choose this CCTV Operator Course?</b></h3>
<ol>
<li>Unlimited access to the course for a lifetime.</li>
<li>Opportunity to earn a certificate accredited by the <b>CPD Quality Standards</b> and <b>CIQ </b>after completing this course.</li>
<li>Structured lesson planning in line with industry standards.</li>
<li>Immerse yourself in innovative and captivating course materials and activities.</li>
<li>Assessments designed to evaluate advanced cognitive abilities and skill proficiency.</li>
<li>Flexibility to complete the Course at your own pace, on your own schedule.</li>
<li>Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.</li>
<li>Unlock career resources for CV improvement, interview readiness, and job success.</li>
</ol>
<h3><b>Who is this CCTV Operator Course</b><b><span> </span></b><b>for?</b></h3>
<ul>
<li>Individuals aspiring to pursue a career as a CCTV operator.</li>
<li>Security professionals aiming to enhance their surveillance skills.</li>
<li>Job seekers interested in roles related to security and surveillance.</li>
<li>Entrepreneurs or business owners looking to bolster their premises' security.</li>
<li>Students with an interest in technology and surveillance systems.</li>
</ul>
<h3><b>Career path</b></h3>
<ul>
<li><strong>CCTV Operator:</strong> £20,000 - £30,000</li>
<li><strong>Surveillance Specialist:</strong> £25,000 - £35,000</li>
<li><strong>Security Supervisor:</strong> £22,000 - £32,000</li>
<li><strong>Loss Prevention Officer:</strong> £18,000 - £28,000</li>
<li><strong>Security Consultant:</strong> £30,000 - £45,000</li>
<li><strong>Corporate Security Manager:</strong> £35,000 - £50,000</li>
</ul>
<h3><b>Prerequisites</b></h3>
<p><span>This </span><b>CCTV Operator Course</b><span> does not require you to have any prior qualifications or experience. You can just enrol and start learning.This </span><b>CCTV Operator Course</b><span> was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.</span></p>
<h3><b>Certification</b></h3>
<p><span>After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.</span></p><div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Module 01: Operational Requirement</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Operational Requirement</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 02: CCTV Operator Skills and Ability</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>CCTV Operator Skills and Ability</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 03: Basics of CCTV  </td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Basics of CCTV</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 04: Technical Guidance</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Technical Guidance</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 05: Monitoring CCTV Cameras</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Monitoring CCTV Cameras</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 06: Watch Surveillance</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Watch Surveillance</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 07: Data Protection Regulations</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Protection Regulations</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Module 08: Job Requirements of a CCTV Operator</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Job Requirements of a CCTV Operator</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Assignment</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Assignment - CCTV Operator Course</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

Embark on a journey into the world of surveillance with our comprehensive 'CCTV Operator Course.' In Module 01, delve into the operational requirements that lay the foundation for effective surveillance, setting the stage for an in-depth exploration. As you progress to Module 02, hone your skills and abilities as a CCTV operator, mastering the art of vigilant observation. Modules 03 and 04 unravel the intricacies of CCTV technology, providing a solid technical foundation to navigate the surveillance landscape. Module 05 and Module 06 transform you into a watchful guardian, teaching the nuances of monitoring cameras and conducting surveillance with precision. Data protection takes the spotlight in Module 07, ensuring you understand the regulations that govern your crucial role. Finally, Module 08 unveils the job requirements of a CCTV operator, equipping you for a fulfilling career in surveillance.
Learning Outcomes
Understand the operational requirements that form the backbone of effective surveillance.
Hone essential skills and abilities crucial for success as a vigilant CCTV operator.
Acquire a solid understanding of the basics of CCTV technology.
Receive technical guidance to navigate and troubleshoot CCTV systems.
Master the art of monitoring CCTV cameras, conducting watchful surveillance with precision.
Why choose this CCTV Operator Course?
Unlimited access to the course for a lifetime.
Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course.
Structured lesson planning in line with industry standards.
Immerse yourself in innovative and captivating course materials and activities.
Assessments designed to evaluate advanced cognitive abilities and skill proficiency.
Flexibility to complete the Course at your own pace, on your own schedule.
Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.
Unlock career resources for CV improvement, interview readiness, and job success.
Who is this CCTV Operator Course for?
Individuals aspiring to pursue a career as a CCTV operator.
Security professionals aiming to enhance their surveillance skills.
Job seekers interested in roles related to security and surveillance.
Entrepreneurs or business owners looking to bolster their premises' security.
Students with an interest in technology and surveillance systems.
Career path
CCTV Operator: £20,000 - £30,000
Surveillance Specialist: £25,000 - £35,000
Security Supervisor: £22,000 - £32,000
Loss Prevention Officer: £18,000 - £28,000
Security Consultant: £30,000 - £45,000
Corporate Security Manager: £35,000 - £50,000
Prerequisites
This CCTV Operator Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This CCTV Operator Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.
Certification
After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.
 Course Curriculum

Module 01: Operational Requirement			
	Operational Requirement		00:12:00
Module 02: CCTV Operator Skills and Ability			
	CCTV Operator Skills and Ability		00:11:00
Module 03: Basics of CCTV			
	Basics of CCTV		00:10:00
Module 04: Technical Guidance			
	Technical Guidance		00:09:00
Module 05: Monitoring CCTV Cameras			
	Monitoring CCTV Cameras		00:10:00
Module 06: Watch Surveillance			
	Watch Surveillance		00:09:00
Module 07: Data Protection Regulations			
	Data Protection Regulations		00:10:00
Module 08: Job Requirements of a CCTV Operator			
	Job Requirements of a CCTV Operator		00:10:00
Assignment			
	Assignment - CCTV Operator Course		00:00:00

207 Operator courses in London

Rhino 3d training course 1-2-1

By Real Animation Works

NPORS Crawler Crane (N103)

By Dynamic Training and Assessments Ltd

NPORS Appointed Person (N401)

By Dynamic Training and Assessments Ltd

NPORS Rigging and Fleeting Loads Lift Planner (N046)

By Dynamic Training and Assessments Ltd

NPORS Vehicle Marshal (N403)

By Dynamic Training and Assessments Ltd

NPORS Manual Handling (N704)

By Dynamic Training and Assessments Ltd

NPORS Plant Machinery Marshal (N133)

By Dynamic Training and Assessments Ltd

NPORS Excavation Marshall - Banksperson (N027)

By Dynamic Training and Assessments Ltd

NPORS Plant Loader and Securer (N120)

By Dynamic Training and Assessments Ltd

NPORS Harness and Fall Arrest (N723)

By Dynamic Training and Assessments Ltd

Search By Location