6199 Courses

Introduction: “Co-ordinating the temporary works process” This two day course is designed to assist those on site who have responsibility for managing all forms of temporary works. It is also designed to give confidence to senior management and those who engage contractors have reached an assessed standard of knowledge. The course has the support of a number of organisations: Temporary Works Forum CECA, UKCG, HSE and FMB. The support of these organisations offers transferability of the course within industry.Temporary works are usually safety and business-critical and require careful co-ordination. An accepted way of achieving this is through the adoption of the management process outlined in BS5975, which introduces the temporary works co-ordinator (TWC) as a key figure. This course explains the role and the overall management context within which it sits.High risk can occur on small as well as larger sites hence understanding the essentials of good safety risk management, as outlined in BS5975, is relevant for projects of all sizes. This course will give the delegate thorough knowledge of the Temporary Works Co-ordinator role however this does not alone make a delegate competent, as this requires other attributes e.g. experience. Aims and Objectives: This course is not a temporary works awareness course. It is only concerned with the process of co-ordination of temporary works, commonly expressed through the role of the Temporary Works Co-ordinator. Attendance does not confer competency as a Temporary Works Co-ordinator.The course gives emphasis, throughout, to: – The importance of communication, co-ordination, co-operation and competency. The ‘4Cs’. – Risk management: safety and also business relatedAllowing the Temporary Works Co-ordinator (TWC) to: – Understand the need for and duties of a TWC – Understand the role of others – Have a detailed knowledge and understanding of BS5975 in respect of this role. Assessment: The method of assessment will be by multiple-choice questions at the end of the course as well as being expected to be interactive during the course.Course Attendance:Delegates are required to attend both sessions, since without full attendance and achievement in the examination the Temporary Works Co-ordinator Training Course cannot be made.Delegates must attend the days in order and, where not on consecutive days, must complete the course within two weeks. Delegates unable to attend both days due to extenuating circumstances (e.g. certificated sickness) will need to enrol onto a new course in order to maintain continuity of learning outcomes and attend both days again. It is expected that experienced and competent Temporary Works Co-ordinators will attend this course. Competence comes from a mixture of education, training and experience and should be judged by an appropriate senior individual, usually referred to as the Designated Individual (DI). Training is considered an essential element of Temporary Works Co-ordinator competence. Background Publications: This course, including its group work and exercises, is constructed around BS5975:2008 +A1:2011. For Open Courses Delegates should bring a copy with them in order not to be significantly disadvantaged. For in house courses it is expected that the Tutor will tailor the course around the organisation procedures,providing they are comprehensive and follow the philosophy of BS5975. In these cases delegates will need a copy of their own procedures. In the absence of adequate procedures delegates will need a copy of the BS itself.Although the following is not mandatory, delegates may find the following useful– BS EN12811-1:20031 Temporary works equipment. Scaffolds. Performance requirements and general design– BS EN12812:2008. Falsework ‐ performance requirements and general design– BS EN12813:2004. Temporary works equipment. Load bearing towers of prefabricated components. Particular methods of structural design– NASC TG20/13 plus supplement 1– NASC TG9:12

IOSH Managing Safely incorporating Workshop H&S Essentials

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - Introduction to Transact-SQL Work with schemas Explore the structure of SQL statements Examine the SELECT statement Work with data types Handle NULLs 2 - Sort and filter results in T-SQL Sort your results Limit the sorted results Page results Remove duplicates Filter data with predicates 3 - Combine multiple tables with JOINs in T-SQL Understand joins concepts and syntax Use inner joins Use outer joins Use cross joins Use self joins 4 - Write Subqueries in T-SQL Understand subqueries Use scalar or multi-valued subqueries Use self-contained or correlated subqueries 5 - Use built-in functions and GROUP BY in Transact-SQL Categorize built-in functions Use scalar functions Use ranking and rowset functions Use aggregate functions Summarize data with GROUP BY Filter groups with HAVING 6 - Modify data with T-SQL Insert data Generate automatic values Update data Delete data Merge data based on multiple tables Additional course details: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

This 18 weeks Virtual Airline Cabin Crew course delivered via Zoom. Lessons scheduled for once a week, evenings from 6:30pm to 9pm. 98% Employment rate after completion of the course. Virtual Airline Cabin Crew which is also known as Air Hostess, Flight Attendant and Stewardess course – Join your lesson from wherever you are.  This intensive 18 weeks Virtual Airline Cabin Crew course designed for candidates who wish to: Travel the world and be paid for it Work in a friendly, collaborative atmosphere, 5000 metres above the sea level Build a global network This glamourous and exciting job requires lots of training and energy. Behind the beautiful smile of each flight attendant, stands a highly trained and skilled person who can deal with unforeseen situations on board.  98% Employment rate after completion of the course. How will you learn? Apart of our traditional class-based tuition, we also offer Virtual Learning courses. On our Virtual (live stream via Zoom) lessons, we provide the same quality of tuition as in the classroom. You only need a laptop, PC or tablet with either built in (or external) camera and microphone. The virtual platform is very interactive with a sense of real classroom at the Academy. You will study from the comfort of your own home and communicate with your tutor and classmates via video chat (by using your phone or computer camera) and you will receive outstanding tuition, qualification, and certification. We provide A-Z guidance starting from before and after the course. Your tutor will guide you through the online course to graduation which you will be welcome to attend. What a joy it would be to meet your tutor and classmates in real life!! You will have: According to the timetable- 1 lesson per week for 18 consecutive weeks. Exams and final exam based on which the certificate will be issued. On successful completion you will hold: Airline Cabin Crew certificate in Current Airline Training Standards and Equipment. Individual support on the journey from the course to a job placement Receive constant updates on recruitment and news from Aviation the world We will enhance your CV Full support on your job application process Gain an insight into the airline selection process and final one-to-one interview What is Flight Attendant? Flight attendant/Airline Cabin Crew/Stewardess/Air Hostess are the most visible, glamorous jobs of all airline employees. A Flight Attendant is someone whose primary duty is to ensure the safety and comfort of passengers during a flight. They are members of an aircrew team , who operate a commercial, business or even military aircraft while travelling domestically or internationally.  Flight Attendant benefits: Getting paid for travelling the world Lifestyle Flexible Work Schedules Meeting Interesting People Free Food & Accommodation Excellent Compensation The uniforms Working Environment How to become successful Flight Attendant job candidate?Our Aviation Team understands each candidate who wish to become Airline Cabin Crew or start a career in Aviation. Airline companies look for individuals who share their values and can act as ambassadors for the company’s brand. Cabin Crew are the face of the airline company which means they deliver a fantastic service that makes airline world famous. Airline companies prefer candidates with knowledge of Cabin Crew role. Airline companies have selection day or online tests as a first stage of recruitment, after which, they will take a closer look at applicants CV, skills and experience. If you completed Airline Cabin Crew course, your application will stand out and you can get an offer from the first round.  Student – Cabin Crew Flying Support Group As a market leading Airline Cabin Crew Training Company with a wealth of experience in Aviation and recruitment, we constantly upgrading our course and going extra nautical mile to guide and support all our students to ensure they can reach their goals. Graduates who are already flying, offer their full support to us and new students. They share an insight of the airline they already fly with, and help new students through the process of joining them at that airline. It gives a flying start to a career to new learners.  Why London Waterloo Academy? Top Airline Cabin Crew course provider in London 98% Employment rate after completion of the course With years of experience in Airline Cabin Crew industry, London Waterloo Academy has been recognised by major TV, radio channels who have invited our Aviation Team for expert advice or interview. We are recognised by major airline companies in Europe and overseas who have approached London Waterloo Academy to deliver internal cabin crew training, corporate training and to recruit our graduates as a result of their high qualification standards and knowledge. Our graduates are now flying with Etihad, Saudi Air, Hainan Airlines, Small Planet, British Airways, Qatar, EasyJet, Thomas Cook, Ryanair, Cubana de Aviación, Air France,Titan, Norwegian B737 Short Haul and many more. The vast global experience of our instructors This course has been developed in accordance with EASA PART-CC Working together – Starting a new career isn’t easy and often it can seem like a lonely and impossible process. Our Aviation Department stays behind each learner, supporting every step of the way, we give you all the tools, skills and assistance you need to succeed. Our success, built on the success of our students and a long list of graduates with successful stories. Course Entry Requirements: English Language at B2 (CEFR) level or above. There are no other special requirements for this Airline Cabin Crew course. We will teach you from scratch and support after the course when applying for the job. This course has been developed for all candidates, independent of their background, wishing to start a new career.  Dates (choose one for your course): 14 March 2024 – 11 July 2024, Thursday classes 10 June 2024 – 7 October 2024, Monday classes 17 September 2024 – 14 January 2025, Tuesday classes 18 November 2024 – 17 March 2025, Monday classes Course duration – 18 weeks Classes – once a week Lesson Time – 6:30pm to 9pm – GMT (London time) Course fee – £529 (we offer flexible payment plan and accept weekly instalments) Registration fee – £300 (includes: examination, Airline Cabin Crew certificate in Current Airline Training Standards and Equipment)

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 2 Award In Activity First Aid (RQF) Two-day course Especially suited to those working in sports or outdoor activities Have the skills to save lives and help injured heal faster 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 Eye Injuries Angina Heart Attack Stroke Asthma Diabetes Anaphylaxis Head Injuries Spinal Injuries Chest Injuries Fractures Sprains, Strains and Dislocations Poisoning Treatment for hot and cold temperatures Benefits of this course: Both Outdoor and Indoor Sports activities run a great risk of injury Would you know what to do if someone in your charge got injured or taken ill? The QA Level 2 Award in Activity First Aid (RQF) is a regulated and nationally recognised qualification designed for those who have a responsibility to provide first aid in outdoor and activity based environments As with all our courses, this course is run in a fun and engaging, interactive and hands-on way Accredited, Ofqual regulated qualification: Our Activity First Aid course leads to a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Activity First Aid fulfils the legal requirements and is a very good way to make sure you and your employees are trained in First Aid, having the ability to save lives and speed healing should the situation occur.The Ofqual Register number for this course is 603/2652/9

QA Level 3 Award In First Aid At Work (RQF) Three-day course Gives learners the knowledge and skills to be a first aider Recommended by HSE for high 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 Eye Injuries Angina Heart Attack Stroke Asthma Diabetes Anaphylaxis Head Injuries Spinal Injuries Chest Injuries Fractures Sprains, Strains and Dislocations Poisoning 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 First Aid at Work (RQF) - FAW - training course is the one recommended for first aiders in a high 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 First Aid at Work (FAW) course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your 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, having the ability to save lives should the situation occur.The Ofqual Register number for this course is 603/2384/X

QA Level 3 Award In First Aid At Work (RQF) Requalification Course Two-day course Requalify for First Aid at Work in just two days, instead of three Continue to remain a first aider in the workplace 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 Eye Injuries Angina Heart Attack Stroke Asthma Diabetes Anaphylaxis Head Injuries Spinal Injuries Chest Injuries Fractures Sprains, Strains and Dislocations Poisoning Benefits of this course: Do you already hold a valid First Aid at Work (FAW) Certificate? Is it about to run out? 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) This course leads to a new QA Level 3 Award in First Aid at Work (RQF) certificate and is the one recommended for first aiders in a higher risk workplace 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 First Aid at Work Requalifying course leads to a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your First Aid at Work Certificate fulfils the legal requirements and is a very good way to make sure you and your employees are trained in First Aid, having the ability to save lives should the situation occur.The Ofqual Register number for this course is 603/2384/X

The Emergency Fist Aid at Work is an accredited 1 day, instructor led course in a fully equipped training room. We use a mixture of training methods such as hands on activities, role play, group discussion, games and the use of equipment / technology to cover the different learning styles of the individual. All learners will have the skills and knowledge to provide the organisation with Emergency First Aider’s that can provide treatment to their casualties in a prompt, safe and effective manner. A range of subjects are covered including:- • Responsibilities and reporting • Resuscitation and AED awareness • Burns • Assessment of the situation • Anatomy • Choking • Dealing with an unresponsive casualty • Minor injuries • Epilepsy • Basic hygiene in First Aid • Bleeding control • Shock Certification Practical assessment is ongoing by the instructor, and a three year qualification will be issued to those who satisfy the criteria. In addition, the HSE strongly recommend that all students undergo an annual refresher programme of three hours. Instructions Please can learners ensure they wear trousers and a full shoe. Learners need to be physically fit and well to undertake the activities for First Aid Training, which requires learners to carryout CPR on the floor. Directions Complete Training Somerset House, Sandal Castle Centre Asdale Road Wakefield WF2 7JE All training is carried out at our office (Somerset House, map is attached). Please note that we do not provide lunch so you will have to bring your own. Please do not park in the office car park as not all spaces belong to us. There is available parking in Asda and Aldi next door, or the public car park at either side of Square Pizza Amenities Rest Room Fridge on site Parking Toilets

The four colour energies will give you the insights to transform your teams ability to influence customers and tailor their approach to different customers preferences. By building deep rapport and creating trust your customers will strengthen their bond with your organisation. Watch as your sales and profits exceed your expectations.