228 Courses in London

Discover the golden art of Kintsugi. The perfect answer to fixing or upcycling sentimental pottery. Whether it's your favourite cup or your Nan's best vase, during this uplifting pottery workshop, we'll take you on a step-by-step journey to fix or upcycle pottery using gold metallic lacquer that is visible and beautiful. Loosely translated, Kintsugi means 'golden joinery' that highlights your object's events rather than disguises them. It can also be seen as a variant of "Waste not, want not".  All materials and tools are provided to fix one piece of ceramics per person across 1.5 hours. You can bring your own broken pottery or we have some pottery ready for you to upcycle and take home. You don’t need any experience, as your guide will be on hand with plenty of one-to-one support, letting you switch off from the world to focus entirely on yourself and follow your mind, body and spirit during the session. At the end of this Kintsugi class in London, you'll have a beautiful piece of pottery, along with a new skill to continue developing in your own time! Good to know: All workshops take place at AC Studios, CC1 Studio 2, Trinity Buoy Wharf, E14 OJW Group workshop of up to 10 people All materials and tools are provided to fix one piece of ceramics per person across 1.5 hours that you can take home there and then. Feel free to bring your own broken pottery otherwise, we have some pottery ready for you to upcycle and take home. Ideal for anyone & everyone no matter your experience but persons under 18 years of age must be accompanied by a paying adult By purchasing it will imply you have read & understood our t&c’s. If you have any questions please feel free to contactus. Otherwise we look forward to welcoming you in the studio.

LEATHER CRAFT AND LEATHER SEWING TECHNIQUES: WHAT IS THIS COURSE ABOUT? This is a theoretical and practical introductory group tuition during which you will be taught common, essential leather crafting and sewing techniques and understand how working with leather differs from working with vegan leather or fabric.You will be taught how to correctly use hand tools, how to sew leather by hand and understand the most common finishing and construction techniques used in bag and accessory making. You will learn about different types of leather and understand how to select the correct type of material(s) for your project. You will receive an overview of the technical aspects of working with leather and constructing bags and accessories such as inking, burninshing, marking, cutting, gluing, reinforcing, skiving, debossing and more.You will learn how to saddle stitch, select the appropriate tools for this sewing technique, and produce your own samples of work to take home with you.You will receive relevant, useful and informative handouts as well as lists of leather and tool suppliers. At the end of the lesson, you will have the choice to create a simple hand-sewn leather item, such as a simple purse or card holder, to take home with you, or to practice more techniques.This is a professional course delivered by a prototype maker and manufacturer, with the aim of providing an overview and hands-on experience on more common leather working practices. At the end of the tuition you will have: – Gained an understanding of leather types, tanning methods, leather characteristics and the best uses for specific projects. – Gained confidence in using specific tools for preparing, marking, finishing, cutting leather and fastening fittings. – Understood and practiced leather craft techniques such as inking, beveling and burnishing techniques – Understood what it means to work with different leather types and thicknesses and have the ability to source and select the correct tools and materials for your projects. – Understood how to manipulate leather using tools, reinforcement, stabilisers and stiffeners in crucial areas of bags and accessories. – Gained confidence in sewing by hand and obtained the skills to realise some simple leather items independently. WHAT WILL BE TAUGHT?Below is a list of topics covered during the classes: LEATHER, VEGAN LEATHER AND HAND TOOLS: – Understanding leather: overviews on types of leather, tanning, finishings and best use– Vegan leathers: an overview on different types and features – Understanding how to choose the right materials for your project and the appropriate tools for those materials – Leather preparing, pattern placement and marking on leather – Cutting complex shapes using a variety of tools – Using leather punches – Understanding the use of skiving, beveling and creasing – Finishing leather edges: painting vs burnishing – Using various leather glues and tapes – Understand the use of reinforcements, fusings and stabilisers to back leather – Prototyping and manufacturing leather goods: mentions of different working methods, machines and tools HAND SEWING: – To understand the different options, characteristics, and proper application of the tools used in saddle stitching – To learn the basics of saddle stitching leather and understood the different the tools and materials used in the technique CONSTRUCTION TECHNIQUES: – To create a small, simple hand stitched leather item to take home with you INCLUDED IN THE COURSE: You will be provided with useful digital and paper handouts which contain:– A list of tools and materials used during the lesson(s), including a description of what they are and how they are used– A list of recommended suppliers for both leather and fittings (physically in London and online)– A glossary containing essential key words related to the topic of the lesson– A glossary containing information about leather types and characteristics WHAT ARE THE ENTRY REQUIREMENTS?This course is suitable for total beginners, beginners with some experience and intermediate.You should be able to use measurements and understand verbal and written English instructions.   ARE THERE ANY OTHER COSTS? IS THERE ANYTHING I NEED TO BRING?Materials are included.Feel free to bring a notepad, if you would like to take some notes, we will provide the rest. HOW LONG IS THIS TUITION?:This tuition will require up to 12 hours to complete. We aim to provide customised and high quality tuition services and by only allowing up to 6 students at a time, we are able to focus on each person needs and interests.As every student has a different level of ability and previous experience, this course might lead some students to complete the core aspects of the lesson in a shorter time frame than others.Students who complete the course early will be welcome to stay and use the studio facilities to exercise on the topics of the lesson.

We would like to welcome you to a creative Saturday afternoon with our team and hand build up to three pieces in our creative studio in Angel. No prior knowledge or skills are required.  What is included:  Instructions and guidance by our team members Sculpting kit and tools A variety of flowers and greenery to choose from for your creative imprints Glass of bubbly or floral lemonade and light refreshments Fun and relaxing start to your weekend It is a small class so we can pay attention and guide you all the way through the class. We will fire your pieces and they will be ready for collection in about three weeks after the class.

We would like to welcome you and your little one to a creative Saturday afternoon with our team and hand build up to three pieces in our creative studio in Angel. No prior knowledge or skills are required.  What is included:  Instructions and guidance by our team members Sculpting kit and tools A variety of flowers and greenery to choose from for your creative imprints Floral lemonade and light refreshments Fun and relaxing start to your weekend It is a small class so we can pay attention and guide you all the way through the class. We will fire your pieces and they will be ready for collection in about three weeks after the class.

https://www.instagram.com/masterpeacelondon/

Hello to all our fabulous dancers out there! Welcome to our Glamorous Strides Heels Dance Class, a class designed to sprinkle a dash of confidence and a whole lot of sass onto your dance journey. Lacing up your heels for this class is completely optional - but bringing your vibrant energy and giving it your all is non-negotiable! As we explore a dazzling array of poses and dance techniques, you'll also be learning some irresistibly fun and seductive choreography that's guaranteed to turn heads. If you love our energy and are ready to embark on an exhilarating journey of discovery and exploration, we can't wait to see your radiant smiles and determined spirits in our upcoming Heels Course. Here's a glimpse of what you'll begin to master in our Glamorous Strides class: Dance Technique & Flexibility: We'll sharpen your dance techniques and improve your flexibility, making every move look effortlessly graceful. Walking & Balancing in Heels: If you choose to wear heels, we'll teach you how to glide across the dance floor with poise and balance. Posing Techniques: Strike a pose! Learn how to accentuate your movements and exude confidence with our expert posing techniques. Stretching: Proper stretching is crucial in dance, and we'll ensure you learn how to do it right, promoting flexibility and preventing injury. Choreography and Performance: Last but not least, you'll learn captivating choreography and the art of performance, imbuing every dance with your unique style and charisma. So, ready to strut, spin, and unleash your inner diva in our Glamorous Strides Heels Dance Class? We can't wait to welcome you to the studio, ready to sparkle and shine on this exciting dance journey. Remember, heels dance is all about confidence, expression, and most importantly, having a fantastic time on the dance floor. Let's strut, spin, and let our spirits shine together in Glamorous Strides! See you in the studio!

Intermediate Ballroom Courses

Advanced Ballroom Courses

Beginner Ballroom Course Waltz, Rumba, Cha-cha, Foxtrot, Tango, Jive

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.