Courses in Warrington

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is any IT, facilities or data centre professional who works in and around the data centre and has the responsibility to achieve and improve efficiency and environmental sustainability, whilst maintaining the availability and manageability of the data centre. Overview After completion of the course the participant will be able to: Understand the impact of data centres on the environment Describe the various environmental/energy management standards Understand the purpose and goals of the legally binding international treaties on climate change Implement various sustainable performance metrics and how to use them in the data centre environment Manage data centre environmental sustainability using international standards Set up the measurement, monitoring and reporting of energy usage Use power efficiency indicators in a variety of data centre designs Use best practices for energy savings in the electrical infrastructure and in the mechanical (cooling) infrastructure Use best practices for energy savings for the ICT equipment and data storage Understand the importance of water management and waste management Understand the different ways to use sustainable energy in the data centre Get practical tips and innovative ideas to make a data centre more sustainable The CDESS© course is aimed at providing knowledge of the standards and guidelines related to environmental sustainability, and how to move your data centre (existing or new) to a more environmentally sustainable design and operations. Impact of Data Centres on the Environment Predictions in 2010 Current situation Outlook and commitments What is Environmental Sustainability The importance of sustainability Senior management commitment Environmental sustainability framework Sustainability policies Performance standards and metrics Information policies Transparency Awareness Service charging models Environmental Management Environmental sustainability framework (ISO 14001) Standards and guidelines ? ISO 50001 / ISO 30134 Measurement and categories Baselining Trend analysis Reporting Power Effiðciency Indicators Various eðfficiency indicators Power Usage Effectiveness (PUE) PUE measurement levels Factors affecting PUE Measurement points and intervals PUE in mixed source environments Measuring PUE in a mixed-use building PUE reporting Impact of PUE after optimising IT load Electrical Energy Savings (Electrical) Identifying the starting point for saving energy Sizing of power DC power Generators UPS systems Power Factor (PF) Energy savings on lighting Electrical Energy Savings (Mechanical) Energy savings on the cooling infrastructure Temperature and humidity setpoints Various energy eðcient cooling technologies Energy savings on the airflow Liquid cooling Energy reusage PUE, ERE/ERF and Control Volume Electrical Energy Savings (ICT) Procurement IT equipment energy eðfficiency ITEEsv, SMPE, SMPO IT equipment utilisation Server virtualisation Open compute project Electrical Energy Savings (Data Storage) Data management Data storage management Data storage equipment effiðciency Water Management Water Usage Effectiveness (WUE) Improving WUE Water usage at the power generation source Energy Water Intensity Factor (EWIF) Waste Management Waste management policies Life-cycle assessment (Cradle to the grave) 3 R?s for waste management Reduce Reuse Second-hand market Recycle Sustainable Energy Usage Sustainable energy sources Power purchase agreements Energy attribute certificates Renewable Energy Factor (REF) Matching renewable energy supply and demand Sustainable energy storage Carbon trading Automated Environmental Management Systems Use of AI and machine learning Load migration Data Centre Infrastructure Management (DCIM) solutions

At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. Course level is beginners to intermediate.

Course Information This course offers foundational guidance and practical support tailored for individuals operating within Good Manufacturing Practice (GMP) frameworks. Explore the fundamental prerequisites of a pharmaceutical quality system (PQS) and delve into the application of quality risk management (QRM) principles, aligning with current regulations and guidance. Gain insights into pivotal aspects such as requirements, roles, and responsibilities, encompassing change control, document management, and key documentation essential for effective implementation of GMP with a focus on regulatory inspections and common findings. Is this course for you? Ideal for professionals engaged in GMP across various sectors, including: Research and Development (R&D) Contract Manufacturing Organisations Manufacturing Units Quality Control (QC) Laboratories Auditing Roles. What will you learn? Event objectives - by the end of the course, delegates shall: Have an awareness of the basic requirements of GMP Be aware of UK and EU GMP Rules and Guidance and relevant publications Understand the roles and responsibilities associated with GMP Be able to contribute to and maintain quality documentation Have a basic understanding of product lifecycle and manufacturing Understand the requirements of GMP in the QC laboratory context Have a basic understanding of risk management and mitigation principles Understand the need for quality systems and quality assurance activities Be aware of common regulatory findings. Learning outcomes: delegates will be able to: Implement their role within GMP with confidence and knowledge of the principle requirements Contribute effectively to the GMP quality system and their organisation’s compliance Comprehend where their organisation’s activities sit within the larger GMP arena Know where to seek further information within the published rules and guidance, UK Legislation, European Commission Directives, ICH Guidance and other relevant publications, as well as via the internet. Tutors Tutors will be comprised of (click the photos for biographies): Louise Handy Director, Handy Consulting Ltd Programme Please note timings may be subject to alteration. Day 1 09:30 Introductions and Scope of the Course Understand the group requirements and the tutor's background and experience. 09:45 Background and Regulatory Environment Setting the scene, understanding the context, key legislation. 10:30 Principles of GMP Key points and requirements. 11:15 Break 11:30 Personnel and Responsibilities Management and staff, duties and accountabilities. 12:00 Overview of GMP Manufacturing Basics of the product life cycle. 12:30 Lunch 13:15 Risk Management Workshop Practical exploration of risk and mitigation activities. 14:30 QC Laboratories Activities and practicalities. 15:15 Break 15:30 Compliance Quality Assurance and Self Inspection. 16:15 Question Time A chance for questions on the practicalities of GMP. 16:30 Close of Course Extra Information Course Material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking. You will need a stable internet connection, a microphone and a webcam. CPD Points 7 Points   Development Level Learn

LOOKING FOR: PB, CHAPTER BOOKS, MG, GRAPHIC NOVELS, CHILDREN'S NON-FICTION Millie van Grutten joined Caroline Sheldon Literary Agency in 2021 and as of early 2024 Caroline Sheldon Literary Agency was acquired by Rogers Coleridge & White. Millie is thrilled to be building the children’s illustrated division at RCW and is actively looking for authors and illustrators of picture books, chapter books, young fiction, graphic novels and is particularly interested in children’s non-fiction presented in any guise. Millie loves working collaboratively with authors and illustrators whether it’s brainstorming a title, building a portfolio, trying out new genres and age groups or simply chatting ideas through. She relishes the opportunity to champion the work of illustrators and authors alike and is open to anything from 0-9 whether texts, illustrations or both. She loves anything with strong and engaging characters at its heart, quirky stories, and books that make you laugh and/or books that can make you laugh while you learn… Apart from the ever enduring and absolute classics like Quentin Blake’s Mrs Armitage, Millie has recently enjoyed Mariajo Ilustrajo’s Lost, Ed Vere’s The Artist, The Secret Beast Club (Robin Birch and Jobe Anderson), Dave Pigeon (Swapna Haddow and Sheena Dempsey), How to Be A Genius Kid (Jim Smith) and anything by Lauren Child. Among many other talents, Millie represents Swapna Haddow, Zehra Hicks, Sandra Dieckmann, Jobe Anderson, Marilyn Esther Chi, Emma Clarke, Jim Smith, Gabriella Szendrey, Helen and Thomas Docherty. Millie would like you to submit a covering letter, 1 page synopsis and the opening three chapters (max 5,000 words) of your novel. For picture books please send up to three texts split into 12 spreads each and a covering letter. For non-fiction please supply a cover letter and proposal with up to 5,000 words of your sample text. Please send EITHER picture books OR another genre, not both in one submission. (In addition to the paid sessions, Millie 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).  Submission Deadline: Wednesday 20 November 2024

The theory assessment provides delegates with the essential knowledge to select, monitor, manage and plan the correct use of Harnesses and lanyards for use in a MEWP. Delegates successfully completing the e-learning will: Have an awareness of how to correctly identify and select the appropriate form of personal protection against falls from MEWPs. Have a theoretical awareness only of how to check, use, maintain and store a harness and lanyard with manufacturer’s instructions. Have a theoretical awareness of how harnesses and lanyards should be fitted and adjusted.

THIS COURSE PACKAGE INCLUDES: 1: INTRODUCTION TO PHLEBOTOMY COURSE (GPT003) - Level 3 (Ireland Level 5) 2: ADVANCED PHLEBOTOMY COURSE (GPT005) - Level 4 (Ireland Level 6) 3: GEOPACE COMPETENCY CERTIFICATE - CPD Certified (optional with Virtual Classroom) Learn how to take blood ... train as a Phlebotomist FAST-TRACK YOUR PHLEBOTOMY TRAINING WITH OUR COMPLETE TRAINING PACKAGE 20% off - Multi-Course Discount Cover all stages from beginner through to Level 4 Available as Classroom or Virtual Classroom Complete your beginner to advanced training in 2 days Awards 2 accredited qualifications - Introduction to Phlebotomy and Advanced Phlebotomy qualifications Both courses are dually accredited (OCN & CPD) Geopace Certificate of Competency included with classroom attendance or available as an option when booking virtual classroom Covers all steps up to live blood draw Learn advanced skills and techniques Virtual Classroom options include comprehensive Practise@Home Training Kits (yours to keep) Basic understanding of English language required OPEN TO ALL APPLICANTS

During this live-online masterclass we will focus on understanding recent developments in the mental health and wellbeing of children in the UK, including looking at the impact of cultural and technological changes over recent years and the impact this is having in schools.

The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types.

Empower Mental Health First Aiders and Champions to maintain their skills with regular Refresher training. Just like physical first aid, we recommend that you refresh your skills every two to three years. (Certificate expires after 3 years). If it's time to update your skills, book onto an MHFA Refresher course now and feel confident that you are performing your vital role safely.

Free relationships and sex education training for professionals working in North Wales. Cwmni Addysg Rhyw - Sex Education Company has been commissioned to deliver relationships and sex education (RSE) training to BCUHB staff and partner organisations in North Wales. The aim of this training is to increase confidence and skills to work more effectively with issues concerning sexual health and vulnerable young people. 'The best training I have ever attended!' 'Fun & informative' Attend the first day of the course if you simply want to update your RSE information and attend both days if you want to gain skills and confidence in delivering RSE to individuals or groups. Day one Vulnerable clients Attitudes and values in relation to practice The law and sex Key sexual health issues, including safer sex Gender identity and sexual orientation Communication and sexual health Relevant resources Day two - Additional second day/module for delivering RSE Assessing learning needs Developing purpose and learning outcomes Managing safety and boundary issues Planning, delivering and evaluating sessions Each day will run from 9.30am to 4.30pm via Teams or Zoom. For more information and/or to be added to our mailing list contact Mel Gadd mel@sexeducationcompany.org Terms & conditions: Cwmni Addysg Rhyw facilitates externally funded training to staff that work in the public, private, voluntary and independent sectors. There is significant investment of resources in terms of time, planning and budget to deliver this service and due to repeated incidents of non-attendance without notice it has now become necessary to introduce a charging policy for cancellation and non attendance. Although this course is free of charge to attend we will charge late cancellation administration fees as follows: No notification of non-attendance - £50, less than 48 hours notice of non-attendance £30, Less than 1 weeks notice of non-attendance £25. By registering on the course you agree to these charges on late cancellation or failure to attend. As we usually have a reserve list for our courses we ask you to only book on the course if you can attend the whole day. Arriving late or leaving early will be classed as non-attendance and may be charged as such. We will be delivering this training via Teams or Zoom. It is your responsibility to ensure you can use the platform before booking. If you are unable to access the training on the day because you can't access the platform this will be classed as non attendance and will be charged as such. If you want to check that you can access the training via teams/zoom before booking please contact us. We are happy to set up a quick call for you to check access.