60228 Courses

Join Mark on Thursday mornings to move, explore, and wake up to your true nature. Mark's classes are all about re-connecting the body and mind in order to find a sense of health, integration, freedom and kindness. Most of the time his classes are based around the seasons, since the Chinese energy system is very connected to the time of year and changing seasons.

CPD Accredited, Interactive Workshop * 2 hr session * Learn all about the Five Steps to Mental Wellbeing and how they could be applied into your life * Learn from the comfort of your own home Course Contents: * Introduction to the Five Steps to Mental Wellbeing * The Science Behind the Five Steps * Learn about the Five Steps themselves and how to apply them into our own life  * - Connect * - Be Active * - Keep learning * - Give to others * - Be mindful BENEFITS OF THIS SHORT COURSE: * People's wellbeing have been under great strain. * Stressful lives lead to people suffering from mental health problems. * The Five Steps to Mental Wellbeing are a scientifically proven method of improving one's mental wellbeing, and increasing one's general emotional resilience * In this Five Steps to Mental Wellbeing workshop, we'll show you what you can do to improve your own mental wellbeing and resilience, and can help you help others do the same!

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - INTRODUCTION TO TRANSACT-SQL * Work with schemas * Explore the structure of SQL statements * Examine the SELECT statement * Work with data types * Handle NULLs 2 - SORT AND FILTER RESULTS IN T-SQL * Sort your results * Limit the sorted results * Page results * Remove duplicates * Filter data with predicates 3 - COMBINE MULTIPLE TABLES WITH JOINS IN T-SQL * Understand joins concepts and syntax * Use inner joins * Use outer joins * Use cross joins * Use self joins 4 - WRITE SUBQUERIES IN T-SQL * Understand subqueries * Use scalar or multi-valued subqueries * Use self-contained or correlated subqueries 5 - USE BUILT-IN FUNCTIONS AND GROUP BY IN TRANSACT-SQL * Categorize built-in functions * Use scalar functions * Use ranking and rowset functions * Use aggregate functions * Summarize data with GROUP BY * Filter groups with HAVING 6 - MODIFY DATA WITH T-SQL * Insert data * Generate automatic values * Update data * Delete data * Merge data based on multiple tables ADDITIONAL COURSE DETAILS: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

QA LEVEL 3 AWARD IN PAEDIATRIC FIRST AID (RQF) -------------------------------------------------------------------------------- * Two day course * HSE highly recommends this course for those who work with children in a childcare setting * Being able to deal with peadiatric emergencies can make the difference between the life and death of children, and save them a lot of suffering -------------------------------------------------------------------------------- COURSE CONTENTS: * The Roles and Responsibilities of an Emergency Paediatric First Aider * Assessing an Emergency Situation * Accident Recording * Minor Injuries * Cuts, Grazes and Bruises * Minor Burns and Scalds * Managing an Unresponsive Infant and Child * Recovery Position Infant and Child * CPR Infant and Child * Safe Use of an AED (Automated External Defibrillator) * Choking * Anaphylaxis * Seizures * Wounds and Bleeding * Hypovolaemic Shock * Head, Neck and Back Injuries * Sprains, strains, dislocations and fractures * Meningitis * Asthma * Diabetes * Eye, Ear and Nose Conditions * Poisoning * Electric Shock * Bites and Stings * Hot and Cold Temperatures BENEFITS OF THIS COURSE: * Would you know what to do if you saw a child in need of First Aid? * Children are prone to minor injuries, but suffer from serious injuries also * In 2014, 2,269 children in the UK were so badly bitten by an animal they had to be admitted to hospital * More than 2 million children have accidents in the home for which they're taken to A&E - every year, with Under 5s accounting for 7% of all hospital emergency treatments * Being able to deal with peadiatric emergencies can make the difference between the life and death of children, and save them a lot of suffering.  * This QA Level 3 Award in Paediatric First Aid (RQF) qualification is ideal for: * - Parents/carers or family members who want to learn key paediatric first aid skills * - those who work with, or intend to work with children in a childcare setting as it is designed to fulfill Ofsted’s First Aid requirements for early years teachers, nursery workers and childminders (as defined within the Statutory Framework for the Early Years Foundation Stage (EYFS) 2014 and within the Child Care Register guide) * Childcare settings who are working towards Millie’s Mark * We also run a Paediatric Annual Refresher to keep those life-saving skills up to date -------------------------------------------------------------------------------- ACCREDITED, OFQUAL REGULATED QUALIFICATION: Our Paediatric First Aid at Work course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards [https://qualsafeawards.org/]. This means that you can be rest assured that your Paediatric First Aid certificate will fulfill the legal requirements. It is a very good way to make sure you and your employees are trained in First Aid for Children and Infants (babies). The Ofqual Register number for this course is 603/0785/7 --------------------------------------------------------------------------------

GUITAR BUILDING COURSE THE AIM The aim of this electric guitar building course is teach you how to assemble a Stratocaster, Telecaster or Jazzmaster style bolt-on-neck design electric guitar to a very high standard as well as gain understanding and knowledge in not only the assembly but also a good understanding of its inner workings and overall function. WHAT TO EXPECT In this electric guitar building course you’ll focus on making the most successful electric guitar of all time: the bolt-on-neck design. In almost any music store, these guitars outnumber others five-to-one. The course will cover Body & Neck assembly, Pickup Installation & Installation of all Electronics and the Professional Setting up of an Electric Guitar The course will commence daily at 09:30 with lectures & discussions on topics relating to each part of the guitar construction and then followed by the practical application of these topics under supervision, finishing at 17:30. The course and workshop located in Cross in Hand, East Sussex, designed for a maximum of 4 people per course enabling a very close learning experience. All Lutherie tools needed to complete the course are supplied. NO Experience necessary! UPON COMPLETION Upon completion of the build your own guitar course you will leave with a great Custom made Guitar! The end product will be a Custom Tele, Strat or Jazzmaster that You will have made and one that will give many standard models a run for their money in tone and feel. PERSONAL ATTENTION The course does have a set agenda but we often meander around topics and are happy to do so, most of us have had many different guitars and they nearly always have some curious tales and they are always good to discuss. BREAK DOWN OF GUITAR COURSE TOPICS BY DAY DAY 1 BODY & NECK Wood choice and body design play a large part in the tone of an electric guitar. If you were to play several solid body guitars unamplified you’ll notice distinct differences between various wood types. A solid body that sounds good acoustically generally will sound good amplified. We’ll discuss the different woods used to make electric guitars and the effect of different body styles on tone and sustain. Just as wood affects the body, when making a neck you have to pay attention to wood choice in order to have a good sounding guitar. The hardware that goes into making a great guitar also plays a large role, not only the quality in the parts but also their fitting. You will be instructed on how best to fit all the component parts with skill and accuracy enabling you to create a great custom made guitar.. Topics covered: Body & Neck styles Wood choices Neck joints Adjustable Truss Rods Fitting neck to body Scale lengths Tremolo Bridge placement (Incl Claw & Springs) Fretboard radius Machine head installation Preparing the Nut Slot Making & Cutting a Bone Nut (Requires working with the belt sander) All the hardware fitted to the guitar will be quality Japanese Gotoh vintage parts, these are particularly well made; tuners hold tune well and the Gotoh bridge is of very good quality, all of this goes together to make a great custom built guitar. DAY 2 ELECTRONICS & FRET DRESSING Once you’ve learnt why and how a great guitar goes together as well as practically applying the previous topics, you now learn to install the best pickups and wiring. For these custom built guitars we will be using Bare Knuckle Boot Camp pickups: very high quality pickups designed to suit our specifications of wood choice and body style. These pickups are hand wound in the UK and are widely regarded as the best pickups on the market today. Choose between Old Guard, True Grit or Brute Force. The key to having a great sounding electric is not just down to the Pickups but also the choice of components that go with it, often overlooked with most mass manufactured guitars, the guitar you make will have highest quality components and will subsequently sound great and work extremely well. Custom CTS Pots, Sprague Capacitor and a CRL (USA) switch as well as vintage cloth wiring all go together to make a very well appointed loaded scratchplate! Topics covered: Schematics Pickup installation Wiring volume & tone pots Wiring 5 way selector switch Wiring output jack Bridge and string grounding Fret Dressing both Theory & Practise DAY 3 FINAL ASSEMBLY The guitar will now be ready for final assembly. Today you will learn how to fully assemble and set up your electric guitar to a professional standard. The topics covered will be very useful for your regular maintenance of the guitar you have made as well as any others that you may have. Topics covered: Professional Setups Theory Fitting and filing the Bone Nut Pickguard placement Installing strap buttons Installing Decals (Personalised custom Decals) Final Setting and fitting the neck Stringing up String tree placement Bridge set up Action height adjustment and setting Pick up height Intonation CUSTOMISING YOUR GUITAR BUILD INCLUSIVE FROM £999 We are more than happy to work with you in order to get the custom build you want, so please contact us if you have a specific body colour scheme or neck choice, which Bare Knuckle pickups you want as well as hardware and we will try help achieve exactly that. If you’re unsure what works best, just get in touch and we will advise where we can. ALL CUSTOM OPTIONS ARE SUBJECT TO AVAILABILITY AND IT IS ALWAYS BEST TO HAVE A 1ST & 2ND CHOICE, THERE ARE SOME COLOURS/PARTS ETC THAT MAY INCUR ADDITIONAL COST. TWEED HARD CASES ARE AVAILABLE FOR AN ADDITIONAL £75, £90 FOR THE JAZZMASTER. (SOFT GIG BAG INCLUDED) SOME ADDITIONAL CHARGES CAN APPLY FOR CUSTOM COLOURS OR SPECS OR IF YOU WOULD LIKE SPECIFIC MADE TO ORDER BARE KNUCKLE PICKUPS

A chance to learn amigurumi style of crochet to make yarn creatures.

Covering both fingers & toes application Suitable for: Complete beginners TIME: 10am - 5:30pm Models: 2 live model during training day What's covered: * Introduction to gel polish  * Health & safety & hygiene  * Skin analysis  * Nail Complications  * Nail Anatomy  * Check List * Contraindications  * Pre/post treatment advice  * Equipment and products  * Consultation  * Application  * Trouble shooting  * And so much more! Extra's * Basic business start up support  * Social media tips  * Follow up call to find out how your getting on and any questions you may have * Small groups (Max 4) * Ongoing support

Sacred Sound Journey Evenings at Brigstock Village Hall, Northamptonshire ~ a deep relaxation Gong Bath and Sound Bath experience with Edwin and Harshani of Mind Body Wellbeing

Who is this Highfield Level 3 Emergency First Aid at Work qualification for? This qualification is aimed at learners who wish to become emergency first-aiders in the workplace. This qualification meets the requirements for training emergency first-aiders in those organisations that have identified that staff need to be trained to this level within their first-aid needs assessment.

The Level 2 Award in Fire Safety is aimed at anyone who is involved in the management of fire safety or fire prevention in the workplace. This includes managers, supervisors, team leaders and fire marshals (or wardens).