606 Courses in Sheffield

Essential Management Skills 1 Day Workshop in Sheffield

Employee Engagement 1 Day Training in Sheffield

Learn how to cannulate ... Nationally Recognised Qualification OCN Accredited - Level 3 (advanced) - Ireland Level 5 CPD Accredited - The CPD Certification Service Classroom or Virtual Classroom options Covers all steps for cannulating in arm or hand Practise on artificial arms and fake blood! Essential qualification for all IV therapies Phlebotomy training desirable but not essential Basic understanding of English language required OPEN TO ALL APPLICANTS

Managing Performance 1 Day Workshop in Sheffield

Negotiation Skills - Professional 1 Day Workshop in Sheffield

This EV charging course is intended to provide expert guidance to learners wishing to gain knowledge and understanding on Electric Vehicle charging equipment installation. This 2 day course provides expert guidance on EV charging equipment installation, an important emerging area which is not covered in detail by the current edition of the Wiring Regulations (BS 7671) or the IET’s Guidance Notes. Aimed at experienced electricians interested in understanding a wide range of equipment and systems available, this course applies to the specialised installation requirements of electric vehicle charging equipment in domestic dwellings, on-street locations, commercial and industrial premises. This training course provides detailed guidance and recommendations on all aspects of the installation of Electric Vehicle Charging Equipment from the origin of the electrical supply, through distribution and final circuits, installation of the charging equipment itself to the cable between the charging equipment and vehicle’s electrical inlet. Also included are related issues of site layout and planning and subsequent inspection, testing, certification and maintenance of installations. Also Covering: How EV charging works How to select the correct EV Charging Point Solution for the customers needs. Technical requirements of installing & the use of different earthing arrangements (TN-C-S/TT systems) Planning requirements, labelling & risk assessments How to carry out surveys & Pre Installation considerations Meeting the requirements of BS7671 Awareness of the IET code of practice for Electrical Vehicle Charging Equipment & Installation. Plus much more Why take this EV charging course? Currently there is an increasing demand for new electric vehicle charging points but too few installers to roll them out. This is already a booming market which is due to get much bigger in the near future. The number of public charging connectors and locations has increased by 38% in the past 12 months and is expected to continue at that rate for years to come. Add this important service to future proof your knowledge to allow extra inspection & testing plus new installation work with this electric vehicle charging course. We have a variety of charging units and simulated installs which means it is just as working on a real installation. Making this installers course real value for money.

This qualification aims to provide expert guidance to learners wishing to gain knowledge and understanding on Electric Vehicle charging equipment installation. This 2 day course provides expert guidance on EV charging equipment installation, an important emerging area which is not covered in detail by the current edition of the Wiring Regulations (BS 7671) or the IET’s Guidance Notes. Aimed at experienced electricians interested in understanding a wide range of equipment and systems available, this course applies to the specialised installation requirements of electric vehicle charging equipment in domestic dwellings, on-street locations, commercial and industrial premises. The course provides detailed guidance and recommendations on all aspects of the installation of Electric Vehicle Charging Equipment from the origin of the electrical supply, through distribution and final circuits, installation of the charging equipment itself to the cable between the charging equipment and vehicle’s electrical inlet. Also included are related issues of site layout and planning and subsequent inspection, testing, certification and maintenance of installations. Why take this course? Currently there is an increasing demand for new electric vehicle charging points but too few installers to roll them out. This is already a booming market which is due to get much bigger in the near future. The number of public charging connectors and locations has increased by 38% in the past 12 months and is expected to continue at that rate for years to come. Entry Requirements There are no formal entry requirements for this qualification, however we do expect you to meet the following requirements: Minimum age 18 years old (mandatory) Must be able to demonstrate the following competencies Be able to correctly install and terminate: pvc/pvc cable (twin and earth) Steel Wire armoured cable (swa) Be able to carry out an initial verification (inspection & testing) on an electrical installation and complete the necessary paperwork. Please Note: These competencies are required for the assessment and are not taught as part of the course. It is also recommended that you are up to date with your wiring regulations.

Construction Project Manager 2 Days Training in Sheffield

Recruitment Skills 1 Day Workshop in Sheffield

MySQL foundation training course description The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.