268 Productivity courses in London

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.

Is your lifestyle too sedentary? Do you feel sluggish by the end of the day? Wrecked by the end of the week? You need to vary your regime at work. You need to work with, rather than against, your physicality in order to boost your energy levels in a sustainable way - without recourse to coffee, sugar or other stimulants. Take away: Four quick and easy ways to make you feel good and re-energised. You will have the opportunity to: Explore how even just small amounts of physical activity can impact your mental and general health and wellbeing, creativity and productivity. Learn what to do about a sedentary lifestyle Get some tips on what to do about your posture Deskercise - try out some easy stretches and exercises you can do at your desk

The psychological insights and skills you need Knowing how to resolve conflict constructively is an essential life skill – improving personal and professional relationships, mental health, productivity and more… Accredited CPD Certificate : 6 hours Length 1 day (9.30am - 4.00pm) > Counts towards the Diploma – from 2024, this course will be a requirement of Part 1 of the HG Diploma. A fantastic approach that helps you unpack the issues, respond positively and find an effective solution that moves everyone forward... This course will: deepen your understanding of why conflicts develop and escalate, the psychological factors involved and the cultural and contextual influences on our perceptions, experience and responses to conflict build your confidence and comfort around being in situations that involve conflict give you a range of skills and techniques that you can use with both individuals and groups, in therapy or the workplace – or with your friends and family – to resolve conflict constructively It will also enable you to: help clients recognise conflict and understand their own responses to it help clients develop the skills to engage with conflict productively, so they are more likely to reach positive outcomes provide clients with a framework and structure for addressing conflict in a healthy way help clients become less fearful of conflict, so they don’t avoid it in ways that are unhelpful and to recognise the role of conflict in healthy relationships provide psychoeducation, explaining how barriers to needs can cause conflict and how this can be different in different cultural contexts The course is interactive and experiential, with a focus on developing practical and transferable conflict resolution skills. It combines trainer input, discussion, small group activities and role-play to build your confidence when helping to resolve conflict at all levels, whether one-to-one or in organisations. Why take this course Conflict isn’t always destructive. Properly handled it can be creative and productive, leading to better outcomes and possibilities for all. Although conflict is a normal, ever-present possibility in our lives – between family, friends, colleagues, neighbours, and in our interactions with organisations – when it becomes entrenched it can cause immense individual distress, and waste time and money. Addressing interpersonal conflict using the psychological insights, concepts and proven techniques you will learn on the day, helps us to solve problems creatively and improve the health and wellbeing of those involved. To lead a healthy life we don’t need to avoid all conflict, but we do need to know how to approach it in ways which can help everyone involved meet their emotional needs, a win/win for all. Learning the human givens approach to conflict resolution helps to reduce the potential damaging consequences of destructive conflict and embrace the benefits of constructive conflict. Throughout the day, Rupinder will draw on her own considerable practical experience of successful conflict resolution and mediation in a wide range of settings as she provides expert guidance and training in the psychological insights and skills you need to be able to constructively resolve conflict between individuals and/or groups. Addressing conflict in the right way helps us solve problems and improves the health and wellbeing of everyone involved... What the course covers The common causes of interpersonal conflict The negative impacts and potential benefits in conflict situations How to consider intentions and outcomes when engaging in conflict The different methods used to influence the outcome of conflict, and how the method influences the outcome What a resolution really is The cultural and contextual influences on perceptions, experience, and responses to conflict The role our innate needs and resources play in conflict situations Identifying our influence on the process of conflict Effective skills to engage people who are in conflict A practical, sequenced model for effective mediation and conflict resolution An effective framework for facilitating constructive conversations How to structure a session/s to: facilitate resolution, increase engagement, understanding and define the needs of all parties Effective skills to facilitate negotiations Techniques and diffusing strategies to reduce potential barriers How to access resources to build agreements that last The effective skills needed to facilitate negotiations How to implement opportunities in organisations to address conflict effectively Ways to develop your leadership ability to respond to conflict and/or support others who are enduring it How to use this to support the process of resolution by improving how individuals relate to one another and addressing the contentious issues constructively And much more… Course Programme The ‘Conflict Resolution’ course starts at 9.30am and runs until 4.00pm. From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am Approaches to conflict 11.00am Discussion over tea/coffee 11.30am Understanding Causes and Impact 1.00pm Lunch (included) 1.45pm Increasing engagement 3.00pm Discussion over tea/coffee 3.15pm Reaching Resolution 4.00pm Day ends Who is this course suitable for? This course is for anyone wishing to understand more about the different ways conflict can affect us, or to feel more confident in a facilitation or leadership role when helping conflicted people It is also very relevant to anyone working in a supportive role – such as counsellors, psychotherapists, managers, HR staff, life coaches, Mindset Coaches, social workers etc. – as well as employees, customer service personnel and anyone working in schools and education. This course has been independently accredited 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.

FourSquare Training specialise in private, corporate Microsoft Teams courses delivered at your premises and tailored to your needs.

This combined First Aid and Fire Training offers the very best value to train your staff for fire and first aid training. Done in just one day, you can complete fire and first aid training

FourSquare Training specialise in private, corporate Microsoft 365 courses delivered at your premises and tailored to your needs.

Mindfulness is a practical technique for developing a greater sense of awareness and focus on the present moment. It is the opposite of mindlessness, meaning that actions and reactions become conscious and deliberate. It is an extremely useful tool for any busy work environment. Currently being used by the likes of Google and Pepsi, mindfulness can be adopted within the workplace to reduce stress and anxiety, provide greater focus and clarity, improve leadership capabilities and enhance the general wellbeing of staff at all levels. This workshop has been developed for forward-thinking organisations wanting to make a real and sustainable commitment to improving workplace wellbeing and productivity. This workshop will help you to understand the basic principles and benefits of mindfulness, and how it can be used in the workplace setting. It will also enable you to develop techniques to alleviate overwhelming feelings of stress or anxiety, prepare for important or challenging meetings, and generally achieve a greater sense of focus, clarity and calm whilst dealing with a hectic schedule.

Writing Clear Business Communication (In-Person) Effective writing seldom, if ever, 'magically materializes' on the spot. In reality, it is most often the product of planning, writing, and rewriting. This is why writing is called a process; it must go through a series of steps before it is clear and complete. This program is about learning about the writing process and covers the full spectrum of documents used when corresponding in the workplace. The ability to write effectively comes naturally to some people, but for the vast majority, it is a task often approached with a mixture of trepidation and dread. However, the ability to communicate in the written word, for whatever purpose, is an important part of our working and personal lives and can have a direct impact on our ability to persuade, gain commitment or agreement and enhance understanding. Good writing sounds like talking on paper, which is why this program is focused on getting the message across and achieving the desired results using the 'keep it simple and direct' approach. What You Will Learn You'll learn how to: Plan and prioritize each day's activities in a more efficient, productive manner Establish strategies to execute priorities and overcome procrastination Understand how to make trade-offs when faced with fire drills How to set and communicate boundary conditions Getting Started Introductions Course orientation Participants' expectations Foundation Concepts Exercise: A day in your life Resources to implement change o Mind-set o Tool-set o Skill-set What is your time really worth? The dynamics of procrastination The myth of multi-tasking Brain Rules - how to optimize your efficiency Organization and Prioritization Time management best practices Goal setting Exercise: Identifying your priorities The importance of organization Time management framework Prioritizing time Time Management Techniques Tips for managing time Nine ways to overcome procrastination The STING technique Managing your time o Handling unplanned urgencies o Dealing with information overload Delegation and managing others' time Creating your personal action plan

This is a one-day training event to help you: Develop your awareness of mental health issues in the workplace Enable you to act in a timely and constructive way to manage mental health issues that arise in the workplace Enable you to promote and maintain good mental health in your working environment It covers: Mental health statistical overview; most prevalent mental health problems, contributing factors, effects on productivity and the costs of mental ill-health Signs and symptoms of prevalent mental health conditions; 3 key indicators for all mental health problems Stigma; what it is and how it affects people Mental health legal and statistical overview: facts & figures, most prevalent mental health problems, aspects of the law, policy and procedural issues and guidelines for best practice Pro-active and constructive principles and strategies to manage mental health issues, to support colleagues who may be vulnerable to mental ill-health, and promote mental wellbeing This workshop will give you: Awareness of the key indications of mental ill-health Recognition of the prevalence and effects of stigma Knowledge of the wider picture; legal context Greater understanding and confidence to act constructively to support individuals who are vulnerable to mental ill-health The ability to take steps to actively promote mental-well-being in the workplace

FourSquare Training specialise in private, corporate SharePoint courses delivered at your premises and tailored to your needs.