Thetford

<header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><header style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><div style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><article fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This half day course is designed to help participants plan and promote events, whether for fundraising, social or educational purposes. It provides practical tips on a wide range of subject areas from choosing events to determining budgets and publicity methods.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course can be adapted to take in any type of events or can concentrate on particular areas such as organising fundraising events, conferences or cultural events.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Areas covered</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Good practice in events management</li><li fr-original-style="" style="box-sizing: border-box;">Being clear about your objectives in organising events</li><li fr-original-style="" style="box-sizing: border-box;">Factors in determining what events to plan</li><li fr-original-style="" style="box-sizing: border-box;">Managing an events team</li><li fr-original-style="" style="box-sizing: border-box;">Budgeting for events</li><li fr-original-style="" style="box-sizing: border-box;">Marketing your events</li><li fr-original-style="" style="box-sizing: border-box;">Health and safety aspects in organising events</li><li fr-original-style="" style="box-sizing: border-box;">Operational planning.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course could be run as part of a training programme or could be run in house.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">In-house courses&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course is designed to be flexible so that it can accommodate the specific needs of a particular organisation or agency. For example, the course could be designed around the planning of a particular event or series of events. The course could be extended in length to a whole day if necessary.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Objectives</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">To give participants a broad overview of events management</li><li fr-original-style="" style="box-sizing: border-box;">To provide suggestions for different types of events that groups could organise</li><li fr-original-style="" style="box-sizing: border-box;">To look at systems to have in place</li><li fr-original-style="" style="box-sizing: border-box;">To provide advice on issues such as volunteer management, budgeting, publicity.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Target Audience</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">People working in the voluntary and community sector, for statutory agencies or in business. The course can be adapted to suit particular needs.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Cost</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">From &pound;150 + travel costs</p></article></div></header></header></header><div style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><br fr-original-style="" style="box-sizing: border-box;"></div>

This half day course is designed to help participants plan and promote events, whether for fundraising, social or educational purposes. It provides practical tips on a wide range of subject areas from choosing events to determining budgets and publicity methods.
The course can be adapted to take in any type of events or can concentrate on particular areas such as organising fundraising events, conferences or cultural events.
Areas covered
Good practice in events management
Being clear about your objectives in organising events
Factors in determining what events to plan
Managing an events team
Budgeting for events
Marketing your events
Health and safety aspects in organising events
Operational planning.
This course could be run as part of a training programme or could be run in house.
In-house courses 
The course is designed to be flexible so that it can accommodate the specific needs of a particular organisation or agency. For example, the course could be designed around the planning of a particular event or series of events. The course could be extended in length to a whole day if necessary.
Objectives
To give participants a broad overview of events management
To provide suggestions for different types of events that groups could organise
To look at systems to have in place
To provide advice on issues such as volunteer management, budgeting, publicity.
Target Audience
People working in the voluntary and community sector, for statutory agencies or in business. The course can be adapted to suit particular needs.
Cost
From £150 + travel costs

SAVO CIC

Event Management

Event Planner

This half day course is designed to help participants plan and promote events, whether for fundraising, social or educational purposes. It provides practical tips on a wide range of subject areas from choosing events to determining budgets and publicity methods.

The course can be adapted to take in any type of events or can concentrate on particular areas such as organising fundraising events, conferences or cultural events.

Organising and Managing Events

General Admission

<p id="isPasted"><strong><span>Course Overview:</span></strong></p><p><span>The "An Understanding of Gastrostomy Tube Care and Safe Use" course is designed to provide healthcare professionals with comprehensive knowledge and practical skills required for the proper care and safe use of gastrostomy tubes. Gastrostomy tubes are commonly used to provide enteral nutrition and medication to patients who cannot consume food orally. This course offers in-depth training on the techniques, considerations, and patient care involved in maintaining and using gastrostomy tubes.</span></p><p><span><br /></span></p><p><span><strong>Course Duration:</strong> </span></p><p><span>1 day (6 hours)</span></p><p><span><br /></span></p><p><span><strong>Course Content:</strong></span></p><p><span>By the end of this course, participants will be able to:</span></p><p id="isPasted"><span>1. Explain the reason for a gastrostomy tube</span></p><p><span>2. List the types of gastrostomy tubes available</span></p><p><span>3. Describe gastrostomy care and safe use (including using the tube to administer flushes, fluid, feed and medication)</span></p><p><span>4. Summarise how to respond to complications in gastrostomy care and enteral feeding</span></p><p><span>5. Discuss safety procedures for managing an gastrostomy tube</span></p><p><span><br /></span></p><p id="isPasted"><span><strong>Learning Objectives:</strong></span></p><p><span>By the end of the course, participants will be able to:</span></p><p><span>1. Understand the basics of gastrostomy tubes.</span></p><p><span>2. Identify the components of gastrostomy tubes.</span></p><p><span>3. Perform safe gastrostomy tube insertion.</span></p><p><span>4. Maintain hygiene and prevent infections.</span></p><p><span>5. Administer nutrition and medication accurately.</span></p><p><span>6. Recognise and manage common complications.</span></p><p><span>7. Handle and store supplies safely.</span></p><p><span>8. Provide emotional support to patients and caregivers.</span></p><p><span>9. Create personalised care plans.</span></p><p><span>10. Stay updated on best practices and guidelines.</span></p><p><span><br /></span></p><p><span><strong>Assessment and Certification:</strong></span></p><p><span>Participants will undergo a practical skills assessment and a written examination to evaluate their understanding of the course content. Successful completion will lead to a certification of achievement in "An Understanding of Gastrostomy Tube Care and Safe Use."</span></p><p id="isPasted"><span><strong>Note: This course overview is a general guideline and can be customised to suit specific local requirements and preferences, therefore, we recommend that you contact us to discuss your requirements prior to making a booking.</strong></span></p>

Course Overview:
The "An Understanding of Gastrostomy Tube Care and Safe Use" course is designed to provide healthcare professionals with comprehensive knowledge and practical skills required for the proper care and safe use of gastrostomy tubes. Gastrostomy tubes are commonly used to provide enteral nutrition and medication to patients who cannot consume food orally. This course offers in-depth training on the techniques, considerations, and patient care involved in maintaining and using gastrostomy tubes.


Course Duration: 
1 day (6 hours)


Course Content:
By the end of this course, participants will be able to:
1. Explain the reason for a gastrostomy tube
2. List the types of gastrostomy tubes available
3. Describe gastrostomy care and safe use (including using the tube to administer flushes, fluid, feed and medication)
4. Summarise how to respond to complications in gastrostomy care and enteral feeding
5. Discuss safety procedures for managing an gastrostomy tube


Learning Objectives:
By the end of the course, participants will be able to:
1. Understand the basics of gastrostomy tubes.
2. Identify the components of gastrostomy tubes.
3. Perform safe gastrostomy tube insertion.
4. Maintain hygiene and prevent infections.
5. Administer nutrition and medication accurately.
6. Recognise and manage common complications.
7. Handle and store supplies safely.
8. Provide emotional support to patients and caregivers.
9. Create personalised care plans.
10. Stay updated on best practices and guidelines.


Assessment and Certification:
Participants will undergo a practical skills assessment and a written examination to evaluate their understanding of the course content. Successful completion will lead to a certification of achievement in "An Understanding of Gastrostomy Tube Care and Safe Use."
Note: This course overview is a general guideline and can be customised to suit specific local requirements and preferences, therefore, we recommend that you contact us to discuss your requirements prior to making a booking.

Guardian Angels Training

Gain comprehensive knowledge and practical skills for safe gastrostomy tube care with our course. Learn techniques, considerations, and patient care.

An Understanding of Gastrostomy Tube Care and Safe Use

<p id="isPasted"><strong><span>Course Overview:</span></strong></p><p><span>The "An Understanding of Fine-Bore Nasogastric Tube Insertion, Care, and Safe Use" course is designed to provide healthcare professionals with comprehensive knowledge and practical skills required for the safe and effective insertion, care, and utilisation of fine-bore nasogastric tubes. Fine-bore nasogastric tubes are commonly used to provide enteral nutrition and medication to patients who cannot consume food orally. This course offers comprehensive training in insertion techniques, ongoing care, and ensuring patient safety.</span></p><p><span><br /></span></p><p><span><strong>Course Duration:</strong> </span></p><p><span id="isPasted"> 1 day (</span><span>6 hours)</span></p><p><span><br /></span></p><p><span><strong>Course Content:</strong></span></p><p><span>By the end of this course, participants will be able to:</span></p><p id="isPasted"><span>1. Define fine bore nasogastric tube (NGT) insertion and the uses</span></p><p><span>2. List the indications and contraindications of NGT</span></p><p><span>3. Outline the anatomy and physiology of GI Tract</span></p><p><span>4. Explain the benefits and risk of NGT insertion and feeding</span></p><p><span>5. Summarise legal and professional issues, including consent, competency, record keeping</span></p><p><span>6. Discuss national standards and guidelines including NPSA Alerts</span></p><p><span>7. Outline infection prevention and control strategies</span></p><p><span>8. List the safer insertion procedure</span></p><p><span>9. Describe the confirmation testing</span></p><p><span>10. Explain the principles of flushing, enteral feeding and fluids, and medication administration</span></p><p><span></span><br /></p><p id="isPasted"><strong><span>Course Objectives:</span></strong></p><p><span>1. Comprehend Nasogastric Tube Fundamentals: Understand the indications for nasogastric tube insertion, types of tubes, and their applications in clinical settings.</span></p><p><span>2. Demonstrate Proper Insertion Techniques: Develop proficiency in safely inserting fine-bore nasogastric tubes using appropriate techniques and equipment.</span></p><p><span>3. Perform Effective Tube Care and Maintenance: Learn how to maintain hygiene, prevent complications, and provide patient comfort during tube placement.</span></p><p><span>4. Address Patient Safety and Ethical Considerations: Prioritise patient safety and address ethical considerations during nasogastric tube insertion and care.</span></p><p><span>5. Troubleshoot Common Issues: Recognise and address common complications and issues related to nasogastric tubes, ensuring optimal functionality.</span></p><p><span>6. Educate Patients and Caregivers: Develop effective communication skills to educate patients, caregivers, and family members about nasogastric tube care and safe use.</span></p><p><span><br /></span></p><p><span><strong>Assessment and Certification:</strong></span></p><p><span>Participants will undergo a practical skills assessment and a written examination to evaluate their understanding of the course content. Successful completion will lead to a certification of achievement in "An Understanding of Fine-Bore Nasogastric Tube Insertion, Care and Safe Use."</span></p><p id="isPasted"><strong><span>Note: This course overview is a general guideline and can be customised to suit specific local requirements and preferences, therefore, we recommend that you contact us to discuss your requirements prior to making a booking.</span></strong></p>

Course Overview:
The "An Understanding of Fine-Bore Nasogastric Tube Insertion, Care, and Safe Use" course is designed to provide healthcare professionals with comprehensive knowledge and practical skills required for the safe and effective insertion, care, and utilisation of fine-bore nasogastric tubes. Fine-bore nasogastric tubes are commonly used to provide enteral nutrition and medication to patients who cannot consume food orally. This course offers comprehensive training in insertion techniques, ongoing care, and ensuring patient safety.


Course Duration: 
 1 day (6 hours)


Course Content:
By the end of this course, participants will be able to:
1. Define fine bore nasogastric tube (NGT) insertion and the uses
2. List the indications and contraindications of NGT
3. Outline the anatomy and physiology of GI Tract
4. Explain the benefits and risk of NGT insertion and feeding
5. Summarise legal and professional issues, including consent, competency, record keeping
6. Discuss national standards and guidelines including NPSA Alerts
7. Outline infection prevention and control strategies
8. List the safer insertion procedure
9. Describe the confirmation testing
10. Explain the principles of flushing, enteral feeding and fluids, and medication administration


Course Objectives:
1. Comprehend Nasogastric Tube Fundamentals: Understand the indications for nasogastric tube insertion, types of tubes, and their applications in clinical settings.
2. Demonstrate Proper Insertion Techniques: Develop proficiency in safely inserting fine-bore nasogastric tubes using appropriate techniques and equipment.
3. Perform Effective Tube Care and Maintenance: Learn how to maintain hygiene, prevent complications, and provide patient comfort during tube placement.
4. Address Patient Safety and Ethical Considerations: Prioritise patient safety and address ethical considerations during nasogastric tube insertion and care.
5. Troubleshoot Common Issues: Recognise and address common complications and issues related to nasogastric tubes, ensuring optimal functionality.
6. Educate Patients and Caregivers: Develop effective communication skills to educate patients, caregivers, and family members about nasogastric tube care and safe use.


Assessment and Certification:
Participants will undergo a practical skills assessment and a written examination to evaluate their understanding of the course content. Successful completion will lead to a certification of achievement in "An Understanding of Fine-Bore Nasogastric Tube Insertion, Care and Safe Use."
Note: This course overview is a general guideline and can be customised to suit specific local requirements and preferences, therefore, we recommend that you contact us to discuss your requirements prior to making a booking.

Gain comprehensive knowledge and practical skills for safe and effective fine-bore nasogastric tube insertion, care, and use with our healthcare professional course.

An Understanding of Fine-Bore Nasogastric Tube Insertion, Care and Safe Use

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;">Gaining a basic understanding of the industry, the dangers of working in the industry and responsibilities as an operator.</li><li fr-original-style="" style="box-sizing: border-box;">Learning 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;">Being 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;">Being able to locate and identify key controls and explain their functions.</li><li fr-original-style="" style="box-sizing: border-box;">Setting up exclusion zone</li><li fr-original-style="" style="box-sizing: border-box;">Identifying and maintaining PPE appropriate for remote control tower crane use.</li><li fr-original-style="" style="box-sizing: border-box;">Conducting all pre-operational and running checks in accordance with manufacturer&#39;s and legislative requirements.</li><li fr-original-style="" style="box-sizing: border-box;">Preparing the remote control tower crane for use and operating 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;">Carrying 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:
Gaining a basic understanding of the industry, the dangers of working in the industry and responsibilities as an operator.
Learning a working knowledge of the manufacturer’s handbook for the particular machine to be used.
Being able to locate and identify the major components of the machine and explain their functions.
Being able to locate and identify key controls and explain their functions.
Setting up exclusion zone
Identifying and maintaining PPE appropriate for remote control tower crane use.
Conducting all pre-operational and running checks in accordance with manufacturer's and legislative requirements.
Preparing the remote control tower crane for use and operating machine safely and efficiently
Environmental considerations
Carrying 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 Remote Control Tower Crane (N115)

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

NPORS Overhead Crane (N104)

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

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

NPORS Plant Machinery Marshal (N133)

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">COURSE INFORMATION</strong></span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">To provide knowledge and understanding in the following areas:</p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an 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 mobile 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 mobile 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 mobile crane use
Conduct all pre-operational and running checks in accordance with manufacturer’s and legislative requirements
Prepare the mobile 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.

NPORS Mobile Crane (N101)

Loughborough

<div>
		

		<div>
			
			<p>Stress can affect your ability to think clearly and rationally and to perform well. This session aims to help you better deal with stress by sharing key insights and strategies to reduce stress and optimize your work-life balance, particularly as we face uncertainties in the economy, the workplace and the environment.</p>
			<div><i></i> 4 Hour Session</div>
			<div><i></i>  £180.00 incl. VAT</div>
			
			
		</div>
	</div>

	

	<div id="filters">
		
		
	</div>

	

    <div>

		
		 
		

		<div></div>

		<div>
			<p>Want to run this event in-house?  Enquire about running this event in-house </p>
			
		</div>

		<div>
			<p>Interested in attending? Have a suggestion about running this event near you?<br />Register your interest now</p>
			
		</div>
	</div>
	<div></div>
	
		
        <div>
			
		</div>
				

	
		<h3>Description</h3>
		<p></p><p><b>Learning Objectives</b></p>
<ul>
<li>Learn coping techniques to deal with a different way of working and living</li>
<li>Feel supported by others and know that you are not alone in the struggle</li>
<li>Recognize the symptoms and causes of stress</li>
<li>Discover simple stress-busting techniques to manage &amp; reduce the effects of stress in your life</li>
<li>Create a simple personalised plan to rise above stress for a healthier &amp; more productive lifestyle</li>
</ul>
<p></p>
	
		<h3>Modules/Lessons</h3>
		<p></p><h3>1. Background</h3>
<p><strong>What is stress - origins, causes, and symptoms.</strong></p>
<ul>
<li>Flight or fight response &amp; role of hormones</li>
<li>Why it matters? Physiological, psychological, and physical effects</li>
<li>The price you pay in terms of your health and your family</li>
<li>Causes</li>
<li>Warning signs: cognitive, emotional, physical, behavioural</li>
<li>Stats from around the world</li>
</ul>
<h3>2. Technique</h3>
<p><strong>Work - life balance</strong></p>
<ul>
<li>How to create balance &amp; set boundaries The notion of 'tilting'</li>
<li>Connecting with and pursuing your passion</li>
<li>Gaining support at work and at home</li>
<li>Learning how to say 'no'</li>
</ul>
<p><strong>Stress reduction techniques</strong></p>
<ul>
<li>Visualization and relaxation techniques</li>
<li>Breathing and stretching</li>
<li>Energizers and drainers</li>
<li>Meditative positive visualization exercise (5 mins)</li>
<li>Physical health</li>
<li>Behaviours and beliefs</li>
<li>Putting things in perspective</li>
<li>Circle of influence (vs. circle of control)</li>
<li>Slowing down (hurry sickness / time famine - Arianna Huffington Thrive)</li>
<li>Purpose - identify what matters to you (values), gratitude journal, contribution</li>
</ul>
<h3>3. Plan</h3>
<p>Action Planning</p>
<ul>
<li>Cultivating gratitude</li>
<li>Finding meaning and purpose</li>
</ul>
<p></p>

Stress can affect your ability to think clearly and rationally and to perform well. This session aims to help you better deal with stress by sharing key insights and strategies to reduce stress and optimize your work-life balance, particularly as we face uncertainties in the economy, the workplace and the environment.
4 Hour Session £180.00 incl. VAT
Want to run this event in-house? Enquire about running this event in-house 
Interested in attending? Have a suggestion about running this event near you?
Register your interest now
Description

Learning Objectives
Learn coping techniques to deal with a different way of working and living
Feel supported by others and know that you are not alone in the struggle
Recognize the symptoms and causes of stress
Discover simple stress-busting techniques to manage & reduce the effects of stress in your life
Create a simple personalised plan to rise above stress for a healthier & more productive lifestyle

Modules/Lessons

1. Background
What is stress - origins, causes, and symptoms.
Flight or fight response & role of hormones
Why it matters? Physiological, psychological, and physical effects
The price you pay in terms of your health and your family
Causes
Warning signs: cognitive, emotional, physical, behavioural
Stats from around the world
2. Technique
Work - life balance
How to create balance & set boundaries The notion of 'tilting'
Connecting with and pursuing your passion
Gaining support at work and at home
Learning how to say 'no'
Stress reduction techniques
Visualization and relaxation techniques
Breathing and stretching
Energizers and drainers
Meditative positive visualization exercise (5 mins)
Physical health
Behaviours and beliefs
Putting things in perspective
Circle of influence (vs. circle of control)
Slowing down (hurry sickness / time famine - Arianna Huffington Thrive)
Purpose - identify what matters to you (values), gratitude journal, contribution
3. Plan
Action Planning
Cultivating gratitude
Finding meaning and purpose


Mpi Learning - Professional Learning And Development Provider

Stress can affect your ability to think clearly and rationally and to perform well. This session aims to help you better deal with stress by sharing key insights and strategies to reduce stress and optimize your work-life balance, particularly as we face uncertainties in the economy, the workplace and the environment.

Stress Management

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

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

NPORS Excavation Marshall - Banksperson (N027)

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">COURSE INFORMATION</strong></span></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">To provide knowledge and understanding in the following areas:</p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator</li><li fr-original-style="" style="box-sizing: border-box;">Have a working knowledge of the manufacturer&rsquo;s handbook for the particular machine to be used</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify the major components of the machine and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Be able to locate and identify key controls and explain their functions</li><li fr-original-style="" style="box-sizing: border-box;">Conduct all pre-operational checks in accordance with manufacturer&rsquo;s and legislative requirements</li><li fr-original-style="" style="box-sizing: border-box;">Identify and maintain PPE appropriate for loading shovel 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 loading shovel for use, operate machinery 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;">Storage and transport of implements and attachments</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate knowledge and understanding of loading and unloading procedures for machine transportation</li><li fr-original-style="" style="box-sizing: border-box;">Carry out all end of shift and shut down procedures</li></ul><h2 style="color: rgb(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
Conduct all pre-operational checks in accordance with manufacturer’s and legislative requirements
Identify and maintain PPE appropriate for loading shovel use
Conduct all necessary safety checks at the work area
Prepare the loading shovel 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
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 Loading Shovel (N209)

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

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

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

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

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

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


Nexus Human

Executive Presentation

Office Skills & Productivity

Microsoft Power Platform

Professional Skills Course (PSC)

Microsoft Powerpoint

Presentation Skills

Microsoft PowerPoint for the Business User

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

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

colour-energies.com

Disc

Team Building

Professional Selling Skills (PSS)

Business Leadership

Relationship Building

Insights

Influence Skills

Insights Discovery

Communication Skills

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

The 4 Colour Energies - Building Influence & Selling Skills

Book by the 10th October for 20% discount

Early Bird Offer

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

Buy One place get a second half price

Broxburn

<p id="isPasted" style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">C20M03 - Access Control Principles</strong></p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course content<br fr-original-style="" style="box-sizing: border-box;"></strong></p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);">Learners will be introduced to the design, installation, commissioning, and maintenance of Access Control systems. This CPD provides a foundation knowledge of Access Control in relation to the requirements of NCP 109 (NSI) and SS2002 (SSAIB) Third Party Certification Bodies codes of practice, associated standards, and the various legal frameworks within the UK.</p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who should attend?</strong></p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);">All those involved in the specifying, design, installation, commissioning, and maintenance of Access Control Systems including specifiers, property managers, consultants, FM providers, security consultants, security installers.</p><p style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course content</strong></p><ul style="color: rgb(63, 77, 90); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Enquiry</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Risk Assessment<ul style="font-size: initial; box-sizing: border-box;" fr-original-style="font-size: initial;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Operational Requirements</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Initial Design</li></ul></li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Quote</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Order</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">System Design Specification</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Installation</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Commissioning</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Handover</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Maintenance</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Assessment</li></ul><p id="isPasted" style="color: rgb(63, 77, 90); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(63, 77, 90);"><img src="https://images.cademy.co.uk/88d338d8-7dc4-4054-bf9e-401495774eee/5293624b-3258-4be0-b61f-1d0469f76c49/original.png" style="width: 300px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-style="width: 300px; display: block; vertical-align: top; margin: 5px auto; text-align: center; cursor: auto;" fr-original-class="fr-draggable"></p>

C20M03 - Access Control Principles
Course content

Learners will be introduced to the design, installation, commissioning, and maintenance of Access Control systems. This CPD provides a foundation knowledge of Access Control in relation to the requirements of NCP 109 (NSI) and SS2002 (SSAIB) Third-Party Certification Bodies codes of practice, associated standards, and the various legal frameworks within the UK.
Who should attend?
All those involved in the specifying, design, installation, commissioning, and maintenance of Access Control Systems including specifiers, property managers, consultants, FM providers, security consultants, and security installers.
Course content
Enquiry
Risk Assessment
Operational Requirements
Initial Design
Quote
Order
System Design Specification
Installation
Commissioning
Handover
Maintenance
Assessment



Ember Compliance

Professional Development

Engineer

Continuous Professional Development (CPD)

Learners will be introduced to the design, installation, commissioning, and maintenance of Access Control systems. 

C20M03 - Access control systems - Principles (online)

London

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

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

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

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

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

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

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

			 

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

<div>   

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

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




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

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

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

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

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

Tables, Rows and Columns

Indexes, Primary Keys and Foreign Keys

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

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

SQL Arithmetic Operations, Expression Queries

SQL Column Aliases

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

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

The Group By Clause

The Having Clause 
Querying Multiple Tables:
 Joins 

Joining Tables

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

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

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



PCWorkshops

Online Course Creation

Database Programming

IT Skills

Data Skills

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

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

General admission

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

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

Kingfisher Access

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

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

IPAF - Harness Awareness 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

		<div> 
						 

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




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



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

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

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

Microsoft SQL Server

SQL Server

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

SQL Course Advanced, 2 Days

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

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Medication awareness training&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">9:30 - 12:30</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For up to 12 delegates per session</p>

Medication Awareness training is mandatory for all staff who are prompting or assisting clients to take their medications.
About this event
Medication Awareness training is for staff who have had never taken part in Medication training before or staff returning to the profession.
By the end of the course, you will be able to:
Understand medication types and uses
Learn legal and ethical responsibilities
Master medication administration procedures
Know proper storage and disposal methods
Recognize and respond to adverse effects
Develop communication and record-keeping skills
Apply person-centred approaches
Conduct risk assessments.

Location for delegates attending in person
Online via Teams
0798 999 5180. sales@chcaretraining.co.uk

Before you book:
Please do not send along staff who have just worked a nightshift or who will be visiting clients immediately before or immediately after a training session. People arriving tired, stressed or late cannot gain the most benefit from a training course. We reserve the right to turn away individuals too exhausted to focus on the training or staff who turn up late for a course and disturb the flow of the proceedings.
All CH Care Training courses are fully inclusive, but if you have any concerns about a member of staff's ability to participate because of physical, sensory or learning differences then please let us know in confidence in advance, so that we may make the appropriate adjustments.

Cancellations
CH Care Training operates a sliding scale of cancellation; If you cancel more than two weeks before the start date of a course, you can ask for a full refund, to change the names of the delegates being sent along, or to transfer a delegate to another training date. If you give less than two weeks but more than one week's notice of cancellation, 50 percent of the booking can be refunded. If you cancel less than a week from the training delivery date we wont be able to refund. There are no refunds for staff who do not turn up on the day of the training course.
If CH Care Training needs to change the date or cancel a course for any reason we will give you the maximum notice we can. In exceptional circumstances we may cancel a course due to extreme weather or circumstances at the training venue. You will be offered a full refund or the opportunity to transfer your booking to an alternative date.

Please ask your staff to read the following guidance before they attend the course:
Arriving at the Venue
The course will start promptly so please arrive at least 15 minutes before the start time of the training to allow plenty of time to use the toilet, and be seated ready for the start of the course.
You can call Training direct on 0798 999 5180 if you are struggling to arrive on time. Please note that the meeting will be locked to late arrivals 10 minutes after the actual course starts.
When you arrive please come into Reception and a member of staff will come to book you in prior to directing you to the training room. This room is located on the ground floor and is wheelchair accessible.

Covid-Secure Premises
Please do not attend the course if you have symptoms of Covid or are feeling unwell. 

During the course
As this is a working environment please ensure you allow the necessary time and focus to get the best from the material being presented. Please bring pen and paper to make notes during the course. Our training sessions are fun and very interactive. We will encourage plenty of comments, points of view and the sharing of lived experiences. Delegates should not share any sensitive information about a client or organisation. Our session agreement asks delegates to maintain confidentiality about individuals and organisations and to respect the views of others on the course.
All CH Care Training courses are inclusive, but if you have any concerns about your ability to participate, such as sensory or learning differences then please let the Trainer know in confidence before the start of a course, so that they may make the appropriate adjustments.
If the course contains practical elements such as Moving & Handling or First Aid, then please wear appropriate clothing to take part in these activities. You will be asked confidentially if you have any health concerns that could prevent you from taking part in the practical activities. Please let a Trainer know if you have any concerns about taking part in the practical courses.
Refreshments are provided for free. Please bring a packed lunch for any full-day courses.

After the course
We will email you a pdf of the course once the training has finished and we have checked that everyone was able to join. If your Manager booked you onto the course using your work or personal email, or if you book yourself onto a course, you will receive the pdf directly. If your Manager booked you onto the course using your organisation’s email address a copy of the course will be available on request from your Manager.
We will also email a link to an online evaluation and we ask that you please fill this in and return it to us so that we can continue to improve our services. All of our evaluations are gathered anonymously.

If you have any questions, please contact Training on 0798 999 5180 or email sales@chcaretraining.co.uk.

CH Care Training

Medication Awareness training for Acer Care

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Sixty minute webinar on Rally Regularity Timing covering equipment required, how to keep to time, working out penalties and speed changes, this webinar focuses on styles of regularity that require the use of standard average speed tables. The competitive component of on the public highway historic road rallying, focusing on regularity using average speed tables. Ideal for competitors on events such as HRCR Clubmans Championship or Rally of the Tests</p>

Mastering Regularity Rallying: A 60-Minute Webinar
Elevate your rallying skills with this focused, one-hour webinar designed to boost your confidence in regularity time keeping, essential for competitive historic road rallying on public highways. Dive into the essentials of average speed tables, timing strategies, and control procedures, and gain insider tips for recovering from common mistakes to stay on course. Perfect for competitors aiming to excel in top-tier events like the HERO Rally of the Tests or HRCR Championship rallies, this webinar offers practical insights to enhance your performance. Join us to refine your skills and gain a competitive edge!

Rally Navigation Training Services

Sports & Fitness

Historic Road Rallying training webinar on Regularity focusing on Average Speed Table style regularities.

Rally Navigation - Regularity for Improvers

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">LOOKING FOR</strong>: ADULT FICTION</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Sarah Williams is a Director of the <a href="http://www.sophiehicksagency.com/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Sophie Hicks Agency</a> which she joined in 2014 and she has worked as a literary agent for over 10 years. Sarah represents a wide range of adult fiction and non-fiction and as she runs the film and television side of the agency, she is particularly interested in books that have screen potential.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">She is looking for literary fiction, reading group fiction, memoir and lifestyle/personal development - basically any book that can surprise, change and challenge a reader. Recent favourites are <em fr-original-style="" style="box-sizing: border-box;">Tides</em> by Sara Freeman, <em fr-original-style="" style="box-sizing: border-box;">The Paper Palace</em> by Miranda Cowley Heller, <em fr-original-style="" style="box-sizing: border-box;">Early Morning Riser</em> by Katherine Heiney and <em fr-original-style="" style="box-sizing: border-box;">In The Dream House</em> by Carmen Maria Machado.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Sarah would like you to submit a covering letter, 1 page synopsis and the first 20 - 30 pages of your manuscript in a single word document.</strong></p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">(<em fr-original-style="" style="box-sizing: border-box;">In addition to the paid sessions, Sarah is kindly offering one free session for low income/under-represented writers. Please email <a href="mailto:agent121@iaminprint.co.uk" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">agent121@iaminprint.co.uk</a>&nbsp;to apply, outlining your case for this option which is offered at the&nbsp;</em><em fr-original-style="" style="box-sizing: border-box;">discretion of&nbsp;</em><em fr-original-style="" style="box-sizing: border-box;">I Am In Print)</em>.&nbsp;</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">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 fr-original-style="" style="box-sizing: border-box;">I Am In Pr</em><em fr-original-style="" style="box-sizing: border-box;">int</em>&nbsp;prior to the event. You also agree to email your material in one document to reach&nbsp;<em fr-original-style="" style="box-sizing: border-box;">I Am In Print</em>&nbsp;by the stated submission deadline and note that&nbsp;<em fr-original-style="" style="box-sizing: border-box;">I Am In Print</em>&nbsp;take no responsibility for the advice received during your agent meeting.</p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">The submission deadline is: Wednesday 31 January 2024</strong></p>

LOOKING FOR: ADULT FICTION
Sarah Williams is a Director of the Sophie Hicks Agency which she joined in 2014 and she has worked as a literary agent for over 10 years. Sarah represents a wide range of adult fiction and non-fiction and as she runs the film and television side of the agency, she is particularly interested in books that have screen potential.
She is looking for literary fiction, reading group fiction, memoir and lifestyle/personal development - basically any book that can surprise, change and challenge a reader. Recent favourites are Tides by Sara Freeman, The Paper Palace by Miranda Cowley Heller, Early Morning Riser by Katherine Heiney and In The Dream House by Carmen Maria Machado.
Sarah would like you to submit a covering letter, 1 page synopsis and the first 20 - 30 pages of your manuscript in a single word document.
(In addition to the paid sessions, Sarah 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 and note that I Am In Print take no responsibility for the advice received during your agent meeting.
The submission deadline is: Tuesday 19 November 2024

1860 Courses in Edinburgh

Organising and Managing Events

By SAVO CIC

An Understanding of Gastrostomy Tube Care and Safe Use

By Guardian Angels Training

An Understanding of Fine-Bore Nasogastric Tube Insertion, Care and Safe Use

By Guardian Angels Training

NPORS Remote Control Tower Crane (N115)

By Dynamic Training and Assessments Ltd

NPORS Overhead Crane (N104)

By Dynamic Training and Assessments Ltd

NPORS Plant Machinery Marshal (N133)

By Dynamic Training and Assessments Ltd

NPORS Mobile Crane (N101)

By Dynamic Training and Assessments Ltd

Stress Management

By Mpi Learning - Professional Learning And Development Provider

NPORS Excavation Marshall - Banksperson (N027)

By Dynamic Training and Assessments Ltd

NPORS Loading Shovel (N209)

By Dynamic Training and Assessments Ltd

Search By Location