145 Educators providing ETC courses in London

Learn to make on-trend garments, develop your sewing & pattern cutting skills, whilst getting into the mind of a designer. We have a range of compelling and sustainable workshops taught by expert tutors and industry professionals.

This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements. Hands-on, Practical SQL course. You will get the PCWorkshops SQL Course Certificate. Max 4 people per course, to keep it personalised.

MASTERCLASS: LEARN PROFESSIONAL LEATHER CRAFT, SEWING AND LEATHERGOODS CONSTRUCTION SKILLS One teacher, five students KEY FEATURES OF THIS COURSE:– Understanding and working with leather– Learning leather hand sewing– Learning leather machine sewing– Realising samples of bag features– Realising two finished leather items Experience a comprehensive two-week Leather Craft and Sewing Masterclass, merging theory with hands-on learning Explore essential techniques for working with leather, vegan alternatives, and fabric. Proficiently handle hand tools, master hand-sewing, and operate industrial machines. Cover material selection, finishing and construction methods.Gain insights into the technical aspects of leatherworking, including preparation, marking, cutting, gluing, reinforcing, skiving, debossing, and more.Participants receive thorough instruction in professional sewing techniques on diverse industrial machines, along with specialised saddle stitching training. Create personalised samples to enhance practical skills.Conclude the masterclass with the ability to craft entirely handmade simple leather items, showcasing acquired skills in both machine-stitched and saddle-stitched styles.Facilitated by a prototype maker and manufacturer, the course offers a professional journey into common leatherworking practices.Participants also receive valuable handouts and curated lists of leather and tool suppliers for ongoing reference.   Here is a concise summary of the topics covered during the classes: LEATHER, VEGAN LEATHER, AND HAND TOOLS:Understanding leather types, tanning, finishings and best useExploring different types of vegan leathers and their featuresComparing leather and vegan leather: pros and cons from a manufacturer’s perspectiveImportance of choosing the right materials and tools for projectsLeather preparation, pattern placement and markingCutting complex shapes with various toolsUsing leather punches, skiving, beveling and creasingFinishing leather edges: painting vs. burnishingUtilising leather glues, tapes and reinforcementsExploration of prototyping and manufacturing leather goods, encompassing varied working methods, machines, and tools.   MACHINE AND HAND SEWING:Understanding industrial sewing machines and their differencesSelecting the right sewing machine for specific materials and constructionsOperating a lock stitch walking foot machineThreading industrial sewing machinesAchieving correct tension in sewingUnderstanding thread types and needle sizesLearning to sew leather, distinguishing it from other materialsCorrectly sewing various leather types, ranging from thin to very thickSewing straight lines, curves and creating parallel seamsProducing various seams and seam finishesBasics of saddle stitching leather and understanding related tools and materials   CONSTRUCTION TECHNIQUES:Sewing and finishing a simple zip on leatherCutting, assembling and sewing simple straps/handlesIncorporating basic lining types in projectsConstructing and sewing common gussetsComprehending the use of reinforcements and stabilisers and their application in the craft of accessory making   LEATHER GOODS MAKING:Creating two finalised leather items from chosen designs such as card holders, purses, clutches, glass covers and similar accessories.# By the end of the tuition, you will have:– Developed confidence in utilising specific tools for leather preparation, marking, finishing, cutting and fastening fittings.– Acquired an understanding of working with diverse leather types and thicknesses, with the ability to source and select appropriate tools and materials for your projects.– Mastered essential leather sewing techniques, troubleshooting common sewing issues and handling challenges such as curves, multiple layers of leather and various surface textures.– Learned to sew fundamental bag components like simple zips, straps, and gussets, along with reinforcing specific areas of a bag.– Built confidence in sewing with both industrial machines and by hand, gaining the skills to independently create simple leather items. Included in the course:You will be provided with useful paper handouts which contain:– A list of tools and materials used during the lesson(s), including a description of what they are and how they are used– A list of recommended suppliers for both leather and fittings (physically in London and online)– A glossary containing essential key words related to the topic of the lesson– A glossary containing information about leather types and characteristics– A glossary containing information about needle and thread types   What are the entry requirements? This course is suitable for total beginners, beginners with some experience and intermediate.You should be able to use measurements and understand verbal and written English instructions.   Are there any other costs? Materials are included.   Is there anything I need to bring? Feel free to bring a notepad, if you would like to take some notes, we will provide the rest.   How long is this tuition? This tuition will require two consecutive weeks / 50 hours to be completed.We aim to provide customised and high quality tuition services and by only allowing up to 5 students at a time, we are able to focus on each person needs and interests.   IMPORTANT TO KNOW: We aim to cover as much of the syllabus as possible. Depending on your ability and prior experience, we may not complete the entire program or we might delve into additional techniques related to the listed topics, including:Advanced finishing techniques (piping, binding, folding)More complex styles of zipsUtilising different machine feet, tools, and equipment in your sewingExploring various fittings, closure types, fastening techniques, and tools (sam browns, magnets, pop buttons, eyelets, etc.)Understanding the importance and application of construction sequences and reference notes during item construction

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

Course Introduction Our Venepuncture and Phlebotomy training equips delegates with the skills and knowledge needed to take blood safely. Please note: this course is for health care professionals and nurses only. About this event Applicable to Nurses, Health Care Assistants and Phlebotomists in primary care, the community, hospitals or nursing homes, this course is interactive and involves a demonstration session on performing blood tests. Our venepuncture training will give delegates the theoretical and practical awareness to undertake a competence assessment framework in the workplace that will deem them competent to take blood safely and appropriately. Each delegate will receive a competence-based framework to allow them to do this. Course Aims Identify and describe equipment used for routine venepuncture Be able to assess and select suitable sites used for venepuncture as well as locations to avoid Describe and utilize the required steps to perform routine venepuncture Describe actions that ensure safety during performance of a venepuncture Identify suitable vein selection and identify factors influencing this Understand relevant professional and legal issues Be able to identify potential complications Understand anatomy and physiology and correct vein selection Be familiar with equipment and exercise choice in using most appropriate equipment Practice safely in terms of infection control and waste management Become skilled and competent at phlebotomy To recognise any complications arising and be able to take the appropriate action Course Content Background and importance of training and competence Supervision and practice Scope and responsibilities Accountability Professional and legal issues Consent and capacity What is phlebotomy? Tools of the trade-equipment Needles and patient safety Blood collection systems and devices Syringes and when to use them Blood collection tubes Labelling Anatomy and physiology Vein Selection: - Identification of Veins - Arm Veins - Hand Veins Vein assessment Unacceptable sites for venous collection Venepuncture procedure Attempts Order of Fill Specimen collection procedures Specimen handling post-phlebotomy Personal protective equipment Needle stick injuries Legislation-EU Directives Disposal Needle phobias Dealing with anxiety/fainting etc. Practical session Potential Complications (including infection control) Practical Application - techniques and troubleshooting Case scenarios Troubleshooting Audit Who should attend / would be applicable? Nurses HCAs Those interested in careers as Phlebotomists AB Health Group awards CPD points / certificate of attendance for each course. If you would prefer an accredited certificate by our accrediting body Aim Qualifications we can organise this. The charge for the certificate including postage is £30.00. Annie Barr AB Health Group Organiser Description Annie Barr is a leading provider of high quality, accredited healthcare training. With a selection of engaging healthcare training that has been developed by experts to equip you and your workforce with the skills, knowledge and competence needed to provide compassionate and high quality care.

This course covers the essential Excel data skills. Our course is interactive, instructor-led. This Excel Data course is on offered on intermediate level of Excel and concentrates on the Data Analytical capabilities of Excel. These concepts are daily used by data analysts and is a basic essential skill for data professionals. By the end, you'll be able to use Excel for analytics, data summaries, trends and statistics. You will create Excel data analytical spreadsheets and samples that you can use as examples at work.

Learn the popular Night Club Style Salsa aka Salsa On2/Mambo with Funky Mambo! Every Tuesday. No partner, no pre-experience required. 😊

Excel Intermediate Course, 1-Day. This course covers the essential Excel Intermediate, in our interactive, instructor led Live Virtual Classroom. You already know your way around Excel e.g. you understand some of the functionality on the Home Ribbons, can move around and format cells. etc. In the Excel intermediate course we cover in-depth functions and Formulae so that you will be able to create fantastic spreadsheets like budgets, forecasts, and more. You will be able to understand and unravel the complicated formulae created by your colleagues. During the course you will excellent spreadsheets so that you have examples to take away. Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Intermediate Certification Hours: 1 Day, 10am-5pm Excel Intermediate Course, Course Outline. Working with Functions and Formulas The Function Wizard Using Functions in Excel: The 5 Popular functions If-else function Working with Names and Ranges Copying formulae Creating Formulae in Excel, general calculations. Lookups: Vlookup, Hlookup, Index, Match. Formatting a Range as a Table: Properties and behaviour of a table. Managing Tables: Working with Tables. Working with Tables: Working with Records and Fields. Filters and Sorting, Freeze panes, split, protecting and unprotecting. Using Excel as a Database: Advanced filter: copy only specified rows and columns from a large data set, auto mate this selective copy. Pivot-tables: Create Pivot Table, Refresh Data. Amend, Filter, Sort, Format Pivot Tables, Add additional Pivot formulae. Pivot Charts: Excel Pivot Charts and Sparklines. Examples and exercises with Pivot Charts and Sparklines. Other Excel Courses Inlcuded with the Excel Intermediate Course PCWorkshops Excel Intermediate Certificate on completion Excel Intermediate Notes Excel Code Examples Practical Excel Intermediate exercises Personal attention in a small group of up to 4 delegates Book the Excel Intermediate Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

PYTHON BOOTCAMP: This 12-week Python Data Analytics Data Boot Camp is designed to give you a complete skill set required by data analysts . You will be fully fluent and confident as a Python data analyst, with full understanding of Python Programming. From Data, databases, datasets, importing, cleaning, transforming, analysing to visualisation and creating awesome dashboards The course is a practical, instructor-lead program.

Dashboards will summarize and present the key indications of large data in an attractive visual display, hightlighting the most important trends so the most imporatnf aspects of data could could be seen in a snap second by glancing at attractive, colourful charts. PowerPivot helps analyze the data and brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data. Power Pivot help analyze and understand the growing quantities of data that are created on a daily basis.