63495 Courses

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

e-ALS has been developed using the RCUKs evidence-based Guidelines and decades of experience in delivering effective resuscitation courses for healthcare professionals, and will help build the confidence needed to take the lead in an emergency. During the course, you will develop the knowledge and skills required to: Recognise and manage the deteriorating patient using a structured ABCDE approach; Deliver standardised CPR in adults; Manage a cardiac arrest by working with a multidisciplinary team in an emergency situation; Become an effective and confident team member and leader by utilising non-technical skills. Who is the course for? The e-ALS course is designed for healthcare professionals who need skills in advanced life support as part of their clinical duties, as well as those who teach these skills on a regular basis. This includes doctors, paramedics and nurses working in acute care areas (e.g. ED, CCU, ICU, HDU, operating theatres, acute medical admissions units) or on resuscitation/ medical emergency/ Critical Care Outreach teams. All applicants must hold a professional healthcare qualification or be in training for a professional healthcare qualification. Medical students in their final year of training can be accepted as Candidates if this is an established local arrangement. Instructions Candidates do a day of e-learning followed by a day of face-to-face learning at one of our Course Centres. Pre course preparation: Before the course, you will be registered on the RCUK Learning Management System (LMS). Here, you can access pre-course course modules that will prepare you for your face-to-face session and a pre-course multiple choice question (MCQ) paper. You will receive your course manual one month before the course. Candidates are expected to read the manual in preparation for the course and submit a completed pre-course MCQ paper before the course begins. Programme: As part of your e-learning you will read through modules that cover all core components of the course. These modules will help you learn at your own pace and test your knowledge before attending a face-to-face day where you will develop your practical skills with the help of our Instructors, and participate in cardiac arrest simulations (CASTeach). Refreshments including lunch are included on all RCUK courses with Immerse Medical Due to the expense incurred in running this course there will be no refund for candidates who, for whatever reason do not attend the course, or cancel within six weeks of the course unless a replacement candidate can be found. E ALS Programme 2021 - 📎 eALS_Programme_2021.pdf

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

Recovery position Bleeding – causes, control measures and risk limitation Shock CPR Demonstration and practice D.R.S.A.B.C. Unconsciousness/ Recovery position Bleeding – causes, control measures and risk limitation Shock CPR Demonstration and practice D.R.S.A.B.C. Unconsciousness/head injuries Choking – responding effectively and practical 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.

The course is run over 2 days. Day 1 is Face to Face, Day 2 is Zoom The course is run over 2 days you will learn about and how to teach and assess the following key areas: PUWER, LOLER and the Manual Handling Regulations Operations (1992) The anatomy of the spine How to risk assess using E.L.I.T.E safe principles The importance of reducing risk and removing hazards Correct understanding of R.I.D.D.O.R How to choose and use the correct equipment safely Condemned and dangerous moves Practical skills – Chair moves, slings, slide sheets and hoisting

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