83 Courses in London

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.

Supporting Microsoft SQL server course description A concise hands on course enabling delegates to manage and administer a Microsoft SQL server database. What will you learn Install SQL server. Backup SQL server databases. Recover SQL server databases. Secure SQL server databases. Perform routine maintenance. Automate tasks. Supporting Microsoft SQL server course details Who will benefit: Anyone working with Microsoft SQL server Prerequisites: Supporting Windows server. Duration 3 days Supporting Microsoft SQL server course contents SQL server introduction Platform, Tools, services. Installation. Creating databases. Backups Back up types, transaction logging, restoring from a backup: Full database, individual files. Security Users, server roles, database roles. Permissions. Monitoring Routine database maintenance. Performance data. Jobs and alerts The SQL server agent, database mail, alerts, jobs.

Overview In the not-so-distant past, a bank teller regularly performed dozens of routine transactions during each and every shift. With the advent of online banking, gradually consumers realized they could do much of the work themselves and perform a range of simple tasks without having to darken the doors of their local branch. 

This is the Alan d signature course. Aimed at barbers returning to the industry or experience barbers feeling ‘bogged down’ with their everyday routine and looking for inspiration. It’s also ideal for those trained in Ladies Hairdressing who haven’t been formally trained in the latest barbering techniques. You will learn the 5 Alan d Foundation Barbering haircuts along with use of clippers, fading, and beard & moustache trimming.

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins

About this training course This 3-day training will provide a comprehensive understanding on the nature of costs and cost drivers in the E&P industry providing in-depth understanding on the budgeting process, proactive management, effective control and optimization of costs together with focused and relevant performance reporting. Training Objectives After the completion of this training course, participants will learn: Understand the nature of costs and cost drivers in the E&P industry through the Field Life Cycle Purpose of the Budget. Planning and Budgeting models. The Strategic and Medium-term plan Using budgets to make effective decisions. Prepare and understand costs in planning, budgeting & forecasting processes e.g. fixed / variable, capex / opex and routine / non-routine. Cost Accounting. Importance of timely cost capture and accurate recording e.g. VOWD / accruals, consistency of coding and clarity on accountability Strategic solutions in delivering cost optimization - 'do more for less' Management of costs in PSC and JV environments. Avoiding cost leakage and ensuring audit preparedness Cost Control Framework - budgets, AFEs, progress reports and variance analysis. Understanding key components and ensuring seamless interaction Cost Performance Reporting - use of KPI's, variance analysis and trend analysis. Tracking and monitoring cost optimization initiatives and targets Target Audience This training course is suitable and will greatly benefit the following specific groups: Finance staff with accounting and financial management responsibilities Those responsible for devising budgets, managing and controlling budgets Professionals engaged in planning, budgeting and management reporting Finance & Audit staff engaged on cost and financial controls Business unit managers and personnel whose responsibilities include cost management, controlling budgets and performance reporting Course Level Basic or Foundation Training Methods The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught in their own organization. Course Duration: 3 days in total (21 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training The maximum number of participants allowed for this training course is 25. This course is also available through our Virtual Instructor Led Training (VILT) format. Trainer Your expert course leader has more than 30 years of experience in the international oil and gas industry, covering all areas of Finance and Audit, including involvement in Commercial roles. During her 19 years with ENI she worked in Italy, Netherlands, Egypt and UK and was CFO for 2 major ENI subsidiaries. She has delivered training courses in Accounting, Audit, Economics and Commercial topics in many Countries. She has a Degree in Economics & Accounting and is a Certified Chartered Accountant. She is also a Chartered Auditor and an International Petroleum Negotiator. Outside of work, she is inspired by the beauty of nature and art, helping disadvantaged people, sports (football, golf) and her cat. Courses Delivered Internationally: E&P Accounting, Auditing in the Oil & Gas Industry Cost Control & Budgeting Introduction to the Oil & Gas Industry Petroleum Project Economics Contracts Strategy International O&G Exploitation Contracts POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

PRINCE2® Foundation Projects fail for a variety of reasons including poor planning, lack of defined quality criteria, poor understanding of the business drivers, inadequate control, and lack of senior management involvement in other words, lack of a structured best practice approach to project delivery. PRINCE2® (6th Edition is the current version) is a structured, process-based approach to project management providing a methodology which can be easily tailored and scaled to suit all types of projects. It is the de facto standard for project management in the UK Government and is used extensively in more than 150 countries worldwide with in excess of 20,000 organizations already benefiting from its powerful approach. It can be used easily in combination with PMI®'s PMBOK® Guideto provide a robust project management methodology, or to augment an existing PMBOK®-based methodology with additional rigor around areas such as Quality, Organization, and Benefits Realization. The goals of this course are to provide participants with a thorough grounding in PRINCE2® and its benefits and to prepare them to sit the Foundation exam. What you will Learn You'll learn how to: Identify the benefits and principles underlying a structured approach to project management Define the PRINCE2® method in depth, including the principles, themes, and processes Prepare and practice for the Foundation exam Getting Started Introductions Course structure Course goals and objectives Overview of the PRINCE2® Foundation exam PRINCE2® Introduction Introducing PRINCE2® The structure of PRINCE2® What PRINCE2® does not provide What makes a project a 'PRINCE2® project'? Project Management with PRINCE2® Defining a project Managing a project Controlling the variables The Project Manager's work PRINCE2 Principles PRINCE2® Principles The Seven Principles Tailoring and Adopting PRINCE2® Defining tailoring Defining embedding What can be tailored? Who is responsible for tailoring? Introduction to the PRINCE2® Themes What is a PRINCE2® Theme? What are the PRINCE2® Themes? Tailoring the themes Format of the theme chapters Business Case Need for a business case Elements of a business case How a business case is developed Managing Benefits Organization Need for a special type of organization PRINCE2® organization structure Roles in a PRINCE2® project Combining roles Quality Relevance of quality to project work Quality, quality control, and quality assurance Quality management approach and the quality register Who is responsible for quality? Plans Need for plans and their hierarchy Approach to planning Content of a PRINCE2® plan Product-based planning Risk The need to manage risks What is a risk? Risk and continued business justification A risk management option Change Change is inevitable Different types of change Baselines and configuration management Issue and change control in PRINCE2® Progress Controlling a PRINCE2® project The application of tolerance Types of control Raising exceptions Introduction to Processes Processes and the project lifecycle The PRINCE2® journey Structure of the process chapters Tailoring the processes Starting up a Project Appointing people to the PRINCE2® roles Establishing some baselines Should we go further with this work? Planning for initiation Directing a Project Should we start / continue the project? Responding to internal / external influences Should we close this project? Initiating a Project Establishing the project's approaches Creating the project plan Refining the business case Assembling the PID Controlling a Stage Authorizing and reviewing work Monitoring and reporting Handling non-planned situations Triggering the next process Managing Product Delivery Accepting work from the Project Manager Getting the work done by the team Routine and non-routine reporting Handing back the completed work Managing a Stage Boundary Taking stock of what we have done Updating the PID Consider the options for continuing / stopping Producing exception plans Closing a Project PRINCE2® at the end of a project Transition of product to operational use How well did we do? Tying up all the loose ends

PRINCE2® Foundation: In-House Training Projects fail for a variety of reasons including poor planning, lack of defined quality criteria, poor understanding of the business drivers, inadequate control, and lack of senior management involvement in other words, lack of a structured best practice approach to project delivery. PRINCE2® (6th Edition is the current version) is a structured, process-based approach to project management providing a methodology which can be easily tailored and scaled to suit all types of projects. It is the de facto standard for project management in the UK Government and is used extensively in more than 150 countries worldwide with in excess of 20,000 organizations already benefiting from its powerful approach. It can be used easily in combination with PMI®'s PMBOK® Guideto provide a robust project management methodology, or to augment an existing PMBOK®-based methodology with additional rigor around areas such as Quality, Organization, and Benefits Realization. The goals of this course are to provide participants with a thorough grounding in PRINCE2® and its benefits and to prepare them to sit the Foundation exam. What you will Learn You'll learn how to: Identify the benefits and principles underlying a structured approach to project management Define the PRINCE2® method in depth, including the principles, themes, and processes Prepare and practice for the Foundation exam Getting Started Introductions Course structure Course goals and objectives Overview of the PRINCE2® Foundation exam PRINCE2® Introduction Introducing PRINCE2® The structure of PRINCE2® What PRINCE2® does not provide What makes a project a 'PRINCE2® project'? Project Management with PRINCE2® Defining a project Managing a project Controlling the variables The Project Manager's work PRINCE2 Principles PRINCE2® Principles The Seven Principles Tailoring and Adopting PRINCE2® Defining tailoring Defining embedding What can be tailored? Who is responsible for tailoring? Introduction to the PRINCE2® Themes What is a PRINCE2® Theme? What are the PRINCE2® Themes? Tailoring the themes Format of the theme chapters Business Case Need for a business case Elements of a business case How a business case is developed Managing Benefits Organization Need for a special type of organization PRINCE2® organization structure Roles in a PRINCE2® project Combining roles Quality Relevance of quality to project work Quality, quality control, and quality assurance Quality management approach and the quality register Who is responsible for quality? Plans Need for plans and their hierarchy Approach to planning Content of a PRINCE2® plan Product-based planning Risk The need to manage risks What is a risk? Risk and continued business justification A risk management option Change Change is inevitable Different types of change Baselines and configuration management Issue and change control in PRINCE2® Progress Controlling a PRINCE2® project The application of tolerance Types of control Raising exceptions Introduction to Processes Processes and the project lifecycle The PRINCE2® journey Structure of the process chapters Tailoring the processes Starting up a Project Appointing people to the PRINCE2® roles Establishing some baselines Should we go further with this work? Planning for initiation Directing a Project Should we start / continue the project? Responding to internal / external influences Should we close this project? Initiating a Project Establishing the project's approaches Creating the project plan Refining the business case Assembling the PID Controlling a Stage Authorizing and reviewing work Monitoring and reporting Handling non-planned situations Triggering the next process Managing Product Delivery Accepting work from the Project Manager Getting the work done by the team Routine and non-routine reporting Handing back the completed work Managing a Stage Boundary Taking stock of what we have done Updating the PID Consider the options for continuing / stopping Producing exception plans Closing a Project PRINCE2® at the end of a project Transition of product to operational use How well did we do? Tying up all the loose ends

Course Prerequisites Minimum of 18 years Good command of English Our beginners level facial course has no entry requirements. If you are thinking of starting a career in the beauty industry, this course will enable you to offer effective facial treatments to your clients. Course Structure A mixture of only study, virtual lectures and onsite practical sessions. All courses are intimate with four learners in class 2-1 ratio. START A NEW CAREER OR ENHANCE YOUR EXISTING BUSINESS TOPICS COVED IN THIS COURSE: The facial skincare treatment routine Cleansing, toning & Exfoliation Consultation techniques Health, safety & hygiene Contraindications Aftercare advice Facial massage Extractions Skin analysis Skin types Acne Anti-ageing Dehydrations

In this class we are doing the Wu style Competition Routine. This is a 45-move set of movements using all the features that make Wu style tai chi different to other styles of tai chi. We also do a set of Qigong exercises in this class. This is a 13-week term.