549 Courses

This workshop gives you the unique opportunity to experience the basics of two crafts in 1 day in your own personal pairs workshop with one to one tuition. The studios are located in the cottage garden of our home on the Cambridgeshire/Norfolk border. Your experience is private to you and there will be no other students in the studios. The "2 crafts in 1 day" workshop is aimed at those who want to have a go at both of these fun crafts, and come away having learnt some basic techniques for both disciplines. As this is basically a private tuition experience, the course is focused but fun, so would make a fantastic gift. The day can also be experienced by just 1 person (to book this, please refer to our other workshop ""2 Crafts in 1 Day!" 1-2-1 woodturning & pottery experience in 1 day for 1 person" where each person could experience the crafts singularly or together.  This makes for a wonderful Valentine's or anniversary experience, and can also be enjoyed by a parent and child. The morning is spent learning the ropes of woodturning - how to cut and shape wood on the lathe, understanding a little about the different tools required, and making a few pieces to take home. After a light farmhouse-style lunch (which we provide and which we tailor to your dietary requirements), the afternoon then continues with a pottery session. Students can have fun with clay, focusing on some basic hand building methods to get them used to handling the material using the techniques of pinching, coiling, slab building and also throwing on the wheel.  A total of 3 pieces can then be chosen for us to glaze and fire once they have dried sufficiently. When ready, they can either be collected by the student (if they live locally) or I can post them on (I have to charge postage & packaging). Refreshments are provided during both workshops, and a light, rustic farmhouse-style lunch is also included - catering to all dietary requirements. Depending on the weather/time of year, lunch can be taken either out in the cottage garden or in our country kitchen. The sessions are hands-on with expert 1-2-1 tuition - and the student will be able to use all the studio facilities. Each student will also be provided with a certificate of participation for both crafts. About a week before your workshop date, we'll e-mail you again with more details about parking etc. We also offer accommodation in the form of our Crafter's Retreat cabin (www.craftersretreat.co.uk) or we can advise of other local B&Bs.

Learn to crochet, learn the basic stitches to get you started. Hook and yarn included.

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!

Make your own willow stars, enjoy an evening workshop of willow weaving with homemade cakes.

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.

When we come together to make SoulCollage® in community, amazing things happen. There is a magic in this creative journey that only requires you coming along with your curiosity and imagination. No artistic genius recquired whatsoever. Just your presence! Images have things to say to us. They can call us through our hearts, our instinctual knowing, and our open intuitive minds. Images offer us portals and openings into a deep wisdom stream. All you need to do is be open to the images that are asking for your attention. Then you make a collage, then you listen to what it wants you to know. It is simple, and profound. This is an in place event in a creative studio in the delightful village of Hartley Wintney. You might like to linger after we close and take a look at the local crafts and antique shops, or take a stroll around the village green just outside of where we will be for the day. It is really quite unique. Getting there: Esiliy accessible by the M4 and M3. There is free weekend parking close to the venue. The nearest train station is Winchfield. Here are some things people have said about a SoulCollage® session at The Soul Shed: "Loved this workshop, from start to finish it made my heart sing.  It was a feast for the soul with words and images that were crafted into something rich and deep for me" -J.E "What stood out for me was how it just happened ....one thing alchemised into another thing” - L.B "I'd describe it as a good way to reconnect with your creative side, relax and maybe gain insight into what is happening inside you" - D.F.

This year, we will be hosting our summer school Monday 31st July-Friday 4th August, 9am-4pm at our studio: GDA, Unit 16 Paper Mill End, B44 8NH. Each day, children will participate in a range of performing arts, including dancing, singing, drama and arts and crafts all around the theme of Roald Dahl's Matilda. We hope to put on a mini performance on the Friday afternoon which parents are invited to watch. This is open to ALL CHILDREN aged 6-13 years. The cost to members is £25 per day or £90 for all 5 days. Children should wear their own comfortable clothing and can either bring a packed lunch or pre-order a hot dinner for £2. Hot food must be requested at least 7 days prior to the summer school starting and will vary each day but be items such as pizza and chips / burger and chips / jacket potatoes etc. Places will be limited but, going by previous years, extremely popular. To secure a place, please contact us clearly stating which date/s you would like. Individual days must be paid in full at time of booking. If you would like to do all 5 days, we request 50% at time of booking with the balance due 14th July. 

Indulge in an Inspiration Day creative workshop at Beach Gallery to nurture your soul & awaken your creativity

An in person London based workshop to help you build Emotional Connection. Our approach is based on helping individuals to rebuild their immense and beautiful capacity for emotional intimacy while also encouraging & fostering personal and psychological safety. We use a set of exercises that are canonical in training actors to deepen emotional connection on stage and screen. You will feel empowered to open up and & become vulnerable with others. The exercises are emotionally ‘light’ and yet powerful. You will not be asked or required to share anything personal. We will work with your imagination, your powers of make believe and ‘creatively play’ in order to show you how you embody changes to help you connect truthfully and genuinely. Overall, the workshop is designed to grow emotional awareness and to provide you with the tools to enable trust, emotional resilience and an expanded capacity for vulnerability which you can use and apply to any relationship whether social, professional or more intimate.

A fun sewing class to create a chicken doorstop, perfect to give as a fun gift