Trainer courses in Manchester

SQL Queries Course, 1-Day. Basic SQL syntax. This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. Private individuals are also very welcome.

This programme has been specifically designed to help experienced trainers, facilitators and coaches use Everything DiSC and the Five Behaviours assessments, and deliver workshops, with their own clients and in-house teams.

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.

This course has been designed and approved by the ILM (Institute of Leadership and Management). The recognition from the ILM means delegates receive an ILM Recognised Certificate from the ILM upon successful completion of the course. All of our ILM Programmes are provided in partnership with The BCF Group, which is the ILM Approved Centre we deliver under. Venue Details Nottingham The BCF Group Ltd, 5 Wheatcroft Business Park, Landmere Lane, Edwalton, Nottingham, NG12 4DG Suitable for Wheelchairs All Nottingham courses are held at the head office of The BCF Group. The comfortable training suites (which are situated on ground level, as well as the toilet facilities, making them wheelchair-friendly) are fully air conditioned with natural daylight. Plentiful on-site free car parking is also available. In-House Courses Our Train The Trainer course has been developed and refined over the many years we have been providing it to delegates from organisations in virtually every industry. The course syllabus is flexible and can be tailored to the specific requirements of your organisation and industry. If you would like to discuss how we can tailor this Train The Trainer course for you and/or run it at your premises, please contact us. Scheduled Courses Classroom Course - Nottingham (NG12 4DG) Classroom training courses enable you to benefit from having the tutor and other delegates right there in the room with you. Face-to-face training sessions are one of the best ways to learn, as it is easy to ask questions and have group discussions. Cost: £895 + vat 16-17 April 2024 - COURSE FULL 29-30 April 2024 18-19 June 2024 15-16 August 2024 14-15 October 2024 03-04 December 2024 Classroom Course - Reading (RG41 5QS) Classroom training courses enable you to benefit from having the tutor and other delegates right there in the room with you. Face-to-face training sessions are one of the best ways to learn, as it is easy to ask questions and have group discussions. Cost: £895 + vat 05-06 March 2024 25-26 June 2024 26-27 September 2024 05-06 December 2024 Zoom™ Course Attending a course via Zoom videoconferencing gives you all of the benefits of classroom training without the need to leave your home or office. You still benefit from a real tutor facilitating the programme, and the content is exactly the same. Cost: £795 + vat March 2024 - 25th March (morning), 25th March (afternoon), 26th March (morning), 26th March (afternoon) May 2024 - 21st May (morning), 21st May (afternoon), 22nd May (morning), 22nd May (afternoon) July 2024 - 18th July (morning), 18th July (afternoon), 19th July (morning), 19th July (afternoon) September 2024 - 18th September (morning), 18th September (afternoon), 19th September (morning), 19th September (afternoon) November 2024 - 13th November (morning), 13th November (afternoon), 14th November (morning), 14th November (afternoon) January 2025 - 21st January (morning), 21st January (afternoon), 22nd January (morning), 22nd January (afternoon)

Brightcore Consultancy delivers Senior Mental Health Lead training in schools and colleges which meets the Department for Education’s quality criteria, and our course is in fact the highest rated of all the nationally DfE approved Senior Mental Health Lead training courses, scoring a perfect 5/5 in each of the 9 DfE quality assurance standards during the quality assurance process.

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

Python Unittest Course Summary. Testing plays a major role in software development. This course will explain Python Unit Testing using the unittest built-in module. We'll cover issues before going to the production itself and the basics of testing in Python. Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Unittest Certification Duration: 1-Day, 10am-5pm Unittest topics UnitTest Framework - Home UnitTest Framework - Overview UnitTest - Framework UnitTest - API UnitTest - Assertion UnitTest - Test Discovery UnitTest - Skip Test UnitTest - Exceptions Test UnitTest - Time Test UnitTest - Unittest2 UnitTest - Signal Handling UnitTest - Doctest UnitTest - Doctest API UnitTest - Py.test Module Nose Testing - Framework Nose Testing - Tools Included with Python Unittest Course Python Unittest Certificate on completion Python Unittest Videos Python Unittest Notes Python Unittest Examples Practical Python Unittest exercises

If you have already undertaken some training in Motivational Interviewing (at least half a day)*, you are welcome to join our MI Skills Club (MISC), which is a free community group for Educational Psychologists wishing to practise their MI skills within a small and friendly group. Because MI is a conversational style, rather than a discrete skill, it is not something that can be mastered by attending a one-off training session. While MI is a learnable approach, it takes practice, reflection and supervision to improve. Learning MI on your own is hard, and receiving objective feedback and expert feedback are helpful in developing and maintaining competence in MI (Miller & Rollnick, 2023). Cathy Atkinson and Fi Coley, who are both members of the Motivational Interviewing Network of Trainers (MINT), are collaborating to build an MI Learning Community for EPs. MINT (2019) defines a learning community as a network of practitioners interested in the same topic, and the community can serve as both a resource and a forum for developing practice. In each 90-minute online session we will focus on one small aspect of MI (micro-skills practice) and use breakout rooms with small groups to practice skills and give /receive supportive feedback. This event is open to Educational Psychologists, Trainee Educational Psychologists, and Assistant Psychologists. We are unable to accommodate aspiring EPs at this event. *If you are just starting out on your MI journey, or you would like to refresh your skills, you can join our one-day Introduction and Refresher training on Friday 27th September 2024 - Motivational Interviewing for Ed Psychs: Introduction and Refresher Tickets, Fri 27 Sep 2024 at 09:00 | Eventbrite

An accredited qualification for current and prospective managers. This programme gives Team Leaders & Managers the skills, disciplines and confidence to manage their team effectively and add a great deal more value to the organisation - where they have to apply their learning in order to achieve the highly coveted ILM qualification. One of the main responsibilities of a manager is to make sure that employees are satisfied with their job and reaching their full potential. A manager who can energise his or her employees will have a team which has a much greater potential and capability of achieving company goals and objectives. It is therefore vital that a manager has the essential skills to fully support and lead their team to success. This 3-day programme brings together the key leadership skills that you will need to be an effective manager so that you can return to the workplace and deliver tangible results. All of our ILM Programmes are provided in partnership with The BCF Group, which is the ILM Approved Centre we deliver under. Course Syllabus The syllabus of the ILM Level 3 Award in Leadership and Management course is split into three main modules, covering the following: Module OneSolving Problems and Making Decisions What is a problem? How to identify a problem, its nature, scope and impact Identifying the root cause Understanding how to interpret information to solve a problem What is involved in making an informed decision? Generate ideas/solutions- creative thinking techniques How to evaluate your options Finding the critical path Having confidence to commit to a decision Planning approach Communicating the decision Implementing the plan Module TwoUnderstanding Leadership What is leadership? Recognise the differences and similarities between leadership and management Qualities and skills of a leader Action Centered Leadership - Team, Task, Individual - John Adair Varying leadership styles Evaluating a range of leadership models and their significance for: Task, Performance, Culture, Relationships Reflect on your own leadership styles and behaviours Create an action plan to enhance your performance Module ThreeUnderstanding the Communication Process in the Workplace Identify what is effective communication Understand the importance of effective communication at work Recognise the different ways we communicate Recognise possible barriers to communication and how to overcome them Johari's window - communication flows How others will perceive and interpret the information you have provided Active listening Developing questioning skills Understanding the significance of non-verbal communication and body language Developing sensory acuity and how to use it effectively in the workplace In-House & Classroom Courses Available Online We have developed an alternative to traditional face-to-face training that continues to provide a full learning experience, and allows delegates to learn effectively whilst self-isolating from home. This is how it looks: Delegates booked on Classroom and In-House courses will continue to have access to their trainer online throughout the days that the course is booked to run. Prior to a delegate's course start date, they will be enrolled on our e-learning platform (in partnership with BCF Group) for the course they are booked on to. They will also be given contact information for their trainer, and details of how to access the online workshops. Delegates will not require any special IT equipment. A desktop computer, laptop, tablet, or a mobile phone with internet and audio capability is all that is required. Delegates taking ILM Qualifications will then proceed to the book review, video review and work based assignments with 12 months tutor support as appropriate, and in line with our previous arrangements. We hope you agree that this blended learning experience represents the safest way to continue supporting our clients and delegates during the Coronavirus disruption. In-House Courses As well as being one of the most popular open courses, we can also arrange this course as an in-house programme for companies and organisations who wish to develop a number of their managers at the same time, and would find an in-house course at their own premises much more suitable. Scheduled Courses Classroom Course - Nottingham (NG12 4DG) Classroom training courses enable you to benefit from having the tutor and other delegates right there in the room with you. Face-to-face training sessions are one of the best ways to learn, as it is easy to ask questions and have group discussions. In addition to the 2 days in the classroom, delegates will need to undertake self-directed learning and 2 work-based assignments. Cost: £995 + vat 07-08 September 2023 14-15 December 2023 12-13 February 2024 Classroom Course - Reading (RG41 5QS) Classroom training courses enable you to benefit from having the tutor and other delegates right there in the room with you. Face-to-face training sessions are one of the best ways to learn, as it is easy to ask questions and have group discussions. In addition to the 2 days in the classroom, delegates will need to undertake self-directed learning and 2 work-based assignments. Cost: £995 + vat 05-06 October 2023 15-16 January 2024 11-12 April 2024 Zoom™ Course Attending a course via Zoom videoconferencing gives you all of the benefits of classroom training without the need to leave your home or office. You still benefit from a real tutor facilitating the programme, and the content is exactly the same. The only difference is that we split the course into four half-day sessions to make it easier on your eyes! Cost: £895 + vat November 2023 - 7th Nov (morning), 7th Nov (afternoon), 8th Nov (morning), 8th Nov (afternoon) March 2024 - 19th Mar (morning), 19th Mar (afternoon), 20th Mar (morning), 20th Mar (afternoon) June 2024 - 11th Jun (morning), 11th Jun (afternoon), 12th Jun (morning), 12th Jun (afternoon) Dickson Training Ltd Founded in 1985 in Yorkshire, we have built an impressive and loyal client base. Our partnerships are built by consistently delivering outstanding development solutions and working in close collaboration with our clients, resulting in us becoming a leading UK and international training provider.

Chair and facilitate effective meetings