36935 PE courses in Bradford delivered Online

MySQL Performance & Tuning training course description This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. What will you learn Develop a monitoring and tuning plan Use server configuration and status variables. Identify and improve problem queries. Make efficient use of indexes. Monitor and size memory caches and locks. Tune the MyISAM and InnoDB storage engine. Evaluate the use of partitioning for performance. MySQL Performance & Tuning training course details Who will benefit: Anyone who wishes to monitor and tune MySQL performance. Prerequisites: Delegates must have a working knowledge of MySQL Database Administration Duration 3 days MySQL Performance & Tuning training course contents Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.

FAA Level 3 Award In Supervising First Aid For Mental Health (RQF) Classroom (two day course), Virtual (6 x 2 ½ hour sessions) Gives learners knowledge of Mental Health First Aid and associated conditions This course is especially suitable for managers, supervisors and other staff that have the power to make changes in the workplace Course Contents: What is Mental Health? Why people develop mental health conditions What the role of a mental health first aider is Knowing how to provide advice and practical support Knowing how to recognise and manage stress Understand the impact of substance abuse on mental health Understand the first aid action plan for mental health and be able to put it in place Know how to implement a positive mental health culture in the workplace Recognising a range of mental health conditions: Depression Anxiety Psychosis Eating disorders Suicide Self-harm PTSD Personality disorders Bipolar disorder Schizophrenia Benefits of this course: 37% of all work-related ill-health is due to mental health problems Problems with mental health cover 45% of all working days lost A whopping 12.8 million working days, or 49, 042 years, were lost due to mental health problems in 2018/19 602,000 workers suffered from work-related stress, depression or anxiety in 2018/19 One in four people will have a mental health problem at some point during their lives Whether work is causing or aggravating mental health problems, employers have a legal responsibility towards their employees Work-related mental health issues must to be assessed to measure the levels of risk to staff Where a risk is identified, steps must be taken to remove it or reduce it as far as reasonably practicable This two day r employees' mental health and wellbeing Accredited, Ofqual regulated qualification Our Mental Health First Aid Courses are nationally recognised, Ofqual regulated qualifications accredited by First Aid Awards Ltd in association with NUCO Training. This means that you can be rest assured that your Mental Health First Aid Certificates fulfill the upcoming legal requirements and are a very good way to make sure you and your employees have a supporting workplace to deal with staff's mental health conditions. The Ofqual Register number for this course is 603/3770/9

Introspective test Emotional regulation and emotional intelligence training Help in addressing pain points areas Full Makeover and beauty treatments 10 V.I.P confidence building sessions Personality test Addressing trauma issues Personal life coach available daily Behavioural pattern training Relationships analysation Happiness test Dating advice for low confidence and insecurity triggers Eradication of negative patterns Cognitive behavioural therapy https://relationshipsmdd.com/product/dating-advice-for-women-with-very-low-confidence-package/

Historical Association webinar series: Making history accessible Presenters: Catherine Priggs and Dale Banham  In this session, participants will review their action research projects established during the first webinar. Coaching conversations will encourage reflection, allowing participants to share their actions and insights. Additionally, they will begin developing a strategic plan to outline next steps for supporting students with SEND in accessing the history curriculum.  To use your corporate recording offer on this webinar please fill in this form: https://forms.office.com/e/bdNUSwLNrL Image: A Squire "Old English" padlock on a gate latch in Devon (Image: Partonez/Wikimedia Commons)

Youth workers plan, organise and supervise community programs for young people. It enables young people to naturally develop their voice, influence, and place in society, allowing them to reach their full potential. Young people need to develop strong interpersonal and social skills. This Youth Work Certificate course will teach you how to organise youth work and youth engagement activities. The fundamentals of outdoor management and the skills and responsibilities of youth workers will be discussed. In addition, you will learn how to plan, organise, and supervise community programs aimed at young people. You will be introduced to various methodologies and models that have influenced modern youth work practices through both practical and theoretical training. This Youth Work Certificate course's lessons have been designed so that anyone with no prior knowledge of the subject can easily dive into them. So enrol now and successfully start your career. Why choose this Youth Work Certificate course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the course. >> Main Course: Youth Work Certificate >> Free Courses*** Course 01: Drug and Alcohol Awareness Training Course 02: Level 2 Award in Suicide Awareness >> Others benefit Included with This Youth Work Certificate Course Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Youth Work Certificate Course] Learning Objectives After completing this Youth Work Certificate course, the learner will be able to: Understand the fundamentals of youth work. Recognise who are youth workers. Know the role and approaches of youth workers. Explain the ethical conduct and principles in youth work. Describe the social change in youth development work. Know the National Youth Agency (NYA). Explain youth work according to the EU. Know the mental health of youth workers. Deal with stress. Describe youth justice and social work Course Curriculum >> Youth Work Certificate Module 01: Overview to Youth Work Module 02: Youth Workers: Who Are They? Module 03: Role and Approaches of Youth Worker Module 04: Ethical Conduct and Principles in Youth Work Module 05: Career as a Youth Worker (Social Work) Module 06: Social Influences on Youth Worker Module 07: The National Youth Agency (NYA) Module 08: The EU on Youth Work Module 09: Mental Health of Youth Worker Module 10: Dealing with Stress Module 11: Youth Justice and Social Work >> Free Courses course 01 >> Drug and Alcohol Awareness Training Module 01: Introduction Module 02: Historical Overview Module 03: Nature of Addiction Module 04: Policy Initiatives and Strategy in Alcohol and Drug Use Module 05: Understanding Alcohol Abuse Module 06: Drug Addiction & Abuse course 02 >> Level 2 Award in Suicide Awareness Module 1: Understanding Suicide course 03 >> Adults Support Worker Module 01: Introduction to Adults Support Worker Module 02: Introduction to Psychology of Older Age – Part I Module 03: Psychology of Older Age – Part II Module 04: Impact of Mental Health in the Old Age Module 05: Dealing with Life Module 06: Enhancing Health And Wellbeing course 04 >> Mental Health Support Worker Module 01: An Overview of Mental Health Module 02: Mental Health Support Worker Module 03: Understanding Childhood and Adolescent Psychiatric Disorders Module 04: Understanding Stress and Anxiety Disorders Module 05: Understanding Schizophrenia Module 06: Understanding Personality Disorders Module 07: Understanding Mood Disorders Module 08: Understanding Eating & Sleeping Disorders Module 09: Understanding Self-Harm and Suicide Module 10: Treating Mental Illness with Medication and Therapy Module 11: Laws Related to Mental Health Module 12: Mental Health System Module 13: The Participation of the Service User Assessment Method After completing each module, you will get MCQ quizzes to assess your learning. You will move through the later modules upon successful completion (60% correct answer at least) of the quiz test. This process continues till the end of the course. Apart from this, you do not need to sit for any other assessments. Certification After completing the course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £15. Who is this course for? This Youth Work Certificate is open to people of all backgrounds. Individuals in related professions can also enrol in this course to refresh or strengthen their skills. In addition, students can take this course to gather professional knowledge besides their study or for the future. Requirements To enroll in this Youth Work Certificate course, students must fulfill the following requirements: Good Command over English language Be energetic and self-motivated Basic computer Skill You must be at least 15 years old Career path Enrol in the Youth Work Certificate course today to learn the skills and knowledge required to work with young people and organise youth activities. Opportunities in this field are: Youth Worker Working within a community organisation PE Teacher Social Worker

Youth workers plan, organise and supervise community programs for young people. It enables young people to naturally develop their voice, influence, and place in society, allowing them to reach their full potential. Young people need to develop strong interpersonal and social skills. This Youth Work Certificate course will teach you how to organise youth work and youth engagement activities. The fundamentals of outdoor management and the skills and responsibilities of youth workers will be discussed. In addition, you will learn how to plan, organise, and supervise community programs aimed at young people. You will be introduced to various methodologies and models that have influenced modern youth work practices through both practical and theoretical training. This Youth Work Certificate course's lessons have been designed so that anyone with no prior knowledge of the subject can easily dive into them. So enrol now and successfully start your career. Why choose this Youth Work Certificate course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the course. >> Main Course: Youth Work Certificate >> Free Courses*** Course 01: Drug and Alcohol Awareness Training Course 02: Level 2 Award in Suicide Awareness >> Others benefit Included with This Youth Work Certificate Course Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Youth Work Certificate Course] Learning Objectives After completing this Youth Work Certificate course, the learner will be able to: Understand the fundamentals of youth work. Recognise who are youth workers. Know the role and approaches of youth workers. Explain the ethical conduct and principles in youth work. Describe the social change in youth development work. Know the National Youth Agency (NYA). Explain youth work according to the EU. Know the mental health of youth workers. Deal with stress. Describe youth justice and social work Course Curriculum >> Youth Work Certificate Module 01: Overview to Youth Work Module 02: Youth Workers: Who Are They? Module 03: Role and Approaches of Youth Worker Module 04: Ethical Conduct and Principles in Youth Work Module 05: Career as a Youth Worker (Social Work) Module 06: Social Influences on Youth Worker Module 07: The National Youth Agency (NYA) Module 08: The EU on Youth Work Module 09: Mental Health of Youth Worker Module 10: Dealing with Stress Module 11: Youth Justice and Social Work >> Free Courses course 01 >> Drug and Alcohol Awareness Training Module 01: Introduction Module 02: Historical Overview Module 03: Nature of Addiction Module 04: Policy Initiatives and Strategy in Alcohol and Drug Use Module 05: Understanding Alcohol Abuse Module 06: Drug Addiction & Abuse course 02 >> Level 2 Award in Suicide Awareness Module 1: Understanding Suicide course 03 >> Adults Support Worker Module 01: Introduction to Adults Support Worker Module 02: Introduction to Psychology of Older Age – Part I Module 03: Psychology of Older Age – Part II Module 04: Impact of Mental Health in the Old Age Module 05: Dealing with Life Module 06: Enhancing Health And Wellbeing course 04 >> Mental Health Support Worker Module 01: An Overview of Mental Health Module 02: Mental Health Support Worker Module 03: Understanding Childhood and Adolescent Psychiatric Disorders Module 04: Understanding Stress and Anxiety Disorders Module 05: Understanding Schizophrenia Module 06: Understanding Personality Disorders Module 07: Understanding Mood Disorders Module 08: Understanding Eating & Sleeping Disorders Module 09: Understanding Self-Harm and Suicide Module 10: Treating Mental Illness with Medication and Therapy Module 11: Laws Related to Mental Health Module 12: Mental Health System Module 13: The Participation of the Service User Assessment Method After completing each module, you will get MCQ quizzes to assess your learning. You will move through the later modules upon successful completion (60% correct answer at least) of the quiz test. This process continues till the end of the course. Apart from this, you do not need to sit for any other assessments. Certification After completing the course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £15 (if claimed by the learner). All of our courses are reviewed regularly to ensure their quality and provide appropriate current training for your chosen subject. Although certificates do not expire (in most cases), it is recommended that they be reviewed or renewed annually. Who is this course for? This Youth Work Certificate is open to people of all backgrounds. Individuals in related professions can also enrol in this course to refresh or strengthen their skills. In addition, students can take this course to gather professional knowledge besides their study or for the future. Requirements To enroll in this Youth Work Certificate course, students must fulfill the following requirements: Good Command over English language Be energetic and self-motivated Basic computer Skill You must be at least 15 years old Career path Enrol in the Youth Work Certificate course today to learn the skills and knowledge required to work with young people and organise youth activities. Opportunities in this field are: Youth Worker Working within a community organisation PE Teacher Social Worker

There is no such thing as a typical Access to HE student. Our Access to HE Diplomas are taken by students of all ages and backgrounds. Courses are designed, in particular, for people who have been out of education for some time, especially those who left school with too few qualifications to be able to go straight to university.

This Level 3 Apprenticeship has been designed for individuals wishing to start or advance their skills in first-line management, and will equip them with the knowledge and understanding needed to effectively provide direction, instructions and guidance to ensure the achievement of set goals.

Overview This course examines the major tools, techniques, and principles aimed at improving quality and productivity in the public sector. To provide students with practical methods for improving public organizations, this course will cover accountability systems, performance measurement, pay-for-performance reward systems, contracting out, and organizational assessment

Overview In the not-so-distant past, a bank teller regularly performed dozens of routine transactions during each and every shift. With the advent of online banking, gradually consumers realized they could do much of the work themselves and perform a range of simple tasks without having to darken the doors of their local branch.