56257 Courses near Stoke On Trent delivered 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

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.

Asbestos surveyors, or managers of surveyors and surveying teams. Asbestos re-inspectors or anyone that undertakes asbestos re-inspections. Those who require a detailed understanding of asbestos surveying principles (e.g. asbestos report writers, architects, building surveyors etc.) Prior Knowledge and Understanding Candidates for this course are expected to be aware of the contents of HSG 264 Asbestos, the survey guide and have a minimum of six months prior experience of assisting on asbestos surveys. In addition, candidates are expected to have had training to cover the core competencies outlined within the foundation material detailed within Table A9.1 of HSG248 Asbestos: The Analysts' Guide (July 2021). This may be achieved by In -house learning or through the P400 foundation module.

The main subject areas of the course are: Building construction and the uses of asbestos Survey types Bulk sampling and material assessments Survey reports Quality control

The most comprehensive, concise and impactful 6 weeks online course available. Fully accredited. Start immediately. Gain 18 CPD Credits and an exclusive Chartered Management Institute Certificate of Recognition Duration: 6 weeks starting immediately Who is this course for? All levels of seniority Language: English Effort: 16 hours of self-paced online learning Award: 18 CPD Credits & CMI Certificate of Recognition  Accreditors: CMI, FMLM, CPD Certification Service  Content format: Videos with optional reading  Assessment Method: Multiple choice, instant result. Retake if required. In total there are 22 video courses to watch. This includes 9 CPD accredited courses that require you to complete a multiple choice assessment to confirm your understanding of the topic. A pass mark of 70% is required and this can be re-taken as many times as required. Optional reading and audio book resources are provided to enable you to explore a topic deeper if required. The content of the course is of the highest global standard and has been created by MIT Sloan Management Review. Our learning platform, called Skillsoft Percipio, provides a stunning learning experience. Key learning areas: Benefits of being an emotionally intelligent leader Leading individuals and teams Critical thinking Managing stress Managing pressure to optimise performance Effective leadership Breaking bad news Decision making On completion of this course, you will receive: A certificate stating 18 CPD Credits- Awarded by the CPD Certification Service A Certificate of Recognition from the prestigious Chartered Management Institute (CMI) Chartered Management Institute Affiliate membership for 1 year A digital badge to share on LinkedIn and add to your resume Your official CPD Certificate Your official CMI Certificate You will also be awarded the following additional benefits: Chartered Management Institute alumni network access for 1 year Access to Chartered Management Institute networking and learning events for 1 year World leading content supported by cutting edge technology. Made for healthcare professionals.    Did you know this course can be covered by the NHS study budget?   The study budget covers: Courses and education activities to support you achieving the curriculum Courses to help you prepare for postgraduate exams Discretionary courses that add value to you individually and support the wider system To access the study budget you should discuss this with your educational supervisor or line manager. To help you with this process, view our example study budget application letter here.