Stoke on Trent

<h2>Course Details</h2><p>Level 3 First Aid at Work (FAW) On-Site (8 Delegates)

Suitability 
It is suitable for workplaces where risk assessments identify the need for highly trained first aiders due to the size of the organisation or workplace, nature of the business or the groups of individuals considered. Learners should be a minimum of 16 years to undertake this qualification.  

Description
The comprehensive and in-depth course will be delivered in a friendly and relaxed way, and will enable learners to respond to an extensive range of first aid incidents and emergencies. It will also provide fundamental details on the legalities of first aid and the responsibilities of employers.. 

Course Content
* What is First Aid?                                                             
* Bones, joints &amp; muscle injuries
* Legislation                                                                         
* Head &amp; Spinal injuries
* Responsibilities of the First Aider.                             
* Chest &amp; abdominal injuries
* Action in an Emergency                                                
* Specialised burn injuries
* Primary Survey                                                                  
* Eye injuries
* Secondary Assessment                                                 
* Poisoning
* The Respiratory System                                                
* Anaphylaxis
* Resuscitation &amp; AED                                                       
* Major illnesses
* Disorders of respiration                                                     
* Disorders of circulation                                                 
* Wounds &amp; Bleeding                                                         
* Seizures                                                                                
* Minor Burns and Scalds
* Foreign objects

Additional sessions (if relevant)
* Extreme heat &amp; cold injuries
* Bites &amp; Stings

How is this course assessed? 
Assessment is ongoing by the instructor, along with a multiple choice question paper after each day, and a three-year qualification will be issued to those who satisfy the criteria. In addition, the HSE strongly recommend that all students undergo an annual refresher programme of three hours.

Price includes all apparatus &amp; Certificates for all delegates</p>

Course Details
Level 3 First Aid at Work (FAW) On-Site (8 Delegates) Suitability It is suitable for workplaces where risk assessments identify the need for highly trained first aiders due to the size of the organisation or workplace, nature of the business or the groups of individuals considered. Learners should be a minimum of 16 years to undertake this qualification. Description
The comprehensive and in-depth course will be delivered in a friendly and relaxed way, and will enable learners to respond to an extensive range of first aid incidents and emergencies. It will also provide fundamental details on the legalities of first aid and the responsibilities of employers.. Course Content
* What is First Aid? * Bones, joints & muscle injuries
* Legislation * Head & Spinal injuries
* Responsibilities of the First Aider. * Chest & abdominal injuries
* Action in an Emergency * Specialised burn injuries
* Primary Survey * Eye injuries
* Secondary Assessment * Poisoning
* The Respiratory System * Anaphylaxis
* Resuscitation & AED * Major illnesses
* Disorders of respiration * Disorders of circulation * Wounds & Bleeding * Seizures * Minor Burns and Scalds
* Foreign objects Additional sessions (if relevant)
* Extreme heat & cold injuries
* Bites & Stings How is this course assessed? Assessment is ongoing by the instructor, along with a multiple choice question paper after each day, and a three-year qualification will be issued to those who satisfy the criteria. In addition, the HSE strongly recommend that all students undergo an annual refresher programme of three hours. Price includes all apparatus & Certificates for all delegates

You Can Do It .Training

The First Aid at Work (FAW) is the highest and most widely recognised first aid qualification.

Lvl3 First Aid at Work (3 Days) On-Site

<h2>Course Details</h2><p>If no dates are available, please contact the office on 01782 438813 for our next dates. 

This course gives delegates a better understanding of safety and the assessment of risk when working within confined spaces, keeping individuals and those around them safe.

ð Course Contents
Understand the legislation applying to Confined Space work
Understand Hazards associated with Confined Space
Undertake Risk Assessments for Confined Space work
Develop Safe Systems of Work and Safe Methods of Work for Confined Space operations (Including Risk Assessments, Method Statements, Rescue Plans and Permit to Work)
Safety Person (Top Man) Responsibilities
Understand the mechanism of atmosphere testing and monitoring
Develop, install and maintain emergency plans and procedures
Maintain records and documents for Confined Space work

If no dates are available please call the team on 01782 438813 for available dates.</p>

Course Details
If no dates are available, please contact the office on 01782 438813 for our next dates. This course gives delegates a better understanding of safety and the assessment of risk when working within confined spaces, keeping individuals and those around them safe. ð Course Contents
Understand the legislation applying to Confined Space work
Understand Hazards associated with Confined Space
Undertake Risk Assessments for Confined Space work
Develop Safe Systems of Work and Safe Methods of Work for Confined Space operations (Including Risk Assessments, Method Statements, Rescue Plans and Permit to Work)
Safety Person (Top Man) Responsibilities
Understand the mechanism of atmosphere testing and monitoring
Develop, install and maintain emergency plans and procedures
Maintain records and documents for Confined Space work If no dates are available please call the team on 01782 438813 for available dates.

First Aid At Work

Construction Safety

Site Management Safety Training Scheme (SMSTS)

Health & Safety Awareness

Confined Space

Safety Awareness

This 1/2 day course gives delegates a better understanding of safety and the assessment of risk.

Confined Space Awareness (On-Site)

<h2>Course Details</h2><p>Overview of the CITB SMSTS Course
The CITB Site Managers Safety Training Scheme course is designed for site managers, or aspiring site managers. It is designed for those with responsibility for managing, monitoring, implementing and reporting in a construction environment.

Assessment
To successfully achieve the course, delegates must:
Complete all four core exercises
Pass the trainer review and
Pass the end of course exam

The trainer review provides a pass/fail based on the delegate's performance and engagement in the core exercises and engagement in the course overall. Details of this are provided in XA6T.

The paper consists of 25 questions, selected by CITB, covering all aspects of the course. The exam must be taken at the end of the course. Each
Exam paper has:
18 multiple choice questions (each worth one mark)
7 questions in multi-response or short written answer format (each worth two marks)

The exam pass mark is 81% (26 out of 32). The exam lasts for 35 minutes and must be completed within this time under exam conditions. Delegates are permitted to use the Construction site safety - The comprehensive guide (GE700) publication and the Construction site management delegate workbook (XA6) for the last 15 minutes of the exam.

Length of Course
This is a five-day course. Delegates are required to complete the full course (37.5 hours) to be eligible for certification.

The course covers relevant health, safety and environmental legislation affecting safe working in the building, construction and civil engineering industries. It highlights the need for risk assessment in the workplace, the implementation of the necessary control measures, and adequate communication to sustain a health and safety culture among the workforce. 

The SMSTS course is endorsed by Build UK as the standard training for all construction managers. 
</p>

Course Details
Overview of the CITB SMSTS Course
The CITB Site Managers Safety Training Scheme course is designed for site managers, or aspiring site managers. It is designed for those with responsibility for managing, monitoring, implementing and reporting in a construction environment. Assessment
To successfully achieve the course, delegates must:
Complete all four core exercises
Pass the trainer review and
Pass the end of course exam The trainer review provides a pass/fail based on the delegate's performance and engagement in the core exercises and engagement in the course overall. Details of this are provided in XA6T. The paper consists of 25 questions, selected by CITB, covering all aspects of the course. The exam must be taken at the end of the course. Each
Exam paper has:
18 multiple choice questions (each worth one mark)
7 questions in multi-response or short written answer format (each worth two marks) The exam pass mark is 81% (26 out of 32). The exam lasts for 35 minutes and must be completed within this time under exam conditions. Delegates are permitted to use the Construction site safety - The comprehensive guide (GE700) publication and the Construction site management delegate workbook (XA6) for the last 15 minutes of the exam. Length of Course
This is a five-day course. Delegates are required to complete the full course (37.5 hours) to be eligible for certification. The course covers relevant health, safety and environmental legislation affecting safe working in the building, construction and civil engineering industries. It highlights the need for risk assessment in the workplace, the implementation of the necessary control measures, and adequate communication to sustain a health and safety culture among the workforce. The SMSTS course is endorsed by Build UK as the standard training for all construction managers. 

Site Safety Supervisor

Citb

CSCS (Construction Skills Certification Scheme)

Construction Design & Management (CDM)

Engineering Construction Industry Training (ECITB)

This course covers all relevant legislation affecting safe working in the building, construction...

CITB SMSTS (5 Days) (On-Site)

<h2>Course Details</h2><p>Overview of the CITB TWSTC Course
This course complements the Temporary works coordinator training course (TWCTC) and is designed to provide training for those undertaking the role of temporary works supervisor (TWS), as defined in BS 5975:2019. The rationale for the TWSTC is to set and raise standards across the industry, and to enable a transferable knowledge base between employers to avoid unnecessary supplementary training.

Entry requirements
There are no formal entry requirements. However, delegates should hold, or be about to hold, the role of a temporary works supervisor. 

Assessment
The examination paper is compulsory and consists of 25 multiple-choice questions selected by CITB. 

It forms the basis of assessing whether a delegate has achieved a sufficient level of understanding to be awarded the Temporary works supervisor training course (TWSTC) certificate. 

The examination lasts for 30 minutes and must be completed within this time. 
The examination is open book.
The examination pass mark is 72%.

Length of Course
This course is designed to be completed in one day. Delegates are required to attend the full day (seven hours) and pass the end-of-course assessment to be eligible for certification. 

The natural progression from this course would be to the Temporary works coordinator training course (TWCTC) if duties allowed. 
</p>

Course Details
Overview of the CITB TWSTC Course
This course complements the Temporary works coordinator training course (TWCTC) and is designed to provide training for those undertaking the role of temporary works supervisor (TWS), as defined in BS 5975:2019. The rationale for the TWSTC is to set and raise standards across the industry, and to enable a transferable knowledge base between employers to avoid unnecessary supplementary training. Entry requirements
There are no formal entry requirements. However, delegates should hold, or be about to hold, the role of a temporary works supervisor. Assessment
The examination paper is compulsory and consists of 25 multiple-choice questions selected by CITB. It forms the basis of assessing whether a delegate has achieved a sufficient level of understanding to be awarded the Temporary works supervisor training course (TWSTC) certificate. The examination lasts for 30 minutes and must be completed within this time. The examination is open book.
The examination pass mark is 72%. Length of Course
This course is designed to be completed in one day. Delegates are required to attend the full day (seven hours) and pass the end-of-course assessment to be eligible for certification. The natural progression from this course would be to the Temporary works coordinator training course (TWCTC) if duties allowed. 

Certificate of Completion of Training (CCT)

Certificate in Education & Training (CET)

This course is designed to provide training for those undertaking the role of temporary works...

CITB Temp Wks Sup'visor (1 Day)(On-Site)

<h2>Course Details</h2><p>This highly-regarded course gives team leaders, supervisors and managers, the training they need to manage health and safety effectively. Delegates will learn about safety and risk management in the workplace.  This course is created for up to 16 delegates.

ð Course content
Introduction and overview of the Health and Safety Law
Responsibilities of Supervisors and Managers
Assessing risks - definitions, factors to consider when carrying out a risk assessment
Risk control selection and the best methods to choose, including consideration of 'reasonably
practicable'</p>

Course Details
This highly-regarded course gives team leaders, supervisors and managers, the training they need to manage health and safety effectively. Delegates will learn about safety and risk management in the workplace. This course is created for up to 16 delegates. ð Course content
Introduction and overview of the Health and Safety Law
Responsibilities of Supervisors and Managers
Assessing risks - definitions, factors to consider when carrying out a risk assessment
Risk control selection and the best methods to choose, including consideration of 'reasonably
practicable'

Occupational Health & Safety

Workplace Health & Safety

Health & Safety

IOSH

This highly-regarded course gives team leaders, supervisors and managers, the training they need...

IOSH Managing Safely (On Site - 3 Days)

<h2>Course Details</h2><p>Overview of the CITB TWCTC Course
The Temporary works coordinator training course (TWCTC) is designed to assist those on site who have responsibility for managing all forms of temporary works. The course has been designed to give confidence to senior management, and to ensure that those who engage contractors have an assessed standard of knowledge.This course will give the delegate a thorough knowledge of the temporary works coordinator (TWC) role. However, this does not make a delegate competent by itself. Competence requires other attributes, such as experience. 

Entry requirements
There are no formal entry requirements. However, delegates should hold, or be about to hold, the role of a TWC.

Assessment
Assessment will be by a multiple-choice examination at the end of the course. Delegates will also be expected to interact and participate during the course. 

The examination paper is compulsory and consists of 25 multiple-choice questions selected by CITB. It forms the basis of assessing whether a delegate has achieved a sufficient level of understanding to be awarded the Temporary works coordinator training course (TWCTC) certificate. 

The examination lasts for 30 minutes and must be completed within this time. 
The examination is open book.
The examination pass mark is 72%

Length of Course
This course is designed to be completed over two consecutive days. Delegates are required to attend both days (14 hours) and to pass the end-of-course assessment to be eligible for certification.

The natural progression from this course would be to either the Site management safety training scheme (SMSTS) or Director's role for health and safety (DRHS) course, where duties allow. 

The course is supported by a number of organisations, including the Temporary Works forum, CECA, Build UK, HSE and FMB. This enables transferability of the training within the industry. Temporary works are safety- and business-critical and require careful coordination. An accepted way of achieving this is through the adoption of the management process outlined in BS 5975:2019, which introduces the temporary works coordinator (TWC) as a key figure. This course explains the role and its overall management context. Temporary works on both smaller and larger sites can be high risk. Therefore, understanding the essentials of good risk and safety management, as outlined in BS 5975:2019, is relevant for projects of all sizes. 
</p>

Course Details
Overview of the CITB TWCTC Course
The Temporary works coordinator training course (TWCTC) is designed to assist those on site who have responsibility for managing all forms of temporary works. The course has been designed to give confidence to senior management, and to ensure that those who engage contractors have an assessed standard of knowledge.This course will give the delegate a thorough knowledge of the temporary works coordinator (TWC) role. However, this does not make a delegate competent by itself. Competence requires other attributes, such as experience. Entry requirements
There are no formal entry requirements. However, delegates should hold, or be about to hold, the role of a TWC. Assessment
Assessment will be by a multiple-choice examination at the end of the course. Delegates will also be expected to interact and participate during the course. The examination paper is compulsory and consists of 25 multiple-choice questions selected by CITB. It forms the basis of assessing whether a delegate has achieved a sufficient level of understanding to be awarded the Temporary works coordinator training course (TWCTC) certificate. The examination lasts for 30 minutes and must be completed within this time. The examination is open book.
The examination pass mark is 72% Length of Course
This course is designed to be completed over two consecutive days. Delegates are required to attend both days (14 hours) and to pass the end-of-course assessment to be eligible for certification. The natural progression from this course would be to either the Site management safety training scheme (SMSTS) or Director's role for health and safety (DRHS) course, where duties allow. The course is supported by a number of organisations, including the Temporary Works forum, CECA, Build UK, HSE and FMB. This enables transferability of the training within the industry. Temporary works are safety- and business-critical and require careful coordination. An accepted way of achieving this is through the adoption of the management process outlined in BS 5975:2019, which introduces the temporary works coordinator (TWC) as a key figure. This course explains the role and its overall management context. Temporary works on both smaller and larger sites can be high risk. Therefore, understanding the essentials of good risk and safety management, as outlined in BS 5975:2019, is relevant for projects of all sizes. 

Certificate in Teaching Program (CTP)

This course is designed to assist those on site who have responsibility for managing all forms of...

CITB Temporary Works Coordinator On-Site

<h2>Course Details</h2><p>This course concentrates on the legal requirements for risk assessments in the organisation and the assessments and practical application. This course will give delegates the ability to carry out suitable and sufficient risk assessments.

ð Course Contents
Health and safety legislation
The management of health and safety at work regulations
Workplace accidents (causation)
The risk assessments process, understanding the key steps
Undertaking a practical risk assessment
Half day</p>

Course Details
This course concentrates on the legal requirements for risk assessments in the organisation and the assessments and practical application. This course will give delegates the ability to carry out suitable and sufficient risk assessments. ð Course Contents
Health and safety legislation
The management of health and safety at work regulations
Workplace accidents (causation)
The risk assessments process, understanding the key steps
Undertaking a practical risk assessment
Half day

Fire Risk Assessment

Risk Assessment

Health & Safety At Work

This course concentrates on the legal requirements for risk assessments in the organisation and...

Risk Assess. & Method Statement On-Site

<h2>Course Details</h2><p>Overview of the CITB SMSTS-R Course
The CITB Site Managers Safety Training Scheme course is designed for delegates who have previously passed the full Site management safety training scheme (SMSTS) course or subsequent refresher course, and can provide proof of attendance. It aims to bring health and safety knowledge up-to-date, as well as giving a thorough overview of the legislative changes and their impact in the workplace. The course provides an opportunity to revisit the wide range of topics from the previous five-day course.

Entry requirements
The refresher course is only for delegates who have previously passed the five-day SMSTS or subsequent refresher course, and hold a valid SMSTS certificate. Evidence must be provided to the training provider of their eligibility.

Assessment
Successful completion of the course requires the delegate to pass an exam paper at the end of the course. 

The paper consists of 25 questions, selected by CITB, covering all aspects of the course. The exam paper must be taken at the end of the course. 
Each paper has: 
• 18 multiple choice questions (each worth one mark) 
• 7 questions in multi-response or short written answer format (each worth two marks)

The exam pass mark is 81% (26 out of 32). The exam lasts for 35 minutes and must be completed within this time under exam conditions. Delegates are permitted to use the Construction site safety - The comprehensive guide (GE700) publication for the last 15 minutes of the exam.

Length of Course
This is a two-day course. Delegates are required to complete the full course (15 hours) to be eligible for certification.

The course aims to bring health and safety knowledge up-to-date, as well as giving a thorough overview of the legislative changes and their impact in the workplace. The course provides an opportunity to revisit the wide range of topics from the previous five-day course.
</p>

Course Details
Overview of the CITB SMSTS-R Course
The CITB Site Managers Safety Training Scheme course is designed for delegates who have previously passed the full Site management safety training scheme (SMSTS) course or subsequent refresher course, and can provide proof of attendance. It aims to bring health and safety knowledge up-to-date, as well as giving a thorough overview of the legislative changes and their impact in the workplace. The course provides an opportunity to revisit the wide range of topics from the previous five-day course. Entry requirements
The refresher course is only for delegates who have previously passed the five-day SMSTS or subsequent refresher course, and hold a valid SMSTS certificate. Evidence must be provided to the training provider of their eligibility. Assessment
Successful completion of the course requires the delegate to pass an exam paper at the end of the course. The paper consists of 25 questions, selected by CITB, covering all aspects of the course. The exam paper must be taken at the end of the course. Each paper has: • 18 multiple choice questions (each worth one mark) • 7 questions in multi-response or short written answer format (each worth two marks) The exam pass mark is 81% (26 out of 32). The exam lasts for 35 minutes and must be completed within this time under exam conditions. Delegates are permitted to use the Construction site safety - The comprehensive guide (GE700) publication for the last 15 minutes of the exam. Length of Course
This is a two-day course. Delegates are required to complete the full course (15 hours) to be eligible for certification. The course aims to bring health and safety knowledge up-to-date, as well as giving a thorough overview of the legislative changes and their impact in the workplace. The course provides an opportunity to revisit the wide range of topics from the previous five-day course.


Site Supervisor

SSSTS

This course is for you if you have previously passed the Site Management Safety Training Scheme...

CITB SMSTS Refresher (2 Days) (On-Site)

<h2>Course Details</h2><p>Overview of the CITB SSSTS Course
The CITB Site supervision safety training scheme (SSSTS) course is designed for those who have, or are about to acquire, supervisory responsibilities. The course covers all relevant legislation and other aspects which affect safe working in the building, construction and civil engineering industries. It highlights the need for risk assessment in the workplace, the implementation of the necessary control measures, and adequate communication to sustain a health and safety culture among the workforce. 

Entry requirements
Delegates should hold, or be about to hold, the role of a supervisor. Delegates must be competent in English at site supervisor level. 

Assessment
Assessment will be by an end of course examination and the trainer review. 

The examination paper is compulsory and consists of 25 questions, selected by CITB, covering all aspects of the course. The examination pass mark is 80% (24 out of 30). The paper consists of 22 multiple choice questions and three short written questions. There are four safety critical questions in each exam paper. The delegate must answer all four of these questions correctly to pass the exam. The multiple-choice questions are worth 1 point each, whereas written questions can score between 1-3 marks. 

Delegates will need to pass all three elements of the trainer review to gain a pass. 
The three elements of the trainer review are as follows:  
Exercise - overall, thinking about the delegate's performance in the group exercise, did they work well as part of the team?
Has the delegate actively engaged with the course and the group? 
Has the learner completed the toolbox talk?
All three elements will be either a pass (yes) or fail (no) and all three elements will need to achieve a pass for the delegate to pass this element of the course. 

Length of Course
This is a two-day course. Delegates are required to complete the full course (15 hours) to be eligible for certification. 

A natural progression from this course would be to attend the Site Management Safety Training Scheme (SMSTS) course. 

The SSSTS course is endorsed by Build UK and exceeds the standard set by CITB for construction supervisors training.  
</p>

Course Details
Overview of the CITB SSSTS Course
The CITB Site supervision safety training scheme (SSSTS) course is designed for those who have, or are about to acquire, supervisory responsibilities. The course covers all relevant legislation and other aspects which affect safe working in the building, construction and civil engineering industries. It highlights the need for risk assessment in the workplace, the implementation of the necessary control measures, and adequate communication to sustain a health and safety culture among the workforce. Entry requirements
Delegates should hold, or be about to hold, the role of a supervisor. Delegates must be competent in English at site supervisor level. Assessment
Assessment will be by an end of course examination and the trainer review. The examination paper is compulsory and consists of 25 questions, selected by CITB, covering all aspects of the course. The examination pass mark is 80% (24 out of 30). The paper consists of 22 multiple choice questions and three short written questions. There are four safety critical questions in each exam paper. The delegate must answer all four of these questions correctly to pass the exam. The multiple-choice questions are worth 1 point each, whereas written questions can score between 1-3 marks. Delegates will need to pass all three elements of the trainer review to gain a pass. The three elements of the trainer review are as follows: Exercise - overall, thinking about the delegate's performance in the group exercise, did they work well as part of the team?
Has the delegate actively engaged with the course and the group? Has the learner completed the toolbox talk?
All three elements will be either a pass (yes) or fail (no) and all three elements will need to achieve a pass for the delegate to pass this element of the course. Length of Course
This is a two-day course. Delegates are required to complete the full course (15 hours) to be eligible for certification. A natural progression from this course would be to attend the Site Management Safety Training Scheme (SMSTS) course. The SSSTS course is endorsed by Build UK and exceeds the standard set by CITB for construction supervisors training. 

Scaffolding Supervisor

This course provides a basic understanding of health & safety duties and responsibilities...

CITB SSSTS (2 Days) (On-Site)

<h2>Course Details</h2><p>Overview of the CITB SSSTS-R Course
This refresher course is for delegates who have previously passed the two-day Site supervision safety training scheme (SSSTS) course and can provide proof of successful attendance. 

Entry requirements
The refresher course is only for delegates who have previously passed the two-day Site supervision safety training scheme (SSSTS) course and can provide proof of successful attendance.

Assessment
Assessment will be by an exam paper at the end of the course. 

The examination paper is compulsory and consists of 25 questions, selected by CITB, covering all aspects of the course. The examination pass mark is 80% (24 out of 30). The paper consists of 22 multiple choice questions and three short written questions. There are four safety critical questions in each exam paper. The delegate must answer all four of these questions correctly to pass the exam. The multiple choice questions are worth 1 point each, whereas written questions can score between 1-3 marks. 

The exam paper forms the basis of assessment of whether or not a delegate has successfully achieved a satisfactory level of understanding to be awarded the Site supervision safety training scheme refresher (SSSTS-R) certificate. The examination lasts for 30 minutes and must be completed within this time. Delegates are permitted to use the Construction site supervision (GE706) publication for the last ten minutes of the examination period. 

Length of Course
This is a one-day course. Delegates are required to complete the full course (7.5 hours). 

It aims to bring health and safety knowledge up-to-date, as well as giving a thorough overview of the legislative changes and their impact in the workplace. The course includes a wide range of topics which have been affected by changes to procedures, and builds upon the material in the original course. 
</p>

Course Details
Overview of the CITB SSSTS-R Course
This refresher course is for delegates who have previously passed the two-day Site supervision safety training scheme (SSSTS) course and can provide proof of successful attendance. Entry requirements
The refresher course is only for delegates who have previously passed the two-day Site supervision safety training scheme (SSSTS) course and can provide proof of successful attendance. Assessment
Assessment will be by an exam paper at the end of the course. The examination paper is compulsory and consists of 25 questions, selected by CITB, covering all aspects of the course. The examination pass mark is 80% (24 out of 30). The paper consists of 22 multiple choice questions and three short written questions. There are four safety critical questions in each exam paper. The delegate must answer all four of these questions correctly to pass the exam. The multiple choice questions are worth 1 point each, whereas written questions can score between 1-3 marks. The exam paper forms the basis of assessment of whether or not a delegate has successfully achieved a satisfactory level of understanding to be awarded the Site supervision safety training scheme refresher (SSSTS-R) certificate. The examination lasts for 30 minutes and must be completed within this time. Delegates are permitted to use the Construction site supervision (GE706) publication for the last ten minutes of the examination period. Length of Course
This is a one-day course. Delegates are required to complete the full course (7.5 hours). It aims to bring health and safety knowledge up-to-date, as well as giving a thorough overview of the legislative changes and their impact in the workplace. The course includes a wide range of topics which have been affected by changes to procedures, and builds upon the material in the original course. 

SIA Training

Site supervisor safety training scheme refresher (SSSTS-R)

CITB SSSTS Refresher (1 Day) (On-Site)

This 1-day Driver CPC Periodic Training course focuses on critical areas of Emergency Aid and Security for professional drivers. Designed to meet Driver CPC requirements, this course equips drivers with essential skills for handling emergency situations and enhancing security awareness on the road.
Who Should Attend:
This course is ideal for all professional drivers required to complete Driver CPC Periodic Training to maintain their Driver CPC Licence. It’s tailored to both experienced drivers and those new to the field, providing relevant, up-to-date skills and knowledge.
Learning Objectives:
The aim of this course is to confirm and expand on each driver’s current knowledge and skills, ensuring they are informed about the latest legislation, best practices, and critical safety procedures. This training is designed to enhance drivers’ confidence and preparedness in managing emergencies and maintaining security awareness, helping them navigate the responsibilities of their role effectively.

Course Format: Online 

Join us to reinforce your skills, stay compliant, and improve your on-road safety practices!

Total Compliance 

Driver CPC - 1 Day Periodic 7 Hour Course - Security Training & Emergency Aid

General Admission

<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

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

<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

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This 4 week online Course is suitable for complete beginners and improvers who would like to learn to paint in Watercolour.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">Each session is 40 minutes live on Tuesday evening and start at 7.00-7.40pm Via Zoom<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">On this Course you will:<br fr-original-style="" style="box-sizing: border-box;">* learn to prepare your water colour paints and mix colours.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* learn a variety of watercolour techniques including, washes, wet in wet, graded, dry brush Flat Wash, Loose watercolour see photos, we will cover a variety of subjects.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* will be taught live by your tutor online via zoom with step- by -step demonstrations and clear explanations of the various stages.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">* Learners will then carry the various tasks alongside the tutor who will be at hand for any questions that you may have.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">This is a 4 week course offered live online via zoom this course rolls on and new dates will be added.</p>
<h2 fr-original-style="" style="box-sizing: border-box;">What&#39;s included in the price?</h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Online Tuition<br fr-original-style="" style="box-sizing: border-box;">Step by step Demonstrations via Zoom in the live class<br fr-original-style="" style="box-sizing: border-box;">Clear explanation from your Tutor<br fr-original-style="" style="box-sizing: border-box;">reference handouts sent via email</p>
<h2 fr-original-style="" style="box-sizing: border-box;">What you will need</h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Starter Kit Available from Tutor - Please email for details<br fr-original-style="" style="box-sizing: border-box;">Watercolour paints - tubes or pans<br fr-original-style="" style="box-sizing: border-box;">Watercolour paper ( Cold Pressed 300 gsm 140lb)<br fr-original-style="" style="box-sizing: border-box;">Round watercolour brushes- size 4 and 6 ( or similar)<br fr-original-style="" style="box-sizing: border-box;">HB graphite pencil to draw image<br fr-original-style="" style="box-sizing: border-box;">Eraser<br fr-original-style="" style="box-sizing: border-box;">Mixing Palette<br fr-original-style="" style="box-sizing: border-box;">2 x jars of clean water<br fr-original-style="" style="box-sizing: border-box;">Kitchen paper<br fr-original-style="" style="box-sizing: border-box;">Hairdryer<br fr-original-style="" style="box-sizing: border-box;">Sketchbook<br fr-original-style="" style="box-sizing: border-box;">Tracing paper</p>
<h2 fr-original-style="" style="box-sizing: border-box;">Suitable for</h2>
<ul fr-original-style="" fr-original-class="fa-ul course-checklists" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Adults</li>
<li fr-original-style="" style="box-sizing: border-box;">Engagement, birthdays &amp; anniversaries</li>
<li fr-original-style="" style="box-sizing: border-box;">Intermediate level</li>
<li fr-original-style="" style="box-sizing: border-box;">Seniors</li>
<li fr-original-style="" style="box-sizing: border-box;">Suitable for beginners</li>
<li fr-original-style="" style="box-sizing: border-box;">Teenagers</li>
<li fr-original-style="" style="box-sizing: border-box;">Wheelchair users</li>
</ul>

This 4 week online Course is suitable for complete beginners and improvers who would like to learn to paint in Watercolour.

Each session is 40 minutes live on Tuesday evening and start at 7.00-7.40pm Via Zoom

On this Course you will:
* learn to prepare your water colour paints and mix colours.

* learn a variety of watercolour techniques including, washes, wet in wet, graded, dry brush Flat Wash, Loose watercolour see photos, we will cover a variety of subjects.

* will be taught live by your tutor online via zoom with step- by -step demonstrations and clear explanations of the various stages.

* Learners will then carry the various tasks alongside the tutor who will be at hand for any questions that you may have.

This is a 4 week course offered live online via zoom this course rolls on and new dates will be added.
What's included in the price?
Online Tuition
Step by step Demonstrations via Zoom in the live class
Clear explanation from your Tutor
reference handouts sent via email
What you will need
Starter Kit Available from Tutor - Please email for details
Watercolour paints - tubes or pans
Watercolour paper ( Cold Pressed 300 gsm 140lb)
Round watercolour brushes- size 4 and 6 ( or similar)
HB graphite pencil to draw image
Eraser
Mixing Palette
2 x jars of clean water
Kitchen paper
Hairdryer
Sketchbook
Tracing paper
Suitable for
Adults
Engagement, birthdays & anniversaries
Intermediate level
Seniors
Suitable for beginners
Teenagers
Wheelchair users

Art By Purnima

Watercolour Painting

Watercolour Techniques for All - 4 week Online Course Tuesday Evenings Via Zoom

<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 

Oldham

<p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(50, 74, 109);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 11</strong></p><p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);">This module aims to develop knowledge and understanding of the importance of customs documentation in the world of international trade to ensure both parties clearly understand the documentation that will be required in the import or export of goods or services. This includes evidence of delivery, proof payment, export and import documentation, customs clearance, intellectual property rights, mitigating risk and dispute resolution.</p><p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Agenda</strong></p><ul style="color: rgb(50, 74, 109); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);"><li fr-original-style="" style="box-sizing: border-box;">Certificate of origin</li><li fr-original-style="" style="box-sizing: border-box;">Licences</li><li fr-original-style="" style="box-sizing: border-box;">Labelling</li><li fr-original-style="" style="box-sizing: border-box;">CMR</li><li fr-original-style="" style="box-sizing: border-box;">Proof of delivery</li><li fr-original-style="" style="box-sizing: border-box;">Certificate of origin</li><li fr-original-style="" style="box-sizing: border-box;">Health certificates</li><li fr-original-style="" style="box-sizing: border-box;">Proof of customs entry</li><li fr-original-style="" style="box-sizing: border-box;">Commodity codes</li><li fr-original-style="" style="box-sizing: border-box;">Certification</li><li fr-original-style="" style="box-sizing: border-box;">WTO</li><li fr-original-style="" style="box-sizing: border-box;">Chambers of commerce</li><li fr-original-style="" style="box-sizing: border-box;">International bodies</li></ul><p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);">&nbsp;</p><p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Examination:</strong><br fr-original-style="" style="box-sizing: border-box;">Certificate on completion and Pass on Multiple Choice<br fr-original-style="" style="box-sizing: border-box;">Multiple choice questionnaire<br fr-original-style="" style="box-sizing: border-box;">Credits: 1</p>

Module 11
This module aims to develop knowledge and understanding of the importance of customs documentation in the world of international trade to ensure both parties clearly understand the documentation that will be required in the import or export of goods or services. This includes evidence of delivery, proof payment, export and import documentation, customs clearance, intellectual property rights, mitigating risk and dispute resolution.
Agenda
Certificate of origin
Licences
Labelling
CMR
Proof of delivery
Certificate of origin
Health certificates
Proof of customs entry
Commodity codes
Certification
WTO
Chambers of commerce
International bodies
 
Examination:
Certificate on completion and Pass on Multiple Choice
Multiple choice questionnaire
Credits: 1

Export Unlocked Limited

Trade & Commerce

Documentary

International Trade

Import/Export

Customs

This module aims to develop knowledge and understanding of the importance of customs documentation in the world of international trade to ensure both parties clearly understand the documentation that will be required in the import or export of goods or services.

IMPORTANCE OF INTERNATIONAL DOCUMENTATION

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyT25lJTIwaG91ciUyMHdlYmluYXIlMjBmb3IlMjBjby1kcml2ZXJzJTIwbG9va2luZyUyMHRvJTIwdGFrZSUyMHRoZSUyMHN0ZXAlMjB1cCUyMGZyb20lMjBzaW5nbGUlMjB2ZW51ZSUyMHN0YWdlJTIwcmFsbGllcyUyMG9yJTIwcm9hZCUyMHJhbGx5aW5nJTIwdG8lMjBtdWx0aS12ZW51ZSUyMHN0YWdlJTIwcmFsbGllcy4lMjBMZWFybiUyMGFib3V0JTIwcm9hZGJvb2tzJTJDJTIwdGltZWNhcmRzJTJDJTIwdGltaW5nJTIwYW5kJTIwcGVuYWx0aWVzJTJDJTIwcGx1cyUyMHJvdXRlJTIwbm90ZXMlMjBhbmQlMjBwYWNlJTIwbm90ZXMlMjBhbmQlMjBtYW55JTIwbW9yZSUyMGhpbnRzJTIwYW5kJTIwdGlwcyUyMHRvJTIwYmVjb21lJTIwYSUyMHN1Y2Nlc3NmdWwlMjBzdGFnZSUyMGNvLWRyaXZlci4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" id="isPasted" fr-original-style="" style="box-sizing: border-box;">One hour webinar for co-drivers looking to take the step up from single venue stage rallies or road rallying to multi-venue stage rallies. Learn about roadbooks, timecards, timing and penalties, plus route notes and pace notes and many more hints and tips to become a successful stage co-driver.</span>


</p>

One hour webinar for co-drivers looking to take the step up from single venue stage rallies or road rallying to multi-venue stage rallies. Learn about roadbooks, timecards, timing and penalties, plus route notes and pace notes and many more hints and tips to become a successful stage co-driver. 

Rally Navigation Training Services

Sports & Fitness

Rally training webinar for co-drivers looking to take the step up from single venue stage rallies or road rallying to multi-venue stage rallies.

Multi Venue Stage Rally Co-Driving

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

2713 Courses in Edinburgh

Lvl3 First Aid at Work (3 Days) On-Site

By You Can Do It .Training

Confined Space Awareness (On-Site)

By You Can Do It .Training

CITB SMSTS (5 Days) (On-Site)

By You Can Do It .Training

CITB Temp Wks Sup'visor (1 Day)(On-Site)

By You Can Do It .Training

IOSH Managing Safely (On Site - 3 Days)

By You Can Do It .Training

CITB Temporary Works Coordinator On-Site

By You Can Do It .Training

Risk Assess. & Method Statement On-Site

By You Can Do It .Training

CITB SMSTS Refresher (2 Days) (On-Site)

By You Can Do It .Training

CITB SSSTS (2 Days) (On-Site)

By You Can Do It .Training

CITB SSSTS Refresher (1 Day) (On-Site)

By You Can Do It .Training

Search By Location