Name: General Data Protection Regulations
Price: 18 GBP
Availability: InStock

Consett

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course is will give the learner an awareness and understanding regarding the types of dementia, signs &amp; symptoms, the different causes of dementia. the course will also cover a range of treatments, strategies &amp; therapies that can improve the quality of life for a person with dementia.</p>

This course is will give the learner an awareness and understanding regarding the types of dementia, signs & symptoms, the different causes of dementia. the course will also cover a range of treatments, strategies & therapies that can improve the quality of life for a person with dementia.

Magpie Training

Dementia Awareness

Healthcare

Dementia Training

General Admission

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Mental health is often an invisible illness that can affect anyone! The aim of this course is to give the learner the knowledge of how to identify the signs, the effects, self help and where to access support.&nbsp;</p>

Mental health is often an invisible illness that can affect anyone! The aim of this course is to give the learner the knowledge of how to identify the signs, the effects, self help and where to access support. 

Mental Health Awareness

Health & Wellbeing

Emotional Wellbeing

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course will give the learner the knowledge on the safe handling of medication, covers legislation, mar charts, the importance of confidentiality and more.</p>

This course will give the learner the knowledge on the safe handling of medication, covers legislation, mar charts, the importance of confidentiality and more.

Privacy

Medication Administration

Safe Handling of Medication

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course will give the learner greater knowlegde on moving and assisting clients within their daily lives, from hoist training to understanding the legislation in place to ensure their safety and their clients.&nbsp;</p>

This course will give the learner greater knowlegde on moving and assisting clients within their daily lives, from hoist training to understanding the legislation in place to ensure their safety and their clients. 

Moving & Handling

Hoist

Care

Health & Social Care

Moving and assisiting training within health and social care

Moving and assisting

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Aims&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1.Raise&nbsp;awareness of challenging&nbsp;behaviour.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2.Recognise causes and types of challenging behaviour</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">3.&nbsp;Identify strategies&nbsp;to deal with the client presenting challenging&nbsp;behaviour</p>

Aims 
1.Raise awareness of challenging behaviour. 
2.Recognise causes and types of challenging behaviour
3. Identify strategies to deal with the client presenting challenging behaviour

Dementia

Addictions

Challenging Behaviour

Learning Disability

Most behaviour is learned, this course shows you how some behaviours are dangerous or restricting, and what you can do to help the person, and yourself

Behaviours that challenge, Promoting Positive Behaviour

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(77, 81, 86); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(77, 81, 86);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The term &#39;skin integrity&#39; refers to</strong>&nbsp;</span><b style="color: rgb(4, 12, 40); box-sizing: border-box;" fr-original-style=" color: rgb(4, 12, 40);">the skin being a sound and complete structure in unimpaired condition</b><span style="color: rgb(77, 81, 86); box-sizing: border-box;" fr-original-style="color: rgb(77, 81, 86);">.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(77, 81, 86); box-sizing: border-box;" fr-original-style="color: rgb(77, 81, 86);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">This course aims to ensure the learner gains the knowledge needed to help prevent skin damage and ulcers forming.</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(77, 81, 86); box-sizing: border-box;" fr-original-style="color: rgb(77, 81, 86);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Causes</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(77, 81, 86); box-sizing: border-box;" fr-original-style="color: rgb(77, 81, 86);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">conditions</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(77, 81, 86); box-sizing: border-box;" fr-original-style="color: rgb(77, 81, 86);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">risks</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(77, 81, 86); box-sizing: border-box;" fr-original-style="color: rgb(77, 81, 86);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">intervention</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(77, 81, 86); box-sizing: border-box;" fr-original-style="color: rgb(77, 81, 86);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">treatment</strong></span></p>

The term 'skin integrity' refers to the skin being a sound and complete structure in unimpaired condition. 
This course aims to ensure the learner gains the knowledge needed to help prevent skin damage and ulcers forming.
Causes
conditions
risks
intervention
treatment

Skincare

Skin Integrity

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Oral health is an important factor in health and social care that can often be missed, The CQC recommends that all staff have the relevent training so that they fully understand the importance of oral hygeine, their role as a carer, &nbsp;the risks and implications.&nbsp;</p>

Oral health is an important factor in health and social care that can often be missed, The CQC recommends that all staff have the relevent training so that they fully understand the importance of oral hygeine, their role as a carer, the risks and implications. 

Healthcare Assistant

Oral Health Education

Dental Hygiene

Residential Care Homes

Oral Health And Hygiene

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is an indepth course covering all aspects of personal care, bathing and hygiene within health and social care.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>

This is an indepth course covering all aspects of personal care, bathing and hygiene within health and social care.



Health & Hygiene

Health

Hand Hygiene

Carer

Personal Care And Bathing

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em style="color: rgb(95, 99, 104); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(95, 99, 104);">Dysphasia</em><span style="color: rgb(77, 81, 86); box-sizing: border-box;" fr-original-style="color: rgb(77, 81, 86);">&nbsp;is a language disorder. This course aims to cover causes, symptoms, treatments and risk factors.</span></p>

Dysphasia is a language disorder. This course aims to cover causes, symptoms, treatments and risk factors.

Dysphasia is a language disorder. This course aims to cover causes, symptoms, treatments and risk factors.

Dysphasia

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course covers the principles of GDPR.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(77, 81, 86); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(77, 81, 86);">Everyone responsible for using personal data has to follow strict rules called &#39;data protection principles&#39;.&nbsp;</span></p>

This course covers the principles of GDPR. 
Everyone responsible for using personal data has to follow strict rules called 'data protection principles'. 

Data Protection

GDPR

Data Protection Officer

Data Privacy

Data Protection Officer (DPO)

Certified in Data Protection (CDP)

General Data Protection Regulations  

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

Airtily

Drawing

Painting

Watercolour Painting

Creative Practice

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

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

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

Sunhouse

Tai Chi

Meditation

Breathing Techniques

THE ART OF BREATH - Qi-Gong & Breathwork 

Concession

Super Concession

Bournemouth

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



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

Travel the world and be paid for it

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

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


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

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

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

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

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

Receive constant updates on recruitment and news from Aviation the world

We will enhance your CV

Full support on your job application process

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

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

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








London Waterloo Academy

Flight Attendant

Stewardess

FLIGHT ATTENDANT VIRTUAL VIA ZOOM COURSE, EVENINGS

Registration Fee

Course Fee

Manchester

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

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

Manchester Wine School

Sommelier

ONLINE - WSET Level 2 Award in Wines - Evenings

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">A standalone 10-week course - 2 hours per week online with daytime and evening options - that will introduce you to the materials, tools, and techniques used in quilling and to Craft4Smiles C.I.C and our tutors. &nbsp; At the end of each session you will have a lovely quilled item to show family and friends or to display on your shelf! You will be told about the other courses we offer so that you can make an informed choice about further learning. Participants in this course often move on to our Introduction to Paper Craft and Mixed Media Course that will introduce you to the basic materials, tools, equipment and techniques used. Experience has shown us that participants for whom English is not their first language, have found that quilling has helped them improve their understanding and spoken English as there is a lot of repetition of basic terms including numbers, colours and directions. Working with someon for whom English is their first language is also helpful.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Programme</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 1: Basic Shapes (1)</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 2: Basic Shapes and Use of a Quilling Comb (2)&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 3: Flower and Butterfly: Picture 8&rdquo; x 10&rdquo;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 4: Making a Shape to Hold Quilled Pieces: Capital Letter</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 6: Basket of Flowers</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 7: Cherry Blossom Box</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 8: 2 x 5&rdquo; x 7&rdquo; Pictures: Duck and Boat</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 11: Pot of Lavender (1)&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Week 10: Pot of Lavender (2)</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You will receive all the materials and items of equipment needed to complete the course. These are yours to keep:&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Materials and Equipment</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong>Quilling Kit:&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Paper Strips: 39 mm: a variety of colours</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Paper Strips: 39 mm: white</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Board</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Needlemaker&#39;s Wheel of Pins</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Formers x 2&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Comb</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1 Pair Tweezers</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Pokey Tool</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Tool: Short</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quilling Tool: Long</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Scissors</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Glue Applicator</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Book Binders&rsquo; Glue 30 ml</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Black and white 300 gsm card for box and picture</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(65, 65, 65); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(65, 65, 65); font-size: 14px;">Craft4Smiles C.I.C. is crafting community that&nbsp;</span><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">provides accessible high quality creative papercraft and mixed media online programmes for adults. Our courses are social and interactive whether delivered online or in-person. Our aim is to introduce and build crafting skills and the basic skills needed for success in the workplace and at home, including self-confidence, problem solving, communicating in a group, basic maths and English. We teach over 45 different paper craft and mixed media techniques. Each course is carefully constructed to help you develop your crafting skills and knowledge. &nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;">Crafting and our courses are mindful, taking us away from the day-to-day. Participants have consistently reported improvements in their wellbeing. &nbsp;Anyone who wants to learn new skills can join our programmes. &nbsp;No previous experience of papercrafting or mixed media work is needed. We have delivered courses successfully in Cambridgeshire for 6 1/2 years and have worked with 280 Cambridges residents during this time. 86% of participants state that what we offer has helped to improve their wellbeing. 75% state that it has made a positive difference to their daily lives. &nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); font-size: 14px;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">Please note that the Cademy calenda/description states that this course is over 13 weeks. This is because the 10 weeks of the course are delivered over 13 weeks, during 3 of which, Craft4Smiles is closed for holidays!&nbsp;</span><br fr-original-style="" style="box-sizing: border-box;"></span></p>

A standalone 10-week course - 2 hours per week online with daytime and evening options - that will introduce you to the materials, tools, and techniques used in quilling and to Craft4Smiles C.I.C and our tutors. At the end of each session you will have a lovely quilled item to show family and friends or to display on your shelf! You will be told about the other courses we offer so that you can make an informed choice about further learning. Participants in this course often move on to our Introduction to Paper Craft and Mixed Media Course that will introduce you to the basic materials, tools, equipment and techniques used. Experience has shown us that participants for whom English is not their first language, have found that quilling has helped them improve their understanding and spoken English as there is a lot of repetition of basic terms including numbers, colours and directions. Working with someon for whom English is their first language is also helpful. 
Programme
Week 1: Basic Shapes (1)
Week 2: Basic Shapes and Use of a Quilling Comb (2) 
Week 3: Flower and Butterfly: Picture 8” x 10”
Week 4: Making a Shape to Hold Quilled Pieces: Capital Letter
Week 6: Basket of Flowers
Week 7: Cherry Blossom Box
Week 8: 2 x 5” x 7” Pictures: Duck and Boat
Week 11: Pot of Lavender (1) 
Week 10: Pot of Lavender (2)
You will receive all the materials and items of equipment needed to complete the course. These are yours to keep: 
Materials and Equipment
 Quilling Kit: 
Quilling Paper Strips: 39 mm: a variety of colours
Quilling Paper Strips: 39 mm: white
Quilling Board
Needlemaker's Wheel of Pins
Quilling Formers x 2 
Quilling Comb
1 Pair Tweezers
Pokey Tool
Quilling Tool: Short
Quilling Tool: Long
Scissors
Glue Applicator
Book Binders’ Glue 30 ml
Black and white 300 gsm card for box and picture
Craft4Smiles C.I.C. is crafting community that provides accessible high quality creative papercraft and mixed media online programmes for adults. Our courses are social and interactive whether delivered online or in-person. Our aim is to introduce and build crafting skills and the basic skills needed for success in the workplace and at home, including self-confidence, problem solving, communicating in a group, basic maths and English. We teach over 45 different paper craft and mixed media techniques. Each course is carefully constructed to help you develop your crafting skills and knowledge. 
Crafting and our courses are mindful, taking us away from the day-to-day. Participants have consistently reported improvements in their wellbeing. Anyone who wants to learn new skills can join our programmes. No previous experience of papercrafting or mixed media work is needed. We have delivered courses successfully in Cambridgeshire for 6 1/2 years and have worked with 280 Cambridges residents during this time. 86% of participants state that what we offer has helped to improve their wellbeing. 75% state that it has made a positive difference to their daily lives. 
Please note that the Cademy calenda/description states that this course is over 13 weeks. This is because the 10 weeks of the course are delivered over 13 weeks, during 3 of which, Craft4Smiles is closed for holidays! 


Craft4Smiles C.I.C. 

A standalone 10-week quilling course - 2 hours per week online with daytime and evening options - that will introduce you to the materials, tools, and techniques used in quilling and to Craft4Smiles C.I.C and our tutors.   At the end of each session you will have a lovely quilled item to show family and friends or to display on your shelf!  All materials and equipment needed will be supplied and are yours to keep. This course is helpful for those for whom English is not their native tongue as there is a lot of repetition of basic terms including numbers, colours and directions.  

Quilling - Monday 19.00 - 21.00 or Tuesday 19.00 - 21.00


Craft4Smiles Cademy Launch

<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 id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you a stressed, exhausted SEN/EBSA parent or carer, running on empty, with no time to shout <em fr-original-style="" style="box-sizing: border-box;">"HELP!"&nbsp;</em>let alone step off the hamster wheel to rest, recharge and recuperate?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Parenting neurodivergent and/or school avoidant young people comes with a unique set of challenges and, if you&#39;re finding yourself lurching from managing meltdowns to fighting for support or feeling isolated and judged because people don&#39;t understand, it can be really hard and I GET IT!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">After finding myself pretty much burnt out I discovered and implemented quick and simple self-help and relaxation tools that have helped strengthen my coping skills to navigate my family&#39;s journey, rebuild my resilience and rediscover&nbsp;my old self!&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">I was so blown away by how beneficial simple habits can be that it&#39;s my mission to help others do the same - and so I created&nbsp;The SHARE Project.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The ethos of THE SHARE Project is that&nbsp;we need to put our own oxygen mask on first&nbsp;so that we can&nbsp;best support our kids&nbsp;and my aim is that the tools you will learn during our time together will become your oxygen mask, not only for use in case of emergency, but as a sustainable part of your ongoing&nbsp;self-care and wellbeing.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">During each&nbsp;of four, weekly, live&nbsp;online workshops, delivered over Zoom, you will learn and practise a new tool to implement daily over the coming week (just a&nbsp;few minutes at a time, I promise)!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Then, during the following week&#39;s workshop we will review your progress, make any tweaks and learn and practise the next tool...&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">There&#39;ll be no suggestions of long and luxurious spa days and fluffy robes because most of us don&#39;t have the time to do that very often and, frankly, the benefits disappear almost as soon as you&#39;ve driven home... My mission<em fr-original-style="" style="box-sizing: border-box;">&nbsp;</em>is to give you sustainable tools to use anytime and anywhere to help yourself cope better and feel happier, regardless of what&#39;s going on around you!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Each group session gives you the opportunity to connect with other SEN parents or carers&nbsp;experiencing similar challenges.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What our clients say:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">"</span></em><span style="color: rgb(32, 33, 36); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(32, 33, 36);"><em fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">The Share project was a gentle, kind experience which showed understanding for parenting with additional challenges. &nbsp;The refocusing was extremely powerful and I felt nurtured by the sessions."</span></em></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(32, 33, 36); box-sizing: border-box;" fr-original-style=" color: rgb(32, 33, 36);"><em fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span data-sheets-root="1" id="isPasted" fr-original-style="" style="box-sizing: border-box;">"I gained different techniques to build resilience and overcome overwhelm."&nbsp;</span><br fr-original-style="" style="box-sizing: border-box;"></span></em></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(32, 33, 36); box-sizing: border-box;" fr-original-style=" color: rgb(32, 33, 36);"><em fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span data-sheets-root="1" fr-original-style="" style="box-sizing: border-box;"><span data-sheets-root="1" style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span data-sheets-root="1" id="isPasted" fr-original-style="" style="box-sizing: border-box;">"has helped me have a more positive outlook day to day, relaxation has helped with my sleep"</span></span><span data-sheets-root="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></span></span></em></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">If you have any questions, please ask and I will be happy to help :)</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Sue&nbsp;</p>

Overcome Overwhelm and Increase Calm with The SHARE Project 🌟
Are you feeling exhausted, overwhelmed and stretched to your limit?  With meetings and meltdowns to manage, battles for support, the frustration of feeling isolated or misunderstood, not to mention the pressure of juggling your job too, it can It can feel like you’re running on empty; hard to find a moment to step off the hamster wheel and just breathe.
I’ve been there, and I get it!💛
After being on the brink of burnout myself, I stumbled upon simple, yet impactful self-help, self-care and relaxation tools. These quick, effective techniques helped me rebuild my strength, reclaim my sense of self and navigate challenges with renewed stamina and joy.  And that’s how The SHARE Project was born.
What is The SHARE Project?
The SHARE Project is built on a simple principle: you need to put your own oxygen mask on first!  By nurturing yourself, you’re better equipped to support your children. Through our three, weekly, set of live online workshops, delivered via Zoom, you’ll discover practical tools to bring more calm and happiness into your daily life.
Here’s what you can expect:
Weekly Workshops:  Each week, we’ll introduce and practice one or two tools designed to fit seamlessly into your life (in just a few minutes at a time, I promise!). These are not your typical “luxury spa day” suggestions — because let’s face it, who has time for that?  Instead, you’ll learn sustainable, go-to strategies that you can use anytime, anywhere, to boost your wellbeing, even in the midst of chaos.  You will also receive a mid-week email of encouragement between workshops and printables to help record and track your progress.
Ongoing Support:  In each session, we’ll review your progress, fine-tune your approach, if needed, and introduce the next tool.  
Community Connection: You’ll be part of a supportive group of fellow SEN parents and carers who understand the unique challenges you face.  
What our clients say:
“The SHARE Project was a gentle, kind experience which showed understanding for parenting with additional challenges.  The refocusing was extremely powerful and I felt nurtured by the sessions.”
“It has helped me to have a more positive outlook day-to-day, and the relaxation has helped with my sleep.”	
“I looked forward to the sessions each week, they gave me time to focus on myself for a change.”
Ready to Feel More Calm and Happy?
If you’re ready to step off the hamster wheel and start reclaiming your joy, The SHARE Project is here for you. Let’s work together to help you feel stronger, more at peace and, most importantly, more you.
If you have any questions, please send me a message and I’ll be happy to help! 😊
With love and support,  
Sue

AUsomeMums

Emotional Resilience

Autism

Mental Resilience

Special Education Needs (SEN)

Self-help and relaxation skills and exercises for stressed, burned out SEN parents and carers

The SHARE Project - Self-Help & Relaxation Exercises for SEN/EBSA Parent Carers (click for dates)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The primary audience for this course is any IT, facilities or data centre professional who works in and around the data centre and has the responsibility to achieve and improve efficiency and environmental sustainability, whilst maintaining the availability and manageability of the data centre.</p>Overview<p>After completion of the course the participant will be able to:<br />Understand the impact of data centres on the environment<br />Describe the various environmental/energy management standards<br />Understand the purpose and goals of the legally binding international treaties on climate change<br />Implement various sustainable performance metrics and how to use them in the data centre environment<br />Manage data centre environmental sustainability using international standards<br />Set up the measurement, monitoring and reporting of energy usage<br />Use power efficiency indicators in a variety of data centre designs<br />Use best practices for energy savings in the electrical infrastructure and in the mechanical (cooling) infrastructure<br />Use best practices for energy savings for the ICT equipment and data storage<br />Understand the importance of water management and waste management<br />Understand the different ways to use sustainable energy in the data centre<br />Get practical tips and innovative ideas to make a data centre more sustainable</p><p>The CDESSÂ© course is aimed at providing knowledge of the standards and guidelines related to environmental sustainability, and how to move your data centre (existing or new) to a more environmentally sustainable design and operations.</p></div><div id="course-pills-2"><h4>Impact of Data Centres on the Environment</h4><ul><li>Predictions in 2010</li><li>Current situation</li><li>Outlook and commitments</li></ul><h4>What is Environmental Sustainability</h4><ul><li>The importance of sustainability</li><li>Senior management commitment</li><li>Environmental sustainability framework</li><li>Sustainability policies</li><li>Performance standards and metrics</li><li>Information policies</li><li>Transparency</li><li>Awareness</li><li>Service charging models</li></ul><h4>Environmental Management</h4><ul><li>Environmental sustainability framework (ISO 14001)</li><li>Standards and guidelines ? ISO 50001 / ISO 30134</li><li>Measurement and categories</li><li>Baselining</li><li>Trend analysis</li><li>Reporting</li></ul><h4>Power EffiÃ°ciency Indicators</h4><ul><li>Various eÃ°fficiency indicators</li><li>Power Usage Effectiveness (PUE)</li><li>PUE measurement levels</li><li>Factors affecting PUE</li><li>Measurement points and intervals</li><li>PUE in mixed source environments</li><li>Measuring PUE in a mixed-use building</li><li>PUE reporting</li><li>Impact of PUE after optimising IT load</li></ul><h4>Electrical Energy Savings (Electrical)</h4><ul><li>Identifying the starting point for saving energy</li><li>Sizing of power</li><li>DC power</li><li>Generators</li><li>UPS systems</li><li>Power Factor (PF)</li><li>Energy savings on lighting</li></ul><h4>Electrical Energy Savings (Mechanical)</h4><ul><li>Energy savings on the cooling infrastructure</li><li>Temperature and humidity setpoints</li><li>Various energy eÃ°cient cooling technologies</li><li>Energy savings on the airflow</li><li>Liquid cooling</li><li>Energy reusage</li><li>PUE, ERE/ERF and Control Volume</li></ul><h4>Electrical Energy Savings (ICT)</h4><ul><li>Procurement</li><li>IT equipment energy eÃ°fficiency</li><li>ITEEsv, SMPE, SMPO</li><li>IT equipment utilisation</li><li>Server virtualisation</li><li>Open compute project</li></ul><h4>Electrical Energy Savings (Data Storage)</h4><ul><li>Data management</li><li>Data storage management</li><li>Data storage equipment effiÃ°ciency</li></ul><h4>Water Management</h4><ul><li>Water Usage Effectiveness (WUE)</li><li>Improving WUE</li><li>Water usage at the power generation source</li><li>Energy Water Intensity Factor (EWIF)</li></ul><h4>Waste Management</h4><ul><li>Waste management policies</li><li>Life-cycle assessment (Cradle to the grave)</li><li>3 R?s for waste management</li><li>Reduce</li><li>Reuse</li><li>Second-hand market</li><li>Recycle</li></ul><h4>Sustainable Energy Usage</h4><ul><li>Sustainable energy sources</li><li>Power purchase agreements</li><li>Energy attribute certificates</li><li>Renewable Energy Factor (REF)</li><li>Matching renewable energy supply and demand</li><li>Sustainable energy storage</li><li>Carbon trading</li></ul><h4>Automated Environmental Management Systems</h4><ul><li>Use of AI and machine learning</li><li>Load migration</li><li>Data Centre Infrastructure Management (DCIM) solutions</li></ul></div>

Duration
5 Days
30 CPD hours
This course is intended for
The primary audience for this course is any IT, facilities or data centre professional who works in and around the data centre and has the responsibility to achieve and improve efficiency and environmental sustainability, whilst maintaining the availability and manageability of the data centre.
Overview
After completion of the course the participant will be able to:
Understand the impact of data centres on the environment
Describe the various environmental/energy management standards
Understand the purpose and goals of the legally binding international treaties on climate change
Implement various sustainable performance metrics and how to use them in the data centre environment
Manage data centre environmental sustainability using international standards
Set up the measurement, monitoring and reporting of energy usage
Use power efficiency indicators in a variety of data centre designs
Use best practices for energy savings in the electrical infrastructure and in the mechanical (cooling) infrastructure
Use best practices for energy savings for the ICT equipment and data storage
Understand the importance of water management and waste management
Understand the different ways to use sustainable energy in the data centre
Get practical tips and innovative ideas to make a data centre more sustainable
The CDESSÂ© course is aimed at providing knowledge of the standards and guidelines related to environmental sustainability, and how to move your data centre (existing or new) to a more environmentally sustainable design and operations.
Impact of Data Centres on the Environment
Predictions in 2010
Current situation
Outlook and commitments
What is Environmental Sustainability
The importance of sustainability
Senior management commitment
Environmental sustainability framework
Sustainability policies
Performance standards and metrics
Information policies
Transparency
Awareness
Service charging models
Environmental Management
Environmental sustainability framework (ISO 14001)
Standards and guidelines ? ISO 50001 / ISO 30134
Measurement and categories
Baselining
Trend analysis
Reporting
Power EffiÃ°ciency Indicators
Various eÃ°fficiency indicators
Power Usage Effectiveness (PUE)
PUE measurement levels
Factors affecting PUE
Measurement points and intervals
PUE in mixed source environments
Measuring PUE in a mixed-use building
PUE reporting
Impact of PUE after optimising IT load
Electrical Energy Savings (Electrical)
Identifying the starting point for saving energy
Sizing of power
DC power
Generators
UPS systems
Power Factor (PF)
Energy savings on lighting
Electrical Energy Savings (Mechanical)
Energy savings on the cooling infrastructure
Temperature and humidity setpoints
Various energy eÃ°cient cooling technologies
Energy savings on the airflow
Liquid cooling
Energy reusage
PUE, ERE/ERF and Control Volume
Electrical Energy Savings (ICT)
Procurement
IT equipment energy eÃ°fficiency
ITEEsv, SMPE, SMPO
IT equipment utilisation
Server virtualisation
Open compute project
Electrical Energy Savings (Data Storage)
Data management
Data storage management
Data storage equipment effiÃ°ciency
Water Management
Water Usage Effectiveness (WUE)
Improving WUE
Water usage at the power generation source
Energy Water Intensity Factor (EWIF)
Waste Management
Waste management policies
Life-cycle assessment (Cradle to the grave)
3 R?s for waste management
Reduce
Reuse
Second-hand market
Recycle
Sustainable Energy Usage
Sustainable energy sources
Power purchase agreements
Energy attribute certificates
Renewable Energy Factor (REF)
Matching renewable energy supply and demand
Sustainable energy storage
Carbon trading
Automated Environmental Management Systems
Use of AI and machine learning
Load migration
Data Centre Infrastructure Management (DCIM) solutions

Nexus Human

Environmental Management System

Leadership in Energy & Environmental Design (LEED)

Certified Energy Manager (CEM)

Service Design Courses (SDC)

Energy Management

Certified Data Centre Environmental Sustainability Specialist (CDESS)

London

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

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

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

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

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

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

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

Session 6:

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

Session 7:

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

Session 8:

SQL Views: Create, alter and drop Views

Session 9:

Inserting rows,
Replacing rows,
Updating rows,
Deleting rows

Session 10:

Session 10: Managing indexes

Session 11:

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

Session 12:

Import data into SQL and Export from SQL

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

PCWorkshops

Database Design & Development

Oracle SQL

Database Programming

Database Administration

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

Oracle SQL Fundamentals, 3 Days

General admission

<div style="color: rgb(88, 89, 91); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(88, 89, 91);"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Course Information</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">This course offers foundational guidance and practical support tailored for individuals operating within Good Manufacturing Practice (GMP) frameworks.</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Explore the fundamental prerequisites of a pharmaceutical quality system (PQS) and delve into the application of quality risk management (QRM) principles, aligning with current regulations and guidance. Gain insights into pivotal aspects such as requirements, roles, and responsibilities, encompassing change control, document management, and key documentation essential for effective implementation of GMP with a focus on regulatory inspections and common findings.</p><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Is this course for you?</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Ideal for professionals engaged in GMP across various sectors, including:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Research and Development (R&amp;D)</li><li fr-original-style="" style="box-sizing: border-box;">Contract Manufacturing Organisations</li><li fr-original-style="" style="box-sizing: border-box;">Manufacturing Units</li><li fr-original-style="" style="box-sizing: border-box;">Quality Control (QC) Laboratories</li><li fr-original-style="" style="box-sizing: border-box;">Auditing Roles.</li></ul><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">What will you learn?</h2><h3 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Event objectives - &nbsp;by the end of the course, delegates shall:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Have an awareness of the basic requirements of GMP</li><li fr-original-style="" style="box-sizing: border-box;">Be aware of UK and EU GMP Rules and Guidance and relevant publications</li><li fr-original-style="" style="box-sizing: border-box;">Understand the roles and responsibilities associated with GMP</li><li fr-original-style="" style="box-sizing: border-box;">Be able to contribute to and maintain quality documentation</li><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of product lifecycle and manufacturing</li><li fr-original-style="" style="box-sizing: border-box;">Understand the requirements of GMP in the QC laboratory context</li><li fr-original-style="" style="box-sizing: border-box;">Have a basic understanding of risk management and mitigation principles</li><li fr-original-style="" style="box-sizing: border-box;">Understand the need for quality systems and quality assurance activities</li><li fr-original-style="" style="box-sizing: border-box;">Be aware of common regulatory findings.</li></ul><h3 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Learning outcomes: delegates will be able to:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Implement their role within GMP with confidence and knowledge of the principle requirements</li><li fr-original-style="" style="box-sizing: border-box;">Contribute effectively to the GMP quality system and their organisation&rsquo;s compliance</li><li fr-original-style="" style="box-sizing: border-box;">Comprehend where their organisation&rsquo;s activities sit within the larger GMP arena</li><li fr-original-style="" style="box-sizing: border-box;">Know where to seek further information within the published rules and guidance, UK Legislation, European Commission Directives, ICH Guidance and other relevant publications, as well as via the internet.</li></ul></div><div style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);"><br fr-original-style="" style="box-sizing: border-box;"></h2><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Tutors</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Tutors will be comprised of (click the photos for biographies):</p><img src="https://www.therqa.com/assets/tutors/17_eyd9QXJ.png" alt="Louise Handy" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"><h3 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Louise Handy</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Director, Handy Consulting Ltd</p><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Programme</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Please note timings may be subject to alteration.</p><h3 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);"><br fr-original-style="" style="box-sizing: border-box;"></h3><h3 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Day 1</h3><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">09:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Introductions and Scope of the Course</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Understand the group requirements and the tutor&#39;s background and experience.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">09:45</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Background and Regulatory Environment</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Setting the scene, understanding the context, key legislation.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">10:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Principles of GMP</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Key points and requirements.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">11:15</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Break</h4><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">11:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Personnel and Responsibilities</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Management and staff, duties and accountabilities.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">12:00</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Overview of GMP Manufacturing</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Basics of the product life cycle.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">12:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Lunch</h4><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">13:15</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Risk Management Workshop</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Practical exploration of risk and mitigation activities.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">14:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">QC Laboratories</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Activities and practicalities.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">15:15</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Break</h4><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">15:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Compliance</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Quality Assurance and Self Inspection.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">16:15</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Question Time</h4><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">A chance for questions on the practicalities of GMP.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">16:30</h3><h4 style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);">Close of Course</h4></div><div style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);"><br fr-original-style="" style="box-sizing: border-box;"></h2><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h2 style="color: rgb(0, 73, 144); box-sizing: border-box;" fr-original-style=" color: rgb(0, 73, 144);">Extra Information</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><ul data-tabs="op6z13-tabs" fr-original-style="" style="box-sizing: border-box;"></ul><div data-tabs-content="example-tabs" style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">Course Material</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Please note this course will run in UK timezone.</p><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">The advantages of this include:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Ability for delegates to keep material on a mobile device</li><li fr-original-style="" style="box-sizing: border-box;">Ability to review material at any time pre and post course</li><li fr-original-style="" style="box-sizing: border-box;">Environmental benefits &ndash; less paper being used per course Access to an online course group to enhance networking.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">You will need a stable internet connection, a microphone and a webcam.</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p></div></div><div style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">CPD Points</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">7 Points</p></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style="color: rgb(88, 89, 91);">&nbsp;</span></p><div style="color: rgb(88, 89, 91); box-sizing: border-box;" fr-original-style=" color: rgb(88, 89, 91);"><h3 style="color: rgb(0, 164, 177); box-sizing: border-box;" fr-original-style=" color: rgb(0, 164, 177);">Development Level</h3><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Learn</p></div>

Course Information
This course offers foundational guidance and practical support tailored for individuals operating within Good Manufacturing Practice (GMP) frameworks.
Explore the fundamental prerequisites of a pharmaceutical quality system (PQS) and delve into the application of quality risk management (QRM) principles, aligning with current regulations and guidance. Gain insights into pivotal aspects such as requirements, roles, and responsibilities, encompassing change control, document management, and key documentation essential for effective implementation of GMP with a focus on regulatory inspections and common findings.
Is this course for you?
Ideal for professionals engaged in GMP across various sectors, including:
Research and Development (R&D)
Contract Manufacturing Organisations
Manufacturing Units
Quality Control (QC) Laboratories
Auditing Roles.
What will you learn?
Event objectives - by the end of the course, delegates shall:
Have an awareness of the basic requirements of GMP
Be aware of UK and EU GMP Rules and Guidance and relevant publications
Understand the roles and responsibilities associated with GMP
Be able to contribute to and maintain quality documentation
Have a basic understanding of product lifecycle and manufacturing
Understand the requirements of GMP in the QC laboratory context
Have a basic understanding of risk management and mitigation principles
Understand the need for quality systems and quality assurance activities
Be aware of common regulatory findings.
Learning outcomes: delegates will be able to:
Implement their role within GMP with confidence and knowledge of the principle requirements
Contribute effectively to the GMP quality system and their organisation’s compliance
Comprehend where their organisation’s activities sit within the larger GMP arena
Know where to seek further information within the published rules and guidance, UK Legislation, European Commission Directives, ICH Guidance and other relevant publications, as well as via the internet.





Tutors
Tutors will be comprised of (click the photos for biographies):

Louise Handy
Director, Handy Consulting Ltd



Programme
Please note timings may be subject to alteration.


Day 1
09:30
Introductions and Scope of the Course
Understand the group requirements and the tutor's background and experience.
09:45
Background and Regulatory Environment
Setting the scene, understanding the context, key legislation.
10:30
Principles of GMP
Key points and requirements.
11:15
Break
11:30
Personnel and Responsibilities
Management and staff, duties and accountabilities.
12:00
Overview of GMP Manufacturing
Basics of the product life cycle.
12:30
Lunch
13:15
Risk Management Workshop
Practical exploration of risk and mitigation activities.
14:30
QC Laboratories
Activities and practicalities.
15:15
Break
15:30
Compliance
Quality Assurance and Self Inspection.
16:15
Question Time
A chance for questions on the practicalities of GMP.
16:30
Close of Course





Extra Information


Course Material


This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event.
Please note this course will run in UK timezone.
The advantages of this include:
Ability for delegates to keep material on a mobile device
Ability to review material at any time pre and post course
Environmental benefits – less paper being used per course Access to an online course group to enhance networking.

You will need a stable internet connection, a microphone and a webcam.


CPD Points
7 Points
 
Development Level
Learn

2509 Courses in Coventry

Dementia Training

By Magpie Training

Mental Health Awareness

By Magpie Training

Safe Handling of Medication

By Magpie Training

Moving and assisting

By Magpie Training

Behaviours that challenge, Promoting Positive Behaviour

By Magpie Training

Skin Integrity

By Magpie Training

Oral Health And Hygiene

By Magpie Training

Personal Care And Bathing

By Magpie Training

Dysphasia

By Magpie Training

General Data Protection Regulations

By Magpie Training

Search By Location