7054 Courses in Kettering delivered Live Online

Duration 1 Days 6 CPD hours This course is intended for Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology. Overview Upon successful completion of this course, students will be able to: - Use subqueries to generate query output. - Manipulate table data by inserting, updating, and deleting records in a table. - Manipulate the table structure. - Create views, manipulate data through views, modify the view structure, and drop views. - Create indices on table columns and drop inefficient indices. - Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction. In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process. Prerequisites SQL Querying Fundamentals - Part 1 1 - Using Subqueries to Perform Advanced Querying Search Based on Unknown Values Compare a Value with Unknown Values Search Based on the Existence of Records Generate Output Using Correlated Subqueries Filter Grouped Data Within Subqueries Perform Multiple-Level Subqueries 2 - Manipulating Table Data Insert Data Modify and Delete Data 3 - Manipulating the Table Structure Create a Simple Table Create a Table with Constraints Add or Drop Table Columns Add or Drop Constraints Modify the Column Definition Back Up Tables Delete Tables 4 - Working with Views Create a View Manipulate Data in Views Create Aliases Modify and Drop Views 5 - Indexing Data Create Indices Drop Indices 6 - Managing Transactions Create Transactions Commit Transactions

Banish those presentation gremlins and communicate with confidence and clarity!

Most trainers are self-taught or have attended short courses and don't have the time to take their skills to the next level. Give staff the skills to understand how and what to train, and to use our special learner-centred techniques to boost the effectiveness and impact of their training courses.. This course includes: Assessing your learners’ skills and abilities Understanding how people learn Learning and training theories Planning and timing an effective session Essential training techniques Assessment and evaluation of learning

This Dementia Train the Trainer course is run over 2 days, you will learn about the subject and know how to teach About this event Understanding dementia Common types of dementia How the brain is affected Causes and symptoms Person centred care Communication Learning about the persons past Care planning The role of friends and relatives Building relationships Equality and diversity in dementia Recognise and help prevent abuse Non-verbal communication Event lasts 1 day 7 hours Understanding dementia Common types of dementia How the brain is affected Causes and symptoms Person centred care Communication Learning about the persons past Care planning The role of friends and relatives Building relationships Equality and diversity in dementia Recognise and help prevent abuse Non-verbal communication

Definition of Safeguarding Legislation & agreed ways of working Definition of Safeguarding Legislation & agreed ways of working Every child matters guidance Myths and statistics Effects on young people Leadership/worker skills Common indicators of abuse Reporting of abuse and potential abuse Barriers to reporting abuse Understanding the types of abuse Recognising acts, signs and symptoms of abuse Who is vulnerable / at risk The role of dignity in safeguarding Legislation and policies and procedure What to do should you have a concern Overview of prevent How to respond to an individual should they disclose a concern

The course is run over 2 days you will learn about and how to teach and assess the following key areas: Policies. Legislation. CQC The course is run over 2 days you will learn about and how to teach and assess the following key areas: Policies. Legislation. CQC Medication. Routes. Formulation. Types. Absorption. MDT. Roles and Responsibilities. Levels of support. Boundaries and agreed ways of working. Order. Receive. Store. Record. Transfer. Dispose. 7 R’s. Sources of info. Practical session including MAR charts. Risk assessments. Person Centred Care. Review. Covert. Consent. Refuse. Errors and action. Infection Control and Technique.

About this event Definition of epilepsy Various types of seizures Classification and management of seizures Ethical and legal responsibilities Recognising triggers and precipitants Person centred care Documentation and record keeping The impact of rescue medication and anti-epileptic drug therapy Rescue medications: what it is, it’s uses for epilepsy and side effects Emergency care plan and when to call an ambulance Risk assessment/promotion of safeguarding and dignity Epilepsy medication demonstration

Miss Date Doctor’s Self-Awareness coaching is designed to help individuals develop a deeper understanding of themselves, their needs, and their values. Self-awareness is a critical component of personal growth and development, and our coaching can provide you with the tools and insights needed to enhance your self-awareness and improve your relationships. Our Self-Awareness coaching includes a range of techniques and strategies, such as mindfulness, self-reflection, goal-setting, and identifying and managing limiting beliefs. We can help you develop a clearer understanding of your strengths and weaknesses, your values and priorities, and the ways in which your past experiences may be impacting your present relationships. With our Self-Awareness coaching, you can learn to become more present and grounded in your interactions with others, communicate more effectively, and build deeper, more meaningful connections with your partner or potential partner. The Miss Date Doctor Self Awareness Package Includes the following: Relationship Self-Awareness, Self-Awareness Coaching, Mindfulness, Self-Reflection, Goal-Setting, Limiting Beliefs, Personal Growth, Developing Self-Awareness, Building Self-Awareness, Communicating Effectively, Relationship Building, Understanding Yourself, Self-Discovery, Self-Awareness Techniques. https://relationshipsmdd.com/product/self-awareness-package/

Miss Date Doctor’s Trust Building coaching is designed to help couples and individuals build and strengthen trust in their relationships. Trust is a critical component of any healthy relationship, and our coaching can provide you with the skills and tools needed to establish and maintain trust with your partner or potential partner. Our Trust Building coaching includes a range of techniques and strategies, such as effective communication, setting clear expectations, demonstrating reliability and consistency, and developing healthy boundaries. We can help you identify and address any trust issues that may be impacting your relationship, and develop a plan to rebuild trust if necessary. With our Trust Building coaching, you can learn to establish and maintain a strong foundation of trust in your relationships, improving communication, increasing intimacy, and building a brighter future together. Have three 1 hour sessions with a M.D.D qualified professional couples therapist The Miss Date Doctor Trust Building package includes the following: Relationship Trust, Trust Building Coaching, Trust Issues, Effective Communication, Setting Clear Expectations, Demonstrating Reliability, Consistency, Healthy Boundaries, Rebuilding Trust, Relationship Building, Trust Techniques, Trust Building Strategies, Trust and Intimacy, Trust Training. https://relationshipsmdd.com/product/trust-building-package/

Hysteria’s history, rooted in Greek myth, evolved into a Victorian belief of a “wandering uterus” leading to disturbing medical practices. We aim to explore the lived experiences on irregular perceptions of reality with an open mind. Each Saturday includes: a live dialogue between Prof. Ernesto Spinelli and an International Existential Therapist; a moment to share your thoughts and feelings with the teachers; and a final integration facilitated by Bárbara Godoy. This series of ten dialogues set out to explore the multifaceted dimentions and complexities associated with Existential Therapies. It attempts to engage with various interpretations of insanity through the lens of patients often painful, confounding, and deeply unsettling life experiences. Hysteria- between Prof. Ernesto Spinelli and Bárbara Godoy “In this talk, I will compare the Histerical patient to the ancient Greek myth of Persephone, the goddess who traversed the boundaries between the world of the living and the underworld. Just as Persephone’s cyclical descent and return mirrored the changing seasons, hysteria was seen as a condition where emotions and experiences defied easy classification. This notion of transgressing boundaries became a cornerstone of early psychoanalysis. In Victorian times, hysteria took a decidedly bizarre turn. Here, the culprit was believed to be a mobile womb, an organ capable of throwing into disorder and confusion. This “wandering womb” was blamed for a variety of ailments and behaviours, particularly any expression of female desire out-of-wedlock. In a truly disturbing reflection of these beliefs, legal rulings based on this theory emerged. In some cases, women diagnosed with hysteria could be forced to undergo a hysterectomy.” Bárbara Godoy. Bárbara Godoy M.A., Adv. Dip. Exi. Psy, UKCP accredited Psychotherapist and Supervisor, MBACP and SEA – Director of Therapy Harley Street. Bárbara’s academic experience in London since 2008 includes lecturing and researching on the theory and practice of Phenomenological Existential Therapy on Doctorate, MA and professional courses at the School of Psychotherapy and Counselling Psychology, Regent’s University and the New School of Psychotherapy and Counselling directed by Emmy van Deurzen. Bárbara has facilitated therapeutic Group Work internationally since 1997. The question about the meaning of Being-Woman was the topic of her thesis completed in 2005 and evolved into two main Women’s Groups: “Nine muses” and “Four Seasons” which she leads in addition to her individual private practice. Currently, as the clinical director of THS, Bárbara leads a team of over 20 professional practitioners in the area of Psychological services and Wellbeing consultancy. Bárbara is also the founder-director of THS’s Personal Development and CPD Programmes. Prof. Ernesto Spinelli was Chair of the Society for Existential Analysis between 1993 and 1999 and is a Life Member of the Society. His writings, lectures and seminars focus on the application of existential phenomenology to the arenas of therapy, supervision, psychology, and executive coaching. He is a Fellow of the British Psychological Society (BPS) as well as an APECS accredited executive coach and coaching supervisor. In 2000, he was the Recipient of BPS Division of Counselling Psychology Award for Outstanding Contribution to the Profession. And in 2019, Ernesto received the BPS Award for Distinguished Contribution to Practice. His most recent book, Practising Existential Therapy: The Relational World 2nd edition (Sage, 2015) has been widely praised as a major contribution to the advancement of existential theory and practice. Living up to the existential dictum that life is absurd, Ernesto is also the author of an on-going series of Private Eye novels. Date and Time: Saturday 13 December from 2 pm to 3 pm – (UK time) Individual Dialogue Fee: £70 Venue: Online Zoom FULL PROGRAMME 2025: 25 January “Knots” with Prof. Ernesto Spinelli and Bárbara Godoy 22 February “Healing” with Dr. Michael Guy Thompson and Prof. Ernesto Spinelli 22 March “Difference” with Prof. Tod DuBose and Prof. Ernesto Spinelli 12 April “Polarisation” with Prof. Kirk Schneider and Prof. Ernesto Spinelli 3 May “Character” with Prof. Robert Romanyshyn and Prof. Ernesto Spinelli 21 June “Opening” with Dr. Yaqui Martinez and Prof. Ernesto Spinelli 19 July “Meaning” with Dr. Jan Resnick and Prof. Ernesto Spinelli 25 October “Invention” with Dr. Betty Cannon and Prof. Ernesto Spinelli 15 November “Hallucination” with Prof. Simon du Plock and Prof. Ernesto Spinelli 13 December “Hysteria” with Bárbara Godoy and Prof. Ernesto Spinelli Read the full programme here > Course Organised by: