2046 Courses in London

Public Speaking Courses That Work Our public speaking courses are refreshingly different and transformative. Mindful presenting is the key to the future of high impact public speaking training. In fact, we are changing organisations one presentation at a time. We do that by providing training that empowers and equips professionals to present with greater confidence, clarity and impact.

Public Speaking Courses That Work Our public speaking courses are refreshingly different and transformative. Mindful presenting is the key to the future of high impact public speaking training. In fact, we are changing organisations one presentation at a time. We do that by providing training that empowers and equips professionals to present with greater confidence, clarity and impact.

Effective cross-cultural management and leadership demand an understanding of the complexities of culture from structural, political, social and psychological perspectives An intensive 3-day training course from one of the leading providers of cross- cultural leadership and management training. Designed for individuals wishing to develop and their skills in managing and leading in a cross-cultural environment. Introduction Created specifically for the cross‐cultural workplace setting and utilising a blend of interactive role play, DVD presentations and case‐study based discussion, the course provides comprehensive skills training for anyone who must manage or lead a cross‐cultural team or employees. Trainer The trainer is Tony Buon, the Managing Partner of Buon Consultancy. He is a qualified workplace psychologist with over 30 years experience . Tony has worked in over 40 countries. He is a Certified Employee Assistance Professional (CEAP) and Associate Lecturer at the Aberdeen Business School. He holds degrees in Psychology, Behavioural Sciences and Work‐ place Education and trains throughout the UK, Europe, The Middle East & Asia. Tony has worked with some of the world’s leading companies over the past 30 years including; Diageo, Dolphin Energy, DuPont, Gulf Offshore, Halliburton, Hewlett‐Packard, ICI, ING Group, Kuwait Petroleum, Lend Lease, McDonalds, National Australia Bank, PetroChina, Pfizer, Qatar Petroleum, Royal Bank of Scotland, Shell, 3M, Coca Cola and Microsoft. He was also the senior consultant to the Sydney 2000 Olympic Games. Tony has also been interviewed in publications as diverse as Rolling Stone and the Reader’s Digest. He has appeared on CNN, BBC, Trans‐World Sport and many international television and radio stations. The Course The world of business has no borders. Nationalisation, globalisation and the growth of multi‐national corporations introduces challenges which managers and leaders must address. Effective cross‐cultural management and leadership demand an understanding of the complexities of culture from structural, political, social and psychological perspectives. The aims of the course are to explore the meaning and psychology of culture; to understand the impact of culture on management and leadership; to identify the areas in which cultural differences present a challenge in managing and leading employees in a multicultural environment; and finally to become more self ‐aware in cultural understanding, individual biases and assumptions and to understand the implications these have on our work. A vital course for any manager or leader work‐ ing in a multi‐cultural environment Covers the managerial, social and psychological aspects of culture Develop your cross‐cultural leadership & management skills in a fun and informative environment Discover best‐practice in diversity management and cross‐cultural communication Appreciate current business issues related to managing and leading in a cross‐cultural environment Comments from previous participants: “ ...one of the best courses I have ever attended!”“ I can’t believe how much I learnt. As an experienced expat, I thought I knew it all, this course truly expanded my people management skills”“ “...the trainer was excellent and the individual feedback and advice fantastic”“ This course will make me a better HR Manager, I have new skills I can use every day in dealing with all staff globally”   This course can be conducted on-site at your location for groups of up to 15 participants The Objectives By the end of the course, the delegates will be able to: Illustrate examples of stereotypes and stereotyping Formulate a business case for cultural diversity in their workplace List Hofstede’s five value dimensions Explain in his/her own words the meaning of each of the five value dimensions Evaluate the risks involved in international assignments The Delegates All supervisors, middle managers , department heads and senior managers Human resource personnel including HR Business Partners All staff interested in developing cross‐cultural skills The Benefits Appreciate the importance and meaning of culture Learn about the psychology of culture Develop your cross‐cultural leadership & management skills Discover how to manage and lead diverse employees in a multi‐cultural environment Appreciate current issues in international business related to managing people The Course Day 1: The Meaning and Psychology of Culture Our world today ‐ the importance of demographics Dimensions of culture Hofstede’s five value dimensions Workplace and organisational culture Stereotypes and stereotyping Cross‐cultural communication Body‐language and culture Day 2: Managing and Leading Diverse Employees Developing a global mindset Culture and strategy Managing in multi‐national companies Multi‐cultural teams and teamwork International assignments and global career development Culture shock and global working Culture and decision‐making

Facilitating Effective Meetings: In-House Training Billions of dollars and exorbitant amounts of time are wasted annually across the globe because of organizations' meeting practices. This contributes to serious performance problems for both organizations and employees, and it has a serious impact on culture and morale. But despite the costs and consequences, every-day people in any role have the ability to change that. They can reduce cost, improve productivity, and enhance their workplace cultures by improving their meeting facilitation skills. And that is because facilitation skills start in the planning stage, not in the live meeting stage. In this course, participants will learn that their responsibility as a facilitator is to be a steward of time, money, relationships, and performance. To do that, they will learn to estimate costs of meetings and practice a variety of strategic thinking and analysis tasks to effectively plan results-aligned meetings. They will also apply several techniques and strategies to proactively prevent and deal with conflict in meetings, as well as give objective, constructive feedback to others in order to create behavior change during meetings. Participants must bring laptops with them and have internet access during the course (both virtual classroom and traditional classroom). The laptops are needed for specific activities. Also note that this course pairs well with IIL's Conflict Resolution Skills and Decision Making and Problem Solving courses, which go much deeper into related skills and tools that support effective meeting facilitation. What you will Learn At the end of this program, you will be able to: Estimate the financial and time costs of attendance for real-world meetings Use a performance formula to define the purpose of meetings Describe the responsibilities and qualities of an effective facilitator Analyze situations to determine when a meeting is necessary Articulate performance-driven meeting goals and results Align meeting goals and results Strategize to invite, involve, and exclude appropriate attendees Explain research-based best practices for meeting decisions and agenda development Create an effective agenda for a results-driven meeting Apply proactive tools and strategies for relationship-building dealing with meeting conflict Give constructive behavioral feedback using the Situation-Behavior-Impact® technique The Business Case for Effective Facilitation Embracing the research on meetings Estimating the real costs of meetings Determining a meeting's performance value Clarifying the meeting facilitator's role Facilitating the Meeting Plan Determining if a meeting is necessary Aligning meeting goals with meeting types Identifying the right attendees Creating a strategically effective agenda Facilitating the Live Meeting Building relationships from the start Dealing with conflict proactively Giving feedback on unproductive behavior

Facilitating Effective Meetings (In-Person) Billions of dollars and exorbitant amounts of time are wasted annually across the globe because of organizations' meeting practices. This contributes to serious performance problems for both organizations and employees, and it has a serious impact on culture and morale. But despite the costs and consequences, every-day people in any role have the ability to change that. They can reduce cost, improve productivity, and enhance their workplace cultures by improving their meeting facilitation skills. And that is because facilitation skills start in the planning stage, not in the live meeting stage. In this course, participants will learn that their responsibility as a facilitator is to be a steward of time, money, relationships, and performance. To do that, they will learn to estimate costs of meetings and practice a variety of strategic thinking and analysis tasks to effectively plan results-aligned meetings. They will also apply several techniques and strategies to proactively prevent and deal with conflict in meetings, as well as give objective, constructive feedback to others in order to create behavior change during meetings. Participants must bring laptops with them and have internet access during the course (both virtual classroom and traditional classroom). The laptops are needed for specific activities. Also note that this course pairs well with IIL's Conflict Resolution Skills and Decision Making and Problem Solving courses, which go much deeper into related skills and tools that support effective meeting facilitation. What you will Learn At the end of this program, you will be able to: Estimate the financial and time costs of attendance for real-world meetings Use a performance formula to define the purpose of meetings Describe the responsibilities and qualities of an effective facilitator Analyze situations to determine when a meeting is necessary Articulate performance-driven meeting goals and results Align meeting goals and results Strategize to invite, involve, and exclude appropriate attendees Explain research-based best practices for meeting decisions and agenda development Create an effective agenda for a results-driven meeting Apply proactive tools and strategies for relationship-building dealing with meeting conflict Give constructive behavioral feedback using the Situation-Behavior-Impact® technique Getting Started The Business Case for Effective Facilitation Embracing the research on meetings Estimating the real costs of meetings Determining a meeting's performance value Clarifying the meeting facilitator's role Facilitating the Meeting Plan Determining if a meeting is necessary Aligning meeting goals with meeting types Identifying the right attendees Creating a strategically effective agenda Facilitating the Live Meeting Building relationships from the start Dealing with conflict proactively Giving feedback on unproductive behavior Summary and Next Steps

In today's dynamic global trade landscape, expertise in cargo inspection is more valuable than ever. Our comprehensive program is designed to equip you with the knowledge, skills, and certification needed to excel in the field of general cargo inspection, this comprehensive program is designed to empower maritime professionals like you with the skills and knowledge needed to excel in the ever-evolving maritime landscape. General cargo, in the context of shipping, refers to a broad category of goods that are typically non-specialized and not classified as bulk cargo or containerized cargo. These are goods that are individually packaged, bundled, or palletized and are not loaded into dedicated containers. General cargo can include a wide variety of items, ranging from machinery, equipment, and vehicles to consumer goods, textiles, and packaged products. Ships transporting general cargo are equipped with versatile cargo-handling facilities such as cranes and derricks to load and unload these diverse goods. General cargo vessels are adaptable and capable of carrying different types of merchandise, making them suitable for various industries and trade routes. The flexibility in handling different types of goods makes general cargo shipping an essential component of global trade. Elevate your career in cargo inspection with our Advanced Diploma in General Cargo Inspection! Enroll now and gain in-depth knowledge in: CS001: Marine Cargo Survey Practices CS002: Essential Law for Cargo Surveyors CS003: Technical Report Writing Skills for Surveyors CS013E: Expert in General Cargo Inspection Why Choose Our Program : Expert-Led Training: Learn from industry professionals with years of experience in cargo inspection. Flexible Learning Options: Access training materials online at your own pace, from anywhere in the world. Practical Insights: Gain real-world insights and case studies to enhance your understanding of cargo inspection challenges and solutions. Certification: Upon successful completion of the program, receive a recognized advanced diploma as an Expert in General Cargo Inspection. Take the Next Step : Ready to elevate your cargo inspection expertise? Enroll now and join our community of skilled professionals dedicated to excellence in cargo inspection. 🌐 Why Choose Us ? Our commitment to excellence, coupled with a history of successful alumni, makes us the perfect choice for your maritime education. Enroll today and set sail towards a brighter future in the maritime world!

Oracle SQL training course description The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create SQL statements to query database tables. Use standard aggregate functions and related SELECT statement clauses. Join Tables. Use basic subqueries and the set operators. Use numeric, character and date functions. Use conversion and other miscellaneous functions. Use SQL parameters. Use complex subqueries. Create and alter tables and views. Insert, update and delete rows in database tables. Manage sequences and synonyms. Oracle SQL training course details Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. Prerequisites: None. Duration 3 days Oracle SQL training course contents Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.

Supporting Microsoft SQL server course description A concise hands on course enabling delegates to manage and administer a Microsoft SQL server database. What will you learn Install SQL server. Backup SQL server databases. Recover SQL server databases. Secure SQL server databases. Perform routine maintenance. Automate tasks. Supporting Microsoft SQL server course details Who will benefit: Anyone working with Microsoft SQL server Prerequisites: Supporting Windows server. Duration 3 days Supporting Microsoft SQL server course contents SQL server introduction Platform, Tools, services. Installation. Creating databases. Backups Back up types, transaction logging, restoring from a backup: Full database, individual files. Security Users, server roles, database roles. Permissions. Monitoring Routine database maintenance. Performance data. Jobs and alerts The SQL server agent, database mail, alerts, jobs.

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.

Database fundamentals training course description This three-day training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. What will you learn Describe core database concepts. Create database objects. Manipulate data. Describe data storage. Administer a database. Create a relational database consisting of 3 related tables. Database fundamentals training course details Who will benefit: Those working with databases. Prerequisites: None. Duration 3 days Database fundamentals training course contents Understanding core database concepts Flat-type databases, hierarchical databases, relational databases, database fundamentals, relational database concepts, using the SQL Server Management Studio Interface. Data Manipulation Language (DML), Data Definition Language (DDL), using DDL statements. Creating database objects Defining data types, using built-in data types, using exact numeric data types, using approximate numeric data types. Creating and using tables. Creating views. Creating stored procedures, SQL injections. Manipulating data Using Queries to select data, combining conditions, using the BETWEEN clause, using the NOT clause, using the UNION clause, using the EXCEPT and INTERSECT clauses, using the JOIN clause. Using Queries to insert data, Inserting data. Updating data and databases, Using the UPDATE statement. Deleting data, Using the DELETE statement, truncating a table with TRUNCATE TABLE, deleting a table with DROP TABLE, using referential integrity. Understanding data storage Normalising a database, normalization, first normal form, second normal form, third normal form, fourth normal form, fifth normal form. Primary, foreign and composite keys, clustered and non-clustered indexes, creating a non-clustered table. Administering a Database Securing Databases, server-level security, database-level security, Windows security, SQL authentication, database server roles, granting access to a database, fixed database roles, object permissions, managing roles, ownership chains, reviewing a sample security model. Backing up and restoring databases, recovery models, backup devices.