4071 Engineer courses

ECS Health & Safety Course with MJ Electrical Training. Available every week, use this course to complete the application process when applying for an ECS Labourers Card.

These two weeks of intensive training consolidate and expand upon what you’ve learnt in Part 1 of the Human Givens Diploma Length: 2 x 5 days (9.00am – 6.30pm) Tutors: Dr Gareth Hughes, Jo Baker Suitable for: See below Location: Our Part 2 courses are held in Bristol Qualification: HG.Dip. / HG.Dip.P. (Trainee) I can’t speak highly enough of Part 2. It had all the elements to make it challenging, stretching, stimulating and, above all, thoroughly practicalPSYCHOTHERAPIST Part 2 of the 3-part Human Givens Diploma course consists of ten days of highly-focused and enjoyable work, plus home study and skills practice. The two separate weeks are held approximately a month apart and include the observation of therapy sessions carried out by HG tutors with real patients. The profound teaching style and practical approach is highly stimulating and generates much extra-curricular thought and discussion. During the two weeks you will have plenty of opportunity to expand upon and consolidate the knowledge and skills you have obtained on the shorter courses that make up Part 1 of the Diploma. There are many practical group and one-to-one exercises during which you will learn how to subtly combine what you’ve learnt into powerful therapy sessions that will enable your clients to move on in their lives, and a 2-hour written examination. The psychological knowledge and psychotherapeutic skills gained on the course are also highly relevant and easily transferable to other fields such as parenting, education, business coaching and back-to-work programmes. Course Dates Part 2 courses are held in Bristol. 2024Course No. HG96 Week 1: 29th January – 2nd February 2024 – 4 places available Week 2: 4th – 8th March 2024 Course No. HG97 Week 1: 20th – 24th May 2024 Week 2: 24th – 28th June 2024 Course No. HG98 Week 1: 14th – 18th October 2024 Week 2: 18th – 22nd November 2024 VENUE: Engineers’ House, Clifton Down, Bristol, BS8 3NB Who is this course for? The HG Diploma is primarily designed for anyone already working in mental health, education or social services, but because all aspects of the course are presented in clear, jargon-free language anyone interested in the subjects covered, or wishing to embark on a career in counselling or psychotherapy for the first time, can benefit from attending. Before attending the first Part 2 week, you need to have completed all 16 x Part 1 required courses, have read the required items on the Reading List and studied the Diploma Manual in depth. NB If you started working towards the HG Diploma before January 2019, you may well have completed some of our previous free-choice Part 1 courses, don’t worry these will still count towards your Part 1 – please call the office to discuss. Meet your tutors Dr Gareth Hughes Gareth is an HG psychotherapist, researcher, nationally recognised expert on university mental health and wellbeing and a Principal Fellow of the Higher Education Academy. Read more Jo Baker For many years Jo worked as a therapist within the Psychological Wellbeing department at the University of Derby, where she dealt with an extensive and varied caseload… Read more

This intensive week of skills practice, feedback and ongoing assessment is the final stage before becoming a fully-qualified human givens practitioner Dates: Mon 6th – Fri 10th Feb 2023Mon 26th – Fri 30th June 2023 Length: 5 days (9.00am – 5.30pm) Tutors: Dr Gareth Hughes, Jo Baker, Rosalind Townsend, Carol Harper Open to: Graduates of Part 2 of the Human Givens Diploma Qualification: Human Givens Practitioner Level Diploma (HG.Dip.P.) This week far exceeded my expectations – I can’t wait to get back and apply what I’ve learntJOHN BUCHANBERGER Part 3 is the Human Givens Practitioner Qualification; the pre-requisite to becoming a fully qualified human givens therapist, eligible for inclusion on the HGI’s Professional Register (which is independently accredited in the UK by the Professional Standards Authority for Health and Social Care). Throughout the week, students practise and demonstrate a broad range of practical therapeutic skills under close supervision and rigorous on-going assessment by the two tutors and experienced facilitators. Students who have already successfully graduated from the course enthuse about how useful and enriching it is. Between Part 2 and Part 3 of the Diploma students are expected to carry out extensive therapeutic practice, with a minimum of 10 different people, under ongoing supervision. For more information, please read the following downloads. Course Dates All Part 3 weeks are held at Engineers’ House in Bristol Winter 2023 – Code WK14 Mon 6th–Fri 10th February 2023 – FULL Summer 2023 – Code WK15 Mon 26th–Fri 30th June 2023 – Full, with waiting list Autumn 2023 – Code WK16 Mon 20th–Fri 24th November 2023 – Waiting list, please contact the office HOW TO APPLY: To attend Part 3, your supervisor must be happy that you have gained enough therapeutic experience and are ready to progress with this part of the Diploma. As there are only 12 places on each Part 3, we recommend you contact us as soon as possible to let us know which course you and your supervisor think you will be most likely to attend. Your name will then be added to the list for that course (for more information on this stage of the Diploma, see: Working towards Part 3). Please contact Fiona Heffernan if you have any questions about the course, or are ready to put your name down for a place on one. Meet your tutors Carol Harper Carol has 30 years’ experience in private practice, her holistic outlook and curiosity has influenced her professional development… Read more Dr Gareth Hughes Gareth is an HG psychotherapist, researcher, nationally recognised expert on university mental health and wellbeing and a Principal Fellow of the Higher Education Academy. Read more Jo Baker For many years Jo worked as a therapist within the Psychological Wellbeing department at the University of Derby, where she dealt with an extensive and varied caseload… Read more Rosalind Townsend Ros Townsend is an experienced psychotherapist and supervisor with busy practices in SW England, where she combines private therapy work with referrals from Occupational Health and the NHS. Read more

Learn to assess, design, and monitor solar PV power plants with EnergyEdge's comprehensive training. Master PVsyst software for bankable system simulations.

Enhance your knowledge on methane emissions mitigation and management in the oil and gas industry with EnergyEdge's course. Sign up now!

Dive deep into well integrity management with EnergyEdge's classroom training. Take your skills to the next level today!

Enhance your skills in cost estimation and analysis of well abandonment activities with EnergyEdge's comprehensive course. Join now!

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.

Enhance your knowledge of AVO attributes and inversion principles with EnergyEdge's course. Enroll now for a transformative learning journey!

Develop your expertise in process hazard assessment and lead HAZOP teams effectively with EnergyEdge's classroom training course. Enroll now!