155 Courses in London

Our children’s performing arts classes provide a fun and engaging environment for kids to explore their creativity and develop their skills in dance, music, and theater. With experienced instructors and a supportive community, our classes help children build confidence, express themselves, and discover their passion for the arts.

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

Facilitated by Registered Clinicians with extensive experience

About this Virtual Instructor Led Training (VILT) The 5 half-day Piping Stress Engineering Virtual Instructor Led Training (VILT) course will systematically expose participants to: The theory and practice of piping stress engineering, with special reference to ASME B 31.1 and ASME B 31.3 Standards. The basic principles and theories of stress and strain and piping stress engineering, through a series of lessons, case study presentations, in-class examples, multiple-choice questions (MCQs) and mandatory exercises. Principal stresses and shear stresses which form the backbone of stress analysis of a material. Expressions for these quantities will be derived using vector algebra from fundamentals. Thermal stress-range, sustained and occasional stresses, code stress equations, allowable stresses, how to increase flexibility of a piping system, cold spring. The historical development of computational techniques from hand calculations in the 1950s to the present-day software. Training Objectives On completion of this VILT course, participants will be able to: Identify potential loads the piping systems and categorise the loads to primary and secondary. Determine stresses that develop in a pipe due to various types of loads and how to derive stress-load relationships, starting from scratch. Treat the primary and secondary stresses in piping system in line with the intent of ASME Standards B 31.1 and B 31.3 and understand how the two codes deal with flexibility of piping systems, concepts of self-springing and relaxation/shake down, displacement stress range and fatigue, what is meant by code compliance. Understand the principles of flexibility analysis, piping elements and their individual effects, flexibility factor, flexibility characteristic, bending of a curved beam and importance of virtual length of an elbow in the flexibility of a piping system. Learn stress intensification factors of bends, branch connections and flanges. Understand how the stresses in the material should be controlled for the safety of the piping system, the user and the environment. Examine how codes give guidance to determine allowable stresses, stress range reduction due to cyclic loading, and effects sustained loads have on fatigue life of piping. Confidently handle terminal forces and moments on equipment. Understand the supplementary engineering standards required to establish acceptance of the equipment terminal loads and what can be done when there are no engineering standard governing equipment terminal loads is available and learn the techniques of local stress analysis. Get a thorough understanding of the concepts and the rules established by the ASME B 31.1 and ASME B 31.3 Standards. Perform flange load analysis calculations based on Kellogg's Equivalent Pressure method & Nuclear Code method. Perform the same using a piping stress analysis software and check for flange stresses and leakage. Confidently undertake formal training of piping stress analysis using any commercial software, with a clear understanding of what happens within the software rather than a 'blind' software training and start the journey of becoming a specialist piping stress engineer.   Target Audience The VILT course is intended for: Recent mechanical engineering graduates who desire to get into the specialist discipline of Piping Stress Engineering. Junior mechanical, chemical, structural and project engineers in the industry who wish to understand the basics of Piping Stress Engineering. Engineers with some process plant experience who desire to progress into the much sought-after specialist disciplines of Piping Stress Engineering. Mechanical, process and structural engineers with some process plant experience who desire to upskill themselves with the knowledge in piping stress engineering and to become a Piping Stress Engineer. Any piping engineer with some pipe stressing experience in the industry who wish to understand the theory and practice of Piping Stress Engineering at a greater depth. A comprehensive set of course notes, practice exercises and multiple-choice questions (MCQs) are included. Participants will be given time to raise questions and participants will be assessed and graded based on responses to MCQs and mandatory exercises. A certificate will be issued to each participant and it will carry one of the three performance levels: Commendable, Merit or Satisfactory, depending on how the participant has performed in MCQs and mandatory exercises. Training Methods The VILT course will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total). Trainer Your expert course leader is a fully qualified Chartered Professional Engineer with over 40 years of professional experience in Oil & Gas (onshore and offshore), Petrochemical and Mining industries in engineering, engineering/design management and quality technical management related to plant design and construction. At present, he is assisting a few Perth based oil & gas and mining companies in detail engineering, piping stress analysis, feasibility study and business development work related to plant design. He is a pioneer in piping stress engineering in Western Australia. His recent major accomplishments include the following roles and challenges: Quality Technical Support Manager of USD 54 billion (Gorgon LNG Project). This encompassed management of quality technical services connected with Welding, Welding Related Metallurgy, Non-Destructive Examination, Insulation /Refractory /Coating, AS2885 Pipelines Regulatory Compliance and Pressure Vessel Registration. Regional Piping Practice Lead and Lead Piping Engineer of Hatch Associates. In this role, he was responsible for providing discipline leadership to several mining projects for BHP Billiton (Ravensthorpe), ALCOA-Australia (Alumina), Maáden Saudi Arabia (Alumina), QSLIC China (Magnesium), COOEC China (O&G Gorgon). He was actively involved in the development of piping engineering practice in WA, including training and professional development of graduate, junior and senior engineers. This also includes the formation of the Piping Engineering Specialist Group. Lead Piping/Pipe Stress Engineer on ConocoPhillips' (COP) Bayu Undan Gas Recycle, Condensate production and processing platform. He was able to develop several novel design methodologies for the project and provided training to engineers on how to implement them. These methodologies were commended by COP and the underwriters of the project Lloyds Register of Shipping, UK. Creator of Piping Engineering Professional Course aimed at global engineering community. Professional Affiliations: Fellow, Institution of Mechanical Engineers, UK (IMechE) Fellow, Institution of Engineers, Australia (EA), National Register of Engineers (NER) Member American Society of Mechanical Engineers, USA (ASME) Honorary Life Member, Institution of Engineers, Sri Lanka (IESL)   POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

This 2 - 2-5 hour course is designed is designed to provide parents and carers with the opportunity to: Develop the basic skills and knowledge needed to deal with a wide range of emergency paediatric First Aid situations, which could arise when looking after babies and children. The course can take place in in a community group or in the comfort of your home, with family and friends who maybe caring for your child or they may have children of their own. The course can be booked during the week, week nights or weekends, with or without children present. The idea is to bring the skills and knowledge to you, in your normal routine.

Measuring Observations Training is facilitated by Registered Clinicians with extensive experience

Join us at our special fundraiser event to celebrate Blankets for London 2023 and support us for next year! Craft Forward Christmas Party celebrating Blankets for London 2023 🌟 Date: Sunday 17th December 2023 🕔 Time: 5pm - 8pm 📍 Location: 3Space International House, 6 Canterbury Crescent, SW9 7QD Craft Forward invites you to a heartwarming celebration of Blankets for London 2023 and all the remarkable achievements we've accomplished together. This fundraising event will be an evening of creativity and community as we come together to celebrate what we have accomplished so far and to fundraise for Blankets for London 2024. Two awards to be won: 🧶 Creative Champion Award: Be prepared to applaud the artistic minds behind our cosy blankets! We will be awarding one creative champion for their exceptional contribution in crafting the most squares for Blankets for London this year. 🧣 Wear Your Creations Award: Show off your handmade creations by wearing your beautifully crafted garments, accessories, and more. The event is your runway, and we're giving away a prize for the best-dressed individual! You'll be able to silently vote through the evening for your favourite outfit. A very special raffle: Feeling lucky? Participate in our special raffle for a chance to win a luxurious blanket kit from Wool and the Gang. It's a knitting and crocheting enthusiast's dream come true, and every penny raised through the raffle will contribute towards Blankets for London 2024. BYOC (Bring Your Own Craft): Of course this wouldn't be a Craft Forward event without some crafting! Bring your work in progress, your most recent finished project, the handmade object you're most proud of. Every penny raised during this event goes towards funding Blankets for London 2024, helping us continue our mission of spreading warmth and love to those most vulnerable in our community. Join us for a memorable evening of warmth, creativity, and community: let's craft a brighter, warmer future, one stitch at a time! Tags United Kingdom Events Greater London Events Things to do in London London Parties London Seasonal Parties #social #networking #party #art #craft #fundraiser #knitting #crochet #christmas #forward

Develop true expertise with our DMI Specialist, Learn social strategy, research and content from industry Skills Experts. Get the latest platform knowledge and strategies including Tik-Tok, Twitch and WeChat. Course Overview Develop true expertise and learn every aspect of Social Media Marketing across 10 modules of interactive content such as Facebook, LinkedIn, Snapchat, YouTube and Instagram. Gain relevant and deep knowledge of social strategy, research and content from industry skills experts. Become a certified social media marketing specialist: Join over 200,000 members around the world, working for some of the world’s top companies using DMI to keep their careers and skills relevant. 81% of our members have been promoted upon completion of one of our courses and 53% have got a salary increase. Get certified with the DMI SPECIALIST digital marketing certification and become a professional digital marketer. Get world class, specialist knowledge and insight: Develop true expertise with our DMI Specialist, Learn social strategy, research and content from industry Skills Experts. Get the latest platform knowledge and strategies including Tik-Tok, Twitch and WeChat. With 10 modules focused on every aspect of social media marketing, DMI Specialist is the most comprehensive Social Media Course available anywhere. Program learning outcomes and content: What Will I Learn? Get the know-how, experience and the insights to be able to work and speak with authority in this face-paced industry. In short, you’ll be a skilled digital marketer, capable of building digital marketing strategies from scratch. We’ve added 8 new soft skill lessons to give you the most industry ready certification available, anywhere. Who is this for? The DMI Specialist Social is for individuals who are responsible for social media marketing campaigns. This includes: • Digital marketing generalists • Marketing Specialists • Marketing Managers • Content creators • Social media consultants • Individuals pursuing profession in social media marketing. • Anyone who wants a career change Course Content: Social Research: Just who are your audience? What do they do, think, feel, eat, love, hate and ‘like’? And what do they think about you? Knowledge is power. And both knowledge and power are fascinating. This module gives you the research techniques to know your audience, and cultural and industry trends. Every day the very people you want to reach throw up gigantic amounts of data. Without the right tools and thinking, it’s a critical mass of meaningless banality. With the right tools and thinking, you have insight deep into hearts and souls. Delve into these tools and put them to use, including the new Google Analytics 4 platform. Social Content: Facebook kittens. Twitter debates. Instagram filters. People can’t get enough content on social media – so better content means better opportunities. So, what does your audience want to see, like and share? With streamlined planning, clever strategy and targeted scheduling, putting the right content in front of the right people is no longer a shot in the dark! Now, you can create amazing content formats that capture the attention of audiences across all social platforms. You can strategize and plan using cutting-edge tools that make your channels stand out from all the others. This module covers the various content formats across platforms, the power and practice of scheduling content and how you can bring it all together with super strategies. Facebook, Instagram and Pinterest: Facebook, Instagram and Pinterest are powerhouses of the social media world. They provide you and your brand with the chance to interact with your customers across the globe at scale. But, each of them has unique features, analytics, and quirks. The module gives you a deep understanding of how these platforms work, how to make your brand stand out in these different spaces, and why you need a spread of messaging across each to succeed. • Build an active, engaged and captive community across each channel. • Create compelling and clever ads that target your audience at the right time. • Use analytics to understand what your audience is doing. Then tweak your content to resonate in all the right ways. • Master the key features of each channel to advertise, strategize and optimize. • Manage each platform so you get the best reach and results. • Reach billions of social loving people every day! Twitter: Twitter marches to its own drum in the social media world – less post and wait, more what’s happening right now. It’s a platform that allows your audience to see, report and comment on world events in almost real-time. It’s also a place where the audience is young, wealthy and educated. Twitter literally challenges you to be ‘more clever’, and this module shows you how. • What a successful Twitter account looks and acts like. • How to use Twitter Ads Manager to advertise effectively. • The right Twitter Ad format for your campaign. • Using Twitter Analytics to react and connect better. • How to create more Tweet-friendly content – snappy, shareable and short. • When to post for maximum impact and engagement. LinkedIn: This module will introduce you to the platform and show you how to use features such as Company pages and Showcase pages, to create a stellar presence for your company – and gain a deep understanding of what that means on LinkedIn. You will understand the unique advertising features and content formats on offer such as Text ads, Sponsored ads, Sponsored InMails, Display ads, and the aptly named Dynamic ads. See what best practice means on this platform, strategize like a CEO and measure the effectiveness of your campaigns. Linkedin can be a tricky platform to master as the tone is hard to crack. But do Linkedin well and your competitors will be scrambling to copy you! You’ve got this – because we do. YouTube & Social Video: YouTube because you have eyes to see. And a picture speaks a thousand words – and this being social, should inspire a few thousand too. Social video is one of the most awesome tools in your new bag of digital tricks. And video is no longer the preserve of guys with film study degrees. This superpower is now yours, and here we give you all the tech and thought basics to make it happen, including how to set up and manage a YouTube channel and create strategies that don’t treat creativity like a buzzword. Learn how video sits within the rest of your mix across platforms, build your online audience and use advertising and analytics for visual campaigns that mesmerise. • Set up and manage a dynamic YouTube channel. • Get creative with social video strategies that engage and convert. • Learn how video sits within the rest of your social media mix. • Build and develop your online audience in a way that benefits your brand. • Use advertising and analytics to deliver mesmerizing visual. Social Apps: If you’re looking to create a buzz online, then social apps are the place to be. Think fun, engaging, and ‘out of the box’ as that’s what these platforms are made for and audiences flock to them (particularly a young demographic). Discover how to use TikTok, Snapchat, WeChat, WhatsApp, and Twitch to tune into your audience effectively. Take a dive into features and understand how to manage content to make the most of everything you post. You’ll also understand how to advertise on the apps that suit your brand. Plus, take inspiration from the best by seeing what campaigns worked and why, so you can TikTok your way to social success. Social Commerce and Affiliate Marketing: With so many eyes on social media, it pays (literally) to know how to market and sell your products online. Social commerce happens when an astute marketer combines the best of social media with the best of e-commerce. You’ll explore the ins and outs of social commerce along with how to create a successful online shop. The latest tactics and tools will be covered so you can make social buying seamless from the first click to the last. You’ll also explore how to optimize paid commerce activity – including cart abandonment – to get the best results. Looking for a way to earn extra money while you grow? Use your social media to tap into affiliate marketing – a great way to earn commission by promoting another company’s products or brand you admire. When it comes to influencing, social media allows you to think BIG. Tap into the world of social influencers by connecting and collaborating with people that think like you. Or reach out to your influencer crush and shine a light on your brand by getting into their social feed. Social Customer Service: One of the best dynamics of social media is how it manages to be collective – the thoughts of billions – yet also personal (it’s about what I ‘like’). This leaves scope for important personal interaction – meaning social customer service is an opportunity for your brand to stand out. This module examines the customer experience. It looks at how to break your audience down into buyer personas so you know them better – and so serve them better. It shows you which platforms do service best and how. Need a social customer service strategy? – no problem. Want to understand how to manage social customer service effectively? – that’s easy. Not sure how to measure and analyze customer service performance? – well, you will now! This module focuses on your customer’s happiness so you can build a contented online community. An audience that feels connected to your brand, so they’ll tell everyone else how great it really is. Social Strategy: So, you have the skills, tools, followers, know-how, tech, smarts and big ideas. Now learn to tie it all together with cutting-edge social strategies practiced by the world’s leading brands. And work out how your social offering sits with – or carries – the rest of your marketing mix. Here we look at planning a dynamic social media strategy that works for you. We dive into setting objectives and social KPIs so you know what you want and can track how you’re getting there. Social media and content production budgets are also explored so you put your money in the places that work, rather than those that don’t. Turn your social media dream into a reality by crafting a social strategy that lets you and your brand sparkle. DURATION 8-10 Weeks WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

Facilitated by Registered Clinicians with extensive experience

Safeguarding Protection Safeguarding and protection Child protection Vulnerable adults Abuse prevention Neglect prevention Exploitation prevention Identifying abuse Reporting abuse Case studies on safeguarding Safeguarding training Recognizing signs of abuse Preventing abuse and neglect Safeguarding course with case studies