202 Memory courses

Super fun, interactive educational baby and toddler music classes with live guitar. Independently run by mother and son, Tin Pan Annie Music have been the award winning proividers of pre-school music classes in South London for nearly 30 Years. Classes are carefully written and designed to super-charge all the developmental and social skills that participating in a live music class can bring. Young children react in such a positive way to live acoustic guitar accompaniment when their world is so full of so much pre-recorded sound. Expect lots of familiar songs and Tin Pan Harry originals, written to introduce children to the shape, timbre, dynamics and rhythm of music which are so important in the development of language and speech. As well as joining in by clapping, dancing and swaying, the children also participate with rhythm sticks, percussion, and silly scarves, Lots of bright colourful props and puppets appear from Tin Pan Annie’s toy box to bring each week’s theme to life, concentration and memory skills develops and their imagination soars. Classes are the highlight of your child's week and often the grown ups too.

This 2 day programme is designed to support practitioners from all health, care, community and voluntary sectors to learn how to use health coaching effectively in their current roles. It will give you the opportunity to build on the many skills you already possess and learn how a health coaching approach can very usefully support your work. This is a highly interactive programme with an emphasis on skill practice and development. The programme will be delivered using a participative and experiential learning process supported by expert input. We will create many opportunities to practice skills and challenge you to identify how you can apply their learning to your own work place settings. Further, the programme will provide an opportunity to discuss applications of health coaching in your system, develop relationships and network with others. We emphasise skills for embedding health coaching through on-going practice, reflection and planning as reflexive practitioners. We follow-up these programmes with a series of e-learning based health coaching shots that comprise brief inputs and memory aids to support you in the application of their learning after the workshop. Please note that even though these courses are funded, please make every effort to attend. if you are unable to attend please let us know as early as possible so that someone else may benefit, thank you!

Private mosaic making class with Mossy Mosaic at The Arienas Collective in central Edinburgh.

Introducing the Occupational Therapy Package: Empowering Independence and Enhancing Daily Living Are you seeking specialized support to enhance your daily living skills and regain independence in your life? Miss Date Doctor’s Occupational Therapy Package offers you expert guidance and personalized interventions to overcome challenges and achieve your goals. Occupational therapy is a client-centered approach that focuses on improving functional abilities and promoting independence in various aspects of life. Our experienced occupational therapists are committed to empowering you to participate fully in meaningful activities and overcome obstacles that may be affecting your daily functioning. Here’s how the Occupational Therapy Package can support you: Comprehensive Assessment: Our occupational therapists will conduct a thorough assessment of your physical, cognitive, and emotional abilities to understand your unique needs and challenges. Personalized Goals: Based on the assessment, we’ll work with you to set personalized goals that align with your aspirations and desired outcomes. Functional Interventions: Through a range of evidence-based interventions, we’ll address challenges related to self-care, productivity, and leisure activities, helping you regain independence in your daily life. Adaptive Techniques: Our therapists will introduce you to adaptive techniques and assistive devices that can support your engagement in various activities and promote greater autonomy. Workplace Support: For individuals seeking occupational therapy for work-related challenges, we’ll provide support and recommendations to improve workplace ergonomics, time management, and productivity. Cognitive Strategies: If cognitive challenges are affecting your daily functioning, our occupational therapists will introduce cognitive strategies to enhance memory, attention, and executive functions. Sensory Integration: For individuals experiencing sensory processing difficulties, our therapists will employ sensory integration techniques to help you better process sensory information and improve daily functioning. Lifestyle Modification: Occupational therapy goes beyond managing symptoms; it aims to improve overall well-being. We’ll work with you to make lifestyle modifications that promote health and balance. The Occupational Therapy Package at Miss Date Doctor is tailored to meet your unique needs and goals. Our compassionate occupational therapists will collaborate with you every step of the way to ensure that your therapy experience is positive, empowering, and transformative. Experience the benefits of occupational therapy and embrace a more independent and fulfilling life. Invest in your well-being and unlock your potential to thrive in everyday activities. Take the first step towards empowerment and enhanced daily living with the Occupational Therapy Package. Let our expert therapists guide you towards a life filled with greater independence, productivity, and satisfaction. 4 X 1 hour https://relationshipsmdd.com/product/occupational-therapy-package/

A workshop to reflect on important experiences in your life and to develop your autobiographical writing skills.

What is included? Footwork Walking & Leading technique Taught by Female & Male native dance instructor Fully equipped dance studio Free car park (in the street) Name of the steps & routine taught in detail Access to a cloud platform with videos & music (only if you sign up for the course) A night out upon termination Playlist shared on Spotify or Apple Music Lots of fun, steps & routines every week Free Music on the Club App for Android & Apple Mobile phones Brain cognitive issues improvement techniques (Muscle memory) Beginners @ 8 PM Please book your course in advance by buying your first two tickets at @£11 each then if you loved it sign up for the 10 weeks course. Bachata lesson for couples & singles in Hammersmith, Chiswick & Barnes with Club Azucar – Latin dance taught by native instructor Ginu Nunez from Latin America  Bachata lesson for couples in London with Club Azucar is a real experience of dancing, we have been delivering private Bachata classes in Hammersmith, Chiswick & Barnes for almost 10 years now and we will be continuing in this fun business for group lessons, we keep the core structure of the Latin dance in a very organic and simple way. Benefits of the Bachata program: – Great dynamic low impact workout – coordination & focus – Easy, non-intimidating learning environment – Weight loss – Positive self-image – A sculpted body – Stress relief and social life interaction, What else are you looking for to get in great shape? T & C First class is not refundable & transferable The course has a beginning & end date All participants must sign up with their name & mobile # Once you purchase your course you must complete it within the time frame of the course duration We reserve the right of admission This course is for couples only and one female & male

Teaching basic number skills to children with Down syndrome and other learning difficulties using the Numicon approach. Basic number skills are vital to enable everyday social inclusion and independence. The training will commence with an overview of the learning profile of a child with Down syndrome; exploring working memory and how this impacts on learning numbers. It will detail how children learn basic number skills – recognising numbers, saying number names, counting to find ‘how many?’ and early hands on addition. It will explore the challenges faced by children who have Down syndrome and other learning disabilities and demonstrate how the use of Numicon as a visual representation of number can help to overcome these difficulties and lead to increased understanding and confidence.

Person centred rehabilitation is designed to create a better life for an individual by the provision of an intense input designed to being about social change. This usually entails a series of visits focused on getting the person out and about to increase confidence, social skills and presence in their local community and to pursue goals and dreams. Usually, the work is carried out under the close clinical supervision of a practicing psychologist. Course Category Inclusion Person Centred Planning Visioning and Problem Solving Peer Support Description Person Centred Rehabilitation Person centred rehabilitation is designed to create a better life for an individual by the provision of an intense input designed to being about social change. This usually entails a series of visits focused on getting the person out and about to increase confidence, social skills and presence in their local community and to pursue goals and dreams. Usually, the work is carried out under the close clinical supervision of a practicing psychologist. PERSON CENTRED PLANNING A Person Centred Planning event would be carried out using the PATH or MAP process – majoring on dreams and goal setting leading to precise action planning. Facilitators would carry out the PATH or other person centred process. A large graphic will be one of the outcomes of the meetings this is a great visual record and a shared memory of the event. This will also inform the priorities for the later follow up inclusion facilitation work. Following the PATH event a ‘scoping report’ is created outlining what Inclusion Facilitation could offer and highlighting what dreams and goals the individual has. INCLUSION FACILITATION The PATH is also provides a good opportunity for the Facilitator to meet the focus person in a comfortable positive environment. Agreed visits from the Inclusion Facilitator are then carried out over a 3 month period. After this intensive input the Inclusion Facilitator will hand over to the existing family, carers and PA team to carry on where he or she has left off. This transition time is planned from the outset. An experienced psychologist needs to be there to support the facilitator at all times and will guide all work done by the inclusion facilitator. Is this just Support work? No! This is proactive engagement – doing whatever is required. This is not passively or reactively providing what is asked for – we are actively pursuing a good life for the individual. The work is built on careful research around a person’s interests and what opportunities exist locally There is community mapping There is work to tackle an individual’s own resistance and reluctance to engage more socially There is a need to engage with people in social settings that the individual attends to build bridges and connections – we are bridge builders You will need to build circles around a person There is a need to create the conditions in which friendships can flourish There is a need for direct psychological supervision and support throughout This work is short term and intense. The facilitator’s main aims will vary depending on the dreams and goals of the focus person. The basic aim of the inclusion facilitator is to better the focus person’s quality of life. Learning Objectives 1 To create a better life for the Individual. 2 Give Individual and family a clear vision of a good life and to support first steps towards this 3 To maximise individuals inclusion and connection with the wider community. 4 To help with friendship, social connection and education 5 To increase confidence, social skills and presence in their local community and to pursue goals and dreams. Who Is It For? Anyone who is involved in the rehabilitation of children or adults who have become disabled through accident or trauma and who is committed to helping them get their life back on track. Course Content Understanding ordinary needs – the dimensions of social inclusion Pursuing the dreams and goals of the individual Improving social skills Community Mapping Being comfortable in social environments Developing conversational skills Having a positive mindset Staying physically active Building relationships Help in meeting new people Create natural circles of support Creating a community circle Having positive body language Employment of support staff Pursuing personal interests   If you like this you will almost certainly enjoy: Person Centred Planning using PATH and MAPs

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins

A three-hour workshop designed to inspire and guide you in writing your personal stories led by local bestselling author and certified book coach Emma Dhesi. This beginner-friendly workshop is designed as a no-pressure, exploratory space where you can connect with your creativity and reflect on your personal experiences. It's ideal for anyone who wants to explore memoir writing and storytelling techniques, whether you’re reflecting on your own life, telling a loved one’s story, or capturing memories tied to a craft or creative activity. You will: Learn practical techniques for uncovering and organising your ideas through memory mapping. Practice sensory writing to make your memories vivid and immersive. Write a heartfelt first scene of your memoir or personal essay, using a simple three-part structure: Hook, Scene, and Reflection. Share your work (optional) and receive encouraging feedback in a supportive group setting. Emma will provide guidance and step-by-step activities to help you structure and enhance your writing, and you will leave with the start of a memoir chapter, or personal essay, and practical tools to continue writing at home. All materials are included, plus a handout with writing prompts, tips, and recommended memoirs for further inspiration. Just bring your ideas and enthusiasm! If you have specific memories or objects you’d like to write about, feel free to bring those for inspiration. More information The Arienas Collective workshops, courses and events are run from a welcoming and supportive environment within a Georgian mews home in Edinburgh’s City Centre New Town. We invite you to join us, leave any day-to-day worries behind and immerse yourself in being creative. Spaces on our workshops and courses are limited so that our creative team of artists and makers can offer you the hands-on help and support you need to make the most of your time with us. Our taster and introductory workshops focus on teaching creative skills and methods you can continue practising at home, using affordable materials and equipment. Where more expensive equipment is required we will mention this in the workshop description. All the equipment and materials you need are included in the price, unless stated otherwise. Light refreshments from local suppliers are provided. On full day workshops you are welcome to bring your own lunch to eat inside or out. There is also a wide range of independent sit-in or takeaway delis, cafés, and restaurants, plus a range of supermarkets all within a 5-10 minute walk. Accessibility The workshop space is on the first-floor of our Georgian mews home and unfortunately we do not have lift access. Blue badge holders can park outside our front door on the single yellow line by arrangement. Allergies The workshop space is in our open plan living space and is not nut free. Please let us know about any skin or food allergies before booking. We offer a dairy-free milk and gluten free snack alternative. Minimum number no refund policy To ensure we can always pay our creatives a fair fee, we require a minimum number of bookings for each workshop and for this reason bookings are non-refundable. Should we have to cancel due to low numbers, we will offer you the option to swap to an alternative date or workshop, or to request a refund. We do our very best to avoid cancellations. Since we often get late bookings, we keep our workshops on sale for as long as possible. We realise that some of you travel from afar, so if you book a space and have not yet received an email confirming your workshop is going ahead and need to make plans for your trip, please get in touch before booking any travel or accommodation so we can update you on booking numbers. Or check in before booking. Private workshop bookings Most of our workshops are also available to book for: private get-togethers with family and friends; themed wedding and birthday celebrations; corporate team building and well-being purposes; and in-store retail events for your customers. If you’d like to know more please Email Lynn. Age restrictions Our workshops are planned with adults in mind. Many are suitable for teenagers, but some may require under 16s to be accompanied for insurance purposes. Please check with us before booking.