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;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator</li><li fr-original-style="" style="box-sizing: border-box;">Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify key controls and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Set up exclusion zone</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for overhead crane use</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational and running checks in accordance with manufacturer&rsquo;s and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Prepare the overhead crane for use and operate machine safely and efficiently</li><li fr-original-style="" style="box-sizing: border-box;">Environmental considerations</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of work and shut down procedures</li></ul><h2 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Entry Requirements</h2><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 operator
Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
Be able to locate and identify the major components of the machine and explain their functions
Be able to locate and identify key controls and explain their functions
Set up exclusion zone
Identify and maintain PPE appropriate for overhead crane use
Conduct all pre-operational and running checks in accordance with manufacturer’s and legislative requirements
Prepare the overhead crane for use and operate machine safely and efficiently
Environmental considerations
Carry out all end of work and shut down procedures
Entry Requirements
Please note, that in all cases, operators are required to supply proof to support their application. They have to have passed the CITB health, safety & environmental touch screen test within two years prior to their application.
Good understanding of spoken and written English.

Dynamic Training and Assessments Ltd

Construction

CSCS (Construction Skills Certification Scheme)

NPORS

NPORS Overhead Crane (N104)

<p style="color: rgb(32, 42, 68); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(32, 42, 68);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Information&nbsp;</strong></p><p style="color: rgb(32, 42, 68); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(32, 42, 68);">By the end of this course, delegates will be able to:</p><ul style="color: rgb(32, 42, 68); box-sizing: border-box;" fr-original-style=" color: rgb(32, 42, 68);"><li fr-original-style="" style="box-sizing: border-box;">Identify the roles and responsibilities&rsquo; of supervisor having understanding of relevant policies, procedures, legislations, risk assessments, method statements and traffic management</li><li fr-original-style="" style="box-sizing: border-box;">Check test certification of equipment and accessories to be used</li><li fr-original-style="" style="box-sizing: border-box;">Safely supervise various tasks and different environments</li><li fr-original-style="" style="box-sizing: border-box;">Carry out a toolbox talk/ safety briefing allocating roles to team</li><li fr-original-style="" style="box-sizing: border-box;">Liaise with both management and operator&rsquo;s</li><li fr-original-style="" style="box-sizing: border-box;">Produce a safe system of work giving a safe step by step guide for team to follow</li><li fr-original-style="" style="box-sizing: border-box;">Produce risk assessment</li><li fr-original-style="" style="box-sizing: border-box;">Hold a debrief with team and discuss any lessons learned</li></ul><div style="color: rgb(38, 49, 62); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 49, 62);"><h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Entry Requirements</strong></h2></div><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">NPORS CSCS &ndash; Candidates must have achieved the relevant CITB Health, Safety &amp; Environment (HS&amp;E) touch-screen-test within 2 years.</p><p style="color: rgb(38, 49, 62); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 49, 62);">Good understanding of spoken and written English.</p>

Course Information 
By the end of this course, delegates will be able to:
Identify the roles and responsibilities’ of supervisor having understanding of relevant policies, procedures, legislations, risk assessments, method statements and traffic management
Check test certification of equipment and accessories to be used
Safely supervise various tasks and different environments
Carry out a toolbox talk/ safety briefing allocating roles to team
Liaise with both management and operator’s
Produce a safe system of work giving a safe step by step guide for team to follow
Produce risk assessment
Hold a debrief with team and discuss any lessons learned
Entry Requirements
NPORS CSCS – Candidates must have achieved the relevant CITB Health, Safety & Environment (HS&E) touch-screen-test within 2 years.
Good understanding of spoken and written English.

NPORS Lift Truck Supervisor Awareness (N036)

<p style="color: rgb(32, 42, 68); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(32, 42, 68);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Description:</strong></p><p style="color: rgb(32, 42, 68); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(32, 42, 68);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p style="color: rgb(32, 42, 68); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(32, 42, 68);"><span style="color: rgb(32, 42, 68); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(32, 42, 68);">This 1 day course is aimed at supervisors/team leaders/managers to provide an understanding of the correct plant operating procedures that should be adopted by plant operators in the workplace.</span></p><ul style="color: rgb(32, 42, 68); box-sizing: border-box;" fr-original-style=" color: rgb(32, 42, 68);"><li fr-original-style="" style="box-sizing: border-box;">Identify the roles and responsibilities&rsquo; of supervisor having understanding of relevant policies, procedures, legislations, risk assessments, method statements and traffic management</li><li fr-original-style="" style="box-sizing: border-box;">Check test certification of equipment and accessories to be used</li><li fr-original-style="" style="box-sizing: border-box;">Safely supervise various tasks and different environments</li><li fr-original-style="" style="box-sizing: border-box;">Carry out a toolbox talk/ safety briefing allocating roles to team</li><li fr-original-style="" style="box-sizing: border-box;">Liaise with both management and operator&rsquo;s</li><li fr-original-style="" style="box-sizing: border-box;">Produce a safe system of work giving a safe step by step guide for team to follow</li><li fr-original-style="" style="box-sizing: border-box;">Produce risk assessment</li><li fr-original-style="" style="box-sizing: border-box;">Hold a debrief with team and discuss any lessons learned</li></ul><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>

Course Description:


This 1 day course is aimed at supervisors/team leaders/managers to provide an understanding of the correct plant operating procedures that should be adopted by plant operators in the workplace.
Identify the roles and responsibilities’ of supervisor having understanding of relevant policies, procedures, legislations, risk assessments, method statements and traffic management
Check test certification of equipment and accessories to be used
Safely supervise various tasks and different environments
Carry out a toolbox talk/ safety briefing allocating roles to team
Liaise with both management and operator’s
Produce a safe system of work giving a safe step by step guide for team to follow
Produce risk assessment
Hold a debrief with team and discuss any lessons learned



NPORS Plant Supervisor Awareness (N034)

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

<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;">The NPORS&nbsp;Shunter Vehicle&nbsp;course is for drivers who do not hold an HGV licence but are required to &#39;shunt&#39; vehicles etc. around on company premises. Shunter training allows these drivers to drive maximum weight articulated and rigged vehicles on-site only around the business premises.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We will conduct a learner analysis to identify the duration of training required for those with limited or no experience, whereas experienced operators can attend a one day Experienced Worker Assessment (Test Only).</p><h2 fr-original-style="" style="box-sizing: border-box;">NPORS Shunter Vehicle (N243) Course Content</h2><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, the dangers of working in the industry and their responsibilities as an operator</li><li fr-original-style="" style="box-sizing: border-box;">Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for Shunter Vehicle use</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area</li><li fr-original-style="" style="box-sizing: border-box;">Prepare the Shunter Vehicle for use and operate machinery safely and efficiently</li><li fr-original-style="" style="box-sizing: border-box;">Attach and set trailers ready for operation</li><li fr-original-style="" style="box-sizing: border-box;">Environmental considerations</li><li fr-original-style="" style="box-sizing: border-box;">Transport and uncouple Shunter Vehicle attachments</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.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Good understanding of spoken and written English.</p></div>

COURSE INFORMATION
The NPORS Shunter Vehicle course is for drivers who do not hold an HGV licence but are required to 'shunt' vehicles etc. around on company premises. Shunter training allows these drivers to drive maximum weight articulated and rigged vehicles on-site only around the business premises.
We will conduct a learner analysis to identify the duration of training required for those with limited or no experience, whereas experienced operators can attend a one day Experienced Worker Assessment (Test Only).
NPORS Shunter Vehicle (N243) Course Content
To provide knowledge and understanding in the following areas:
Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator
Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
Be able to locate and identify the major components of the machine and explain their functions
Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
Identify and maintain PPE appropriate for Shunter Vehicle use
Conduct all necessary safety checks at the work area
Prepare the Shunter Vehicle for use and operate machinery safely and efficiently
Attach and set trailers ready for operation
Environmental considerations
Transport and uncouple Shunter Vehicle attachments
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 Shunter Vehicle (N243)

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

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

NPORS Skidsteer Loader (N212)

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

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

NPORS Crawler Crane (N103)

<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, the dangers of working in the industry and their responsibilities as a plant operator</li><li fr-original-style="" style="box-sizing: border-box;">Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify steering, driving and braking controls and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Safely mount and dismount the machine</li><li fr-original-style="" style="box-sizing: border-box;">Start and stop the engine and safely move the machine off and stop it safely</li><li fr-original-style="" style="box-sizing: border-box;">Configure the machine for travel and maneuver it safely laden and unladen, in open and confined areas</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all necessary safety checks at the work area</li><li fr-original-style="" style="box-sizing: border-box;">Maneuver the machine to the work area and correctly configure in readiness to carry out lifting and load handling tasks</li><li fr-original-style="" style="box-sizing: border-box;">Carry out lifting and load handling tasks</li><li fr-original-style="" style="box-sizing: border-box;">Lift and transfer loads accurately and safely at different locations</li><li fr-original-style="" style="box-sizing: border-box;">Load and unload external transport safely</li><li fr-original-style="" style="box-sizing: border-box;">Fit, adjust and or remove attachments</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down procedures</li></ul><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, the dangers of working in the industry and their responsibilities as a plant operator
Have a working knowledge of the manufacturer’s handbook for the particular machine to be used
Be able to locate and identify the major components of the machine and explain their functions
Be able to locate and identify steering, driving and braking controls and explain their functions
Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
Safely mount and dismount the machine
Start and stop the engine and safely move the machine off and stop it safely
Configure the machine for travel and maneuver it safely laden and unladen, in open and confined areas
Conduct all necessary safety checks at the work area
Maneuver the machine to the work area and correctly configure in readiness to carry out lifting and load handling tasks
Carry out lifting and load handling tasks
Lift and transfer loads accurately and safely at different locations
Load and unload external transport safely
Fit, adjust and or remove attachments
Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation
Carry out all end of shift and shut down procedures
Entry Requirements
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 Side Loader (N006)

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

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

NPORS Road Roller (N214)

London

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

		<div> 
						 

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




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



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

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

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

PCWorkshops

Microsoft SQL Server

Database Programming

SQL Server

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

SQL Course Advanced, 2 Days

General admission

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

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

Pronounce Languages

Spanish

Language Teaching

Teaching Online

Online Education

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

10-week Spanish course for Absolute Beginners (Level 1)

General Admission

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">On this webinar, we will discuss how market forces impact funds, Real estate investment trusts and private equity firms in Real Estate.</p>

On this webinar, we will discuss how market forces impact funds, Real estate investment trusts and private equity firms in Real Estate.

Bayfield Training

Free Webinar | How market forces impact funds, REITS and Private Equity firms in Real Estate

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Using a trauma informed approach to workplace bullying &amp; harassment cases reduces the risks of adding another layer of injury. We look at how workplace trauma develops, and how it is different from other traumas, and what that means in terms of being able to present the facts in an investigation.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">WHAT YOU&#39;LL LEARN...</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">What is trauma?&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">How workplace bullying trauma develops&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Injuries caused by bullying &amp; harassment&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Understanding the injury to the brain&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">The neuroscience of trauma and memory&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">The workplace as the traumatiser&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Institutional betrayal&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">The challenges for investigators&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Purpose and perception of investigations&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Current policies and best practice - and their flaws&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Strategies for a trauma informed approach&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">How to avoid secondary trauma&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Reporting outcomes &amp; recommendations</li><li fr-original-style="" style="box-sizing: border-box;">Longer term recovery for individuals and organisations&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Keeping yourself safe from vicarious trauma</li></ul>

Using a trauma informed approach to workplace bullying & harassment cases reduces the risks of adding another layer of injury. We look at how workplace trauma develops, and how it is different from other traumas, and what that means in terms of being able to present the facts in an investigation.
WHAT YOU'LL LEARN...
What is trauma?
How workplace bullying trauma develops
Injuries caused by bullying & harassment
Understanding the injury to the brain
The neuroscience of trauma and memory
The workplace as the traumatiser
Institutional betrayal
The challenges for investigators
Purpose and perception of investigations
Current policies and best practice - and their flaws
Strategies for a trauma informed approach
How to avoid secondary trauma
Reporting outcomes & recommendations
Longer term recovery for individuals and organisations
Keeping yourself safe from vicarious trauma

Conduct Change Ltd

Conflict Resolution

Behaviour Change

Lawyer

Emotional Wellbeing

Harassment

Investigation

Trauma Informed

Psychology

Neuroscience

Mediation

Employment Law

Investigator

Mediator

A TRAUMA INFORMED APPROACH TO WORKPLACE BULLYING & HARASSMENT CASES

Using a trauma informed approach to workplace bullying & harassment cases reduces the risks of adding another layer of injury. We look at how workplace trauma develops, and how it is different from other traumas, and what that means in terms of being able to present the facts in an investigation.



A Trauma Informed Approach to Workplace Bullying Cases

<p id="isPasted" style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">LOOKING FOR:</strong> ADULT FICTION, NON-FICTION</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">Sian Ellis-Martin joined Blake Friedmann in 2018 and is building a list of fiction and non-fiction at the agency.&nbsp;</span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">With regards to fiction, Sian is looking for commercial, upmarket and accessible literary novels. She always wants to be completely absorbed by the world of the novel, to jump into the character&rsquo;s life and be swept into the narrative as if she&rsquo;s been there all along. She&rsquo;s drawn in by compelling characters and relationships, and loves stories with a mystery or question at the heart of them. She&rsquo;s open to these ideas being explored in a variety of ways, but at the moment, she&rsquo;d particularly like to find an epic love story, a fun, queer rom-com with an unusual setting or pitch, and/or a sweeping family saga. She leans more towards contemporary settings but does enjoy a historical backdrop too.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">In non-fiction, she&rsquo;s looking for narrative non-fiction, history from different perspectives and books that make complicated ideas around things like politics and literature more accessible. Her favourite type of non-fiction book is the one that makes you interested in something or someone you&rsquo;d never thought you would be. She&rsquo;d also love to find cookery and food books too, particularly cuisines that are less visible in the book world, or budget cooking.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">She&rsquo;s not currently taking on YA, children&rsquo;s, fantasy or science fiction projects.</span></p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">Sian would like you to submit a covering letter, 1 - 2 page synopsis and the first three chapters (or 5,000 words) of your manuscript in a single word document.&nbsp;</strong></p><p id="isPasted" style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">(<em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">In addition to the paid sessions, Sian is kindly offering one free session for low income/under-represented writers. Please email <a href="mailto:agent121@iaminprint.co.uk" style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto; font-size: var(--font-size);" fr-original-style="box-sizing: border-box; text-decoration: inherit; cursor: pointer; user-select: auto;">agent121@iaminprint.co.uk</a> to apply, outlining your case for this option which is offered at the&nbsp;</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">discretion of&nbsp;</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print)</em>.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">By booking you understand you need to conduct an internet connection test with<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Pr</em><em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">int</em> prior to the event. You also agree to email your material in one document to reach <em fr-original-style="" style="box-sizing: border-box;">I Am In Print</em> by the stated submission deadline 20and note that <em style="box-sizing: border-box;" fr-original-style="box-sizing: border-box;">I Am In Print</em> take no responsibility for the advice received during your agent meeting.</p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">Please prepare to submit your manuscript immediately you book as the submission deadline is now: Monday 8 July 2024</strong></p>

LOOKING FOR: ADULT FICTION, NON-FICTION
Sian Ellis-Martin joined Blake Friedmann in 2018 and is building a list of fiction and non-fiction at the agency. 
With regards to fiction, Sian is looking for commercial, upmarket and accessible literary novels. She always wants to be completely absorbed by the world of the novel, to jump into the character’s life and be swept into the narrative as if she’s been there all along. She’s drawn in by compelling characters and relationships, and loves stories with a mystery or question at the heart of them. She’s open to these ideas being explored in a variety of ways, but at the moment, she’d particularly like to find an epic love story, a fun, queer rom-com with an unusual setting or pitch, and/or a sweeping family saga. She leans more towards contemporary settings but does enjoy a historical backdrop too.
In non-fiction, she’s looking for narrative non-fiction, history from different perspectives and books that make complicated ideas around things like politics and literature more accessible. Her favourite type of non-fiction book is the one that makes you interested in something or someone you’d never thought you would be. She’d also love to find cookery and food books too, particularly cuisines that are less visible in the book world, or budget cooking.
She’s not currently taking on YA, children’s, fantasy or science fiction projects.
Sian would like you to submit a covering letter, 1 - 2 page synopsis and the first three chapters (or 5,000 words) of your manuscript in a single word document. 
(In addition to the paid sessions, Sian is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print). 
By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline 20and note that I Am In Print take no responsibility for the advice received during your agent meeting.
Submission Deadline: Monday 11 November 2024

I Am In Print

Fiction Writing

19th November Sian Ellis-Martin #Agent121. Looking for: ADULT FICTION, NON-FICTION

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>This course is for Azure Administrators. The Azure Administrator implements, manages, and monitors identity, governance, storage, compute, and virtual networks in a cloud environment. The Azure Administrator will provision, size, monitor, and adjust resources as appropriate.</p><p></p><p></p><p>This course teaches IT Professionals how to manage their Azure subscriptions, secure identities, administer the infrastructure, configure virtual networking, connect Azure and on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, implement web apps and containers, back up and share data, and monitor your solution.</p><p></p>Prerequisites<p>Successful Azure Administrators start this role with experience in virtualization, networking, identity, and storage. Understanding of on-premises virtualization technologies, including: VMs, virtual networking, and virtual hard disks. Understanding of network configurations, including TCP/IP, Domain Name System (DNS), virtual private networks (VPNs), firewalls, and encryption technologies. Understanding of Active Directory concepts, including users, groups, and role-based access control. Understanding of resilience and disaster recovery, including backup and restore operations.</p></div><div id="course-pills-2"><h3>1 - Configure Microsoft Entra ID</h3> <ul> <li>Describe Microsoft Entra ID benefits and features</li> <li>Describe Microsoft Entra concepts</li> <li>Compare Active Directory Domain Services to Microsoft Entra ID</li> <li>Select Microsoft Entra editions</li> <li>Implement Microsoft Entra join</li> <li>Implement Microsoft Entra self-service password reset</li> </ul> <h3>2 - Configure user and group accounts</h3> <ul> <li>Create user accounts</li> <li>Manage user accounts</li> <li>Create bulk user accounts</li> <li>Create group accounts</li> <li>Create administrative units</li> </ul> <h3>3 - Configure subscriptions</h3> <ul> <li>Identify Azure regions</li> <li>Implement Azure subscriptions</li> <li>Obtain an Azure subscription</li> <li>Identify Azure subscription usage</li> <li>Implement Microsoft Cost Management</li> <li>Apply resource tagging</li> <li>Apply cost savings</li> </ul> <h3>4 - Configure Azure Policy</h3> <ul> <li>Create management groups</li> <li>Implement Azure policies</li> <li>Create Azure policies</li> <li>Create policy definitions</li> <li>Create an initiative definition</li> <li>Scope the initiative definition</li> <li>Determine compliance</li> </ul> <h3>5 - Configure role-based access control</h3> <ul> <li>Implement role-based access control</li> <li>Create a role definition</li> <li>Create a role assignment</li> <li>Compare Azure roles to Microsoft Entra roles</li> <li>Apply role-based access control</li> <li>Review fundamental Azure RBAC roles</li> </ul> <h3>6 - Configure Azure resources with tools</h3> <ul> <li>Use the Azure portal</li> <li>Use Azure Cloud Shell</li> <li>Use Azure PowerShell</li> <li>Use Azure CLI</li> </ul> <h3>7 - Use Azure Resource Manager</h3> <ul> <li>Review Azure Resource Manager benefits</li> <li>Review Azure resource terminology</li> <li>Create resource groups</li> <li>Create Azure Resource Manager locks</li> <li>Reorganize Azure resources</li> <li>Remove resources and resource groups</li> <li>Determine resource limits</li> </ul> <h3>8 - Configure resources with Azure Resource Manager templates</h3> <ul> <li>Review Azure Resource Manager template advantages</li> <li>Explore the Azure Resource Manager template schema</li> <li>Explore the Azure Resource Manager template parameters</li> <li>Consider Bicep templates</li> <li>Review QuickStart templates</li> </ul> <h3>9 - Configure virtual networks</h3> <ul> <li>Plan virtual networks</li> <li>Create subnets</li> <li>Create virtual networks</li> <li>Plan IP addressing</li> <li>Create public IP addressing</li> <li>Associate public IP addresses</li> <li>Allocate or assign private IP addresses</li> </ul> <h3>10 - Configure network security groups</h3> <ul> <li>Implement network security groups</li> <li>Determine network security group rules</li> <li>Determine network security group effective rules</li> <li>Create network security group rules</li> <li>Implement application security groups</li> </ul> <h3>11 - Configure Azure DNS</h3> <ul> <li>Identify domains and custom domains</li> <li>Verify custom domain names</li> <li>Create Azure DNS zones</li> <li>Delegate DNS domains</li> <li>Add DNS record sets</li> <li>Plan for Azure Private DNS zones</li> <li>Review Azure Private DNS zone scenarios</li> </ul> <h3>12 - Configure Azure Virtual Network peering</h3> <ul> <li>Determine Azure Virtual Network peering uses</li> <li>Determine gateway transit and connectivity</li> <li>Create virtual network peering</li> <li>Extend peering with user-defined routes and service chaining</li> </ul> <h3>13 - Configure network routing and endpoints</h3> <ul> <li>Review system routes</li> <li>Identify user-defined routes</li> <li>Determine service endpoint uses</li> <li>Determine service endpoint services</li> <li>Identify private link uses</li> </ul> <h3>14 - Configure Azure Load Balancer</h3> <ul> <li>Determine Azure Load Balancer uses</li> <li>Implement a public load balancer</li> <li>Implement an internal load balancer</li> <li>Determine load balancer SKUs</li> <li>Create back-end pools</li> <li>Create health probes</li> <li>Create load balancer rules</li> </ul> <h3>15 - Configure Azure Application Gateway</h3> <ul> <li>Implement Azure Application Gateway</li> <li>Determine Azure Application Gateway routing</li> <li>Configure Azure Application Gateway components</li> </ul> <h3>16 - Configure storage accounts</h3> <ul> <li>Implement Azure Storage</li> <li>Explore Azure Storage services</li> <li>Determine storage account types</li> <li>Determine replication strategies</li> <li>Access storage</li> <li>Secure storage endpoints</li> </ul> <h3>17 - Configure Azure Blob Storage</h3> <ul> <li>Implement Azure Blob Storage</li> <li>Create blob containers</li> <li>Assign blob access tiers</li> <li>Add blob lifecycle management rules</li> <li>Determine blob object replication</li> <li>Upload blobs</li> <li>Determine Blob Storage pricing</li> </ul> <h3>18 - Configure Azure Storage security</h3> <ul> <li>Review Azure Storage security strategies</li> <li>Create shared access signatures</li> <li>Identify URI and SAS parameters</li> <li>Determine Azure Storage encryption</li> <li>Create customer-managed keys</li> <li>Apply Azure Storage security best practices</li> </ul> <h3>19 - Configure Azure Files and Azure File Sync</h3> <ul> <li>Compare storage for file shares and blob data</li> <li>Manage Azure file shares</li> <li>Create file share snapshots</li> <li>Implement Azure File Sync</li> <li>Identify Azure File Sync components</li> <li>Deploy Azure File Sync</li> </ul> <h3>20 - Configure Azure Storage with tools</h3> <ul> <li>Use Azure Storage Explorer</li> <li>Use the Azure Import/Export service</li> <li>Use the WAImportExport tool</li> <li>Use the AzCopy tool</li> </ul> <h3>21 - Configure virtual machines</h3> <ul> <li>Review cloud services responsibilities</li> <li>Plan virtual machines</li> <li>Determine virtual machine sizing</li> <li>Determine virtual machine storage</li> <li>Create virtual machines in the Azure portal</li> <li>Connect to virtual machines</li> </ul> <h3>22 - Configure virtual machine availability</h3> <ul> <li>Plan for maintenance and downtime</li> <li>Create availability sets</li> <li>Review update domains and fault domains</li> <li>Review availability zones</li> <li>Compare vertical and horizontal scaling</li> <li>Implement Azure Virtual Machine Scale Sets</li> <li>Create Virtual Machine Scale Sets</li> <li>Implement autoscale</li> <li>Configure autoscale</li> </ul> <h3>23 - Configure Azure App Service plans</h3> <ul> <li>Implement Azure App Service plans</li> <li>Determine Azure App Service plan pricing</li> <li>Scale up and scale out Azure App Service</li> <li>Configure Azure App Service autoscale</li> </ul> <h3>24 - Configure Azure App Service</h3> <ul> <li>Implement Azure App Service</li> <li>Create an app with App Service</li> <li>Explore continuous integration and deployment</li> <li>Create deployment slots</li> <li>Add deployment slots</li> <li>Secure your App Service app</li> <li>Create custom domain names</li> <li>Back up and restore your App Service app</li> <li>Use Azure Application Insights</li> </ul> <h3>25 - Configure Azure Container Instances</h3> <ul> <li>Compare containers to virtual machines</li> <li>Review Azure Container Instances</li> <li>Implement container groups</li> <li>Review the Docker platform</li> </ul> <h3>26 - Configure file and folder backups</h3> <ul> <li>Describe Azure Backup benefits</li> <li>Implement Backup Center for Azure Backup</li> <li>Configure Azure Recovery Services vault backup options</li> <li>Use the Microsoft Azure Recovery Services (MARS) agent</li> <li>Configure on-premises file and folder backups</li> </ul> <h3>27 - Configure virtual machine backups</h3> <ul> <li>Explore options to protect virtual machine data</li> <li>Create virtual machine snapshots in Azure Backup</li> <li>Set up Azure Recovery Services vault backup options</li> <li>Back up your virtual machines</li> <li>Restore your virtual machines</li> <li>Implement System Center DPM and Azure Backup Server</li> <li>Compare the MARS agent and Azure Backup Server</li> <li>Implement soft delete for your virtual machines</li> <li>Implement Azure Site Recovery</li> </ul> <h3>28 - Configure Azure Monitor</h3> <ul> <li>Describe Azure Monitor key capabilities</li> <li>Describe Azure Monitor components</li> <li>Define metrics and logs</li> <li>Identify monitoring data and tiers</li> <li>Describe activity log events</li> <li>Query the activity log</li> </ul> <h3>29 - Configure Azure alerts</h3> <ul> <li>Describe Azure Monitor alerts</li> <li>Manage Azure Monitor alerts</li> <li>Create alert rules</li> <li>Create action groups</li> </ul> <h3>30 - Configure Log Analytics</h3> <ul> <li>Determine Log Analytics uses</li> <li>Create a Log Analytics workspace</li> <li>Create Kusto (KQL) queries</li> <li>Structure Log Analytics queries</li> </ul> <h3>31 - Configure Network Watcher</h3> <ul> <li>Describe Azure Network Watcher features</li> <li>Review IP flow verify diagnostics</li> <li>Review next hop diagnostics</li> <li>Visualize the network topology</li> </ul></div>

Duration
4 Days
24 CPD hours
This course is intended for

This course is for Azure Administrators. The Azure Administrator implements, manages, and monitors identity, governance, storage, compute, and virtual networks in a cloud environment. The Azure Administrator will provision, size, monitor, and adjust resources as appropriate.


This course teaches IT Professionals how to manage their Azure subscriptions, secure identities, administer the infrastructure, configure virtual networking, connect Azure and on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, implement web apps and containers, back up and share data, and monitor your solution.

Prerequisites
Successful Azure Administrators start this role with experience in virtualization, networking, identity, and storage. Understanding of on-premises virtualization technologies, including: VMs, virtual networking, and virtual hard disks. Understanding of network configurations, including TCP/IP, Domain Name System (DNS), virtual private networks (VPNs), firewalls, and encryption technologies. Understanding of Active Directory concepts, including users, groups, and role-based access control. Understanding of resilience and disaster recovery, including backup and restore operations.
1 - Configure Microsoft Entra ID
Describe Microsoft Entra ID benefits and features
Describe Microsoft Entra concepts
Compare Active Directory Domain Services to Microsoft Entra ID
Select Microsoft Entra editions
Implement Microsoft Entra join
Implement Microsoft Entra self-service password reset
2 - Configure user and group accounts
Create user accounts
Manage user accounts
Create bulk user accounts
Create group accounts
Create administrative units
3 - Configure subscriptions
Identify Azure regions
Implement Azure subscriptions
Obtain an Azure subscription
Identify Azure subscription usage
Implement Microsoft Cost Management
Apply resource tagging
Apply cost savings
4 - Configure Azure Policy
Create management groups
Implement Azure policies
Create Azure policies
Create policy definitions
Create an initiative definition
Scope the initiative definition
Determine compliance
5 - Configure role-based access control
Implement role-based access control
Create a role definition
Create a role assignment
Compare Azure roles to Microsoft Entra roles
Apply role-based access control
Review fundamental Azure RBAC roles
6 - Configure Azure resources with tools
Use the Azure portal
Use Azure Cloud Shell
Use Azure PowerShell
Use Azure CLI
7 - Use Azure Resource Manager
Review Azure Resource Manager benefits
Review Azure resource terminology
Create resource groups
Create Azure Resource Manager locks
Reorganize Azure resources
Remove resources and resource groups
Determine resource limits
8 - Configure resources with Azure Resource Manager templates
Review Azure Resource Manager template advantages
Explore the Azure Resource Manager template schema
Explore the Azure Resource Manager template parameters
Consider Bicep templates
Review QuickStart templates
9 - Configure virtual networks
Plan virtual networks
Create subnets
Create virtual networks
Plan IP addressing
Create public IP addressing
Associate public IP addresses
Allocate or assign private IP addresses
10 - Configure network security groups
Implement network security groups
Determine network security group rules
Determine network security group effective rules
Create network security group rules
Implement application security groups
11 - Configure Azure DNS
Identify domains and custom domains
Verify custom domain names
Create Azure DNS zones
Delegate DNS domains
Add DNS record sets
Plan for Azure Private DNS zones
Review Azure Private DNS zone scenarios
12 - Configure Azure Virtual Network peering
Determine Azure Virtual Network peering uses
Determine gateway transit and connectivity
Create virtual network peering
Extend peering with user-defined routes and service chaining
13 - Configure network routing and endpoints
Review system routes
Identify user-defined routes
Determine service endpoint uses
Determine service endpoint services
Identify private link uses
14 - Configure Azure Load Balancer
Determine Azure Load Balancer uses
Implement a public load balancer
Implement an internal load balancer
Determine load balancer SKUs
Create back-end pools
Create health probes
Create load balancer rules
15 - Configure Azure Application Gateway
Implement Azure Application Gateway
Determine Azure Application Gateway routing
Configure Azure Application Gateway components
16 - Configure storage accounts
Implement Azure Storage
Explore Azure Storage services
Determine storage account types
Determine replication strategies
Access storage
Secure storage endpoints
17 - Configure Azure Blob Storage
Implement Azure Blob Storage
Create blob containers
Assign blob access tiers
Add blob lifecycle management rules
Determine blob object replication
Upload blobs
Determine Blob Storage pricing
18 - Configure Azure Storage security
Review Azure Storage security strategies
Create shared access signatures
Identify URI and SAS parameters
Determine Azure Storage encryption
Create customer-managed keys
Apply Azure Storage security best practices
19 - Configure Azure Files and Azure File Sync
Compare storage for file shares and blob data
Manage Azure file shares
Create file share snapshots
Implement Azure File Sync
Identify Azure File Sync components
Deploy Azure File Sync
20 - Configure Azure Storage with tools
Use Azure Storage Explorer
Use the Azure Import/Export service
Use the WAImportExport tool
Use the AzCopy tool
21 - Configure virtual machines
Review cloud services responsibilities
Plan virtual machines
Determine virtual machine sizing
Determine virtual machine storage
Create virtual machines in the Azure portal
Connect to virtual machines
22 - Configure virtual machine availability
Plan for maintenance and downtime
Create availability sets
Review update domains and fault domains
Review availability zones
Compare vertical and horizontal scaling
Implement Azure Virtual Machine Scale Sets
Create Virtual Machine Scale Sets
Implement autoscale
Configure autoscale
23 - Configure Azure App Service plans
Implement Azure App Service plans
Determine Azure App Service plan pricing
Scale up and scale out Azure App Service
Configure Azure App Service autoscale
24 - Configure Azure App Service
Implement Azure App Service
Create an app with App Service
Explore continuous integration and deployment
Create deployment slots
Add deployment slots
Secure your App Service app
Create custom domain names
Back up and restore your App Service app
Use Azure Application Insights
25 - Configure Azure Container Instances
Compare containers to virtual machines
Review Azure Container Instances
Implement container groups
Review the Docker platform
26 - Configure file and folder backups
Describe Azure Backup benefits
Implement Backup Center for Azure Backup
Configure Azure Recovery Services vault backup options
Use the Microsoft Azure Recovery Services (MARS) agent
Configure on-premises file and folder backups
27 - Configure virtual machine backups
Explore options to protect virtual machine data
Create virtual machine snapshots in Azure Backup
Set up Azure Recovery Services vault backup options
Back up your virtual machines
Restore your virtual machines
Implement System Center DPM and Azure Backup Server
Compare the MARS agent and Azure Backup Server
Implement soft delete for your virtual machines
Implement Azure Site Recovery
28 - Configure Azure Monitor
Describe Azure Monitor key capabilities
Describe Azure Monitor components
Define metrics and logs
Identify monitoring data and tiers
Describe activity log events
Query the activity log
29 - Configure Azure alerts
Describe Azure Monitor alerts
Manage Azure Monitor alerts
Create alert rules
Create action groups
30 - Configure Log Analytics
Determine Log Analytics uses
Create a Log Analytics workspace
Create Kusto (KQL) queries
Structure Log Analytics queries
31 - Configure Network Watcher
Describe Azure Network Watcher features
Review IP flow verify diagnostics
Review next hop diagnostics
Visualize the network topology

Nexus Human

Microsoft AZ-900

Microsoft Virtual Academy (MVA)

Microsoft AZ-104

Microsoft Azure

Microsoft AZ-303

Microsoft AZ-700

AZ-104T00 Microsoft Azure Administrator

<h3 style="color: rgb(14, 14, 14); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(14, 14, 14);">Read and discuss this lovely romance, telling the story of a woman torn between love and duty, between Ireland and America&nbsp;</h3><h4 style="color: rgb(14, 14, 14); box-sizing: border-box;" fr-original-style=" color: rgb(14, 14, 14);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Highlights</strong></h4><ul style="color: rgb(14, 14, 14); box-sizing: border-box;" fr-original-style=" color: rgb(14, 14, 14);"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Join this book club&nbsp;</strong>and gain&nbsp;extra motivation to read in English</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">6 hours of live classes</strong> to help you develop fluent speaking in English</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Read &amp; discuss this charming story&nbsp;</strong>of home, of migration to America, of life changing decisions&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Be corrected by an expert English teacher</strong>&nbsp;to remove errors and mistakes</li></ul><p style="color: rgb(14, 14, 14); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(14, 14, 14);">Practise and&nbsp;<em fr-original-style="" style="box-sizing: border-box;">develop your English</em>&nbsp;online in this 6 week English book club course using Brooklyn by Colm T&oacute;ib&iacute;n. &nbsp;<span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Each week you&nbsp;<em fr-original-style="" style="box-sizing: border-box;">read</em>&nbsp;some chapters,&nbsp;<em fr-original-style="" style="box-sizing: border-box;">discuss</em>&nbsp;them in class and&nbsp;<em fr-original-style="" style="box-sizing: border-box;">improve</em>&nbsp;specific areas of vocabulary or grammar while also&nbsp;<em fr-original-style="" style="box-sizing: border-box;">examining</em>&nbsp;literary aspects of the novel. &nbsp;Personalised feedback&nbsp;<em fr-original-style="" style="box-sizing: border-box;">improves</em>&nbsp;your grammar, vocabulary and pronunciation.</span></p><h4 style="color: rgb(14, 14, 14); box-sizing: border-box;" fr-original-style=" color: rgb(14, 14, 14);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The Book Club book</strong></h4><div style="color: rgb(14, 14, 14); box-sizing: border-box;" fr-original-style=" color: rgb(14, 14, 14);"><p style="color: var(--color-body-text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--color-body-text);">This is a lovely, quiet sort of book about a small town girl getting a chance to change her life. &nbsp;Ireland in the early 1950s is difficult, and for Eilis Lacey, as for other Irish girls, opportunities are limited. So when she gets a chance to emigrate to New York, she has to go.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">This is a story of love and of duty. &nbsp;It&#39;s a powerful portrait of a woman making decisions that will shape her whole life, told in a simple, elegant style. &nbsp;&nbsp;</p><p style="color: var(--color-body-text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--color-body-text);">With this elating and humane novel, Colm T&oacute;ib&iacute;n has produced a masterwork ―&nbsp;Sunday Times<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">The most compelling and moving portrait of a young woman I have read in a long time -- Zo&euml; Heller ―&nbsp;Guardian, Books of the Year<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">Suffused with humane depth, funny, affecting, deftly plotted ... a novel of magnificent accomplishment -- Peter Kemp ―&nbsp;Sunday Times, Novel of the Year</p></div><div style="color: rgb(14, 14, 14); box-sizing: border-box;" fr-original-style=" color: rgb(14, 14, 14);"></div><div style="color: rgb(14, 14, 14); box-sizing: border-box;" fr-original-style=" color: rgb(14, 14, 14);"><p style="color: var(--color-body-text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--color-body-text);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"></strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Geoff says:</strong></p><blockquote fr-original-style="" style="border-left: 2px solid rgb(94, 53, 177); color: rgb(94, 53, 177); margin-left: 0px; padding-left: 5px; box-sizing: border-box;"><p style="color: var(--color-body-text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--color-body-text);"><em fr-original-style="" style="box-sizing: border-box;"><i data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" data-mce-style="font-weight: 400;" fr-original-style="" style="box-sizing: border-box;">"<span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Colm T&oacute;ib&iacute;n is one of the great Irish modern writers. &nbsp;</span><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Brooklyn, set in Colm T&oacute;ib&iacute;n&#39;s home town,</span></span></i></em><em fr-original-style="" style="box-sizing: border-box;"><i data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" data-mce-style="font-weight: 400;" fr-original-style="" style="box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">&nbsp;was the winner of the Costa Novel Award, and has been made into a much loved film starring&nbsp;</span></span></i></em>Saoirse Ronan - but as usual the book is better!"</p></blockquote></div>

Read and discuss the world's most famous Christmas story! 
Highlights
Join this book club and gain extra motivation to read in English
5 hours of live classes to help you develop fluent speaking in English
Study this classic Dickens novel and increase your cultural knowledge
Be corrected by an expert English teacher to remove errors and mistakes
Practise and develop your English online in this 5 week advanced course featuring the classic Charles Dickens novel A Christmas Carol. Each week you read some chapters, discuss them in class and improve specific areas of vocabulary or grammar while also examining literary aspects of the novel. Personalised feedback improves your grammar, vocabulary and pronunciation.
The Book Club book
A Christmas Carol is the most famous Christmas story of all. Dickens combines social realism with exaggeration, black comedy, and the supernatural to tackle important questions about the poor and disadvantaged in English society. Ebenezer Scrooge is mean and unpleasant but will he change when the ghost of his old partner, Jacob Marley, haunts him on Christmas Eve? Scrooge is visited by three spirits of Christmas Past, Present and Future, showing him his mistakes and leading to a change in his outlook. Charles Dickens tells this incredible story in fascinating language full of adjectives, as well as with real humanity. 
Geoff says:
"I chose this book because it is so well known, through movies and the theatre, but have you read the original in English? The themes of love, kindness and generosity means it is a positive, uplifting story, and still relevant today. We read the original text, which is short."


Book Club School

English Language Teaching

English Speaking

English Literature

English

ESOL (English for Speakers of Other Languages)

A Christmas Carol - Tuesdays from 19th November

Join Me For This 8 Week Qigong and Breathwork Online Course
HARNESSING THE POWER OF THE BREATH
The way we breathe affects everything we do, everything we think and everything we feel. It affects our sleep, our digestion, our immune system, our energy levels, our emotions, our ability to think clearly and our relationships, to name but a few.
In this course we will be combining my passions of Qigong and Breathwork to help bring us into balance so we can move though Autumn into winter full of peace and vitality.
Why Qigong and Breathwork?
Qigong is breathwork (Qi is Breath), it is an amazing way of opening and clearing the body, of making space for our healthy energy to flow. It allows us to stay relaxed and receptive without forcing or pushing. It is easy to learn and naturally attuned to your individual body and how it wants to expand, release and recharge.
Breathwork is simply bringing our conscious attention to our breath and is one of the most powerful ways we have to change our state at any given moment. In the course i will introduce you to eight different breath techniques to help you to breathe better. Commit to just 10mins a day and you’ll be amazed at the results you can achieve.
Everyone is welcome to join the course no matter your experience. 
When: 8th October 2024 – 5th December
Tuesday Evenings 6-7pm and Thursday mornings 9-9.30am (via Zoom)
Dates:
Tuesdays 6-7pm: October 8th, 15th, 22nd November 5th, 12th, 19th, 26th, December 3rd.
Thursdays 9-9.30am: October 10th, 17th, 24th, November 7th, 14th, 21st, 28th December 5th.

Price: £110 (Concessions £80: Super concession £60)
What is included: 
Eight live 60min evening zoom classes 
Eight live 30min morning meditation zoom classes 
Access to replays of all classes so you can catch up in your own time. 
Learn a Qigong routine for healthy lungs 
Learn how to clear the meridian pathways for increased vitality 
Learn 8 new powerful breath practices 
Access to private Whats App group to share experiences and ask questions 
Weekly supporting material for home practice :
– A Weekly video with a guided 10min Breath Practice 
– PDF – explanations of each practice 
– Key acupuncture points for self massage 

What will I get out of the course?
Reconnect with your breath
Learn how to improve your respiration
Learn to regulate your own nervous system
Access deeper body awareness
Less physical tension
Reduced pain
Improved mental clarity
Strengthened immune system 
Improved sleep
Improved digestion
Less stress and anxiety, depression and panic attacks
Deepening meditation practice
More energy
Just Breathe
Just Be

Sunhouse

Tai Chi

Meditation

Breathing Techniques

THE ART OF BREATH - Qi-Gong & Breathwork 

Concession

Super Concession

Bournemouth

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



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

Travel the world and be paid for it

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

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


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

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

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

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

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

Receive constant updates on recruitment and news from Aviation the world

We will enhance your CV

Full support on your job application process

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

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

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








London Waterloo Academy

Flight Attendant

Stewardess

FLIGHT ATTENDANT VIRTUAL VIA ZOOM COURSE, EVENINGS

Registration Fee

Course Fee

Manchester

<p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(34, 34, 34);">The WSET Level 2 Award in Wines has full accreditation from OfQual as a Level 2 Vocational Qualification. Through a combination of tasting and theory you will explore the factors that impact the style and quality of wine and learn how to describe wines with confidence.</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Schedule:</strong></p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">The 8 x 2-hour online sessions on -&nbsp;</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What the course covers</strong></p><ul style="color: rgb(34, 34, 34); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Wine tasting</strong>: You will learn how to taste and describe wines using the WSET Systematic Approach to Tasting (SAT)</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Food and wine pairing</strong>: You will learn the principles of food and wine pairing</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Wine service and storage</strong>: You will learn the correct way to store and serve wine and how to recognise common faults found in wine</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Labelling</strong>: You will learn how to decode and understand wine labels</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Factors influencing the style of wine</strong>: You will explore how environmental factors, grape-growing, vineyard and maturation options influence the style and quality of the wines made all over the world</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Grape varieties</strong>: You&#39;ll learn about the styles of wines produced by the key international red and white grape varieties (Chardonnay, Pinot Grigio, Sauvignon Blanc, Riesling, Cabernet Sauvignon, Pinot Noir, Merlot and Syrah/Shiraz) as well as the styles of wines made with 22 regionally important grape varieties grown in 70 wine regions (GI&#39;s) around the world</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Sparkling and Fortified wines</strong>: You will be taught how grape varieties and winemaking processes influence the style of wines in these two key wine categories.</li></ul><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">No prior wine knowledge is required however the course builds upon the&nbsp;<a href="https://www.localwineschool.com/manchester/events/professional-courses/wset-courses/wset-course-level-1-online/" target="_blank" rel="noopener" style="color: rgb(157, 40, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(157, 40, 51);">WSET Level 1 Award in Wines</a> course. It is not essential to complete Level 1 to join the Level 2 course but if you are a complete begineer you may wish to consider this option. We recommend you read the course specification document&nbsp;<a href="https://www.wsetglobal.com/media/11718/wset_l2wines_specification_en_jun2022_issue11.pdf" target="_blank" rel="noopener" style="color: rgb(157, 40, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(157, 40, 51);">HERE</a>&nbsp;for full details of the content, structure and assesment criteria. Any questions please&nbsp;<a href="https://www.localwineschool.com/manchester/contact/" target="_blank" rel="noopener" style="color: rgb(157, 40, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(157, 40, 51);">get in touch</a>.</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course delivery</strong></p><ul style="color: rgb(34, 34, 34); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><li fr-original-style="" style="box-sizing: border-box;">The Level 2 Award in Wines online course covers the same syllabus as the classroom course and is delivered in LIVE interactive online lessons by one of our certified wine educators</li><li fr-original-style="" style="box-sizing: border-box;">This course includes 16 hours online tuition in 8 x 2hr sessions&nbsp;and we recommend a minimum of 12 hours additional study</li><li fr-original-style="" style="box-sizing: border-box;">Your tutor will give you a guided tasting of 12 wines on this course (for details of how to order the wines see below)</li><li fr-original-style="" style="box-sizing: border-box;">You will receive access to practice multiple-choice revision questions specific to this course - FREE OF CHARGE</li></ul><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">Please note a reliable broadband connection is essential for the completion of this online course as are basic computer skills.</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Examination</strong></p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">To obtain the WSET Level 2 Award in Wines Qualification, you will need to successfully pass the exam. The exam is made up of 50 multiple-choice questions to be completed in 1 hour. A mark of 55% is required to pass the exam.</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">The exam is taken online via a <a href="https://www.youtube.com/watch?v=DarWJz6dUbU" target="_blank" rel="noopener" style="color: rgb(157, 40, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(157, 40, 51);">Remote Invigilation</a> service giving you the flexibility to take the exam at a time and date of your choice. More details will be sent upon registration. Please ensure you read the information&nbsp;<a href="https://www.wsetglobal.com/wset-remote-invigilation-essential-guidance/?dm_i=5G5C,KRHB,4A50QU,2G285,1" target="_blank" rel="noopener" style="color: rgb(157, 40, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(157, 40, 51);">HERE</a>&nbsp;if you wish to take the exam online.&nbsp;</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Whats included</strong></p><ul style="color: rgb(34, 34, 34); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><li fr-original-style="" style="box-sizing: border-box;">All WSET course materials posted to you at no extra charge including: Looking Behind the Label course manual, Study Guide, specification and SAT Tasting Card</li><li fr-original-style="" style="box-sizing: border-box;">LIVE virtual interactive sessions taught by a Local Wine School WSET Certified Tutor</li><li fr-original-style="" style="box-sizing: border-box;">Exclusive access to practice multiple choice questions provided FREE OF CHARGE</li><li fr-original-style="" style="box-sizing: border-box;">WSET exam fee&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Remote Invigilation service&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Internationally recognised WSET qualification, certificate and pin for those who pass the exam</li><li fr-original-style="" style="box-sizing: border-box;">VAT at 20% &nbsp;(VAT receipt can be provided on request)</li></ul><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Wines</strong></p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">It is recommended that at least 12 wines are tasted as part of this course, although this is optional and the cost of wines is not included in the course fee above.</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">Our wine experts have specially selected wines for this course designed to demonstrate specific learning outcomes. We have negotiated a discounted price only available to our online students. Details of how to order your case of wines will be provided when you book your place. The cost is approx &pound;150 including VAT and delivery.&nbsp;</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">Wine preservation advice is give so that after each tasting exercise you can reseal and return to the wines over the coming days. &nbsp;</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Special Educational Needs</strong></p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">Please make the school aware if you have a condition which may mean that you will qualify for additional help during the exam such as dyslexia.</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Important dates</strong></p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">Registration deadline: please book at least 5 days before the start of the course, to allow time to send materials and order the tasting wines.</p>

The WSET Level 2 Award in Wines has full accreditation from OfQual as a Level 2 Vocational Qualification. Through a combination of tasting and theory you will explore the factors that impact the style and quality of wine and learn how to describe wines with confidence.
Course Schedule:
The 8 x 2-hour online sessions on - 
What the course covers
Wine tasting: You will learn how to taste and describe wines using the WSET Systematic Approach to Tasting (SAT)
Food and wine pairing: You will learn the principles of food and wine pairing
Wine service and storage: You will learn the correct way to store and serve wine and how to recognise common faults found in wine
Labelling: You will learn how to decode and understand wine labels
Factors influencing the style of wine: You will explore how environmental factors, grape-growing, vineyard and maturation options influence the style and quality of the wines made all over the world
Grape varieties: You'll learn about the styles of wines produced by the key international red and white grape varieties (Chardonnay, Pinot Grigio, Sauvignon Blanc, Riesling, Cabernet Sauvignon, Pinot Noir, Merlot and Syrah/Shiraz) as well as the styles of wines made with 22 regionally important grape varieties grown in 70 wine regions (GI's) around the world
Sparkling and Fortified wines: You will be taught how grape varieties and winemaking processes influence the style of wines in these two key wine categories.
No prior wine knowledge is required however the course builds upon the WSET Level 1 Award in Wines course. It is not essential to complete Level 1 to join the Level 2 course but if you are a complete begineer you may wish to consider this option. We recommend you read the course specification document HERE for full details of the content, structure and assesment criteria. Any questions please get in touch.
Course delivery
The Level 2 Award in Wines online course covers the same syllabus as the classroom course and is delivered in LIVE interactive online lessons by one of our certified wine educators
This course includes 16 hours online tuition in 8 x 2hr sessions and we recommend a minimum of 12 hours additional study
Your tutor will give you a guided tasting of 12 wines on this course (for details of how to order the wines see below)
You will receive access to practice multiple-choice revision questions specific to this course - FREE OF CHARGE
Please note a reliable broadband connection is essential for the completion of this online course as are basic computer skills.
Examination
To obtain the WSET Level 2 Award in Wines Qualification, you will need to successfully pass the exam. The exam is made up of 50 multiple-choice questions to be completed in 1 hour. A mark of 55% is required to pass the exam.
The exam is taken online via a Remote Invigilation service giving you the flexibility to take the exam at a time and date of your choice. More details will be sent upon registration. Please ensure you read the information HERE if you wish to take the exam online. 
Whats included
All WSET course materials posted to you at no extra charge including: Looking Behind the Label course manual, Study Guide, specification and SAT Tasting Card
LIVE virtual interactive sessions taught by a Local Wine School WSET Certified Tutor
Exclusive access to practice multiple choice questions provided FREE OF CHARGE
WSET exam fee
Remote Invigilation service
Internationally recognised WSET qualification, certificate and pin for those who pass the exam
VAT at 20% (VAT receipt can be provided on request)
Course Wines
It is recommended that at least 12 wines are tasted as part of this course, although this is optional and the cost of wines is not included in the course fee above.
Our wine experts have specially selected wines for this course designed to demonstrate specific learning outcomes. We have negotiated a discounted price only available to our online students. Details of how to order your case of wines will be provided when you book your place. The cost is approx £150 including VAT and delivery. 
Wine preservation advice is give so that after each tasting exercise you can reseal and return to the wines over the coming days. 
Special Educational Needs
Please make the school aware if you have a condition which may mean that you will qualify for additional help during the exam such as dyslexia.
Important dates
Registration deadline: please book at least 5 days before the start of the course, to allow time to send materials and order the tasting wines.

2484 Courses in Wallasey

NPORS Overhead Crane (N104)

By Dynamic Training and Assessments Ltd

NPORS Lift Truck Supervisor Awareness (N036)

By Dynamic Training and Assessments Ltd

NPORS Plant Supervisor Awareness (N034)

By Dynamic Training and Assessments Ltd

NPORS Appointed Person (N401)

By Dynamic Training and Assessments Ltd

NPORS Shunter Vehicle (N243)

By Dynamic Training and Assessments Ltd

NPORS Skidsteer Loader (N212)

By Dynamic Training and Assessments Ltd

NPORS Plant Machinery Marshal (N133)

By Dynamic Training and Assessments Ltd

NPORS Crawler Crane (N103)

By Dynamic Training and Assessments Ltd

NPORS Side Loader (N006)

By Dynamic Training and Assessments Ltd

NPORS Road Roller (N214)

By Dynamic Training and Assessments Ltd

Search By Location