7082 Courses near East Norton delivered Live Online

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify a Query Execute a Saved Query 2 - Performing a Conditional Search Search Using a Simple Condition Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns 3 - Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values 4 - Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators 5 - Retrieving Data from Tables Combine Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from a Single Table Using Joins 6 - Presenting Query Results Save the Query Result Generate an XML Report

Elevate Basildon Business - Women in Business Peer Group We have 8 spaces for people in the Basildon borough. Run by Essex Businesswoman of the Year – Sarah Brockwell, these friendly sessions are held on ZOOM. You need to commit to attend all 4 sessions. Discuss your business, business ideas, hurdles and plans and make new connections with like-minded people. (No experience is necessary) As well as the Peer Group sessions, each participant has 2 hours of 1:1 support from Sarah, also on ZOOM. Who is it for?: Businesses and people from the Basildon Borough. All business types, sizes and stages are welcome - from pre-startup to established. Join us to learn and grow your network. No experience necessary. Join Zoom Meeting https://us06web.zoom.us/j/86710461184 Meeting ID: 867 1046 1184 Your Basildon. Your Business. Your Growth. ----------------------------------------------------------------------------------------- This project is funded by the UK Government through the UK Shared Prosperity Fund.

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/

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/

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

Banish those presentation gremlins and communicate with confidence and clarity!

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

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

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

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.