London

Manchester

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(48, 48, 48); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(48, 48, 48);">We are committed to directing you toward the most suitable educational course considering your personal circumstances, educational needs, and career aspirations.</span></p>

EU Network

Foundation Year, Bachelors degree, Masters, no IELTS needed, Student finance support 

We will help you to find the right course for you

Coventry

<main tabindex="-1" data-main-content="true" style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><div data-page-transition="CrossFade" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-id="Containerx3iv3inlineContent" data-testid="inline-content" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-id="Containerx3iv3inlineContent-gridContainer" data-testid="mesh-container-content" fr-original-style="" style="box-sizing: border-box;"><section tabindex="-1" data-block-level-container="ClassicSection" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-id="comp-lhj9f6s6inlineContent" data-testid="inline-content" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-id="comp-lhj9f6s6inlineContent-gridContainer" data-testid="mesh-container-content" fr-original-style="" style="box-sizing: border-box;"><div data-testid="richTextElement" fr-original-style="" style="box-sizing: border-box;"><h6 style="color: rgb(39, 8, 79); box-sizing: border-box;" fr-original-style=" color: rgb(39, 8, 79);"><span style="color: rgb(139, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(139, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">What is the IDP?</span></strong></span></h6><p style="color: rgb(var(--color_2)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_2));">The Individual Development Programme is a bespoke programme that has been used since 2009 with Individuals from both the UK and internationally. It is exactly what its title infers: a programme to help any individual develop personally, professionally, creatively and spiritually &ndash; using carefully selected initiatives, activities, exercises, discussions, projects and coaching to bring out the person&rsquo;s individual potential an<span style="font-size: 12px; box-sizing: border-box;" fr-original-style="font-size: 12px;">d talents.</span></p><h6 style="color: rgb(39, 8, 79); box-sizing: border-box;" fr-original-style=" color: rgb(39, 8, 79);"><span style="color: rgb(139, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(139, 0, 0);"><span style="font-size: 14px; box-sizing: border-box;" fr-original-style="font-size: 14px;">How is it structured?</span></span></h6><p style="color: rgb(var(--color_2)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_2));">Normally the Coach will arrange a simple structure with the &lsquo;IDP trainee&rsquo;, e.g., 2 days per month, arranged specifically and individually, to fit around the person&rsquo;s lifestyle/working life and geographical limitations. Then the person/individual is given specifically-tailored exercises, assignments and projects to complete in their own time, prior to the next training session or meeting.</p><h6 style="color: rgb(39, 8, 79); box-sizing: border-box;" fr-original-style=" color: rgb(39, 8, 79);"><span style="color: rgb(139, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(139, 0, 0); font-size: 14px;">Who can do this Programme?</span></h6><p style="color: rgb(var(--color_2)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_2));">This IDP is suitable for anyone over 18 who shows a clear desire to explore and understand their potential and develop their own path, being intentional and willing to apply and work on the equipping assignments given to them. This is a particularly good structure for working people, or parents, or those of an age where they are not able, or do not wish to attend a full-time college/study programme, and want an individual approach to their development.</p><p style="color: rgb(var(--color_2)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_2));">The bespoke nature of this programme means that it is highly flexible and can suit anyone.</p><h6 style="color: rgb(39, 8, 79); box-sizing: border-box;" fr-original-style=" color: rgb(39, 8, 79);"><span style="color: rgb(139, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(139, 0, 0); font-size: 14px;">Who leads the Programme?</span></h6><p style="color: rgb(var(--color_2)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_2));">The programme is designed and led by<span style="color: rgb(139, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(139, 0, 0);">&nbsp;<a href="https://www.core-arts.uk/directors" target="_blank" style="color: inherit; user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;">Danny Scott</a></span>&nbsp;who has been working internationally for over thirty years in the performing arts, personal development and coaching &ndash; both in the corporate sector and arts sector. Danny also brings in additional coaches as necessary for specific requirements to meet the Individual&rsquo;s needs.</p><h6 style="color: rgb(39, 8, 79); box-sizing: border-box;" fr-original-style=" color: rgb(39, 8, 79);"><span style="color: rgb(139, 0, 0); font-size: 14px; box-sizing: border-box;" fr-original-style="color: rgb(139, 0, 0); font-size: 14px;">Endorsements</span></h6><p style="color: rgb(var(--color_2)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_2));">&ldquo;Danny is able to challenge and bring people beyond their limits whether they are young or old, laypersons or professionals - with a unique gift to unfold their potential physically and spiritually/mentally. Students&hellip; are amazed to find themselves enriched and grow in all artistic and personal areas.&rdquo;&nbsp;(Church leader and Head of &lsquo;Artcross&rsquo; Conference Austria)</p><p style="color: rgb(var(--color_2)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_2));">"Danny is an exceptionally committed teacher. He values the students and believes in their ability, which in turn yields extraordinary results.. His energy, vision and enthusiasm are outstanding...&rdquo;&nbsp; (Education Manager - Churchill Theatre, Bromley, UK)</p></div><div data-semantic-classname="button" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div></div></div></section></div></div></div></main><footer tabindex="-1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><div tabindex="-1" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-id="SITE_FOOTERinlineContent" data-testid="inline-content" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-id="SITE_FOOTERinlineContent-gridContainer" data-testid="mesh-container-content" fr-original-style="" style="box-sizing: border-box;"><div data-testid="richTextElement" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div></div></div></div></footer>

CORE theatre arts training

Maximise your potential with bespoke individual development

Individual Development Programme (IDP)

Bridgend

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">What is perinatal mental health and fathers?&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The term &lsquo;perinatal&rsquo; refers to the period of time around childbirth. Interpretations of the timeframe of this period vary; in some cases, it includes the time before conception until two years after an infant has been born. In the UK, the First 1001 Days Movement raises awareness of the developmental significance of the first two and a half years of a child&rsquo;s life.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">In the course we explain:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">High risk of suicide in new fathers.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The impact on the partner and the development of the child.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">PTSD, Perinatal Anxiety and Depression in fathers.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Signs, Symptoms and how to engage with fathers.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Importance of bonding and attachment with father - baby.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Biological risk factors&nbsp;</p>

Mark Williams

Midwifery

Health Visiting

Fathers and Perinatal Mental Health 

Windsor

<section style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><div data-testid="columns" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-id="comp-kgmem0aqinlineContent" data-testid="inline-content" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-id="comp-kgmem0aqinlineContent-gridContainer" data-testid="mesh-container-content" fr-original-style="" style="box-sizing: border-box;"><section fr-original-style="" style="box-sizing: border-box;"><div data-testid="columns" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-id="comp-kgmem0arinlineContent" data-testid="inline-content" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-id="comp-kgmem0arinlineContent-gridContainer" data-testid="mesh-container-content" fr-original-style="" style="box-sizing: border-box;"><div data-testid="richTextElement" fr-original-style="" style="box-sizing: border-box;"><h1 style="color: rgb(var(--color_15)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><span style="color: rgb(var(--color_15)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));">I&rsquo;m a qualified Guitar Instructor offering personalized lessons and instruction to students in the Berkshire&nbsp;area.</span></h1></div><div data-testid="richTextElement" fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><span style="color: rgb(var(--color_15)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><span style="color: rgb(var(--color_15)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));">I&rsquo;ve been teaching people of all ages and experience levels since 1995&nbsp;and love what I do.</span></p></div></div></div><div data-mesh-id="comp-kgmem0asinlineContent" data-testid="inline-content" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-id="comp-kgmem0asinlineContent-gridContainer" data-testid="mesh-container-content" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div></div></div></section></div></div></div></section><section style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><div data-testid="columns" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-id="comp-kgma8ejlinlineContent" data-testid="inline-content" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-id="comp-kgma8ejlinlineContent-gridContainer" data-testid="mesh-container-content" fr-original-style="" style="box-sizing: border-box;"><section fr-original-style="" style="box-sizing: border-box;"><div data-testid="columns" fr-original-style="" style="box-sizing: border-box;"><div data-hook="bgLayers" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div data-mesh-id="comp-kgma8ejl2inlineContent" data-testid="inline-content" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-id="comp-kgma8ejl2inlineContent-gridContainer" data-testid="mesh-container-content" fr-original-style="" style="box-sizing: border-box;"><div data-testid="richTextElement" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(var(--color_15)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><span style="color: rgb(var(--color_15)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));">CONTACT ME</span></h2></div><div data-testid="richTextElement" fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><span style="color: rgb(var(--color_15)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));">Windsor Guitar Lessons, Longmead, Windsor, UK</span></p></div><div data-testid="richTextElement" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div data-mesh-id="comp-kgmbpl26inlineContent" data-testid="inline-content" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-id="comp-kgmbpl26inlineContent-gridContainer" data-testid="mesh-container-content" fr-original-style="" style="box-sizing: border-box;"><form fr-original-style="" style="box-sizing: border-box;"><div data-mesh-id="comp-kgmbpl2hinlineContent" data-testid="inline-content" fr-original-style="" style="box-sizing: border-box;"><div data-mesh-id="comp-kgmbpl2hinlineContent-gridContainer" data-testid="mesh-container-content" fr-original-style="" style="box-sizing: border-box;"><div data-testid="richTextElement" fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><br fr-original-style="" style="box-sizing: border-box;"></p></div></div></div></form></div></div></div></div><div data-hook="bgLayers" fr-original-style="" style="box-sizing: border-box;"><div data-testid="colorUnderlay" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><img src="https://static.wixstatic.com/media/bb5568_1a73c5ea1c3a4f27aa9982f530ca19c9~mv2.jpg/v1/fill/w_980,h_1564,fp_0.50_0.50,q_85,usm_0.66_1.00_0.01,enc_auto/bb5568_1a73c5ea1c3a4f27aa9982f530ca19c9~mv2.jpg" alt="denny_3_edited.jpg" width="490" height="782" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"></div></div></section></div></div></div></section>

Windsor Guitar Lessons

Guitar

I’m a qualified Guitar Instructor offering personalized lessons and instruction to students in the Berkshire area.

WINDSOR GUITAR LESSONS, YOUR GUITAR INSTRUCTOR

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Learning in friendly way how to get your joy and mindfulness back.Q&amp;A time&nbsp;</p>

Bogumila Malinowska /Counselling/Psychotherapy in Person and online in London

Academy of Counselling Education (ACE)

It will help to return to your own resources based on self trust and intuition 

Mindfulness and grounding skills 

Bridgwater

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Changing patterns of thinking can be challenging, I work with individuals and small groups to discover techniques that are proven methods of change, such lateral thinking techniques, Appreciative Inquiry and other methodologies to change stuck patterns.</p>

Kevin Chamberlain

Building Creative Thinking

Bournemouth

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">I am also available for various events such as festivals, corporate functions, weddings, etc.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">I regularly receive bookings across the UK, in Europe and beyond. I have provided sound journeys &amp; gong baths in gardens, halls, marquees, tents, private villas and even upon large private boats! Anything is possible&hellip;</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Please contact me&nbsp;with your enquiry.</p>

Robin Freeman - Sacred Sound Healing

Sound Healing

Meditation

Aromatherapy

Sound journey & gong baths for festivals, corporate functions, weddings, etc

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">As a qualified Reiki master, I can come to your home and provide a 1hr Reiki healing session.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&nbsp;</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">We can work on any areas you may be aware of that require some attention. Or I can do a full body scan and assessment, free up an unbalanced energy flow within the body and bring everything back into alignment.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">These sessions are a fantastic way to relieve stress and promote healing.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">For more information or booking enquiries, please contact me here.</p>

Private Reiki sessions within the comfort of your own home.

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">I occasionally organise one-off events such as outdoor sound journeys &amp; gong baths in magical woodland locations, peaceful parks or on beautiful beaches. Sometimes under the stars with a fire.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Any upcoming events like this will be listed HERE (Eventbrite). So be sure to check regularly.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&nbsp;</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">I also occasionally organise all-night puja events.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Guests are invited to bring comfy bedding and everything they need to spend a whole night sleeping to the subtle healing frequencies of gongs and other powerful healing instruments that continue throughout the whole night.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">These events will begin with a welcome ceremony, followed by a beautiful meditation session. After this, we all lay down, get comfortable, relax and slowly fall into a beautiful deep sleep. In the morning we gently awaken feeling refreshed, revitalised and re-energised.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Any upcoming events like this will be listed here. So be sure to check regularly.</p>

Outdoor sound journey & gong bath / all night puja’s & other special events

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">I offer private sound healing and sound therapy sessions on either a 1:1 or 2:1 (couples/friends) basis. I come to you and provide this service within the comfort of your own home.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">These sessions can be completely tailored toward your individual needs. Popular subjects I am often asked to concentrate on are stress relief, anxiety, grief, sleep issues, physical or emotional pain and/or discomfort, letting go of burdens that you no longer wish to carry, setting new intentions, re-energizing and recharging or just an ultimate relaxation sound journey session that will leave you feeling beautifully peaceful, calm and relaxed.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">My sessions include the use of sound and vibration, guided meditation, and aromatherapy.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&nbsp;</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">I also offer chakra rebalancing sessions to restore the natural flow of energy within us using Tibetan body work bowls, gong, powerful crystals, and guided meditation.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&nbsp;</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">For more information on these popular 1:1 or 2:1 sessions please get in touch.</p>

Private 1:1 or 2:1 Sound Healing sessions in the comfort of your own home.

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.</p><p></p><p></p><p>This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

Learning & Development

Design & Technology Courses (DT)

Data Skills

Trainers Course

Microsoft AZ-303

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

General Admission

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Definition of Safeguarding Legislation &amp; agreed ways of working</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Definition of Safeguarding</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Legislation &amp; agreed ways of working</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Every child matters guidance</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Myths and statistics</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Effects on young people</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Leadership/worker skills</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Common indicators of abuse</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Reporting of abuse and potential abuse</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Barriers to reporting abuse</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Understanding the types of abuse</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Recognising acts, signs and symptoms of abuse</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Who is vulnerable / at risk</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The role of dignity in safeguarding</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Legislation and policies and procedure</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">What to do should you have a concern</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Overview of prevent</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">How to respond to an individual should they disclose a concern</p>

Caring For Care

Safeguarding Train the Trainer

<div data-hook="bgLayers" data-motion-part="BG_LAYER" style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></div><div data-mesh-id="comp-lpba7l9einlineContent" data-testid="inline-content" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><div data-mesh-id="comp-lpba7l9einlineContent-gridContainer" data-testid="mesh-container-content" fr-original-style="" style="box-sizing: border-box;"><div data-testid="richTextElement" fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Everything DiSC Facilitator Training Programme</strong></p><p style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));">This programme has been specifically designed to help experienced trainers, facilitators and coaches use Everything DiSC and the Five Behaviours assessments, and deliver workshops, with their own clients and in-house teams. Learn how the DiSC suite of behavioural assessments can help to improve workplace relationships and act as a catalyst for change.&nbsp;</p><p style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(var(--color_15));"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">The </span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><a href="https://www.discgb.co.uk/everything-disc-facilitator-training" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; text-decoration: inherit; font-size: var(--font-size); box-sizing: border-box; color: inherit; cursor: pointer;" fr-original-class="wysiwyg_underlined_link_cls">Everything DiSC Facilitator Programme</a></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"> is delivered via two or three, instructor-led, interactive webinars, using Zoom.</span></p><p style="color: rgb(var(--color_15)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_15));"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">You will receive all of the benefits of joining our network of members, facilitators and coaches and can choose to include an additional session which provides a detailed overview of <a href="https://www.discgb.co.uk/five-behaviours-model" target="_self" style="color: inherit; user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;">The Five Behaviours</a>. You can also choose to open an online&nbsp;<a href="https://www.discgb.co.uk/epic" target="_blank" style="color: inherit; user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: inherit;">EPIC</a>&nbsp;account with us at a discounted rate straight away or defer this until you are ready to get started issuing your first Everything DiSC and Five Behaviours access codes.&nbsp;</span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">During the programme you will :</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Learn the background to DISC and the key cornerstone principles</li><li fr-original-style="" style="box-sizing: border-box;">Receive and explore your own personal Everything DiSC Workplace profile&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Practice using the Supplement for Facilitators</li><li fr-original-style="" style="box-sizing: border-box;">Learn about all of the DISC styles</li><li fr-original-style="" style="box-sizing: border-box;">Find out how to recognise other people&#39;s style</li><li fr-original-style="" style="box-sizing: border-box;">Find strategies for adapting your own style</li><li fr-original-style="" style="box-sizing: border-box;">Experience how Everything DiSC on Catalyst helps to keep DiSC alive</li><li fr-original-style="" style="box-sizing: border-box;">Learn about the full Everything DiSC suite of profiles available</li><li fr-original-style="" style="box-sizing: border-box;">Explore facilitation ideas, tools, techniques and best practices</li></ul><div fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(57, 63, 68); font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(57, 63, 68); font-size: 16px;">We also offer official Certification programmes to enable you to qualify as an Everything DiSC Certified Practitioner :&nbsp;&nbsp;</span><span style="color: rgb(57, 63, 68); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(57, 63, 68); font-size: 16px;"><a href="https://www.discgb.co.uk/everything-disc-certification" style="color: inherit; user-select: auto; text-decoration: inherit; font-size: var(--font-size); box-sizing: border-box; cursor: pointer;" target="_blank" rel="noopener noreferrer" fr-original-style=" color: inherit;" fr-original-class="wysiwyg_underlined_link_cls"><u fr-original-style="" style="box-sizing: border-box;">Everything DiSC&reg; Certification</u></a>&nbsp;programme or&nbsp;</span><span style="color: rgb(57, 63, 68); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(57, 63, 68); font-size: 16px;"><a href="https://www.discgb.co.uk/five-behaviors-certification" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; color: inherit; cursor: pointer; text-decoration: inherit;"><u fr-original-style="" style="box-sizing: border-box;">The Five Behaviours Certification</u> Programme</a></span><span style="color: rgb(57, 63, 68); font-size: 16px; box-sizing: border-box;" fr-original-style="color: rgb(57, 63, 68); font-size: 16px;">.&nbsp;</span></div></div></div></div>

DISCGB

Disc

This programme has been specifically designed to help experienced trainers, facilitators and coaches use Everything DiSC and the Five Behaviours assessments, and deliver workshops, with their own clients and in-house teams.

Everything DiSC Facilitator Training

<h3 fr-original-style="" style="box-sizing: border-box;">Data Protection (GDPR) Foundation Certificate</h3>
<div fr-original-style="" fr-original-class="lcb-body" style="box-sizing: border-box;">
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" fr-original-class="education-description-wrapper" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Data Protection (GDPR) Foundation Certificate is the course for people who need a formal qualification to demonstrate a clear, concise and generic understanding of the General Data Protection Regulation and Data Protection Act 2018, in support of the practical knowledge often acquired in the workplace. It is suitable for the public, private and third sectors and will teach participants essential GDPR skills and sufficient knowledge to assist their organisation toward their data protection implementation and GDPR accountability requirement.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Foundation Certificate is an internationally recognised qualification, endorsed by TQUK, which is regulated by Ofqual, a UK Government department.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">As the course covers a lot of ground in a short time we recommend attendees who know nothing about data protection to attend our one-hour live, online Introduction to Data Protection and the GDPR.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Note: This course is delivered live, online, using the Zoom platform. &nbsp;It will be delivered 9.30 - 12.30 and 13.30 - 16.30</p>
</div>
</section>
</div>

Computer Law Training

Legal

Data Protection

Compliance

GDPR

This Foundation Certificate  is an internationally recognised qualification, endorsed by TQUK, which is regulated by Ofqual, a UK Government department.

Data Protection (GDPR) Foundation Certificate

General admission

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you a stressed, exhausted SEN/EBSA parent or carer, running on empty, with no time to shout <em fr-original-style="" style="box-sizing: border-box;">"HELP!"&nbsp;</em>let alone step off the hamster wheel to rest, recharge and recuperate?</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Parenting neurodivergent and/or school avoidant young people comes with a unique set of challenges and, if you&#39;re finding yourself lurching from managing meltdowns to fighting for support or feeling isolated and judged because people don&#39;t understand, it can be really hard and I GET IT!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">After finding myself pretty much burnt out I discovered and implemented quick and simple self-help and relaxation tools that have helped strengthen my coping skills to navigate my family&#39;s journey, rebuild my resilience and rediscover&nbsp;my old self!&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">I was so blown away by how beneficial simple habits can be that it&#39;s my mission to help others do the same - and so I created&nbsp;The SHARE Project.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The ethos of THE SHARE Project is that&nbsp;we need to put our own oxygen mask on first&nbsp;so that we can&nbsp;best support our kids&nbsp;and my aim is that the tools you will learn during our time together will become your oxygen mask, not only for use in case of emergency, but as a sustainable part of your ongoing&nbsp;self-care and wellbeing.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">During each&nbsp;of four, weekly, live&nbsp;online workshops, delivered over Zoom, you will learn and practise a new tool to implement daily over the coming week (just a&nbsp;few minutes at a time, I promise)!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Then, during the following week&#39;s workshop we will review your progress, make any tweaks and learn and practise the next tool...&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">There&#39;ll be no suggestions of long and luxurious spa days and fluffy robes because most of us don&#39;t have the time to do that very often and, frankly, the benefits disappear almost as soon as you&#39;ve driven home... My mission<em fr-original-style="" style="box-sizing: border-box;">&nbsp;</em>is to give you sustainable tools to use anytime and anywhere to help yourself cope better and feel happier, regardless of what&#39;s going on around you!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Each group session gives you the opportunity to connect with other SEN parents or carers&nbsp;experiencing similar challenges.</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;">What our clients say:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">"</span></em><span style="color: rgb(32, 33, 36); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(32, 33, 36);"><em fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">The Share project was a gentle, kind experience which showed understanding for parenting with additional challenges. &nbsp;The refocusing was extremely powerful and I felt nurtured by the sessions."</span></em></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(32, 33, 36); box-sizing: border-box;" fr-original-style=" color: rgb(32, 33, 36);"><em fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span data-sheets-root="1" id="isPasted" fr-original-style="" style="box-sizing: border-box;">"I gained different techniques to build resilience and overcome overwhelm."&nbsp;</span><br fr-original-style="" style="box-sizing: border-box;"></span></em></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(32, 33, 36); box-sizing: border-box;" fr-original-style=" color: rgb(32, 33, 36);"><em fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span data-sheets-root="1" fr-original-style="" style="box-sizing: border-box;"><span data-sheets-root="1" style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);"><span data-sheets-root="1" id="isPasted" fr-original-style="" style="box-sizing: border-box;">"has helped me have a more positive outlook day to day, relaxation has helped with my sleep"</span></span><span data-sheets-root="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></span></span></em></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">If you have any questions, please ask and I will be happy to help :)</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Sue&nbsp;</p>

Discover Calm and Happiness with The SHARE Project: Your Path to Resilience! 🌟
Are you feeling exhausted, overwhelmed and stretched to your limit?  With meetings and meltdowns to manage, battles for support, the frustration of feeling isolated or misunderstood, not to mention the pressure of juggling your job too, it can It can feel like you’re running on empty; hard to find a moment to step off the hamster wheel and just breathe.
I’ve been there, and I get it!💛
After being on the brink of burnout myself, I stumbled upon simple, yet life-changing self-help and relaxation tools. These quick, effective techniques helped me rebuild my resilience, reclaim my sense of self and navigate challenges with renewed strength. The transformation was so profound that I knew I had to share it with others—and that’s how The SHARE Project was born.
What is The SHARE Project?
The SHARE Project is built on a simple principle: you need to put your own oxygen mask on first!  By nurturing yourself, you’re better equipped to support your children. Through our four-week, live online workshop series, delivered via Zoom, you’ll discover practical tools to bring more calm and happiness into your daily life.
Here’s what you can expect:
Weekly Workshops:  Each week, we’ll introduce and practice a new tool designed to fit seamlessly into your life (just a few minutes a day, I promise!). These are not your typical “luxury spa day” suggestions — because let’s face it, who has time for that?  Instead, you’ll learn sustainable, go-to strategies that you can use anytime, anywhere, to boost your wellbeing, even in the midst of chaos.  You will also receive a mid-week email of encouragement between workshops and printables to help record and track your progress.
Ongoing Support:  In each session, we’ll review your progress, fine-tune your approach, and introduce the next tool.  This isn’t just a one-off workshop; it’s a journey of growth and connection.
Community Connection: You’ll be part of a supportive group of fellow SEN parents and carers who understand the unique challenges you face.  Together, we’ll share experiences, uplift each other, and grow stronger.
What our clients say:
“The SHARE Project was a gentle, kind experience which showed understanding for parenting with additional challenges.  The refocusing was extremely powerful and I felt nurtured by the sessions.”
“It has helped me to have a more positive outlook day-to-day, and the relaxation has helped with my sleep.”	
“I looked forward to the sessions each week, they gave me time to focus on myself for a change.”
Ready to Feel More Calm and Happy?
If you’re ready to step off the hamster wheel and start reclaiming your joy, The SHARE Project is here for you. Let’s work together to help you feel more at peace, more resilient, and, most importantly, more you.
Got any questions? Send me a message and I’ll be happy to help! 😊
With love and support,  
Sue

AUsomeMums

Emotional Wellbeing

Emotional Resilience

Autism

Mental Resilience

Special Education Needs (SEN)

Self-help and relaxation skills and exercises for stressed, burned out SEN parents and carers

The SHARE Project - Self-Help & Relaxation Exercises for SEN/EBSA Parent Carers

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Join Mark on Thursday mornings to move, explore, and wake up to your true nature.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Mark teaches Zen Yoga, a form of yoga based in Zen Buddhist philosophy. Zen Yoga emphasises a balance of the yin and yang aspects of practice, awareness/mindfulness, physical alignment, and the flow of energy in the body through the acupuncture meridian lines.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Mark&#39;s classes are all about re-connecting the body and mind in order to find a sense of health, integration, freedom and kindness. Most of the time his classes are based around the seasons, since the Chinese energy system is very connected to the time of year and changing seasons.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This class is suitable for all levels.</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;">Practising online</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Create a clear and comfortable place to practice. Make sure you&#39;re not going to be disturbed. Have an extra layer handy for the relaxation period at the end just in case.</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;">Caution</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Not all asanas (postures) or movements are suitable for everyone. You should consult with your medical practitioner before beginning and yoga or exercise programme. I assume no responsibility or liability for any injuries or losses that may result from practising yoga via these online classes.</p>

Join Mark on Thursday mornings to move, explore, and wake up to your true nature.
Mark teaches Zen Yoga, a form of yoga based in Zen Buddhist philosophy. Zen Yoga emphasises a balance of the yin and yang aspects of practice, awareness/mindfulness, physical alignment, and the flow of energy in the body through the acupuncture meridian lines.
Mark's classes are all about re-connecting the body and mind in order to find a sense of health, integration, freedom and kindness. Most of the time his classes are based around the seasons, since the Chinese energy system is very connected to the time of year and changing seasons.
This class is suitable for all levels.
Practising online
Create a clear and comfortable place to practice. Make sure you're not going to be disturbed. Have an extra layer handy for the relaxation period at the end just in case.
Caution
Not all asanas (postures) or movements are suitable for everyone. You should consult with your medical practitioner before beginning and yoga or exercise programme. I assume no responsibility or liability for any injuries or losses that may result from practising yoga via these online classes.

Mark Westmoquette

Mindfulness

Yoga

Join Mark on Thursday mornings to move, explore, and wake up to your true nature. Mark's classes are all about re-connecting the body and mind in order to find a sense of health, integration, freedom and kindness. Most of the time his classes are based around the seasons, since the Chinese energy system is very connected to the time of year and changing seasons.

Zen Yoga, Thursdays 10am (ONLINE)

<p id="isPasted" style="margin: 0cm; font-size: medium; font-family: Calibri, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Calibri",sans-serif;color: rgb(0, 0, 0);'><span style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0);">If you are a parent or carer of a child or young person who may not be able to make decisions about their welfare and finances now or in the future, you will need to consider the best ways to protect them as they move to adulthood.&nbsp;</span></p><p style="margin: 0cm; font-size: medium; font-family: Calibri, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Calibri",sans-serif;color: rgb(0, 0, 0);'><span style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0);">&nbsp;</span></p><p style="margin: 0cm; font-size: medium; font-family: Calibri, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Calibri",sans-serif;color: rgb(0, 0, 0);'><span style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0);">Philip Warford, Lawyer and specialist in planning for the future of disabled &amp; vulnerable people, will talk through the key principles of the Mental Capacity Act 2005, who can make a Powers of Attorney and how the Court of Protection might help.</span></p><p style="margin: 0cm; font-size: medium; font-family: Calibri, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Calibri",sans-serif;color: rgb(0, 0, 0);'><span style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0);">&nbsp;</span></p><p style="margin: 0cm; font-size: medium; font-family: Calibri, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Calibri",sans-serif;color: rgb(0, 0, 0);'><span style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0);">Philip will discuss:</span></p><p style="margin: 0cm; font-size: medium; font-family: Calibri, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Calibri",sans-serif;color: rgb(0, 0, 0);'><span style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; font-family: Arial, sans-serif; color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p style="margin: 0cm; font-size: medium; font-family: Arial, sans-serif; color: black; box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Arial",sans-serif;color:black;'><span style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">MENTAL CAPACITY&nbsp;</strong></span></p><ul style="list-style-type: undefined; margin-left: 26px; box-sizing: border-box;" fr-original-style="list-style-type: undefined;margin-left:26px;"><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">What is mental capacity &amp; who assesses mental capacity&nbsp;</li><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">What affects mental capacity&nbsp;</li><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">Different levels of capacity for different things&nbsp;</li><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">How the Mental Capacity Act 2005 affects us</li></ul><p style="margin: 0cm; font-size: medium; font-family: Arial, sans-serif; color: black; box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Arial",sans-serif;color:black;'><span style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">POWERS OF ATTORNEY&nbsp;</strong></span></p><ul style="list-style-type: undefined; margin-left: 26px; box-sizing: border-box;" fr-original-style="list-style-type: undefined;margin-left:26px;"><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">What is a Power of Attorney</li><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">Lasting Powers of Attorney explained</li></ul><p style="margin: 0cm; font-size: medium; font-family: Arial, sans-serif; color: black; box-sizing: border-box;" fr-original-style='margin:0cm;font-size: medium;font-family:"Arial",sans-serif;color:black;'><span style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">COURT OF PROTECTION&nbsp;</strong></span></p><ul style="list-style-type: undefined; margin-left: 26px; box-sizing: border-box;" fr-original-style="list-style-type: undefined;margin-left:26px;"><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">What it is and what is does</li><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);">When and how to contact them&nbsp;</li><li style="font-size: 16px; color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="font-size: 16px; color: rgb(0, 0, 0);"><span lang="EN-US" style="font-family: Arial, sans-serif; box-sizing: border-box;" fr-original-style="font-family: Arial, sans-serif;">Timescales and their charges<br fr-original-style="" style="box-sizing: border-box;"></span></li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-family: Arial, sans-serif; color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" fr-original-style="font-family: Arial, sans-serif; color: rgb(0, 0, 0); font-size: 16px;">Philip is the Managing Director of Renaissance Legal. He&nbsp;specialises in helping families and carers of disabled and vulnerable people plan for their future using Wills, Trusts, Powers of Attorney, Court of Protection applications and Inheritance Tax Planning.&nbsp;</span><span style="font-family: Arial, sans-serif; font-size: 16px; box-sizing: border-box;" fr-original-style="font-family: Arial, sans-serif; font-size: 16px;">Philip&nbsp;regularly speaks at seminars on behalf of many local and national charities including Mencap, NAS and Sense. &nbsp;</span></p>

If you are a parent or carer of a child or young person who may not be able to make decisions about their welfare and finances now or in the future, you will need to consider the best ways to protect them as they move to adulthood. 
 
Philip Warford, Lawyer and specialist in planning for the future of disabled & vulnerable people, will talk through the key principles of the Mental Capacity Act 2005, who can make a Powers of Attorney and how the Court of Protection might help.
 
Philip will discuss:


 MENTAL CAPACITY 
What is mental capacity & who assesses mental capacity
What affects mental capacity
Different levels of capacity for different things
How the Mental Capacity Act 2005 affects us
POWERS OF ATTORNEY 
What is a Power of Attorney
Lasting Powers of Attorney explained
COURT OF PROTECTION 
What it is and what is does
When and how to contact them
Timescales and their charges
Philip is the Managing Director of Renaissance Legal. He specialises in helping families and carers of disabled and vulnerable people plan for their future using Wills, Trusts, Powers of Attorney, Court of Protection applications and Inheritance Tax Planning. Philip regularly speaks at seminars on behalf of many local and national charities including Mencap, NAS and Sense. 

Born at the Right Time

Disability

leading expert Philip Warford will talk about the options available to protect a disabled person using specialist Wills and Trusts

Decision Making for Vulnerable People Webinar 

<p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);">Competition in the communications sector is complex and fast-changing. This presents both risks and opportunities to providers, as well as challenges for public authorities.</p><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Would you like to gain expert insights on the practical applications of competition law in the regulated telecoms industry? <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Then, this training is for you!</strong></p><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">Presented by experts through practical case examples, this <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">online training</strong> will guide you through the latest competition law developments affecting the telecoms industry and give you a full overview of the role played by competiton law in shaping the telecoms market.</p><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Topics covered include:&nbsp;</strong></p><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li fr-original-style="" style="box-sizing: border-box;">Relationship between competition law and sector-specific telecoms regulation</li><li fr-original-style="" style="box-sizing: border-box;">Market definition</li><li fr-original-style="" style="box-sizing: border-box;">Telecoms mergers</li><li fr-original-style="" style="box-sizing: border-box;">Antitrust aspects of network co-operation</li><li fr-original-style="" style="box-sizing: border-box;">Typical abuses of dominance in the telecoms sector</li><li fr-original-style="" style="box-sizing: border-box;">Broadband state aid&nbsp;</li></ul><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">When:&nbsp;</strong>17-19 September 2024 - <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">9 hours of interactive sessions spread over 3 days</strong></p><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Where:&nbsp;</strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Online</strong>, using Microsoft Teams</p><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Cannot make it to one of the sessions?</strong> All sessions will be <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">recorded</strong> and made available to <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">registered participants</strong>.</p>

Cullen International SA

Telecommunications

Competition Law in the telecoms sector

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This class has something for everything, from beginners who wish to customise their data entry forms in SharePoint right up to advanced users who need to use advanced formulas to deliver more bespoke actions to their apps.</p>Overview<p>After taking this course, students will be able to: - Understand when to use PowerApp. - Describe the components of PowerApps and their correct use. - Create PowerApps from existing data sources. - Brand PowerApps. - Customize PowerApps beyond just using the automated wizards. - Connect to a range of data sources from Excel to Azure SQL. - Understand the difference between canvas apps and model-driven apps. - Integrate PowerApps with other Office 365 systems ? including Teams and SharePoint Online. - Administer and Maintain PowerApps</p><p>Students will be taught how to design, test and publish new apps that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their business.</p></div><div id="course-pills-2"><h3>1 - AN INTRODUCTION TO POWERAPPS</h3> <ul> <li>What is PowerApps?</li> <li>The benefits of apps</li> <li>How to get PowerApps</li> <li>Canvas Apps and Model-Driven Apps</li> <li>License Options and Costs</li> <li>Discover PowerApps with Templates</li> <li>Lab 1: Introduction to PowerApps</li> </ul> <h3>2 - GETTING STARTED WITH POWERAPPS</h3> <ul> <li>Building a new app from a data source</li> <li>Add, edit and remove controls</li> <li>Intro to Formulas</li> <li>Testing an app</li> <li>App Settings</li> <li>Publish and Share Apps</li> <li>Version History and Restore</li> <li>PowerApps Mobile App</li> <li>Lab 1: Getting Started</li> </ul> <h3>3 - BRANDING AND MEDIA</h3> <ul> <li>Less is more</li> <li>Duplicate Screens</li> <li>Fonts</li> <li>Screen Colours and Matching Colours</li> <li>Screen Backgrounds</li> <li>Buttons and Icons</li> <li>Hide on Timer</li> <li>Size and Alignment by reference</li> <li>Show and Hide on Timer</li> <li>Lab 1: Branding and Media</li> </ul> <h3>4 - POWERAPPS CONTROLS</h3> <ul> <li>Text Controls for Data Entry and Display</li> <li>Controls ? Drop downs, combo box, date picker, radio button and more</li> <li>Forms ? Add and edit data in underlying data sources quickly</li> <li>Charts ? present information in pie, line and bar charts</li> <li>Lab 1: Build Apps from Blank</li> </ul> <h3>5 - DATA SOURCES AND LOGIC</h3> <ul> <li>Data Storage and Services</li> <li>How do I decide which database to use?</li> <li>Connect to on-premises data - Gateway</li> <li>What is Delegation?</li> <li>Specific Data Examples</li> <li>Displaying Data</li> <li>Lab 1: Data Source and Logic</li> </ul> <h3>6 - MODEL-DRIVEN APPS</h3> <ul> <li>What is a model-driven app?</li> <li>Where will my data be stored?</li> <li>How do create a model-driven app</li> <li>Canvas vs model-driven summary</li> <li>Lab 1: Model-Driven App</li> </ul> <h3>7 - POWERAPP INTEGRATION</h3> <ul> <li>Embed PowerApps in Teams</li> <li>Embed PowerApps in SharePoint Online</li> <li>Start a Flow from a PowerApp</li> <li>Lab 1: PowerApp Integration</li> </ul> <h3>8 - ADMINISTRATION AND MAINTENANCE OF POWERAPPS</h3> <ul> <li>Identify which users have been using PowerApps</li> <li>Reuse an app in another location (move from testing or development to production)</li> <li>Review app usage</li> <li>Prevent a user from using PowerApps</li> <li>Manage environments</li> <li>Lab 1: Administration and Maintenance</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55265 Microsoft PowerApps training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the 55265 Microsoft PowerApps course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Microsoft Power Apps

Power Apps

Microsoft AZ-900

Microsoft Power Platform

Microsoft AZ-700

Microsoft Power Automate

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">One of the criticisms levelled at the Real Estate sector is that it has traditionally been a well-connected space, with entry to it dictated by who you know, rather than what you know. With many University degrees in Real Estate teaching theoretical knowledge, how can you articulate this experience on a CV, and obtain greater practical experience with skills like modelling capabilities? In this webinar, Directors at Cobalt Recruitment, Maria Sinclair and Tom Enefer, will go through what new entrants to the Real Estate sector need to have on their CV and the avenues they can take to get more practical experience, including:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">How you can communicate your education and modules studied effectively with employers</li><li fr-original-style="" style="box-sizing: border-box;">Tips to make your CV stand out</li><li fr-original-style="" style="box-sizing: border-box;">The industry apprenticeships available</li><li fr-original-style="" style="box-sizing: border-box;">Relevant internships on offer</li><li fr-original-style="" style="box-sizing: border-box;">The university sandwich year placements there are</li><li fr-original-style="" style="box-sizing: border-box;">Courses you can take to get a better understanding of the sector</li></ul>

One of the criticisms levelled at the Real Estate sector is that it has traditionally been a well-connected space, with entry to it dictated by who you know, rather than what you know. With many University degrees in Real Estate teaching theoretical knowledge, how can you articulate this experience on a CV, and obtain greater practical experience with skills like modelling capabilities? In this webinar, Directors at Cobalt Recruitment, Maria Sinclair and Tom Enefer, will go through what new entrants to the Real Estate sector need to have on their CV and the avenues they can take to get more practical experience, including:
 
How you can communicate your education and modules studied effectively with employers
Tips to make your CV stand out
The industry apprenticeships available
Relevant internships on offer
The university sandwich year placements there are
Courses you can take to get a better understanding of the sector

Bayfield Training

One of the criticisms levelled at the Real Estate sector is that it has traditionally been a well-connected space, with entry to it dictated by who you know, rather than what you know. With many University degrees in Real Estate teaching theoretical knowledge, how can you articulate this experience on a CV, and obtain greater practical experience with skills like modelling capabilities? In this webinar, Directors at Cobalt Recruitment, Maria Sinclair and Tom Enefer, will go through what new entrants to the Real Estate sector need to have on their CV and the avenues they can take to get more practical experience, including:

- How you can communicate your education and modules studied effectively with employers
- Tips to make your CV stand out
- The industry apprenticeships available
- Relevant internships on offer
- The university sandwich year placements there are
- Courses you can take to get a better understanding of the sector


2713 Courses in Edinburgh

We will help you to find the right course for you

By EU Network

Individual Development Programme (IDP)

By CORE theatre arts training

Fathers and Perinatal Mental Health

By Mark Williams

WINDSOR GUITAR LESSONS, YOUR GUITAR INSTRUCTOR

By Windsor Guitar Lessons

Mindfulness and grounding skills

By Bogumila Malinowska /Counselling/Psychotherapy in Person and online in London

Building Creative Thinking

By Kevin Chamberlain

Sound journey & gong baths for festivals, corporate functions, weddings, etc

By Robin Freeman - Sacred Sound Healing

Private Reiki sessions within the comfort of your own home.

By Robin Freeman - Sacred Sound Healing

Outdoor sound journey & gong bath / all night puja’s & other special events

By Robin Freeman - Sacred Sound Healing

Private 1:1 or 2:1 Sound Healing sessions in the comfort of your own home.

By Robin Freeman - Sacred Sound Healing

Search By Location