17101 Other courses in Banstead delivered Online

QA Level 2 Award In Health And Safety In The Workplace (RQF) Health and Safety Training Courses QA Level 2 Award In Health And Safety In The Workplace (RQF) Course Contents: Roles and responsibilities of employers and employees Health and safety laws Risk assessments and risk control hierarchy Identifying and controlling risks from common workplace hazards, including: Slips, Trips and Falls Manual Handling Fire Working from Height Electricity Hazardous Substances Workplace conditions Ergonomics Equipment Noise and vibration Transport and vehicles Violence Smoking, alcohol and drugs Stress Procedures for responding to accidents and incidents Recording incidents, accidents and ill health Benefits of this course: In 2023/24, 1.7 million people suffered from a work-related illness 600,000 sustained a non-fatal injury 138 People lost their lives 776,000 Workers suffered from work-related stress, depression or anxiety The estimated cost of injuries and ill health last year was £21.6 billion 33.7 million working days, or 140,417 working years, were lost due to work-related illnesses and injuries It is an employer's duty to protect the health, safety and welfare of their employees and other people who might be affected by their business. This includes providing sufficient information, instruction and training of employees, so they can work in a way that does not put themselves or others at risk This QA Level 2 Award in Health and Safety in the Workplace (RQF) course helps employees gain an understanding of health and safety issues and their own role within that Accredited, Ofqual regulated qualification: This Health and Safety Training Course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards. This means that you can be rest assured that your Health and Safety Certificate fulfils the legal requirements and is an excellent way to make sure you and your employees are trained in Health and Safety. The Ofqual Register number for this course is 603/2687/6

CPD Accredited, Interactive Short Course 1½ hr session Would you know how to save someone's life if they were to go into anaphylactic shock? Learn how to do so from the comfort of your own home or workplace Course Contents: What is anaphylaxis The causes of anaphylaxis The immune system How to recognise someone in anaphylactic shock How to treat someone in anaphylactic shock Benefits of this Short Course: Allergy is the most common chronic disease in Europe The UK has some of the highest prevalence rates of allergic conditions in the world, with over 20% of the population affected by one or more allergic disorder A staggering 44% of British adults now suffer from at least one allergy and the number of sufferers is on the rise Up to 20% of patients with allergies struggle daily with the fear of a possible asthma attack, anaphylactic shock, or even death from an allergic reaction Almost a third of allergy sufferers have had to chance their lifestyles to reduce their allergic reactions In 2014, 19.2% of emergency admissions were for anaphylactic reactions and 19.2% were for ‘Other’ allergic reactions With the knowledge you'll pick up from this course, you could potentially save someone's life! Your browser does not support HTML5 video.

Overview Corporate sales as word define mainly happens to take place during Business to Business sales process where a company sells their product and services to other businesses. It is a very complex sales and understanding and creating a strategic plan is really important during the process. Today corporate industries are working and planning new strategies, running many campaigns to promote business and use enhance marketing and sales plan to achieve their goals. In this competitive era, it has become a major necessity now. Attaining the desired skills, it requires continual development and training. Today every corporate sector wants to increase the business and losing big or even small deals is more than just a disappointment. It gives an edge to the competitors over their competitors.  This course is specially designed to understand the depth of corporate sales and how to create appropriate strategies in the niche market. It will help attain the skills required for continual development to cope with the changing trends. This Course Corporate Sales will reduce the risk of losing and will increase success with key sales opportunities.  This corporate sales programme will feed you with a trustable approach that reduces risks without fading chances of individual flair or innovation

Oracle SQL training course description The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create SQL statements to query database tables. Use standard aggregate functions and related SELECT statement clauses. Join Tables. Use basic subqueries and the set operators. Use numeric, character and date functions. Use conversion and other miscellaneous functions. Use SQL parameters. Use complex subqueries. Create and alter tables and views. Insert, update and delete rows in database tables. Manage sequences and synonyms. Oracle SQL training course details Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. Prerequisites: None. Duration 3 days Oracle SQL training course contents Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material. Overview After completing this course, you will be able to: Describe key database concepts in the context of SQL Server Describe database languages used in SQL Server Describe data modelling techniques Describe normalization and denormalization techniques Describe relationship types and effects in database design Describe the effects of database design on performance Describe commonly used database objects This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance. This material updates and replaces course Microsoft course 10985 which was previously published under the same title. Module 1: Introduction to databases Introduction to Relational Databases Other Databases and Storage Data Analysis SQL Server Database Languages Module 2: Data Modeling Data Modelling Designing a Database Relationship Modeling Module 3: Normalization Fundamentals of Normalization Normal Form Denormalization Module 4: Relationships Introduction to Relationships Planning Referential Integrity Module 5: Performance Indexing Query Performance Concurrency Module 6: Database Objects Tables Views Stored Procedures, Triggers and Functions

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

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

BGP training course description A detailed study of BGP, from the basics of how it works through to advanced issues such as route reflectors, policy, filtering, route selection and routing registries. The course culminates with a study of an industrial strength BGP template illustrating important issues such as bogon filtering. Practical hands on with routers follow the major sessions to reinforce the theory. A multiple choice exam, leading to the LAIT III certification, is available after the course. The exam consists of 60 questions and lasts 2 hours. What will you learn Connect enterprises to the Internet, and ISPs to each other. Describe how BGP works. List, describe and configure the main BGP attributes. Implement and troubleshoot BGP. Work with route aggregation and calculate CIDR prefixes in seconds. Influence traffic paths with BGP. BGP training course details Who will benefit: Anyone who will be working with BGP. Prerequisites: TCP/IP Foundation for engineers Definitive IP routing for engineers. Duration 5 days BGP training course contents Basic BGP IGPs, EGPs, What's BGP? BGP RIB, in/out process, tables peers, adding routes. Hands on Simple configuration and troubleshooting. The Internet and peering ASs, AS numbers, Internet structure, ISP types, ISP network design, IXs, peering vs. transit, public/ private peering, bi/multi-lateral peering. Hands on AS information gathering. How BGP works Incremental updates, Path vector protocols, BGP protocol stack, the BGP header, message types, NLRI, withdrawn routes, route refresh, route dampening. Hands on More troubleshooting, packet analysis. MBGP and IPv6 Multiprotocol routing, AFI, SAFI, MBGP and multicasts, IPv6, MPLS VPNs. Hands on IPv6 BGPv4 aggregation CIDR, benefits, techniques, shortcuts, configuring BGP aggregation, leaking routes. Hands on Reducing routing table size. BGP path selection BGP attributes, attribute types, route selection order, Local preference, AS prepend, MEDs. Hands on Influencing traffic with BGP. BGP routing policies What is policy? Examples, route filtering, AS filtering, REs, applying preference selectively, peer groups. Hands on Sophisticated policies. RIPE and routing registries RIRs, Allocations, assignments, PI vs. PA. Objects, RPSL, routing registry, Hands on The RIPE database. Automating BGP configuration Automation tools, whois, IRRToolSet, Bogon lists, tracking bogon lists, HTTP, Peering, routing registries, DNS. Communities What is a community? Community names, communities for: peer types and geography. RFC 1998, default communities. Hands on Setting local preference on other routers. Route servers What are route servers? LINX route servers, route server policy control, What are route collectors, Looking glasses. Hands on Setting up and working with a route server. Peer relationships IBGP, EBGP, next hop self, advertising routes into/out of BGP, synchronisation. Hands on IBGP, troubleshooting a large BGP network. Route reflectors and confederations Full mesh IBGP, Route reflectors, RR configuration and design, confederations, migration issues. Hands on RR configuration. BGP architectures Stub vs. transit AS, when to use BGP, multihoming strategies and issues, default routes. Multihop EBGP, load balancing. Hands on Multihoming. BGP security RFC 7454, security steps, BGP TTL security, filters, RPKI, ROAs, rsync, rrdp, validators. A secure BGP template. Hands on RPKI prefix validation.

About this Training Course The LNG market is developing from a fully based market on long-term contracts, to a more flexible market based on a portfolio of contracts of different durations. The increase of LNG demand, fuelled by South Korea, Japan and several other emerging economies, are creating a base for a more flexible market, where the LNG spot market will be playing a key role. Changes in the LNG market can be identified in the following areas: development of terminals and plant sizes, increased integration throughout the supply chain, diversification of supply sources, increased contractual flexibility and increased geographical distance. This is creating the foundation for the development of the LNG spot market right here in Asia today. This 3 full-day intensive intermediate level course will give you cutting-edge knowledge needed in today's complex LNG market. Increase your knowledge and understanding of the LNG market and spot trading aspects by attending this course. Training Objectives By the end of this course, participants will be able to: Leverage on the current and global drivers of the world Natural gas and LNG markets Understand regional LNG pricing effects and who the key buyers and new sellers are Appreciate the trading structures of LNG and how to structure its risk management Understand the workings and future outlook of the Asian LNG Spot market Discover and exploit the arbitrage trading opportunities between the different markets Learn what LNG derivatives are and how it will become available for hedging and proprietary trading purposes Target Audience This course will benefit: LNG market development executives are drawn from both technical and non-technical (commercial, finance and legal) backgrounds. Participants in an LNG market development team, perhaps with expertise in one area of gas development, will benefit from the course by obtaining a good grounding of all other areas. The course is pitched at an intermediate level, although those with a basic knowledge will be able to grasp most of the concepts covered. Course Level Intermediate Trainer Your course leader is a skilled and accomplished professional with over 25 years of extensive C-level experience in the energy markets worldwide. He has strong expertise in all the aspects of (energy) commodity markets, international sales, marketing of services, derivatives trading, staff training and risk management within dynamic and high-pressure environments. He received a Master's degree in Law from the University of Utrecht in 1987. He started his career at the NLKKAS, the Clearing House of the Commodity Futures Exchange in Amsterdam. After working for the NLKKAS for five years, he was appointed as Member of the Management Board of the Agricultural Futures Exchange (ATA) in Amsterdam at the age of 31. While working for the Clearing House and exchange, he became an expert in all the aspects of trading and risk management of commodities. In 1997, he founded his own specialist-consulting firm that provides strategic advice about (energy) commodity markets, trading and risk management. He has advised government agencies such as the European Commission, investment banks, major utilities, and commodity trading companies and various energy exchanges and market places in Europe, CEE countries, North America and Asia. Some of the issues he has advised on are the development and implementation of a Risk Management Framework, investment strategies, trading and hedging strategies, initiation of Power Exchanges (APX) and other trading platforms, the set-up of (OTC) Clearing facilities, and feasibility and market studies like for the Oil, LNG and the Carbon Market. The latest additions are (Corporate) PPAs and Artificial Intelligence for energy firms. He has given numerous seminars, workshops and (in-house) training sessions about both the physical and financial trading and risk management of commodity and carbon products. The courses have been given to companies all over the world, in countries like Japan, Singapore, Thailand, United Kingdom, Germany, Poland, Slovenia, Czech Republic, Malaysia, China, India, Belgium and the Netherlands. He has published several articles in specialist magazines such as Commodities Now and Energy Risk and he is the co-author of a book called A Guide to Emissions Trading: Risk Management and Business Implications published by Risk Books in 2004. 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

LOOKING FOR: CHILDREN'S: PICTURE BOOK TEXTS, NON-FICTION, POETRY Lucy Brownridge is Editorial Director at Wide Eyed Editions and Frances Lincoln Children’s Books, and formerly Thames & Hudson where she helped to establish the Children’s list. She specialises in highly illustrated picture books and non-fiction (including poetry) for children. She has commissioned and edited books which have gone on to win the Carnegie Awards, The British Book Awards, the Klaus Flugge Prize, the Blue Peter Prize and have been translated into over 30 languages. She has been editor to Alan Ahlberg, Quentin Blake, Mariajo Ilustrajo, Yuval Zommer and Children’s Laureate Joseph Coelho among many others. She is the author of The Fantastical Safari and The Cat Family series, and many other books for children. She is interested in the history of illustrated children’s books and is always looking for innovative ways to use the book format. ABOUT YOU Include a covering letter, in a Word document, telling Lucy about yourself and your sources of inspiration. If you have one, include a link to your website. She is keen to read stories she hasn't seen before or see artwork with a distinctive style rather than something that fits with trends. She has particular experience with picture books and illustrated narrative non-fiction. PICTURE BOOKS Please send one or two (max) full manuscripts, in a Word document, starting with a short summary/blurb. Make the summary punchy and engaging. Remember that the best picture book stories are simple and every word should count. Do you see this book as part of a series? NON-FICTION PROPOSALS Please send a paragraph explaining your idea, a contents list, if appropriate, and a sample piece of text. (In addition to the paid sessions, Lucy is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Friday 11th July 2025