267 Courses in London delivered Live Online

This Business English tutoring course is designed to help adult learners improve their English language skills within a professional context. Participants will focus on developing their communication skills, vocabulary, and cultural understanding necessary for success in the business world. Through practical exercises, role-plays, and industry-specific materials, learners will enhance their ability to effectively communicate in English within various business situations.  Course Duration: 12 weeks (48 sessions) Course Objectives: By the end of this course, participants will: 1. Communicate confidently and effectively in English within a business setting. 2. Expand business-related vocabulary and improve language accuracy. 3. Develop listening skills to understand business conversations and presentations. 4. Enhance reading comprehension skills for business-related texts. 5. Write accurately and coherently for business correspondence. Course Outline: Week 1: Introduction to Business English - Introduction to course objectives, expectations, and methodology - Assessment of participants' current language proficiency and individual learning goals - Overview of key business English skills and areas of focus Week 2: Business Communication Skills - Developing effective oral communication skills for business settings - Role-plays and discussions related to common business scenarios - Enhancing fluency, clarity, and confidence in expressing ideas and opinions Week 3: Business Vocabulary Expansion - Expanding business-related vocabulary and terminology - Exercises and activities to reinforce and practice key business terms - Incorporating industry-specific jargon into oral and written communication Week 4: Business Writing Skills - Improving writing skills for business correspondence - Practice exercises for emails, reports, memos, and other business documents - Enhancing clarity, coherence, and professional tone in written communication Week 5: Listening and Comprehension in Business Contexts - Developing listening skills to understand business conversations, presentations, and meetings - Authentic listening materials related to various business topics - Strategies for note-taking, understanding accents, and extracting key information Week 6: Reading and Comprehension for Business - Developing reading skills for business-related texts - Strategies for skimming, scanning, and understanding complex business documents - Identifying main ideas, supporting details, and summarising key information Week 7: Business Presentation Skills - Developing effective presentation skills for business contexts - Techniques for organising content, engaging the audience, and delivering impactful presentations - Practice sessions with feedback and guidance Week 8: Business Negotiation Skills - Enhancing negotiation skills for business interactions - Role-plays and practical exercises for successful negotiations - Polishing language and strategies for effective business communication Week 9: Business Etiquette and Cultural Understanding - Understanding business etiquette and cultural nuances in professional settings - Developing intercultural communication skills for international business contexts - Practicing effective communication in diverse and multicultural environments Week 10: Business Networking and Socialising - Developing language skills for networking and socialising in business contexts - Role-plays and exercises for effective communication at conferences, events, etc. - Polishing conversational skills, small talk, and building professional relationships Week 11: Business Grammar and Language Accuracy - Reviewing and reinforcing essential grammar rules and structures in a business context - Identification and correction of common errors in business writing and speaking - Exercises and activities to improve language accuracy Week 12: Review and Final Evaluation - Reviewing course content and addressing individual needs - Comprehensive review exercises for all language skills in a business context - Final evaluation and feedback session Note: This syllabus serves as a guideline and can be customised based on the specific needs, interests, and proficiency levels of the participants. The course may also include guest speakers or industry-specific case studies to provide further immersion and practical application of language skills.

This very practical workshop is designed to enable participants to improve the impact, clarity and accuracy of their business documents - both internal and external.: This workshop will help participants: Identify the purpose of writing their documents - to themselves and to their readers Recognise and meet the needs of their readers Plan documents systematically and improve the layout, flow and structure Express the content more clearly, concisely and correctly Adapt the tone and style of writing to the circumstances Proof-read and edit work effectively, using formal marks and techniques Improve visual layout, format and appearance 1 Course objectives Welcome and Introductions The problems now - group discussion 2 Writing better business documents What points to highlight / exclude Starting off Introductions Conclusions Executive summaries 3 Rules and standards George Orwell's famous maxim Why write? - clarifying your aims and objectives A seven-step method for better preparation The three-stage process for writing well Grouping information for your reader 4 Proof-reading and editing The difference between proof-reading and editing Proof-reading methods and strategies Proof-reading marks and techniques Training your eye for detail Knowing what to look for 5 Effective editing Grammar and English standards Words - usage and spelling Sentences - units of thought Paragraphs - themes Punctuation - spotting and correcting common errors Say what you mean - active v passive language 6 How's your English? Grammar quizzes and punctuation test Spotting spelling errors Rephrasing jargons and clichés Common error's and mistakes 7 Document layout House style Use of white space Fonts and effects 8 One-to-one workshops These are practical sessions with one-to-one consultation with colleagues and the trainer They are held at key points to consolidate the learning from different sessions 9 Course summary Summary of key points Action plans

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins

https://www.patreon.com/moonhealinganddivination/membership

LOOKING FOR: ADULT FICTION, YA THRILLER Saskia Leach is a Junior Literary Agent at Kate Nash Literary Agency, where she has been working since 2021. She loves stories that features complex and dynamic characters and is fascinated by books containing document inserts or written from multiple perspectives. Saskia represents fiction for adults and young adults in the genres of crime, thriller, romance, historical/saga, horror, speculative and bookclub. She does not represent literary fiction, sci-fi, fantasy, non-fiction, action/adventure thrillers, non-fiction, picture books or chapter books for children younger than middle grade. Saskia is particularly looking for LGBTQIA+ romance, high concept psychological thriller with a unique hook or set in an unusual location, and bookclub fiction revolving around a moral dilemma - but she is open to reading submissions in all genres she represents. She is keen to hear from writers from underrepresented voices and perspectives. Saskia would like you to submit a covering letter, 1 page synopsis and the first 5,000 words of your manuscript in a single word document. (In addition to the paid sessions, Saskia is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice given in your Agent121. The submission deadline is: Tuesday 20th May 2025

Four weeks of revision exercises, study stories and feedback exchange for flash fiction authors.

Live online course with study materials and certificate of completion included This beginner's WordPress course will enable you to create your own website using the world's favourite content management system. The user friendly web based software enables you to quickly and easily get your website up and running. This one day course will teach you how to write, edit and manage your WordPress site and also to use image, audio and video content. Whether you are seeking to learn WordPress for your own personal posts or for business and marketing purposes this course will get you up and running right away. Resources Introduction to WordPress Description Completing this course will enable you to do the following and more: Become familiar with the WordPress CMS Install and configure WordPress Manage WordPress themes Understand the WP interface and the dashboard Add users and assigning different user roles Set-up reading options Create, add, update and assign menus Understand Posts and Pages Edit and format content Use the Gutenberg block editor Create and manage your homepage Carry out customisations Understand SEO optimisation For the full course content please download the course information pdf listed above. Who is this course for? This workshop is suitable for anyone with basic PC or Mac skills who wishes to learn how to create and manage websites with WordPress. No previous knowledge or experience of WordPress is necessary. Requirements Attendees should have basic PC or Mac skills. You will need a broadband internet connection to participate in this live online course. Certificates Certificate of completion Digital certificate - Included

This level is the first step for any person who is interested in learning the English language. It is especially useful for students who have never had any sort of experience in studying the language or those who have a very basic knowledge and understanding of the language.   

Take your knowledge to the next level with EnergyEdge course on Layer of Protection Analysis (LOPA). Enroll now to advance your career.

PYTHON BOOTCAMP: This 12-week Python Data Analytics Data Boot Camp is designed to give you a complete skill set required by data analysts . You will be fully fluent and confident as a Python data analyst, with full understanding of Python Programming. From Data, databases, datasets, importing, cleaning, transforming, analysing to visualisation and creating awesome dashboards The course is a practical, instructor-lead program.