417 Dele courses in London

This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements. Hands-on, Practical SQL course. You will get the PCWorkshops SQL Course Certificate. Max 4 people per course, to keep it personalised.

This Excel Introduction course is a very good introduction to essential fundamental programming concepts using Excel as programming language. These concepts are daily used by professionals and are essential in most jobs. By the end, you'll be comfortable with Excel concepts, ribbons, formulas, and the Functions Wizard. You will gain hands-on practical experience creating a spreadsheet from scratch on your own.

Basic Python syntax and principles of Object Orientated Programming. Most attendees are in-work IT Professional. Private individuals are also very welcome. Evening courses also running. Our Style: Hands-on, Practical Location: Online, Instructor-led Download: anaconda.com Duration: 6 weeks, 1 evening per week, 6pm - 8pm Times: arrange a time for your time zone

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.

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.

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.

Excel Intermediate Course, 1-Day. This course covers the essential Excel Intermediate, in our interactive, instructor led Live Virtual Classroom. You already know your way around Excel e.g. you understand some of the functionality on the Home Ribbons, can move around and format cells. etc. In the Excel intermediate course we cover in-depth functions and Formulae so that you will be able to create fantastic spreadsheets like budgets, forecasts, and more. You will be able to understand and unravel the complicated formulae created by your colleagues. During the course you will excellent spreadsheets so that you have examples to take away. Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Intermediate Certification Hours: 1 Day, 10am-5pm Excel Intermediate Course, Course Outline. Working with Functions and Formulas The Function Wizard Using Functions in Excel: The 5 Popular functions If-else function Working with Names and Ranges Copying formulae Creating Formulae in Excel, general calculations. Lookups: Vlookup, Hlookup, Index, Match. Formatting a Range as a Table: Properties and behaviour of a table. Managing Tables: Working with Tables. Working with Tables: Working with Records and Fields. Filters and Sorting, Freeze panes, split, protecting and unprotecting. Using Excel as a Database: Advanced filter: copy only specified rows and columns from a large data set, auto mate this selective copy. Pivot-tables: Create Pivot Table, Refresh Data. Amend, Filter, Sort, Format Pivot Tables, Add additional Pivot formulae. Pivot Charts: Excel Pivot Charts and Sparklines. Examples and exercises with Pivot Charts and Sparklines. Other Excel Courses Inlcuded with the Excel Intermediate Course PCWorkshops Excel Intermediate Certificate on completion Excel Intermediate Notes Excel Code Examples Practical Excel Intermediate exercises Personal attention in a small group of up to 4 delegates Book the Excel Intermediate Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

Excel Advanced Course, 1-Day. Who should attend: Excel Advanced is for Excel Experts: Your work daily with Excel and your work revolves around spreadsheets and Excel databases. Course Details: Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Advanced Certification Hours: 1 Day, 10am-5pm Delivery Style: 1-1, because we understand that individuals have varying skill levels and varying applications. Excel Advanced Course Description General Editing Standard Formatting Rules Input Validate rules Using Formulas in Conditional Formatting Group and Outline Filter and Sorting Excel Tables and Advanced Filter Working with Excel tables Copy specific datasets from sheets, workbooks or external data Consilidate Goal seek, consolidate and scenarios Using Form Templates Creating Templates Advanced Excel Lookup Functions VLookup Function Hlookup Function Using the Index Function, Using the Match Function, Index and Match Together Using the Indirect Function Excel Advanced Functions Using Error Functions, Logical Functions, Array Functions, Rounding Functions Advanced Excel Pivot Table Tools Importing Pivot Table Data, Calculated Fields in Pivot Tables, Showing Pivot Data as a Percentage, Creating Custom Pivot Tables Styles Pivot Charts Excel Macros Creating, amending and deleting macros Running macros Macro menus, toolbars and shortcuts Alternative Excel Courses Inlcuded with the Excel Advanced Course PCWorkshops Excel Advanced Certificate on completion Excel Advanced Notes Excel Code Examples Practical Excel Advanced exercises Personalised attention in a 1-1 session About us Our experienced trainers are award winners. FAQ's Client Comments

Python Data Analytics boot camp. 12 1 day lessons, learn Python Basics through to machine learning and front-ends. With practical project to give you full confidence and credibility.