• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

53330 Courses delivered Online

SQL Querying Fundamentals - Part 1

By Nexus Human

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

SQL Querying Fundamentals - Part 1
Delivered OnlineFlexible Dates
£495

Epilepsy Train the Trainer

4.9(1007)

By Caring For Care

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

Epilepsy Train the Trainer
Delivered OnlineFlexible Dates
£450

Dementia Train the Trainer

4.9(1007)

By Caring For Care

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

Dementia Train the Trainer
Delivered OnlineFlexible Dates
£450

Safeguarding Train the Trainer

4.9(1007)

By Caring For Care

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

Safeguarding Train the Trainer
Delivered OnlineFlexible Dates
£450

Medication Train the Trainer

4.9(1007)

By Caring For Care

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.

Medication Train the Trainer
Delivered OnlineFlexible Dates
£450

Training of Trainers

4.9(9)

By Sterling Training

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

Training of Trainers
Delivered OnlineFlexible Dates
£450

Presentation Skills Excellence

4.9(9)

By Sterling Training

Banish those presentation gremlins and communicate with confidence and clarity!

Presentation Skills Excellence
Delivered OnlineJoin Waitlist
£450

Crystal Healer Practitioner Training - Accredited. (1 payment)

4.9(31)

By The Natural Wellbeing Academy

Crystal Healer Training, Accredited Qualification Course. From an Academy of Integrative Holistic Wellbeing

Crystal Healer Practitioner Training - Accredited. (1 payment)
Delivered Online On Demand
£600

BOHS P402 Online - Surveying and sampling strategies for Asbestos in buildings

By Airborne Environmental Consultants Ltd

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

BOHS P402 Online - Surveying and sampling strategies for Asbestos in buildings
Delivered in Manchester + 1 more or OnlineFlexible Dates
£575

BOHS P402 - Surveying and sampling strategies for Asbestos in buildings

By Airborne Environmental Consultants Ltd

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.

BOHS P402 - Surveying and sampling strategies for Asbestos in buildings
Delivered in Manchester + 1 more or OnlineFlexible Dates
£575