1282 Courses in Sheffield

Performance management, Managing Performance, Employee engagement,

Managing meetings, Meeting Management, Efficient Meetings, Moccasin Approach, Moccasin Manager,

The Moccasin Manager, The Moccasin Approach, Management Training, Management Development,

Intro to SQL training course description A hands on course focusing on the use of SQL. In particular this course does not concentrate on any particular version of SQL but rather enables delegates to recognise the differences found in SQL on different platforms. What will you learn Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to define databases. Intro to SQL training course details Who will benefit: Anyone working with databases. Prerequisites: None. Duration 2 days Intro to SQL training course contents What is SQL? What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends. Database basics RDBMS, Tables. Hands on Investigating a database. Basic SQL commands SQL Overview: SQL DML, SQL DDL, SQL queries. SELECT, WHERE and ORDER BY clauses. Combining conditions. IN, LIKE and BETWEEN. Hands on Querying a database from existing tables. SQL data retrieval Scalar functions. Hands on Selecting data from an existing database. More SQL data retrieval Scalar functions, variations. Aggregate functions, GROUP BY. HAVING. Hands on Selecting data from an existing database. Table joins Multiple tables, joins, keys, inner joins, left joins, right joins. Hands on Selecting data from an existing database. SQL basic data manipulation INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK. Hands on Modifying data in tables. SQL Data Definition USE, CREATE, DROP, TRUNCATE, ALTER. Hands on Managing new tables and columns. Data control GRANT, REVOKE. Hands on Defining permissions.

Give leaders and managers the skills to tackle the tough stuff with this practical course. Perfect for experienced as well as new managers, we’ll provide the tools to talk confidently with staff on tricky subjects and highlight the importance of enhancing their emotional intelligence. The course includes: Changing your mindset Unconscious bias Emotional Intelligence Planning (not scripting) Monologue vs dialogue Questioning skills Listening skills Solution- finding

Introduction to Design Thinking: In-House Training Innovation is the cornerstone of highly successful companies, especially those that continue to be successful over the years and decades. Design thinking practices fuel this continual innovation, as they are the critical links from inspiration to delivery, concept to showroom floor, and start-up to global business. Design thinking is a structured approach to promoting innovation and creative problem-solving. It is not a new approach. It has been around for centuries, as the art, architecture, and inventions of mankind illustrate. By examining the steps to achieving great design and maximum utility of product, design thinking approaches provide a framework in which to develop new solutions to problems and new products to sell. This highly interactive course is designed to help participants think like designers to generate innovation, and to help teams to produce more innovation and creativity. Since design thinking is based on doing rather than thinking, we participants are challenged to apply the techniques, in the classroom, to create new ideas and solutions to a case study project. What you will Learn At the end of this program, you will be able to: Explain the underlying principles and value of using Design Thinking for innovation Describe the basic concepts of the Stanford Model for Design Thinking Evaluate a set of basic Design Thinking techniques for application to your projects Apply tools, techniques, and skills aligned with the 5 stages of the Stanford Model Drive innovation through Design Thinking at some level in your work environment Foundation Concepts Problems and solutions The Design Thinking difference Design Thinking skills and abilities Design Thinking mindset Design Thinking frameworks Stages of Design Thinking Problems and solutions The Design Thinking difference Design Thinking skills and abilities Design Thinking mindset Design Thinking frameworks General Practices Team formation Visualization Improvisation Personalization Empathize Practices Overview of Empathize techniques Observation Engagement Interviews Define Practices Overview of Define practices Unpacking techniques Defining the customer techniques Integrating the Define experience Ideate Practices Overview of Ideate practices Reusable techniques for the Ideate stage New Ideate techniques to explore Prototype & Test Practices Overview of Prototype practices Examples of prototypes Overview of Testing practices Forms of testing techniques Adopt and Adapt Design Thinking Overview of Design Thinking implementation Design Thinking implementation challenges Success in implementing Design Thinking Summary and Next Steps Workshop summary Next steps: Personal Action Plans

FAA Level 1 Award In Awareness Of First Aid For Mental Health (RQF) Classroom (4.5 hour course), Virtual (2 x 2 ½ hour sessions) Gives learners a good awareness of Mental Health First Aid Gives learners the skills to start that difficult conversation 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 Recognising a range of mental health conditions: Depression Anxiety Psychosis Eating disorders Suicide Self-harm 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 half day course gives people a good awareness of mental health in the workplace For a more complete introduction, see our full day First Aid for Mental Health or two day Supervising First Aid for Mental Health courses Accredited, Ofqual regulated qualification This Awareness of Mental Health First Aid Course is a nationally recognised, Ofqual regulated qualification accredited by First Aid Awards. This means that you can be rest assured that your Mental Health First Aid Certificates fulfil 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/3768/0

These comprehensive Total Electrical 20 training courses fully meet the qualification certification requirements of Part P schemes and are aimed at non-electrical and electrical persons wishing to up-skill or re-train. The aim of the Total Electrical 20 training courses is to provide a level of competence, which will allow work to be safely and efficiently carried out on Electrical Equipment and Systems all within a 4 or 6 week period. A 4 week Total Electrical 20 training course which gives you the foundation knowledge you need to commence working as a domestic electrician. The Total Electrical 20 training courses are a mixture of both practical work and theoretical study, with the emphasis being put on as much practical as possible. This Total Electrical 20 training course can be supplemented to a 6 week course with additional modules to enhance your existing skills and therefore widen your market. The Total Electrical 20 training courses are designed to be as PRACTICAL as they possibly can be, with over 50% of the course time being practical, because we believe that the best way to learn is to do it!! With ALL our courses we offer unbiased technical support and access to a wealth of knowledge and information upon completion. Once you’ve completed your course with Technique, you can be assured that our service doesn’t end there… There are NO hidden costs on our courses, everything is included. The above Total Electrical 20 training courses are inclusive of examination registration entry fees, stationary, and a FREE tool kit*. All test instrumentation required for the course will be available for use during the course, should you require to purchase you own, advice will be readily available to assist you with your selection. These items can either be pre-ordered or purchased during the course.

These comprehensive Total Electrical 20 training courses fully meet the qualification certification requirements of Part P schemes and are aimed at non-electrical and electrical persons wishing to up-skill or re-train. The aim of the Total Electrical 20 training courses is to provide a level of competence, which will allow work to be safely and efficiently carried out on Electrical Equipment and Systems all within a 4 or 6 week period. A 4 week Total Electrical 20 training course which gives you the foundation knowledge you need to commence working as a domestic electrician. The Total Electrical 20 training courses are a mixture of both practical work and theoretical study, with the emphasis being put on as much practical as possible. This Total Electrical 20 training course can be supplemented to a 6 week course with additional modules to enhance your existing skills and therefore widen your market. The Total Electrical 20 training courses are designed to be as PRACTICAL as they possibly can be, with over 50% of the course time being practical, because we believe that the best way to learn is to do it!! With ALL our courses we offer unbiased technical support and access to a wealth of knowledge and information upon completion. Once you’ve completed your course with Technique, you can be assured that our service doesn’t end there… There are NO hidden costs on our courses, everything is included. The above Total Electrical 20 training courses are inclusive of examination registration entry fees, stationary, and a FREE tool kit*. All test instrumentation required for the course will be available for use during the course, should you require to purchase you own, advice will be readily available to assist you with your selection. These items can either be pre-ordered or purchased during the course.

Managing Multiple Projects: In-House Training Succeeding in today's competitive marketplace often requires cycle time reduction - reducing the duration of projects and getting results faster. This workshop will address managing multiple projects within the context of program or product management. Are your projects taking longer and longer to complete? Are results less than optimal because of time pressures on resources? Would you like to increase project 'throughout'? Succeeding in today's competitive marketplace often requires cycle time reduction - reducing the duration of projects and getting results faster. This workshop will address managing multiple projects within the context of program or product management. Planning and managing individual projects is challenging. When introducing the real-life limitation of resources and other outside influences into the multi-project environment, those challenges are magnified, and new challenges are introduced. This interactive workshop will position you for immediate action. The goal of this course is to equip you with the necessary knowledge, skills, and techniques so that you can effectively and productively manage multiple projects. What you Will Learn You'll learn how to: Manage stakeholder relationships and expectations Prioritize and sequence multiple projects Manage time and stress within a multiple project environment Effectively manage logical dependencies among projects Optimize the use of resources across multiple projects using concepts from Critical Chain methods Manage risk and communications in a multiple project environment Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Portfolio, program, and project management principles The multiple project environment The MMP Process Model Developing the Multiple Project List Multiple project portfolio management Project selection Project categories and types The multiple project list Multiple Project Logical Dependencies Project dependencies Types of multiple project portfolios Categories of logical dependencies across multiple projects Project priorities in the multiple project schedule Multiple Project Resource Management Multiple project resources and resource management concepts Multiple project resource loading Resource pool and resource database Multiple project resource issues and outsourcing Critical chain resource management, including drum resources and multi-tasking Managing Risk Across Multiple Projects Multiple project risk management process Identifying, assessing, and responding to multiple project risks Critical chain and multiple project risks Risk interrelationship management methods Creating and Executing the Multiple Project Plan The multiple project plan Multiple project scheduling Multiple project budgeting Executing and maintaining the multiple project plan Controlling in the multiple project environment Tools in multiple project management Multiple Project Communications Effective communication in the multiple project environment Common communication barriers Multiple project communications plan Resolving multiple project conflicts Summary and Next Steps What did we learn, and how can we implement this in our work environments?