776 Courses in Leicester delivered Live Online

Relationship coaching for your relationship skills can be done individually or as a couple Emotional intelligence training Learn how to be a strong couple Love Language training Learn how to improve rapport and empathy Emotional validation and emotional civility training Consideration and patience training Conflict Resolution and self management Free check in calls in between sessions Choose one of our office locations to have your sessions 1 hour per week 3 sessions https://relationshipsmdd.com/product/relationship-coach-london-package/

Develop your pronunciation and fluency in speaking. Enrich your vocabulary. Become confident speakers in everyday life. Communicate effectively and interact socially in formal situations. Deal with situations when you travel to places where the language is spoken.

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.

4G & 5G Roaming Scenarios & Procedures course description This course is designed to explain the roaming procedures of modern mobile networks, based on the GSMA roaming specification the course explains all scenarios where a mobile subscriber may find themselves whilst visiting a preferred mobile network partner. Interconnection between MNOs and the use of GRX & IPX as an interworking process. The course will work through the registration & authentication procedure, download of the user profile, the APN configuration & DIAMETER process to verify user authenticity. VoLTE roaming and IMS registration procedures for voice support & SMS delivery will be discussed and explained. What will you learn Architecture Models Technical requirements for interfaces - 4G Roaming Scenarios Technical requirements & recommendations for services Other Technical Requirements & Recommendations Technical Requirements for QoS support Technical Requirements & Recommendations for Interfaces - 5G Scenarios Technical Requirements & Recommendations for Interworking & Coexistence with E-UTRAN & EPC Technical Requirements & Recommendations for Services Other Technical Requirements & Recommendations 4G & 5G Roaming Scenarios & Procedures course details Who will benefit: Those working in mobile networks. Prerequisites: None. Duration 3 days 4G & 5G Roaming Scenarios & Procedures course contents Architecture Models 4G Evolved Packet System 5G Core Network SGs Interface for CSFB& SMS over SGs Technical Requirements for Interfaces - 4G Roaming Scenarios General requirements for inter-PLMN interfaces Stream Control Transmission Protocol (SCTP) IAMETER S8 Interface SGW selection PGW selection GTP Transport Layer engineering S9 interface Implementation requirements Guidelines for DIAMETER over S9 S6a & S6d interface Gy interface Guidelines for DIAMETER over Gy Legacy interworking scenarios VPLMN has not implemented LTE HPLMN has not implemented LTE Co-existence scenarios Possible scenarios 2G/3G roaming agreement only 2G/3G LTE roaming agreement LTE roaming registrations Consequences of different APN approaches when roaming Guidance regarding the APN approach when roaming Inter-RAT handover Handover & access restrictions to/from 2G/3G & LTE (Active mode) Access restriction for 2G/3G and/or LTE (Idle mode) Handover of PDN Connections between GERAN/UTRAN & LTE Handover to/from non-3GPP accesses & LTE Bandwidth considerations ARP considerations at handover from LTE to 2G/3G Tech requirements & recommendations for Services SMS SMS over SGs Voice CSFB Roaming retry for CSFB Roaming Forwarding for CSFB Coexistence of Roaming Forwarding & Roaming Retry Recommended procedures IMS Voice Roaming Architecture Other Technical Requirements & Recommendations Access Control Addressing APN for IMS based services IMS Well Known APN APN for Home Operator Services Gateway Selection Inter-PLMN roaming handover Data off related functionality Emergency Services Emergency PDN connectivity Emergency Call indicator Security GTP Security DIAMETER Security DIAMTER Roaming hubbing Default APN E-UTRA NR Dual Connectivity with EPC GW Selection for E-UTRA-NR Dual Connectivity TAC/LAC Restriction Guidelines Technical Requirements for QoS support QoS parameters definition QoS Management in the Home Routed architecture QoS control for IMS APN in the S8HR architecture Support of QoS in GRX/IPX QoS Control in Local Breakout architecture Technical Requirements & Recommendations for Interfaces - 5G Scenarios General requirements for inter-PLMN interfaces Transport protocol - TCP/IP Serialisation protocol - JSON Interface Definition language - OpenAPI Application Protocol - HTTP2 Inter-PLMN (N32) Interface N32c N32f ALS & IPX HTTP Proxy SMF & UPF in HPLMN & VPLMN Requirements related to Service Based Architecture Naming, addressing & routing for 5G SA roaming SEPP load distribution SEPP administration, naming convention & routing SEPP HTTP redirections Technical Requirements & Recommendations for Interworking & Coexistence with E-UTRAN & EPC Interworking scenarios Coexistence scenarios Inter-RAT Handover Handover & Access restriction between 5GC & EPC Technical Requirements & Recommendations for Services Network slicing Voice, Video & Messaging Location support UE Route Selection Policy Other Technical Requirements & Recommendations Access control IP Addressing DNN for IMS based services Emergency PDU Session Emergency Services Fallback Security Steering of Roaming in 5GS Technical Requirements for QoS support 5G QoS model 5G QoS profile QoS Control

Body Language Masterclass Communication Through Movement Course Overview This "Body Language Masterclass: Communication Through Movement" provides an in-depth exploration of non-verbal communication, offering insights into how body language influences interactions and relationships. Learners will understand the importance of body movements, facial expressions, posture, and gestures in communication. The course is designed to enhance communication effectiveness in personal and professional settings, focusing on recognising and using non-verbal cues to convey messages more clearly. By the end of the course, participants will be equipped with the skills to interpret and utilise body language to improve their interpersonal interactions, boosting confidence and enhancing professional communication. Course Description In this course, participants will delve into the key elements of non-verbal communication, learning how body language affects our daily interactions. Topics include understanding the nuances of gestures, posture, and facial expressions, as well as their role in business settings. The course covers the importance of non-verbal communication in forming impressions, creating rapport, and enhancing leadership skills. Additionally, learners will examine how to use body language effectively in the digital world. Through engaging lessons, participants will develop essential skills in recognising non-verbal cues and improving their communication style. This course is suitable for individuals seeking to elevate their communication abilities and build stronger, more authentic connections in both personal and professional contexts. Body Language Masterclass Communication Through Movement Curriculum Module 01: How You Communicate Nonverbally Through Your Body Module 02: Reading and Understanding Non-Verbal Communication Module 03: The Importance of Non-Verbal Communication in Business Module 04: Improving Your Non-Verbal Communication Skills Module 05: Branding Yourself Non-Verbal Communication Module 06: Branding Yourself in the Digital World Through Non-Verbal Communication Module 07: Conclusion (See full curriculum) Who is this course for? Individuals seeking to improve their communication skills. Professionals aiming to enhance their interpersonal interactions in the workplace. Beginners with an interest in understanding body language. Those who want to build stronger personal and professional relationships. Career Path Corporate Communication Specialist HR and Recruitment Professional Marketing and Branding Specialist Leadership and Management Roles Customer Service Manager Media and Public Relations Expert

This course accompanies your Practitioner diploma in clinical hypnotherapy, its a practical Hypnotherapy Training course: It's 5-Days of immersive practice. Dive into the practical implementation of clinical hypnotherapy with 5 intensive days of training. These training days are designed to equip you with essential hands-on skills for immediate application. These training days invite you to experience and practice with guidance the tools and techniques taught in the first 5 modules of the practitioner diploma in clinical hypnotherapy. Across these training days, you will actively learn to: * Induce Hypnosis & Build Rapport: Master various hypnotic inductions and communication techniques to effectively guide clients into a trance state. * Implement Suggestion & Regression Therapy: Gain practical experience in crafting and delivering powerful suggestion therapy, along with exploring regression techniques to address root causes of challenges. * Apply Advanced Language Patterns: Develop and refine your use of hypnotic language for effective client consultations, rapid transformation, and facilitating positive behavior and state changes. * Address Specific Client Needs: Learn practical methods for rapid phobia release, managing anxiety, overcoming fears, and applying solution-focused techniques to help clients achieve their desired outcomes. * Prepare for Practice: Begin to understand the fundamentals of setting up and developing your own clinical hypnotherapy practice, preparing you for real-world application. This immersive training emphasises hands-on practice, ensuring you gain the confidence and capability it accompanies the accademic part of your self directed learning to begin your journey in clinical hypnotherapy.

Motorsport is as much a business as it is a sport. Our new master’s programme will provide students with a broad range of modules which examine the national and international aspects of the industry from a commercial perspective. From governance, structure and international sports law, through to the importance and interdependence of commercial rights holders, promoters, manufacturer, teams, sponsors and the role played by the media, this course is aimed at enhancing the professional and career prospects of those with an aspiration of working within this exciting and challenging global industry. Our programme will help you to develop as professionals with a strong grounding in ethics and a clear sense of how motorsport relates to various cultures, stakeholders and the sectors it interacts with.

This course shows you how to apply various approaches and algorithms to solve business problems through AI and ML, follow a methodical workflow to develop sound solutions, use open-source, off-the-shelf tools to develop, test, and deploy those solutions, and ensure that they protect the privacy of users. This course includes hands-on activities for each topic area.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for all project managers and project team leaders. This class is intended for PMP?s looking to earn PDU's, or for Project Managers looking to learn more about Project Team Leadership techniques. Project success depends on choosing, motivating, and leading the project team. This course focuses on improving the project manager?s human resource expertise, from initial planning through project closure. Participants will apply all course principles to a work-related case study taken directly from their work environment. At course completion, students will be able to develop a human resource plan, acquire optimal team members, develop and motivate team members, and manage team members to accomplish project goals. NOTE: This course will earn you 14 PDUs. 1 - Project Teams Overview Project Human Resource Management Project Human Resources Management Processes Case Study Selection 2 - Develop Human Resource Plan Plan Human Resource Management Roles and Responsibilities Project Organizational Chart Staffing Management Plan Resource Histogram 3 - Acquire Project Team Acquire Project Team Overview Multi-Criteria Decision Analysis Acquire Contract Resources Optimize Virtual Teams Best Practices Social Identity Theory Virtual Teams and Social Identity Theory Team Building Activities for Virtual Teams Cultural Diversity Individualism and Communitarianism Perspectives of Time and Space Fate and Personal Responsibility Face and Saving Face Body Language Create Resource Calendars 4 - Develop Project Team Develop Project Team Overview Ground Rules Form, Storm, Norm, Perform, Adjourn Team Building Team Building ? Personality Profiles Collaborative, Delphi, Majority and Plurality Decision Making Recognition and Rewards Expectancy Theory Maslow?s Hierarchy Of Needs Operant Conditioning Team Performance Assessment 5 - Manage Project Team Manage Project Team Overview Performance Problems Challenging Stakeholders Stress Management Conflict Management and Resolution Views of Conflict Sources of Project Management Conflict Conflict Resolution Survey Conflict Resolution Techniques Additional course details: Nexus Humans Project Team Leadership 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 Project Team Leadership 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.

Do you participate in English-language meetings? Do you got to prepare an agenda in English? And is English your second language? This course is specifically for non-native English speakers needing skills in planning and participating in meetings.