115 Courses in Edinburgh

Disciplined Agile Scrum Master (DASM): In-House Training Is your team treading water using waterfall? Do you feel trapped in an agile framework? Would you like to find solutions to the problems you've been wrestling with? Are you looking for ways to enhance your team's agility? Break free from your old ways by choosing a way of working that fits your team's context. Find strategies to improve your processes and strengthen your team with the Disciplined Agile® tool kit. Disciplined Agile Scrum Master is a nine-lesson, instructor-led course that shows you how to use Disciplined Agile (DA™) to improve your team's way of working. In just two days, you will become familiar with foundational agile and lean practices that DA supports, practice using the tool kit to solve problems, and learn how to build high-performance teams. Filled with activities, animations, supplemental reading, and more, this course will prepare you to take the Disciplined Agile Scrum Master (DASM) exam and, equally important, start using Disciplined Agile immediately. #BBD0E0 » What You Will Learn After the completion of this course, you will be able to: Apply foundational agile and lean practices in your own team setting Describe what business agility is and how it is core to value proposition of Disciplined Agile® Describe the significance of the Disciplined Agile mindset Define the DA™ principles, promises, and guidelines and how they set Disciplined Agile apart from other frameworks Explain how people are organized into DA teams Define the primary DA roles and how they each are key to the success of a self-organizing agile team Explain how to help your team work well together using the Lean principle of 'respect people' Analyze your team's context to make better process-related decisions Select the best-fit DA life cycles for your teams Apply the five DA steps of choosing your team's way of working (WoW) Apply the relevant agile and lean techniques to successfully initiate your team Apply the relevant agile and lean techniques to support your team producing business value Apply the relevant agile and lean techniques to support your team releasing their work into production Apply the relevant agile and lean techniques to support your team on an ongoing basis Recognize when to be resilient List and define the principles of Lean Significance of the Disciplined Agile® Mindset Business agility and how it is core to value proposition of Disciplined Agile Eight DA principles and how they are core to what sets Disciplined Agile apart from other agile frameworks Which situations each of the DA™ life cycles is best applied DA Practice of choosing a team's way of working (WoW) Foundations of Agile How people are organized into DA teams Primary DA roles and how they each are key to the success of a self-organizing agile team Help your team work well together (Lean principle 'Respect people') Inception phase and why it is important DA tool kit to tailor your way of working within a select phase according to context Agile techniques and ceremonies relevant to Inception Construction phase and why it is important Agile techniques and ceremonies that take place during Construction Eliminate Waste and Build Quality (Lean principles) Deliver Value Quickly (Lean principle) Transition phase and why it is important Ongoing phase and why it is important Learn Pragmatically (Lean principle) Elements of the process blade (onion) diagram Principles of Lean When to be resilient Benefits of explicit workflow Kaizen loops and PDSA techniques for continuous improvement Options for cross-team learning: "community of practice" and "center of excellence"

This half-day Suicide First Aid Lite training course gives learners the knowledge and tools to understand that suicide is one of the most preventable deaths and some basic skills can help someone with thoughts of suicide stay safe from their thoughts and stay alive.

The ceremony invites us to let go of all the distorted perceptions of the Feminine and reclaim her true nurturing qualities. The Spirits of Cacao and Rose will assist and support our journey with their alchemical transformative energy. The event combines Shamanic Journeys, Cacao and Rose Ceremony (following the energy of the Mayan calendar) and Sacred Sounds.

Anaphylaxis is a severe and life-threatening allergic reaction, which requires immediate medical attention. With the number of sufferers increasing each year, it is extremely important to know what to do when faced with this acute emergency condition.  The QA Level 2 Award in Basic Life Support and Management of Anaphylaxis (RQF) qualification has been designed for those who have a specific responsibility at work, at home or in voluntary and community activities, to provide basic life support and manage anaphylaxis when dealing with an emergency. Successful candidates will be able to recognise the signs and symptoms of anaphylaxis, and will be equipped with the vital skills needed to administer safe, prompt and effective treatment.

Pilates and Yoga Fusion is a low-impact workout that seamlessly blends the core-strengthening principles of Pilates with the flexibility-enhancing poses of Yoga. This unique combination offers a well-rounded practice that focuses on strength, stability, balance, and deep stretching, all performed on a mat. By incorporating mindful movement, breathwork, and intentional body alignment, this class helps to improve flexibility, mobility, and overall well-being. This class is designed for all fitness levels, whether you’re new to Pilates and Yoga or have prior experience. Our session includes a mix of flowing Yoga-inspired sequences to promote relaxation and flexibility, combined with Pilates-based exercises to engage the core and build functional strength. The emphasis on stretching helps release tension, improve posture, and enhance mobility, making it an excellent practice for anyone looking to move with greater ease in daily life. Beyond the physical benefits, Pilates and Yoga Fusion encourages mindfulness and body awareness, helping you feel more present and connected. The class environment is welcoming and supportive, providing a space to unwind, reset, and invest in your well-being. Join us for a class and experience the perfect balance of strength and flexibility! Whether you’re looking to tone your muscles, relieve stress, or improve your range of motion, this fusion workout offers something for everyone. Come move, stretch, and breathe with us—you’ll leave feeling stronger, more flexible, and completely refreshed. Egle is a fully qualified Level 3 (UK) Personal Trainer, Pilates Mat Teacher, Yoga Teacher, Sports Massage Therapist, Outdoor Fitness Instructor, and Group Exercise Instructor. Passionate about health, fitness, well-being, and nutrition, she firmly believes that the fitter and healthier a person is, the more enjoyable life becomes. Egle works with individuals of all fitness levels, from those who have never stepped into a gym or exercise class to those seeking their next challenge. Her main focus is to provide a diverse range of services tailored to meet various health and fitness needs. She is also deeply committed to injury prevention and rehabilitation, helping clients move safely and effectively toward their goals. This class is sponsored by Cash4Clubs, Sported and Flutter UKI It is FREE and is aimed at adults (particularly, but not only 18-25), women, etnic minorities, any individuals from low-income background. Suitable for all levels experience. By attending this class you release the teacher, Giada Gaslini and Art and Spirituality Cic, from any liability arising out of any personal injuries, emotional or physical release, death, physical reaction, expectations of results, theft in the venue or damages that may happen to people and objects while attending. Pictures will be taken during the workshop, if you prefer not to be in them, please inform the teacher.

EPFA and EFAW combined course

Introducing the Dating Profile Specialist Package: Elevate Your Online Dating Experience with Expert Guidance Are you seeking professional assistance to create an exceptional online dating profile that stands out and captures the attention of potential matches? Miss Date Doctor’s Dating Profile Specialist Package offers you personalized guidance and support from experienced specialists who are dedicated to helping you present your best self in the online dating world. Crafting a standout dating profile requires expertise and insight into what makes a profile truly captivating. Our specialized dating profile experts are committed to helping you showcase your unique qualities and increase your chances of making meaningful connections. Here’s how the Dating Profile Specialist Package can support you: Personalized Assessment: Our dating profile specialists will conduct a thorough assessment to understand your personality, interests, and dating goals. Tailored Profile Creation: We’ll work with you to create a personalized and compelling dating profile that reflects your authentic self. Photo Selection: Our experts will provide guidance on selecting and arranging photos that highlight your best features and personality. Attention-Grabbing Bio: We’ll help you craft a captivating bio that effectively communicates your values, hobbies, and what you’re looking for in a partner. Showcasing Unique Qualities: Our specialists will assist in highlighting your unique qualities and qualities that set you apart from the crowd. Online Etiquette Guidance: We’ll provide insights into how to initiate conversations, maintain engaging communication, and build connections. Boosting Confidence: The Dating Profile Specialist Package can boost your confidence by providing expert support in creating an impressive and authentic profile. Attracting Compatible Matches: We’ll work towards attracting matches who resonate with your personality and are genuinely interested in connecting with you. The Dating Profile Specialist Package at Miss Date Doctor is designed to empower you with a standout online dating profile that captures your true essence. Our specialized dating profile experts provide tailored guidance and practical advice to help you make a lasting impression in the online dating community. Invest in your online dating success and take the first step towards a captivating dating profile with the Dating Profile Specialist Package. Embrace the opportunity to showcase your best self and attract matches that align with your values and aspirations. Let our experts guide you towards an enhanced online dating experience filled with meaningful connections. 4 sessions x 1 hour 20 new photos using Artificial intelligence approved https://relationshipsmdd.com/product/dating-profile-specialist/

Healing Circles are not the same as "women’s circles" or the gatherings that have become more common in recent times. In traditional shamanic cultures, healing took place within the entire tribe rather than just in one-on-one sessions. The community saw itself as a unified whole, where each person contributed to the well-being of others. When someone became unwell, it affected everyone, so the group shared the responsibility of restoring balance and health. In these communal healing sessions, a powerful collective energy would emerge, greatly amplifying the healing process for the person in need. This is what we aim to recreate during our weekend together: a strong, collective contribution where everyone plays a part in the healing of those in need. You will have the opportunity to: Receive healing Channel spirits and offer your support to others Trained practitioners will guide the healing process. At the start, I will provide a thorough introduction to shamanism and healing, so no prior experience is required—just an open heart filled with unconditional love. If joining online, please have a wooden stick and any other tools you feel connected to (such as feathers, stones, drums, rattles, sound instruments, crystals—whatever you wish to bring). If attending in person, feel free to bring any healing tools you like or come as you are, with nothing at all. If you feel the call to become a practitioner, join our waitlist for the Year Course starting in October 2025 https://shamanicpractitioner.scoreapp... Giada's Journey Creative explorer of the human well-being with twenty years’ experience running events, workshops and retreats. Co-author of a non-profit book with other 33 Italian women about their stories in different countries. She has been learning to heal herself supporting a Holistic connection between mind, body and spirit. She has been studying and practicing Buddhist teachings, meditation and the Five Tibetan Rites Yoga in Nepal, India and Italy. Approached the imaginal world and dreams with the psychologist Elio Occhipinti and a regressive hypnosis journey with the vision of the psychiatrist Brian Weiss.  Her studies and practice have helped her become: Shamanic Practitioner and Teacher with the two years formal training in Scotland and Teacher Training in Wales  Shamanic and Integral Yoga Teacher, Ikigai Coach, Forest Therapy Guide qualified with Selene Calloni Williams at the Imaginal Academy and part of the Italian-Swiss Association for Counselling and Coaching, Aiscon.  Professional Esoteric Numerologist graduated at The Connaissance School of Numerology Corporate Mental Health Coach achieved with WeFocus Founder of Drink In Art exhibitions of local artists in private flats Founder of School of Shamanism creative and spiritual workshops, classes and therapies Founder of the Art and Spirituality Centre centre for creativity and well-being in Edinburgh By attending to our classes, workshops and retreats you agree to our TERMS AND CONDITIONS Payment  Bookings are non-refundable.  Disclaimer  By booking a class or workshop or retreat or 1-1 session -online or any other venues – with us, you release Giada Gaslini, Invisible Caims/School of Shamanism and any business partners working with Invisible Caims from any liability arising out of any personal injuries, emotional or physical release, death, expectations of results, theft in the venue or damages that may happen to people and objects while attending. We recommend that you consult your GP regarding the suitability of undertaking an exercise programme, if the class you are booking includes it like with yoga or similar, and following all the safety instructions required before beginning to exercise. When participating in an exercise, there is the possibility of sustaining a physical injury. If you engage in this exercise programme, you agree that you do so at your own risk, are voluntarily participating in these activities and assume all risk of injury to yourself. You acknowledge that coaching, shamanic healing and counselling are not to be used as a substitute for psychotherapy, psychoanalysis, mental health care, or other professional advice by legal, medical or other professionals. Our sessions are aimed at inner research, problem solving and personal growth, they do not replace the work of doctors and psychotherapists because they do not consider, treat or aim to solve pathologies and symptoms that are strictly medical. All contracts subject to and governed by English Law and the exclusive jurisdiction of the Courts of England and Wales according to my current insurance.  

This 2 - 2-5 hour course is designed is designed to provide parents and carers with the opportunity to: Develop the basic skills and knowledge needed to deal with a wide range of emergency paediatric First Aid situations, which could arise when looking after babies and children. The course can take place in in a community group or in the comfort of your home, with family and friends who maybe caring for your child or they may have children of their own. The course can be booked during the week, week nights or weekends, with or without children present. The idea is to bring the skills and knowledge to you, in your normal routine.

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