Stockport 

At CAPE Coaching & Development, we understand the value of effective and impactful development. This September and October 2024, we’re offering 90-minute interactive online workshops designed to empower your teams and drive success.
Choose from our tailored topics:
1. Dealing with Imposter Syndrome: Understand why it happens and learn practical strategies to overcome it.
2. Stress and Resilience: Discover the true meaning of resilience, its link to wellbeing, and why it’s crucial both at work and home. Learn key techniques to manage stress and create a personal resilience template.
3. Emotional Intelligence: Unlock the secret to workplace success. Explore its importance, how to develop it, and its impact on professional relationships.
4. Critical Thinking and Problem Solving: Learn how to get unstuck, make better decisions, and focus on the right tasks.
5. Motivating Yourself and Others: Understand why the carrot and stick approach falls short and discover more effective motivation strategies.
Exceptional Value: Only £495 plus VAT per workshop.
Don’t miss out on this opportunity to bring high-impact development to your organisation. 
CAPE's Commitment
At CAPE Coaching & Development, we are dedicated to providing high-quality, impactful development that truly makes a difference. Our workshops are designed to be engaging, practical, and relevant, ensuring your teams gain the skills and insights they need to excel. Join us in creating a motivated, resilient, and emotionally intelligent workforce ready to tackle any challenge.
Sign up today: info@wearyourcape.co.uk and visit our website for more info.

CAPE Coaching and Development

Team Building

Employee Engagement

Motivation

Emotional Intelligence (EQ)

Leadership Skills

Emotional Resilience

8D Problem Solving

THRIVE

Team Management

Academic & Personal Development

Critical Thinking

Give your team the tools they need to thrive! Sign up for our 90-minute interactive workshops this September and October. From imposter syndrome to motivation, we’ve got you covered. Contact us at info@wearyourcape.co.uk to book. 

Ready to Reignite Your Team Post-Summer?

Northampton

Your course will be bespoke designed to meet your business needs. You can come to us, we can come to you or we can do it online. The choice is yours. 
All of our training is engaging as well as insightful. Please see details of our modules here. 


Beyond Theory: business training & coaching

Leadership Development

Professional Development

Institute of Leadership & Management (ILM)

Bespoke and One-off Courses and Workshops

We offer a range of customer service training courses to equip people with the skills and knowledge needed to deliver the very best customer experience. Each of our courses will be bespoke designed to align with your business and meet you and your teams learning needs. 
All of our training is engaging as well as insightful. Learn more about our Customer Excellence training here. 


Customer Experience

Customer Care

Customer Service

Customer Success (CS)

Customer Journey

Dealing With Difficult Customers

Customer Experience Management

leadership management training course customer service training 

Customer Excellence Training

Use the SDI 2.0 to discover your strengths and overdone strengths. Your course will be bespoke designed to meet your business needs, enabling you to improve relationships and teamwork at work and beyond. You can come to us, we can come to you or we can do it online. The choice is yours. 
All of our training is engaging as well as insightful. Learn more about our SDI 2.0 training here. 


Coaching & Consulting Business

Coaching

SDI 2.0 (Strength Deployment Inventory) : personality profiling

Use the MBTI to discover your personality preferences - those habits that help and hinder your progress. Your course will be bespoke designed to meet your business needs, enabling you to improve relationships and teamwork at work and beyond. You can come to us, we can come to you or we can do it online. The choice is yours. 
All of our training is engaging as well as insightful. Learn more about our MBTI training here. 


leadership management training course MBTI personality profiling 

MBTI (Myers Briggs Type Indicator) : personality profiling

Nobody is perfect but a team can be. Use Belbin Team Roles to discover your teams strengths and overdone strengths. Your course will be bespoke designed to meet your business needs, enabling you to improve relationships and teamwork at work and beyond. You can come to us, we can come to you or we can do it online. The choice is yours. 
All of our training is engaging as well as insightful. Learn more about our Belbin Team Roles training here. 


Team Leader

leadership management training course belbin team roles 

Belbin Team Roles : personality profiling

Your course will be bespoke designed to meet your business needs. You can come to us, we can come to you or we can do it online. The choice is yours. 
A minimum of 4 half day modules are needed to achieve accreditation. Please see details of our modules here. 
Our Engaging Leadership training has been mapped to Level 5. This means that all participants on our Institute Approved training will have access to student membership with The Institute of Leadership. Following completion of your course the Institute will provide external recognition of your learning. You will receive a Certificate of Achievement from us, plus automatic upgrade to professional membership for the remainder of your student membership term. You’ll also receive a membership certificate, post-nominals (if Associate, Member or Fellow) and a digital credential to share on social media. 

Coaching Skills

Mentoring

Mentor

leadership management training course mentoring coaching 

Coaching & Mentoring Skills - accredited by the Institute of Leadership 

Your course will be bespoke designed to meet your business needs. You select the learning you need from our range of 20 half day modules and we provide the training. You can come to us, we can come to you or we can do it online. The choice is yours. 
A minimum of 9 half day modules are needed to achieve accreditation. Please see details of our modules here. 
Our Engaging Leadership training has been mapped to Level 5. This means that all participants on our Institute Approved training will have access to student membership with The Institute of Leadership. Following completion of your course the Institute will provide external recognition of your learning. You will receive a Certificate of Achievement from us, plus automatic upgrade to professional membership for the remainder of your student membership term. You’ll also receive a membership certificate, post-nominals (if Associate, Member or Fellow) and a digital credential to share on social media. 

Engaging Leadership - accredited by the Institute of Leadership

Customer Service Leadership - accredited by the Institute of Leadership

HACCP Trainer - Level 2 HACCP Training Course 
On-Site HACCP Training for Your Food Business
Do you require an expert HACCP trainer to visit your premises and deliver training on the principles of HACCP to your staff?
Our experienced trainers can come directly to your business location to provide tailored, on-site HACCP training, ensuring that your team gain knowledge and skills to maintain food safety standards. 
This Level 2 HACCP course is designed for individuals working in food and drink manufacturing, as well as catering businesses. It is particularly beneficial for those who are new to HACCP, as well as those who have gained some practical experience or knowledge through their work.
We have delivered this course at different manufacturing sites which include, brewers, distillers, fishmongers, cakes, bread, noodle, pastries, meats, ready meals and food packaging factories. 
Catering companies we have taught HACCP to include, sushi and sashimi, contract caterers, artisans, butchers, cakes/biscuits/cookies, residential care homes, retailers and more. 
The level 2 course in HACCP is a one day course, typically 9am-5pm.
Special offer £250 plus £20pp (usually £350 plus £30pp) includes RSPH exam fees and course material. 
You will learn about the Principles of HACCP, Food Safety Management, Hazards, CCPs, Critical Limits, Target Levels, Codex Decision Tree, Different methods of Monitoring, Corrective Actions, Verification methods and HACCP documentation. We will also cover Safer Food Better Business for Catering learners.
You will be assessed by a multiple choice exam of 20 questions. 
Although we are based in London, we do travel to different locations outside London. Trainer travel fees may be applicable, depending on your business location.
We also offer Level 3 HACCP training.
Contact us to enquire or to book

Kitchen Tonic Training Company and Food Safety Consultants

Health & Safety

Food Handling

HACCP

HACCP Trainer - HACCP Level 2 RSPH - Onsite Training Nationwide

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

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)

General Admission

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

<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

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

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

<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;">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

<h2 id="isPasted" style="color: rgb(45, 66, 76); box-sizing: border-box;" fr-original-style=" color: rgb(45, 66, 76);">What is the course about?</h2><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">You&#39;re a maker in your favoured medium - ceramics, wood, metal, glass or whatever - and you want to make electric lamps.</p><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">This course will tell you everything you need to know beyond using your existing skills in making the lamp base: design considerations; bulbs, bulb holders and lampshades; wiring; testing; and all the standards and regulations that you need to conform to (covering UK and EU requirements).</p><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">Note that although I am a potter, the course is not centered round the use of ceramics (or any other material) in making your lamp base.&nbsp;</p><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">The course is run over three weekly sessions, 19:00 &ndash; 20:30. These are recorded and put onto the course web page so you can view them at other times.</p><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">An additional discussion session will be set up at a time when most students can attend, even if not able to attend the live sessions - this will be scheduled at the start of the course.</p><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">In addition, a number of videos show the stages in wiring up and testing many types of lamp, and these can be watched from the course page.</p><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">The course page also has links to additional information that you may find useful.</p><h2 style="color: rgb(45, 66, 76); box-sizing: border-box;" fr-original-style=" color: rgb(45, 66, 76);">What will we cover?</h2><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">Lamp proportions and design considerations; basics of lighting; bulbs and bulb holders, switches and lampshades; electrical considerations and wiring up your lamp; testing your lamp; standards and regulations.</p><h2 style="color: rgb(45, 66, 76); box-sizing: border-box;" fr-original-style=" color: rgb(45, 66, 76);">What will I achieve?</h2><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">By the end of this course you should be able to&hellip;</p><ul style="color: rgb(91, 107, 114); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);"><li fr-original-style="" style="box-sizing: border-box;">Be familiar with the design proportions and considerations for different types of lamp, e.g. bedside, desktop, floor standing, wall or ceiling</li><li fr-original-style="" style="box-sizing: border-box;">Be familiar with the various options for light bulbs, bulb holders and switches</li><li fr-original-style="" style="box-sizing: border-box;">Understand the pros and cons of making a lamp that runs directly off the mains, or that uses a transformer</li><li fr-original-style="" style="box-sizing: border-box;">Be able to select the necessary components, and wire up, a lamp</li><li fr-original-style="" style="box-sizing: border-box;">Know how to test your lamps, what instrumentation is needed, and how manufacturing tests differ from PAT testing</li><li fr-original-style="" style="box-sizing: border-box;">Understand the standards and requirements and how they affect the design of your lamp</li><li fr-original-style="" style="box-sizing: border-box;">Be able to produce the necessary documentation to accompany your lamp, and know how to make it eligible to use the required CE / UKCA mark</li><li fr-original-style="" style="box-sizing: border-box;">Understand the principles behind WEEE, and the requirements this imposes on the maker and the retailer</li></ul><h2 style="color: rgb(45, 66, 76); box-sizing: border-box;" fr-original-style=" color: rgb(45, 66, 76);">What level is the course and do I need any particular skills?</h2><p style="color: rgb(91, 107, 114); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);">Intermediate. You should have the skills to make the lamp base in your preferred material, as that is not covered in the course though obviously necessary to make a lamp.&nbsp;</p><h2 style="color: rgb(45, 66, 76); box-sizing: border-box;" fr-original-style=" color: rgb(45, 66, 76);">What do I get?</h2><ul style="color: rgb(91, 107, 114); box-sizing: border-box;" fr-original-style=" color: rgb(91, 107, 114);"><li fr-original-style="" style="box-sizing: border-box;">Three live sessions with questions and discussions, lasting about 90 minutes each week</li><li fr-original-style="" style="box-sizing: border-box;">Recordings of all sessions for later viewing on the course page</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Downloadable PDFs of all presentations</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">A set of videos on the course page taking you through assembling, wiring and testing of lamps</li><li fr-original-style="" style="box-sizing: border-box;">Additional optional online course material, giving background info and greater depth</li><li fr-original-style="" style="box-sizing: border-box;">A discussion session where you can ask anything related to the course or related matters - the date and time will be scheduled so most students can participate, including those unable to attend the live sessions</li><li fr-original-style="" style="box-sizing: border-box;">Premium level access to the Tech part of my web site, containing much more information, references etc.</li><li fr-original-style="" style="box-sizing: border-box;">Course completion certificate</li></ul>

What is the course about?
You're a maker in your favoured medium - ceramics, wood, metal, glass or whatever - and you want to make electric lamps.
This course will tell you everything you need to know beyond using your existing skills in making the lamp base: design considerations; bulbs, bulb holders and lampshades; wiring; testing; and all the standards and regulations that you need to conform to (covering UK and EU requirements).
Note that although I am a potter, the course is not centered round the use of ceramics (or any other material) in making your lamp base. 
The course is run over three weekly sessions, 19:00 – 20:30. These are recorded and put onto the course web page so you can view them at other times.
An additional discussion session will be set up at a time when most students can attend, even if not able to attend the live sessions - this will be scheduled at the start of the course.
In addition, a number of videos show the stages in wiring up and testing many types of lamp, and these can be watched from the course page.
The course page also has links to additional information that you may find useful.
What will we cover?
Lamp proportions and design considerations; basics of lighting; bulbs and bulb holders, switches and lampshades; electrical considerations and wiring up your lamp; testing your lamp; standards and regulations.
What will I achieve?
By the end of this course you should be able to…
Be familiar with the design proportions and considerations for different types of lamp, e.g. bedside, desktop, floor standing, wall or ceiling
Be familiar with the various options for light bulbs, bulb holders and switches
Understand the pros and cons of making a lamp that runs directly off the mains, or that uses a transformer
Be able to select the necessary components, and wire up, a lamp
Know how to test your lamps, what instrumentation is needed, and how manufacturing tests differ from PAT testing
Understand the standards and requirements and how they affect the design of your lamp
Be able to produce the necessary documentation to accompany your lamp, and know how to make it eligible to use the required CE / UKCA mark
Understand the principles behind WEEE, and the requirements this imposes on the maker and the retailer
What level is the course and do I need any particular skills?
Intermediate. You should have the skills to make the lamp base in your preferred material, as that is not covered in the course though obviously necessary to make a lamp. 
What do I get?
Three live sessions with questions and discussions, lasting about 90 minutes each week
Recordings of all sessions for later viewing on the course page
Downloadable PDFs of all presentations
A set of videos on the course page taking you through assembling, wiring and testing of lamps
Additional optional online course material, giving background info and greater depth
A discussion session where you can ask anything related to the course or related matters - the date and time will be scheduled so most students can participate, including those unable to attend the live sessions
Premium level access to the Tech part of my web site, containing much more information, references etc.
Course completion certificate

Tim Thornton

Lighting Design

Lampshade Making

Arts & Crafts

Want to make electric lamps, but not sure about the wiring, regulations and so on? If you can make the lamp base (in clay, wood, glass metal or whatever), then this course tells you how to do the rest.

Making Electric Lamps

<p style="color: rgba(26, 26, 26, 0.7); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgba(26, 26, 26, 0.7);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Live via Zoom. Fortnightly - 3/17/31 Oct, 14/28 Nov, 12 Dec - 6-8pm UK time (plus an optional sharing session on 9 Jan)</em></strong></p><p style="color: rgba(26, 26, 26, 0.7); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgba(26, 26, 26, 0.7);">Join artist Julie Galante for this brand new course designed to nurture your creative practice. Together we&rsquo;ll explore ways to &nbsp;create work that reflects your individual interests, passion, and point of view, no matter your experience level. The course content is delivered over seven live Zoom sessions, in a small, welcoming group with plenty of opportunities for interaction. Additionally, there will be optional (but highly recommended) assignments to complete in between the live sessions - assignments designed to get you stuck in to your creative practice in new and interesting ways.</p><p style="color: rgba(26, 26, 26, 0.7); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgba(26, 26, 26, 0.7);">During each live session, there will be a demonstration focusing on a particular aspect of visual art - this will include various materials, subjects, and considerations such as composition, theme, mark-making, layering, and so on. We will also have a look at everyone&rsquo;s recent creations, with celebration of the triumphs and suggestions for moving forward with work-in-progress. Together we&rsquo;ll explore techniques including drawing, painting, mixed-media, paper craft, and collage, but you don&rsquo;t have to work exclusively in these media to take part - all creative disciplines are welcome.</p><p style="color: rgba(26, 26, 26, 0.7); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgba(26, 26, 26, 0.7);">Each participant will be encouraged to deepen their explorations in whatever direction interests them most - be it a series of written reflections, sketches, collages, photographs, mixed-media pieces, or a unique, personal combination of all these.</p><p style="color: rgba(26, 26, 26, 0.7); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgba(26, 26, 26, 0.7);">There will be an optional online discussion group for participants to stay connected and share their creations with each other between sessions. There will also be discounts available for other workshops and one-to-one mentoring.&nbsp;</p>

Live via Zoom. Fortnightly - 1/15/29 Oct, 12/26 Nov, 10 Dec - 6-8pm UK time 
Join artist Julie Galante for this course designed to nurture your creative practice. Together we’ll explore ways to create work that reflects your individual interests, passion, and point of view, no matter your experience level. The course content is delivered over six live Zoom sessions, in a small, welcoming group with plenty of opportunities for interaction. Additionally, there will be optional (but highly recommended) assignments to complete in between the live sessions - assignments designed to get you stuck in to your creative practice in new and interesting ways.
During each live session, there will be a demonstration focusing on a particular aspect of visual art - this will include various materials, subjects, and considerations such as composition, theme, mark-making, layering, and so on. We will also have a look at everyone’s recent creations, with celebration of the triumphs and suggestions for moving forward with work-in-progress. Together we’ll explore techniques including drawing, painting, mixed-media, and collage, but you don’t have to work exclusively in these media to take part - all creative disciplines are welcome.
Each participant will be encouraged to deepen their explorations in whatever direction interests them most - be it a series of drawings, written reflections, sketches, collages, photographs, mixed-media pieces, or a unique, personal combination of all these.
There will be an optional Facebook group for participants to stay connected and share their creations with each other between sessions. There will also be discounts available for other workshops and one-to-one mentoring. 

845 Design courses in Nottingham

Ready to Reignite Your Team Post-Summer?

By CAPE Coaching and Development

Bespoke and One-off Courses and Workshops

By Beyond Theory: business training & coaching

Customer Excellence Training

By Beyond Theory: business training & coaching

SDI 2.0 (Strength Deployment Inventory) : personality profiling

By Beyond Theory: business training & coaching

MBTI (Myers Briggs Type Indicator) : personality profiling

By Beyond Theory: business training & coaching

Belbin Team Roles : personality profiling

By Beyond Theory: business training & coaching

Coaching & Mentoring Skills - accredited by the Institute of Leadership

By Beyond Theory: business training & coaching

Engaging Leadership - accredited by the Institute of Leadership

By Beyond Theory: business training & coaching

Customer Service Leadership - accredited by the Institute of Leadership

By Beyond Theory: business training & coaching

HACCP Trainer - HACCP Level 2 RSPH - Onsite Training Nationwide

By Kitchen Tonic Training Company and Food Safety Consultants

Search By Location