Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. We also learn Data Definition Language and Data Manipulation Language statements. as well as course automation of queries using T-SQL. Hands-on, Practical SQL Advanced Course. PCWorkshops SQL Advanced Course Certificate. Max 4 people per course; we keep it personalised.
Course Introduction Our Venepuncture and Phlebotomy training equips delegates with the skills and knowledge needed to take blood safely. Please note: this course is for health care professionals and nurses only. About this event Applicable to Nurses, Health Care Assistants and Phlebotomists in primary care, the community, hospitals or nursing homes, this course is interactive and involves a demonstration session on performing blood tests. Our venepuncture training will give delegates the theoretical and practical awareness to undertake a competence assessment framework in the workplace that will deem them competent to take blood safely and appropriately. Each delegate will receive a competence-based framework to allow them to do this. Course Aims Identify and describe equipment used for routine venepuncture Be able to assess and select suitable sites used for venepuncture as well as locations to avoid Describe and utilize the required steps to perform routine venepuncture Describe actions that ensure safety during performance of a venepuncture Identify suitable vein selection and identify factors influencing this Understand relevant professional and legal issues Be able to identify potential complications Understand anatomy and physiology and correct vein selection Be familiar with equipment and exercise choice in using most appropriate equipment Practice safely in terms of infection control and waste management Become skilled and competent at phlebotomy To recognise any complications arising and be able to take the appropriate action Course Content Background and importance of training and competence Supervision and practice Scope and responsibilities Accountability Professional and legal issues Consent and capacity What is phlebotomy? Tools of the trade-equipment Needles and patient safety Blood collection systems and devices Syringes and when to use them Blood collection tubes Labelling Anatomy and physiology Vein Selection: - Identification of Veins - Arm Veins - Hand Veins Vein assessment Unacceptable sites for venous collection Venepuncture procedure Attempts Order of Fill Specimen collection procedures Specimen handling post-phlebotomy Personal protective equipment Needle stick injuries Legislation-EU Directives Disposal Needle phobias Dealing with anxiety/fainting etc. Practical session Potential Complications (including infection control) Practical Application - techniques and troubleshooting Case scenarios Troubleshooting Audit Who should attend / would be applicable? Nurses HCAs Those interested in careers as Phlebotomists AB Health Group awards CPD points / certificate of attendance for each course. If you would prefer an accredited certificate by our accrediting body Aim Qualifications we can organise this. The charge for the certificate including postage is £30.00. Annie Barr AB Health Group Organiser Description Annie Barr is a leading provider of high quality, accredited healthcare training. With a selection of engaging healthcare training that has been developed by experts to equip you and your workforce with the skills, knowledge and competence needed to provide compassionate and high quality care.
Best MS (Microsoft) Project Beginners Courses in London, England! This one-day Microsoft Project Beginners Course is designed to cover the concepts of creating, scheduling, baselining and tracking projects using Microsoft Project. We cover all versions of Microsoft Project, instructor-led, classroom-based, practical, and hands-on. We offer the classes on a one-to-one basis, but group sessions are scheduled on request.
At Dakoda’s Dance Academy, we offer a nurturing environment where preschool children can learn to express themselves through movement. We understand that children develop at different rates, which is why our classes are tailored to each child’s abilities. Our experienced and highly trained instructors have a passion for teaching and helping children reach their full potential. Our Adult & Baby Ballet classes focus on developing children’s coordination, balance, and strength, while also introducing them to the basics of ballet technique. We use props such as ribbons and scarves to help engage the children and make the classes fun, imaginative and interactive. Age-appropriate preschool music is also used
Venepuncture and cannulation course Venepuncture training for healthcare professionals Cannulation skills development Intravenous access techniques Blood sample collection training Infection control in venepuncture Hands-on venepuncture practice Cannula insertion training Nursing revalidation hours CPD accredited course Healthcare professional skills development Venepuncture and cannulation procedures Venepuncture certification program Intravenous catheter insertion Best practices in venepuncture Patient assessment for venepuncture Troubleshooting venepuncture complications Venepuncture and cannulation simulation Real-life venepuncture scenarios Healthcare career advancement with venepuncture skills
At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. Course level is beginners to intermediate.
This course covers the essential Excel data skills. Our course is interactive, instructor-led. This Excel Data course is on offered on intermediate level of Excel and concentrates on the Data Analytical capabilities of Excel. These concepts are daily used by data analysts and is a basic essential skill for data professionals. By the end, you'll be able to use Excel for analytics, data summaries, trends and statistics. You will create Excel data analytical spreadsheets and samples that you can use as examples at work.
Overcome the Fear of Public Speaking Are you held back by the fear of public speaking? This fear is more than just meeting nerves—it acts as a formidable barrier, muting your valuable contributions and stalling your career progression. Despite possessing valuable experience and ideas, the overwhelming fear of speaking out in meetings causes you to retreat into silence. Meanwhile, your less experienced but more confident colleagues speak up, gaining visibility and opportunities that could have been yours. A fear of public speaking is a significant obstacle blocking you from the recognition and career advancement you deserve. The Way Forward? Our Public Speaking Class in London is crafted for professionals keen to conquer their fear of public speaking and seize control of their careers. Embark on this transformative journey with us and swiftly gain the confidence to: Confidently share your thoughts and ideas in meetings - Actively engage in discussions - Deliver compelling presentations - Elevate your professional visibility Why Our Public Speaking Class in London? We understand your struggle. Our instructors have personally faced and overcome their own intense public speaking fears. Their journey has equipped them with the unique empathy and expertise to facilitate your journey from fear to confidence. Stop letting a fear of public speaking hold back your career. Join our Public Speaking Class in London and transform your next meeting into a confident opportunity for success. It's time for your voice to unlock the recognition and opportunities for your career success.
PYTHON BOOTCAMP: This 12-week Python Data Analytics Data Boot Camp is designed to give you a complete skill set required by data analysts . You will be fully fluent and confident as a Python data analyst, with full understanding of Python Programming. From Data, databases, datasets, importing, cleaning, transforming, analysing to visualisation and creating awesome dashboards The course is a practical, instructor-lead program.