433 Link courses in London

Python Data Analytics with Python using Numpy, Pandas, Dataframes. Most attendees are in-work Data Professional. Private individuals are very welcome. Our Style: Hands-on, Practical Location: Online, Instructor-led

Practical MySQL Course Intermediate, to leave you fully conversant with queries, DML and DDL statements. Hands-on, Practical MySQL Course Intermediate. PCWorkshops MySQL Course Intermediate Certificate. Max 4 people per course, we keep it personalised.

This one-day workshop is designed to build upon skills already acquired using Microsoft Word, whether participants are self-taught or have previously attended a course. It gives participants a good understanding of managing different types of paragraph indents, and managing automated numbered paragraph lists. This course will help participants: Create and manage the layout of paragraphs Create and manage multi-level numbered paragraphs Effectively insert, use and manage section breaks Create and manage columns Find, create and apply styles Create and update a table of contents from styles Work with styles to manage formatting Work with sums in tables and use table headings Input and edit text using AutoText Work with SmartArt graphics Link to other files using paste special 1 Managing paragraph layout Controlling paragraph layouts with indents Creating and managing paragraph hanging indents 2 Numbering paragraphs Creating a new multi-level numbered paragraph Managing existing multi-level numbered paragraphs 3 Inserting columns Creating columns from existing paragraphs Setting up columns Managing columns 4 Document section breaks Controlling document layout using section breaks Managing page orientation using section breaks Managing page numbering using section breaks 5 Using styles Applying quick styles Finding existing styles Creating and saving styles Modifying styles Creating a table of contents from styles Updating a table of contents 6 Using quick parts Saving content to quick parts Modifying saved quick parts Inserting content using AutoText Editing AutoText entries Inputting text using AutoCorrect 7 Advanced table features Sorting table columns Running sums in tables Repeating table headings at top of page Importing Excel content in tables Using table properties 8 Creating a mail merge Creating letters, labels and emails Merging addresses from external files Using Outlook's address book to merge Merging to email 9 SmartArt graphic Visually communicate content with SmartArt Choosing a SmartArt graphic Inputting into SmartArt Modifying and formatting SmartArt graphics 10 Linking to other files Linking to files using paste special Linking an Excel chart to a document Managing linked content from Word

Help with chronic pain – learn the powerful psychological and behavioural techniques that alleviate persistent pain and accelerate healing with pain specialist Dr Grahame Brown Accredited CPD Certificate: 6 hours Length: 1 day (9.30am - 4.00pm GMT) Fantastic to have the opportunity to train with this specialist. Thoroughly enjoyed this online course – the best I have attended...CLINCIAL HYPNOTHERAPIST Live online training – Join Dr Grahame Brown on Wednesday 24th April 2024 for this practical live online training event via Zoom, you will have plenty of opportunities to ask questions. Simply book your place and we will email you the Zoom link the day before the event. BONUS RECORDING – the training is recorded, in case anyone experiences technical difficulties on the day, so you will also get a recording for a limited time afterwards to maximise your learning. Can’t make this date?  Register your interest and we’ll let you know when there’s another. Why you should attend Pain is endemic in our society and whatever the cause – back pain, migraine, arthritic pain, dental pain, irritable bowel (IBS), labour/menstrual pain, cancer pain, psychogenic pain, psychosomatic pain – it can be incapacitating. Chronic pain is any pain which lasts for more than three months and it is estimated that between 25–40% of our population suffer from persistent or chronic pain. The sociological and economic costs of this are enormous but it is in the personal human suffering involved – mental as well as physical – that the real costs should be measured. Many are desperate for effective help to relieve their pain and the associated effects, such as insomnia and depression. This online workshop – with leading pain and musculoskeletal medicine consultant Dr Grahame Brown – gives you important new information about how we experience pain – derived from the latest neuroscience – and a powerful range of psychological techniques for managing pain naturally, preventing it from escalating and speeding up healing. You will discover how people can be helped out of the vicious cycle of chronic pain and how, by working holistically through the bio-psycho-social model, suffering can be dramatically reduced. You don’t need to have any prior medical knowledge to learn from and enjoy the day – you will leave with a much clearer understanding of what is going on in the mind/body system, what you can do to reduce suffering when pain persists and ways to prevent chronic ongoing pain from developing. It is a key event if you work with people suffering from pain at any stage (from recent onset, recurrent to persistent) or if you would like to find out how to successfully manage pain without medication. You will learn a wide variety of pain management techniques, which can easily be integrated into your work, to help relieve pain and promote recovery – often in just one session. Dr Grahame Brown has a real gift for helping people heal themselves – I know: I’m one of them!CHRISTOPHER BUCKLEY, PROFESSOR OF RHEUMATOLOGY, UNIVERSITY OF BIRMINGHAM What will you learn An increased understanding of how we perceive pain (from the latest neuroscientific research) and what is happening in the mind/body system A road map for helping people out of the vicious cycle of chronic pain, or to stop it developing in the first place The confidence and skills to help patients suffering from persistent pain of whatever cause – no need to feel ‘heart-sink’ with some patients anymore An understanding of what is going on when pain persists – and what you can do about it How to reduce the risk of chronic pain developing – prevention is better than cure – and identify the factors that make it likely A range of psychological chronic pain management techniques to use with your patients or yourself The importance of the bio-psycho-social model in reducing pain and accelerating healing How to produce significant pain relief by changing the way people think about their pain – in minutes An understanding of the value of pain displacement and how to use the brain’s ‘reality simulator’ What the latest neuroscience tell us about the experience of pain How to use guided imagery, relaxation and distraction to promote chronic pain relief How to deal with constant pain and promote healing How healthcare professionals can make their consultations more therapeutic How to avoid labelling patients’ pain as ‘purely psychological’ The many myths about pain – and why some well-intentioned pain management techniques don’t work and more… No prior medical knowledge is needed for you to benefit from the day. Course Programme The ‘Effective Pain Management’ live online course starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am Understanding pain 11.00am Comfort break and discussion 11.30am Assessing a person with persistent pain 1.00pm Lunch break 1.45pm Psychological & Behavioural treatment interventions 2.45pm Comfort break and discussion 3.00pm Practical demonstration of interventions 4.00pm Day ends Who is this course suitable for? This course is designed to enhance the skills and knowledge of health care professionals of any discipline who work on a regular or occasional basis with people in pain to improve outcomes, including: • doctors • surgeons • nurses • dentists • neurologists • osteopaths • chiropractors • palliative care workers • psychiatrists • midwives • physiotherapists • occupational therapists • psychologists • health visitors • support/care workers • psychotherapists • counsellors – it is perfect CPD If you personally experience persistent pain then you will gain much from the workshop but please be aware the programme is not designed to be a treatment day and the tutor will be unable to give opinions to individuals with pain problems unless (with consent) their problem can be discussed for the benefit of all participants Anyone who would like to understand more about their own experience of pain, or that of someone they care for, and what can be done to manage ongoing pain and alleviate suffering This course has been independently assessed by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

– essential guidance for safe and effective remote working Join our expert tutors to discover how you can make online therapy work for your practice Accredited CPD Certificate: 4 hours Length: 9am – 1.15pm (BST) LIVE ONLINE – Specialist training in delivering effective therapy online or over the phone – Join Ros Townsend live online on Tuesday 11th June 24 for this jam-packed, informative session. You will receive your Zoom link the day before the event. NB. Spaces are limited and tend to go quickly. Register your interest here if you can’t make this date, and we’ll let you know when there’s another one. BONUS RECORDING – the training is recorded, in case of technical difficulties, so you will also get a recording for 2 weeks afterwards to maximise your learning. Delivering online therapy, or counselling clients on the phone, requires a particular set of skills and brings with it specific considerations. This live online workshop will help you gain confidence in working safely and ethically, examining the advantages, potential drawbacks and adjustments you need to make to work remotely successfully. There will be plenty of time for questions, and helpful discussions with your peers and experienced tutors. Why take this course Whether you are a new practitioner wanting to develop your online practice, or an experienced therapist who has decided to start offering services online or on the phone, this course will help you gain the skills and understanding you need to do so safely and effectively. Unlike other online courses, this practical live online CPD training gives you the opportunity to ask our experienced tutors questions about any aspects that concern you, as well as learning from their case histories about what has worked – and what hasn’t – for them. Covering essential areas such as managing client expectations, setting up a therapeutic online environment, risk management, and the use and adaptation of various skills and techniques for online or telephone work, this course gives you the essential information you need to deliver therapeutic interventions remotely. Both Jo Baker and Ros Townsend, the course tutors, have extensive experience of working with clients online, with Ros now running her entire therapy practice remotely. Jo works using a blended approach (combining face-to-face counselling and online psychotherapy), and both bring a wealth of practical tips, hands on experience and real-life examples to the training. During the day, there will be ample opportunity to discuss and share ideas with both tutors and peers, and to enter into both structured and more free-ranging discussions about both the benefits and potential difficulties that one might encounter when working therapeutically through remote mediums. What the training covers: The importance of aligning client and therapist expectations for online therapy, or therapy over the phone How to set-up successfully for work on the phone or online – including template agreements to use with your clients Managing your technology and ensuring good communication – key things to ascertain, plus troubleshooting tips What to do when the call won’t connect The importance of confidentiality and privacy – and the potential problems you need be aware of when working online Agreeing safe communication methods between sessions How to successfully manage dual therapy spaces The importance of setting and maintaining professional boundaries Discussion regarding what is / is not acceptable in a home therapy space How to manage transitions before and after the session – for clients and therapists The key differences between online and face to face therapy work How to adapt and work successfully with a range of key therapeutic skills – such as Guided Imagery and The Rewind technique Assessing suitability of client presentations – including guidance on cases that are not suitable for online therapy How to manage risk effectively in an online or telephone environment How to put in place effective contingency plans for when technology fails Developing flexibility: dealing with the unexpected – including what to do if a session is interrupted When to refer a client on The additional pressures and potential stressors of online and telephone working Working in a blended way – combining remote and face-to-face sessions Key differences for the client of receiving therapy online or over the telephone The particular considerations of working with a wider client group from different geographical locations The importance of self-care and self-awareness Insurance and GDPR considerations when delivering online therapy or counselling, or working via the phone The importance of appropriate supervision Course Programme The ‘Online and phone therapy training’ course starts at 9.00am and runs until 1.15pm. (BST). 9.00am Join the Zoom meeting 9.15am First session starts 11.00am Comfort break and discussion 11.30am Second session 1.15pm Day ends Who is this course suitable for? This course is designed for both trainee and fully-qualified therapists, psychotherapists and counsellors It is recommended to all HG practitioners by the Human Givens Institute – trainee HG Therapists are expected to take this training if they are considering working online. This course has been independently accredited by the internationally recognised CPD Standards Office for 4 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

SSRS Report Builder Course Summary. Practical SSRS Report Builder course, to leavy you full conversant with queries, DML and DDL statements. Hands-on, Practical SSRS course. PCWorkshops SSRS Course Certificate. Max 4 people per course, we keep it personalised. Where is the SSRS Report Builder Course? Online: Instructor-led. Classroom: Request per email. SSRS Course Materials SSRS Coding Examples Manuals and Notes: In-depth reference materials Exercises: Practical exercises Payment Options → £600, Follow the booking link Arrange for installments Included with SSRS Report Builder Course: SSRS Course Certificate on completion. SSRS Course Manual. Practical SSRS Course exercises. SSRS Code Samples. After the course, 1 free session for questions. Max group size, online and in classroom, on this SSRS Course is 4. Course Topics SSRS Report Builder Course Topics SSRS Course topics: This course focus on producing reports using MS SQL SSRS Report Builder, to use the product features and tools related to data retrieval, visualisations and deployment. The Target Audience: end-users who will produce reports for their department or group using datasets. SSRS Course Topics Report Models: Data source views Creating a model Entities, attributes and roles Tables: Creating tables Interactive sorting Floating headers Grouping: Inserting groups Group headers/footers Displaying group totals Expanding and collapsing Expressions: The expression builder The Report Items collection Built-in fields Conditional formatting expressions Page headers and footers Page names and numbers Exporting reports: The various report formats Using RenderFormat. Parameters: Creating parameters Filtering using parameters Drop list parameters Coping with empty tables Matrices: Row and column groups Sorting and filtering matrices Creating subtotals Charts: Creating charts The parts of a chart Formatting charts Basic reports: Text boxes and images Selecting report items Formatting parts of a report Miniature charts Creating sparklines Creating data bars Graphical indicators Creating and customising indicators Linear and radial gauges Lists: Page-per-record lists Dashboard lists Other list ideas Subreports: Creating a child report Creating the main report Linking the two reports Report parts: Publishing report parts The report part gallery Updating report parts Book the SSRS Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

SSRS Report Builder Course Summary. Practical SSRS Report Builder course, to leavy you full conversant with queries, DML and DDL statements. Hands-on, Practical SSRS course. PCWorkshops SSRS Course Certificate. Max 4 people per course, we keep it personalised. Where is the SSRS Report Builder Course? Online: Instructor-led. Classroom: Request per email. SSRS Course Materials SSRS Coding Examples Manuals and Notes: In-depth reference materials Exercises: Practical exercises Payment Options → £600, Follow the booking link Arrange for installments Included with SSRS Report Builder Course: SSRS Course Certificate on completion. SSRS Course Manual. Practical SSRS Course exercises. SSRS Code Samples. After the course, 1 free session for questions. Max group size, online and in classroom, on this SSRS Course is 4. Course Topics SSRS Report Builder Course Topics SSRS Course topics: This course focus on producing reports using MS SQL SSRS Report Builder, to use the product features and tools related to data retrieval, visualisations and deployment. The Target Audience: end-users who will produce reports for their department or group using datasets. SSRS Course Topics Report Models: Data source views Creating a model Entities, attributes and roles Tables: Creating tables Interactive sorting Floating headers Grouping: Inserting groups Group headers/footers Displaying group totals Expanding and collapsing Expressions: The expression builder The Report Items collection Built-in fields Conditional formatting expressions Page headers and footers Page names and numbers Exporting reports: The various report formats Using RenderFormat. Parameters: Creating parameters Filtering using parameters Drop list parameters Coping with empty tables Matrices: Row and column groups Sorting and filtering matrices Creating subtotals Charts: Creating charts The parts of a chart Formatting charts Basic reports: Text boxes and images Selecting report items Formatting parts of a report Miniature charts Creating sparklines Creating data bars Graphical indicators Creating and customising indicators Linear and radial gauges Lists: Page-per-record lists Dashboard lists Other list ideas Subreports: Creating a child report Creating the main report Linking the two reports Report parts: Publishing report parts The report part gallery Updating report parts Book the SSRS Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

Basic Python syntax and principles of Object Orientated Programming. Most attendees are in-work IT Professional. Private individuals are also very welcome. Evening courses also running. Our Style: Hands-on, Practical Location: Online, Instructor-led Download: anaconda.com Duration: 6 weeks, 1 evening per week, 6pm - 8pm Times: arrange a time for your time zone

In Person Korean Glow Facial Course Content: Salon health and safety Anatomy and physiology Contra indications Hygiene Trolley set up Consultation Skin Conditions Extractions What is korean facial Products Step by Step guide Who is this training for? The training is availble to anyone trained in Hydrodermabrasion and facials. Please note, if you are not trained in the above you can sign up for our hydrodermabrasion training alongside the korean facial. Training kit There is no training kit included in this course. Our training manual explains what products you need and where to purchase them from Certificate You will receive an end of course certificate How do Online Courses work? http://www.kbhtrainingacademy.com/online-courses Duration of Course? You will have 3 months to complete the course before it expires Will I require a model? Yes, usually 1 model is required to complete all of the required case studies Are there video tutorials? Yes, you will have a link to YouTube and training videos to watch the treatment being performed

Are you looking for something that will help you understand yourself and how to interact with others more effectively? Would you like something that uses a simple four colour model to quickly allow you to understand your personality type and how you can use this knowledge to enhance your relationships and reach your goals, whatever they are? We think that Insights Discovery might be just the thing for you! What's even better is that our Discovery bundle includes both a copy of your unique profile and a 90 minute personal session with our executive coach, Cami Rose, to chat it all through and set you up for success using your new knowledge for the future. Just request a session and we'll be in touch with the link that will allow you to complete the Insights evaluator and arrange your personal coaching session at a time to suit you. Want Discovery for your team? We can do that too. Leave us your name and details and we'll be in touch to chat through your needs and objectives.