26 Courses in Birmingham

Salsa or Latin Dance rhythm private class in London for couples or individuals to achieve a good knowledge of the Salsa, Samba, Bachata, Merengue or Latin dance steps One to One lesson, 5 minimum pack lesson booking. Taught by native instructor You can have this lesson at our premises, on Zoom, Pre-recorded or home visit, the choice is yours!!! The Program includes: 10 or 20 Lesson 1on1 lesson Walking & Leading techniques Female & Male Teachers Footwork & Upper body techniques Steps & routines names (brain method) Body posture and language Tempo & beat music technique Fully equipped dance studio Ownership of your footage work progress & Docs Music library via dropbox or Spotify Salsa or Latin Dance rhythm private class in London for couples or individuals to achieve a good knowledge of the salsa, samba, bachata, merengue or Latin dance steps One to One lesson, 4 minimum pack lesson book Teach by the native instructor We have been training people in salsa in London for almost 20 years and are still in business as salsa in west London is increasing massively.  SALE

If you got a call from a TV producer asking you to appear on Newsnight, would you say ‘yes’? And if you did, could you make your argument in a way that captured the attention of the audience without being interrupted? Our media training courses are aimed at senior spokespeople and experts who give interviews on TV, radio or in print. We equip them with the skills and confidence to take control and give engaging, memorable and effective performances in which they deliver their key messages, no matter what the circumstances. Highly interactive and practical, each course includes a series of realistic print, radio and television exercises with experienced journalists. We provide immediate feedback following each interview, including techniques for improvement, advice about potential answers and the framing of key messages. While all our media training courses are bespoke, on a typical course we will cover: how the media operates how to prepare for interviews the differences between TV, radio and print interviews how to conduct different types of interview, such as pro-active, reactive, expert commentator and hostile (crisis communications) developing key messages which convey your views persuasively how to take control of an interview, stick to your own agenda and deliver key messages successfully use of language, body language, dress and delivery After the course, each delegate receives the Rough House Media Toolkit, including written feedback, recorded copies of their interview exercises, the Rough House Media Guide to Interviews and further supporting materials. We also provide a confidential assessment to the PR team of each delegate’s suitability for different types of interview. Venue We deliver courses in the most appropriate format for your circumstances – whether face to face or online. Face to face courses are portable: they can be held in purpose-built studios, at your own offices or at an external venue. In the latter two cases, we create a mock studio for the practical exercises. Online courses give you flexibility and enable you to offer training to delegates from all over the world. We have run virtual courses for people from the Far East, South Asia, North America and Europe, as well as the UK.

Join our teenagers every Wednesday, 7:30-9pm at our studio for intense dance training. Each week we develop core strength and flexibility whilst working on Freestyle and Rock n Roll dance skills. Dancers are currently working towards various medals and graded exams but with a focus on the Level 3 certification for which there will be an exam in March 2024. Attendance requires membership at our academy with monthly fees (£21 per calendar month)

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. 

A relaxed and informal Blackwork Embroidery course in the lovely setting of a converted 18th Century cotton mill in Warwick Bridge, Carlisle. This course has been designed to guide the complete beginner or act as a refresher for those who may have dabbled in Blackwork embroidery in the past. We will cover the history, styles of Blackwork embroidery, threads and techniques.

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.

Start this class as a beginner and leave as a glass making addict. In this full-day workshop, you will learn each step of the glass blowing process from experienced and encouraging glassmaking experts in their inspiring studio!  With all of the materials, supplies and equipment needed to make your own glass provided in this workshop, learning to blow glass couldn’t be easier.  You will be part of a small group of 4-6 people with up to two tutors. Although you’re building your technical skills, there’s still room in this workshop for creativity- after all you're learning from top glass blowing artists! With all the colours you could dream of, get experimental and let your imagination take the reins to style your glass. In the beginning of this workshop, you will learn how to prepare different colour and texture techniques to apply to your glass pieces.  You will be able to make a bowl or paperweight and choose a final form from the following list of functional objects: - Drinking glass - Vase - Decorative bauble Master how to safely and confidently heat molten glass in a 1100 degree furnace which you will then gather and remove from the furnace using historical hand forged tools. Make sure you’re full of hot air for the next step! Once you have perfected removing your glass from the furnace, it’s time to learn how to sculpt and blow your own glass.  After a hard and hot graft it’s time to chill out! Cooling your glass is equally as fascinating and important as heating your glass, at the end of the workshop you will learn how to safely and properly cool your glass like a professional.  Many students learn best through a combination of demonstrations as well as a hands-on interactive teaching approach. This workshop is no exception! You will watch a demonstration then safely learn more about each step in the glass blowing process through having a go yourself. Not only will you get to take your three perfect and personalised glass pieces home at the end of the workshop, you will also be leaving with a full understanding of the glass making process and techniques as well as a burning hunger to create more gorgeous glass. What's included in the price? Although lunch in our full day course is included in the workshop, you’re welcome to bring along any food and drink with you or visit the on site cafe. It’s important to stay hydrated so make sure you bring along a bottle of water.  Cancellation policy Strict - Cancellation and a full refund can be obtained up to 8 weeks before the course starts

Francesca Wyllie (BA Hons Fine Art) has an amazing north-facing art studio at El Retiro in Andalucia, which was purpose-built to accommodate painting groups. Bespoke painting and sculpture workshops can be arranged or Francesca can travel locally to guide you in your own studios or locations.

Welcome to Pole Mission, the top pole dance studio in London. We offer a variety of pole dance classes, including beginner to advanced pole dancing lessons, pole fitness courses, and aerial hoop sessions. Our experienced instructors provide engaging and empowering workouts for all skill levels. Join us for pole dance classes, pole fitness in London, and specialized pole dance courses. Conveniently located in London, we provide a supportive environment to help you achieve your fitness goals. Experience the best in pole dance and aerial hoop at Pole Mission today!

We invite adults, children, complete beginners, and advanced pianists alike to join us at our studio on Baker Street for the finest and most comprehensive piano lessons London has to offer, thanks to a wonderful team of piano instructors. Please contact us for in-person or online lesson availability.