602 Courses 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

Construction Project Manager 2 Days Training in Sheffield

QA Level 3 Award In Emergency First Aid At Work (RQF) Full day course Gives learners the knowledge and skills to be an emergency first aider Recommended by HSE for low-risk workplaces Course Contents: The Roles and Responsibilities of an Emergency First Aider Assessing an Incident Minor Injuries Cuts, Grazes and Bruises Minor Burns and Scalds Managing an Unresponsive Casualty CPR Safe Use of an AED (Automated External Defibrillator) Choking Seizures Wounds and Bleeding Shock Benefits of this course: 1.1 million workers in Britain had an accident at work in 2014/2015 Of those, 2,700 were from the East Midlands On average, one out of every 370 people received an injury at work The estimated cost of injuries and ill health last year was £15 billion The Health and Safety (First Aid) Regulations 1981 require all employers to make arrangements to ensure their employees receive immediate attention if they are injured or taken ill at work. This includes carrying out a risk assessment, appointing a suitable amount of first aiders and providing adequate first aid training Typically, first aiders will hold a valid certificate in either First Aid at Work (FAW) or Emergency First Aid at Work (EFAW) Our QA Level 3 Award in Emergency First Aid at Work (RQF) - EFAW - training course is the one recommended for first aiders in a low risk workplace Having the correct first aid provision in the workplace is not just a legal requirement, it is incredibly important for the safety of all members of staff! As this is a Regulated Qualification, employers can book this course for their employees in the safe knowledge that they have fulfilled their legal responsibilities for providing quality first aid training, without having to undertake any lengthy due diligence checks Accredited, Ofqual regulated qualification: Our Emergency First Aid at Work course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Emergency First Aid at Work Certificate fulfills the legal requirements and is a very good way to make sure you and your employees are trained in First Aid.The Ofqual Register number for this course is 603/2367/X

QA Level 3 Award In First Aid At Work (Annual Refresher) (RQF) Half day course How much do you still remember from your last first aid training course? Skills fade rapidly. This course is there to ensure learners retain the most important skills of saving a life. The Annual Refresher as recommended by HSE Course Contents: Assessing an Incident Managing an Unresponsive Casualty Recovery Position CPR Safe Use of an AED (Automated External Defibrillator) Choking Benefits of this course: 1.1 million workers in Britain had an accident at work in 2014/2015 Of those, 2,700 were from the East Midlands On average, one out of every 370 people received an injury at work Are you already holding a valid Emergency First Aid at Work (EFAW) or First Aid at Work (FAW) Certificate? How much can you still remember a year later? HSE strongly recommends that first aiders undertake Annual Refresher training during any three year FAW/EFAW certification period. This will help qualified first aiders remain competent and keep up to date with any changes to first aid procedures. In just half a day, this course is an ideal way to satisfy HSE requirements whilst minimising disruption to the work day. Accredited, Ofqual regulated qualification: Our Emergency First Aid at Work Annual Refresher course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Emergency First Aid at Work Annual Refresher Certificate fulfils the legal requirements and is a very good way to make sure you and your employees keep your First Aid skills up to date.The Ofqual Register number for this course is 603/3154/9

One and a half-hour session Have you already got a valid First Aid Certificate? Do you feel confident you can do what needs to be done when the situation arises? Are there first aid situations you do not feel ready for, that were maybe not covered or are now more important to you? These special First Aid Skills Practice Sessions give you the chance to refresh your theory and/or practical skills Whichever subjects you would like to work on - you choose what you want to practice or know more about Course Contents: Can’t quite remember how or why to put someone in the recovery position? Practice it! Still confident in giving CPR? Ever done it with different barriers? Here’s your chance. Scared of what to do if someone chokes? We have baby and child infant choking models and an adult choking vest. Save their lives! Bandage a wound, apply a sling, treat someone for shock? That can be done. Want to know more about Heart Attacks or Strokes? Just let us know. Know the theory about an Automated External Defibrillator (AED), but haven’t had the chance to actually use one? Now you can. And so on and so forth – the choice is yours! Benefits of this course: Have you already got a valid First Aid Certificate? Can you still remember everything that you have learned? Or maybe you did some training a while ago that wasn't necessarily certificated, and you just want to refresh your skills and knowledge a bit Do you feel confident you can do what needs doing when the situation arises? It is highly recommended to do 'something’ to keep your skills up to date – as a matter of fact, this is a prerequisite of your First Aid Certificate. We run Annual Refresher courses, which is a properly accredited certification awarded by Qualsafe Awards. These are recommended on a yearly basis. In between that, it is still good to keep one's skills and knowledge up to date. Our special First Aid Skills Practice Sessions give you the chance to refresh your theory and/or practical skills. Whichever subjects you would like to work on. An experienced trainer will be at hand to show and explain. NOWHERE ELSE DO YOU HAVE THE CHANCE TO DO THIS! CPD Accredited: These sessions are non-Ofqual regulated. However, they are taught by our trainer, who is an accredited first aid trainer via Qualsafe Awards, First Aid Awards Ltd and Highfields Qualifications. You'll get accredited quality either way! These sessions are CPD Accredited, so you'll get 1.5 CPD hours with this training. If you'd like to do a nationally accredited course instead, we'd like to recommend you do our First Aid at Work Annual Refresher, Emergency First Aid at Work, First Aid at Work or Basic Life Support for Adults and Children course.

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.

Administering Microsoft SQL Server course description This course provides students with the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on how to use SQL Server 2016 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2014 or SQL Server 2016. It covers the new features in SQL Server 2016, but also the important capabilities across the SQL Server data platform. What will you learn Describe core database administration tasks and tools. Configure SQL Server databases and storage. Import and export data. Monitor SQL Server. Trace SQL Server activity. Manage SQL Server security. Audit data access and encrypt data. Administering Microsoft SQL Server course details Who will benefit: Individuals who work with SQL Server databases. Individuals who develop applications that deliver content from SQL Server databases. Prerequisites: Introduction to data communications & networking. Duration 3 days Administering Microsoft SQL Server course contents Introduction to SQL Server administration Database administration, SQL Server platform, database management tools and techniques. Hands on SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server. Working with databases and storage Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension. Hands on Configuring tempdb storage, creating databases, attaching a database. Importing and exporting data Transferring data, importing and exporting table data, copying or moving a database. Hands on import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function. Monitoring SQL Server 2014 Monitoring SQL Server, dynamic management views and functions, performance monitor. Hands on Baseline metrics, monitoring a workload. Tracing SQL Server activity Tracing workload activity, using traces. Hands on Capturing a trace in SQL Server profiler, generating tuning recommendations. Managing SQL Server security SQL Server security, server-level security, database-level principals, database permissions. Hands on SQL Server security. Testing access.

MySQL server admins training course description This MySQL Server administration course is designed for MySQL Server administrators who have a basic understanding of a MySQL database and a good working knowledge of SQL commands. The course provides an understanding of MySQL Architecture and practical experience in setting up, configuring and maintaining a MySQL server, backing up and recovering data and optimising query performance. This MySQL Server administration course also covers MySQL replication and its role in high availability and scalability. What will you learn Use MySQL Workbench. Install and configure a MySQL Server . Administer and tune a MySQL server. Configure log files and interpret error messages.. Secure the Server. Administer a replication topology. MySQL server admin training course details Who will benefit: Database administrators, Database developers and Technical consultants. Prerequisites: Introduction to MySQL Duration 5 days MySQL server admin training course contents Introduction to Oracle Application Express APEX concepts APEX main components Workspaces, database applications and websheet applications Creating a workspace The Workspace Administrator Upgrading APEX Logging into APEX Running an application SWL Workshop Use APEX to browse, create and modify objects Process ad hoc SQL statements Manage scripts in APEX Create, run and save SQL queries Build a database application Application components Create an application Create an application from a spreadsheet Create reports Create reports using wizards Edit report attributes Add links to reports Create a link to a printer-friendly version of a report Save and print reports in different formats Using files Uploading images Creating cascading stylesheet files Uploading static files Adding an Image as an application logo Adding a reference to a Javascript file Pages and regions Web form behaviour in APEX Create a form based on a table Create a form based on a procedure Create a form with a report Create a tabular form Format a form Locking in APEX forms Creating lists of values Overview of application express shared Components Dynamic and static lists of values Create a dynamic list of values Create a static list of values Use a list of values to control data in a report Create a cascading list of values Items and buttons Understand the different Types of items Create items Understand and edit item attributes Use Javascript with item Manipulate items in tabular forms Add dynamic items to a report Create and edit buttons Page Processing Page rendering and page processing Create computations Validate input data Process Data Understand application branching Create conditional branches Shared components Overview of application express navigation components Manage parent and standard tabs Create navigation bar entries Create and use lists and list items Manage breadcrumbs Create shortcuts Shared component subscription User interface defaults Display dynamic content Filter reports with dynamic queries Create charts with a wizard Format charts Create calendars Add links to calendars Create hierarchical trees State and debugging Understand session state Set a session state value Clear the session state Review the session state Review the messages in debug mode Enabling feedback Managing feedback and team development Themes and templates Switch to a different theme View existing templates Understand and manage templates Create a new template Add references to cascading stylesheet and Javascript files Dynamic actions and plug-in components Identify plug-in components and their types Plug In a component Create dynamic actions Use a plug-in in a dynamic action Building website applications Websheet applications and their components Create a websheet application Enable SQL and PL/SQL in a websheet application Add sections and pages to a websheet application Add links on a websheet page Add a data grid to a websheet application Create SQL reports ion websheet applications Add annotations to a websheet application Implementing security Authentication and authorization Provide an authentication scheme Create an authorization scheme using access control Enable and configure session state protection Deploy an appliction Define supporting objects Package an application Export an application Import an application Install supporting objects Administer Apex workspaces Manage workspaces and users Request a schema or storage Purge session state Monitor developer activity log Monitor workspace activity View activity reports Import a workspace Utility programs Import and export data Generate DDL statements View objects reports

QA Level 2 Award In Fire Safety (RQF) Face to Face Classroom: Full day course Online / Virtual Classroom: 3 sessions of 2½ hours Suitable for Fire Wardens/Fire Marshals and all other members of staff Provides a foundation of fire safety knowledge on which employers and ‘responsible persons’ can build, keeping the business safe from fire Benefits of this course: How much do you know about keeping yourself and others safe in the workplace? Fire Safety Law breaches can result in unlimited fines and imprisonment More importantly, how would you feel if someone got injured or even killed by a fire you could have prevented? This course is for anyone who has a specific responsibility for fire safety in the workplace, such as designated fire wardens/fire marshals Successful candidates will gain an understanding of fire safety management at work and the specific roles and responsibilities related to fire safety in the workplace. Course Contents: Causes of Fire in the Workplace The Fire Triangle Hazards during and after a Fire Fire and Smoke Spread Identifying and Controlling Fire Hazards Fire Safety Laws Duties and Responsibilities of Employers and Employees Undertaking a Fire Safety Inspection Fire Safety Risk Assessments Contents of a Fire Safety Briefing Roles and Responsibilities of the Nominated Fire Warden Accredited, Ofqual regulated qualification: Our Fire Safety course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.You can rest assured that the training your employees receive is of a high quality and the candidates will get a strong grounding in Fire Safety, helping to keep your staff and your business safe from fire.The Ofqual Register number for this course is 603/2756/X

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further Jenny Price - Acer ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills