Name: OPEN DAY 2024 Calligraphy demo
Availability: InStock

Edinburgh

<div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><section fr-original-style="" style="box-sizing: border-box;"><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><section fr-original-style="" style="box-sizing: border-box;"><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><section fr-original-style="" style="box-sizing: border-box;"><div style="color: rgb(31, 39, 68); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(31, 39, 68);"><section fr-original-style="" style="box-sizing: border-box;"><h1 style="color: rgb(14, 32, 111); box-sizing: border-box;" fr-original-style=" color: rgb(14, 32, 111);"><span style='color: var(--text); font-size: var(--font-size); background-color: transparent; font-family: "SF UI Text", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; box-sizing: border-box;' fr-original-style='color: var(--text); font-size: var(--font-size); background-color: transparent; font-family: "SF UI Text", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol";'>This class will allow bookings from 11th August when the 20% Discount code goes live! Join the waiting list to be first to book your space! Discount Code - BOOGIEBEATSCOT</span></h1></section></div><div style="color: rgb(31, 39, 68); box-sizing: border-box;" fr-original-style="color: rgb(31, 39, 68);"><section fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is a very special class taking place in the lounge of Queens Manor Care Home. We maybe joined by some residents for these classes bringing a fantastic intergenerational opportunity.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is a mixed age class so babies from 6 months to age 5 welcome, making it perfect for siblings and childminders too.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Join Mairi and Giggles the Boogie Beat Monkey for an interactive and fun Boogie Beat classes. Singing, dancing, classical fairy tales and stories and much more!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Spend quality time with your little one whist supporting their learning and development.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">If you cannot see a ticket type to suit your needs (ie multiple children) please get in touch directly with me at mairicurle@boogiebeat.co.uk. Childminder Discount is available, please email me directly for more information.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"></p><br fr-original-style="" style="box-sizing: border-box;"></section></div><div style="color: rgb(31, 39, 68); box-sizing: border-box;" fr-original-style="color: rgb(31, 39, 68);"><h3 style="color: rgb(14, 32, 111); box-sizing: border-box;" fr-original-style=" color: rgb(14, 32, 111);">What you need to bring</h3><div style="color: rgb(14, 32, 111); box-sizing: border-box;" fr-original-style=" color: rgb(14, 32, 111);">Blanket for non walking babies to sit on.</div></div><div style="color: rgb(31, 39, 68); box-sizing: border-box;" fr-original-style="color: rgb(31, 39, 68);"><section fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(14, 32, 111); box-sizing: border-box;" fr-original-style=" color: rgb(14, 32, 111);">Dates and times</h3></section><p style="color: rgb(14, 32, 111); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(14, 32, 111);">6th Sep - 27th Sep</p></div></section></div></section></div></section></div><div style="color: rgb(31, 39, 68); box-sizing: border-box;" fr-original-style=" color: rgb(31, 39, 68);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(31, 39, 68); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(31, 39, 68);"><section fr-original-style="" style="box-sizing: border-box;"><h1 style="color: rgb(14, 32, 111); box-sizing: border-box;" fr-original-style=" color: rgb(14, 32, 111);">Intergenerational Boogie Beat Mixed Age Sept</h1><h2 style="color: rgb(14, 32, 111); box-sizing: border-box;" fr-original-style=" color: rgb(14, 32, 111);">By <a data-cy="supplierLink" href="https://activities.bookpebble.co.uk/supplier/78004c88-d067-41c7-b83d-ec5b637d6772" style="color: rgb(67, 120, 255); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(67, 120, 255);">Boogie Beat Music and Movement Edinburgh</a></h2></section></div><div fr-original-style="" style="box-sizing: border-box;"><section style="text-align: center; box-sizing: border-box;" fr-original-style="text-align: center;">Queens Manor Lounge, Queens Manor Care Home Lounge 565 Queensferry Road, Edinburgh, EH4 8DU</section></div><div style="color: rgb(31, 39, 68); box-sizing: border-box;" fr-original-style="color: rgb(31, 39, 68);"><br fr-original-style="" style="box-sizing: border-box;"></div>

This class will allow bookings from 11th August when the 20% Discount code goes live! Join the waiting list to be first to book your space! Discount Code - BOOGIEBEATSCOT

This is a very special class taking place in the lounge of Queens Manor Care Home. We maybe joined by some residents for these classes bringing a fantastic intergenerational opportunity.
This is a mixed age class so babies from 6 months to age 5 welcome, making it perfect for siblings and childminders too.

Join Mairi and Giggles the Boogie Beat Monkey for an interactive and fun Boogie Beat classes. Singing, dancing, classical fairy tales and stories and much more!

Spend quality time with your little one whist supporting their learning and development.

If you cannot see a ticket type to suit your needs (ie multiple children) please get in touch directly with me at mairicurle@boogiebeat.co.uk. Childminder Discount is available, please email me directly for more information.

What you need to bring
Blanket for non walking babies to sit on.
Dates and times
6th Sep - 27th Sep
Intergenerational Boogie Beat Mixed Age Sept
By Boogie Beat Music and Movement Edinburgh
Queens Manor Lounge, Queens Manor Care Home Lounge 565 Queensferry Road, Edinburgh, EH4 8DU

Boogie Beat Music and Movement Edinburgh

Toddler

Baby

For Kids

This class will allow bookings from 11th August when the 20% Discount code goes live! Join the waiting list to be first to book your space! Discount Code - BOOGIEBEATSCOT

This is a very special class taking place in the lounge of Queens Manor Care Home. We maybe joined by some residents for these classes bringing a fantastic intergenerational opportunity.

This is a mixed age class so babies from 6 months to age 5 welcome, making it perfect for siblings and childminders too.

Intergenerational Boogie Beat Mixed Age

This is for 1 child and their adult/s. Siblings under 1 year old attend free.

Standard Ticket

Childminder

Child Care

Family Friendly

Childminding

Daycare

Currie Mixed Age Fri Am

General Admission

Prestonpans

Pitman

Pennypit Thurs AM

London

An opportunity for boys & girls aged 5- 17 years to expand their knowledge & study various topics of Islam with our qualified & experienced teachers residing in the UK. The goal is to showcase to our youth to strive to live and act by the Qur'an & Sunnah.

Ilmul Atfaal Online

Islamic Studies Classes

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our Annual Open Day is the only time The Arienas Collective is open to the public. It is a great opportunity to visit our home-based workshop space, meet some of the artists and makers who run our workshops, find out more about all the workshops and courses we offer, and watch live, mini workshop demonstrations.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Opening hours</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Doors open at 12 noon and close at 6.30pm. Why not combine a visit to see us with a city centre shopping trip, or festive get-together. Edinburgh will be in full festive swing by then! We&#39;re hidden away in a quiet mews just a 10 minute stroll from the hustle and bustle of St James Quarter shopping centre, St Andrew&#39;s Square, George Street, Princes Street and Edinburgh&#39;s &#39;favourite village&#39;, Stockbridge. There are also plenty of independent shops, cafes, galleries and restaurants in nearby Broughton Street, Dundas Street, and St Stephen&#39;s Street.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Pop-up shops</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Some of our artists and makers also bring artworks and gifts to sell, often at special Arienas Open Day prices. The Arienas Collective creative gift kits, experiences, and gift vouchers will be available to buy on the day, with a special gift box offer. Card payments are preferred, however we will accept cash on the day - but please note we may have a limited supply of change available.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Free entry and refreshments - we welcome donations for our creative partner</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We will have complimentary mulled wine and mince pies on offer, and welcome donations for our 2024 creative partner. </p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Mini-workshop demonstrations</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our free mini workshop demonstrations are always a big attraction and usually sell out! To be the first to know when the workshop demonstrations are live to book, make sure you book your Open Day space early.</p>

Our Annual Open Day is the only time The Arienas Collective is open to the public. It is a great opportunity to visit our home-based workshop space, meet some of the artists and makers who run our workshops, find out more about all the workshops and courses we offer, and watch live, mini workshop demonstrations.
Opening hours
Doors open at 12 noon and close at 6.30pm. Why not combine a visit to see us with a city centre shopping trip, or festive get-together. Edinburgh will be in full festive swing by then! We're hidden away in a quiet mews just a 10 minute stroll from the hustle and bustle of St James Quarter shopping centre, St Andrew's Square, George Street, Princes Street and Edinburgh's 'favourite village', Stockbridge. There are also plenty of independent shops, cafes, galleries and restaurants in nearby Broughton Street, Dundas Street, and St Stephen's Street.
Pop-up shops
Some of our artists and makers also bring artworks and gifts to sell, often at special Arienas Open Day prices. The Arienas Collective creative gift kits, experiences, and gift vouchers will be available to buy on the day, with a special gift box offer. Card payments are preferred, however we will accept cash on the day - but please note we may have a limited supply of change available.
Fundraising
We will once again be fundraising to support Lihtaryk Art Studio in Kyiv, Ukraine to continue providing creative workshops for children, young people, adults and families to distract them from the horrors of living in wartime. 
The Arienas Collective will donate its 10% pop-up shop sales commission, and the creative team will be donating prizes for an Open Day tombola. 
We will have complimentary mulled wine and mince pies on offer, and welcome donations which will also go to Lihtaryk Art Studio.
Free workshop demos
Our free wee workshop demonstrations are always a big attraction and usually sell out! Spaces are offered on a first come, first served basis. Any spaces not claimed 15 minutes before the start time will be reallocated on the day. You can book your space using the links below.
12.30 Soapmaking with Jenny Smith, The Scottish Soapworks
12.30 Silver clay jewellery with Anna Campbell, Jewellery School Scotland (demo room)
13.30 Sketching with the Edinburgh Sketcher 
13.30 Lino printing with Suzanne Kemplay (demo room)
14.30 Calligraphy with Panna Chauham Calligraphy
14.30 Gel printing with Lou Davis
15.30 Macrame with Lucy Wayman (demo room)
15.30 Enamelling with Sheila McDonald
16.30 Silver clay jewellery with Anna Campbell, Jewellery School Scotland (demo room)
17.30 Mixed media & collage with Morven Ferguson (demo room)



More information
Please note that our workshop space is on the first floor of a Georgian mews home and there is no lift access. The space is not nut free, and if you have any concerns about any allergies please contact us before booking. 
Our workshops are designed with adults in mind. Some are suitable for teenagers, but may require those aged 14 or under to be accompanied for insurance purposes. The Open Day is open to all, but space is restricted and since there will be workshop demos running, children should be supervised by an adult at all times. 
You will find free parking in nearby streets and lanes within our parking zone. Please check the parking signs in case of any changes.
Please DO NOT park in the Meuse itself since this may block in our neighbours. Thank you.
Much as we love them, the Open Day can be very busy at times and would not suitable for dogs. Sorry.
If you have any questions about the suitability of the event, demos or location for your group, please email lynn@thearienascollective.com.

The Arienas Collective

Arts & Crafts

The Arienas Collective creative workshop space Open Day in Edinburgh's city centre featuring local artists and makers, workshop demos and festive pop-up shop

The Arienas Collective OPEN DAY 2024

Sign up to be notified as soon as our workshop demonstration slots are available to book.

Sign up for the Open Day

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Watch a wee workshop on creating folded book sculptures with artist Panna Chauhan.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Limited spaces available. This will take place in our demo room. Arrive early for the best view!</p>

A free workshop demo provided as part of our annual Open Day.
Watch a wee workshop demo on enamelling with jeweller Shiela McDonald.
This will take place gathered around our upstairs coffee table space. Arrive early for a seat, and for the best view!
Limited spaces available. 

Calligraphy

Free enamelling workshop demo at The Arienas Collective Festive Open Day in Edinburgh City Centre

OPEN DAY 2024 Enamelling with Sheila McDonald

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Watch a wee workshop demo on firing silver clay jewellery with expert Anna Campbell.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Limited spaces available. This will take place in our demo room. Arrive early for the best view!</p>

A free workshop demo as part of our annual Open Day.
Watch a wee workshop demo on firing silver clay jewellery with expert Anna Campbell of Jewellery School Scotland.
This will take place in our upstairs demo room. Arrive early for the best view!
Limited spaces available. 

Silver Clay Jewellery

Free silver clay jewellery workshop and festive Pop Up shop at The Arienas Collective Annual Open Day in Edinburgh City Centre

OPEN DAY 2024 Silver clay jewellery making demo

A free workshop demo provided as part of our annual Open Day.
Watch a wee workshop demo on mixed media and collage with artist Morven Ferguson.
This will take place in our upstairs demo room. Arrive early for the best view!
Limited spaces available. 

Free mixed media and collage workshop demo at The Arienas Collective Festive Open Day in Edinburgh City Centre

OPEN DAY 2024 Mixed media & collage demo

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Watch a wee workshop demo on lino printing with artist Suzanne Kemplay.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Limited spaces available. This will take place in our demo room. Arrive early for the best view!</p>

A free Lino printing workshop demonstration as part of our annual Open Day.
Watch a wee workshop demo on lino printing with artist Suzanne Kemplay.
This will take place in our upstairs demo room. Arrive early for the best view!
Limited spaces available.

Free lino printing workshop demo and festive pop up shop at The Arienas Collective creative workshop Open Day in Edinburgh City Centre

OPEN DAY 2024 Lino printing demo

A free workshop demo provided as part of our annual Open Day.
Watch a wee workshop demo on calligraphy with artist Panna Chauhan.
This will take place gathered around our upstairs coffee table space. Arrive early for a seat and for the best view!
Limited spaces available. 

Free calligraphy demo at The Arienas Collective Festive Open Day in Edinburgh City Centre

OPEN DAY 2024 Calligraphy demo

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span data-slate-fragment="JTdCJTIyb2JqZWN0JTIyJTNBJTIyZG9jdW1lbnQlMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTdEJTJDJTIybm9kZXMlMjIlM0ElNUIlN0IlMjJvYmplY3QlMjIlM0ElMjJibG9jayUyMiUyQyUyMnR5cGUlMjIlM0ElMjJwYXJhZ3JhcGglMjIlMkMlMjJkYXRhJTIyJTNBJTdCJTIyY2xhc3NOYW1lJTIyJTNBbnVsbCU3RCUyQyUyMm5vZGVzJTIyJTNBJTVCJTdCJTIyb2JqZWN0JTIyJTNBJTIydGV4dCUyMiUyQyUyMmxlYXZlcyUyMiUzQSU1QiU3QiUyMm9iamVjdCUyMiUzQSUyMmxlYWYlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyT25lJTIwaG91ciUyMHdlYmluYXIlMjBmb3IlMjBjby1kcml2ZXJzJTIwbG9va2luZyUyMHRvJTIwdGFrZSUyMHRoZSUyMHN0ZXAlMjB1cCUyMGZyb20lMjBzaW5nbGUlMjB2ZW51ZSUyMHN0YWdlJTIwcmFsbGllcyUyMG9yJTIwcm9hZCUyMHJhbGx5aW5nJTIwdG8lMjBtdWx0aS12ZW51ZSUyMHN0YWdlJTIwcmFsbGllcy4lMjBMZWFybiUyMGFib3V0JTIwcm9hZGJvb2tzJTJDJTIwdGltZWNhcmRzJTJDJTIwdGltaW5nJTIwYW5kJTIwcGVuYWx0aWVzJTJDJTIwcGx1cyUyMHJvdXRlJTIwbm90ZXMlMjBhbmQlMjBwYWNlJTIwbm90ZXMlMjBhbmQlMjBtYW55JTIwbW9yZSUyMGhpbnRzJTIwYW5kJTIwdGlwcyUyMHRvJTIwYmVjb21lJTIwYSUyMHN1Y2Nlc3NmdWwlMjBzdGFnZSUyMGNvLWRyaXZlci4lMjIlMkMlMjJtYXJrcyUyMiUzQSU1QiU1RCU3RCU1RCU3RCU1RCU3RCU1RCU3RA==" id="isPasted" fr-original-style="" style="box-sizing: border-box;">One hour webinar for co-drivers looking to take the step up from single venue stage rallies or road rallying to multi-venue stage rallies. Learn about roadbooks, timecards, timing and penalties, plus route notes and pace notes and many more hints and tips to become a successful stage co-driver.</span>


</p>

One hour webinar for co-drivers looking to take the step up from single venue stage rallies or road rallying to multi-venue stage rallies. Learn about roadbooks, timecards, timing and penalties, plus route notes and pace notes and many more hints and tips to become a successful stage co-driver. 

Rally Navigation Training Services

Sports & Fitness

Rally training webinar for co-drivers looking to take the step up from single venue stage rallies or road rallying to multi-venue stage rallies.

Multi Venue Stage Rally Co-Driving

<article id="cincluded">
					<div>
						<h5>SQL Advanced Course Summary.</h5>
					</div>
					<div></div>
					<p>
						
						<br />Practical SQL Advanced Intensive Course
						, exploring the advanced and less commonly used SQL Statements and techniques.
						<br />We also learn Data Definition Language and Data Manipulation Language statements, 
						<br />as well as course automation of queries using T-SQL.
						<br />Hands-on, Practical SQL Advanced Course. 
						<br />PCWorkshops SQL Advanced Course Certificate.
						<br />Max 4 people per course, we keep it personalised. 
						
				  	</p>
	    		</article>

<div id="#">
							<div>
								<h5>Where is the SQL Advanced Course?</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>Online: </b>Instructor-led.</li>
									 <li><b>Classroom: </b>Request per email.</li> 
								</ul>
								</div>
							</article>
						</div>
						
					   	<div id="#">
							<div>
								<h5>SQL Advanced Course Materials</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>SQL Coding Examples </b>   </li>
									 <li><b>Manuals and Notes: </b>In-depth reference materials </li>
									 <li><b>Exercises:</b> Practical exercises  </li> 
								</ul>
								</div>
							</article>
						</div>
						 
						
						<div id="#">
							<div>
								<h5>Payment for SQL Course Advanced </h5>
							</div>
							<article>
								<div>
								<ul>
									<li>→  £600, Follow the booking link </li>	 
									<li>Arrange for installments</li>
								</ul>
								</div>
							</article>
						</div>
						
						<div id="#">
							<div>
								<h5>Included with SQL Advanced Course:</h5>
							</div>
							<article>
								<div>
								<ul>
									<li>SQL Advanced Course Certificate on completion.
									</li><li>SQL Advanced Course Manual.
									</li><li>Practical SQL Advanced Course exercises
									</li><li>SQL Code Samples.
									</li><li>After the course, 1 free session for questions.
									</li><li>Max group size, online and in classroom, on this SQL Advanced Course is 4.</li>
								</ul>
								</div>
							</article>
						</div>
						

			   	<div id="cdetails">
					<div>
						<h5>SQL Course Advanced Topics</h5>
					</div>
					<article>
						<div>
							<h5>SQL ADVANCED COURSE TOPICS</h5>
						</div>
						<div></div>
						<div>
					 	<ul>
					    	<li>Database Concepts Revision:
								<br />What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,

								</li><li>SQL Sub-queries:

								<br />·Sub-queries in the WHERE, SELECT, From or Having clauses
								<br />·Using SOME, ALL, ANY and IN clauses in the Where Clause <br />·Self-contained sub-queries
								<br />·Correlated sub-queries
								<br />·Sub-queries with the EXISTS predicate

								</li><li>Derived Tables and CTEs:
								<br />·Using SQL derived tables
								<br />·SQL Common Table Expressions (CTEs)
								<br />·Recursive CTEs

								</li><li>Views:
								<br />Create, alter and drop Views, Indexes

								</li><li>SQL Stored Procedure Basics:
								<br />·Stored Procedure Principles
								<br />·Creating stored procedures
								<br />·Executing stored procedures
								<br />·System stored procedures

								</li><li>Variables:
								<br />·Declaring variables
								<br />·SET versus SELECT
								<br />Parameters and Return Values
								<br />·Passing parameters
								<br />·Default values and WHERE clauses
								<br />·Output parameters
								<br />·Using RETURN
								<br />·Testing Conditions
								<br />·The IF/ELSE statement
								<br />·CASE
								<br />·CHOOSE

								</li><li>Looping:
								<br />·Syntax of SQL WHILE
								<br />·Breaking out of a loop
								<br />·Basic transactions
								<br />·Beginning a transaction
								<br />·Committing/rolling back
								<br />·Deleting and updating
								<br />·Using DELETE and UPDATE
								<br />·Sys.Objects
								<br />·Dropping objects

								</li><li>User defined Functions:
								<br />Table Valued Functions
								<br />·In-line table-valued functions
								<br />·Multi- Statement table-valued functions
								<br />·Limitations of user-defined functions
								<br />Scalar Functions
								<br />·What are scalar functions?
								<br />·Some examples
								<br />·Disadvantages of scalar functions
								<br />·Three advantages

								</li><li>Cursors:
								<br />·Syntax of fetching rows
								<br />·When to use (and when not to)

								</li><li>Triggers:
								<br />·Create or replace triggers

								</li><li>Creating Tables in SQL:

								<br />·Create, alter and drop Tables
								<br />·Inserting values, single rows and multiple rows using queries
								</li><li>Constraints:
								<br />·Not Null, Unique,Default,Check,Primary Key,Foreign Key,Identity / Auto-increments

								</li><li>Sequencing
								</li><li>Indexes

								</li><li>SQL Temporary Tables and Table Variables:
								<br />·Create and use SQL temporary tables
								<br />·Create and use SQL table variables
								<br />·SQL Tables vs. Table Variables

								</li><li>Error-Handling:
								<br />·SQL TRY/CATCH
								<br />·SQL System error functions
								<br />·Customizing SQL error messages
								<br />·@@ error function

								</li><li>Debugging:
								<br />·The SQL Server debugger, Debugging (breakpoints, etc.)
							
							 
							
							</li>
						</ul>
						</div>
					</article>
				</div>

		<div> 
						 

						
				     
	                  <div></div>
 		</div>
	                
				     
				   <div id="booking">
	                  <div>
	                     <h5>BOOK THE SQL Course Advanced COURSE</h5> 
	                  </div>
							 
							 <div id="eventbrite-widget-container-48063008753"></div>




					 
	               </div>
				   <div id="#">
	                  <div>
	                     <h5>About SQL Course Advanced</h5>
	                  </div>



	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>

SQL Advanced Course 
 
Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. 
We also learn Data Definition Language and Data Manipulation Language statements, 
as well as course automation of queries using T-SQL. 
Hands-on, Practical SQL Advanced Course. 
PCWorkshops SQL Advanced Course Certificate. 
Max 4 people per course; we keep it personalised. 
Where is the SQL Advanced Course?
Online: Instructor-led.
Classroom: Request per email.
SQL Advanced Course Materials
SQL Coding Examples
Manuals and Notes: In-depth reference materials
Exercises: Practical exercises
 
Included with SQL Advanced Course:
SQL Advanced Course Certificate on completion.
SQL Advanced Course Manual.
Practical SQL Advanced Course exercises
SQL Code Samples.
After the course, 1 free session for questions.
Max group size, online and in classroom, on this SQL Advanced Course is 4.
SQL Course Advanced Topics
SQL ADVANCED COURSE TOPICS
Database Concepts Revision: 
What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,
SQL Sub-queries: 
·Sub-queries in the WHERE, SELECT, From or Having clauses 
·Using SOME, ALL, ANY and IN clauses in the Where Clause 
·Self-contained sub-queries 
·Correlated sub-queries 
·Sub-queries with the EXISTS predicate
Derived Tables and CTEs: 
·Using SQL derived tables 
·SQL Common Table Expressions (CTEs) 
·Recursive CTEs
Views: 
Create, alter and drop Views, Indexes
SQL Stored Procedure Basics: 
·Stored Procedure Principles 
·Creating stored procedures 
·Executing stored procedures 
·System stored procedures
Variables: 
·Declaring variables 
·SET versus SELECT 
Parameters and Return Values 
·Passing parameters 
·Default values and WHERE clauses 
·Output parameters 
·Using RETURN 
·Testing Conditions 
·The IF/ELSE statement 
·CASE 
·CHOOSE
Looping: 
·Syntax of SQL WHILE 
·Breaking out of a loop 
·Basic transactions 
·Beginning a transaction 
·Committing/rolling back 
·Deleting and updating 
·Using DELETE and UPDATE 
·Sys.Objects 
·Dropping objects
User defined Functions: 
Table Valued Functions 
·In-line table-valued functions 
·Multi- Statement table-valued functions 
·Limitations of user-defined functions 
Scalar Functions 
·What are scalar functions? 
·Some examples 
·Disadvantages of scalar functions 
·Three advantages
Cursors: 
·Syntax of fetching rows 
·When to use (and when not to)
Triggers: 
·Create or replace triggers
Creating tables in SQL: 
·Create, alter and drop Tables 
·Inserting values, single rows and multiple rows using queries
Constraints: 
·Not Null, Unique,Default, Check,Primary Key,Foreign Key,Identity / Auto-increments
Sequencing
Indexes
SQL Temporary Tables and Table Variables 
·Create and use SQL temporary tables 
·Create and use SQL table variables 
·SQL Tables vs. Table Variables
Error-Handling: 
·SQL TRY/CATCH 
·SQL System error functions 
·Customizing SQL error messages 
·@@ error function
Debugging: 
·The SQL Server debugger, Debugging (breakpoints, etc.)

About SQL Course Advanced
Our experienced trainers are award winners.
More about us
FAQ's
Client Comments

PCWorkshops

Microsoft SQL Server

Database Programming

SQL Server

Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. 
We also learn Data Definition Language and Data Manipulation Language statements. 
as well as course automation of queries using T-SQL. 
Hands-on, Practical SQL Advanced Course. 
PCWorkshops SQL Advanced Course Certificate. 
Max 4 people per course; we keep it personalised. 

SQL Course Advanced, 2 Days

General admission

Thornton

Staines

Lincoln

Newark


The candidate journey is the process job applicants go through when interacting with Noble Foods. It encompasses every interaction in person and online, from the moment a candidate first becomes aware of us to the final hiring decision – and even beyond.

You play a key role in the successful recruitment of new starters. It’s important that you have the skills to navigate all stages of the recruitment process to give the candidates the best experience, hire top talent and ensure we remain legally compliant.

What does the course cover?
What is the candidate journey and why is it important?
The role of the line manager
Legal Compliance
The Noble Foods Candidate Journey
How to fill out a Requisition
How to post a job
Selection Process
Interviews
Flexible Working Requests


Noble Foods

The Candidate Journey

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">These short-courses are designed to provide a snapshot into the key areas of the language for a variety of levels. &nbsp;Designed to be self-contained; you will not be required to purchase textbooks or extra materials; everything you need will be provided, including access to my online learning materials. &nbsp;You will also receive the PowerPoint slides, the agenda for the following week &amp; any homework set after each class. &nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">I have designed all the slides myself for thee 10-week courses, as I wanted to use my 10+ years of experience to develop something different from the traditional &ldquo;here&rsquo;s a textbook&rdquo; approach that lots of evening classes use. &nbsp;This class is designed to get you speaking in a way that will propel you forward with your language skills in practical settings.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Each learner is entitled to a <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">free 15-minute introduction session</strong> on Zoom so that we can get to know each other and assess your current level. &nbsp;I will also talk you through the controls on Zoom if you are not familiar with how to use it. &nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Each course is comprised of 10 x 1 hour sessions. &nbsp;The groups will contain approximately 3-4 students (with an absolute maximum of 6 students) and are designed to encourage learners to strengthen their speaking skills in a relaxed, friendly atmosphere &amp; learn language skills in a social environment. &nbsp;If you miss a session, it may be possible to join another class running the same session at another time that week, or you can request receiving the learning materials via email. &nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The courses are designed to have practical application for travel &amp; learning for personal interest. &nbsp;I firmly believe having a grammar component is key for long-term success with learning a language, but I promise to break it down so that it isn&rsquo;t overwhelming!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">When a 10-week course finishes, it will be followed by three weeks of optional revision classes. &nbsp;After this, you can simply choose to join the next level course, until you reach a level where you can join our conversation classes.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You may also like to consider a blended learning approach; group classes are friendlier for your budget than private one-to-one tuition, but top up any time with one of my <a href="http://www.pronouncelanguages.co.uk/online-lessons" target="" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">private lessons</a> to consolidate your learning, ask further questions, revisiting themes or investigate a topic of particular interest to you that may not be covered in the short course.  </p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This specific course is for those with little or no knowledge of the Spanish language.</p>

These short-courses are designed to provide a snapshot into the key areas of the language for a variety of levels. Designed to be self-contained; you will not be required to purchase textbooks or extra materials; everything you need will be provided, including access to my online learning materials. You will also receive the PowerPoint slides, the agenda for the following week & any homework set after each class. 
I have designed all the slides myself for thee 10-week courses, as I wanted to use my 10+ years of experience to develop something different from the traditional “here’s a textbook” approach that lots of evening classes use. This class is designed to get you speaking in a way that will propel you forward with your language skills in practical settings. 
Each learner is entitled to a free 15-minute introduction session on Zoom so that we can get to know each other and assess your current level. I will also talk you through the controls on Zoom if you are not familiar with how to use it. 
Each course is comprised of 10 x 1 hour sessions. The groups will contain approximately 3-4 students (with an absolute maximum of 6 students) and are designed to encourage learners to strengthen their speaking skills in a relaxed, friendly atmosphere & learn language skills in a social environment. If you miss a session, it may be possible to join another class running the same session at another time that week, or you can request receiving the learning materials via email. 
The courses are designed to have practical application for travel & learning for personal interest. I firmly believe having a grammar component is key for long-term success with learning a language, but I promise to break it down so that it isn’t overwhelming!
When a 10-week course finishes, it will be followed by three weeks of optional revision classes. After this, you can simply choose to join the next level course, until you reach a level where you can join our conversation classes.
You may also like to consider a blended learning approach; group classes are friendlier for your budget than private one-to-one tuition, but top up any time with one of my private lessons to consolidate your learning, ask further questions, revisiting themes or investigate a topic of particular interest to you that may not be covered in the short course. 
This specific course is for those with little or no knowledge of the Spanish language.

Pronounce Languages

Spanish

Language Teaching

Teaching Online

Online Education

An exciting 10-week course to build your Spanish skills from scratch.  Practical applications for travel & conversation.  Enlarge your vocabulary, improve your grammar in a pain-free, step-by-step way, working with a tutor with 10+ years' experience & a small group of learners.

10-week Spanish course for Absolute Beginners (Level 1)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Medication awareness training&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">9:30 - 12:30</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For up to 12 delegates per session</p>

Medication Awareness training is mandatory for all staff who are prompting or assisting clients to take their medications.
About this event
Medication Awareness training is for staff who have had never taken part in Medication training before or staff returning to the profession.
By the end of the course, you will be able to:
Understand medication types and uses
Learn legal and ethical responsibilities
Master medication administration procedures
Know proper storage and disposal methods
Recognize and respond to adverse effects
Develop communication and record-keeping skills
Apply person-centred approaches
Conduct risk assessments.

Location for delegates attending in person
Online via Teams
0798 999 5180. sales@chcaretraining.co.uk

Before you book:
Please do not send along staff who have just worked a nightshift or who will be visiting clients immediately before or immediately after a training session. People arriving tired, stressed or late cannot gain the most benefit from a training course. We reserve the right to turn away individuals too exhausted to focus on the training or staff who turn up late for a course and disturb the flow of the proceedings.
All CH Care Training courses are fully inclusive, but if you have any concerns about a member of staff's ability to participate because of physical, sensory or learning differences then please let us know in confidence in advance, so that we may make the appropriate adjustments.

Cancellations
CH Care Training operates a sliding scale of cancellation; If you cancel more than two weeks before the start date of a course, you can ask for a full refund, to change the names of the delegates being sent along, or to transfer a delegate to another training date. If you give less than two weeks but more than one week's notice of cancellation, 50 percent of the booking can be refunded. If you cancel less than a week from the training delivery date we wont be able to refund. There are no refunds for staff who do not turn up on the day of the training course.
If CH Care Training needs to change the date or cancel a course for any reason we will give you the maximum notice we can. In exceptional circumstances we may cancel a course due to extreme weather or circumstances at the training venue. You will be offered a full refund or the opportunity to transfer your booking to an alternative date.

Please ask your staff to read the following guidance before they attend the course:
Arriving at the Venue
The course will start promptly so please arrive at least 15 minutes before the start time of the training to allow plenty of time to use the toilet, and be seated ready for the start of the course.
You can call Training direct on 0798 999 5180 if you are struggling to arrive on time. Please note that the meeting will be locked to late arrivals 10 minutes after the actual course starts.
When you arrive please come into Reception and a member of staff will come to book you in prior to directing you to the training room. This room is located on the ground floor and is wheelchair accessible.

Covid-Secure Premises
Please do not attend the course if you have symptoms of Covid or are feeling unwell. 

During the course
As this is a working environment please ensure you allow the necessary time and focus to get the best from the material being presented. Please bring pen and paper to make notes during the course. Our training sessions are fun and very interactive. We will encourage plenty of comments, points of view and the sharing of lived experiences. Delegates should not share any sensitive information about a client or organisation. Our session agreement asks delegates to maintain confidentiality about individuals and organisations and to respect the views of others on the course.
All CH Care Training courses are inclusive, but if you have any concerns about your ability to participate, such as sensory or learning differences then please let the Trainer know in confidence before the start of a course, so that they may make the appropriate adjustments.
If the course contains practical elements such as Moving & Handling or First Aid, then please wear appropriate clothing to take part in these activities. You will be asked confidentially if you have any health concerns that could prevent you from taking part in the practical activities. Please let a Trainer know if you have any concerns about taking part in the practical courses.
Refreshments are provided for free. Please bring a packed lunch for any full-day courses.

After the course
We will email you a pdf of the course once the training has finished and we have checked that everyone was able to join. If your Manager booked you onto the course using your work or personal email, or if you book yourself onto a course, you will receive the pdf directly. If your Manager booked you onto the course using your organisation’s email address a copy of the course will be available on request from your Manager.
We will also email a link to an online evaluation and we ask that you please fill this in and return it to us so that we can continue to improve our services. All of our evaluations are gathered anonymously.

If you have any questions, please contact Training on 0798 999 5180 or email sales@chcaretraining.co.uk.

CH Care Training

Medication Awareness training for Acer Care

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Sixty minute webinar on Rally Regularity Timing covering equipment required, how to keep to time, working out penalties and speed changes, this webinar focuses on styles of regularity that require the use of standard average speed tables. The competitive component of on the public highway historic road rallying, focusing on regularity using average speed tables. Ideal for competitors on events such as HRCR Clubmans Championship or Rally of the Tests</p>

Mastering Regularity Rallying: A 60-Minute Webinar
Elevate your rallying skills with this focused, one-hour webinar designed to boost your confidence in regularity time keeping, essential for competitive historic road rallying on public highways. Dive into the essentials of average speed tables, timing strategies, and control procedures, and gain insider tips for recovering from common mistakes to stay on course. Perfect for competitors aiming to excel in top-tier events like the HERO Rally of the Tests or HRCR Championship rallies, this webinar offers practical insights to enhance your performance. Join us to refine your skills and gain a competitive edge!

Historic Road Rallying training webinar on Regularity focusing on Average Speed Table style regularities.

Rally Navigation - Regularity for Improvers

We all have different experiences, backgrounds and perspectives which mean that we can all react differently to situations at work, which can also affect the relationships we have. This diversity of experience and thought is a good thing, but on occasion it can also lead to misunderstanding and conflict between individuals which need effective resolution strategies. 
Conflict can have a significant impact on colleagues and the business financially and emotionally. It is important that as a manager you have the tools to resolve conflict before it becomes an issue. 

What does the course cover?
What is Workplace conflict?
What causes conflict in the workplace?
The effects of conflict on colleagues and the business
Types of Conflict
Conflict Management Styles
Early Conflict resolution
Mediation


Conflict Management

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">LOOKING FOR</strong>: ADULT FICTION</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Sarah Williams is a Director of the <a href="http://www.sophiehicksagency.com/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Sophie Hicks Agency</a> which she joined in 2014 and she has worked as a literary agent for over 10 years. Sarah represents a wide range of adult fiction and non-fiction and as she runs the film and television side of the agency, she is particularly interested in books that have screen potential.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">She is looking for literary fiction, reading group fiction, memoir and lifestyle/personal development - basically any book that can surprise, change and challenge a reader. Recent favourites are <em fr-original-style="" style="box-sizing: border-box;">Tides</em> by Sara Freeman, <em fr-original-style="" style="box-sizing: border-box;">The Paper Palace</em> by Miranda Cowley Heller, <em fr-original-style="" style="box-sizing: border-box;">Early Morning Riser</em> by Katherine Heiney and <em fr-original-style="" style="box-sizing: border-box;">In The Dream House</em> by Carmen Maria Machado.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Sarah would like you to submit a covering letter, 1 page synopsis and the first 20 - 30 pages of your manuscript in a single word document.</strong></p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">(<em fr-original-style="" style="box-sizing: border-box;">In addition to the paid sessions, Sarah is kindly offering one free session for low income/under-represented writers. Please email <a href="mailto:agent121@iaminprint.co.uk" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">agent121@iaminprint.co.uk</a>&nbsp;to apply, outlining your case for this option which is offered at the&nbsp;</em><em fr-original-style="" style="box-sizing: border-box;">discretion of&nbsp;</em><em fr-original-style="" style="box-sizing: border-box;">I Am In Print)</em>.&nbsp;</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">By booking you understand you need to conduct an internet connection test with<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong><em fr-original-style="" style="box-sizing: border-box;">I Am In Pr</em><em fr-original-style="" style="box-sizing: border-box;">int</em>&nbsp;prior to the event. You also agree to email your material in one document to reach&nbsp;<em fr-original-style="" style="box-sizing: border-box;">I Am In Print</em>&nbsp;by the stated submission deadline and note that&nbsp;<em fr-original-style="" style="box-sizing: border-box;">I Am In Print</em>&nbsp;take no responsibility for the advice received during your agent meeting.</p><p style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: border-box; font-size: 16px; color: var(--text); font-family: sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><strong style="box-sizing: border-box; font-weight: 700;" fr-original-style="box-sizing: border-box; font-weight: 700;">The submission deadline is: Wednesday 31 January 2024</strong></p>

LOOKING FOR: ADULT FICTION
Sarah Williams is a Director of the Sophie Hicks Agency which she joined in 2014 and she has worked as a literary agent for over 10 years. Sarah represents a wide range of adult fiction and non-fiction and as she runs the film and television side of the agency, she is particularly interested in books that have screen potential.
She is looking for literary fiction, reading group fiction, memoir and lifestyle/personal development - basically any book that can surprise, change and challenge a reader. Recent favourites are Tides by Sara Freeman, The Paper Palace by Miranda Cowley Heller, Early Morning Riser by Katherine Heiney and In The Dream House by Carmen Maria Machado.
Sarah would like you to submit a covering letter, 1 page synopsis and the first 20 - 30 pages of your manuscript in a single word document.
(In addition to the paid sessions, Sarah 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 in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting.
The submission deadline is: Tuesday 19 November 2024

I Am In Print

SOLD OUT! 26th November Sarah Williams #Agent121. Looking for: ADULT FICTION

<p style="color: rgba(26, 26, 26, 0.7); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgba(26, 26, 26, 0.7);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Live via Zoom. Fortnightly - 3/17/31 Oct, 14/28 Nov, 12 Dec - 6-8pm UK time (plus an optional sharing session on 9 Jan)</em></strong></p><p style="color: rgba(26, 26, 26, 0.7); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgba(26, 26, 26, 0.7);">Join artist Julie Galante for this brand new course designed to nurture your creative practice. Together we&rsquo;ll explore ways to &nbsp;create work that reflects your individual interests, passion, and point of view, no matter your experience level. The course content is delivered over seven live Zoom sessions, in a small, welcoming group with plenty of opportunities for interaction. Additionally, there will be optional (but highly recommended) assignments to complete in between the live sessions - assignments designed to get you stuck in to your creative practice in new and interesting ways.</p><p style="color: rgba(26, 26, 26, 0.7); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgba(26, 26, 26, 0.7);">During each live session, there will be a demonstration focusing on a particular aspect of visual art - this will include various materials, subjects, and considerations such as composition, theme, mark-making, layering, and so on. We will also have a look at everyone&rsquo;s recent creations, with celebration of the triumphs and suggestions for moving forward with work-in-progress. Together we&rsquo;ll explore techniques including drawing, painting, mixed-media, paper craft, and collage, but you don&rsquo;t have to work exclusively in these media to take part - all creative disciplines are welcome.</p><p style="color: rgba(26, 26, 26, 0.7); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgba(26, 26, 26, 0.7);">Each participant will be encouraged to deepen their explorations in whatever direction interests them most - be it a series of written reflections, sketches, collages, photographs, mixed-media pieces, or a unique, personal combination of all these.</p><p style="color: rgba(26, 26, 26, 0.7); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgba(26, 26, 26, 0.7);">There will be an optional online discussion group for participants to stay connected and share their creations with each other between sessions. There will also be discounts available for other workshops and one-to-one mentoring.&nbsp;</p>

Live via Zoom. Fortnightly - 1/15/29 Oct, 12/26 Nov, 10 Dec - 6-8pm UK time 
Join artist Julie Galante for this course designed to nurture your creative practice. Together we’ll explore ways to create work that reflects your individual interests, passion, and point of view, no matter your experience level. The course content is delivered over six live Zoom sessions, in a small, welcoming group with plenty of opportunities for interaction. Additionally, there will be optional (but highly recommended) assignments to complete in between the live sessions - assignments designed to get you stuck in to your creative practice in new and interesting ways.
During each live session, there will be a demonstration focusing on a particular aspect of visual art - this will include various materials, subjects, and considerations such as composition, theme, mark-making, layering, and so on. We will also have a look at everyone’s recent creations, with celebration of the triumphs and suggestions for moving forward with work-in-progress. Together we’ll explore techniques including drawing, painting, mixed-media, and collage, but you don’t have to work exclusively in these media to take part - all creative disciplines are welcome.
Each participant will be encouraged to deepen their explorations in whatever direction interests them most - be it a series of drawings, written reflections, sketches, collages, photographs, mixed-media pieces, or a unique, personal combination of all these.
There will be an optional Facebook group for participants to stay connected and share their creations with each other between sessions. There will also be discounts available for other workshops and one-to-one mentoring. 

Airtily

Drawing

Painting

Watercolour Painting

Creative Practice

Join Me For This 8 Week Qigong and Breathwork Online Course
HARNESSING THE POWER OF THE BREATH
The way we breathe affects everything we do, everything we think and everything we feel. It affects our sleep, our digestion, our immune system, our energy levels, our emotions, our ability to think clearly and our relationships, to name but a few.
In this course we will be combining my passions of Qigong and Breathwork to help bring us into balance so we can move though Autumn into winter full of peace and vitality.
Why Qigong and Breathwork?
Qigong is breathwork (Qi is Breath), it is an amazing way of opening and clearing the body, of making space for our healthy energy to flow. It allows us to stay relaxed and receptive without forcing or pushing. It is easy to learn and naturally attuned to your individual body and how it wants to expand, release and recharge.
Breathwork is simply bringing our conscious attention to our breath and is one of the most powerful ways we have to change our state at any given moment. In the course i will introduce you to eight different breath techniques to help you to breathe better. Commit to just 10mins a day and you’ll be amazed at the results you can achieve.
Everyone is welcome to join the course no matter your experience. 
When: 8th October 2024 – 5th December
Tuesday Evenings 6-7pm and Thursday mornings 9-9.30am (via Zoom)
Dates:
Tuesdays 6-7pm: October 8th, 15th, 22nd November 5th, 12th, 19th, 26th, December 3rd.
Thursdays 9-9.30am: October 10th, 17th, 24th, November 7th, 14th, 21st, 28th December 5th.

Price: £110 (Concessions £80: Super concession £60)
What is included: 
Eight live 60min evening zoom classes 
Eight live 30min morning meditation zoom classes 
Access to replays of all classes so you can catch up in your own time. 
Learn a Qigong routine for healthy lungs 
Learn how to clear the meridian pathways for increased vitality 
Learn 8 new powerful breath practices 
Access to private Whats App group to share experiences and ask questions 
Weekly supporting material for home practice :
– A Weekly video with a guided 10min Breath Practice 
– PDF – explanations of each practice 
– Key acupuncture points for self massage 

What will I get out of the course?
Reconnect with your breath
Learn how to improve your respiration
Learn to regulate your own nervous system
Access deeper body awareness
Less physical tension
Reduced pain
Improved mental clarity
Strengthened immune system 
Improved sleep
Improved digestion
Less stress and anxiety, depression and panic attacks
Deepening meditation practice
More energy
Just Breathe
Just Be

2713 Courses in Edinburgh

Intergenerational Boogie Beat Mixed Age

By Boogie Beat Music and Movement Edinburgh

Currie Mixed Age Fri Am

By Boogie Beat Music and Movement Edinburgh

Pennypit Thurs AM

By Boogie Beat Music and Movement Edinburgh

Islamic Studies Classes

By Ilmul Atfaal Online

The Arienas Collective OPEN DAY 2024

By The Arienas Collective

OPEN DAY 2024 Enamelling with Sheila McDonald

By The Arienas Collective

OPEN DAY 2024 Silver clay jewellery making demo

By The Arienas Collective

OPEN DAY 2024 Mixed media & collage demo

By The Arienas Collective

OPEN DAY 2024 Lino printing demo

By The Arienas Collective

OPEN DAY 2024 Calligraphy demo

By The Arienas Collective

Search By Location